Microsoft Power BI Desktop and DAX plus Dashboard creation

Focused View

Ismaila Mumin Omeiza

19:52:29

204 View

1 - Course Projects

1 - Take a look at the projects we are going to create in this Course.mp4

08:54

2 - Intro to POPWER BI Desktop

2 - Best place to Install Power BI Desktop from.mp4

03:59

3 - Important Power BI Settings you need to Know.mp4

04:13

4 - Quick tour to Power BI.mp4

05:59

5 - All helpful resources to Learn Power BI.mp4

05:48

3 - How to Connect and Transform Data in Power Query

6 - AdventureWorksCSV.zip

6 - All-Resources.zip

6 - Backgrounds.zip

6 - Editable-Backgrounds.zip

6 - Importing Product Table to Power Query.mp4

13:49

6 - Power-Query-Date-Code.txt

6 - completed-dashboard.zip

7 - Understanding the Query Editor.mp4

04:17

8 - Choose columns and Removing columns.mp4

07:14

9 - Power Query Marge Column and Column from Example.mp4

14:44

10 - Extracting Text in Power Qury.mp4

09:55

11 - Regional data Settings.mp4

08:45

12 - Intro to Append Queries.mp4

07:28

13 - Basic way to Append Queries or Tables.mp4

07:15

14 - Advanced way to Append Queries or Tables.mp4

08:26

15 - Adding Index Number and Merging Queries.mp4

06:40

16 - How to Merge multiple columns.mp4

07:14

17 - Importing the Returns FactTable.mp4

01:57

18 - Power Query Static Calendar Table.mp4

12:06

19 - Build Dynamic Power Query Calendar Table.mp4

16:08

20 - Exclude some Tables from Report Refresh.mp4

05:35

21 - How to solve some common Queries Error.mp4

12:07

4 - Creating Data Modeling

22 - Intro to Data Model.mp4

00:32

23 - Arranging Tables in the Models.mp4

11:56

24 - Creating a Star Schema Relationships.mp4

11:56

25 - Creating SnowFlake Relationships.mp4

05:25

5 - 04 How to create a Date Table using DAX

26 - How to create A Date Table with DAX.mp4

07:19

27 - How to restrict CALENDAR AUTO with VAR.mp4

12:04

28 - Two ways to add columns in a Data Table.mp4

08:23

29 - How to use IN and If Function.mp4

09:38

30 - Mark your date table.mp4

02:58

6 - Understand Calculated Column in Power BI

31 - Intro to DAX Language in Power BI.mp4

04:52

32 - Understanding Implicit Measures and Explicit Measures.mp4

13:11

33 - Intro to Calculated Column.mp4

02:00

34 - Aggregation with Calculated column.mp4

02:00

35 - Fixing Percentage Error in Calculated column.mp4

03:07

36 - Calculate Order Level in Calculated column.mp4

05:42

37 - Customer Segmentation in Calculated Column.mp4

20:58

7 - Understand DAX Measures

38 - Intro to DAX Measures.mp4

02:04

39 - How to Organize your Measures in a Single Table.mp4

03:48

40 - DAX Measures for Aggregations.mp4

20:27

41 - Calculating Returned and Refund Rates.mp4

10:44

42 - Correct way to use the Count Functions 1.mp4

12:49

43 - Correct way to use the Count Functions 2.mp4

10:39

44 - Intro to the Calculate Function.mp4

04:23

45 - Details on Calculated Columns.mp4

22:38

46 - Transaction in Canada using CACULATE FUNCTION.mp4

12:13

47 - Best Website to learn DAX FUNCTIONS.mp4

04:40

48 - All and Calculate Function.mp4

15:05

49 - Us All Function with multiple Tables.mp4

13:52

50 - Allselected with Calculate to get correct Percentage.mp4

06:49

51 - Adding Comment in Power BI.mp4

07:46

52 - Understand DAX Table Function.mp4

14:20

53 - The AND Function.mp4

12:54

54 - Advanced AND Function.mp4

11:04

8 - Understand Context Transition

55 - Intro to Context Transition.mp4

05:06

56 - Changing Row context to Filter Context.mp4

08:24

57 - Segmenting Customer using Context Transition.mp4

07:31

58 - Adding DrillThrough To know your customers by segment.mp4

04:41

9 - Simplify DAX with Variables

59 - Simplify DAX with Variables.mp4

09:23

60 - 02 Example of VAR or variables.mp4

07:06

61 - 03 VAR with Percentage of Grand Total.mp4

07:24

62 - Fix Issues on Customer Table.mp4

04:19

63 - Creating a disconnected Table for Top N.mp4

09:58

64 - Top N measure.mp4

15:49

65 - 08 Top N with WhatIf Parameter.mp4

17:45

10 - 09 Understand the default Filters in Power BI Desktop

66 - Understand Filter on This Visual.mp4

08:13

67 - Understand Filter on This Page alone.mp4

03:26

68 - Filter on All pages.mp4

02:16

11 - Visualization Learn to create a Detailed Dashboard

69 - Dashboard Overview.mp4

07:03

70 - How to Sketch your Dashboard Layout before Creation.mp4

12:38

71 - Creating a KPI Cards.mp4

19:05

72 - Finding Profitable customer and Product.mp4

16:51

73 - Show daily Trend with a Line Chart and zooming option.mp4

08:44

74 - Top 10 Ordered Products.mp4

07:22

75 - Things you need to create clean Dashboard.mp4

04:10

76 - Formatting Dashboard.mp4

13:20

77 - Arranging Shapes in Power Point for dashboard Template.mp4

10:26

78 - How to pick correlated colors for your Dashboard.mp4

04:28

79 - Getting statics and Animated Icons.mp4

