Power BI & DAX Simplified

Focused View

MyExcelAcademy .

7:21:04

123 View

1. Introduction

1.1 POWER BI & DAX Simplified.pdf

1. Introduction to the course and Power BI.mp4

05:28

2. What is Power Query.html

3.1 EPOS (start).xlsx

3. Understanding your data.mp4

03:33

2. Importing Data and Understanding Power Query & Power BI

1. Import your Data.mp4

10:40

2. Power BI Interface.mp4

06:26

3. Your First Dashboard in under 20 minutes

1.1 market analysis dashboard without dax.zip

1. Sales Overview.mp4

21:48

4. DAX Measures & Calculated Columns

1. Understanding Measures & Calculated Columns.mp4

11:06

2. SUMX and Row Context.mp4

07:28

3. Basic Dax Measures.mp4

17:42

4.1 dax & calculated columns.zip

4.2 DAX Measures vs Calculated Columns.pdf

4. DISTINCT, COUNTROWS, VALUES.mp4

17:42

5. CALCULATE

1.1 Calculate.pdf

1. Understanding CALCULATE.mp4

16:55

2. ALL VS. REMOVEFILTERS.mp4

09:51

3.1 Reference Table.xlsx

3. ALLSELECTED.mp4

12:50

4.1 dax & calculated columns.zip

4. TOP N - DYNAMIC.mp4

14:23

5.1 5. Formatting text and visuals.mp4

16:51

5. Formatting your text and visuals.mp4

16:51

6. Calculating Market Shares

1. ISINSCOPE.mp4

05:46

2. Use of Variables.mp4

05:14

3.1 market shares.zip

3. Calculate Market Shares.mp4

06:59

4.1 Reference Table.xlsx

4. Market Insights.mp4

07:34

7. Time Intelligence

1.1 EPOS (start).xlsx

1. Append new Data.mp4

04:24

2. Create a Calendar Table.mp4

12:15

3. SAMEPERIODLASTYEAR & DATEADD.mp4

09:58

4. YEARTODATE, QUARTERTODATE, CUMULATIVE SALES.mp4

09:59

5. AVERAGE SALES.mp4

06:50

6.1 time intelligence.zip

6. DATESINPERIOD.mp4

06:42

8. PRICE SEGMENTATION ANALYSIS

1. Price Segmentation.mp4

10:40

2. Percentage of Sales & Countrows.mp4

09:08

3. Dynamic Text.mp4

04:47

4. Ranking.mp4

08:55

5.1 price segmentation.zip

5. Using SWITCH Function.mp4

09:57

9. Field Parameters - NEW

1. Field Parameters.mp4

07:59

2. Editing Field Parameters.mp4

04:09

10. Dashboard Report

1. Create a Remote Control Filter.mp4

05:45

2. Bookmarks.mp4

08:15

3. Using Bookmarks without Data.mp4

05:31

4. Using Filter with IN Function.mp4

07:19

5. Guage Charts.mp4

05:20

6. Guage Charts Complete.mp4

05:14

7. Avoiding Blanks.mp4

03:24

8. Nested Calculate.mp4

07:33

9. Completed Shares Calculation.mp4

03:32

10. Using the UNICHAR Function.mp4

10:46

11. Multirow Card Visual.mp4

12:49

12. Stacked Column Chart.mp4

09:49

13. Analyze feature.mp4

06:41

14. Category Sales Comparison.mp4

07:42

15. Dynamic Title.mp4

03:02

16. Show Top 5 SKUs in a Tool Tip.mp4

07:16

17. Apply tool tips on visuals.mp4

05:14

18.1 18. Using Themes.mp4

02:31

18. Using Themes.mp4

02:31

Description

Learn from beginners level to Advanced level

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

Who is this for?

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

What You Need to Know?

Excel knowledge and the willingness to learn a new tool

Basics of Power BI and a fair understanding

More details

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

User Reviews

Rating

average 0

Total votes0

Focused display

I have been an Excel user for the last 13 years and enjoy working with Excel on a daily basis. It never seems to amaze me what you can learn everyday using your Excel skills. I work as a Brand Manager for an FMCG Sales distribution company and have successfully taught many working professionals and corporate companies basics to advanced techniques using Excel and VBA. I now plan to bring my own course to Udemy followers and share my methodology and techniques. I will be updating my course with new materials for my students with Power Query + Power BI and other interesting Excel videos.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.