Power BI Desktop, Custom Visuals, Introduction to Power BI:- Power BI Component, Types of Reports in Real-time Usage, Power BI Tools and Implementation Plan Power BI Licensing and Excel Analytics. Power BI

Desktop Tool:-

• Report Visuals, Fields, Pages and Filters
• Data and Relationship Option, PBI Canvas
• Get Data from DAT Files, Excel Files, Access Files
• PBIX and PBIT Files And Re-Using Reports
• Data Import Options Designing Simple / Basics Reports in PBI
• Visual Interactions in Power BI - Options Spotlight Options with Visuals, Real-time Use
• Slicer Visual in Power BI and Data Filters

Hierarchies & Filters:-

• Grouping and Binning with Fields, Bin Size and Biz Limits (Max, Min)
• Creating Hierarchies. Drilldown, Drill Up Reports
• Filters : Types and Usage in Real-time, Conditional Filters, Visual Filters, Page Filters, Report Filters
• Drill-thru Filters with Hierarchy Levels TOP N Filters – Usage Filtering at Category Level, Import and Direct Query with Power BI.

Power Bi Visuals:-

• Fields, Formats and Analytics Options
• Table Visuals & Properties, Data Bar and Data Scaling Options
• Divergent Colors and Data Labeling Matrix : Sub Totals, Grand Totals
• Row Groups and Column Groups in Matrix
• Slicer Visual - Properties, Alignment Single Select and All Options
• Chart Reports - Common Properties Axis, Legend Types- Stacked Bar, Column, Line charts Clustered Bar, Column, Line Chart

Power Bi Visuals with Different Types:-

• Tree Map, Funnel and Gauge Reports, Map Reports
• Single Row Card and Multi Row Cards
• Callout Values in KPI Reports and Use, Indicator, Trend and Target Goals in KPIs
• Using Buttons, Images in Power BI Canvas
• Bookmarks in Power BI Desktop – Usage Using Bookmarks for Visual Filters

Module 4.2 - Data Modeling with Power Query Power Query Basic Operations:-

• Power Query Usage & Operation Types, QUERY Concept, Properties, Validations
• Power Query - Data Mash Up Operations
• Basic Data Types, Literals and Values, Expressions
• Primitives in M Language, Structured Data Values in Power Query
• LIST, RECORD, TABLE, Connection Format Settings let, source, in statements in M Lang Functions, Parameters in Power Query
• INVOKE Functions & Execution Results
• Power BI Canvas: Edits, Applied Steps, Frowns, Query Header Row Formatting

Power Query Usage:-

• Power Query Transformations Categories
• Query Combine & Merge Transformations, Join Options In Merge Transformation
• Truncate, Replace, Split, Reduce Rows, Manage Columns, Hide / Show Columns Grouping, Aggregations, Column Formats
• Transpose, Reverse Rows Transformations
• Power Query - Row Count And Replace, Data Type Detection - Scenarios, Use
• Data Type Conversions And Value Replace Fill Up And Fill Down,Pivot And Unpivot Transformations
• Move, Filter And Converttolist() Split, Format, Merge, Extract, Parse, Date,Time

Module 4.3 - Data Modeling with DAX DAX Functions: -

• DAX as library of Functions, Types, Variables, Operators Dax Formula With Excel, Limitations
• DAX Architecture and Entity Sets
• Rules OF DAX, Working Options, Syntax, Functions
• ROW Context and Filter Context, DAX Structures and Syntax Options
• Creating and Measuring with DAX Creating and Using Columns with DAX

Advance DAX Functions:- 

• Data Modeling Options in DAX, Detecting & Adding Relations for DAX
• Power BI DAX Functions - Types, Usage, Cheat Sheet
• Power BI Reports - DAX Functionalities Calculated Columns, Aggregated Measures
• Quick Measures in DAX - Auto validations, DAX Performance Date and Time & Text Functions, Logical & Mathematical Functions
• Data Modeling with DAX. Creating Roles
• SELECTEDVALUE, FORMAT Functions RELATED, COUNTROWS CALCULATE, SUM, ALL
• Report Development
• Live Project Session