Data Transformation with Power Query / Query Edition

• Introduction to Power Query & Power Query Editor User Interface
• Data Processing, Data types and Filters in Power Query
• Inbuilt Column Transformations
• In built Row Transformations
• Combine Queries (Merge Queries & Append Queries)
• Merge Queries / Join Tables
• Append Queries / Union ALL Tables
• Query Options
• Home Tab Options
• Transform Tab Options
• Add Column Tab Options
• View Tab, Tools Tab & Help Tab Options

Inbuilt Column Transformations

• Remove Columns / Remove Other Columns
• Name / Rename a Column
• Reorder Columns or Sort Columns
• Add Column / Custom Column
• Split Columns / Merge Columns
• Pivot, Unpivot Columns
• Transpose Columns

Power View

• Report View / Power View
• Visuals Interactions
• Filters in Power View
• Hierarchies and Drill-Down Reports
• Power BI Visualizations
• Visuals for Filtering
• Visualizing Categorical Data
• Visualizing Trend Data
• Visualizing KPI Data
• Visualizing Tabular Data
• Visualizing Geographical Data
• Grouping, Binning & Sorting
• Tooltip Page
• Bookmarks, Selection Pane & Buttons

Introduction to DAX

• DAX Functions
• DAX Logical Functions
• Time Intelligence
• Power BI Visual Interactions (Ad-hoc filtering and highlighting)
• Grouping and Binning

Functions in DAX / DAX Functions Categories

• Filters, Drill through and Visual Interactions
• Grouping and Binning
• Sorting Data in Visuals in Power BI Desktop
• Hierarchies and Drill-Down in Power BI
• Visualizing Data
• Visualizing Trend Data

Power BI Service Introduction

• Access on-premises data from Power BI Service – Data Gateway
• App
• DATA WAREHOUSING CONCEPTS
• Bookmarks and Selection Pane
• MAP
• Tooltip Page

Live Projects and Case Studies

Live Project 1: Insurance Domain

• Overview of Insurance Business
• Insurance and Information Technology
• Insurance dependency on Business Intelligence and Data Warehouse
• Tableau as BI reporting tool in Insurance Domain

Live Project 2: Health Care Domain / Banking Domain

• Overview of Banking Business
• Banking and Information Technology
• Banking dependency on Business Intelligence and Data Warehouse
• Tableau as BI reporting tool in Banking Domain

Live Project 3: Retail Domain

• Overview of Retail Business
• Retail Industry and Information Technology
• Retail Industry dependency on Business Intelligence and Data Warehouse
• Tableau as BI reporting tool in Retail Domain