Power BI Course Topics Covered

Power Bi Training Part 02 Topics Covered

Power BI Course Part 02 Module 01: What is DAX?

~ Data types and operators
~ Formula syntax
~ The importance of naming conventions
~ Formatting DAX code
~ Writing comments in your codeSSBI Tools

Power BI Course Part 02 Module 02: DAX basics

~ Calculated columns v/s measures
~ DAX function types
~ Aggregation Functions
~ Iteration Functions
~ Table functions
~ CALCULATE function
~ DAX patterns
~ Working with one table versus many tables

Power BI Course Part 02 Module 03: Optimising your data model for DAX

~ Lookup Tables vs Fact Tables
~ How to build data models so that DAX actually works as expected

Power BI Course Part 02 Module 04: Getting started with DAX

~ Understanding context
~ How the DAX calculation engine works
~ Evaluation context
~ Filter context
~ Row context
~ Filter Propagation
~ SUM/AVERAGE/MIN/MAX
~ COUNT/COUNTA/COUNTROWS/COUNTBLANK
~ DIVIDE
~ SUMX/AVERAGEX/MINX/MAXX
~ IF
~ Calculated column examples

Power BI Course Part 02 Module 05: Expanding on CONTEXT

~ How Filter and Row context work with relationships
~ ISFILTERED / ISCROSSFILTERED
~ RELATED function

Power BI Course Part 02 Module 06: CALCULATE statement

~ Why CALCULATE is important
~ Why do you even have to use CALCULATE?
~ What can you do when you use CALCULATE
~ How are formula calculated when you involve CALCULATE
~ CALCULATE examples
~ Filtering with CALCULATE
~ Understanding context transition

Power BI Course Part 02 Module 07: Table Functions

~ FILTER
~ ALL
~ ALLSELECTED
~ ALLEXCEPT
~ VALUES/HASONEVALUE
~ USERELATIONSHIP

Power BI Course Part 02 Module 08: Common DAX examples

~ Cumulative totals
~ Averages per day
~ Moving averages

Power BI Course Part 02 Module 09: Time Intelligence Functions

~ What are time intelligence functions
~ Why you must have a date table
~ How to set up your data model
~ The importance of CONTEXT and the CALCULATE function
~ Types of time intelligence functions
~ Aggregations – YTD, QTD, MTD
~ Time comparisons – SAMEPERIODLASTYEAR, PARALLELPERIOD, PREVIOUSMONTH
~ Example of real world situations where you would use time intelligence functions

Power BI Course Part 02 Module 10: Advanced Table Functions

~ ADDCOLUMNS
~ SELECTCOLUMNS
~ SUMMARIZE
~ CROSSJOIN

Power BI Course Part 02 Module 11: Power Bi Service

~ Course Structure & Outline
~ Introducing Power BI Service
~ Account Tiers (Free/Pro/Premium)
~ Creating a New Account
~ Interface of Power Bi Service
~ Data Connection Options
~ Common Workspace Actions
~ My Workspace vs. App Workspaces
~ Creating an App Workspace
~ DEMO: Loading Data to App Workspaces
~ Gateways, Refresh & Dataflows
~ Understanding Gateways
~ Setting up a Personal Gateway
~ Enabling Scheduled Refresh
~ Setting up an Enterprise Gateway
~ Understanding Dataflows
~ Reports & Dashboards
~ Understanding Reports & Dashboards
~ Report Interface & Tools
~ Inserting & Formatting Visuals
~ DEMO: Adding Slicers & Matrix Visuals
~ Creating Data-Driven Alerts
~ Exploring Data with Q&A
~ Generating Quick Insights
~ Adding Personal Bookmarks
~ Designing for Web vs. Mobile
~ Sharing & Collaboration Options
~ Printing & Exporting
~ Publishing to the Web
~ Sharing Reports & Dashboards
~ Defining User Roles & Permissions
~ Generating Usage Reports
~ Configuring Row-Part Security
~ Publishing Apps
~ Power BI Mobile
~ Mobile App Features (iPhone)

Power BI Course Fee

(We provide Individual based Classroom training)

( Power BI Training for Corporates available )

Course Name	Course Duration	Course Fees	Fees (US $)
Power BI Training Part 01	20 sessions of 1 hr. each	10,000/-	$ 285
Power BI Training Part 02	20 sessions of 1 hr. each	12,500/-	$ 360
Power BI Training Part 01 & Part 02	40 sessions of 1 hr. each	22,500/-	$ 645