POWER BI - Contents
Power Bi training in west delhi
Module 1
Power Bi training in west delhi
POWER BI
Power BI Desktop Installation
- Data Sources & Visual Types
- Canvas, Visualizations and Fields
- Get Data and Memory Tables
- In-Memory xvelocity Database
- Table and Tree Map Visuals
- Format Button and Data Labels
- Legend, Category and Grid
- PBIX and PBIT File Formats
- Visual Interaction, Data Points
- Disabling Visual Interactions
- Edit Interactions
- Format Options
- SPOTLIGHT & FOCUSMODE
- CSV and PDF Exports. Tooltips
- Power BI EcoSystem, Architecture
Visual Sync, Grouping
- Slicer Visual : Real-time Usage
- Orientation, Selection Properties
- Single & Multi Select, CTRL Options
- Slicer : Number, Text and Date Dat
- Slicer List and Slicer Dropdowns
- Visual Sync Limitations with Slicer
- Disabling Slicers,Clear Selections
- Grouping : Real-time Use, Examples
Hierarchies, Filters
- Creating Hierarchies in Power B
- Independent Drill-Down Options
- Dependant Drill-Down Options
- Conditional Drilldowns, Data Points
- Drill Up Buttons and Operations
- Expand & Show Next Level Options
- Dynamic Data Drills Limitations
- Show Data and See Records
- Filters : Types and Usage in Real-time
- Visual Filter, Page Filter, Report Filter
- Basic, Advanced and TOP N Filters
- Category and Summary Level Filters
- DrillThru Filters, Drill Thru Reports
- Keep All Filters” Options in DrillThru
- CrossReport Filters, Include, Exclude
Bookmarks, Azure, Modeling
- Drill-thru Filters, Page Navigations
- Bookmarks: Real-time Usage
- Bookmarks for Visual Filters
- Bookmarks for Page Navigations
- Selection Pane with Bookmarks
- Buttons, Images with Actions
- Buttons, Actions and Text URLs
- Bookmarks View & Selection Pane
- OLTP Databases, Big Data Sources
- Azure Database Access, Reports
- Import & Direct Query with Power BI
- SQL Queries and Enter Data
- Data Modeling : Currency, Relations
- Summary, Format, Synonyms
- Web View & Mobile View in PBI
Visualization Properties
- Stacked Charts and Clustered Charts
- Line Charts, Area Charts, Bar Charts
- 100% Stacked Bar & Column Charts
- Map Visuals: Tree, Filled, Bubble
- Cards, Funnel, Table, Matrix
- Scatter Chart : Play Axis, Labels
- Series Clusters & Selections
- Waterfall Chart and ArcGIS Maps
Power Query Level 1
- Power Query M Language Purpose
- Power Query Architecture and ETL
- Data Types, Literals and Values
- Power Query Transformation Types
- Table & Column Transformations
- Text & Number Transformations
- Date, Time and Structured Data
- List, Record and Table Structures
- let, source, in statements @ M Lang
- Power Query Functions, Parameters
- Invoke Functions, Execution Results
- Get Data, Table Creations and Edit
- Merge and Append Transformations
- Join Kinds, Advanced Editor, Apply
- ETL Operations with Power Query
Power Query Level 2
- Query Duplicate, Query Reference
- Group By and Advanced Options
- Aggregations with Power Query
- Transpose, Header Row Promotion
- Reverse Rows and Row Count
- Data Type Changes & Detection
- Replace Columns: Text, NonText
- Replace Nulls: Fill Up, Fill Down
- PIVOT, UNPIVOT Transformations
- Move Column and Split Column
- Extract, Format and Numbers
- Date & Time Transformations
- Deriving Year, Quarter, Month, Day
- Add Column : Query Expressions
- Query Step Inserts and Step Edits
Power Query Level 3
- Creating Parameters in Power Query
- Parameter Data Types, Default Lists
- Static/Dynamic Lists For Parameters
- Removing Columns and Duplicates
- Convert Tables to List Queries
- Linking Parameters to Queries
- Testing Parameters and PBI Canvas
- Multi-Valued Parameter Lists
