Become An Expert In Microsoft Power BI Desktop

Focused View

Sayyed Kashif Asrar Ahmad

26:02:30

446 View

1 - Introduction and Course Structure

1 - Read Me.html

2 - Introduction to Course.mp4

02:57

3 - Course Design.mp4

04:35

4 - Adventure-Works-Image-Resources.rar

4 - Adventure-Works-Raw-Data.rar

4 - Adventure-Work-Dashboard.rar

4 - Become-an-Expert-in-Power-BI.rar

4 - Download Resources.html

5 - Course Project.mp4

04:19

6 - Setting Expectations.mp4

01:58

2 - Power BI Introduction

1 - Quiz Introduction to Power BI Desktop.html

7 - Introduction.mp4

01:36

8 - What is Power BI.mp4

06:01

9 - Power BI Download and Installation.mp4

02:55

10 - Power BI Settings.mp4

04:43

11 - Work Flow Interface.mp4

05:22

12 - Resources and Monthly Updates.mp4

02:37

3 - Connecting Preparing Data

13 - Introduction Connecting Preparing Data.mp4

02:35

14 - Power BI Data Sources Connectors.mp4

10:16

15 - New Power Query Editor Tools.mp4

09:07

16 - Table transformation.mp4

15:15

17 - Assignment Table Transformation.mp4

02:14

18 - Solution Table Transformation.mp4

08:09

19 - Expert Tip Data Storage Connection Modes.mp4

09:07

20 - Connecting to SQL Server Datasource.mp4

06:08

21 - Connecting to a Web Page.mp4

05:23

22 - QA Column Profiling Tools.mp4

16:12

23 - Numeric Tools.mp4

11:49

24 - Assignment Numeric Tools.mp4

01:35

25 - Solution Assignment Numeric Tool.mp4

03:00

26 - Text Tools.mp4

10:09

27 - Assignment Text Tools.mp4

01:20

28 - Solution Assignment Text Tools.mp4

03:21

29 - Date Time Calendar Table.mp4

16:29

30 - Changing Locale to Format Date.mp4

04:33

31 - Expert Tip Rolling Calendar.mp4

14:17

32 - Assignment Date Table.mp4

01:37

33 - Solution Date Table.mp4

02:34

34 - Index Conditional Columns.mp4

12:49

35 - Guidelines to Work With Calculated Columns.mp4

09:25

36 - Grouping Aggregation.mp4

09:17

37 - Pivot UnPivot Columns.mp4

07:10

38 - Merging Queries.mp4

09:46

39 - Appending Queries.mp4

09:14

40 - Expert Tip Adding Files From Folder.mp4

08:21

41 - Data Source Setting.mp4

06:25

42 - Expert Tip Parameterised Data Source.mp4

13:57

43 - Refreshing Queries Organizing.mp4

07:52

44 - Expert Tip Import Excel Model in Power BI.mp4

06:07

45 - Best Practices Data Connection Preparation.mp4

02:20

4 - Data Model

46 - Data Modeling Introduction.mp4

02:53

47 - Data Modeling 101.mp4

05:38

48 - Normalization.mp4

04:10

49 - Fact Dimension Tables.mp4

02:49

50 - Primary Foreign Keys.mp4

09:57

51 - Understanding Table Relationships.mp4

02:04

52 - Creating Table Relationships.mp4

10:30

53 - Managing Table Relationships.mp4

04:18

54 - Star Snowflake Schemas.mp4

04:06

55 - Assignment Table Relationships.mp4

01:46

56 - Solution Assignment Table Relationships.mp4

06:38

57 - Expert Tip Active InActive Relationship.mp4

05:52

58 - Cardinality.mp4

05:23

59 - Connecting to Multiple Data Tables.mp4

09:57

60 - Filter Context Flow Waterfall Model.mp4

07:07

61 - Bidirectional Filters Risks.mp4

10:51

62 - Hiding Fields From Report View.mp4

07:36

63 - Expert Tip Custom Model Layout.mp4

06:57

64 - Assignment Hiding Fields.mp4

01:46

65 - Solution Assignment Hiding Fields Filter Flow.mp4

07:25

66 - Categorizing Formatting Data.mp4

11:56

67 - The Data Hierarchies.mp4

06:34

68 - Assignment Date Hierarchy.mp4

01:46

69 - Solution Assignment Date Hierarchy.mp4

