You are on Excelgoodies.com (USA)

You can browse Excelgoodies India for more location-specific courses.

or

www.excelgoodies.in

Talk to you soon.

Please wait while we are processing your request….

Thank you for contacting us! We will get back to you soon!

Please enter your name
Invalid Email ID
Invalid phone number
Please select preferred time to call
Please enter message

Prove you're human: Type the code shown.

=
Invalid Catcha Code
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.

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.

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.

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

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

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.

Why should I learn VBA?

Primary objective of learning VBA is to collect data from multiple and ad-hoc sources before uploading it to the SQL for reporting purpose.

  • Reading Outlook emails and updating it to SQL Database.
  • Reading PDF documents
  • Scrapping websites and updating it to Database
  • Performing Data transformations in Excel before importing into SQL
Why should I learn VBA?

Primary objective of learning VBA is to collect data from multiple and ad-hoc sources before uploading it to the SQL for reporting purpose.

  • Reading Outlook emails and updating it to SQL Database.
  • Reading PDF documents
  • Scrapping websites and updating it to Database
  • Performing Data transformations in Excel before importing into SQL
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.

+1 650 491 3131

+1 650 491 3131

Full Stack BI Reporting & Automation Course

Aviation Data Professionals.

Do you want to take your data analysis and reporting skills to the next level while also learning about automation?
Unlock the full potential of your data with our Full Stack BI Reporting Course tailored specifically for the aviation industry.

Please enter your name
Invalid Email ID
Invalid phone number
Please select preferred time to call

Prove you're human: Type the code shown.

=
Invalid Catcha Code
Please wait while we are processing your request. Thank you for contacting us! We will get back to you soon!

INTRODUCTION

In this course, you will learn how to harness the power of cutting-edge technologies like Power BI, MS-SQL, ETL, VBA, and Python to generate
advanced end-to-end reports in aviation industry. Our expert instructors bring real-world experience and industry insights to the course, ensuring
that you learn the latest best practices and cutting-edge techniques.

In this course, you will learn how to harness the power of cutting-edge technologies like Power BI, MS-SQL, ETL, VBA, and Python to generate advanced end-to-end reports. Our expert instructors bring real-world experience and industry insights to the course, ensuring that you learn the latest best practices and cutting-edge techniques.

COURSE

We've designed this course specifically for aviation data
professionals and offer it exclusively to aviation companies.

BI CONSULTING

From analyzing supply chain data to optimizing logistics operations,
we'll help you leverage your data to make better decisions and
improve your bottom line.

Our team of experts will work closely with you to understand your
unique challenges and develop customized solutions that meet your
specific needs.

Is a tailor-made course not what you're looking for? No problem! Join hundreds of other individuals in our vibrant regular Full Stack BI Reporting & Automation course

Is a tailor-made course not what you're looking for? No problem! Join hundreds of other individuals in our vibrant regular

Key Aviation Reports You'll Be Working With

Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy

Key Reports You'll Learn

1

Passenger Load Factor Report

2

Route Profitability Report

3

Safety Incident Report

4

Flight Operations Report

5

Fuel Efficiency Report

6

Aircraft Maintenance Report

7

Airline Revenue Report

8

Customer Satisfaction Report

9

Crew Utilization Report

10

Airline KPI Report

Tools You'll Learn

Visualization Tool

Microsoft Power BI

Data Modeling Tool

Power Pivot

Data Integrator Tool

ETL with SSIS

Data Transformation Tool

Power Query

Data Warehousing Tool

MS-SQL

Automation Tool

VBA & Python

Key Aviation Reports You'll Be Working With

Lorem ipsum dolor sit amet, consetetur sadipscing elitr,

Key Reports You'll Learn

1

Passenger Load Factor Report

2

Route Profitability Report

3

Safety Incident Report

4

Flight Operations Report

5

Fuel Efficiency Report

6

Aircraft Maintenance Report

7

Airline Revenue Report

8

Customer Satisfaction Report

9

Crew Utilization Report

10

Airline KPI Report

Tools You'll Learn

Visualization Tool

Microsoft Power BI

Data Integrator Tool

