Month: June 2022

From Decomposition Tree to Details in Power BI!!!

Posted on by Annie D

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!!!” →

How To Visualize A Variable’s Distribution Alternatives With Seaborn

Posted on by Annie D

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” →

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

Posted on by Annie D

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!” →

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

Posted on by Annie D

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” →

Enterprise DNA Power Tools – Quick Measures Pro Pt.1

Posted on by Annie D

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” →

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

Posted on by Annie D

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)” →

Publish from Power BI Desktop for External Users

Posted on by Annie D

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” →

Improving Data Literacy with George Mount

Posted on by Annie D

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” →

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

Posted on by Annie D

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)” →

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

Posted on by Annie D

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.

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

Posted on by Annie D

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?” →

How To Create Chatbots With Power Virtual Agents

Posted on by Annie D

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” →