Course curriculum

    1. Introduction to Power Query

    2. File 1 - Ex 1 _ 2

    3. File 1 - Ex 3

    4. File 1 - Ex 4_5_6

    5. File 1 - Ex 7_8_9

    6. File 1 - Saving

    7. File 2 - Task

    8. File 3 - Ex 1

    9. File 4 - Ex 1

    10. File 5 - Ex 1

    11. File 6 - Ex 1

    12. File 7 - Task

    13. Merging Queries- File 8

    14. Merging Queries - File 9

    15. Merging Queries - File 10 Task

    16. Unpivot Columns - File 11

    17. Unpivot Columns - File 12

    18. Grouping Data - File 13

    19. Get data from Website Basic

    1. Introduction to Data Model in Power BI

    2. Data Normalization vs Data DeNormalization

    3. Primary Key vs Foreign Key

    4. Fact Table vs Dimension Table

    1. Introduction to DAX Functions

    2. Calculated Columns vs Calculated Measures

    3. Text Functions

    4. Date and Time Functions

    5. Creating Calendar Table

    6. Logical Functions

    7. Aggregation Functions

    8. Filter Functions

    9. Time Intelligence Functions

    1. Data Visualization

    2. Bar and Column Chart

    3. Line and Area Chart

    4. Line and Column Chart

    5. Ribbon Chart

    6. Waterfall Chart

    7. Funnel Chart

    8. Scatter Chart

    9. Pie Chart

    10. Treemap

    11. Guage Chart

    12. Card Chart

    13. Slicer

    14. Table

    15. Matrix

    16. Key influencer

    17. Bookmarks

    18. Filters pane and Drill Through Filters

    1. Quiz

About this course

  • $499.00
  • 51 lessons
  • 6 hours of video content

Discover your potential, starting today

Enroll today