Full Stack BI

Reporting
& Automation

(On-Cloud BI Reporting)

Power BI | DAX | MS-SQL | Power Apps | Power Automate

All-in-One Course | View Schedule

MASTER

Data Analytics, Advanced Reporting,
Programming & Automation.

Full Stack BI Reporting & Automation

(On-Cloud BI Reporting)

50-hour Course | 6 Data-Tools | 7 Specialist Certificates

Power BI | DAX | MS-SQL | ETL | VBA | Python View Schedule

Course Ratings

(1.5K+ Professionals enrolled)

All-in-One Course | View Schedule

Power BI

Adv. DAX

MS-SQL

Power Query

Power Apps

Power Automate

Master data analytics, advanced BI reporting, and automation like a boss, and become a bonafide techno-functional pro. Level up your analytical skills and dominate the data game with our end-to-end BI Reporting program.

Prove you're human: Type the code shown.

Call me! E-mail me!

By clicking any of the above buttons, I agree to the terms & conditions and privacy policy, and I consent to receive updates via SMS or email

Program at a Glance

TOTAL COURSE DURATION

50-hours, 24 Sessions

Online live classes, Instructor-led.

TRAINING SHEDULE

View Schedule

POWER BI, SQL, Power Apps & Power Automate

45+ Projects

CERTIFICATES

7-Specialist Certificates (one for each tool)

Tools You'll Learn

Visualization Tool

Microsoft Power BI

Data Modeling Tool

Power Pivot

Data Transformation Tool

Power Query

Data Warehousing Tool

MS-SQL

Application Development Tool

Microsoft Power Apps

Workflow Automation Tool

Microsoft Power Automate

Course Content Overview

A snapshot of what you'll be learning in 6-weeks.

Quick Excel brush-up

Objective: To prepare a quick POC with small data and get the concurrence on the output before investing time on huge datasets.

Overview

Core Fundamentals Of Spreadsheets
How System Interprets Your Data
Crucial Formatting Concepts
Understanding Core Formula Fundamentals & Advanced Referencing Concepts
60+ Advanced Excel Functions
Cleansing & Transforming Data
Data Summarization
Conditional Summarization
Working With Multiple Datasets
Working With Pivot Tables Including Advanced Pivot Tables Options
15+ Charts - When To Use What Chart?
Develop Data Models to Simulate Complex Business Scenarios for What IF Analysis

Modeling with Power Pivot

Objective: To do faster queries, simpler DAX code and enjoy easier maintenance.

Introduction To PowerPivot

Limitation Of Excel Functions
Limitation Of Excel Pivot table
Why Powerpivot?
Powerpivot Features – Overview

Powerpivot Environment

Opening Powerpivot Environment
Understanding External Data Section
Understanding Formatting
Powerpivot Views
Understanding Measures

Loading Data Into PowerPivot

Calculated Columns

Calculated Columns
Entering Formulas
Using Autocomplete Feature
Renaming Columns
Understanding Tables

Creating Measures

Creating Simple DAX Measures
Explicit Measure Vs Implicit Measure
Referencing Measures In Other Measures
Formatting Measures
Manage Data Relationships
Working With Multiple Tables
Disconnected Tables
Creating Custom Calendars
Using Advanced Filter()
Advanced Calculated Columns
Understanding Relationship Concept
Join Tables
Left Join Tables
Right Join Tables

Data Visualization Using

Charts, Score Cards And Dashboards
Slicers
Map Visualizations
Data Binding And Formatting

Creating Advanced Dashboards With PowerPivot

Creating Free Form Reports With PowerPivot & Excel

Develop Simple Models And Forecast Data Using PowerPivot & Excel

Power BI

Objective: Getting started with Power BI and leverage it’s full potential to develop compelling visualizations.

Building Blocks of Power BI

Visualizations
Datasets
Reports
Dashboards
Tiles

Building Your First Power BI Report

Connect to Data Sources in Power BI Desktop
Clean and Transform Your Data With the Query Editor
Create a report in Power BI Desktop
Publish the report in the Power BI service

Data Modeling with Power BI

Fundamentals of Modeling
How to Manage Your Data Relationships
Create Calculated Columns
Optimizing Data Models for Better Visuals
Create measures and work with time-based functions
Create Calculated Tables
Explore Time-Based Data

Visualizations

Create and Customize Simple Visualizations

Building compelling data visualizations

Identify metrics and pair them with appropriate data visuals
Using slicers
Creating Map Visualizations
Creating Tables and Matrixes
Creating Scatter Charts
Creating Waterfall and Funnel Charts
Using Gauges and Single Number Cards
Charting Options including Formatting with Colors, Shapes, Text Boxes, Images, etc.

Designing User-friendly reports

Customize themes
Create versatile layouts for your reports
Design principles to reduce noise and highlight data stories

Creating interactive reports for data exploration

Filtering & drilling for insights
Difference between filters & slicers
Filter pane for reporting needs

Exploring Data

Use Quick Insights in the Power BI service
Create and Configure A Dashboard
Share Dashboards with your organization
Display Visuals and Tiles Full-Screen

Power Query

Objective: To learn different methods to Transform Data before uploading it to the SQL Database.

Overview

Introduction
Loading & Refresh
Combine data from multiple data sources

Data Transformation

