4-month live training, 6 hours per weekend (3 hours each on
Saturday and Sunday)
Training mode: Fully Interactive Live Online class with class
recoding
This course is designed to take you from a beginner to an advanced
user of Power BI.
Whether you are aspiring Data analyst, Power BI Developer looking
to unlock the power of data, this course will provide you with the
skills needed to create impactful reports and dashboards.
We designed our training sessions carefully to be super-efficient.
Your time is precious, and so is ours. Our aim is to get you job
ready in the quickest time possible
Prerequisite: Prior knowledge of Excel is beneficial for learning
Power BI but not strictly needed.
Section 1: Introduction to Power Bi
Section 2: Data Sources and Connectors
Section 4: Power BI Basics: Power Query, Modeling, and DAX
Section 5: Power BI Visuals
Section 6: Power Query: Transforming & Shaping Data
Section 6.1: Transforming & Shaping Data
Section 6.1.1: Transform Table
Section 6.1.2: Transform Columns
Section 6.1.3: Combine Data
Section 6.1.4: Split Columns
Section 6.1.5: Text Formatting Functions
Section 6.1.6: Extracting Text
Section 7: Data modeling in Power BI
Section 8: Data Analysis using DAX Functions
Section 8.1: Introduction to (DAX)
Section 8.2: DAX Aggregate Functions
Section 8.3: Counting Function Dax
Section 8.4: Logical Functions
Section 8.5: DAX Text Functions
Section 8.6: DAX Date Functions
Section 8.7: Advanced DAX Functions
Section 8.8: Time Intelligence Functions
Section 8.9: Advanced DAX Concepts
Section 8.10: CALCULATE and CALCULATETABLE Functions
Section 8.12: Filter Functions (context modification in DAX)
Section 8.13: Table Functions
Section 9: Introducing Power Bi Service
Section 9.1: Connecting to Data
Section 9.2: Administering the Power BI Service
Section 9.3: Refresh Schedules & Content administration
Section 9.4: Sharing Administration
Section 9.14: Building Paginated Reports
Section 10: Integrating AI and Machine Learning with Power BI
Section 11: dax query
Section 12: Power Bi Hands-on Real-World Projects list
Section 13: Power Bi Interview Essentials.
SECTION 1: INTRODUCTION TO POWER BI
Introduction to Power BI - Need, Importance
History - Power View, Power Query, Power Pivot
Power BI Installation and Cloud Account
Power BI Cloud and Power BI Service
Power BI Architecture and Data Access
Power BI Desktop - Instillation, Usage
Take a quick tour of the Power BI interface.
Understanding Power BI Report Designer
Report Canvas, Report Pages: Creation, Renames, View Options:
Full, Fit Page, Width Scale
Report Visuals, Fields and UI Options, Focus Mode, Explore and
Export Settings
Power BI Cloud Account Configuration
Course Plan - Power BI Online Training
SECTION 2: DATA SOURCES AND CONNECTORS
Explore various data connectors and their types
Connect to a variety of data sources, databases, Excel files, and
cloud storage services
Direct Query Options and Real-time (LIVE) Data Access Connecting
to SharePoint folders
SECTION 4: POWER BI BASICS: POWER QUERY, MODELING, AND DAX
Create and use calculated columns and measures
Basic data transformation using power query
CALCULATE Fundamental function for context modification
SECTION 5: POWER BI VISUALS
Work with advanced features like drill-through, bookmarks, and
custom tooltips
Create a variety of charts and graphs, including bar charts, line
charts, pie charts, and more
Explore themes for report design
Manage roles, apply conditional formatting, and configure small
multiples
Visual-Level Filters and Format Options
Page Level Filters and Report Level Filters
Page-Level Filters and Column Formatting, Filters
Report Fields, Formats and Analytics
SECTION 6: POWER QUERY: TRANSFORMING & SHAPING DATA
Authentication with a data source and Manage connections
Get data in Power BI Desktop
SECTION 6.1: TRANSFORMING & SHAPING DATA
Promote or demote column headers
SECTION 6.1.1: TRANSFORM TABLE
Choose or remove columns
Filter a table (Text Filter, Number Filter and by row position)
Pivot and Unpivot columns
Grouping or summarizing rows
Data types in Power Query Dealing with errors in Power Query
Transpose a table and Reverse rows
SECTION 6.1.2: TRANSFORM COLUMNS
Working with duplicate values
Sort columns and Rename columns
Fill values in a column
Replace values and errors
Move columns
Add an index column
Add a column from examples
Add a conditional column
Add a custom column
Append queries
SECTION 6.1.3: COMBINE DATA
Merge queries
Combine Files
SECTION 6.1.5: TEXT FORMATTING FUNCTIONS
SECTION 6.1.4: SPLIT COLUMNS
SECTION 6.1.6: EXTRACTING TEXT
SECTION 7: DATA MODELING IN POWER BI
Modeling view user interface
Hide table and column form Data model
Display Folder
Understanding Of Dimension table & Fact table
Star schema data models
Types of cardinalities Managing relationships in Power BI
SECTION 8: DATA ANALYSIS USING DAX FUNCTIONS
SECTION 8.1: INTRODUCTION TO (DAX)
Overview of Data Analysis Expressions (DAX)
Create and use calculated columns and measures
Understanding the Importance of Data Modeling and Data
Visualization
Filter Context & Row Context
SECTION 8.2: DAX AGGREGATE FUNCTIONS
Introduction to DAX Aggregate Functions
CALCULATE Fundamental function for context modification
SUM, SUMX, MIN, MAX, and AVERAGE Functions
SECTION 8.3: COUNTING FUNCTION DAX
COUNT, COUNTA, COUNTAX, COUNTROWS, COUNTX, COUNTBLANK &
DISTINCTCOUNT
SECTION 8.4: LOGICAL FUNCTIONS
Introduction to Logical Functions: AND, OR, NOT, IF, IFERROR,
TRUE, False
SECTION 8.5: DAX TEXT FUNCTIONS
Text Functions: COMBINEVALUES, SEARCH, FIND, EXACT, and TRIM
CONCATENATE, REPLACE, LEFT, RIGHT, MID, LEN, SUBSTITUTE, FIXED,
and FORMAT
SECTION 8.6: DAX DATE FUNCTIONS
Date Functions: MINUTE, HOUR, DAY, MONTH, QUARTER, YEAR, EDate,
EOMonth
WEEKDAY, WEEKNUM, DATE, TODAY, NOW, CALENDAR, and CALENDAR AUTO
SECTION 8.7: ADVANCED DAX FUNCTIONS
MAX, MAXA, MAXX
FIRSTNONBLANKVALUE, LASTNONBLANKVALUE
GENERATESERIES, EXCEPT, All, ALLEXCEPT ALLSELECTED, SELECTEDVALUE,
VALUE, ERROR, IN, UPPER, LOWER
PARENT, CHILD, PARALLELPERIOD, TopN, GROUPBY
SECTION 8.8: TIME INTELLIGENCE FUNCTIONS
TOTALYTD, TOTALQTD, TOTALMTD
DATESYTD, DATESQTD, DATESMTD
SAMEPERIODLASTYEAR, PARALLELPERIOD, PREVIOUSMONTH, NEXTMONTH
DATEDIFF, DATESBETWEEN, DATESINPERIOD, DATEADD
SECTION 8.9: ADVANCED DAX CONCEPTS
Dynamic URLs and Dynamic Data
DAX CONTAINSSTRING & CONTAINSSTRINGEXACT
DAX IN, DAX CONTAINSROW, and Overview of DAX Operators
FILTER Context in Power BI
CROSSFILTERING and Relationship Management
SECTION 8.10: CALCULATE AND CALCULATETABLE FUNCTIONS
Understanding DAX CALCULATE and DAX CALCULATETABLE
Counting Working Days between Two Dates
Lookup for Multiple Values in a Table
SECTION 8.12: FILTER FUNCTIONS (CONTEXT MODIFICATION IN DAX)
ALL, ALLEXCEPT, ALLSELECTED, KEEPFILTERS, REMOVEFILTERS, CALCULATE
VALUES, DISTINCT, RELATEDTABLE
USERELATIONSHIP, EARLIER, FILTER
SECTION 8.13: TABLE FUNCTIONS
SUMMARIZE, SUMMARIZECOLUMNS
RELATED, RELATEDTABLE.
SECTION 9: INTRODUCING POWER BI SERVICE
Introducing Power BI Service
Quick Tour of the Interface
Building Blocks of PBI Service
SECTION 9.1: CONNECTING TO DATA
Data Connecting Options
Loading Local Data to a Workspace
Centralizing Data Cleansing with Dataflows
Centralizing Data with Shared Datasets
SECTION 9.2: ADMINISTERING THE POWER BI SERVICE
Overview of Workspace Administration
Designing Workspace Structures
Workspace Creation
Workspace Settings
Assigning Workspace Roles
Using Deployment Pipelines
Understanding Data Gateways
Granting Access to Datasets
SECTION 9.3: REFRESH SCHEDULES & CONTENT ADMINISTRATION
Creating Refresh Schedules
Implementing Incremental Refresh
Creating Subscriptions
Configuring Data Alerts
On premises gateway configuration SECTION 9.4: SHARING
ADMINISTRATION
Publishing & Updating App
Using Publish to Web
Giving Access to External Users
Allowing Users to Export Reports
SECTION 9.14: BUILDING PAGINATED REPORTS
Installing Power BI Report Builder
Create a blank report
Configure the report header
Create a data source and dataset
Configure the report parameter
Add textboxes to report header region
Add a table to the report
Format the table data region
Finalize the report design
SECTION 10: INTEGRATING AI AND MACHINE LEARNING WITH POWER BI
Explore features such as anomaly detection, smart narratives, Q&A
visuals, and the decomposition tree
Learn how to use AI and machine learning to create more powerful
and insightful reports and dashboards.
SECTION 11: DAX QUERY
DEFINE: Specify a concept or term within a context
EVALUATE: Assess the performance or significance of a process or
data
MEASURE: Quantify the extent or value of a specific attribute
ORDER BY: Command to sort data in a specified sequence
START AT: Indicate the initial position within a sequence or
process
VAR: Declare, assign, or manipulate a variable
COLUMN: Vertical arrangement of data in a table or spreadsheet
TABLE: Define or reference a structured set of data.
SECTION 12: POWER BI HANDS-ON REAL-WORLD PROJECTS LIST
Sales and Revenue Analysis
Human Resources Analytics
Social Media Analytics.
SECTION 13: POWER BI INTERVIEW ESSENTIALS
Common Interview Questions: Prepare for typical Power BI interview
queries
Resume Building: Learn strategies to highlight Power BI ability on
your resume effectively
Career Path Exploration: Explore various Power BI career paths for
informed professional decisions
Networking Strategies: Develop effective networking skills within
the Power BI community.
Portfolio Development: Create a
compelling Power BI portfolio to highlight practical skills and
accomplishments.
1. Introducing Microsoft Excel
2. Data entry: Click, type, edit.
Undo/redo mistakes!
3. Work with Sheets: Add, rename, delete,
move.
4. Select like a pro: Single cells, ranges, rows, columns.
5. Cut, copy, paste: Spread data like butter.
6. Row & column
wrangling: Insert, delete, move, hide.
7. Cell makeovers: Resize,
style, format, borders, shades.
8. Format painter: Copy-paste
styles in a flash.
1. Cells: Enter, edit, select, copy, move, add, delete.
2. Text: Align, rotate, wrap for tidy display.
3. Merge: Combine cells for bigger impact.
4. Numbers & Dates: Dress them up with formats.
5. De-Dupe: Say goodbye to doubles.
6. Go To Special: Find cells hiding in plain sight.
7. Data Grab & Shape: Import, transform, conquer!
8. Consolidate: Unite data from far and wide.
1. Find it: Built-in, online, or homemade.
2. Use it: Fill, edit, adapt as needed.
3. Benefits: Save time, ensure consistency, boost accuracy.
4. Pro tips: Build your own, automate tasks, explore add-ins.
1. AutoSum & Fill: Magic buttons for totals.
2. Clear: Poof! Content or formatting gone.
3. Flash Fill: Detects patterns, fills data like magic.
4. Wildcards: Find & replace anything with special symbols.
5. Find & Replace: Search and swap text easily.
6. Sort: Organize data in a blink.
7. Filter: Focus on what matters, hide the rest.
8. Text to Columns: Split text into separate columns.
9. Paste Special: Choose what gets pasted, values or fancy formatting.
10. Group & Outline: Collapse and expand data like a tree.
1. Illustration Group: Pictures, shapes, SmartArt, screenshots for visual flair.
2. Drawing Tools: Style, fill, outline, effects to beautify your objects.
3. Insert Tab Bonus: Tables, charts, links, text boxes, symbols - add anything!
1. Insert Function: Search and insert built-in functions into cells.
2. Name Manager: Create and manage named ranges for easier referencing.
3. Formula Auditing:
I. Trace and audit formulas for error detection and understanding relationships.
II. Trace Precedents: Show cells referenced in the formula.
III. Trace Dependents: Show cells dependent on the formula.
4. Error Checking: Detect and highlight formula errors.
5. Evaluate Formula: Step through the evaluation of a formula for better understanding.
1. Reference styles in Excel.
2. Relative Reference: Adjusts based on the formula cell's position when copied.
3. Absolute Reference: Remains fixed when the formula is copied.
4. Mixed Reference: Fixes either the column (e.g., $A1) or the row (e.g., A$1).
1. Highlight Cells Rules: Emphasize cells based on specified criteria.
2. Top Bottom Rules: Highlight highest or lowest values in a range.
3. Data Bar: Visualize values with dynamic bar lengths.
4. Color Scales: Apply color gradients for quick value comparison.
5. Icon Sets: Use icons to represent data levels or statuses.
6. Conditional Formatting using Formulas: Create custom formatting based on specific formulas.
1. Proofing: catches typos, suggests synonyms, and checks grammar.
2. Comments: let you leave notes and collaborate with others.
3. Changes: tracks edit and reveals who did what, when.
4. Protection: safeguards your sheets and workbooks from unauthorized changes.
5. Accessibility: makes your documents usable for everyone.
1. Macros: record, run, edit, and automate tasks.
2. VBA: write powerful code for custom functions.
3. Controls: add buttons, lists, etc. to interact with data.
4. XML: import and export data in a structured format.
5. Extending functionality: add-ins and COM to boost Excel's capabilities.
1. Record actions: Turn repetitive tasks into scripts (even without coding).
2. Code custom scripts: For complex automation, write TypeScript code.
3. Run and schedule scripts: Automate everyday tasks and save time.
4. Connect to other tools: Trigger scripts from Power Automate flows.
1. General (startup, appearance, save format, accessibility).
2. Formulas (calculation, error handling, formula display).
3. Data (external connections, refresh, validation, fill, sorting).
4. Proofing (spelling, grammar, AutoCorrect, language).
5. Save (auto-save, file format, recovery).
6. Advanced (editing, display, printing, formulas, content, privacy).
7. Customize Ribbon (personalize ribbon tabs and commands).
8. Quick Access Toolbar (add frequently used commands).
9. Add-Ins (manage extensions).
10. Trust Center (security, privacy, macro settings).
1. Views: Switch between Normal, Page Layout, & custom versions.
2. Show/Hide: Gridlines, Headings, Formula Bar, etc.
3. Zoom: Magnify worksheet for better viewing.
4. Window: Split panes, freeze rows/columns, open new windows.
5. Macros: Access and manage macros.
6. Customize: Save custom views, add options to Quick Access Toolbar.
