MBSI Microsoft Business Intelligence Online for graduates by Great Learning

Introduction To Power BI
Introduction To Power BI – Need, Importance
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 Online Training
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
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
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
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
POWER QUERY & M LANGUAGE
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
POWER QUERY & M LANGUAGE
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
Table Bars And Drill Thru Filters
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
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
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
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
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