Category: Power BI

Finish the Puzzle: Querying Power BI Semantic Models with Semantic Link!

Posted on by Annie D

Want to use notebooks to leverage data from a Power BI semantic model (dataset)? Maybe you’re a data scientist wanting to augment your models with that data, or maybe you just want to validate stuff as a Power BI developer. Semantic Link (or Sempy) can help!

Sample Notebook: https://github.com/guyinacube/demo-files/blob/master/video%20demos/Synapse/20231019%20-%20Sempy.ipynb

What is semantic link?
https://learn.microsoft.com/fabric/data-science/semantic-link-overview

Tutorial: Clean data with functional dependencies
https://learn.microsoft.com/fabric/data-science/tutorial-data-cleaning-functional-dependencies

Tutorial: Extract and calculate Power BI measures from a Jupyter notebook
https://learn.microsoft.com/fabric/data-science/tutorial-power-bi-measures

Detect, explore, and validate functional dependencies in your data
https://learn.microsoft.com/fabric/data-science/semantic-link-validate-data

fabric Package
https://learn.microsoft.com/python/api/semantic-link-sempy/sempy.fabric?view=semantic-link-python

📢 Become a member: https://guyinacu.be/membership Continue reading “Finish the Puzzle: Querying Power BI Semantic Models with Semantic Link!” →

Escape the Ordinary with a Low Code Lakehouse in Microsoft Fabric

Posted on by Annie D

A lakehouse can be intimidating especially if you don’t know Python. Patrick looks at a low-code, potentially no-code option for creating a lakehouse in Microsoft Fabric to get you going!

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools page – <a Continue reading “Escape the Ordinary with a Low Code Lakehouse in Microsoft Fabric” →

Discover the Untapped Settings in Power BI Desktop

Posted on by Annie D

There are a lot of settings within Power BI Desktop! Adam looks at a few you may not know about and should be aware of. Definitely review these!

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools page – rel=”nofollow”>https://guyinacube.com/tools/

#PowerBI #MicrosoftFabric #GuyInACube

Endless Demo Data – GPT4’s Advanced Data Extraction Capabilities

Posted on by Annie D

Join me as I take you through an incredible discovery with ChatGPT 4’s Advanced Data Analysis plugin. From generating datasets tailored to specific industries to understanding the power of this tool, we’ll uncover the potential for data analysis and science in real-time.

🔍 What to Expect:
– An introduction to ChatGPT 4 and its Advanced Data Analysis capabilities.
– Generation of specific datasets across varied industries.
– Real-time creation and download of large datasets.
– Exploration of data analysis suggestions using AI.

🔧 Tools & Tech:
Discover the speed and versatility of ChatGPT 4 in generating datasets and providing actionable insights.

🚀 Real-time Results:
See firsthand the extraction of Continue reading “Endless Demo Data – GPT4’s Advanced Data Extraction Capabilities” →

Mastering Power BI Desktop: A Deep Dive into the Pane Switcher

Posted on by Annie D

On-Object Editing has been out for a bit in Power BI Desktop, and it came with a cool pane switcher! Adam walks through how to use the pane switcher and talks about some recent updates.

Use on-object interaction with visuals in your report (preview)
https://learn.microsoft.com/power-bi/create-reports/power-bi-on-object-interaction

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— rel=”nofollow”>http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/

#PowerBI #GuyInACube

Using ChatGPT To Supercharge Power BI Development

Posted on by Annie D

Leverage the power of ChatGPT to enhance your Power BI development process.

Details of what you will learn in this event series:

– Understand the potential of ChatGPT in enhancing Power BI development
– Learn how to integrate ChatGPT into your Power BI workflow
– Discover real-life examples of how ChatGPT can automate and streamline data analysis tasks
– Gain insights into best practices and tips for effective usage

How AI Is Changing Everything For Data Professionals

Posted on by Annie D

An outline of this event:

AI has emerged as a game-changer, transforming the way organizations analyze, interpret, and leverage data to drive insights, make informed decisions, and gain a competitive edge. Join us as we delve into the various aspects of AI and its profound implications for data professionals.

Whether you’re a data scientist, data analyst, or data engineer, this webinar will provide valuable insights and practical examples of how AI is changing the landscape for data professionals.

Details of what you will learn in this event:
– Highlighting the benefits and challenges of AI adoption in data-related work
– Understanding the role of AI Continue reading “How AI Is Changing Everything For Data Professionals” →

Using WORKOUTS to Master Data Skills

Posted on by Annie D

An outline of this event:

In the rapidly evolving field of data analytics, it is crucial for professionals to continuously upgrade their data skills to stay relevant and competitive. WORKOUTS is an innovative approach that combines hands-on exercises, practical applications, and collaborative learning to help data practitioners master data skills effectively.

In this virtual event, participants will engage in interactive and immersive learning experiences through a series of WORKOUTS sessions designed to enhance their data skills in a practical and engaging manner. The event will cover various data-related topics, tools, and techniques, and provide participants with opportunities to apply their learning in Continue reading “Using WORKOUTS to Master Data Skills” →