TRENDING REPORTING COURSES
Power BI | MS-SQL | Power Apps | Power Automate
Power BI | MS-SQL | ETL with SSIS | VBA | SSAS
Power BI | Power Pivot | Power Query | Basic DAX
Advanced Excel | MIS Reporting | Model Building
Advanced Excel | MIS Reporting | Power Query
VB Programming | VBA | MS-Office Automation
Formulas | Pivots | Advance Dashboards
TAILORED BI REPORTING COURSES
BY INDUSTRY
Reporting & Automation
(On-Cloud BI Reporting)
Power BI | DAX | MS-SQL | Power Apps | Power Automate
Power BI | DAX | MS-SQL | ETL | Power Apps | Power Automate
MASTER
Data Analytics, Advanced Reporting,
Programming & Automation.
(On-Cloud BI Reporting)
50-hours Course | 6 Data-Tools | 7 Specialist Certificates
Power BI | DAX | MS-SQL | ETL | VBA | Python View Schedule
(1.5K+ Professionals enrolled)
Power BI
Adv. DAX
MS-SQL
Power Query
Power Apps
Power Automate
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
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.
Objective: To do faster queries, simpler DAX code and enjoy easier maintenance.
Objective: Getting started with Power BI and leverage it’s full potential to develop compelling visualizations.
Objective: To learn different methods to Transform Data before uploading it to the SQL Database.
Objective: To add analytical power to your Power BI model that is not available in the data as-is, using DAX.
Objective: To query MS-SQL Database (es) by writing accurate, effective, and robust T-SQL code - the right way.
Objective: Leverage DAX potential to perform advanced data analytics
Objective: To perform advanced and complex data transformations not available in the Query Editor
Objective: Get hands-on experience with advanced administration settings, permissions, Data refresh times etc.
Power Apps Training Course for Working Professionals
Power Automate Training Course for Working Professionals
Objective: To put our entire learning to use and arrive at the best possible BI solution -using the right combination of available technologies.
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
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
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?
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.
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?
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.
CloseAdd 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?
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.
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?
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
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?
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:
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
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.
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.
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.
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.
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.
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?
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.
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.
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.
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.
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.
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.
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.
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.
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
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.
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:
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.
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 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.
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
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.
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.
There are many important tasks / activities which cannot be done using Power Bi components like -
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.
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.
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.
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.
Objective: To do faster queries, simpler DAX code and enjoy easier maintenance.
Objective: Getting started with Power BI and leverage it’s full potential to develop compelling visualizations.
Objective: To learn different methods to Transform Data before uploading it to the SQL Database.
Objective: To add analytical power to your Power BI model that is not available in the data as-is, using DAX.
Objective: To query MS-SQL Database (es) by writing accurate, effective, and robust T-SQL code - the right way.
Objective: Leverage DAX potential to perform advanced data analytics
Objective: To perform advanced and complex data transformations not available in the Query Editor
Objective: Get hands-on experience with advanced administration settings, permissions, Data refresh times etc.
Power Apps Training Course for Working Professionals
Power Automate Training Course for Working Professionals
Objective: To put our entire learning to use and arrive at the best possible BI solution -using the right combination of available technologies.
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
Business Associate
Tel: +44 (0)20 3769 3689
Email: support@excelgoodies.uk
Connect us on
Week 1 :
Quick Excel Brush-up - Advanced Formulas & FunctionsWeek 2 :
Power BI & DAX Fundamentals Advanced DAX Function, Power Query & Power PivotWeek 3 :
Power BI & DAX Fundamentals Advanced DAX Function, Power Query & Power PivotWeek 4 :
T-SQL & Power BI AdministrationWeek 5 :
Power AppsWeek 6 :
Power AutomateWeek 7 :
Project Scenarios using Power BI, Power Automate, Power Apps & SQL
Avail additional 10% Corporate Benefit*
on the total course fee for
5+
participants.
Get you team BI ready, today.
*Available until Oct 30, 2024.
Week 1 :
Quick Excel Brush-up - Advanced Formulas & FunctionsWeek 2 :
Power BI & DAX Fundamentals Advanced DAX Function, Power Query & Power PivotWeek 3 :
Power BI & DAX Fundamentals Advanced DAX Function, Power Query & Power PivotWeek 4 :
T-SQL & Power BI AdministrationWeek 5 :
Power AppsWeek 6 :
Power AutomateWeek 7 :
Project Scenarios using Power BI, Power Automate, Power Apps & SQLYou'll honored with total of 7-certificates
throughout the program.
Exam ID : EG-901
Eligibility : On clearing post-training assessment
Exam ID : EG-902
Eligibility : On clearing post-training assessment
Exam ID : EG-905
Eligibility : On clearing post-training assessment
Exam ID : EG-906
Eligibility : On clearing post-training assessment
Exam ID : EG-904
Eligibility : On implementing a Live VBA project
Exam ID : EG-907
Eligibility : On clearing post-training assessment
Exam ID : FSBI-001
Eligibility : On securing above 8-certificates
MCT, MCP, MEE, MOS
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.
You'll honored with total of 7-certificates through-out the program.
1
EG-901
Level :
View Sample
2
EG-902
Level :
View Sample
3
EG-903
Level :
View Sample
4
EG-904
Level :
View Sample
5
EG-905
Level :
View Sample
6
EG-906
Level :
View Sample
7
FSBI-001
Level :
View Sample
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
Susan Rodezno
Power BI Training
Analyst, Process Improvement, Corporate Budgeting & Reporting
Essex Property Trust
United States
Sami's very knowledgeable and professional and clearly an expert in what he does. He was patient with us and provided us with a lot of content, giving us the tools to succeed while not giving away the farm sot to speak. I feel like I learned a great deal and looking forward to going back to reference material as well as completing the project for this class completion. thank you,
Tao Peng
Power BI Training
Information Technology Specialist
Minnesota State College Southeast
United States
This is an excellent training. Sami is a great and patient instructor. He made sure everyone is on course and understands the topic fully before he moves on, if help is needed beyond class time, he also was there before the class to answer questions. I am really impressed with his knowledge and expertise, it seems he always knows the answer to questions. I will definitely take another class with Sami and Excelgoodies again.
Iris Bradshaw
Power BI Training
Data Analyst
Qnnect
United States
I had a little experience with Power BI prior to the class. The information given greatly expanded my knowledge and I am excited to put the knowledge to use. Sami's instructions were very easy to follow and he made sure to answer everyone's questions. The only issue I had with the course was with the students not the instructor or course itself. It was a bit frustrating when some of the students were not prepared (especially not having the system requirements installed) and we had to wait for them to download materials or software. Sami handled it professionally but it took away time that could have been used for training. Overall, I am very please with what I have learned and will be looking into taking the Full Stack BI training. Thank You, Iris Bradshaw
Total Reviews
4583
Overall growth till now
Average Rating
4.9
Average rating this year
Susan Rodezno
Power BI Training
Analyst, Process Improvement, Corporate Budgeting & Reporting
Essex Property Trust
United States
Sami's very knowledgeable and professional and clearly an expert in what he does. He was patient with us and provided us with a lot of content, giving us the tools to succeed while not giving away the farm sot to speak. I feel like I learned a great deal and looking forward to going back to reference material as well as completing the project for this class completion. thank you,
Tao Peng
Power BI Training
Information Technology Specialist
Minnesota State College Southeast
United States
This is an excellent training. Sami is a great and patient instructor. He made sure everyone is on course and understands the topic fully before he moves on, if help is needed beyond class time, he also was there before the class to answer questions. I am really impressed with his knowledge and expertise, it seems he always knows the answer to questions. I will definitely take another class with Sami and Excelgoodies again.
Iris Bradshaw
Power BI Training
Data Analyst
Qnnect
United States
I had a little experience with Power BI prior to the class. The information given greatly expanded my knowledge and I am excited to put the knowledge to use. Sami's instructions were very easy to follow and he made sure to answer everyone's questions. The only issue I had with the course was with the students not the instructor or course itself. It was a bit frustrating when some of the students were not prepared (especially not having the system requirements installed) and we had to wait for them to download materials or software. Sami handled it professionally but it took away time that could have been used for training. Overall, I am very please with what I have learned and will be looking into taking the Full Stack BI training. Thank You, Iris Bradshaw
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
Excelgoodies Limited.
71–75 Shelton Street, Covent Garden
London WC2H 9JQ
Daniel Carter
Business Associate
ENQUIRY
+44 (0)20 3769 3689