ETL with SSIS

Data Transformation Tool

Power Query

Data Modeling Tool

Power Pivot

Data Warehousing Tool

MS-SQL

Automation Tool

VBA & Python

Course Content - Overview

Learn the entire suite of tools and technologies involved in building a complete BI solution.

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?

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?

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?

Ad-hoc Automations using VBA

When company environment doesn't support Power Apps, it is tools like VBA which comes to rescue. This section will explore the power of VBA and help you automate processes or tasks which otherwise is not possible using Power BI tools.

Why should I learn VBA?

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?

Course Snapshot

Duration

6-Weeks, 30 Sessions

Online live classes, Instructor-led.

Cohort Date

Tuesday, July 11

View Shedule

Certificate

9-Specialist Certificates

List of Certificates

1:1 Mentorship

15-hours | Project-based

View Details

COURSE SNAPSHOT

Duration

6-Weeks, 30 Sessions

Online live classes, Instructor-led.

Cohort Date

Tuesday, July 11

View Shedule

Certificate

9-Specialist Certificates

List of Certificates

1:1 Mentorship

15-hours | Project-based

View Details

Detailed Course Content

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

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

Objective: To collect data from multiple ad-hoc sources and prepare it for loading it to SQL Database for BI Reporting purpose.

Overview

  • Core Fundamentals of VBA
  • Understanding VBA Environment
  • Writing simple VBA Codes
  • Concept of Variables & Data Types
  • Testing & Debugging Code
  • Understanding Fundamental Coding Blocks
  • IF Block
  • Select Case
  • And / Or Conditions
  • Understanding Fundamentals of Looping
  • For Loop
  • Do While
  • Understanding Object Based Programming
  • Advanced Excel Automations
  • Word Automation
  • Outlook Automation
  • Working with Database
  • Working with Web Browsers - Web Scrapping
  • Creating User Interfaces with VBA Forms
  • Handling Run Time Errors & Securing Code

Objective: To collect data from multiple ad-hoc sources and prepare it for loading it to SQL Database for BI Reporting purpose.

Overview

  • Core Fundamentals of Python
  • Understanding Python Development Environment
  • Understanding Data Types
  • Concept of Variables & Operators
  • Functions including String, Math, Date, Time, etc
  • Files and Modules in Python
  • Understanding Fundamental Coding Blocks
  • IF Block
  • Select Case
  • And / Or Conditions
  • Understanding Fundamentals of Looping
  • For Loop
  • Do While
  • Understanding Object Oriented Programming in Python
  • Data Analysis Process
  • Python Nympy - Shape, Size, Arrays, Agregation, Comparisons, Transposing, etc
  • Reporting & Data Analysis with Power BI ,Python & SQL
  • Web Scrapping with Python

Objective: Extract Data from multiple data sources, transform them with SSIS or M-Program transformation options and, Load it to Reporting Database / Data Warehouse

Understanding SSIS Packages

Creating & Managing Connections with Connection Manager

  • Importing Data With ADO.NET
  • Importing Data From Excel
  • Importing Data From Flat Files
  • Importing Data From FTP
  • Importing Data From SMTP
  • Working with Multiple Connections
  • Working with Control Flows
  • Working with Data Flows
  • Working with Variables & Expressions

Performing Transformations

  • Aggregation Transformations
  • Audit Transformations
  • Conditional Split Transformations
  • Data Conversion Transformations
  • DQS Cleansing Transformations
  • Derived Columns Transformations
  • Export Column Transformation
  • Fuzzy Grouping Transformation
  • Fuzzy Lookup Transformation
  • Lookup Transformation
  • Merge Transformation
  • Merge Join Transformation
  • Pivot Transformation
  • Unpivot Transformation
  • Row Count Transformation
  • Sort Transformation

Loading Data to SQL Server

Advanced SQL Concepts

DML INSIGHTS

  • INSERT
  • UPDATE
  • DELETE
  • Detecting DML Errors

Understanding 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

SQL VIEWS

  • Create & Manage VIEWs
  • Getting a VIEW's Source Code
  • Updatable VIEWs
  • Derived Tables
  • Dynamic VIEWs
  • Partitioning Data Using Views
  • View Restrictions

