Category: Power BI

Unleashing The Power Of OpenAI’s Code Interpreter For Data Analysis — This Changes Everything!

Posted on by Annie D

Dive into the world of data science with OpenAI’s Code Interpreter. This video showcases the power and potential of this innovative tool in performing advanced data analysis tasks. We’ll explore a customer service call dataset, demonstrating how Code Interpreter automates the creation of BI notebooks, performs time series analysis, predictive modeling, and more. Discover how Code Interpreter is democratizing data science, making complex analyses accessible to a wider audience. Join us on this exciting journey into the future of data analysis with OpenAI’s Code Interpreter!

Key Takeaways:

– The video introduces and explores the use of OpenAI’s Code Interpreter for advanced data Continue reading “Unleashing The Power Of OpenAI’s Code Interpreter For Data Analysis — This Changes Everything!” →

The MAGIC of Power BI in PowerPoint!

Posted on by Annie D

There were some recent updates to the storytelling experience in PowerPoint with Power BI. Patrick walks through how you can use these to make the most of PowerPoint and Power BI!

About storytelling with Power BI in PowerPoint
https://learn.microsoft.com/power-bi/collaborate-share/service-power-bi-powerpoint-add-in-about

📢 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/
— <a Continue reading “The MAGIC of Power BI in PowerPoint!” →

Leveraging OneLake Explorer – The OneDrive of Data! (Microsoft Fabric)

Posted on by Annie D

It’s been said that OneLake is the OneDrive of data in Microsoft Fabric! OneLake Explorer makes that even more so. Patrick walks you through how this works and how you can leverage it today!

OneLake File Explorer
https://learn.microsoft.com/fabric/onelake/onelake-file-explorer

📢 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/
— <a href="https://guyinacube.com" Continue reading “Leveraging OneLake Explorer – The OneDrive of Data! (Microsoft Fabric)” →

Create MEANINGFUL data labels with measures in Power BI

Posted on by Annie D

Tired of the usual text data labels that only have one value? Looking for something different? Patrick shows you how to customize your data labels using DAX in your Power BI reports!

📢 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 Continue reading “Create MEANINGFUL data labels with measures in Power BI” →

Can you use Power Query Dynamic M Parameters for multi-select?

Posted on by Annie D

Dynamic M parameters in Power Query isn’t anything new. However, Patrick was challenged with using them to allow for multi-select and “select all” with a slicer in a Power BI report. Will he succeed?

Dynamic M query parameters in Power BI Desktop
https://learn.microsoft.com/power-bi/connect-data/desktop-dynamic-m-query-parameters

📢 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
— Continue reading “Can you use Power Query Dynamic M Parameters for multi-select?” →

SQL Server in Microsoft Fabric? Use CETaS to move data!

Posted on by Annie D

People have been asking “What about SQL Server?” with regards to Microsoft Fabric. Bob Ward joins us to show a way you can get your SQL data into Fabric with CETaS and the power of shortcuts in OneLake. And, then use that data in Power BI!

CREATE EXTERNAL TABLE AS SELECT (CETAS) (Transact-SQL)
https://learn.microsoft.com/sql/t-sql/statements/create-external-table-as-select-transact-sql?view=sql-server-ver16&tabs=powershell

Microsoft SQL, Data Virtualization and Microsoft Fabric (Slides)
https://aka.ms/sqlfabricdemo

Bob Ward:
https://twitter.com/bobwardms
https://www.linkedin.com/in/bobwardms/

📢 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 Continue reading “SQL Server in Microsoft Fabric? Use CETaS to move data!” →

🔴 Microsoft Fabric/Power BI Q&A – LIVE (June 24, 2023) (Member Chat 2nd Half)

Posted on by Annie D

Join us live as we answer your questions about Microsoft Fabric (including Power BI)!

💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public can watch & Super Chat for Questions)

📢 RULES FOR Q&A: 📢

👉 Put a “Q:” in front of your comment to help us identify questions!
👉 Super chats take priority
👉 Do NOT re-post your questions! We’ll get to as many questions as we can.
👉 If you SPAM your question, you will be put in timeout

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

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

Want to take your Power BI skills to the next level? We have training courses available Continue reading “🔴 Microsoft Fabric/Power BI Q&A – LIVE (June 24, 2023) (Member Chat 2nd Half)” →

