Discover the depths of Advanced Data Analysis (ADA) by OpenAI. Dive into a structured learning experience that fuses cutting-edge research with hands-on exercises to provide a comprehensive understanding of Advanced Data Analysis.
Category: Power BI

Editing your Direct Lake Datasets from Tabular Editor? Yes please!
Wanting to edit your Direct Lake Power BI Dataset in Microsoft Fabric? Now writing via the XMLA endpoint is supported. Patrick shows you how to use tools to modify.
Announcing XMLA Write support for Direct Lake datasets
https://blog.fabric.microsoft.com/en-us/blog/announcing-xmla-write-support-for-direct-lake-datasets?ft=All
Dataset connectivity with the XMLA endpoint
https://learn.microsoft.com/power-bi/enterprise/service-premium-connect-tools
📢 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
— <a href="http://www.facebook.com/guyinacube" Continue reading “Editing your Direct Lake Datasets from Tabular Editor? Yes please!”

Using Microsoft Fabric Workspaces (Power BI and more!)
Workspaces are a way to organize and manage content within Microsoft Fabric. This includes Power BI content. Adam walks you through what Workspaces are all about and different options available.
Workspaces
https://learn.microsoft.com/fabric/get-started/workspaces
Roles in workspaces in Microsoft Fabric
https://learn.microsoft.com/fabric/get-started/roles-workspaces
Workspaces in Power BI
https://learn.microsoft.com/power-bi/collaborate-share/service-new-workspaces
📢 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
— <a href="http://www.facebook.com/guyinacube" Continue reading “Using Microsoft Fabric Workspaces (Power BI and more!)”

Deep Dive Into A Telco Company Dataset – Using Advanced Data Analysis (ADA) from Open AI
Join me as I dive into the powerful capabilities of Advanced Data Analysis (ADA), formerly Code Interpreter, a cutting-edge tool designed for advanced data analytics. Whether you’re a seasoned data professional or just dipping your toes into the world of statistics and algorithms, Ada is here to redefine the game.
🔍 What to Expect:
– The transformative power of ADA’s automated suggestions.
– Bridging the gap between ADA and tools like Power BI.
– Anomaly detection, even for the untrained eye.
– The rising significance of Python and why understanding its structure is more important than ever.
– The depth of analysis ADA offers and how Continue reading “Deep Dive Into A Telco Company Dataset – Using Advanced Data Analysis (ADA) from Open AI”

My AI and Data Analytics Inflection Point Explained! #codeinterpreter #machinelearning
Diving deep into AI’s transformative power, I share unexpected insights from my personal exploration. Join me as I unveil the revelations from my AI journey!

Modern Analytics Freestyle
Join us for an enlightening virtual event that delves into the transformative power of modern data analysis. Discover how today’s data analysts, equipped with the latest AI tools, can significantly enhance and streamline your workflow. As we collaboratively navigate a real-world data challenge, we’ll unveil a plethora of innovative data analysis techniques that promise to redefine the boundaries of what you believed was possible. Elevate your analytical prowess and extend your capabilities beyond what you thought achievable just a year ago. Don’t miss this opportunity to be at the forefront of the data revolution!
This event will take place on Enterprise Continue reading “Modern Analytics Freestyle”

No more Report Builder for Power BI Paginated Reports???
Not a fan of Power BI Report Builder? Still want to use Paginated reports? Patrick shows the new Paginated authoring experience within the service! It’s BANANAS!
Low code authoring of paginated reports
https://powerbi.microsoft.com/blog/low-code-authoring-of-paginated-reports/
Create paginated reports that you can export in the Power BI service
https://learn.microsoft.com/power-bi/paginated-reports/web-authoring/paginated-formatted-table
📢 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
— <a Continue reading “No more Report Builder for Power BI Paginated Reports???”

Landing data with Dataflows Gen2 in Microsoft Fabric
Pipelines are cool in Microsoft Fabric, but how could we use Dataflows to get data into our Data Warehouse? Patrick shows another way to move your data with just a few clicks!
📢 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 Continue reading “Landing data with Dataflows Gen2 in Microsoft Fabric”

Creating your first Data Warehouse in Microsoft Fabric
It’s time to show the Data Warehouse within Microsoft Fabric some love! Patrick walks you through how you can get started with your first Data Warehouse using Data Pipelines.
What is data warehousing in Microsoft Fabric?
https://learn.microsoft.com/fabric/data-warehouse/data-warehousing
Microsoft Fabric decision guide: data warehouse or lakehouse
https://learn.microsoft.com/fabric/get-started/decision-guide-warehouse-lakehouse?toc=%2Ffabric%2Fdata-warehouse%2Ftoc.json&bc=%2Ffabric%2Fdata-warehouse%2Ftoc.json
Data warehouse tutorial introduction
https://learn.microsoft.com/fabric/data-warehouse/tutorial-introduction
Ingest data into the Warehouse
https://learn.microsoft.com/fabric/data-warehouse/ingest-data
📢 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!
*******************
— Continue reading “Creating your first Data Warehouse in Microsoft Fabric”

A quirky Bookmark scenario with Filters in Power BI. Pay Attention!
A question came up about why bookmarks weren’t working and how to solve a particular scenario regarding filters in Power BI. Adam shows how to solve this and uses a little DAX to do it!
📢 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 Continue reading “A quirky Bookmark scenario with Filters in Power BI. Pay Attention!”

The Future of Data Analytics – AI Enhanced #codeinterpreter #machinelearning #hiddeninsights
You know what I think is the future of data analytics? It’s not just Power BI with its dynamic visuals, nor is it just Excel with its unmatched ad-hoc capabilities. It’s the fusion of these with AI-driven tools like code interpreters. These AI tools guide our insights, supercharging our analysis, making everything more efficient. Imagine blending all these tools, maximizing every ounce of their potential. That’s the future I see. Dive deeper with me and let’s shape this future together!
#powerbi #excel #chatgpt #codeinterpreter

Wait! We can use Databricks data with Microsoft Fabric???
Ready to learn how you can use Databricks with Microsoft Fabric? Patrick shows you how you can integrate the data and enable the MAGIC of Fabric while leveraging your existing Databricks implementation.
Using Azure Databricks with Microsoft Fabric and OneLake
https://blog.fabric.microsoft.com/en-us/blog/using-azure-databricks-with-microsoft-fabric-and-onelake
📢 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/
#MicrosoftFabric #Databricks #GuyInACube