POWER BI Course content download.
INTRODUCTION TO POWER BI:
1
Introduction to Power BI – Need, Importance
2
Power BI – Advantages and Scalable Options
3
History – Power View, Power Query, Power Pivot
4
Power BI Data Source Library and DW Files
5
Cloud Collaboration and Usage Scope
6
Power BI Cloud and Power BI Service
7
Power BI Architecture and Data Access
8
On Premise Data Access and Microsoft On Drive
9
Power BI Desktop – Installation, Usage
10
Sample Reports and Visualization Controls
11
Power BI Cloud Account Configuration
12
Understanding Desktop & Mobile Editions
13
Report Rendering Options and End User Access
14
Power View and Power Map. Power BI Licenses
CREATING POWER BI REPORTS & AUTO FILTERS
1
Report Design with Legacy & .DAT Files
2
Report Design with Database Tables
3
Understanding Power BI Report Designer
4
Report Canvas, Report Pages: Creation, Renames
5
Report Visuals, Fields and UI Options
6
Experimenting Visual Interactions, Advantages
7
Reports with Multiple Pages and Advantages
8
Pages with Multiple Visualizations. Data Access
9
“GET DATA” Options and Report Fields, Filters
10
Report View Options: Full, Fit Page, Width Scale
11
Report Design using Databases & Queries
12
Navigation Options and Report Refresh
13
Stacked bar chart, Stacked column chart
14
Clustered bar chart, Clustered column chart
15
Adding Report Titles. Report Format Options
16
Focus Mode, Explore and Export Settings
REPORT VISUALIZATIONS & PROPERTIES
1
Power BI Design: Canvas, Visualizations and Fields
2
Import Data Options with Power BI Model, Advantages
3
Data Fields and Filters with Visualizations
4
Visualization Filters, Page Filters, Report Filters
5
Conditional Filters and Clearing. Testing Sets
6
General Properties, Sizing, Dimensions, and Positions
7
Alternate Text and Tiles. Header (Column, Row) Properties
8
Grid Properties (Vertical, Horizontal) and Styles
9
Table Styles & Alternate Row Colors – Static, Dynamic
10
Sparse, Flashy Rows, Condensed Table Reports. Focus Mode
11
Totals Computations, Background. Borders Properties
12
Column Headers, Column Formatting, Value Properties
13
Conditional Formatting Options – Color Scale
14
Page Level Filters and Report Level Filters
15
Visual-Level Filters and Format Options
16
Report Fields, Formats and Analytics
17
Page-Level Filters and Column Formatting, Filters
18
Background Properties, Borders and Lock Aspect
CHART AND MAP REPORT PROPERTIES
1
Chart report types and properties
2
Stacked bar chart, stacked column chart
3
Clustered bar chart, clustered column chart
4
100% stacked bar chart, 100% stacked column chart
5
Line charts, area charts, stacked area charts
6
Line and stacked row charts
7
Line and stacked column charts
8
Waterfall chart, scatter chart, pie chart
9
Field Properties: Axis, Legend, Value, Tooltip
10
Field Properties: Color Saturation, Filters Types
11
Formats: Legend, Axis, Data Labels, Plot Area
12
Data Labels: Visibility, Color and Display Units
13
Data Labels: Precision, Position, Text Options
14
Analytics: Constant Line, Position, Labels
15
Working with Waterfall Charts and Default Values
16
Modifying Legends and Visual Filters – Options
17
Map Reports: Working with Map Reports
18
Hierarchies: Grouping Multiple Report Fields
19
Hierarchy Levels and Usages in Visualizations
HIERARCHIES & DRILLDOWN REPORTS
1
Hierarchies and Drilldown Options
2
Hierarchy Levels and Drill Modes – Usage
3
Drill-thru Options with Tree Map and Pie Chart
4
Higher Levels and Next Level Navigation Options
5
Aggregates with Bottom/Up Navigations. Rules
6
Multi Field Aggregations and Hierarchies in Power BI
7
SEE DATA and SEE RECORDS Options. Differences
8
Toggle Options with Tabular Data. Filters
9
Drilldown Buttons and Mouse Hover Options @ Visuals
10
Dependent Aggregations, Independent Aggregations
11
Automated Records Selection with Tabular Data
12
Report Parameters: Creation and Data Type
13
Available Values and Default values. Member Values
14
Parameters for Column Data and Table / Query Filters
15
Parameters Creation – Query Mode, UI Option
16
Linking Parameters to Query Columns – Options
17
Edit Query Options and Parameter Manage Entries
18
Connection Parameters and Dynamic Data Sources
19
Synonyms – Creation and Usage Options
POWER QUERY & DATA MODELING
1
Understanding Power Query Editor – Options
2
Power BI Interface and Query / Dataset Edits
3
Working with Empty Tables and Load / Edits
4
Empty Table Names and Header Row Promotions
5
Undo Headers Options. Blank Columns Detection
6
Data Imports and Query Marking in Query Editor
7
Query Rename, Load Enable and Data Refresh Options
8
Combine Queries – Merge Join and Anti-Join Options
9
Combine Queries – Union and Union All as New Dataset
10
Creating Reference Tables and Queries
11
Custom Columns with Power Query
12
Power Query Expressions and Usage
13
IF..ELSE Conditions, Transform Column() Types
14
Using Parameters with M Language (Power Query Editor)
15
List Generation and Table Conversion Options
16
Aggregations using Power Query & Usage in Reports
17
Reports from Page collection with Power Query
18
Aggregate and Evaluate Options with M Language
DAX EXPRESSIONS
1
Purpose of Data Analysis Expressions (DAX)
2
Scope of Usage with DAX. Usability Options
3
DAX Context : Row Context and Filter Context
4
DAX Entities : Calculated Columns and Measures
5
DAX Data Types : Numeric, Boolean, Variant, Currency
6
Date time Data Type with DAX. Comparison with Excel
7
DAX Operators & Symbols. Usage. Operator Priority
8
Parenthesis, Comparison, Arithmetic, Text, Logic
9
DAX Functions and Types: Table Valued Functions
10
Filter, Aggregation and Time Intelligence Functions
11
Information Functions, Logical, Parent-Child Functions
POWERBI DEPLOYMENT & SHARING
1
PowerBI Report Validation and Publish
2
Understanding PowerBI Architecture
3
Reports and Dataset Items Validation
4
Dashboards and Pins – Real-time Usage
5
Dynamic Data Sources and Encryptions
6
Personal and Organizational Content Packs
7
Data Refresh with Power BI Architecture
8
PBIX and PBIT Files with Power BI – Usage
9
Visual Data Imports and Visual Schemas
10
Relation between Dashboards to Reports
11
Relation between Datasets to Reports
12
Relation between Datasets to Dashboards
13
Import and Export Options with Power BI
14
Dataset Navigations and Report Navigations
15
Quick Navigation Options with “My Workspace”
16
Dashboards, Workbooks, Reports, Datasets
17
Automatic Refresh – Possible Issues
18
Configuring Dataset for Manual Refresh of Data
19
Configuring Automatic Refresh and Schedules
ADDITIONAL BENEFITS
1
Real-time Project Exercise
2
Resume Preparation &
3
Interview Questions & Assignments
Be the first to add a review.
Please, login to leave a review