What you’ll learn:
Module1: Basic Report Design: Power BI Desktop Installation,Architecture of Power BI,Data sources and Visual Types,Canvas, Visualization and fields
Format Button and data labels,Legend, Category and Grid,Visual Interaction, Data Points,Edit Interaction,Format Options,PBIX and PBIT File Formats
Spotlight and Focus Mode,Tooltips
Module2: Visual Sync, Grouping,Slicer Visual: Real-Time Usage,Orientation, Selection Properties,Single and Multi-Select, Ctrl Options
Slicer: Number, Text and Date Data,Slicer List and Slicer Drop Down,Visual sync,Disabling Slicer,Clear selection Limitation with slicers
Module 3: Hierarchies, Filters:Creating Hierarchies in Power BI,Independent Drill-Down Options,Dependent 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,Drill Thru Filters, Drill Thru Reports
Drill-thru Filters, Page Navigations,Bookmarks: Real-time Usage,Bookmarks for Visual Filters, Bookmarks for Page Navigation
Selection Pane with Bookmarks Buttons, Images with Actions Buttons, Actions and Text URLs, Bookmarks View & Selection Pane
Import & Direct Query with Power BI,SQL Queries and Enter Data,Data Modelling : Currency, Relations, Summary, Format, Synonyms,Web View & Mobile View
Module 8: Power Query Level 1,Power Query M Language Purpose,Power Query Architecture and ETL, Data Types, Literals and Values,Power Query Transformation
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, Parameter,Invoke Functions, Execution Results
Get Data, Table Creations and Edit,Merge and Append Transformations, Join Kinds, Advanced Editor, Apply ETL Operations with Power Query
Module 9: Power Query Level 2 Query Duplicate, Query Reference,Group By and Advanced Options,Aggregations with Power Query
