Power BI & DAX - Beginners to Advanced

Name: Power BI & DAX - Beginners to Advanced
Rating: 4.5 (39 reviews)

Learn from beginners level to Advanced level

Created byMyExcelAcademy .

Last updated 11/2024

English

What you'll learn

Learn to use and implement DAX to solve many scenarios
Design and Implement Power BI Dashboards
Learn DAX along side data analysis thinking on what customers expect to see
Transform raw data into meaningful insights that tell a story
Combine DAX and Visualizations to showcase your Dashboards

Course content

12 sections • 70 lectures • 9h 20m total length

Introduction to the course and Power BI5:28
What is Power Query
Understanding your data3:33

Create a Remote Control Filter5:45
Bookmarks8:15
Using Bookmarks without Data5:31
Using Filter with IN Function7:19
Calculate brand gold sales across selected categories using calculate and filter with the in function to form gauge charts. Then compute market share as a percentage of total category sales.
Guage Charts5:20
Guage Charts Complete5:14
Avoiding Blanks3:24
Nested Calculate7:33
Completed Shares Calculation3:32
Using the UNICHAR Function10:46
Multirow Card Visual12:49
Stacked Column Chart9:49
Analyze feature6:41
Category Sales Comparison7:42
Dynamic Title3:02
Show Top 5 SKUs in a Tool Tip7:16
Use a Power BI tooltip page to show the top 5 SKUs by total amount, with item names, a total amount card, and a trend chart filtered by date.
Apply tool tips on visuals5:14
Using Themes2:31
Apply Power BI themes to sync colors across visuals and text, using default or Innovate theme. Adjust slicer fonts and colors in the format visual pane to reflect the theme.
Customizing your Themes9:56
Appending new data - watch out for the Bug!8:00

Requirements

Excel knowledge and the willingness to learn a new tool
Basics of Power BI and a fair understanding

Description

I'll take you from the Basics to Advanced level, using DAX, visuals, Power BI tricks and tips along the way.

If you're coming from an Excel background like me, then don't fret, I'll show you examples of DAX comparing them with Excel along the way. Step by Step is key and remember 20% of the stuff you learn is more than enough for 80% of your Power BI Desktop knowledge. Knowledge gained is Knowledge shared. Learning fundamentals is key and this course will cover the fundamentals and take you to the next level. We will cover case study of real world market analysis with multiple Brands, and how to analyze market shares , Brand positioning and sales comparison.

By the end of the course, not only will you have developed an entire business intelligence tool from the ground up using Power BI, but you will have gained the knowledge and confidence to apply these same concepts to your own Power BI projects.

Power BI is the next big thing so why not join today and accelerate your career.

My goal will be to update new modules and videos as we go along, remember that Power BI is updating and evolving on a monthly basis and there are many minute features that can explode into Powerful insights

Who this course is for:

Data Analysts, Excel users, Excel enthusiasts, Sales Managers, anyone willing to learn Power BI

Power BI & DAX - Beginners to Advanced

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 9min

Importing Data and Understanding Power Query & Power BI2 lectures • 17min

Your First Dashboard in under 20 minutes1 lecture • 22min

DAX Measures & Calculated Columns4 lectures • 54min

CALCULATE5 lectures • 1hr 11min

Calculating Market Shares4 lectures • 26min

Time Intelligence6 lectures • 50min

PRICE SEGMENTATION ANALYSIS5 lectures • 43min

Field Parameters - NEW2 lectures • 12min

Dashboard Report20 lectures • 2hr 16min

Requirements

Description

Who this course is for: