+1 650 491 3131

Batch starts on

th

Powerful Business Intelligence for all.

Power BI - Data Analytics, Modeling & Advanced Reporting

25-hours Course | 12 BI Dashboards | 5 Other Projects | View Schedule

View Schedule

Program at a Glance

TOTAL COURSE DURATION

25-hours, 10 Sessions

Live Online (Weekdays)

TRAINING SCHEDULE

View Schedule View Schedule

COURSE FEE

$699

Enroll Now

CERTIFICATE

Data Analysis & Dashboard Associate Using Power BI

Sample Certificate

Create a data-driven story with Power BI reports.

Data analytics is one of the hottest IT skills and Power BI is an extremely demanded analytics
service. This engaging, practical, and hands-on course begins with a quick data visualization of a
dataset; you will use this example to get hands-on and master data storytelling.

ExcelGoodies
ExcelGoodies
ExcelGoodies
ExcelGoodies
ExcelGoodies
ExcelGoodies

What will I learn?

Learn how to build and use Power BI business intelligence reports.

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.

ExcelGoodies

Why should I learn Power BI

DAX Formulas

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.

ExcelGoodies

Why should I learn DAX

Data Transformation with Power Query

Whether you're consolidating multiple data sources, handling diverse data formats, or crafting dynamic queries, this versatile tool ensures efficiency and precision in your data preparation, spanning from data cleansing to advanced transformations.

ExcelGoodies

Why should I learn Power BI

Data Analysis 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.

ExcelGoodies

Why should I 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.

ExcelGoodies

Why should I learn MS-SQL?

Taught by Microsoft Certified Trainers.

*

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

Course Content Overview

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

Introduction to PowerBI Building Blocks of Power BI
  • Visualizations
  • Datasets
  • Reports
  • Dashboards
  • Tiles
Getting Comfortable With Power BI Environment
  • Connect to Data Sources in Power BI Desktop
  • Cleaning Irregularly Formatted Date and Transform Your Data With the Query Editor
  • Create a report in Power BI Desktop
  • Publish the report in the Power BI service
Data Modelling with Power BI
  • Fundamentals of Modelling
  • 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
  • How to Use Combination Charts
  • 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.
  • Creating Interactions Between Visualizations
  • Visual hierarchies and drill-down behaviour
Exploring Data
  • Exploring Data
  • Use Quick Insights in the Power BI service
  • Create and Configure A Dashboard
  • Ask Questions of Your Data With Natural Language
  • Share Dashboards with your organization
  • Display Visuals and Tiles Full-Screen
Power BI and Excel
  • Power BI and Excel
  • Import an Excel table into Power BI
  • Import Excel files with data models and Power View sheets
  • Connect OneDrive for Business to Power BI
  • Excel data in Power BI summary
Publishing and Sharing
  • Publishing and Sharing
  • Publish Reports from Power BI Desktop to the Power BI Service
  • Print and export Power BI dashboards
  • Manually Republish and Refresh Your Data
  • Introducing Power BI Mobile
  • Create a group in Power BI
  • Create a content pack in Power BI
  • Connect to a content pack from a group in Power BI
  • Edit a content pack in Power BI
  • Integrate OneDrive for Business with Power BI
  • Publish a report to the web from Power BI
Introduction to PowerPivot
  • Limitation of Excel Functions
  • Limitation of Excel PivotTable
  • Why PowerPivot?
  • PowerPivot Features - Overview
PowerPivot Environment
  • Opening PowerPivot Environment
  • Understanding External Data Section
  • Understanding Formatting
  • PowerPivot Views
  • Understanding Measures
Taking Data into PowerPivot
  • From Excel
  • From MS Access
  • From Ms-SQL
  • From Custom Query
  • From Text Files
  • From Other Sources
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
  • Using UNION QUERIES
Data visualization Using
  • Power View
  • Charts, Score Cards and Dashboards
  • Slicers
  • Map Visualizations
  • Data Binding and Formatting
Creating Advanced Dashboards with PowerPivot
Introduction to Microsoft Power Query for Excel Import data from external data sources Import with Standard Connectors
  • Connect to a Text or CSV file
  • Connect to a Web page
  • Connect to an Excel Table/Range
Import Data from a File
  • Connect to an Excel workbook
  • Connect to a Text or CSV file
  • Connect to an XML file
  • Connect to a JSON file
Import Data from a Database
  • Connect to a SQL Server database
  • Connect to an Access database
  • Connect to a MySQL database