Stored Procedures

  • Stored Procedure Advantages
  • Internals
  • Creating Stored Procedures, Executing Stored Procedures
  • Environmental Concerns
  • Parameters for Procedures
  • Important Automatic Variables
  • Flow Control Language
  • Errors
  • Nesting
  • AutoStart Procedures
  • User Defined Functions
  • Scalar UDFs
  • Table-Valued UDFs
  • Per-Row UDFs

Working with Date & Time

  • Date and Time Data Types
  • Date and Time Manipulation
  • Date and Time Functions
  • Literals
  • Identifying Weekday
  • Handling Date-only or Time-only Data Prior to SQL Server 2008
  • Examples of Date and Time Calculations
  • Rounding Issues
  • Date- and Time-Related Querying Problems
  • Age Problems
  • Overlaps
  • Grouping by the Week
  • Working Days
  • Generating a Series of Dates

SETS

  • Unions
  • Differences
  • Intersections
  • Subsets

Transactions

  • Transactions Defined
  • How SQL Server Transactions Work
  • Types of Transactions
  • Avoiding Transactions Altogether
  • Automatic Transaction Management
  • Transaction Isolation Levels
  • Transaction Commands and Syntax
  • Debugging Transactions
  • Optimizing Transactional Code

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 at https://powerbi.microsoft.com/en-us/get-started/

  2. Excel 2016 & above with PowerPivot

    Available with Office 365 subscriptions that include desktop versions of Excel for Windows. Also available with certain onetime office purchases. Refer https://support.office.com/en-us/article/where-is-power-pivot-aa64e217-4b6e-410b-8337-20b87e1c2a4b for more information

  3. SQL Server Development Tools (SSDT)

    Refer https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver15

  4. Visual Studio 2017 & above

    Visual Studio Community Edition is Free and can be downloaded fromhttps://visualstudio.microsoft.com/vs/

  5. MS-SQL Server

    Free & Downloadable at https://www.microsoft.com/en-us/sql-server/sql-server-editions-express/

  6. SSIS

    It comes along with your SQL Server License.

Course Fee

$ 1999*

What is included?

  • 8 Excel Reports & Models
  • 12 Power BI + DAX Dashboards
  • 6 Power Query Projects
  • 6 Power Pivot Models
  • 6 Power Query Projects
  • 7 ETL Projects
  • 5 MS-SQL Projects
  • 14 VBA Automation Scenarios
  • 4 Power BI + DAX + PQ Based Dashboards
  • 3 Power BI + DAX + PQ + SQL Based Dashboards
  • 9 Master Projects Using Power BI, DAX, PQ, SQL VBA, Web-Scrapping, API Integration, etc.
Read More Close

Course Content

A snapshot of what you'll be learning in 12-weekends

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

Objective: To collect data from multiple ad-hoc sources and prepare it for loading it to SQL Database for BI Reporting purpose.

Overview

  • Core Fundamentals of VBA
  • Understanding VBA Environment
  • Writing simple VBA Codes
  • Concept of Variables & Data Types
  • Testing & Debugging Code
  • Understanding Fundamental Coding Blocks
  • IF Block
  • Select Case
  • And / Or Conditions
  • Understanding Fundamentals of Looping
  • For Loop
  • Do While
  • Understanding Object Based Programming
  • Advanced Excel Automations
  • Word Automation
  • Outlook Automation
  • Working with Database
  • Working with Web Browsers - Web Scrapping
  • Creating User Interfaces with VBA Forms
  • Handling Run Time Errors & Securing Code

Objective: To collect data from multiple ad-hoc sources and prepare it for loading it to SQL Database for BI Reporting purpose.

Overview

  • Core Fundamentals of Python
  • Understanding Python Development Environment
  • Understanding Data Types
  • Concept of Variables & Operators
  • Functions including String, Math, Date, Time, etc
  • Files and Modules in Python
  • Understanding Fundamental Coding Blocks
  • IF Block
  • Select Case
  • And / Or Conditions
  • Understanding Fundamentals of Looping
  • For Loop
  • Do While
  • Understanding Object Oriented Programming in Python
  • Data Analysis Process
  • Python Nympy - Shape, Size, Arrays, Agregation, Comparisons, Transposing, etc
  • Reporting & Data Analysis with Power BI ,Python & SQL
  • Web Scrapping with Python