03:03

70 - Best Practices Desiging a Data Model.mp4

02:05

5 - Using DAX in Power BI

71 - Introduction to Using DAX in Power BI.mp4

01:41

72 - DAX.mp4

02:08

73 - Mcode vs DAX Code.mp4

02:39

74 - Calculated Columns.mp4

12:56

75 - DAX Measures.mp4

04:02

76 - Implicit Explicit Measures.mp4

10:04

77 - Quick Measures.mp4

03:18

78 - Comparing Calculated Columns Measures.mp4

02:44

79 - Expert Tip Measures Tables.mp4

08:51

80 - The Filter Context.mp4

08:14

81 - Calculation Steps for a Measure.mp4

03:10

82 - DAX Syntax and Operators.mp4

05:16

83 - Frequently Used Functions.mp4

04:16

84 - Maths Statistics Functions.mp4

12:37

85 - Maths Counting Functions.mp4

18:28

86 - Assignment New Measures.mp4

01:38

87 - Solution Assignment New Measures.mp4

11:16

88 - Expert Tip Organising Measures.mp4

05:38

89 - Logical Functions in DAX.mp4

08:08

90 - Switch Logical Function.mp4

16:07

91 - Assignment Logical Functions.mp4

02:22

92 - Solution Assignment Logical Functions.mp4

09:52

93 - Text Functions in DAX.mp4

08:33

94 - Assignment Text Functions.mp4

01:26

95 - Solution Assignment Text Functions.mp4

06:55

96 - DAX Functions for Date Time.mp4

10:01

97 - Assignment Date Functions.mp4

00:59

98 - Solution Assignment Date functions.mp4

02:50

99 - The DAX Function RELATED.mp4

09:37

100 - The DAX Function CALCULATE.mp4

17:44

101 - The Peculiar Case of Unmtached Totals.mp4

08:07

102 - Assignment CALCULATE Function.mp4

02:04

103 - Solution Assignment CALCULATE Function.mp4

09:41

104 - The ALL Function of DAX.mp4

13:27

105 - Assignment CALCULATE ALL.mp4

01:52

106 - Solution Assignment Calculate All.mp4

04:47

107 - The FILTER Function of DAX.mp4

10:30

108 - The Iterator Functions of DAX.mp4

18:18

109 - Assignment Iterator Functions.mp4

01:46

110 - Solution Assignment Iterator Functions.mp4

05:34

111 - Time Intelligence Functions in DAX.mp4

25:59

112 - Assignment Time Intelligence.mp4

01:47

113 - Solution Assignment Time Intelligence.mp4

15:03

114 - Best Practices Using DAX.mp4

02:37

6 - Advanced DAX for Measures

115 - Introduction to Advanced DAX.mp4

01:56

116 - DAX Shortcuts.mp4

06:41

117 - Formatting DAX Code.mp4

07:00

118 - Comments in DAX Code.mp4

04:23

119 - Error Handling in DAX.mp4

08:39

120 - DAX Variables and Uses.mp4

08:42

121 - Evaluation Order for Variables.mp4

06:24

122 - Expert Tip Debug Test DAX.mp4

09:26

123 - Modifiers for CALCULATE Function.mp4

04:14

124 - Modifier REMOVEFILTERS.mp4

09:14

125 - Modifier KEEPFILTERS.mp4

08:36

126 - Assignment Modifiers.mp4

01:36

127 - Solution Assignment Modifiers.mp4

08:07

128 - Expert Tip Advanced CALCULATE Uses.mp4

12:36

129 - Table Filter Functions.mp4

02:28

130 - Calculated Virtual Tables.mp4

05:02

131 - The DISTINCT Function.mp4

04:32

132 - Versatile VALUES Function.mp4

06:04

133 - Table Relationships.mp4

02:54

134 - Iterator Cardinality.mp4

04:40

135 - CONCATENATEX Function.mp4

07:58

136 - Expert Tip Dynamic Labels.mp4

09:22

137 - Requirements of a Date Table.mp4

02:40

138 - Calendar Function.mp4

05:07

139 - Expert Tip Reusable Date Table.mp4

13:13

140 - Time Intelligence Functions.mp4

03:54

141 - PARALLELPERIOD Function.mp4

07:41

142 - PREVIOUSQUARTER Function.mp4

06:31

143 - SAMEPERIODLASTYEAR Function.mp4

08:05

144 - Additional Time Intelligence Calculations.mp4

10:43

145 - Best Practices Advanced DAX.mp4

02:01

7 - Visualizing Data

146 - Introduction Visualizing Data on Dashboards.mp4

02:25

147 - Key Questions Before You Design.mp4

07:05

148 - Analytics Dashboard.mp4

05:31

149 - The Dashboard Layout.mp4

08:02

150 - Adding Pages Objects to Report View.mp4

09:25

151 - Format Selection Panes.mp4

04:11

152 - Cards MultiRow Cards.mp4

12:05

153 - Assignment KPI Cards.mp4

01:41

154 - Solution Assignment KPI Cards.mp4

04:22

155 - OnObject Formatting.mp4

03:16

156 - Adding Line Charts.mp4

12:01

157 - Expert Tip Trend Lines Forecasts.mp4

07:03

158 - Assignment Line Chart.mp4

01:25

159 - Solution Assignment Line Chart.mp4

05:50

160 - KPI Cards.mp4

14:56

161 - Doughnut Bar Charts.mp4

07:38

162 - The Filter Options Pane.mp4

11:36

163 - Assignment Doughnut Chart Filters.mp4

01:57

164 - Solution Assignment Doughnut Chart Filters.mp4

08:35

165 - Tables Matrix Visuals.mp4

12:03

166 - Conditional Formatting.mp4

06:59

167 - Top N Filter.mp4

03:32

168 - Assignment Tables.mp4

02:18

169 - Solution Assignment Tables.mp4

11:19

170 - Expert Tip Top N Text Cards.mp4

12:57

171 - Assignment Top N Cards.mp4

01:49

172 - Solution Assignment Top N Cards.mp4

12:46

173 - New Card Visual.mp4

10:42

174 - Advanced Formatting New Card Visual.mp4

09:22

175 - More Advanced Formatting New Card Visual.mp4

10:32

176 - Assignment New Card Visual.mp4

01:31

177 - Solution Assignment New Card Visual.mp4

13:08

178 - Expert Tip Sparkline Chart in Card.mp4

08:19

179 - Map Visual.mp4

07:51

180 - Slicers.mp4

07:33

181 - Assignment Slicer.mp4

01:42

182 - Solution Assignment Slicer.mp4

06:20

183 - New Button Slicer.mp4

10:39

184 - The DAX Function HASONEVALUE.mp4

08:56

185 - Radial Gauge Charts.mp4

12:28

186 - Expert Tip Advanced Formatting Gauge Charts.mp4

06:43

187 - Area Charts.mp4

07:32

188 - Drill Up Down.mp4

09:08

189 - Assignment Drill Up Down.mp4

01:42

190 - Solution Assignment Drill Up Down.mp4

03:02

191 - CrossReport Drillthrough.mp4

08:02

192 - Editing Report Interactions.mp4

08:33

193 - Assignment Report Interactions.mp4

01:37

194 - Solution Assignment Report Interactions.mp4

04:07

195 - Power BI Bookmarks.mp4

07:34

196 - Assignment Bookmarks.mp4

02:00

197 - Solution Assignment Bookmarks.mp4

07:24

198 - Expert Tip Custom Navigation Buttons.mp4

10:34

199 - Expert Tip Slicer Panel.mp4

10:59

200 - Report Parameters.mp4

12:37

201 - Fields Parameters.mp4

10:03

202 - Assignment Field Parameters.mp4

01:52

203 - Solution Assignment Field Parameters.mp4

06:17

204 - Expert Tip Custom Tooltips.mp4

11:12

205 - Assignment Custom Tooltip.mp4

01:37

206 - Solution Assignment Custom Tooltip.mp4

06:31

207 - Using Custom Visuals.mp4

10:35

208 - Using Roles in Power BI.mp4

07:30

209 - Mobile Layouts.mp4

06:35

210 - Preview Publishing to Power BI Service.mp4

03:28

211 - Best Practices Data Visualizations.mp4

02:26

8 - Artificial Intelligence in Power BI

212 - Introduction to AI in Power BI.mp4

03:48

213 - Anomaly Detection.mp4

09:42

214 - Smart Narrative Summaries.mp4

11:13

215 - QA Visuals.mp4

21:14

216 - Decomposition Tree.mp4

13:30

217 - Key Influencers.mp4

16:52

9 - Optimization Tools in Power BI

218 - Introduction to Optimization in BI.mp4

02:26

219 - Optimize Menu Ribbon.mp4

02:52

220 - Pausing Visuals.mp4

07:08

221 - Optimization Presets.mp4

07:08

222 - Applying AIl slicer button.mp4

05:56

223 - Performance Analyzer.mp4

08:41

224 - External Tools.mp4

06:56

10 - Power BI Updates New Features

225 - About This Section.html

Description

2024's cutting-edge Power BI course tailored for Business Intelligence Analysts, Data Analysts and Data Professionals

What You'll Learn?

Master the use of the most user-friendly Business Intelligence tool to produce impressive professional-quality business intelligence reports from scratch
Transform raw data into interactive dashboards. Master the art of writing advanced DAX measures and calculated columns to tackle complex computations.
Learn how to use the capabilities of DAX to generate potent calculations & comparison for multiple tables utilized by data scientists & professional analysts
Master visuals: column, line, pie, combo, scatter, treemap, gauges, KPIs. Design tables, matrices for reporting and showcase your skills with course projects
Leverage data science skills to extract insights, analyze, and visualize complex queries effortlessly. Harness potent artificial intelligence tools in reports
Master Query Editor for Power BI connections to diverse sources. Understand Data Model distinctions and workflow nuances
Learn from seasoned industry expert

Who is this for?

Those seeking a hands-on, project-based introduction to Power BI Desktop

Data analysts and Excel users aspiring to enhance their skills

Individuals aiming to master the top business intelligence tool

Students craving an engaging, interactive learning experience

Anyone eyeing a career in data analysis or business intelligence

What You Need to Know?

Microsoft Power BI Desktop (free download)

Designed for PC/Windows users, currently not available for mac users

Experience with Excel Power Query, Power Pivot & DAX is beneficial but not mandatory

More details

Description
Master Power BI Desktop for data analysis through hands-on assignments and projects led by a top-rated instructor in Power BI.
Are you a data professional or an aspiring analyst eager to indulge into the leading business intelligence platform? Look no further. This meticulously designed course is your gateway to mastery. With tens of hours of video tutorials, comprehensively covering every Power BI topic, this is the course youâ€™ve been looking for.
Embark on a journey guided by top-tier instructors from Sayyed Academy. Dive into hands-on projects and real-world assignments, polishing your skills along the way.
COURSE PROJECT:
Step into the shoes of a Business Intelligence Analyst at Adventure Works Cycles, a fictional manufacturing company. Your mission? Transform raw data into polished reports and dynamic dashboards, tracking KPIs, analyzing regional performance, identifying product trends, and pinpointing high-value customers.
Fear not! We'll be with you every step of the way, offering clear explanations and expert tips to elevate you from novice to pro â€“ guaranteed.
This course covers all the stages of the business intelligence workflow, replicating real-world tasks encountered by data professionals.

SECTION 1: Connecting & Shaping Data
In this phase, we will focus on constructing automated workflows to extract, transform, and load project data via Power Query. Explore various data connectors, storage modes, profiling tools, table transformations, and more:

Data connectors
Storage & import modes
Query editing tools
Table transformations
Database connectivity
Web data extraction
QA & Profiling tools
Text, numerical, date & time tools
Rolling calendars
Index & conditional columns
Grouping & aggregating
Pivoting & unpivoting
Merging & appending queries
Data source parameters
Excel model imports
SECTION 2: Building a Relational Data Model
In this phase, we delve into data modeling best practices, covering cardinality, normalization, filter flow, and star schemas. We kick-start the Adventure Works data model from scratch:

Database normalization
Fact & dimension tables
Primary & foreign keys
Star & snowflake schemas
Active & inactive relationships
Relationship cardinality
Filter context & flow
Bi-directional filters
Model layouts
Data formats & categories
Hierarchies

SECTION 3: Enriching Data with DAX Calculations
In this segment, we introduce data analysis expressions (DAX). Create calculated columns and measures, explore row and filter contexts, and wield powerful tools like filter functions, iterators, and time intelligence patterns:

DAX vs. M
Calculated columns & measures
Implicit, explicit & quick measures
Measure calculation steps
DAX syntax & operators
Math & stats functions
Conditional & logical functions
The SWITCH function
Text functions
Date & time functions
The RELATED function
CALCULATE, FILTER & ALL
Iterator (X) functions
Time intelligence functions