Editing Queries Created with Power Query
Editing Column Headers in Power Query
Splitting Column Data with Power Query
Sorting Data
Multi-Level Sorting
Filtering Data
Aggregate data from a column
Insert a custom column into a table
Merge columns
Remove columns
Remove rows with errors
Promote a row to column headers
Transforming Text Values
Replacing Data
Using the Fill command
Pivot and Unpivot Column
Transpose Query Data
Pivot Column Command in Action
Unpivot Columns Command
Grouping Data
Create a Duplicate Query
Group and Summarize Data
Advanced Data Grouping
Working with multiple sources in Power Query
Multiple Excel Tables
Expand a column containing an associated table
Understanding Table Relationships
Merging Queries

Loading Power Query Data to Destinations

Familiarity with the Load & Refresh Settings
Loading it to Workbook
Loading it to Data Model

DAX Functions

Objective: To add analytical power to your Power BI model that is not available in the data as-is, using DAX.

Overview

What is DAX?
Data Types
Table-Valued Functions
Building a Calendar Table
Date and Time Functions
Filter Functions
Information Functions
Logical Functions
Mathematical and Trigonometric Functions
Statistical Functions
Text Functions
Time Intelligence Functions

Creating Advanced Dax Measures With Advanced Dax Functions

Calculate()
All()
Filter()
IF()
Switch()
SumX()

Evaluation Context

Filter Context
Row Context
Using RELATED in a Row Context
Filters and Relationships
USERELATIONSHIP

Hierarchies in DAX

Querying with DAX

Relationships

One-to-Many Relationships
Many-to-Many Relationships

T-SQL

Objective: To query MS-SQL Database (es) by writing accurate, effective, and robust T-SQL code - the right way.

Introduction to MS-SQL

Creating a Database
Understanding Tables and Creating Tables
Inserting, Updating and Deleting Data
Querying Data
Filtering Data
Grouping Data
Ordering Data
Column Aliases
Table Aliases

DDL INSIGHTS

CREATE TABLE
Dropping Objects
CREATE INDEX
TEMPORARY OBJECTS
Object Naming and Dependencies

SELECT STATEMENTS

Simple SELECTs
Calculated and Derived Fields
SELECT TOP / BOTTOM Records
Derived Tables
Joins
Predicates
Subqueries
Aggregate Functions
GROUP BY and HAVING
UNION
ORDER BY

Advanced DAX Expressions

Objective: Leverage DAX potential to perform advanced data analytics

Advanced Table Manipulation Functions

ADDCOLUMNS
CROSSJOIN
DATATABLE
DISTINCT column
EXCEPT
FILTERS
GENERATESERIES
INTERSECT
NATURALINNERJOIN
NATURALLEFTOUTERJOIN
ROW
SELECTCOLUMNS
SUMMARIZE
SUMMARIZECOLUMNS
Constructor
TOPN
UNION
VALUES

Advanced Filter Functions

ADDMISSINGITEMS
ALL
ALLCROSSFILTERED
ALLEXCEPT
ALLSELECTED
CALCULATE
DISTINCT
FILTER
FILTERS
RELATED
REMOVEFILTERS
SELECTEDVALUE
USERELATIONSHIP
VALUES

ADVANCED USAGE OF

CALCULATE
SUMX
COUNTX
AVERAGEX
MAXX
MINXX
DATATABLE

M Programming with Power Query

Objective: To perform advanced and complex data transformations not available in the Query Editor

Understanding M Programming Code

M LANGUAGE Specifications
Lexical Structure
Basic Concepts
Values
Types
Operators
Let
Conditionals
Functions
Error Handling
Creating Simple M Expressions
Creating Simple M Functions
Working with List, Record & Tables
Understanding Operators and Evaluation Methods
Data Types & Type Conversions

Working with M Functions

ACCESSING DATA FUNCTIONS - From Excel, SQL, CSV, Tab-Delimited, Webpage, XML, JSON, SharePoint, etc.
COMBINER FUNCTIONS
COMPARER FUNCTIONS
DATE FUNCTIONS
DATETIME FUNCTIONS
DURATION FUNCTIONS
LIST FUNCTIONS
LOGICAL FUNCTIONS
NUMBER FUNCTIONS
RECORD FUNCTIONS
REPLACER FUNCTIONS
SPLITTER FUNCTIONS
TABLE FUNCTIONS
TEXT FUNCTIONS
TIME FUNCTIONS
TYPE FUNCTIONS
VALUE FUNCTIONS

Power BI Administration

Objective: Get hands-on experience with advanced administration settings, permissions, Data refresh times etc.

Overview

Publishing Power BI Reports
Creating & Managing Workspaces and Its Access
Creating & Managing Dashboard and Its Access
Installing & Configuring Data gateway
Scheduling and configuring data refresh
Managing & Reusing Datasets
Scheduling Report Alerts
Setting up Row Level Permissions
Managing Users & Audit Log
Custom Branding Power BI For your Organization
Adding Custom Visuals for your Organization

Power Apps

Power Apps Training Course for Working Professionals

INTRODUCTION TO POWER APPS

Overview of Power Apps

What is Power Apps?
Benefits and use cases
Types of Power Apps: Canvas, Model-Driven, and Portal Apps

Getting Started

Setting up your Power Apps environment
Navigating the Power Apps interface

DATA INTEGRATION AND MANAGEMENT

Connecting to Data Sources

Introduction to connectors
Connecting to common data sources (SharePoint, Excel, SQL Server, etc.)

Managing Data

Understanding data tables and collections

BUILDING YOUR FIRST CANVAS APP

Basics of Canvas Apps

Understanding Canvas Apps
Creating a simple Canvas App
Adding screens and navigation
Creating simple app to view details from data source.
Using simple forms to display and edit data

ADVANCED CANVAS APP FEATURES

User Experience Design

