Course 1

Microsoft Power BI Training

• Upcoming Batches
• Curriculum

  Sl. No.	Chapter
  Chapter - 1	Power BI –A Complete Package Introduction
  Chapter - 1.1	Introduction to Power BI
  Chapter - 1.2	Components of Power BI
  Chapter - 1.3	Installing Power BI Desktop
  Chapter - 1.4	Various Options in Power BI Desktop
  Chapter - 2	Working with Different Sources (Excel, SQL Server, OData Feed etc.)
  Chapter - 2.1	Import
  Chapter - 2.2	Direct Query
  Chapter - 2.3	Import vs Direct Query
  Chapter - 2.4	Limitations of Direct Query
  Chapter - 2.5	Query Editor
  Chapter - 2.6	Working with Power Query Editor
  Chapter - 2.7	Relationships (1:1, 1: Many, Many:1)
  Chapter - 2.8	Basics of M Language
  Chapter - 3	Reports Development
  Chapter - 3.1	Reports Development in Power BI
  Chapter - 3.2	Working with Different Visuals
  Chapter - 3.3	Formatting Options in Reports
  Chapter - 3.4	Working with Filters
  Chapter - 3.5	Custom Visuals
  Chapter - 4	Power BI Service (Power BI service domain account will be provided to hands on Service)
  Chapter - 4.1	Overview of Power BI Service
  Chapter - 4.2	Publishing the Reports
  Chapter - 4.3	Dashboards
  Chapter - 4.4	Gateways
  Chapter - 4.5	Enterprise vs Personal Gateway
  Chapter - 4.6	Work Spaces
  Chapter - 4.7	Content Packs/ Apps
  Chapter - 4.8	Security
  Chapter - 4.9	Schedule Data Refresh
  Chapter - 4.10	Power BI Premium
  Chapter - 5	SSAS Tabular
  Chapter - 5.1	SSAS Tabular Overview
  Chapter - 5.2	Install and Configure SSAS Tabular
  Chapter - 5.3	Building a Tabular Model
  Chapter - 5.4	SSAS Tabular as Source
  Chapter - 5.5	Live Connections
  Chapter - 5.6	Deploy & Processing in Tabular
  Chapter - 5.7	SQL Server Agent
  Chapter - 5.9	Schedule Processing of Model
  Chapter - 6	Data Analysis Expressions (DAX)
  Chapter - 6.1	Introduction to DAX
  Chapter - 6.2	Calculated Columns
  Chapter - 6.3	Measures
  Chapter - 6.4	Calculated Columns vs Measures
  Chapter - 6.5	Variables
  Chapter - 6.6	Table Functions
  Chapter - 6.7	Evaluation Contexts
  Chapter - 6.8	Calculate
  Chapter - 6.9	Time Intelligence in DAX
  Chapter - 6.10	Frequently Used DAX functions in Real time
  Chapter - 6.11	Calendar Functions
  Chapter - 7	Advanced/ Other Power BI Concepts
  Chapter - 7.1	Parameters
  Chapter - 7.2	Drill Through
  Chapter - 7.3	Bookmarks
  Chapter - 7.4	Row level Security
  Chapter - 7.5	Dynamic Measures
  Chapter - 7.6	Dynamic Axis in Charts
  Chapter - 7.7	Dynamic Filters
  Chapter - 7.8	Power BI Template file
  Chapter - 7.9	Wallpapers
  Chapter - 7.10	Themes
  Chapter - 7.11	Q&A
  Chapter - 7.12	Editing the Themes
  Chapter - 7.13	Power BI Updates
  Chapter - 8	Live Project
  Chapter - 8.1	Course Prerequisites
  Chapter - 8.2	Before attending Analyzing Data with Power BI course, students must have:
  Chapter - 8.3	Good understanding of relational databases and reporting.
  Chapter - 8.4	Some basic knowledge of data warehouse schema topology (including star and snowflake schemas).
  Chapter - 8.5	Fundamental understanding of basic programming constructs (such as looping and branching).
  Chapter - 8.6	Basic knowledge of key business priorities such as revenue, profitability, and financial accounting
  Chapter - 8.7	Familiarity with Microsoft Office applications particularly Excel.

Read More