You might encounter a requirement where you’ll need to display the ratio percentage of a particular level in your data against a parent level, and many might find this to be a tricky task as there is no straightforward function to achieve this result. In this video, Harsh is going to demonstrate how you can calculate percentages in hierarchical form.

***** Video Details *****
00:00 Introduction
01:14 The matrix
01:35 % of total sales
03:06 Total sales
04:08 Total sales per territory
04:44 Total sales per product
06:21 % of sales per territory
06:57 % of sales per product
08:12 Results

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Continue reading “How To Calculate Percentages In A Hierarchical Form In Power BI” →

One of the most common questions you’ll encounter as a data analyst is how is the best way to explore a given data set. This is an important consideration primarily if you wan to put all the data together in a report that’s going to be easy to interpret by yourself or your team. In this tutorial, George is going to demonstrate how you can efficiently explore a dataset in Pandas using ProfileReport().

***** Video Details *****
00:00 Introduction
04:03 Overview of data set
04:33 Variables
06:06 Interactions
06:37 Correlations
07:17 Missing values
08:48 Sample
09:12 Example
10:50 Recap

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Continue reading “How To Explore Datasets In Pandas With ProfileReport()” →

There’s no question that it is important for companies to understand their data. The challenge most businesses face, however, is that they lack the time and manpower to gather, analyze, and report all of their relevant data. Moreover, big data has made it even more difficult for business owners to make decisions based on information spread out across multiple systems. How can businesses find solutions that will allow them to slice and dice data in many ways so that they can understand how different areas of the business perform?

Pascal Kiefer is a Business Intelligence enthusiast and the founder of K Continue reading “Leveraging the Power of Business Intelligence with Pascal Kiefer” →

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

When is it?
June 2nd – 12pm Los Angeles (PDT), 3pm New York (EDT), 8pm London (BST)
June 3rd – 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 1)” →

EVENT DETAILS – https://enterprisedna.co/reporting-and-data-visualization-summit-may-2022-registration/

RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/reporting-and-data-visualization-summit/

[Breakout Session 4] Member Case Studies (Member-Only)

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

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

Who’s doing it?
Presented by Brian Julius – Chief Content Officer, Enterprise DNA

If you have questions regarding this training, please send it to http://forum.enterprisedna.co/

#PowerBI #DataVisualization #eDNASummitMay2022 #EnterpriseDNAEvents