Objective: Extract Data from multiple data sources, transform them with SSIS or M-Program transformation options and, Load it to Reporting Database / Data Warehouse

Understanding SSIS Packages

Creating & Managing Connections with Connection Manager

  • Importing Data With ADO.NET
  • Importing Data From Excel
  • Importing Data From Flat Files
  • Importing Data From FTP
  • Importing Data From SMTP
  • Working with Multiple Connections
  • Working with Control Flows
  • Working with Data Flows
  • Working with Variables & Expressions

Performing Transformations

  • Aggregation Transformations
  • Audit Transformations
  • Conditional Split Transformations
  • Data Conversion Transformations
  • DQS Cleansing Transformations
  • Derived Columns Transformations
  • Export Column Transformation
  • Fuzzy Grouping Transformation
  • Fuzzy Lookup Transformation
  • Lookup Transformation
  • Merge Transformation
  • Merge Join Transformation
  • Pivot Transformation
  • Unpivot Transformation
  • Row Count Transformation
  • Sort Transformation

Loading Data to SQL Server

Advanced SQL Concepts

DML INSIGHTS

  • INSERT
  • UPDATE
  • DELETE
  • Detecting DML Errors

Understanding 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

SQL VIEWS

  • Create & Manage VIEWs
  • Getting a VIEW's Source Code
  • Updatable VIEWs
  • Derived Tables
  • Dynamic VIEWs
  • Partitioning Data Using Views
  • View Restrictions

Stored Procedures

  • Stored Procedure Advantages
  • Internals
  • Creating Stored Procedures, Executing Stored Procedures
  • Environmental Concerns
  • Parameters for Procedures
  • Important Automatic Variables
  • Flow Control Language
  • Errors
  • Nesting
  • AutoStart Procedures
  • User Defined Functions
  • Scalar UDFs
  • Table-Valued UDFs
  • Per-Row UDFs

Working with Date & Time

  • Date and Time Data Types
  • Date and Time Manipulation
  • Date and Time Functions
  • Literals
  • Identifying Weekday
  • Handling Date-only or Time-only Data Prior to SQL Server 2008
  • Examples of Date and Time Calculations
  • Rounding Issues
  • Date- and Time-Related Querying Problems
  • Age Problems
  • Overlaps
  • Grouping by the Week
  • Working Days
  • Generating a Series of Dates

SETS

  • Unions
  • Differences
  • Intersections
  • Subsets

Transactions

  • Transactions Defined
  • How SQL Server Transactions Work
  • Types of Transactions
  • Avoiding Transactions Altogether
  • Automatic Transaction Management
  • Transaction Isolation Levels
  • Transaction Commands and Syntax
  • Debugging Transactions
  • Optimizing Transactional Code

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 at https://powerbi.microsoft.com/en-us/get-started/

  2. Excel 2016 & above with PowerPivot

    Available with Office 365 subscriptions that include desktop versions of Excel for Windows. Also available with certain onetime office purchases. Refer https://support.office.com/en-us/article/where-is-power-pivot-aa64e217-4b6e-410b-8337-20b87e1c2a4b for more information

  3. SQL Server Development Tools (SSDT)

    Refer https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver15

  4. Visual Studio 2017 & above

    Visual Studio Community Edition is Free and can be downloaded fromhttps://visualstudio.microsoft.com/vs/

  5. MS-SQL Server

    Free & Downloadable at https://www.microsoft.com/en-us/sql-server/sql-server-editions-express/

  6. SSIS

    It comes along with your SQL Server License.

Course Fee

$ 1999*

650-591-3131

