MODULE 1: GETTING STARTED WITH POWER BI

• Overview of Data Analytics and Business Analytics
• Roles of Data Analyst
• Introduction to Power BI
• Need for Power BI
• Power BI Alternatives
• Building Blocks of Power BI
• Key Features of Power BI
• Value It Offers
• Licensing & Pricing
• Installing Power BI Desktop

MODULE 2: OVERVIEW OF POWER BI INTERFACES

• Home Tab
• Insert Tab
• Modeling Tab
• View Tab
• Optimize Tab
• Help Tab
• Ways to Import Files in Power BI
• Import file into Power BI
• Different between Load and Transform
• Filter Pane
• Visualization Section (Add Data and Format Visualizations)
• Data Section
• Report, Data and Model Views
• Desktop Layout vs Mobile Layout views

MODULE 3: DATA MANIPULATION AND MODELING IN POWER BI

• Upload Source Data in Power BI
• Transform Data in Power Query
• Change Data Source Settings
• Check Date Formats
• Check Number Formats
• Check Other Data Formats
• Sort Columns
• Data Modeling in Power BI
• Building Relationships Between Fields from Different Tables
• Types of Relationships
• Manage Relationship Options
• Properties and Data Tabs in Model View
• Check and Change Location Data in Power BI

MODULE 4: CREATE AND FORMAT A TABLE VISUALIZATION

• Import data from Excel and Create the First Visualization
• Create a Table
• Add Data to Table
• Format Table Visualization
• Format Font, Size and Background Colors
• Change Number and Date Format
  

MODULE 5: WORKING WITH DIFFERENT CHARTS & TABLES

• Create Matrix Table
• Drill Down Data, See Data and Records, and Export Data
• Bar & Column Charts
• Create Combo Charts with Line & Stacked Column Chart
• Line and Area Charts
• Ribbon Chart
• Understand the Concept of Waterfall Chart
• Funnel and Scattered Charts
• Pie and Donut Charts
• When to Use Treemap Charts
• Map, Filled Map & Shape Map Charts
• Create KPI Measure Using Gauge Visualization
• Use of Single and Multi-Row Cards
• Usage of Old vs New Card
• KPI Creation & Design
• How to Create Slicer
• Effective Visualization Technique Using Decomposition Tree Method

MODULE 6: ADD MORE CONTROLS TO THE VISUALIZATIONS

• Adding Text boxes, Images and Shapes
• Visual Level, Page Level and Report Level Filters - Basic Filters
• Advanced Filtering
• Filter Top N Items
• Slicer
• Synchronizing Slicers to Multiple Pages
• Slicer Warning
• Adding More Control to your Visualizations - Filters and Slicers
• Sort Visuals
• Configure Small Multiples
• Use Bookmarks for Reports
• Group and Layer Visuals by Using the Selection Pane
• Drill Through Feature of Power BI
• Buttons and Actions
• Page Navigation and Drill Through Actions
• Enable Natural Language Queries (Ask A Question) and Page Formatting
• Tooltip Pages
• Page and Bookmark Navigator

MODULE 7: WORKING WITH MULTIPLE FILES

• Merge Queries and Expand Table
• Merger Queries with Group By and Different Types of Joins
• Comma Separated Files
• Append Two Queries Together
• Combine Files from Folder
• Getting Multiple Files
  

MODULE 8: DATA MODELING WITH DAX

• What is Data Modeling?
• Problems with Direction of Relationships between Data Sets
• What is DAX?
• Difference between DAX and Excel Formulas

DATE & TIME FUNCTIONS

• DATE Function
• DATEVALUE Function
• DAY Function
• EDATE Function
• EOMONTH Function
• NOW Function
• TODAY Function
• WEEKNUM Function
• YEAR Function

LOGICAL FUNCTIONS

• AND Function
• FALSE Function
• IF Function
• IFERROR Function
• NOT Function
• OR Function
• SWITCH Function
• TRUE Function

MODULE 8: DATA MODELING WITH DAX (Part 2)

 TEXT FUNCTIONS

• BLANK Function
• CONCATENATE Function
• EXACT Function
• FIND Function
• FORMAT Function
• LEFT Function
• LEN Function
• LOWER Function
• MID Function
• REPLACE Function
• REPT Function
• RIGHT Function
• SEARCH Function
• SUBSTITUTE Function
• TRIM Function
• UPPER Function
• VALUE Function

MATH FUNCTIONS

• DIVIDE Function
• SUM Function
• SUMX Function

TIME INTELLIGENCE FUNCTIONS