17:28

80 - Formatting and adding Animated Icons to our Dashboard.mp4

23:18

81 - Formatting Table.mp4

07:10

82 - Edit Interactions for slicers and visuals.mp4

02:36

83 - Adding Bookmarks buttons and blur plus Map chart.mp4

17:42

84 - How to show and Hide Bookmarks.mp4

07:55

85 - Adjust shape in Power point.mp4

03:01

12 - Visualization Dashboard with profit forecast

86 - Project Dataset.html

87 - Challenge Dashboard.mp4

05:29

88 - Creating Forecast in a Line Chart.mp4

12:58

89 - Using the Gauge Chart for comparing values with Target.mp4

15:28

90 - Creating Tooltip Template in Power Point.mp4

08:24

91 - Creating a custom Tooltip.mp4

14:00

92 - Creating Conditional Formatting Measure for a Gauge Chart.mp4

12:23

93 - How to fix Blank Error.mp4

06:10

94 - Weekday Profit.mp4

07:59

95 - Adding Slicers.mp4

02:36

96 - Adding Drill Through.mp4

07:51

97 - How to add Info to Drill Through.mp4

12:44

98 - Formatting dashboard and adding background.mp4

20:43

13 - Dashboard using WhatIf Parameter to change Scenarios

99 - Project Dataset.html

100 - Intro to WhatIf Analysis Dashboard.mp4

07:18

101 - Parameter slide for Quantity Ordered.mp4

10:57

102 - Parameter for Cost Change.mp4

06:33

103 - Parameter for changing prices of products.mp4

09:52

104 - Profit percentage change.mp4

09:20

105 - Creating Table and formatting.mp4

17:15

106 - Creating Dark template in Power point formatting.mp4

21:25

107 - How to create a conditional Measures to show Up and Down trends.mp4

26:32

14 - WhatIf Analysis Dashboard with Top5

108 - Project Dataset.html

109 - Dashboard intro.mp4

01:37

110 - Creating new page.mp4

02:23

111 - Charts for Top New and Old Products.mp4

09:52

112 - KPI Cards.mp4

08:04

113 - Creating Template in Power Point.mp4

16:58

114 - Changing Dashboard colors.mp4

04:14

15 - Sales Returns Dashboard

115 - Project Dataset.html

116 - Intro to Returned Dashboard.mp4

03:47

117 - Important KPIs.mp4

11:48

118 - Returned and Refund Trend.mp4

12:28

119 - Align charts and cards.mp4

15:46

120 - Creating a template in Power Point.mp4

17:24

121 - Importing and Formatting dashboard.mp4

11:42

122 - How to create hide and show filter part 1.mp4

09:04

123 - How to create hide and show filter part 2.mp4

10:54

124 - Changing cards in Power Point.mp4

05:18

125 - How to Create Advanced caption using DAXVAR.mp4

39:46

Description

2023 Edition Power BI Desktop Course. Learn DAX with projects and how to create Reports and Dashboards

What You'll Learn?

You learn how to use Power BI Desktop for Report and Dashboard creation
Transform and clean data using Power Query
Data modelling (creating relationships)
Write DAX (data analysis expression) from beginner to advanced level
Creating interactive Reports
Creating interactive Dashboards
Write advanced DAX using Variables

Who is this for?

Data analysts

Students

Managers

People who want to develop analytics skills

What You Need to Know?

No previous Power BI knowledge is needed ( I will teach you all you need to know)

Basic computer skill

Willing to learn new skill

More details

Description
Welcome to Power BI Desktop course. This is completely built with lots of Practical that will make you work with any real-Life datasets

Are you a data professional or aspiring analyst looking to learn the top business intelligence platform on the market,
taking this course will build your confidence in data and analytics in general.

Through out the course we will guide you through on how to approach real-life projects.

This is the scenario:
You just got hired as a DATA analyst into a sales and distribution company. Your first task is to use POWER BI to get
insight from the companyâ€™s historical data.

Request from your Employer:
Your employer needs you to help them TRACK KPIâ€™s like: Revenue, Returns, Refunds & Profit etc. Create a dashboard that helps them find trend and other useful insights.
They want to identify high profitable Product, Customer and Location etc

You don't need to worry about how to go through this project, we'll be here to walk you through every single step with intuitive, crystal clear explanations and helpful resources you need to get better.

Step 1: Connecting to data and transformation
In this first stage we are going to look at how to get data, get it clean and transformed and load it into Power BI desktop.

We will explore how to append data from csv and further use the advanced way to combine data from csv which is using the folder option to consolidate your yearly, weekly, quarterly or monthly data for easy update.

Step 2: Data modelling or Creating a Relationship
In this stage we will look at how to best connect your data table and the lookup tables together.

Step 3: Adding Calculated Fields with DAX
In this stage things will start to get more interesting. This is the stage you are going to get introduced to Data Analysis
Expressions (DAX) at this stage we will learn how to create calculated columns and measures, explore when to use calculated column and when to avoid it.

Step 4: Visualization (Dashboard)
This final stage is where we bring our data to LIFE with report and dashboard. We will learn the best way to create an outstanding dashboard, create custom tooltips, explore bookmarks and Power BI What-If Parameters.

Who this course is for:
Data analysts
Students
Managers
People who want to develop analytics skills

User Reviews

Rating

average 0

Total votes0

Focused display

As a person with a very high keenness in data analytics with over 6 years of practical experience, I have brought my knowledge and skill to help you learn data analytics with ease.as a student of Technology and data analytics, my aim is to give you an industry-standard training course that will make you thrive.Over the years, I have been working from home as a freelance data analyst with several companies across the world and I am here to show you I did it.

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.