What is included?

  • 8 Excel Reports & Models
  • 12 Power BI + DAX Dashboards
  • 6 Power Query Projects
  • 6 Power Pivot Models
  • 6 Power Query Projects
  • 7 ETL Projects
  • 5 MS-SQL Projects
  • 14 VBA Automation Scenarios
  • 4 Power BI + DAX + PQ Based Dashboards
  • 3 Power BI + DAX + PQ + SQL Based Dashboards
  • 9 Master Projects Using Power BI, DAX, PQ, SQL VBA, Web-Scrapping, API Integration, etc.

Training Schedule

Week 1 - Quick Excel Brush-up & Power BI

Mon, Sep 18 through Fri, Sep 22

11:00 AM to 1:00 PM ET

( Project 1: Aviation )

Week 2 - DAX Function & Power Query

Mon, Sep 25 through Fri, Sep 29

11:00 AM to 1:00 PM ET

( Project 2: Aviation )

Week 3 - Power Pivot, T-SQL & Power BI Administration

Mon, Oct 2 through Fri, Oct 6

11:00 AM to 1:00 PM ET

( Project 3: Aviation )

Week 4 - Advanced DAX Function & M-Programming

Mon, Oct 16 through Fri, Oct 20

11:00 AM to 1:00 PM ET

( Project 4: Aviation )

Week 5 - Ad-hoc Automations using VBA Macro

Mon, Oct 23 through Fri, Oct 27

11:00 AM to 1:00 PM ET

( Project 5: Aviation )

Week 6 - ETL with MS-SQL & SSIS and Architect BI Solution

Mon, Oct 30 through Fri, Nov 3

11:00 AM to 1:00 PM ET

( Project 6: Aviation )

NEW

Upcoming Batch

Starts On

Tuesday, 11 JULY

Time

11:00 AM - 2:00 PM ET

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 Dec 15, 2023.

Training Schedule

Week 1 - Quick Excel Brush-up & Power BI

Mon, Sep 18 through Fri, Sep 22

11:00 AM to 1:00 PM ET

( Project 1: Aviation )

Week 2 - DAX Function & Power Query

Mon, Sep 25 through Fri, Sep 29

11:00 AM to 1:00 PM ET

( Project 2: Aviation )

Week 3 - Power Pivot, T-SQL & Power BI Administration

Mon, Oct 2 through Fri, Oct 6

11:00 AM to 1:00 PM ET

( Project 3: Aviation )

Week 4 - Advanced DAX Function & M-Programming

Mon, Oct 16 through Fri, Oct 20

11:00 AM to 1:00 PM ET

( Project 4: Aviation )

Week 5 - Ad-hoc Automations using VBA Macro

Mon, Oct 23 through Fri, Oct 27

11:00 AM to 1:00 PM ET

( Project 5: Aviation )

Week 6 - ETL with MS-SQL & SSIS and Architect BI Solution

Mon, Oct 30 through Fri, Nov 3

11:00 AM to 1:00 PM ET

( Project 6: Aviation )

Week 1 - Quick Excel Brush-up & Power BI

Tue, Jul 11 through Fri, Jul 14

11:00 AM to 1:00 PM ET

Week 2 - DAX Function & Power Query

Mon, Jul 17 through Fri, Jul 21

11:00 AM to 1:00 PM ET

Week 3 - Power Pivot, T-SQL & Power BI Administration

Mon, Jul 24 through Fri, Jul 28

11:00 AM to 1:00 PM ET

Week 4 - Advanced DAX Function & M-Programming

Mon, Aug 7 through Fri, Aug 11

11:00 AM to 1:00 PM ET

Week 5 - Ad-hoc Automations using VBA Macro

Mon, Aug 14 through Fri, Aug 18

11:00 AM to 1:00 PM ET

Week 6 - ETL with MS-SQL & SSIS and Architect BI Solution

Mon, Aug 21 through Fri, Aug 25

11:00 AM to 1:00 PM ET

9 Specialist Certificates

Take exam and get certified for in-demand data tools.

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

  • Level :

Exam ID : EG-903

Eligibility : On clearing post-training assessment

Certificate : Report Automation Specialist using Excel VBA Programming

  • Level :

Exam ID : EG-904

Eligibility : On implementing a Live VBA project

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 : Data warehouse & ETL Specialist using MS-SQL, SSIS & Power BI

  • Level :

