PowerBI - Classroom Training at SQL School Training Institute

September 25, 2017

Complete Real-time and Practical Power BI Training with Real-time Scenarios. Power BI is a cloud-based, elegant end-to-end business analytics tool that enables anyone to visualize, analyze, forecast any type of data with greater speed, efficiency, and understanding. It connects users to a broad range of data through easy-to-use dashboards, interactive reports and compelling visualizations for your day to day corporate business needs in Cloud & On-premise.

Trainer: Mr. Sai Phanindra T (11+ Yrs EXP). Profile

** If above schedule does not work for you, please find below options :

Option 1: PowerBI Training Videos - On-demand, 24x7 Access
Option 2: Interactive Training from other experienced faculty

ALL SESSIONS ARE COMPLETELY PRACTICAL, REAL-TIME.
Total Course Fee: 6000/- [USD 100]. Dur: 2 Weeks / 3 Wknds

Highlights : Basic to Adv. DAX M * Language Custom * Visualizations * Advanced Reports Custom * Dashboards Azure Integration

Power BI Training Course Contents:

Brochure:

CHAPTER 1 : INTRODUCTION TO POWER BI (Free Demo)

Introduction to Power BI - Need, Imprtance
Power BI - Advantages and Scalable Options
History - Power View, Power Query, Power Pivot
Power BI Data Source Library and DW Files
Cloud Colloboration and Usage Scope
Business Analyst Tools, MS Cloud Tools
Power BI Installation and Cloud Account
Power BI Cloud and Power BI Service
Power BI Architecture and Data Access
OnPremise Data Acces and Microsoft On Drive
Power BI Desktop - Instalation, Usage
Sample Reports and Visualization Controls
Power BI Cloud Account Configuration
Understanding Desktop & Mobile Editions
Report Rendering Options and End User Access
Power View and Power Map. Power BI Licenses
Course Plan - Power BI Classroom Training

CHAPTER 8 : DAX EXPRESSIONS - Level 1

Purpose of Data Analysis Expresssions (DAX)
Scope of Usage with DAX. Usabilty Options
DAX Context : Row Context and Filter Context
DAX Entities : Calculated Columns and Measures
DAX Data Types : Numeric, Boolean, Variant, Currency
Datetime Data Tye with DAX. Comparison with Excel
DAX Operators & Symbols. Usage. Operator Priority
Parenthesis, Comparison, Arthmetic, Text, Logic
DAX Functions and Types: Table Valued Functions
Filter, Aggregation and Time Intelligence Functions
Information Functions, Logical, Parent-Child Functions
Statistical and Text Functions. Formulas and Queries
Syntax Requirements with DAX. Differences with Excel
Naming Conventions and DAX Format Representation
Working with Special Characters in Table Names
Attribute / Column Scope with DAX - Examples
Measure / Column Scope with DAX - Examples

CHAPTER 2 : CREATING POWER BI REPORTS, AUTO FILTERS

Report Design with Legacy & .DAT Files
Report Design with Databse Tables
Understanding Power BI Report Designer
Report Canvas, Report Pages: Creation, Renames
Report Visuals, Fields and UI Options
Experimenting Visual Interactions, Advantages
Reports with Multiple Pages and Advantages
Pages with Multiple Visualizations. Data Access
PUBLISH Options and Report Verification in Cloud
"GET DATA" Options and Report Fields, Filters
Report View Options: Full, Fit Page, Width Scale
Report Design using Databases & Queries
Query Settings and Data Preloads
Navigation Options and Report Refresh
Stacked bar chart, Stacked column chart
Clustered bar chart, Clustered column chart
Adding Report Titles. Report Format Options
Focus Mode, Explore and Export Settings

CHAPTER 9 : DAX EXPRESSIONS - Level 2

YTD, QTD, MTD Calculations with DAX
DAX Calculations and Measures
Using TOPN, RANKX, RANK.EQ
Computations using STDEV & VAR
SAMPLE Function, COUNTALL, ISERROR
ISTEXT, DATEFORMAT, TIMEFORMAT
Time Intelligence Functions with DAX
Data Analysis Expressions and Functions
DATESYTD, DATESQTD, DATESMTD
ENDOFYEAR, ENDOFQUARTER,ENDOFMONTH
FIRSTDATE, LASTDATE, DATESBETWEEN
CLOSINGBALANCEYEAR,CLOSINGBALANCEQTR
SAMEPERIOD and PREVIOUSMONTH,QUARTER
KPIs with DAX. Vertipaq Queries in DAX
IF..ELSEIF.. Conditions with DAX
Slicing and Dicing Options with Columns, Measures
DAX for Query Extraction, Data Mashup Operations
Calcualted COlumns and Calculated Measures with DAX

CHAPTER 3 : REPORT VISUALIZATIONS and PROPERTIES

Power BI Design: Canvas, Visualizations and Fileds
Import Data Options with Power BI Model, Advantages
Direct Query Options and Real-time (LIVE) Data Access
Data Fields and Filters with Visualizations
Visualization Filters, Page Filters, Report Filters
Conditional Filters and Clearing. Testing Sets
Creating Customised Tables with Power BI Editor
General Properties, Sizing, Dimensions, and Positions
Alternate Text and Tiles. Header (Column, Row) Properties
Grid Properties (Vertical, Horizontal) and Styles
Table Styles & Alternate Row Colors - Static, Dynamic
Sparse, Flashy Rows, Condensed Table Reports. Focus Mode
Totals Computations, Background. Boders Properties
Column Headers, Column Formatting, Value Properties
Conditional Formatting Options - Color Scale
Page Level Filters and Report Level Filters
Visual-Level Filters and Format Options
Report Fields, Formats and Analytics
Page-Level Filters and Column Formatting, Filters
Background Properties, Borders and Lock Aspect

CHAPTER 10 : POWERBI DEPLOYMENT & CLOUD

PowerBI Report Validation and Publish
Understanding PowerBI Cloud Architecture
PowerBI Cloud Account and Workspace
Reports and DataSet Items Validation
Dashboards and Pins - Real-time Usage
Dynamic Data Sources and Encryptions
Personal and Organizational Content Packs
Gateways, Subscriptions, Mobile Reports
Data Refresh with Power BI Architecture
PBIX and PBIT Files with Power BI - Usage
Visual Data Imprts and Visual Schemas
Cloud and On-Premise Data Sources
How PowerBI Supports Data Model?
Relation between Dashbaords to Reports
Relation between Datasets to Reports
Relation between Datasets to Dashbaords
Page to Report - Mapping Options
Publish Options and Data Import Options
Need for PINS @ Visuals and PINS @ Reports
Need for Data Streams and Cloud Intergration

CHAPTER 4 : CHART AND MAP REPORT PROPERTIES

CHART Report Types and Properties
STACKED BAR CHART, STACKED COLUMN CHART
CLUSTERED BAR CHART, CLUSTERED COLUMN CHART
100% STACKED BAR CHART, 100% STACKED COLUMN CHART
LINE CHARTS, AREA CHARTS, STACKED AREA CHARTS
LINE AND STACKED ROW CHARTS
LINE AND STACKED COLUMN CHARTS
WATERFALL CHART, SCATTER CHART, PIE CHART
Field Properties: Axis, Legend, Value, Tooltip
Field Properties: Color Saturation, Filters Types
Formats: Legend, Axis, Data Labels, Plot Area
Data Labels: Visibility, Color and Display Units
Data Labels: Precision, Position, Text Options
Analytics: Constant Line, Position, Labels
Working with Waterfall Charts and Default Values
Modifying Legends and Visual Filters - Options
Map Reports: Working with Map Reports
Hierarchies: Grouping Multiple Report Fields
Hierarchy Levels and Usages in Visualizations
Preordered Attribute Collection - Advantages
Using Field Hierarchies with Chart Reports
Advanced Query Mode @ Connection Settings - Options
Direct Import and In-memory Loads, Advantages

CHAPTER 11 : POWER BI CLOUD OPERATIONS

Report Publish Options and Verifications
Working with Power BI Cloud Interface & Options
Navigation Paths with "My Workspace" Screens
FILE, VIEW, EDIT REPORTS, ACCESS, DRILLDOWN
Saving Reports into pdf, pptx, etc. Report Embed
Report Rendering and EDIT, SAVE, Print Options
Report PIN and individual Visual PIN Options
Create and Use Dashboards. Menu Options
Goto Dashboard and Goto LIVE Page Options
Operations on Pinned Reports and Visuals
TITLE, MEDIA, USAGE METRICS & FAVOURITES
SUBSCRIPTION Options and Reports with Mobile View
Options with Report Page : Print and Subscribe
Report Actions: USAGE METRICS, ANALYSE IN EXCEL
Report Actions: RELATED ITEMS, RENAME, DELETE
Dashboard Actions: METRICS, RELATED ITEMS
Dashboard Actions: SETTINGS FOR Q & A, DELETE
PIN Actions: METRICS, SHARE, RELATED ITEMS
PIN Actions: SETTINGS FOR Q & A, DELETE
EDIT DASHBOARD (CLOUD), On-The-Fly Reports
Dataset Actions: CREATE REPORT, REFRESH
SCHEDULED REFRESH & RELATED ITEMS
Dashboard Integration with Apps in Power BI

CHAPTER 5 : HIERARCHIES and DRILLDOWN REPORTS

Hierarchies and Drilldown Options
Hierarchy Levels and Drill Modes - Usage
Drill-thru Options with Tree Map and Pie Chart
Higher Levels and Next Level Navigation Options
Aggregates with Bottom/Up Navigations. Rules
Multi Field Aggregations and Hierarchies in Power BI
DRILLDOWN, SHOWNEXTLEVEL, EXPANDTONEXTLEVEL
SEE DATA and SEE RECORDS Options. Differences
Toggle Options with Tabular Data. Filters
Drilldown Buttons and Mouse Hover Options @ Visuals
Dependant Aggregations, Independant Aggregations
Automated Records Selection with Tabular Data
Report Parameters : Creation and Data Type
Available Values and Default values. Member Values
Parameters for Column Data and Table / Query Filters
Parameters Creation - Query Mode, UI Option
Linking Parameters to Query Columns - Options
Edit Query Options and Parameter Manage Entries
Connection Parameters and Dynamic Data Sources
Synonyms - Creation and Usage Options

