🔢 IsNumber – Check if a value is a number
📝 IsText – Check if a value is text
✂️ Trim – Remove extra spaces from text
⬅️ Left – Extract a substring from the left
➡️ Right – Extract a substring from the right
🔍 Find – Find a substring (case-sensitive)
🔎 Search – Find a substring (case-insensitive)
📏 Mid – Extract text from the middle
🔢 Len – Count characters in a text
🔠 Upper – Convert text to uppercase
🔡 Lower – Convert text to lowercase
🔤 Char – Get the character from an ASCII code
🔢 Code – Get the ASCII code of a character
🔗 Concatenate – Combine multiple text strings
💲 Dollar – Format a number as currency
🔢 Fixed – Round a number with fixed decimals
🆕 Proper – Capitalize the first letter of each word
🔄 Substitute – Replace specific text in a string
🔁 Replace – Replace text based on position
🔢 Rept – Repeat a text multiple times
🧹 Clean – Remove non-printable characters
🔗 Join Strings – Merge multiple text values
🔢 Counting Words – Count words in a cell
🔍 Number of Instances – Count occurrences of a substring
📊 Text to Columns – Split text into columns
⚖️ Compare Text – Check if two text values match
✅ Exact – Compare two strings exactly
🔢 Row – Get the row number of a cell
📊 Row in Array Formula – Use row function inside arrays
🔢 Column – Get the column number of a cell
📊 Column in Array Formula – Use column function inside arrays
📍 Address – Get the address of a cell
📏 Offset – Reference a cell by offsetting rows/columns
🔄 Transpose – Convert rows to columns and vice versa
📌 Indirect – Create a reference from text
🔗 Hyperlink – Create a clickable link
📊 GetPivotData – Extract data from a Pivot Table
🎯 Choose – Select a value from a list
🔎 Vlookup – Find a value in a vertical range
🔎 Hlookup – Find a value in a horizontal range
📋 Index – Get a value from a range
📋 Index (Two-Dimensional) – Retrieve values from a table
📋 Index (Three-Dimensional) – Retrieve values across multiple sheets
🎯 Match – Find the position of a value
🔄 Lookups with Match – Combine lookup functions
❌ IsErr – Check for any error except #N/A
⚠️ IsError – Check for any error
🚫 IsNA – Check if the error is #N/A
🤔 If – Perform conditional logic
🏗 Nested Ifs – Use multiple If conditions
✅ True – Returns TRUE
❌ False – Returns FALSE
🛑 And – Check if multiple conditions are TRUE
🔄 Or – Check if at least one condition is TRUE
🚫 Not – Reverse a logical condition
📆 Date – Create a date value
📅 Today – Get today’s date
⏰ Now – Get current date and time
🔢 Day – Extract the day from a date
🔢 Month – Extract the month from a date
🔢 Year – Extract the year from a date
🏢 Networkdays – Count working days between two dates
📆 Weekday – Get the day of the week
📆 Workday – Get a future/past working day
🔢 DATEDIF – Calculate difference between dates
🔄 Entering Array Formulas – Work with multiple cell formulas
✅ Benefits of using Array Formulas – Speed and efficiency
➕ Sumproduct for Multiple Condition Summarization
🔀 Sumproduct with And & Or Conditions
➕ SumIf – Summarize with one condition
🔢 Countif – Count based on one condition
➕ Sumifs – Summarize with multiple conditions
🔢 Countifs – Count with multiple conditions
⚠️ Resolving Version Conflicts
📊 Subtotal – Calculate subtotals
🃏 Using Wildcards – Handle partial matches
💳 PMT – Calculate loan payments
💰 FV – Future value of an investment
💲 PV – Present value of an investment
📈 RATE – Calculate interest rate
🎲 Rand Between – Generate random numbers
🎰 Rand – Generate a random decimal
🔢 Random Numbers – Create randomized lists
📆 Random Dates – Generate random dates
⏰ Random Time – Generate random time
🔤 Random Characters – Generate random text
🔗 Generating Dependent Random Texts
📊 Text to Columns Using Form Controls
🎚 Option Button – Create form controls
⬇️ Drop Down – Create selection lists
🔄 Scroll Bars – Use scroll controls
🎨 Conditional Formatting – Format cells dynamically
🌡 Creating Heat Chart – Visualize data with colors
📊 Using Data Bars – Create in-cell bar charts
🎥 Recording Macro – Automate tasks
🎛 Assigning Macro to Buttons – Run macros with buttons
⌨️ Assigning Shortcut Keys to Macro – Quick macro execution
⚠️ Points to be Noted While Using Macro Recorder
🔽 Filtering Data – Show only what’s needed
📈 Sorting Data – Arrange data in order
📋 Sorting by Custom List – Custom sorting rules
🔄 Sorting by Rows – Sort horizontally
📌 Getting Unique List – Remove duplicates
🔗 Getting Unique Combinations – Filter complex lists
🎯 Getting Only Desired Columns – Extract specific data
🎯 And / Or Criteria – Advanced filtering
📊 Creating Pivot Table – Summarize large data
🎭 Summarizing Data into Years/Qtrs/Months
📊 Creating Pivot Charts – Visualize pivot data
🔢 Using Calculated Fields – Custom calculations
🔄 Trace Precedent – Identify cell dependencies
🔄 Trace Dependent – Find which cells use a formula
❌ Clear Arrows – Remove trace visuals
❓ What is Tableau? – An overview of Tableau's capabilities
🖥️ Tableau Products Overview (Public, Desktop, Server, Cloud) – Understand the various Tableau offerings
🔗 Connecting to Different Data Sources (Excel, CSV, Databases) – Learn how to connect to multiple data sources
🔄 Understanding Live vs. Extract Connections – Compare real-time connections with data extracts
📂 Data Pane Overview (Dimensions vs. Measures) – Distinguish between dimensions and measures
🔍 Filtering & Sorting Data – Master the art of data organization
🏗️ Creating Hierarchies & Groups – Organize data into meaningful groups and hierarchies
⚙️ Working with Data Types & Changing Field Properties – Customize your data for analysis
📊 Creating Bar Charts, Line Charts, and Pie Charts – Build foundational visualizations
🔥 Working with Heatmaps & Highlight Tables – Visualize data intensity and comparisons
🔀 Using Dual-Axis Charts & Combined Charts – Learn to overlay multiple data sets effectively
➕ Understanding Aggregations (SUM, AVG, COUNT) – Grasp the basics of summarizing data
🧮 Basic Calculated Fields – Create custom calculations to enrich your analysis
📈 Introduction to Table Calculations (Running Total, Percent of Total) – Dive into advanced data computations
🎨 Customizing Colors & Labels – Enhance visuals with tailored aesthetics
💬 Using Annotations & Tooltips – Add context and insights directly on your visualizations
⚡ Conditional Formatting – Dynamically format visuals based on data criteria
🔍 Applying Quick Filters & Context Filters – Quickly narrow down your data view
⚙️ Creating Parameters for Dynamic Interactions – Empower users with interactive controls
🔀 Sorting Data Dynamically – Arrange data in real-time based on user input
🖥️ Creating a Basic Dashboard Layout – Assemble your visualizations into a coherent dashboard
🕹️ Adding Filters & Actions for Interactivity – Enable user-driven exploration within your dashboard
📦 Using Containers & Floating Elements – Optimize dashboard design with layout tools
🚀 Mini Project: Create a Dashboard with Sample Data – Apply your skills in a practical project
📤 Publishing & Sharing Options – Learn how to distribute your dashboards effectively
⚡ Best Practices for Performance Optimization – Ensure your dashboards run smoothly and efficiently
📖 Introduction to Databases
🗄 Introduction to RDBMS
🔄 Explain RDBMS through Normalization
🔍 Different Types of RDBMS
💾 Software Installation (MySQL Workbench)
⚙️ Types of SQL Commands (DDL, DML, DQL, DCL, TCL) and Their Applications
🔢 Data Types in SQL (Numeric, Char, Datetime)
🔍 SELECT
⏩ LIMIT
🌟 DISTINCT
🔍 WHERE AND
🔀 OR
📥 IN
🚫 NOT IN
↔️ BETWEEN
✅ EXIST
❓ ISNULL
❌ IS NOT NULL
🔤 Wild Cards
🔄 ORDER BY
🔀 Usage of Case When Then to Solve Logical Problems
❓ Handling NULL Values (IFNULL, COALESCE)
🔢 Group By
🔍 Having Clause
🔢 COUNT
➕ SUM
📈 AVG
🔻 MIN
🔺 MAX
🔤 COUNT String Functions
⏰ Date & Time Functions
🚫 NOT NULL
🔒 UNIQUE
✔️ CHECK
🆕 DEFAULT
🔑 Primary Key
🔗 Foreign Key (Both at Column Level and Table Level)
🤝 Inner Join
⬅️ Left Join
➡️ Right Join
🔀 Cross Join
🔄 Self Join
🌐 Full Outer Join
🆕 Create
❌ Drop
🔄 Alter
🔀 Rename
🚮 Truncate
🔧 Modify
💬 Comment
✍️ DML Commands: Insert, Update & Delete
🔄 TCL Commands: Commit, Rollback, Savepoint
📂 Data Partitioning
🔍 Indexes (Different Types of Indexes)
👁 Views in SQL
⚙️ Stored Procedures
🔧 Procedure with IN Parameter
🔄 Procedure with OUT Parameter
🔀 Procedure with INOUT Parameter
👤 User-Defined Functions
📊 Window Functions
🏆 Rank
🎖 Dense Rank
⬆️ Lead
⬇️ Lag
📝 Row_Number
🔗 Union, Union All
🔄 Intersect
🔍 Sub-Queries, Multiple Query
🚨 Handling Exceptions in a Query
🔄 CONTINUE Handler
🚪 EXIT Handler
⏰ Triggers - Before | After DML Statement
Tech Bodhi IT Training’s Power BI certification course is curated by subject matter experts to help you clear the official Microsoft Power BI Data Analyst Exam: PL-300 . This course will help you gain expertise in Business Analytics and throughout the training, you will master the concepts such as Power BI Desktop, Architecture, DAX, Service, Mobile Apps, Reports, QGA, and many more with industry-relevant use cases. This Power BI training ensuresthat you get hands-on experience in real-time projects. Learn Power BI from experienced industry experts.
👥 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 - Types
⚙️ Power BI Dev & Prod Environments
🛠 Understanding the Power BI Tools
💻 Installing Power BI & Connecting to Data
🔍 Working with the Query Editor
📊 Working with the Data Model and Creating a Visualization
🔗 Data Sources & Visual Types
🎨 Canvas, Visualizations and Fields
📥 Get Data and Memory Tables
⚡ In-Memory xVelocity Database
📋 Table and Tree Map Visuals
🖌 Format Button and Data Labels
🗺 Legend, Category and Grid
💾 PBIX and PBIT File Formats
🔄 Visual Interaction, Data Points
🚫 Disabling Visual Interactions
🛠 Edit Interactions - Format Options
🔦 SPOTLIGHT & FOCUS MODE
💬 Tooltips
🌐 Power BI Ecosystem & Architecture
📊 Stacked Charts and Clustered Charts
📈 Line Charts, Area Charts, 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 and ArcGIS Maps
🖼 Infographics, Icons and 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
📋 Series, Custom Series and Legends
🗂 Slicer Visual: Real-Time Usage
📐 Orientation & Selection Properties
🔢 Single & Multi-Select, CTRL Options
🔤 Slicer: Number, Text & Date Data
📋 Slicer List & Slicer Dropdowns
🚫 Visual Sync Limitations with Slicer
❌ Disabling Slicers & Clearing Selections
🔗 Grouping: Real-Time Use & Examples
📏 Bin Size and Bin Limits (Max, Min)
🔢 Bin Count and Grouping Options
🏛 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 Drills Limitations
👀 Show Data & See Records
🔎 Filters: Types and Usage in Real-Time
📊 Visual Filter, Page Filter & Report Filter
🎯 Basic, Advanced & TOP N Filters
📑 Category & Summary Level Filters
🚀 Drill-Thru Filters & Drill-Thru Reports
🔄 Keep All Filters Option in Drill-Thru
🔗 Cross Report Filters: Include & Exclude
🚪 Drill-Thru Filters & Page Navigations
🔖 Bookmarks: Real-Time Usage
🔍 Bookmarks for Visual Filters
📄 Bookmarks for Page Navigations
📝 Selection Pane with Bookmarks
🔘 Buttons & Images with Actions
🔗 Buttons, Actions & Text URLs
👀 Bookmarks View & Selection Pane
🔄 Import & Direct Query with Power BI
📝 SQL Queries & Enter Data
🔗 Data Modeling & Relations
📝 Power Query M Language Purpose
🏗 Power Query Architecture & ETL
🔤 Data Types, Literals & Values
🔄 Power Query Transformation Types
📊 Table & Column Transformations
🔢 Text & Number Transformations
📆 Date, Time & Structured Data
📋 List, Record & Table Structures
🔧 Power Query Functions & Parameters
🔄 Invoke Functions & Execution Results
🛠 Get Data, Table Creations & Edits
🔗 Merge & Append Transformations
🔀 Join Kinds, Advanced Editor & Apply
🔄 ETL Operations with Power Query
🔄 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
↔️ Move Column & Split Column
🔍 Extract, Format & Numbers
📆 Date & Time Transformations
📅 Deriving Year, Quarter, Month & Day
➕ Add Column: Query Expressions
📝 Query Step Inserts & Step Edits
🔧 Creating Parameters in Power Query
🔣 Parameter Data Types & Default Lists
🚫 Removing Columns & Duplicates
🔄 Convert Tables to List Queries
✅ Testing Parameters on the PBI Canvas
💡 DAX: Importance in Real-Time
📊 Real-World Usage of Excel & DAX
🏗 DAX Architecture & Entity Sets
🔤 DAX Data Types & Syntax Rules
➕ DAX Measures & Calculations
🔍 ROW Context & Filter Context
➗ DAX Operators & Special Characters
📚 DAX Functions: Types in Real-Time
🛠 Creating & Using Measures with DAX
📝 Creating & Using Calculated Columns with DAX
⏱ Quick Measures & Summaries
➕ SUM, AVERAGEX & KEEPFILTERS
🔄 Dynamic Expressions & IF in DAX
🏗 Data Modeling Options in DAX
🔍 Detecting Relationships for DAX
📊 Using Calculated Columns in DAX
➕ Using Aggregated Measures in DAX
📈 Working with Facts & Measures
🔄 Modeling: Handling Missing Relationships
🔗 Modeling: Relationship Management
⚙️ CALCULATE Function Conditions
🔄 CALCULATE & ALL Member Scope
🔗 RELATED & COUNTROWS in DAX
🔄 Dynamic Expressions & RETURN
📆 Date, Time & Text Functions
🔢 Logical & Mathematical Functions
⏱ Running Total & EARLIER Function
📊 AVERAGEX & AVERAGE in DAX
🔄 KEEPRFILTERS & CALCULATE
🔢 COUNTROWS, RELATED & DIVIDE
⏩ PARALLELPERIOD & DATEDADD
🔙 CALCULATE & PREVIOUSMONTH
🔗 USERELATIONSHIP & DAX Variables
🗓 TOTALYTD & TOTALQTD
🔢 DIVIDE, CALCULATE & Conditions
📝 IF-ELSE-THEN Statement
🎯 SELECTEDVALUE & FORMAT
➕ SUM & DATEDIFF Examples in DAX
📆 TODAY, DATE & DAY with DAX
⏳ Time Intelligence Functions – DAX
🏛 Power BI Service Architecture
☁️ Power BI Cloud Components & Uses
🏢 App Workspaces & Report Publishing
📊 Reports & Related Datasets in the Cloud
✨ Creating New Reports in the Cloud
🚀 Report Publishing & Uploads
📊 Dashboard Creation & Usage
📌 Adding Tiles to Dashboards
📍 Pinning Visuals & Report Pages
🔗 Visual Pin Actions in Dashboards
🔄 LIVE Page Interaction in Dashboards
🖼 Adding Media: Images & Custom Links
🕹 Dashboard Actions & Report Actions
📊 Dataset Actions: Creating Reports
🤝 Sharing, Metrics & Exports
📱 Mobile View & Dashboard Themes
❓ Q & A [Cortana] & Pin Visuals
📤 Export, Subscribe & Notifications
⭐ Featured Dashboards & Refresh Options
🔌 Gateways Configuration in PBI Service
🌐 Gateway Types & Cloud Connections
🔗 Gateway Clusters & Adding Data Sources
🔄 Data Refresh: Manual & Automatic
🔄 Dataflows & Power Query Expressions
📝 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 Deployment
❓ Project FAQs & Solution