Import Data from Online Services
  • Connect to Salesforce Objects
  • Connect to a Sharepoint Online List
  • Connect to Facebook
Import Data from Other Sources
  • Connect to an Excel Table or Range
  • Connect to a Web page
Shape data from Multiple Data Sources
  • Shape or transform a query
  • Refresh a query
  • Combine data from multiple data sources
  • Filter a table
  • Sort a table
  • Group rows in a table
  • Expand a column containing an associated table
  • Aggregate data from a column
  • Insert a custom column into a table
  • Combine multiple queries
  • Merge columns
  • Remove columns
  • Remove rows with errors
  • Promote a row to column headers
  • Split a column of text
  • Insert a query to the worksheet
Performing Calculations using DAX Functions
  • Table-Valued Functions
  • 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()
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
UNDERSTANDING TRANSACT-SQL DATA TYPES
  • Dates
  • Strings
  • Numeric
  • BLOBs
  • Bits
  • UNIQUEIDENTIFIER
  • Cursor Variables
  • Timestamps
DDL INSIGHTS
  • CREATE TABLE
  • Dropping Objects
  • CREATE INDEX
  • TEMPORARY OBJECTS
  • Object Naming and Dependencies
DML INSIGHTS
  • INSERT
  • UPDATE
  • DELETE
  • Detecting DML Errors
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
WORKING WITH VIEWS
  • ANSI SQL Schema VIEWs
  • Getting a VIEW's Source Code
  • Updatable VIEWs
  • Derived Tables
  • Dynamic VIEWs
  • Partitioning Data Using Views
  • View Restrictions
  1. Power BI Desktop

    Free & Downloadable from Microsoft Store App

    https://www.microsoft.com/store/productid/9NTXR16HNW1T?ocid=pdpshare

  2. Excel 2016 & above with PowerPivot

    Available with Office 365 subscriptions that include desktop versions of Excel for Windows.

  3. 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.

  4. 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

Training Schedule

Session Date Time (ET)

Course Fee

$699

What is included?

  • 25 hours of Instructor-led training.
  • Power BI & Power Query Projects & related case studies.
  • 30-Days post training support (via Email).
  • BI Reporting Specialist Certificate
View Certificate

Connect with Us

Mr. Perrie Smith

Business Associate

Tel: +1 650 491 3131

Email: inquiry_excel@excelgoodies.com

Connect us on

About Your Trainer

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.

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.

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.

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.

Course Content Overview

A snapshot of what you'll be learning in 2 weeks

Introduction to PowerBI Building Blocks of Power BI
  • Visualizations
  • Datasets
  • Reports
  • Dashboards
  • Tiles
Getting Comfortable With Power BI
Environment
  • Connect to Data Sources in Power BI Desktop
  • Cleaning Irregularly Formatted Date and Transform Your Data With the Query Editor
  • Create a report in Power BI Desktop
  • Publish the report in the Power BI service
Data Modelling with Power BI
  • Fundamentals of Modelling
  • 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
  • How to Use Combination Charts
  • 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.
  • Creating Interactions Between Visualizations
  • Visual hierarchies and drill-down behaviour
Exploring Data
  • Exploring Data
  • Use Quick Insights in the Power BI service
  • Create and Configure A Dashboard
  • Ask Questions of Your Data With Natural Language
  • Share Dashboards with your organization
  • Display Visuals and Tiles Full-Screen
Power BI and Excel
  • Power BI and Excel
  • Import an Excel table into Power BI
  • Import Excel files with data models and Power View sheets
  • Connect OneDrive for Business to Power BI
  • Excel data in Power BI summary
Publishing and Sharing
  • Publishing and Sharing
  • Publish Reports from Power BI Desktop to the Power BI Service
  • Print and export Power BI dashboards
  • Manually Republish and Refresh Your Data
  • Introducing Power BI Mobile
  • Create a group in Power BI
  • Create a content pack in Power BI
  • Connect to a content pack from a group in Power BI
  • Edit a content pack in Power BI
  • Integrate OneDrive for Business with Power BI
  • Publish a report to the web from Power BI
Introduction to PowerPivot
  • Limitation of Excel Functions
  • Limitation of Excel PivotTable
  • Why PowerPivot?
  • PowerPivot Features - Overview
PowerPivot Environment
  • Opening PowerPivot Environment
  • Understanding External Data Section
  • Understanding Formatting
  • PowerPivot Views
  • Understanding Measures