Digging into DYNAMIC format strings for DAX Measures in Power BI

Posted on by Annie D

DYNAMIC format strings recently were made available for DAX Measures in Power BI Desktop! Zoe walks us through how you can use these to enhance your reports!

Create dynamic format strings for measures
https://learn.microsoft.com/power-bi/create-reports/desktop-dynamic-format-strings

Zoe Douglas
https://www.linkedin.com/in/zoedouglas-data/
https://twitter.com/DataZoePowerBI

📢 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
— rel=”nofollow”>https://www.instagram.com/guyinacube/
— https://guyinacube.com

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

#PowerBI #MicrosoftFabric #GuyInACube

Supercharge Your Power BI Workflow: A Guide to Using ChatGPT

Posted on by Annie D

Join Sam in this enlightening video as he shares his personal journey with OpenAI’s ChatGPT, a revolutionary language model that’s transforming the way we work with Power BI. Discover how the AI is assisting him at every step of his Power BI development journey, from understanding the Power BI interface to handling complex DAX formulas.

In this video, Sam explains how ChatGPT enhances his work by aiding in tasks such as understanding the query editor, aiding with formulas, brainstorming visualization ideas, and even evaluating data. He delves into practical examples, showcasing the immense possibilities that this AI opens up for your Continue reading “Supercharge Your Power BI Workflow: A Guide to Using ChatGPT” →

Get the most as a Data Scientist with Microsoft Fabric (Public Preview)

Posted on by Annie D

Going down the DATA SCIENCE path can be hard when trying to get all the right data. Microsoft Fabric breaks down barriers and allows for easy reuse of data with OneLake. Nellie joins to talk about how data scientists can take advantage!

What is Data Science in Microsoft Fabric?
https://learn.microsoft.com/fabric/data-science/data-science-overview

Develop, execute, and manage Microsoft Fabric notebooks
https://learn.microsoft.com/fabric/data-engineering/author-execute-notebook?toc=%2Ffabric%2Fdata-science%2Ftoc.json&bc=%2Ffabric%2Fdata-science%2Fbreadcrumb%2Ftoc.json

How to accelerate data prep with Data Wrangler in Microsoft Fabric
https://learn.microsoft.com/fabric/data-science/data-wrangler

Nellie Gustafsson
https://twitter.com/nelliegson
https://www.linkedin.com/in/nelliegustafsson/

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

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

Want to take your Power BI skills to the next level? We have Continue reading “Get the most as a Data Scientist with Microsoft Fabric (Public Preview)” →

Your data is in the Lakehouse, but now what? | Microsoft Fabric (Public Preview)

Posted on by Annie D

You’ve got your data into OneLake and a Lakehouse, but now what? What can you do with that data after you’ve landed it in Microsoft Fabric? Justyna walks us through different areas where you can leverage your data throughout fabric. From data warehouses to even Power BI!

What is Data engineering in Microsoft Fabric?
https://learn.microsoft.com/fabric/data-engineering/data-engineering-overview

What is Spark compute in Microsoft Fabric?
https://learn.microsoft.com/fabric/data-engineering/spark-compute

Develop, execute, and manage Microsoft Fabric notebooks
https://learn.microsoft.com/fabric/data-engineering/author-execute-notebook

OneLake shortcuts
https://learn.microsoft.com/fabric/onelake/onelake-shortcuts

Justyna Lucznik
https://twitter.com/JustynaLucznik
https://www.linkedin.com/in/justyna-lucznik/

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

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

Want to take your Power BI skills to Continue reading “Your data is in the Lakehouse, but now what? | Microsoft Fabric (Public Preview)” →

🔴 Microsoft Fabric/Power BI Q&A – LIVE (June 17, 2023) (Member Chat 2nd Half)

Posted on by Annie D

Join us live as we answer your questions about Microsoft Fabric (including Power BI)!

💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public can watch & Super Chat for Questions)

📢 RULES FOR Q&A: 📢

👉 Put a “Q:” in front of your comment to help us identify questions!
👉 Super chats take priority
👉 Do NOT re-post your questions! We’ll get to as many questions as we can.
👉 If you SPAM your question, you will be put in timeout

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

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

Want to take your Power BI skills to the next level? We have training courses available Continue reading “🔴 Microsoft Fabric/Power BI Q&A – LIVE (June 17, 2023) (Member Chat 2nd Half)” →