Microsoft Power BI Training In Marathahalli Bangalore

Power BI is a business analytics service by Microsoft. It aims to provide interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards.

Course Certification : Yes

Module 1

What you'll learn

The syllabus covers 

Power BI Desktop, Power BI Query Editor, Data Analysis Expressions (DAX), RLS (Row Level Security), Data Analysis, Power Bi Custom Visuals, Power BI Service, Installing and Configuring Gateway for your on-premise database,Tabular Model in SSAS.

At the end of this course students will be able to analyse data from different data sources and create their own Reports.

Components of the Course (Microsoft Power BI)

1) Power BI Desktop
2) Power BI service
3) Mobile Power BI app

  • Introduction to Power BI
  • Introduction to BI (Business Intelligence)
  • Introduction to Tables
  • Introduction to Joins
  • Introduction to Data Modelling
  • Star and snowflake schema
  • Introduction to data visualization
  • Installing Power BI Desktop
  • Components of Power BI
  • Introduction to Power Query Editor
  • Importing Data to Power BI Desktop
  • Joins in Power BI
  • Creating Basic Visualizations in Power BI Desktop
  • What is Visual, Page and Report in Power BI
  • Publishing Power BI .pbix file  to Power BI Service
  • Creating Workspaces in Power BI Service
  • Sharing content to the users in the Organization

Module 2

  • Power BI Desktop and Power BI Service
  • Exploring the Sales Data
  • Identifying Metrics and Attributes in Sales Data
  • Understanding the Sales Data model
  • Creating relationships between tables in Relationships tab.
  • Creating Simple measures and columns
  • Difference between New measure and calculated column

Module 3

This module introduces to DAX (Data Analysis Expressions), this is the most important topic in
Power BI Desktop.
Aggregate Functions
  • SUM
  • SUMX
  • AVERAGE
  • MIN
  • MAX
  • DIVIDE
Count Functions
  • COUNT
  • COUNTDISTINCT
  • COUNTA
  • COUNTROWS
Logical Functions
  • CALCULATE
  • AND
  • OR
  • IF
  • ISBLANK
  • ISERROR

Module 4

Intermediate level DAX
  • CONCATENATE
  • COMBINEVALUES
  • FILTER
  • ALL
  • ALLSELECTED
  • ALLEXCEPT
Time-intelligence DAX
  • DATEADD
  • DATEDIFF
  • DATESBETWEEN
  • DATEYTD
  • DATEQTD
  • DATEMTD
  • PARALLELPERIOD
  • TOTALMTD
  • TOTALQTD
  • TOTALYTD
Power Query editor:
  • Transforming data
  • Perform a range of query editing skills in Power BI
  • Add, Merge, Delete Columns
  • Creating new Tables, combine or merge tables.
  • Shape data, using formatting and transformations.

Module 5

Interactive Data Visualizations
  • Creating Power BI reports
  • Working on Power Custom Visuals
  • My Workspace and APP Workspace
  • Working on App Workspace
  • Security Set-up in Workspace
  • Scheduling Refresh in Datasets
  • App creation in Power BI
  • Dashboards and Tiles in Power BI Service
  • Content Packs
  • RLS Security
  • Managing a Power BI solution

Module 6

Power BI mobile app
  • Power BI mobile apps
  • Using the Power BI mobile app
  • Power BI embedded
Power BI Web data
  • Get Data from Web
  • Creating Power BI Report based on Web data
  • Workspace and App creation of for the Web Report.
  • Power BI embedded
Marketing Analytics
  • Metrics in Marketing Analytics
  • Flow of Marketing Data
  • Marketing Analytics Dashboard
Finally Resume Preparation, Mock-up interviews
Upcoming Batches