Taking Data into PowerPivot
  • From Excel
  • From MS Access
  • From Ms-SQL
  • From Custom Query
  • From Text Files
  • From Other Sources
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
  • Using UNION QUERIES
Data visualization Using
  • Power View
  • Charts, Score Cards and Dashboards
  • Slicers
  • Map Visualizations
  • Data Binding and Formatting
Creating Advanced Dashboards with
PowerPivot
Introduction to Microsoft Power Query
for Excel
Import data from external data sources Import with Standard Connectors
  • Connect to a Text or CSV file
  • Connect to a Web page
  • Connect to an Excel Table/Range
Import Data from a File
  • Connect to an Excel workbook
  • Connect to a Text or CSV file
  • Connect to an XML file
  • Connect to a JSON file
Import Data from a Database
  • Connect to a SQL Server database
  • Connect to an Access database
  • Connect to a MySQL database
Import Data from Online Services
  1. Connect to Salesforce Objects
  2. Connect to a Sharepoint Online List
  3. Connect to Facebook
Import Data from Other Sources
  • Connect to an Excel Table or Range
  • Connect to a Web page
Shape data from Multiple Data Sources
  • Shape or transform a query
  • Refresh a query
  • Combine data from multiple data sources
  • Filter a table
  • Sort a table
  • Group rows in a table
  • Expand a column containing an associated table
  • Aggregate data from a column
  • Insert a custom column into a table
  • Combine multiple queries
  • Merge columns
  • Remove columns
  • Remove rows with errors
  • Promote a row to column headers
  • Split a column of text
  • Insert a query to the worksheet
Performing Calculations using DAX Functions
  • Table-Valued Functions
  • 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()
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
UNDERSTANDING TRANSACT-SQL DATA TYPES
  • Dates
  • Strings
  • Numeric
  • BLOBs
  • Bits
  • UNIQUEIDENTIFIER
  • Cursor Variables
  • Timestamps
DDL INSIGHTS
  • CREATE TABLE
  • Dropping Objects
  • CREATE INDEX
  • TEMPORARY OBJECTS
  • Object Naming and Dependencies
DML INSIGHTS
  • INSERT
  • UPDATE
  • DELETE
  • Detecting DML Errors
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
WORKING WITH VIEWS
  • ANSI SQL Schema VIEWs
  • Getting a VIEW's Source Code
  • Updatable VIEWs
  • Derived Tables
  • Dynamic VIEWs
  • Partitioning Data Using Views
  • View Restrictions

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

Objective: It complements Power Pivots and Power BI better than any other DB.

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

UNDERSTANDING TRANSACT-SQL DATA TYPES

  • Dates
  • Strings
  • Numeric
  • BLOBs
  • Bits
  • UNIQUEIDENTIFIER
  • Cursor Variables
  • Timestamps

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: 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

  1. Power BI Desktop

    Free & Downloadable from Microsoft Store App

    https://www.microsoft.com/store/productid/9NTXR16HNW1T?ocid=pdpshare

  2. Excel 2016 & above with PowerPivot

    Available with Office 365 subscriptions that include desktop versions of Excel for Windows.

  3. 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.

  4. 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

$699

What is included?

  • 25 hours of Instructor-led training.
  • Power BI & Power Query Projects & related Case Studies.
  • 30-Days post training support (via Email).
  • BI Reporting Specialist Certificate
View Certificate
*

These advanced concepts are part of our Full Stack BI course and are available for an additional cost, in addition to the regular Power BI course.

READY TO BE CERTIFIED AS A

BI Reporting Specialist?

Training Schedule

Session Date Time (ET)

Certifications

Data Analysis & Dashboard Associate Using Power BI
Eligibility:
On clearing post-training assessment.
View Sample Certificate

Connect with Us

Mr. Perrie Smith

Business Associate

Tel: +1 650 491 3131

Email: inquiry_powerbi@excelgoodies.com

Connect us on

About Your Trainer

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.

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.

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.

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.

Why Power BI skill is highly sought after?

ExcelGoodies

USD 90,000

is the annual average salary of

Data Scientist using Power BI

ExcelGoodies

2,50,000

Companies have

implemented Power BI

ExcelGoodies

97%

Fortune 500 Companies use

Power BI

ExcelGoodies

Top Leader

in Analytics & BI for 14th

Consecutive Year.

Source:

ExcelGoodies ExcelGoodies ExcelGoodies

Few Real­world Use Cases of Power BI Reporting

Power BI Use Cases Across Industries: Finance to Healthcare.

