Power BI course from Basic Level

Goals

• 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,  and Multi-Valued Parameter Lists.

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

• Columns From Examples, Indexes, Conditional Columns, Expressions.

Prerequisites

• Laptop with good configuration, Power BI Desktop software.