Master Power BI & Tableau: The Ultimate BI Skillset 

Business Intelligence: Power BI Course Content 📊🚀

Tech Bodhi IT Training offers a powerful combination of Power BI and Tableau courses to equip you with the most in-demand Business Intelligence skills. Our Power BI certification course is designed to help you master Power BI’s core features, including Power BI Desktop, DAX, Service, and Reports, while also integrating Tableau for advanced data visualization techniques. Prepare for the Microsoft PL-300 exam, work on real-world projects, and learn from industry experts. With this dual-focus program, you'll gain the edge you need to excel in the world of data analytics. 

Module 1: Introduction to Power BI 🏁

• Power BI Job Roles in Real-time 👔

• Power BI Data Analyst Job Roles 📈

• Business Analyst - Job Roles 👨‍💼

• Power BI Developer - Job Roles 👩‍💻

• Comparing Tableau and Power BI 🔄

• Types of Reports in Real-World 📑

  • Interactive & Paginated Reports 📊

  • Analytical & Mobile Reports 📱

• Data Sources Types in Power BI 🌐

• Power BI Licensing Plans 💼

• Power BI Dev & Prod Environments ⚙️

• Understanding the Power BI Tools 🛠️

• Installing Power BI & Connecting to Data 💻🔗

• Working with the Query Editor 🔍

• Building the Data Model & Creating Visualizations 🎨

Module 2: Basic Report Design 🖼️

• Data Sources & Visual Types 🗃️

• Canvas, Visualizations, and Fields 🎨

• Getting Data & Memory Tables 💾

• In-Memory XVelocity Database ⚡

• Table and Tree Map Visuals 🌳

• Format Button & Data Labels 🖌️

• Legend, Category, and Grid 📋

• PBIX and PBIT File Formats 📂

• Visual Interactions & Data Points 💡

• Disabling Visual Interactions 🚫

• Edit Interactions & Format Options 🛠️

• Spotlight & Focus Mode 🔦

• Tooltips 💬

• Power BI Ecosystem & Architecture 🌐

Module 3: Learn Basic & Advanced Charts 📈

• Stacked & Clustered Charts 📊

• Line, Area, & Bar Charts 📉

• 100% Stacked Bar & Column Charts ➕

• Map Visuals: Tree, Filled, Bubble 🗺️

• Cards, Funnel, Table, Matrix 🗃️

• Scatter Chart: Play Axis & Labels 🎯

• Series Clusters & Selections 🔄

• Waterfall Chart & ArcGIS Maps 🌊

• Infographics, Icons & Labels 🖼️

• Color Saturation & Sentiment Colors 🌈

• Column Series & Column Axis in Lines 🔢

• Join Types: Round, Bevel, Miter 🔗

• Shapes, Markers, Axis & Plot Area 🧩

• Display Units, Data Colors, Shapes 🎨

• Custom Series & Legends 📝

Module 4: Visual Sync & Grouping 🔀

• Slicer Visual: Real-time Usage 🍰

• Orientation & Selection Properties 🧭

• Single & Multi-Select (CTRL Options) ⌨️

• Slicer for Numbers, Text & Dates 🔢🔤📆

• Slicer List & Dropdowns ⬇️

• Visual Sync Limitations with Slicers 🚧

• Disabling Slicers & Clearing Selections 🚫

• Grouping: Real-time Examples 👥

• Bin Size & Bin Limits (Max, Min) 📏

• Bin Count & Grouping Options 🔢

Module 5: Hierarchies & Filters 🔍

• Creating Hierarchies in Power BI 🏛️

• Independent Drill-Down Options 🔽

• Dependent Drill-Down Options ⬇️

• Conditional Drilldowns & Data Points 🔄

• Drill Up Buttons & Operations 🔼

• Expand & Show Next Level Options 📈

• Dynamic Data Drill Limitations ⚠️

• Viewing Data & Records 📋

• Filters: Types & Real-time Usage

  • Visual, Page, & Report Filters

  • Basic, Advanced & TOP N Filters

  • Category & Summary Level Filters

  • Drill Thru Filters & Reports

  • “Keep All Filters” Options

  • Cross Report Filters, Include & Exclude

Module 6: Bookmarks & Options 🔖

• Drill-thru Filters & Page Navigations 🔄

• Real-time Bookmarks Usage 🔖

• Bookmarks for Visual Filters 👀

• Bookmarks for Page Navigations 🗺️

• Selection Pane with Bookmarks 📑

• Buttons & Images with Actions 🔘🖼️

• Text URLs & Button Actions 🔗

• Bookmarks View & Selection Pane 👁️

• Import & Direct Query with Power BI 💻

• SQL Queries & Data Entry ✍️

• Data Modeling & Relations 🔗

Module 7: Power Query Level 1 🔄

• Purpose of Power Query M Language 📜

• Power Query Architecture & ETL 🛠️

• Data Types, Literals & Values 🔢

• Transformation Types in Power Query 🔄

• Table & Column Transformations 📊

• Text & Number Transformations 🔠🔢

• Date, Time & Structured Data Transformations ⏰

• List, Record & Table Structures 🗂️

• Power Query Functions & Parameters 🔧

• Invoking Functions & Execution Results ✅

• Getting Data, Creating & Editing Tables 📝

• Merge & Append Transformations 🔗

• Join Kinds, Advanced Editor & Apply ✍️

