Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

From Decomposition Tree to Details in Power BI!!!

The Decomposition Tree is an amazing visual but how can we get to the details. Where’s my drill through? Patrick walks you through how you can set this up in Power BI Desktop!

Create and view decomposition tree visuals in Power BI
https://docs.microsoft.com/power-bi/visuals/power-bi-visualization-decomposition-tree

Set up drillthrough in Power BI reports
https://docs.microsoft.com/power-bi/create-reports/desktop-drillthrough

Wyn Hopkins
https://twitter.com/wynhopkins

📢 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
Continue reading “From Decomposition Tree to Details in Power BI!!!”


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

How To Visualize A Variable’s Distribution Alternatives With Seaborn

When working with a data set that comprises of multiple variables, it’s best to be able to make sense how these differ and interact with each other. In this tutorial, George is going to demonstrate how you can use the Seaborn function in Python to visualize alternatives of a variable’s distribution.

***** Video Details *****
00:00 Introduction
00:30 Data set
01:19 Histogram
03:46 Boxplot
05:12 Violinplot
06:20 Swarmplot
07:17 Stripplot

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – <a Continue reading “How To Visualize A Variable’s Distribution Alternatives With Seaborn”


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Modern Data Lakehouse? Where do you even start??? Azure Synapse of course!

Trying to get started with a Modern Data Lakehouse? There are so many options today. Where do you even begin? Patrick and Stijn help you get a handle on it with Azure Synapse Analytics!

Stijn Wynants
https://twitter.com/SQLStijn

Building a Modern Lakehouse Data Warehouse with Azure Synapse Analytics: Moving your Database to the lake
https://sql-stijn.com/2022/06/14/building-a-modern-lakehouse-data-warehouse-with-azure-synapse-analytics-moving-your-database-to-the-lake/

Pipelines and activities in Azure Data Factory and Azure Synapse Analytics
https://docs.microsoft.com/azure/data-factory/concepts-pipelines-activities

Integrate with pipelines
https://docs.microsoft.com/azure/synapse-analytics/get-started-pipelines

📢 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 Continue reading “Modern Data Lakehouse? Where do you even start??? Azure Synapse of course!”


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

How To Create Dynamic Temporal Scale In Power BI Pt.2

Every so often we’ll be needing the availability of a custom visual of a bar chart or line chart that gives an option to plot the chart either weekly, monthly, quarterly, or yearly. In this video, Greg is going to demonstrate how you can create dynamic temporal scale using a disconnected table in Power BI that can let you change the level of granularity depending on your date or time basis.

***** Video Details *****
00:00 Introduction
00:47 What is a dynamic temporal scale
00:50 Overview of Part 1
02:09 R10a_Table
05:23 The measure

***** Related Links *****
How To Create Dynamic Temporal Scale In Power BI Pt.1 – Continue reading “How To Create Dynamic Temporal Scale In Power BI Pt.2”


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Enterprise DNA Power Tools – Quick Measures Pro Pt.1

At Enterprise DNA, our goal is to help organizations turn data into insights so they can make better data-driven decisions. So we’re continuously updating our Power Tools so that you’ll have everything you need to create faster reports — all from one convenient location.

Power Tools is our suite of external tools designed by Microsoft MVP, Greg Deckler, to help you create faster reports and dashboards. In this video, Brian is going to do a deep dive into Quick Measures Pro, which is probably the most complex of the 5 available tools but is definitely well worth to learn as it’ll give Continue reading “Enterprise DNA Power Tools – Quick Measures Pro Pt.1”


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Practical Power Query Solutions – Nested Structured Values (Part 2)

RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/webinar-series-resources-free/

When is it?
June 16th – 12pm Los Angeles (PDT), 3pm New York (EDT), 8pm London (BST)
June 17th – 5am Sydney (AEST), 7am Auckland (NZST)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Melissa de Korte, Enterprise DNA Expert – Driving an analytical movement through using Power BI!

During This Free Training, You Will Learn:

• Explore structured columns containing Lists, Records or Tables
• Retrieve only certain parts from nested Lists, Records or Tables
• Deal with mixed columns or lists inside records, or Continue reading “Practical Power Query Solutions – Nested Structured Values (Part 2)”


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Publish from Power BI Desktop for External Users

Have you ever wanted to publish from Power BI Desktop to a different organization? External Users publishing!!! I show you how you can log in as an external user in Power BI Desktop and then publish. BANANAS!!!

Ross Couldrey
LinkedIn: https://www.linkedin.com/in/rosscouldrey/

Distribute Power BI content to external guest users using Azure Active Directory B2B
https://docs.microsoft.com/power-bi/guidance/whitepaper-azure-b2b-power-bi

📢 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
Continue reading “Publish from Power BI Desktop for External Users”


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Improving Data Literacy with George Mount

Businesses are increasingly recognizing the importance of data analytics in making informed decisions across all aspects of their operations. However, simply having access to data is not enough. They need to be able to extract value from it as well. They also need to have the skills and tools to analyze it effectively. How can businesses become more literate about their data in order to identify and respond to opportunities and threats strategically?

George Mount is the founder and CEO of Stringfest Analytics, a consulting firm specializing in analytics education and upskilling. He has worked with leading bootcamps, learning platforms, and Continue reading “Improving Data Literacy with George Mount”


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Practical Power Query Solutions – Nested Structured Values (Part 2)

RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/webinar-series-resources-free/

When is it?
June 16th – 12pm Los Angeles (PDT), 3pm New York (EDT), 8pm London (BST)
June 17th – 5am Sydney (AEST), 7am Auckland (NZST)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Melissa de Korte, Enterprise DNA Expert – Driving an analytical movement through using Power BI!

During This Free Training, You Will Learn:

• Explore structured columns containing Lists, Records or Tables
• Retrieve only certain parts from nested Lists, Records or Tables
• Deal with mixed columns or lists inside records, or Continue reading “Practical Power Query Solutions – Nested Structured Values (Part 2)”


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

excelisfun e-Book release: The Only App That Matters: Microsoft 365 Excel. Preview of Book!

Buy the e-Book today: https://lnkd.in/gZMZMSYD
e-book out June 15. Physical book out Aug 1.
This is a preview of Michael “excelisfun” Girvin’s new 800 page Excel and Power BI book. Two years in the making. Every topic you ever wanted in Excel, PivotTables, Array Formulas, Data Analysis, Power BI Desktop and much more.


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

What tool do you use to optimize your Power BI dataset?

Need some help optimizing your Power BI Dataset but don’t want to hand over your Power BI Desktop file? Patrick shows you some tools to get information to help with optimizing assistance! These are tools we use EVERYDAY!

DAX Studio
https://daxstudio.org/

Bravo for Power BI
https://bravo.bi/

Tabular Editor 3
https://tabulareditor.com/

📢 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
Continue reading “What tool do you use to optimize your Power BI dataset?”


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

How To Create Chatbots With Power Virtual Agents

Power Virtual Agents enables you to respond to your customers of even within your organization using intelligent sophisticated, AI-powered, conversational bots. For today’s video, Henry is going to demonstrate the exciting new evolution of the Power Virtual Agents.

***** Video Details *****
00:00 Introduction
00:28 What is Power Virtual Agents?
01:06 Creating a chatbot
02:12 Creating topics
03:45 Sample workflow
06:38 Suggest topics

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://www.enterprisedna.co/power-bi-resources
FREE – Continue reading “How To Create Chatbots With Power Virtual Agents”