READY TO BE CERTIFIED AS A

BI Reporting Specialist?

Few Real­world Use Cases of Power BI Reporting

Power BI Use Cases Across Industries: Finance to Healthcare.

Learner stories around the world!

Reviews

  • Trainer's Expertise
  • Course Structure
  • Course Content
  • Assignments
  • Certification Process

Scott A. Reifsynder

Chief Financial Officer

Nexterus

This class was extremely helpful in my knowledge and growth in these database, analysis and reporting tools. I really enjoyed the hands-on approach and got lots of “goodies” out of all the classes. Your approach, repetitiveness and patience is much appreciated and sincerely helped...

Josh Grenzsund

Director of Business Development

DOWL

This was a very good course where I learned high level concepts of data management (how it moves/should move) for business users, the concepts for querying and organizing data sets, the interaction and use of various tools/software, and detailed work with DAX and SQL expressions...

Frank Young

Business Analyst

It was indeed some good learning! Sessions were highly informative with loaded tips here and there by Sami on remembering concepts and implementing it back at work.

I really enjoyed Assignments session which truly boosted my confidence in Automation...

Karen Smith

Quantitative Analyst

Good sessions. Highly passionate trainer. Sami was quick enough to identify the skill sets and the knowledge of the participants to pace his training accordingly.

His way of simplifying the coding concepts was just spell bounding. He knew his students...

Cody K

Risk Reporting Developer

A well-structured program. The flow of training was carried out pretty well by the tutor. Enjoyed working with case studies and the concepts were taught in the simplest way

It made me much more confident to assume...

Learner stories around the world!

Learner stories around
the world

Total Reviews

4583

Overall growth till now

Average Rating

4.9

Average rating this year

Graph

5

2.0K

4

1.0K

3

500

2

200

1

0

Star Rating

Trainer's Expertise

Course Structure

Course Content

Assignments

Certification Process

ExcelGoodies

Scott A. Reifsynder

Power BI Training

Chief Financial Officer

Nexterus

United States

This class was extremely helpful in my knowledge and growth in these database, analysis and reporting tools. I really enjoyed the hands-on approach and got lots of “goodies” out of all the classes. Your approach, repetitiveness and patience is much appreciated and sincerely helped me learn how to accomplish these important tasks. Doing these activities again and again embedded these processes into my routines while I began strategizing how to best utilize these tools in my company’s reporting and analyses. I’d be happy to consider additional classes that you offer on related, important topics to continue enhancing my skills. Thank you very much for your teaching and training methods. I am also very grateful that you provided the daily sample dashboards, instruction steps and how-to descriptions.

ExcelGoodies

Wendy Flowers

Power BI Training

Financial and Business Analyst

First Light

United States

This Power BI course was an exceptional training experience. It was very fast paced -- necessary as it covered Power Pivots, Power Query, DAX, Power BI, and SQL. Sami ran the training smoothly, staying after to help individuals with questions. We also are able to schedule up to two 30-minute sessions after the end of the course for guidance on projects. Highly recommend!

ExcelGoodies

Tim Palacios

Power BI Training

WFM Data Developer

World Connection

United States

This course was excellent. Sami had a systematic approach to the course curriculum which I feel is key to most if not all learning experiences. He was very knowledgeable and very quick with troubleshooting and helping support when we had any challenges with our work. I am definitely going to take more courses from Excelgoodies. If you are an IT professional or require Data Analytics for your job, this is a great course and I highly recommend it. I think my only critique is that I would have like to have more time devoted to the database side of the class, but that is just a personal preference.

Learner stories
around the world

Total Reviews

4583

Overall growth till now

Average Rating

4.9

Average rating this year

Industry Insights

ExcelGoodies

Power BI

7 Advanced DAX Functions to Supercharge Your Power BI Reports

ExcelGoodies

Power BI

Creating Mobile-Friendly Reports with Power BI

ExcelGoodies

Power BI

The Fast-Food Chain Data Story with Power BI: Do’s & Don’ts of data storytelling

Recommended Course (For Advanced Reporting Users Only)

Full Stack BI R
Reporting & Automation Course.

72 Sessions | 9-Specialist Certifications

You will learn to use the right and hybrid technology for end-to-end advanced power reporting.

Tools: Power BI, Power Pivot, VBA, Excel,
M-Programming, MS-SQL, SSIS, and many more.

Power BI

Micorsoft T-SQL

MS-SQL Integrated Services

Python

Microsoft Excel VBA

MS-Excel

Power Query