Microsoft Power BI - Masterclass & Milestone and BEYOND

Name: Microsoft Power BI - Masterclass & Milestone and BEYOND
Rating: 4.4 (2 reviews)

Facebook, Linkedin, Websites... are only places to stock and introduce data. And, if we starting to learn by using them

Created byFlorian Fiducia

Last updated 6/2024

English

What you'll learn

A new view of a more developed experience with Power BI
Creating reports with Facebook, Linkedin and website's data
Understand and use DAX
Experienced with Milestones
Discover different types of reports
Clean & Model your datasets

Course content

21 sections • 156 lectures • 5h 19m total length

Introduction2:12

SUMMARIZE()2:17
Describe how the Power BI SUMMARIZE() function returns a summary table from the data, optionally groups by columns, and uses expressions to define the final values for each grouping.
REMOVEFILTERS()1:55
KEEPFILTERS()1:19
Master keepfilters() to adjust filter context in Power BI, using diverse expressions to produce a values table; apply Asia to calculate revenues with selective filters and name the result.
ISFILTERED()0:30
FILTER()2:38
CALCULATE()2:49
CALCULATETABLE()3:09
ALLSELECTED()1:23
ALLEXCEPT()1:17

AVERAGE()0:36
AVERAGEX()4:03
DIVIDE()1:10
SUM()0:34
SUMX()2:55
ROUND() - ROUNDUP() - ROUNDDOWN()3:09
Learn how to round numbers using round(), roundup(), and rounddown() to a specified number of digits, including digits left of the decimal and negative digits, with examples showing decimal places.
MROUND()1:08
POWER()0:45
MIN() - MEDIAN() - MAX()1:43
INT()1:34
DISTINCT()1:34
COUNTX()1:16
COUNTROWS()0:52
COUNTBLANK()0:52
COUNTA()0:59
Master the counting function that counts non-empty values in a column, and see how it applies to an order table’s product category values for basic statistics in Power BI.
COUNTAX()1:30

Introduction0:46
Overview1:21
Searching0:31
Average line5:06
Constant line0:32
Min line1:36
Max line1:23
Discover how to identify and display maximum values in Power BI, including selecting the maximum metric, adjusting color and transparency, and formatting the name and value on the right.
Median line1:03
Percentile line3:03
Analyze percentile line visuals in Power BI to compare data across a range from minimum to maximum, with examples like 10 percent transparency and a group value of 776,483.
Forecasting & Trend line2:29
Identify how to define forecasts and trend lines in Power BI analytics, use confidence intervals to show forecast ranges, and build color-adjusted visuals to display forecasted lines.

Requirements

Explained for everyone but can be easier with few basics skills

Description

Are you looking for a fun and interactive way to master data analysis and visualization? Look no further! Our Power BI course is the perfect blend of entertainment and education that will have you hooked from the very first lesson.

Imagine being able to effortlessly connect and transform data from various sources, including popular platforms like Facebook and Linkedin. With our course, you will learn how to do just that, and so much more. Through engaging lectures, we will take you on a journey to discover the full potential of DAX and how it can be used to create visually stunning reports for any company's department.

But why stop there? You will also have the skills to create awesome reports using your own personal datasets. Not only will you learn how to navigate through different websites to download datasets, but you will also gain a deep understanding of how DAX works. And that's not all, at the end of the course, you will have the opportunity to evaluate your progress and celebrate your milestones. But what makes our course truly unique is that we teach you by using real-life examples and scenarios.

Learning is always more enjoyable when you can apply it to something you are familiar with. And with Facebook, Linkedin, and various websites as our playground, you will be able to do just that. So don't wait any longer, join us now and see for yourself how our course can make learning Power BI a fun and entertaining experience.

Get ready to become a data analysis and visualization guru, while having a blast along the way. See you in class!

Who this course is for:

Every students who want to improve their skills on Power BI and becoming closer to an expert
Beginners or experienced students with needs or wants to improve their skills
Everyone who wants to learn, discover or re-discover Power BI

Microsoft Power BI - Masterclass & Milestone and BEYOND

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 2min

Become an Expert with DAX5 lectures • 12min

DAX Functions - DATES6 lectures • 9min

DAX Functions - Filters9 lectures • 17min

DAX Functions - Conditions7 lectures • 14min

DAX Functions - Math & Stats16 lectures • 25min

DAX Functions - Text8 lectures • 13min

Visualisation for Professional6 lectures • 13min

Tooltips7 lectures • 14min

Analytics Pane10 lectures • 18min

Requirements

Description

Who this course is for: