Business Intelligence with Power BI Desktop

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: 2. Connection and Shaping Data

Lecture 1: Introduction and adjusting settings in Power Bi

Lecture 2: 2-2.Transform data in power bi

Lecture 3: 2-3. Dealing with texts

Lecture 4: 2-4.Dealing with numbers

Lecture 5: 2-5.Working with Date & Time

Lecture 6: 2-6.Index column and conditional column

Lecture 7: 2-7.Grouping & Aggregating

Lecture 8: 2-8. Pivot & unpivot Demo 1

Lecture 9: 2-8. Pivot & unpivot Demo 2

Lecture 10: 2-9. Merging Queries

Lecture 11: 2-10. Append Queries

Lecture 12: 2-11.Connecting a folder

Lecture 13: 2-12. Data source sitting and refreshing in report

Lecture 14: 2-13. Data type and categories in PBi

Lecture 15: 2-14. Hierarchies in PBi

Chapter 3: 3. Table Relationships and Data Model

Lecture 1: 3-1.The issue and Data model

Lecture 2: 3-2. Normalization and understand Data table & Data lookup

Lecture 3: 3-3. Creating table relationship

Lecture 4: 3-4. Snowflake schemas

Lecture 5: 3-5. Editing relationship and Active vs. Inactive relationship

Lecture 6: 3-6. Connect multiple data table

Lecture 7: 3-7. Filter flow

Lecture 8: 3-8. Bi direction ( two-way) direction filter

Lecture 9: 3-9. Hiding fields from the report view

Chapter 4: 4. Analyzing Data with DAX

Lecture 1: 4-1. Intro to DAX and calculated column

Lecture 2: 4-2. Intro to measures

Lecture 3: 4-3. Adding measures, Implicit vs. Explicit measures

Lecture 4: 4-4. DAX Date & Time function 1

Lecture 5: 4-4. DAX Date & Time function 2

Lecture 6: 4-5.DAX. IF-OR-AND functions

Lecture 7: 4-6. DAX, Common text functions

Lecture 8: 4-7. DAX , Joining Data with related

Lecture 9: 4-8. DAX, Math functions

Lecture 10: 4-9. DAX. Count functions ( Count, COUNTA, Countrows, distinctcount)

Lecture 11: 4-10. important

Lecture 12: 4-11. DAX, Calculate function

Lecture 13: 4-12. DAX, Calculate ALL

Lecture 14: 4-13. DAX, Filter

Lecture 15: 4-14. DAX, Iterator functions

Lecture 16: 4-15. DAX, Time intelligence

Chapter 5: Data Visualization with Power BI Desktop

Lecture 1: 5-2. Basics of Visualization Data in Power BI

Lecture 2: 5-3. Formatting options

Lecture 3: 5-4. Filter Options

Lecture 4: 5-5. Explore data with Matrix

Lecture 5: 5-6. Filter Data with slicers

Lecture 6: 5-7. Cards and KPI Visuals

Lecture 7: 5-8. Text Cards

Lecture 8: 5-9. Visualizing Data with Maps

Lecture 9: 5-10. Visualizing Data with Tree maps

Lecture 10: 5-11. Trendline and Area Chart

Lecture 11: 5-12. Trendline with forecasts

Lecture 12: 5-13. Goal pacing with gauges chart

Lecture 13: 5-14. Edit Report Interactions

Lecture 14: 5-15, Drill Through Filter

Lecture 15: 5-16. Report Bookmarks

Lecture 16: 5-17. What if analysis

Lecture 17: 5-18. Managing and Viewing Roles

Lecture 18: 5-19. More visuals, Mobile Layout and PBI Service need cut