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
- Power BI Cloud and Power BI Service
- Power BI Architecture and Data Access
- On Premise Data Access and Microsoft On Drive
- Power BI Desktop – Installation, Usage
- Sample Reports and Visualization Controls
- Power BI Cloud Account Configuration
- Understanding Desktop & Mobile Editions
- Power View and Power Map. Power BI Licenses
CREATING POWER BI REPORTS, AUTO FILTERS
- Report Design with Database 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
- “GET DATA” Options and Filters
- Report View Options: Full, Fit Page, Width Scale
- Report Design using Databases & Queries
- 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 & PROPERTIES
- Power BI Design: Canvas, Visualizations and Fields
- Import Data Options with Power BI Model, Advantages
- Data Fields and Filters with Visualizations
- Visualization Filters, Page Filters, Report Filters
- Conditional Filters and Clearing. Testing Sets
- 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. Borders 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 Visuals.
- Modifying Legends and Visual Filters – Options
- Map Reports: Working with Map Reports
- Hierarchies: Grouping Multiple Report Fields
- Hierarchy Levels and Usages in Visualizations
HIERARCHIES & 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 Hierarchiesin Power BI
- Toggle Options with Tabular Data. Filters
- Drilldown Buttons and Mouse Hover Options @ Visuals
- Dependent Aggregations, Independent Aggregations
- 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 & DATA MODELING
- 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
- 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
- Creating Reference Tables and Queries
- Custom Columns with Power Query
- Power Query Expressions and Usage
- Transform Column() Types
- Using M Language (Power Query Editor)
- List Generation and Table Conversion Options
- Aggregations using Power Query & Usage in Reports
- Reports from Page collection with Power Query
- Aggregate and Evaluate Options with M Language
DAX EXPRESSIONS
- Purpose of Data Analysis Expressions (DAX)
- Scope of Usage with DAX. Usability Options
- DAX Context : Row Context and Filter Context
- DAX Entities : Calculated Columns and Measures
- DAX Operators & Symbols. Usage. Operator Priority
- DAX Functions and Types: Table Valued Functions
- Filter, Aggregation and Time Intelligence Functions
- Logical, Date & Time, Text(String) Functions
POWER BI DEPLOYMENT & SHARING
- Power BI Report Validation and Publish
- Understanding Power BI Architecture
- Reports and Dataset Items Validation
- Dashboards and Pins – Real-time Usage
- Dynamic Data Sources and Encryptions
- Personal and Organizational Content Packs
- Data Refresh with Power BI Architecture
- PBIX and PBIT Files with Power BI – Usage
- Visual Data Imports and Visual Schemas
- Relation between Dashboards to Reports
- Relation between Datasets to Reports
- Relation between Datasets to Dashboards
- Import and Export Options with Power BI
- Dataset Navigations and Report Navigations
- Quick Navigation Options with “My Workspace”
- Dashboards, Workbooks, Reports, Datasets
- Automatic Refresh – Possible Issues
- Configuring Dataset for Manual Refresh of Data
- Configuring Automatic Refresh and Schedules
ADDITIONAL BENEFITS
- Real-time Project Exercise
- Resume Preparation &
- Interview Questions& Assignments
There are no items in the curriculum yet.
