Power BI

VBA training in Nepal

Power BI Course Content

 

Day 1:

Get Power BI Desktop

Getting started with Power BI Desktop

Overview of Power BI

 

Day 2:

Data Sources in Power BI Desktop

Import Excel Workbooks

Data Type in Power BI Desktop

Explore Pivot Feature

 

Day 3:

Data import from Folder

Append multiples files

Transforming Data (Combine Files)

Joins (Left, Right, Inner, Outer)

Transforming Data (Merging Queries)

Refresh the data

 

Day 4:

Data Connect from multiple source

Delimited text files

JSON file

XML file

Connect to web data

Data Transformation

Transforming Data (Appending Queries)

Transforming Data (M Query Basics)

 

Day 5:

Connect to API

We will take some available examples

 

Day 6:

Pivot feature in Power BI

Unpivot feature in Power BI

Advance Data Transformation

 

Day 7:

Introduction to Modeling Data

Data Mappping (Relationship between tables)

One to One

One to Many

Many to Many

 

Day 8:

Introduction to Database connection from Power BI Desktop

Connect Access Database

Connect Oracle Database (If available in your machine)

Connect MySQL Databas (If available in your machine)

Connect SQL Server Database (If available in your machine)

 

Day 9:

Basics DAX

Creating Calculated Columns

Navigation Functions

Conditional and Logical Functions

Calculated tables

Creating Calculated Measures (Measure Basics)

Creating Calculated Measures (Time Intelligence Functions)

 

Day 10:

Advanced DAX

Working with Variables

Working with Filter Context (What is Filter Context?)

Working with Filter Context (CALCULATE)

Working with Filter Context (Overriding Filter Context)

Working with Filter Context (FILTER)

Working with Filter Context (FILTER and ALL)

Working with Filter Context (ALLEXCEPT)

Working with Filter Context (Totals)

 

Day 11:

Advanced DAX Function (CONTAINS)

Advanced DAX Function (FIND)

Advanced DAX Function (SEARCH and SUBSTITUTE)

Advanced DAX Function (ALLSELECTED)

Introduction to Visualization in Power BI Desktop

Branding (Size, Header, Spacing, Footer)

 

Day 12:

Introduction to Visualization in Power BI Desktop

Branding (Size, Header, Spacing, Footer)

Insert Image, Shape, Text Box

Creating Basic Reports with the Power BI Desktop

Start Data Visualization

 

Day 13:

  • Bar Chart
  • Column Chart
  • Line Chart
  • Area Chart
  • Ribbon Chart
  • Pie Chart
  • Combo Chart
  • Bubble Chart
  • Scatter Chart
  • Donut Chart
  • Gauge Chart
  • Funnel Chart
  • Waterfall Chart
  • Single Number Chart
  • Multi row Chart
  • KPI Chart
  • Table Chart
  • Matrix Chart
  • Tree Map
  • Slicer
  • Map
  • Filled Map

Day 14:

Using the Power BI Service (Deploying to the Power BI Service)

Using the Power BI Service (Creating and Sharing Dashboards)

Using the Power BI Service (Setting up App Workspaces)

Using the Power BI Service (Concept of Report, Dashboard, Power BI App)

Using the Power BI Service (Concept on development environment and production environment)

Using the Power BI Service (Subscriptions and Alerts)

Using the Power BI Service (Export and Embed Options)

 

Day 15:

Refreshing the Data (Refreshing Data Overview)

Refreshing the Data (Installing the Data Gateway)

Refreshing the Data (Scheduling a Data Refresh)

Understand End to End process for a Power BI Dashboard.