Designing responsive layouts
Using themes and templates
Best practices for user interface design

Working with Controls

Using different types of controls like

Button
Text input
Drop down
Combo Box
Date picker
List box
Radio
Text label
Vertical gallery
Horizontal gallery
Flexible height gallery
Blank Vertical gallery
Blank Horizontal gallery
Blank Flexible height gallery
Data table
Horizontal container
Vertical container
Container
Image
Icons
Shapes
Working with control properties

Working with Variables

Global variables
Context variable
Collections

Using formulas for dynamic form management

Functions to be used in forms

SubmitForm
EditForm
Clear
ClearCollect
Collect
Filter
If
Navigate
NewForm
Notify
Patch
Refresh
Search
Set
Text
ThisItem
Value

Advanced Controls and Features

Working with media (images, videos)
Implementing charts and graphs
Using Power Automate for workflows

INTRODUCTION TO MODEL-DRIVEN APPS

Basics of Model-Driven Apps

Understanding the Common Data Service (Dataverse)
Creating entities and relationships
Building a simple Model-Driven App

SECURITY AND ADMINISTRATION

Security in Power Apps

Understanding security roles and permissions
Implementing data security

App Management

Managing app versions
Publishing and sharing apps

BEST PRACTICES AND ADVANCED TOPICS

Performance Optimization

Tips for improving app performance
Debugging and troubleshooting techniques

Real-World Use Cases

Case studies and examples
Industry-specific applications

REALTIME PROJECTS

Project 1: Employee Leave Request App
Project 2: Inventory Management App
Project 3: Customer Feedback App
Project 4: Project Management Dashboard
Project 5: Sales Order Processing App

Power Automate

Power Automate Training Course for Working Professionals

INTRODUCTION TO POWER AUTOMATE

Overview of Power Automate

What is Power Automate?
Benefits and use cases
Types of flows: Cloud Flows, Desktop Flows, and Business Process Flows

Getting Started

Setting up your Power Automate environment
Navigating the Power Automate interface

CREATING YOUR FIRST FLOW

Basics of Flow Creation

Understanding triggers and actions
Creating a simple flow
Running and testing flows

Flow Templates

Using predefined templates
Customizing template flows
Best practices for using templates

WORKING WITH CONNECTORS

Introduction to Connectors

Understanding connectors and their roles
Connecting to common data sources (SharePoint, OneDrive, Outlook, etc.)

Advanced Data Integration

Using premium connectors
Connecting to SQL Server, Azure, and other advanced data sources

ADVANCED FLOW FEATURES

Conditions and Loops

Implementing conditional logic
Using loops for repetitive tasks

Approvals and Notifications

Creating approval workflows
Sending email and mobile notifications

Error Handling and Troubleshooting

Managing errors in flows
Debugging and troubleshooting techniques

DESKTOP FLOWS (RPA)

Introduction to Desktop Flows

Understanding Robotic Process Automation (RPA)
Setting up Power Automate Desktop

Building Desktop Flows

Recording desktop actions
Automating desktop applications

Advanced Desktop Flow Features

Using conditions and loops in desktop flows
Integrating with cloud flows

BUSINESS PROCESS FLOWS

Introduction to Business Process Flows

Understanding business process automation
Creating a simple business process flow

Customizing Business Process Flows

Defining stages and steps
Implementing business rules and logic

Advanced Business Process Flow Features

Using custom entities and fields
Integrating with power apps

PROJECTS

Power Automate Projects

Project 1: Automated Invoice Approval Workflow
Project 2 : Employee Onboarding Automation
Project 3: Social Media Post Scheduler
Project 4: Customer Support Ticketing System
Project 5: Monthly Sales Report Automation