CHAPTER 12 : IMPROVING POWER BI REPORTS

Publish PowerBI Report Templates
Import and Export Options with Power BI
Dataset Navigations and Report Navigations
Quick Navigation Options with "My Workspace"
Dashboards, Workbooks, Reports, Datasets
Working with MY WORK SPACE group
Installing the Power BI Personal Gateway
Automatic Refresh - Possible Issues
Adding images to the dashboards
Reading & Editing Power BI Views
Power BI Templates (pbit)- Creation, Usage
Managing report in Power BI Services
PowerBI Gateway - Download and Installation
Personal and Enterprise Gateway Features
PowerBI Settings : Dataset - Gateway Integration
Configuring Dataset for Manual Refresh of Data
Configuring Automatic Refresh and Schdules
Workbooks and Alerts with Power BI
Dataset Actions and Refresh Settings with Gateway
Using natural Language Q&A to data - Cortana

CHAPTER 6 : POWER QUERY & M LANGUAGE - Part 1

Understanding Power Query Editor - Options
Power BI Interface and Query / Dataset Edits
Working with Empty Tables and Load / Edits
Empty Table Names and Header Row Promotions
Undo Headers Options. Blank Columns Detection
Data Imports and Query Marking in Query Editor
JSON Files & Binary Formats with Power Query
JavaScript Object Notation - Usage with M Lang.
Applied Steps and Usage Options. Revert Options
creating Query Groups and Query References. Usage
Query Rename, Load Enable and Data Refresh Options
Combine Queries - Merge Join and Anti-Join Options
Combine Queries - Union and Union All as New Dataset
M Language : NestedJoin and JoinKind Functions
REPLACE, REMOVE ROWS, REMOVE COL, BLANK - M Lang
Column Splits and FilledUp / FilledDown Options
Query Hide and Change Type Options. Code Generation

CHAPTER 13 : INSIGHTS AND SUBSCRIPTIONS

Data Navigation Paths and Data Splits
Getting data from existing systems
Data Refresh and LIVE Connections
pbit and pbix : differences. Usage Options
Quick Insights For Power BI Reports
Quick Insights For PowerBI Dashboads
Generating Insights with Cloud Datasets
Generarting Reports with Cloud Datasets
Using relational databases on-premises
Using relational databases in the cloud
Consuming a service content pack
Creating a custom data set from a service
Creating a content pack for your organization
Consuming an organizational content pack
Updating an organizational content pack
Adding Tiles : Images, Videos, DataStreams
Creating New Reports from Cortana, Advantages

CHAPTER 7 : POWER QUERY & M LANGUAGE - Part 2

Invoke Function and Freezing Columns
Creating Reference Tables and Queries
Detection and Removal of Query Datasets
Custom Columns with Power Query
Power Query Expressions and Usage
Blank Queries and Enumuration Value Generation
M Language Sematics and Syntax. Tranform Types
IF..ELSE Conditions, TransformColumn() Types
RemoveColumns(), SplitColumns(),ReplaceValue()
Table.Distinct Options and GROUP BY Options
Table.Group(), Table.Sort() with Type Conversions
PIVOT Operation and Table.Pivot(). List Functions
Using Parameters with M Language (Power Query Editor)
Advanced Query Editor and Parameter Scripts
List Generation and Table Conversion Options
Aggregations using PowerQuery & Usage in Reports
Report Generation using Web Pages & HTML Tables
Reports from Page collection with Power Query
Aggregate and Evaluate Options with M Language
Creating high-density reports, ArcGIS Maps, ESRI Files
Generating QR Codes for Reports

CHAPTER 14 : POWERBI INTEGRATION ELEMENTS

SSRS Integration with Power BI
SSRS Report Portal URL to Power BI Cloud
Power BI KPI Reports Vs SSRS KPI Reports
Convering and Working with Mobile Reports
Report Buidler Reports to Powert BI
Generating QR Codes and Report Security
Reporting JSON Files, Bulk Data Loads
Creating high-density Reports in Power BI
OLAP DataSources in Power BI
Using MDX Queries with PowerBI Queries
MDX SELECT and Perspective Access
KPIs and MDX Expressions with Power BI
MDX Queries and Filters with Power BI
Linked Servers and T-SQL SPROCs with MDX
YTD, PARALLELPERIOD,SCOPE, ALLMEMBERS
WHERE, EXCEPT, RANGE, NONEMPTY
CURRENT & EMPTY, AND / OR, LEFT / RIGHT
SCOPE, THIS, THIS, FREEZE Functions
Choosing between DAX and MDX
Using R for Power BI Reports and Dashboards
Streaming DataSets with Microsoft R

Sign In