Exam ID : EG-907

Eligibility : On clearing post-training assessment

Certificate : Business Reporting Specialist using Python & Power BI

  • Level :

Exam ID : EG-908

Eligibility : On clearing post-training assessment

Certificate : Fullstackbi Reporting & Automation Specialist

  • Level :

Exam ID : FSBI-001

Eligibility : On securing above 8-certificates

9 Specialist Certificates

Take exam and get certified for in-demand data tools.

MS-Excel Associate

Level :

Exam ID :

EG-901

Eligibility :

On clearing post-training assessment

Sample Certificate :

View here

MIS Reporting & Business Modeling
Specialist using MS-Excel

Level :

Exam ID :

EG-902

Eligibility :

On clearing post-training assessment

Sample Certificate :

View here

VBA Developer

Level :

Exam ID :

EG-903

Eligibility :

On clearing post-training assessment

Sample Certificate :

View here

Report Automation Specialist
using Excel VBA Programming

Level :

Exam ID :

EG-904

Eligibility :

On implementing a Live VBA project

Sample Certificate :

View here

Data Analysis & Dashboard
Associate using Power BI

Level :

Exam ID :

EG-905

Eligibility :

On clearing post-training assessment

Sample Certificate :

View here

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

Level :

Exam ID :

EG-906

Eligibility :

On clearing post-training assessment

Sample Certificate :

View here

Data warehouse & ETL Specialist using
MS-SQL, SSIS & Power BI

Level :

Exam ID :

EG-907

Eligibility :

On clearing post-training assessment

Sample Certificate :

View here

Business Reporting Specialist using
Python & Power BI

Level :

Exam ID :

EG-908

Eligibility :

On clearing post-training assessment

Sample Certificate :

View here

Fullstackbi Reporting &
Automation Specialist

Level :

Exam ID :

FSBI-001

Eligibility :

On securing above 8-certificates

Sample Certificate :

View here

About Your Trainer

Mr. Sami

MCT, MCP, MEE, MOS

30,000+

Students Trained

18+

Year of Experience

4.9

Reviews

Mr. Sami, Microsoft Certified Trainer, with his qualifications in Finance, HR & Information Technology brings in 14
years of Industry experience. He has successfully trained 9500+ professionals by now, and the counting is still on.

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.

Learner stories
around the world

Total Reviews

4583

Overall growth till now

Average Rating

4.9

Average rating this year

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.

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!

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

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

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.

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!

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.

Esteemed Clientele

BI Reporting Consulting for Aviation Companies.

Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam

Why hire more staff when you can achieve
300% growth with your existing workforce?

From analyzing flight data to optimizing ground operations, we'll help you
leverage your data to make better decisions and improve your bottom line.

Our team of experts will work closely with you to understand your unique
challenges and develop customized solutions that meet your specific needs.

Consulting Engagement - Models

Embedded Consulting

Get the benefit of an in-house expert team without the overhead!

We’ll provide you with a dedicated team of BI and Automation experts who understand your business, deliver ongoing support, and continuously optimize your BI reporting and automation solutions. Opt for this model when you want a long-term partnership with a team that feels like an extension of your company.

Get a dedicated team of BI experts for a year!

Minimum Engagement Period:

1 Year

BOT (Build-Operate-Transfer)

Get your BI initiatives up and running quickly!

Our BOT (Build-Operate-Transfer) Model provides you with a team of BI and Automation experts who build, operate, and transfer the solution to your in-house team once it's fully operational. Opt for this model when you want to accelerate your BI and Automation initiatives without building an in-house team or when you need to scale up quickly.

Accelerate your BI initiatives without building an in-house team!

Minimum Engagement Period:

6 months

Training + Consulting

Empower your team with the BI Knowledge

Our expert trainers will equip your team with the necessary skills and knowledge to handle your BI reporting and automation needs. From there, we’ll provide ongoing consulting to ensure your solutions are continuously optimized for your business needs. Opt for this model when you want to develop the skills of your internal team while receiving external consulting support.

Empower your team with BI skills

Minimum Engagement Period:

6 months – 1 year

Industry Insights

FSBI