SECTION 4: Mastering Advanced DAX
This phase dives into advanced DAX functions, including implementing advanced aggregation, contextual calculations, time intelligence functions, and DAX variables:

DAX shortcuts, code formatting, etc.
Error handling
DAX variables and uses
DAX code testing and debugging
DAX modifiers
REMOVEFILTER & KEEPFILTER modifiers
Advanced CALCULATE function uses
Table and filter functions
Calculated Virtual tables
DISTINCT function
VALUES function
Table relationships & cardinality
CONCATENATEX function
Dynamic labels
CALENDAR function
Time intelligence functions
PARALLELPERIOD & PREVIOUSQUARTER functions
Additional time intelligence calculations

SECTION 5: Crafting Dynamic Data Visualizations
Section 5 focuses on breathing life into data with reports and dashboards. Review into data visualization best practices, chart creation, and interactivity enhancement:

Data viz best practices
Dashboard design framework
Cards & KPIs
Line charts, trend lines & forecasts
On-object formatting
Table & matrix visuals
Conditional formatting
Top N filtering
Map visuals
Drill up, drill down & drillthrough
Report slicers & interactions
Bookmarks & page navigation
Numeric & fields parameters
Custom tooltips
Importing custom visuals
Managing & viewing roles (RLS)
Mobile layouts
Publishing to Power BI Service

SECTION 6: Artificial Intelligence in Power BI
Unlock AI's potential in Power BI with expert lessons. Explore predictive analytics, anomaly detection, clustering, and more for data-driven insights.

Introduction to AI in Power BI
Anomaly Detection
Smart Narrative Summaries
Q&A Visuals
Decomposition Tree
Key Influencers

SECTION 7: Artificial Intelligence in Power BI
Explore Optimization Tools in Power BI: Unveil native and external resources to boost report performance, enhancing insights and efficiency.

Introduction to Optimization in BI
Optimize Menu Ribbon
Pausing Visuals
Optimization Presets
Applying All slicer button
Performance Analyzer
External Tools
SECTION 8: Power BI Updates & New Features
Stay Updated with Power BI: Discover the latest features and updates as they're released. Explore new visuals and functions added to Power BI post-course launch.

DAX Query View
Advanced Measures in DAX Query View
Calculation Groups
Calculation Groups For Daily Averages
Calculation Groups For Time Intelligence
Visual Calculations
Using Visual Calculations

SECTION 9: Mastering Dashboard Design
Master advanced data visualization techniques, essential KPIs, dashboard examples, and finance and accounts terminologies in Power BI for impactful dashboards and compelling reports.

12 Vital KPIs
Visual Data Handbook
Chart Selection Guide
Variety of Dashboard Examples
A Guide to Essential Accounting KPIs
Finance and Accounting Terms Glossary for Power BI

Uncover potent artificial intelligence tools like decomposition trees, key influencers, smart narratives, and natural language Q&A, coupled with performance optimization techniques for seamless report operation at scale. Discover the latest Power BI visuals, including the new card visual, button slicer, and more.

Ready to embark on this transformative journey? Enroll today and unlock immediate, lifelong access to:

Over 27 hours of premium video content
A 270+ page Power BI eBook
28 practical assignments with solutions
Downloadable course project files
A powerful Power BIÂ cheat sheet for quick and ready reference
Expert Q&A support forum
A risk-free 30-day money-back guarantee

If you seek the ultimate course to cultivate job-ready Power BI skills, look no further.
Keep learning with joy !
Who this course is for:
Those seeking a hands-on, project-based introduction to Power BI Desktop
Data analysts and Excel users aspiring to enhance their skills
Individuals aiming to master the top business intelligence tool
Students craving an engaging, interactive learning experience
Anyone eyeing a career in data analysis or business intelligence

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Power BI

Sayyed Kashif Asrar Ahmad

Instructor's Courses

With 20 years of experience across Power BI, Python, Java, .NET, and SAP, adept in ETL, database development, and report creation, certified in SAP BI 7.0 and Sun Java 2.0, with PMP training. Extensive professional background includes tenure with premier organizations such as Saudi Aramco and Wipro Technologies. Currently mentoring in Power BI, Tableau, Python, ETL, SQL, and DAX. I graduated in Electronics and Communication Engineering from Jamia Millia Islamia, New Delhi, India.

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.