Power BI Training in Bangalore

CHAPTER 1: INTRODUCTION TO POWER BI (Free Demo)

• 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 Collaboration 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
• 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
• Report Rendering Options and End User Access
• Power View and Power Map. Power BI Licenses
• Course Plan – Power BI Online Training

CHAPTER 2: CREATING POWER BI REPORTS, AUTO FILTERS

• Report Design with Legacy & .DAT Files
• 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
• 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 3: REPORT VISUALIZATIONS and PROPERTIES

• Power BI Design: Canvas, Visualizations and Fields
• 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 Customized 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. 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

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 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
• Dependent Aggregations, Independent 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 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: Nested Join and Join Kind Functions
• REPLACE, REMOVE ROWS, REMOVE COL, BLANK – M Lang
• Column Splits and Filled Up / Filled Down Options
• Query Hide and Change Type Options. Code Generation

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 Enumeration Value Generation
• M Language Semitics and Syntax. Transform 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 through Filters