Power Bi

In this Module you will learn how to clean, transform and load data, you will the process of profiling and understanding the condition of you data.

• Intro

  9:34

• Data Shaping

  -

• Enhancing data structure

  -

• Intro to designing Data model

  -

• Fact vs Dimension

  8:04

• Creating Hierarchy

  -

• Reviewing Data Model

  -

• Quiz

  -

In this module you will learn use DAX, DAX functions in Power BI for dynamic data analysis, including CALCULATE, SUMX, RANKX, DATEDIFF, LOOKUPVALUE, and more.

• Intro

  9:26

• Creating calculated column RankX Highest

  -

• Creating Calculated Column RankX Dense

  -

• Creating Measures

  -

• Timeline Intelligence Function

  -

• KPI 2

  -

• Additional KPI

  -

• Using Direct Query

  -

• Importance of variables

  -

• Building measures

  -

• Adding Measures

  -

• Quiz

  -

In this Module, you will the fundamental of designing and building a report.

• Intro

  -

• Filtering and Sorting Report

  -

• Sync Slicers

  -

• Creating Drill Through

  -

• Drill Through 2

  -

• Conditional Formatting

  -

• Accessibility Features

  -

• Creating Histograms

  -

• Accessibility Tab order

  -

• Intro Creating Dashboard

  -

• Creating Form from Push Data

  -

• Creating real-time data

  -

• Streaming Dataset

  -

• Accessing Power Automate

  -

• Enhancing DashBoard

  -

• Config DashBoard

  -

• More Dashboard Features

  -

• Quiz

  -

In this Module you will learn how to create paginated report, which can readily accessible as pdf, powerpoint or slides.

• Intro

  -

• Download report

  -

• Sorting Report

  -

• Creating Column Header

  -

• Pagination Report

  5:44

• Advance Analytic Grouping

  -

• Advance Drill Down

  12:40

• Data Insight

  -

• Using visuals

  -

• Creating Custom analytics

  7:26

• Quiz

  -

In this Module, you will learn how to manage reports, including how share contents, reports and dashboard, also how to assign dataset roles.

• Introduction to Managing Datasets

  -

• Creating and publishing Apps

  -

• Editing Parameters

  -