• ETL Operations with Power Query 🚀

Module 8: Power Query Level 2 🔄

• Query Duplicate & Query Reference 🔁

• Group By & Advanced Options 🧮

• Aggregations with Power Query 📊

• Transpose & Header Row Promotion 🔀

• Reverse Rows & Row Count 🔄

• Data Type Changes & Detection 🛠️

• Replace Columns (Text, Non-text) 🔄

• Replace Nulls (Fill Up, Fill Down) ⬆️⬇️

• Pivot & Unpivot Transformations 🔄

• Moving & Splitting Columns ✂️

• Extract, Format & Number Operations 🔢

• Date & Time Transformations ⏰

• Deriving Year, Quarter, Month, Day 📆

• Adding Columns with Query Expressions ➕

• Inserting Query Steps & Editing Steps 📝

• Creating Parameters in Power Query 🔧

• Parameter Data Types & Default Lists 📋

• Removing Columns & Duplicates 🚫

• Converting Tables to List Queries 📑

• Testing Parameters on the PBI Canvas ✅

Module 9: DAX Functions - Level 1 📊

• Importance of DAX in Real-time 🌟

• Real-world Usage of Excel & DAX 📈

• DAX Architecture & Entity Sets 🏗️

• DAX Data Types & Syntax Rules 🔤

• Creating DAX Measures & Calculations ➕

• Understanding ROW Context & Filter Context 🔄

• DAX Operators & Special Characters ⚙️

• Types of DAX Functions in Real-time 🔍

• Creating & Using Measures with DAX 📏

• Creating & Using Columns with DAX 📊

• Quick Measures & Summaries ⚡

• Common Functions: SUM, AVERAGEX, KEEPFILTERS ➕

• Dynamic Expressions & IF in DAX 🔄

Module 10: DAX Functions - Level 2 📈

• Data Modeling Options in DAX 🏗️

• Detecting Relationships for DAX 🔍

• Using Calculated Columns in DAX ➕

• Aggregated Measures in DAX 🔢

• Working with Facts & Measures 📊

• Modeling Missing Relationships ⚠️

• Relationship Management 🔄

• CALCULATE Function Conditions ✅

• CALCULATE & ALL Member Scope 🔄

• Using RELATED & COUNTROWS 📏

• Dynamic Expressions & RETURN 🔄

• Date, Time & Text Functions ⏰

• Logical & Mathematical Functions ➕

• Running Total & EARLIER Function 🔢

Module 11: DAX Functions - Level 3 📊

• AVERAGEX & AVERAGE in DAX 🔄

• KEEPFILTERS & CALCULATE 🔄

• COUNTROWS, RELATED & DIVIDE ➗

• PARALLELPERIOD & DATEDADD ⏰

• CALCULATE & PREVIOUSMONTH 🔄

• USERELATIONSHIP & DAX Variables 🛠️

• TOTALYTD & TOTALQTD 📆

• Using DIVIDE & CALCULATE with Conditions ✅

• IF ELSE THEN Statements 🔀

• SELECTEDVALUE & FORMAT 🎨

• SUM & DATEDIFF Examples 📊

• TODAY, DATE & DAY Functions ⏰

• Time Intelligence Functions in DAX ⏳

Module 12: Power BI Cloud - 1 ☁️

• Power BI Service Architecture 🏗️

• Cloud Components & Usage 🌐

• App Workspaces & Report Publishing 📤

• Cloud-based Reports & Datasets 🌩️

• Creating New Reports in the Cloud 🆕

• Report Publishing & Uploads 📤

• Dashboard Creation & Usage 📊

• Adding Tiles to Dashboards ➕

• Pinning Visuals & Report Pages 📌

• Live Page Interactions in Dashboards 🔴

• Adding Media: Images & Custom Links 🖼️🔗

Module 13: Power BI Cloud - 2 ☁️

• Dashboard Actions & Report Actions 🔄

• Dataset Actions: Creating Reports 📑

• Sharing, Metrics & Exports 🔄

• Mobile View & Dashboard Themes 📱

• Q & A (Cortana) & Pinning Visuals ❓

• Export & Subscription Options 📤

• Featured Dashboards & Refresh 🔄

• Gateways Configuration in Power BI Service ⚙️

• Gateway Types & Cloud Connections 🌐

• Gateway Clusters & Adding Data Sources ➕

• Data Refresh (Manual & Automatic) 🔄

• Dataflows & Power Query Expressions 🔍

Module 14: Real-Time Project 🚀

• Project Requirement Analysis 📝

• Implementing SDLC Phases 🔄

• Requirement Gathering & FSA

  • Phase 1:

    • PBIX Report Design 🎨

    • Visualizations & Properties 🖼️

    • Analytics & Formatting 📊

  • Phase 2:

    • Data Modeling & Power Query 🔄

    • Dynamic Connections & Azure DB ☁️

    • Parameters & M Language Scripts 🛠️

  • Phase 3:

    • DAX Requirements & Analysis 📏

    • Cloud & Report Server Integration ☁️🖥️

    • Project FAQs & Solutions ❓

Module 15: Projects Coverage 💼

• Bank Customers Analysis Project 🏦

• Udemy Data Analysis 📊

• Retail Sales Analysis 🛍️

• Insurance Project 🛡️

• IPL Analysis 🏏

Bonus Session 🎁

• Real-Time Scenarios & Common Project Development Questions 💡