Power BI for Beginner

Goals

What will you learn in this course:

• 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,Tooltip

• 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

• 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

• 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

• 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

• Creating Lists in Power Query,Converting Lists to Table Data,Advanced Edits and Parameters,Data Type Conversions, Expressions

• Columns From Examples, Indexes, Conditional Columns, Expressions

Prerequisites

What are the prerequisites for this course?

• Laptop with good configuration, Power BI Desktop software