Why does FSBI Specialist earns 30%-50% more than BI experts?

FSBI

Exploring the Different Roles and Career Paths in FSBI & Automation

FSBI

Real-World Business Scenario: PwC Case Study – From Weeks to hours

FSBI

7 Advanced DAX Functions to Supercharge Your Power BI Reports

FSBI

Creating Mobile-Friendly Reports with Power BI

FSBI

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

Connect with Us

Request we contact you

Have a Power BI sales expert contact
you.

Mr. Perrie Smith

Business Associate

Tel: +1 650 491 3131

Email: inquiry@excelgoodies.com

Excelgoodies Consulting Inc.

739 Bryant Street,

San Francisco, CA 94107.

Connect with Us

Request we contact you

Have a Power BI sales expert contact
you.

Please enter your name
Invalid Email ID
Invalid phone number
Please select preferred time to call

Prove you're human: Type the code shown.

=
Invalid Catcha Code
Please wait while we are processing your request. Thank you for contacting us! We will get back to you soon!

Mr. Perrie Smith

Business Associate

Tel: +1 650 491 3131

Email: inquiry@excelgoodies.com

Excelgoodies Consulting Inc.

739 Bryant Street,

San Francisco, CA 94107.

COURSES

TRENDING REPORTING COURSES

  • FullStackBIRReporting & Automation Course

    Power BI | MS-SQL | ETL with SSIS | VBA | Python

  • Advanced Excel & Power Query

    Advanced Excel | MIS Reporting | Power Query

  • Excel VBA Macro Programming (VBA)

    VB Programming | VBA | MS-Office Automation

  • Data Analytics Using Microsoft Power BI Course

    Power BI | Power Pivot | Power Query | Basic DAX

  • Advanced Excel & MIS Reporting Course

    Advanced Excel | MIS Reporting | Model Building

TAILORED BI REPORTING COURSES

BY INDUSTRY

Aviation

Retail

Healthcare

Banking & Finance

Manufacturing

Telecommunications

Insurance

Hospitality

Transportation

E-commerce

Aviation

Retail

Healthcare

Banking & Finance

Manufacturing

Telecommunications

Insurance

Hospitality

Transportation

E-commerce

Accounting & Finance

Operations

Customer Service

Human Resources

Marketing

Sales

Supply Chain

Project Management

BY FUNCTION

Accounting & Finance

Operations

Customer Service

Human Resources

Marketing

Sales

Supply Chain

Project Management

NEW

UPCOMING BATCHES

STUDENT STORIES

INDUSTRY INSIGHTS / BLOG

TECHNOLOGY CONSULTING

  • HOME
  • ABOUT US
  • CONTACT US
  • +1 650 491 3131
    inquiry@excelgoodies.com
TRENDING REPORTING COURSES

Full Stack BIR Reporting & Automation Course

Power BI | DAX | MS-SQL | VBA | Python | ETL with SSIS

Advanced Excel & Power Query

Advanced Excel | MIS Reporting | Power Query

Excel VBA Macro Programming (VBA)

VB Programming | VBA | MS-Office Automation

Power BI Reporting Course

Power BI | Power Pivot | power Query

Advanced Excel & MIS Reporting Course

Advanced Excel | MIS Reporting | Model Building

CUSTOMIZED BI REPORTING COURSES

BY INDUSTRY

Aviation

Retail

Healthcare

Banking & Finance

Manufacturing

Telecommunications

Insurance

Hospitality

Transportation

E-commerce

BY FUNCTION

Accounting & Finance

Operations

Customer Service

Human Resources

Marketing

Sales

Supply Chain

Project Management

UPCOMING BATCHES

Full Stack BIRReporting Training

Advanced Excel & Power Query

Excel VBA Macro Training

Power BI Reporting Course

Advanced Excel & MIS Reporting

Check all upcoming batches
REVIEWS

Blog / Resources

Students Success Stories

CONNECT WITH US
+1 650 491 3131
inquiry@excelgoodies.com
COMPANY

Home

About Us

Contact Us

Terms & Conditions Privacy Policy

Copyright Excelgoodies Consulting Inc