Desktop Flows (RPA

Project 1: Automated Data Entry from Emails
Project 2: Invoice Processing and Archiving
Project 3: Automated Report Generation
Project 4: Customer Account Reconciliation
Project 5: Automated Data Migration

Architect Power BI Solution

Objective: To put our entire learning to use and arrive at the best possible BI solution -using the right combination of available technologies.

Overview

Case Study 1
Case Study 2
Case Study 3

System Requirements

Power BI Desktop

Free & Downloadable from Microsoft Store App

https://www.microsoft.com/store/productid/9NTXR16HNW1T?ocid=pdpshare
Excel 2016 & above with PowerPivot

Available with Office 365 subscriptions that include desktop versions of Excel for Windows.
MS-SQL Server

https://www.microsoft.com/en-in/sql-server/sql-server-downloads

Kindly install Developer Edition as it is full-featured free edition, licensed for use as a development and test database in a non-production environment.
SQL Server Management Studio (SSMS)

Download and install SSMS from https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16

Program Overview

Total Course Duration

50-hours, 24 Sessions

Online live classes, Instructor-led.

Training Schedule

View Schedule

Power BI, SQL, Power Apps

45+ Projects

Check what’s included?

One for each tool

7 Specialist Certificates

View Certificate Details

Tools You'll Learn

Visualization Tool

Microsoft Power BI

Data Modeling Tool

Power Pivot

Data Transformation Tool

Power Query

Data Warehousing Tool

MS-SQL

Application Development Tool

Microsoft Power Apps

Workflow Automation Tool

Microsoft Power Automate

Course Syllabus Overview

Quick brush-up with Excel

Excel is to BI what wireframing is to application development. Brush up your Excel skills with 60+ formulas, pivots, charts & dashboards to quickly build a POC with small data before investing your time in building complex BI reports with big datasets.

Why should I learn Excel?

Visualization with Power BI

Getting started with Power BI is simple. Then, once you want to leverage its full potential, you need a different set of skills. Learn how to develop these skills, unlock more insights through better data analysis and visualization with this section.

Why should I learn Power BI?

Advanced Calculation with DAX

Add analytical power to your Power BI model that is not available in the data as-is, using DAX. The goal of this section is to teach you basic to advance features of DAX, providing the knowledge to write formulas for common and advanced business scenarios.

Why should I learn DAX?

M-Programming with Power Query

During this section, you'll learn how to perform advanced data transformations not available in the Query Editor. We will discuss how to leverage the embedded PowerBI programming language (M) to achieve this.

Why Should I learn M-Programming?

Model-building with Power Pivot

Explore the most powerful tool to build data models, forecast estimates, perform what-if-analysis scenario etc. If you are yet to have the Power BI license, you would still be able to create powerful & blended reports and share it internally using Power Pivot.

Why should I learn Power Pivot?

Data warehousing using MS-SQL

Data for Power BI can come from many sources, but often the data is hosted in SQL Server. This section will teach you how to write accurate, effective, and robust T-SQL code- the right way and also understand the logic behind the same.

Why should I learn MS-SQL?

MS-SQL is a recommended skill while working with Power BI. You can say it is one of the basic building block if you are looking forward to work full-time with BI.

It offers you more flexibility to implement complication logic which otherwise requires multiple steps inside Power BI model. Also, if you're using direct query mode then you need to have a strong knowledge on SQL as almost all processing happens at the source systems else you would restrict yourself to only limited modeling and designing visualizations.

Important things MS-SQL can help you with

Create an optimal data model for space and speed
Manage partitions the right way
Design an efficient and trustable security model
Define an ideal processing strategy
Automate deployment and management of the data model

Why to have MS-SQL as Data warehouse?

While power query could do the major transformations - required for the reporting purpose, it is not advisable and recommended to access the production database for reporting requirements. ETL data from multiple data sources into your data warehouse and then load it to your BI via T-SQL is the best practice.

Application Development with Power Apps

Master this low-code platform for developing tailored business applications. Learn to create responsive apps that integrate seamlessly with data sources, enhancing efficiency in business operations without requiring advanced coding skills.

Workflow Automation with Power Automate

In this section, you will learn how to automate repetitive tasks and streamline workflows. You can set up automated processes that connect your BI tools with other software, like sending notifications or updating data automatically. This automation helps you save time, improve collaboration, and make faster decisions based on real-time data.

Mastering SSAS Tabular is pivotal for robust Business Intelligence solutions, especially when working extensively with tools like Power BI. It serves as a foundational skill, empowering full-time BI practitioners with essential capabilities.

Enhanced Flexibility:

SSAS Tabular offers unparalleled flexibility in implementing complex logic, enabling streamlined workflows that might otherwise demand convoluted steps within Power BI models. Particularly in direct query mode, a strong grasp of SSAS Tabular empowers you to optimize processing at the source system, expanding modeling and visualization design possibilities.

Key SSAS Capabilities:

Optimal Data Modeling: Craft optimized data models for both efficiency and speed.
Partition Management: Master effective partitioning strategies for enhanced performance.
Security Model Design: Establish robust and reliable security protocols for data access.
Processing Strategy Definition: Define and execute an ideal data processing strategy.
Automation: Automate deployment and management tasks for seamless data model maintenance.

The Role of SSAS Tabular in Data Warehousing:

Utilizing SSAS Tabular as a data warehouse reinforces best practices in Business Intelligence. While Power Query handles significant transformations, relying on a production database for reporting is not recommended. Leveraging SSAS Tabular, ETL processes are streamlined, allowing data to be sourced from multiple origins and efficiently loaded into your BI via T-SQL, ensuring data integrity and optimal reporting performance.

Architect Power BI Solution

This section will help you put together Excel, VBA, Power BI, DAX, Power Query and SQL to architect the best BI solution. You'll also learn to publish, securely share reports including row level permissions along with BI administrative tasks like setting up data gateways etc.

Why should I learn to Architect a solution?

Quick brush-up with Excel

Why should I learn Excel?

To prepare a quick POC with small data and get the concurrence on the output before investing time on huge datasets.
Find out the challenges via POC and in turn reduce the overall BI development time and efforts.

You need not be an expert in Excel, but it does come in handy to be proficient in Excel as it is estimated that 80% of data scientist's time is spent cleaning and preparing data - which becomes a cakewalk with Excel.

You can consider Excel more or less as the foundation to Power BI.

Visualization with Power BI

Why should I learn Power BI?

Besides all technical reasons, It is everywhere - Power BI is a leader in Gartner's Magic Quadrant for Analytics and Business Intelligence Platforms.

There is a reason it's called "Power" BI - An incredibly powerful tool for both modeling and visualizing data. It has the same base as Power Query.

As an Analyst, you would find Microsoft Power BI to be a fantastic tool that can handle most of the analytics pipeline. It goes from ingesting and modeling data to presenting it as dashboards and sharing the dashboards with the people who care about them.

Advanced Calculation with DAX

Why should I learn DAX?

DAX is used in several Microsoft Products such as Microsoft Power BI, Microsoft Analysis Services and Microsoft Power Pivot for Excel. These products all share the same internal engine, called Tabular/Vertipaq (xVelocity before).

With DAX you have the ability to include business logic in calculations in order to enrich your business intelligence models.

M-Programming with Power Query

Why Should I learn M-Programming?

You need to perform data transformations in the Query Editor that cannot be done by simply using the User Interface.

To perform complex operations on data in the Power Query Editor

Model-building with Power Pivot

Why should I learn Power Pivot?

The easiest way to create a data model in Power BI and Power Pivot is to gather the data "as is" from a data source, define relationships, and then start designing reports. But this approach raises several issues when you have too many tables, or different levels of granularity.

Benefits of a proper data model with power pivot includes:

Faster queries
Simpler DAX code
Easier maintenance

ETL with SSIS

Extract - Transform - Load. Extract Data from multiple data sources, transform it with SSIS inbuilt transformation options or use M-Programs with SSIS and, Load it to the Reporting Database or Data Warehouse for generating dynamic BI Reports.

Why should I know ETL with SSIS?

Businesses receive data from outside of their systems and need to perform data-quality routines to standardize and clean the data before loading it into their systems.

SSIS can handle most data situations from heterogeneous databases or flat files. This is commonly the case when different areas of the business use different standards and formats for the information. Sometimes the data formats are different because the platforms from which they originate differ from the intended destination.

In these cases, SSIS includes a rich set of data-transformation tasks to perform a wide range of data-cleaning, converting, and enriching functions. You can replace values or get descriptions from code values by using exact or fuzzy lookups within SSIS. Identifying records that may be duplicates by using SSIS grouping transformations helps to successfully remove them before loading to the destination.

Data warehousing using MS-SQL

Why should I learn MS-SQL?

MS-SQL is a recommended skill while working with Power BI. You can say it is one of the basic building block if you are looking forward to work full-time with BI.

Important things MS-SQL can help you with

Create an optimal data model for space and speed
Manage partitions the right way
Design an efficient and trustable security model
Define an ideal processing strategy
Automate deployment and management of the data model

Why to have MS-SQL as Data warehouse?

Modeling & Analytics with SSAS

In this section, you'll master SSAS Tabular, crafting optimized data models for lightning-fast analysis. You'll seamlessly integrate these models with BI tools, enabling real-time insights and building robust reporting solutions.

Why should I learn SSAS Tabular?

There are many important tasks / activities which cannot be done using Power Bi components like -

Reading emails from outlook and updating it to SQL Server
Reading PDF documents
Reading websites (web scrapping)
Triggering automated emails

It is tool like VBA which can enhance the power of your BI and help you turn the solution to a full-fledge end to end automation.

Architect Power BI Solution

Why should I learn to Architect a solution?

The whole purpose of this section is to arrive at the best possible BI reporting solution for existing business problems instead of just performing a task.

To build a light-weight solution for a huge dataset
Improvise the Data refresh times and reduce associated cost
Use the right mix of available technologies to work with huge datasets - for reporting purpose.

Taught by Microsoft Certified Trainers.

All our classes are live, hands-on and with real-trainers.

No recorded sessions.

Course Content Overview

A snapshot of what you'll be learning in 6-weeks.

Quick Excel brush-up Modeling with Power Pivot Power BI Power Query DAX Functions T-SQL Advanced DAX Expressions M Programming with Power Query Power BI Administration Power Apps Power Automate Architect Power BI Solution System Requirements

Objective: To prepare a quick POC with small data and get the concurrence on the output before investing time on huge datasets.

Overview

Core Fundamentals Of Spreadsheets
How System Interprets Your Data
Crucial Formatting Concepts
Understanding Core Formula Fundamentals & Advanced Referencing Concepts
60+ Advanced Excel Functions
Cleansing & Transforming Data
Data Summarization
Conditional Summarization
Working With Multiple Datasets
Working With Pivot Tables Including Advanced Pivot Tables Options
15+ Charts - When To Use What Chart?
Develop Data Models to Simulate Complex Business Scenarios for What IF Analysis

Objective: To do faster queries, simpler DAX code and enjoy easier maintenance.

Introduction To PowerPivot

Limitation Of Excel Functions
Limitation Of Excel Pivot table
Why Powerpivot?
Powerpivot Features – Overview

Powerpivot Environment

Opening Powerpivot Environment
Understanding External Data Section
Understanding Formatting
Powerpivot Views
Understanding Measures

Loading Data Into PowerPivot

Calculated Columns

Calculated Columns
Entering Formulas
Using Autocomplete Feature
Renaming Columns
Understanding Tables

Creating Measures

Creating Simple DAX Measures
Explicit Measure Vs Implicit Measure
Referencing Measures In Other Measures
Formatting Measures
Manage Data Relationships
Working With Multiple Tables
Disconnected Tables
Creating Custom Calendars
Using Advanced Filter()
Advanced Calculated Columns
Understanding Relationship Concept
Join Tables
Left Join Tables
Right Join Tables

Data Visualization Using

Charts, Score Cards And Dashboards
Slicers
Map Visualizations
Data Binding And Formatting

Creating Advanced Dashboards With PowerPivot

Creating Free Form Reports With PowerPivot & Excel

Develop Simple Models And Forecast Data Using PowerPivot & Excel

Objective: Getting started with Power BI and leverage it’s full potential to develop compelling visualizations.

Building Blocks of Power BI

Visualizations
Datasets
Reports
Dashboards
Tiles

Building Your First Power BI Report

Connect to Data Sources in Power BI Desktop
Clean and Transform Your Data With the Query Editor
Create a report in Power BI Desktop
Publish the report in the Power BI service

Data Modeling with Power BI

Fundamentals of Modeling
How to Manage Your Data Relationships
Create Calculated Columns
Optimizing Data Models for Better Visuals
Create measures and work with time-based functions
Create Calculated Tables
Explore Time-Based Data

Visualizations

Create and Customize Simple Visualizations

Building compelling data visualizations

Identify metrics and pair them with appropriate data visuals
Using slicers
Creating Map Visualizations
Creating Tables and Matrixes
Creating Scatter Charts
Creating Waterfall and Funnel Charts
Using Gauges and Single Number Cards
Charting Options including Formatting with Colors, Shapes, Text Boxes, Images, etc.

Designing User-friendly reports

Customize themes
Create versatile layouts for your reports
Design principles to reduce noise and highlight data stories

Creating interactive reports for data exploration

Filtering & drilling for insights
Difference between filters & slicers
Filter pane for reporting needs

Exploring Data

Use Quick Insights in the Power BI service
Create and Configure A Dashboard
Share Dashboards with your organization
Display Visuals and Tiles Full-Screen

Objective: To learn different methods to Transform Data before uploading it to the SQL Database.

Overview

Introduction
Loading & Refresh
Combine data from multiple data sources

Data Transformation

Editing Queries Created with Power Query
Editing Column Headers in Power Query
Splitting Column Data with Power Query
Sorting Data
Multi-Level Sorting
Filtering Data
Aggregate data from a column
Insert a custom column into a table
Merge columns
Remove columns
Remove rows with errors
Promote a row to column headers
Transforming Text Values
Replacing Data
Using the Fill command
Pivot and Unpivot Column
Transpose Query Data
Pivot Column Command in Action
Unpivot Columns Command
Grouping Data
Create a Duplicate Query
Group and Summarize Data
Advanced Data Grouping
Working with multiple sources in Power Query
Multiple Excel Tables
Expand a column containing an associated table
Understanding Table Relationships
Merging Queries

Loading Power Query Data to Destinations

Familiarity with the Load & Refresh Settings
Loading it to Workbook
Loading it to Data Model

Objective: To add analytical power to your Power BI model that is not available in the data as-is, using DAX.

Overview

What is DAX?
Data Types
Table-Valued Functions
Building a Calendar Table
Date and Time Functions
Filter Functions
Information Functions
Logical Functions
Mathematical and Trigonometric Functions
Statistical Functions
Text Functions
Time Intelligence Functions

Creating Advanced Dax Measures With Advanced Dax Functions

Calculate()
All()
Filter()
IF()
Switch()
SumX()

Evaluation Context

Filter Context
Row Context
Using RELATED in a Row Context
Filters and Relationships
USERELATIONSHIP

Hierarchies in DAX

Querying with DAX

Relationships

One-to-Many Relationships
Many-to-Many Relationships

Objective: To query MS-SQL Database (es) by writing accurate, effective, and robust T-SQL code - the right way.

Introduction to MS-SQL

Creating a Database
Understanding Tables and Creating Tables
Inserting, Updating and Deleting Data
Querying Data
Filtering Data
Grouping Data
Ordering Data
Column Aliases
Table Aliases

DDL INSIGHTS

CREATE TABLE
Dropping Objects
CREATE INDEX
TEMPORARY OBJECTS
Object Naming and Dependencies

SELECT STATEMENTS

Simple SELECTs
Calculated and Derived Fields
SELECT TOP / BOTTOM Records
Derived Tables
Joins
Predicates
Subqueries
Aggregate Functions
GROUP BY and HAVING
UNION
ORDER BY

Objective: Leverage DAX potential to perform advanced data analytics

Advanced Table Manipulation Functions

ADDCOLUMNS
CROSSJOIN
DATATABLE
DISTINCT column
EXCEPT
FILTERS
GENERATESERIES
INTERSECT
NATURALINNERJOIN
NATURALLEFTOUTERJOIN
ROW
SELECTCOLUMNS
SUMMARIZE
SUMMARIZECOLUMNS
Constructor
TOPN
UNION
VALUES

Advanced Filter Functions

ADDMISSINGITEMS
ALL
ALLCROSSFILTERED
ALLEXCEPT
ALLSELECTED
CALCULATE
DISTINCT
FILTER
FILTERS
RELATED
REMOVEFILTERS
SELECTEDVALUE
USERELATIONSHIP
VALUES

ADVANCED USAGE OF

CALCULATE
SUMX
COUNTX
AVERAGEX
MAXX
MINXX
DATATABLE

Objective: To perform advanced and complex data transformations not available in the Query Editor

Understanding M Programming Code

M LANGUAGE Specifications
Lexical Structure
Basic Concepts
Values
Types
Operators
Let
Conditionals
Functions
Error Handling
Creating Simple M Expressions
Creating Simple M Functions
Working with List, Record & Tables
Understanding Operators and Evaluation Methods
Data Types & Type Conversions

Working with M Functions

ACCESSING DATA FUNCTIONS - From Excel, SQL, CSV, Tab-Delimited, Webpage, XML, JSON, SharePoint, etc.
COMBINER FUNCTIONS
COMPARER FUNCTIONS
DATE FUNCTIONS
DATETIME FUNCTIONS
DURATION FUNCTIONS
LIST FUNCTIONS
LOGICAL FUNCTIONS
NUMBER FUNCTIONS
RECORD FUNCTIONS
REPLACER FUNCTIONS
SPLITTER FUNCTIONS
TABLE FUNCTIONS
TEXT FUNCTIONS
TIME FUNCTIONS
TYPE FUNCTIONS
VALUE FUNCTIONS

Objective: Get hands-on experience with advanced administration settings, permissions, Data refresh times etc.

Overview

Publishing Power BI Reports
Creating & Managing Workspaces and Its Access
Creating & Managing Dashboard and Its Access
Installing & Configuring Data gateway
Scheduling and configuring data refresh
Managing & Reusing Datasets
Scheduling Report Alerts
Setting up Row Level Permissions
Managing Users & Audit Log
Custom Branding Power BI For your Organization
Adding Custom Visuals for your Organization

Power Automate Training Course for Working Professionals

INTRODUCTION TO POWER AUTOMATE

Overview of Power Automate

What is Power Automate?
Benefits and use cases
Types of flows: Cloud Flows, Desktop Flows, and Business Process Flows

Getting Started

Setting up your Power Automate environment
Navigating the Power Automate interface

CREATING YOUR FIRST FLOW

Basics of Flow Creation

Understanding triggers and actions
Creating a simple flow
Running and testing flows

Flow Templates

Using predefined templates
Customizing template flows
Best practices for using templates

WORKING WITH CONNECTORS

Introduction to Connectors

Understanding connectors and their roles
Connecting to common data sources (SharePoint, OneDrive, Outlook, etc.)

Advanced Data Integration

Using premium connectors
Connecting to SQL Server, Azure, and other advanced data sources

ADVANCED FLOW FEATURES

Conditions and Loops

Implementing conditional logic
Using loops for repetitive tasks

Approvals and Notifications

Creating approval workflows
Sending email and mobile notifications

Error Handling and Troubleshooting

Managing errors in flows
Debugging and troubleshooting techniques

DESKTOP FLOWS (RPA)

Introduction to Desktop Flows

Understanding Robotic Process Automation (RPA)
Setting up Power Automate Desktop

Building Desktop Flows

Recording desktop actions
Automating desktop applications

Advanced Desktop Flow Features

Using conditions and loops in desktop flows
Integrating with cloud flows

BUSINESS PROCESS FLOWS

Introduction to Business Process Flows

Understanding business process automation
Creating a simple business process flow

Customizing Business Process Flows

Defining stages and steps
Implementing business rules and logic

Advanced Business Process Flow Features

Using custom entities and fields
Integrating with power apps

PROJECTS

Power Automate Projects

Project 1: Automated Invoice Approval Workflow
Project 2 : Employee Onboarding Automation
Project 3: Social Media Post Scheduler
Project 4: Customer Support Ticketing System
Project 5: Monthly Sales Report Automation

Desktop Flows (RPA

Project 1: Automated Data Entry from Emails
Project 2: Invoice Processing and Archiving
Project 3: Automated Report Generation
Project 4: Customer Account Reconciliation
Project 5: Automated Data Migration

Power Apps Training Course for Working Professionals

INTRODUCTION TO POWER APPS

Overview of Power Apps

What is Power Apps?
Benefits and use cases
Types of Power Apps: Canvas, Model-Driven, and Portal Apps

Getting Started

Setting up your Power Apps environment
Navigating the Power Apps interface

DATA INTEGRATION AND MANAGEMENT

Connecting to Data Sources

Introduction to connectors
Connecting to common data sources (SharePoint, Excel, SQL Server, etc.)

Managing Data

Understanding data tables and collections

BUILDING YOUR FIRST CANVAS APP

Basics of Canvas Apps

Understanding Canvas Apps
Creating a simple Canvas App
Adding screens and navigation
Creating simple app to view details from data source.
Using simple forms to display and edit data

ADVANCED CANVAS APP FEATURES

User Experience Design

Designing responsive layouts
Using themes and templates
Best practices for user interface design

Working with Controls

Using different types of controls like

Button
Text input
Drop down
Combo Box
Date picker
List box
Radio
Text label
Vertical gallery
Horizontal gallery
Flexible height gallery
Blank Vertical gallery
Blank Horizontal gallery
Blank Flexible height gallery
Data table
Horizontal container
Vertical container
Container
Image
Icons
Shapes
Working with control properties

Working with Variables

Global variables
Context variable
Collections

Using formulas for dynamic form management

Functions to be used in forms

SubmitForm
EditForm
Clear
ClearCollect
Collect
Filter
If
Navigate
NewForm
Notify
Patch
Refresh
Search
Set
Text
ThisItem
Value

Advanced Controls and Features

Working with media (images, videos)
Implementing charts and graphs
Using Power Automate for workflows

INTRODUCTION TO MODEL-DRIVEN APPS

Basics of Model-Driven Apps

Understanding the Common Data Service (Dataverse)
Creating entities and relationships
Building a simple Model-Driven App

SECURITY AND ADMINISTRATION

Security in Power Apps

Understanding security roles and permissions
Implementing data security

App Management

Managing app versions
Publishing and sharing apps

BEST PRACTICES AND ADVANCED TOPICS

Performance Optimization

Tips for improving app performance
Debugging and troubleshooting techniques

Real-World Use Cases

Case studies and examples
Industry-specific applications

REALTIME PROJECTS

Project 1: Employee Leave Request App
Project 2: Inventory Management App
Project 3: Customer Feedback App
Project 4: Project Management Dashboard
Project 5: Sales Order Processing App

Objective: To put our entire learning to use and arrive at the best possible BI solution -using the right combination of available technologies.

Overview

Case Study 1
Case Study 2
Case Study 3

System Requirements

Power BI Desktop

Free & Downloadable from Microsoft Store App

https://www.microsoft.com/store/productid/9NTXR16HNW1T?ocid=pdpshare
Excel 2016 & above with PowerPivot

Available with Office 365 subscriptions that include desktop versions of Excel for Windows.
MS-SQL Server

https://www.microsoft.com/en-in/sql-server/sql-server-downloads

Kindly install Developer Edition as it is full-featured free edition, licensed for use as a development and test database in a non-production environment.
SQL Server Management Studio (SSMS)

Download and install SSMS from https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16

Course Fee

$ 1999^*

*Upgrade Fee for existing Power BI Students: $1299

Reserve My Seat

Connect with Us

Mr. Perrie Smith

Business Associate

Tel: +1 650 491 3131

Email: inquiry_fsbi@excelgoodies.com

Connect us on

7.9k

1.8k

804

Course Fee

$ 1999^*

*Upgrade Fee for existing Power BI Students:
$1299

What's included?

8 Excel Reports & Models
12 Power BI + DAX Dashboards
6 Power Query Projects
6 Power Pivot Models
5 Power Apps Projects
5 Power Automate Projects

5 Workflows (RPA) Projects
5 MS-SQL Projects
4 Power BI + DAX + PQ Based Dashboards
3 Power BI + DAX + PQ + SQL Based Dashboards
9 Master Projects Using Power BI, DAX, PQ, SQL
Power Automate, Power Apps etc.

Training Schedule

Week 1 :
Quick Excel Brush-up - Advanced Formulas & Functions

Thu, Jan 09 & Fri, Jan 10

Week 2 :
Power BI & DAX Fundamentals Advanced DAX Function, Power Query & Power Pivot

Mon, Jan 13 through Fri, Jan 17

Week 3 :
Power BI & DAX Fundamentals Advanced DAX Function, Power Query & Power Pivot

Tue, Jan 21 through Fri, Jan 24

Week 4 :
T-SQL & Power BI Administration

Mon, Jan 27 & Tue, Jan 28

Week 5 :
Power Apps & Power Automate

Mon, Feb 10 through Fri, Feb 14

Week 6 :
Power Apps & Power Automate

Tue, Feb 18 through Fri, Feb 21

Week 7 :
Project Scenarios using Power BI, Power Automate, Power Apps & SQL

Mon, Feb 24 & Tue, Feb 25

NEW

Upcoming Batch

Starts On

Course Fee

$1999*

*($1299 for Excelgoodies Power BI Students)

Or Click here to view next cohort dates.

CORPORATE
Training 5 or
more people?

Avail additional 10% Corporate Benefit^*
on the total course fee for 5+ participants.
Get you team BI ready, today.

*Available until Nov 30, 2024.

Training Schedule

Training Agenda

Week 1 :
Quick Excel Brush-up - Advanced Formulas & Functions

Thu, Jan 09 & Fri, Jan 10

Week 2 :
Power BI & DAX Fundamentals Advanced DAX Function, Power Query & Power Pivot

Mon, Jan 13 through Fri, Jan 17

Week 3 :
Power BI & DAX Fundamentals Advanced DAX Function, Power Query & Power Pivot

Tue, Jan 21 through Fri, Jan 24

Week 4 :
T-SQL & Power BI Administration

Mon, Jan 27 & Tue, Jan 28

Week 5 :
Power Apps & Power Automate

Mon, Feb 10 through Fri, Feb 14

Week 6 :
Power Apps & Power Automate

Tue, Feb 18 through Fri, Feb 21

Week 7 :
Project Scenarios using Power BI, Power Automate, Power Apps & SQL

Mon, Feb 24 & Tue, Feb 25

7 Specialist Certificates

You'll honored with total of 7-certificates
throughout the program.

Certificate : MS-Excel Associate

Level :

Exam ID : EG-901

Eligibility : On clearing post-training assessment

Certificate : MIS Reporting & Business Modeling Specialist using MS-Excel

Level :

Exam ID : EG-902

Eligibility : On clearing post-training assessment

Certificate : Data Analysis & Dashboard Associate using Power BI

Level :

Exam ID : EG-905

Eligibility : On clearing post-training assessment

Certificate : Data Analytics & BI Developer using MS-SQL & Power BI

Level :

Exam ID : EG-906

Eligibility : On clearing post-training assessment

Certificate : Workflow Specialist using Power Automate

Level :

Exam ID : EG-904

Eligibility : On implementing a Live VBA project

Certificate : Power Apps Business Solutions Expert

Level :

Exam ID : EG-907

Eligibility : On clearing post-training assessment

Certificate : Fullstackbi Reporting & Automation Specialist (On-Cloud)

Level :

Exam ID : FSBI-001

Eligibility : On securing above 8-certificates

About Your Trainer

Mr. Sami

MCT, MCP, MEE, MOS

Mr. Sami

MCT, MCP, MEE, MOS

30,000+

Students Trained

18+

Year of Experience

4.9

Reviews

Mr. Sami is an exceptionally accomplished and certified Microsoft Trainer, possessing extensive expertise in the fields of Finance, HR, and Information Technology. With an impressive 14-year tenure in the industry, he has successfully trained and empowered over 23,000 professionals, and the number continues to grow.

He has undertaken assignments with the renowned IRS, The World Bank, Tata Chemicals, Buckman Laboratories, Standard Chartered, ING Barings and much more. His nature of going that Extra Mile has got him the startling popularity amongst the Excelgoodies prominent clients.

With his wealth of knowledge and dedication to delivering exceptional training experiences, Mr. Sami consistently exceeds the expectations of his clients and leaves a lasting impact on the professionals he trains.

Throughout his illustrious career, Mr. Sami has collaborated with esteemed organizations such as the IRS, The World Bank, Mercedez-Benz, Comcast, Standard Chartered, and ING Barings, to name just a few. His unwavering commitment to going the extra mile has earned him a stellar reputation among Excelgoodies' prominent clients.