Course curriculum

  • 1

    Introduction

    • Introduction

  • 2

    2. Connection and Shaping Data

    • 2-1. Introduction and adjusting settings in Power Bi

    • 2-2.Transform data in power bi

    • 2-3. Dealing with texts

    • 2-4.Dealing with numbers

    • 2-5.Working with Date & Time

    • 2-6.Index column and conditional column

    • 2-7.Grouping & Aggregating

    • 2-8. Pivot & unpivot Demo 1

    • 2-8. Pivot & unpivot Demo 2

    • 2-9. Merging Queries

    • 2-10. Append Queries

    • 2-11.Connecting a folder

    • 2-12. Data source sitting and refreshing in report

    • 2-13. Data type and categories in PBi

    • 2-14. Hierarchies in PBi

  • 3

    3. Table Relashionships and Data Model

    • 3-1.The issue and Data model

    • 3-2. Normalization and understand Data table & Data lookup

    • 3-3. Creating table relationship

    • 3-4. Snowflake schemas

    • 3-5. Editing relationship and Active vs. Inactive relationship

    • 3-6. Connect multiple data table

    • 3-7. Filter flow

    • 3-8. Bi direction ( two-way) direction filter

    • 3-9. Hiding fields from the report view

  • 4

    4. Analyzing Data with DAX

    • 4-1. Intro to DAX and calculated column

    • 4-2. Intro to measures

    • 4-3. Adding measures, Implicit vs. Explicit measures

    • 4-4. DAX Date & Time function 1

    • 4-4. DAX Date & Time function 2

    • 4-5.DAX. IF-OR-AND functions

    • 4-6. DAX, Common text functions

    • 4-7. DAX , Joining Data with related

    • 4-8. DAX, Math functions

    • 4-9. DAX. Count functions ( Count, COUNTA, Countrows, distinctcount)

    • 4-10. important

    • 4-11. DAX, Calculate function

    • 4-12. DAX, Calculate ALL

    • 4-13. DAX, Filter

    • 4-14. DAX, Iterator functions

    • 4-15. DAX, Time intelligence

  • 5

    5. Data Visualization with Power BI Desktop

    • 5-2. Basics of Visualization Data in Power BI

    • 5-3. Formatting options

    • 5-4. Filter Options

    • 5-5. Explore data with Matrix

    • 5-6. Filter Data with slicers

    • 5-7. Cards and KPI Visuals

    • 5-8. Text Cards

    • 5-9. Visualizing Data with Maps

    • 5-10. Visualizing Data with Treemaps

    • 5-11. Trendline and Area Chart

    • 5-12. Trendline with forecasts

    • 5-13. Goal pacing with guage chart

    • 5-14. Edit Report Interactions

    • 5-15, DrillThrough Filter

    • 5-16. Report Bookmarks

    • 5-17. What if analysis

    • 5-18. Managing and Viewing Roles

    • 5-19. More visuals, Mobile Layout and PBI Service