• FIRSTDATE Function
• LASTDATE Function
• NEXTDAY Function
• NEXTMONTH Function
• NEXTQUARTER Function
• NEXTYEAR Function
• OPENINGBALANCEMONTH Function
• OPENINGBALANCEQUARTER Function
• OPENINGBALANCEYEAR Function
• PARALLELPERIOD Function
• PREVIOUSDAY Function
• PREVIOUSMONTH Function
• PREVIOUSQUARTER Function
• PREVIOUSYEAR Function
• SAMEPERIODLASTYEAR Function
• STARTOFMONTH Function
• STARTOFQUARTER Function
• STARTOFYEAR Function
• TOTALMTD Function
• TOTALQTD Function
• TOTALYTD Function
• CLOSINGBALANCEMONTH Function
• CLOSINGBALANCEQUARTER Function
• CLOSINGBALANCEYEAR Function
• DATESINPERIOD Function
• DATESMTD Function
• DATESQTD Function
• DATESYTD Function
• ENDOFMONTH Function
• ENDOFQUARTER Function
• ENDOFYEAR Function
  

MODULE 8: DATA MODELING WITH DAX (Part 3)

STATISTICAL FUNCTIONS

• ADDCOLUMNS Function
• AVERAGE Function
• AVERAGEX Function
• COUNT Function
• COUNTA Function
• COUNTAX Function
• COUNTBLANK Function
• COUNTROWS Function
• COUNTX Function
• CROSSJOIN Function
• DISTINCTCOUNT Function
• MAX Function
• MAXA Function
• MAXX Function
• MIN Function
• MINX Function
• SUMMARIZE Function
• TOPN Function

FILTER FUNCTIONS

• ALL Function
• ALLEXCEPT Function
• ALLSELECTED Function
• CALCULATE Function
• DISTINCT Function
• FILTER Function
• VALUES Function

OTHER FUNCTIONS

• SUMMARIZECOLUMNS Function
• Use of VAR in DAX Language
  

Supply Chain Analytics Dashboard to showcase supply chain KPI results to management in real time.

Key Deliverables

• KPI Design
• Source Data Upload
• Calculate Columns
• Create Measures Using DAX
• Create Filters
• Design Interactive Dashboard

Inventory Analysis to track the inventory items and perform ageing in real time basis.

Key Deliverables

• KPI Design
• Source Data Upload
• Calculate Columns
• Create Measures Using DAX
• Create Filters
  
• Design Interactive Dashboard

Practical Workshop (3) - Prepare and Design Financial Performance Dashboard

 Key Deliverables

• KPI Design
• Source Data Upload
• Calculate Columns
• Create Measures Using DAX
• Create Filters
• Design Interactive Dashboard

Practical Workshop (4) - Prepare and Design Sales Analysis Dashboard

Key Deliverables

• KPI Design
• Source Data Upload
  
• Calculate Columns
• Create Measures Using DAX
• Create Filters
• Design Interactive Dashboard

Practical Workshop (5) - Prepare and Design Call Center Feedbacks and Financial Ratio Analytics Dashboards

Key Deliverables

• KPI Design
• Source Data Upload
• Calculate Columns
• Create Measures Using DAX
• Create Filters
• Design Interactive Dashboard

Practical Workshop (6) - Prepare and Design Receivables Analysis and Tracking Dashboard

Key Deliverables

• KPI Design
• Source Data Upload
• Calculate Columns
• Create Measures Using DAX
• Create Filters
• Design Interactive Dashboard

This part (i.e. Module 10 to Module 12) will not be covered in live classes. Separate recordings will be uploaded on the website after completing all the previous modules (i.e. Module 1 to Module 9).

 MODULE 10: POWER BI SERVICE

• Introducing The Power BI Service
• Logging into Power BI Service and a quick look around
• Power BI Terminology
• Datasets and Reports in the Power BI Service
• Get Data - Importing Your Data as a Dataset
• Get Data - Importing your data as a Workbook
• The Navigation Pane, including Add a Quick Insights result to a report

MODULE 11: POWER BI PRO, ADDING USERS, SHARING REPORTS & VISUALS

• Signing up for Power BI Pro
• Adding new users
• Creating & Sharing a New Report
• Sharing reports and visuals to PowerPoint

MODULE 12: OTHER FEATURES OF POWER BI SERVICE

• Static vs Dynamic Row Level Security
• Differences between dashboards and reports
• Configure Subscriptions
• Use the Q&A Feature
• Analyze Data in Excel
• Manually Refreshing data in the Power BI Service
• Where is Scheduled Refresh?
• Configure a Dataset Scheduled Refresh
• Create and Configure a Workspace
• Assign Workspace Roles
• Providing Access to Datasets
• Publish reports on the web, so the public can see