Business Professionals
Techno-Business Professionals
Power BI | Power Query | Advanced DAX | SQL - Query &
Programming
Microsoft Fabric | Power BI | Power Query | Advanced DAX |
SQL - Query & Programming
Microsoft Power Apps | Microsoft Power Automate
Power BI | Adv. DAX | SQL (Query & Programming) |
VBA | Python | Web Scrapping | API Integration
Power BI | Power Apps | Power Automate |
SQL (Query & Programming)
Power BI | Adv. DAX | Power Apps | Power Automate |
SQL (Query & Programming) | VBA | Python | Web Scrapping | API Integration
Power Apps | Power Automate | SQL | VBA | Python |
Web Scraping | RPA | API Integration
Technology Professionals
Power BI | DAX | SQL | ETL with SSIS | SSAS | VBA | Python
Power BI | SQL | Azure Data Lake | Synapse Analytics |
Data Factory | Databricks | Power Apps | Power Automate |
Azure Analysis Services
Microsoft Fabric | Power BI | SQL | Lakehouse |
Data Factory (Pipelines) | Dataflows Gen2 | KQL | Delta Tables | Power Apps | Power Automate
Power BI | Power Apps | Power Automate | SQL | VBA | Python | API Integration
New
Home | About Us | Contact Us
ExcelGoodies WorldwideUSA | UK | Australia | Singapore | Phillipinnes
3 Weeks | 30 Hours
15 Sessions, 2 Hrs Each
Live Online, Instructor-Led
Excel Formulas, Pivots & Charts
Add at Checkout for $99
Batch starts on
th
From Power BI Basics to SQL-Driven Analytics
Learn to connect, query, and create advanced reports.
Perfect for Power Users who want to "take Power BI to the next level." To learn Advanced DAX, understanding RDBMS is essential. This course builds on Power BI fundamentals and introduces SQL, enabling you to perform complex calculations, optimize reporting, and automate workflows—"without any coding experience."
Master SQL for Data Integration – Query and manage large datasets efficiently.
Take DAX to the Next Level – Create sophisticated measures for deeper analytics.
Optimize Data Models for Speed – Ensure smooth, high-performance reporting.
Automate Reports & Workflows – Reduce manual effort using SQL and DAX.
Handle Large Datasets with Ease – Work with SQL, Excel, and multiple data sources
Deliver Faster Insights – Optimize Power BI reports for real-time decision-making.
Master SQL for Data Integration – Query and manage large datasets efficiently.
Take DAX to the Next Level – Create sophisticated measures for deeper analytics.
Optimize Data Models for Speed – Ensure smooth, high-performance reporting.
Automate Reports & Workflows – Reduce manual effort using SQL and DAX.
Handle Large Datasets with Ease – Work with SQL, Excel, and multiple data sources
Deliver Faster Insights – Optimize Power BI reports for real-time decision-making.
Finance & Operations
who need SQL-powered analytics for forecasting and trend analysis.
Reporting Professionals
who need to connect databases with Power BI for dynamic reporting
Data Analysts
looking to combine SQL skills with Power BI for more advanced reporting.
Business Analysts
who want to bridge the gap between SQL databases and business reports.
BI & IT Developers
aiming to optimize data models and improve Power BI performance.
Non-technical professionals
with basic SQL knowledge, ready to build more complex reports with Power BI.
A snapshot of what you'll be learning in 3-weeks.
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
Secondary Monitor (optional, but recommended)
Having a secondary monitor will greatly assist in following the pace of the trainer. It allows you to view instructions and your own workspace simultaneously, enhancing your learning experience.
Advanced power bi courses – now available.
Power BI with Microsoft Fabric
For Scalable Reporting
This Power BI with SQL course includes 14 Power BI projects and 6 SQL projects, combining data visualization, data transformation, and SQL query skills. You’ll create interactive dashboards, transform data with Power Query, write DAX formulas, and master SQL queries. Here are the top Power BI and SQL projects you'll work on:
Inventory & Supply Chain Dashboard
Create dynamic visualizations that track inventory levels, order fulfillment rates, and supplier performance. Learn to automate real-time data alerts to ensure optimal stock levels and timely deliveries.
Financial Health Dashboard
Build financial dashboards that display key metrics like revenue, expenses, and cash flow, with live updates. Automate reports that compare actual vs. budget figures and offer real-time insights for business decisions.
Customer Support Dashboard
Visualize customer service metrics such as ticket status, response times, and customer satisfaction. Learn how to automate ticket updates and generate insights to improve support efficiency.
Sales Performance Dashboard
Track sales revenue, regional performance, and top-selling products using dynamic visualizations. Create automatic reports to measure progress against sales targets.
Project Management Dashboard
Design a project management dashboard that tracks timelines, budgets, and milestones in real time. Automate status updates to identify risks or delays early.
Marketing Campaign Dashboard
Build dashboards that visualize key marketing metrics, such as conversions, impressions, and ROI. Automate reports to evaluate campaign success and optimize marketing strategies.
Database Design & Normalization
Design and normalize relational databases using primary keys,foreign keys, and normal forms to optimize storage and scalability.
Customer Data Analysis
Analyze customer data with JOINs, GROUP BY, and HAVING to identify trends, segment groups, and generate insights for marketing.
Sales Data Analysis
Use window functions and CTEs to track sales metrics, revenue, and product performance, generating actionable insights.
Inventory Management Queries
Leverage subqueries, UNION, and CASE to track inventory, product stock, and sales velocity for decision-making.
Employee Performance Tracker
Apply ranking functions (e.g., RANK(), DENSE_RANK()) to evaluate employee performance, track KPIs, and enhance workforce management.
Financial Reporting Queries
Retrieve financial data using aggregate functions and GROUP BY to automate real-time reports for balance sheets and P&L statements.
Create dynamic visualizations that track inventory levels, order fulfillment rates, and supplier performance. Learn to automate real-time data alerts to ensure optimal stock levels and timely deliveries.
Build financial dashboards that display key metrics like revenue, expenses, and cash flow, with live updates. Automate reports that compare actual vs. budget figures and offer real-time insights for business decisions.
Visualize customer service metrics such as ticket status, response times, and customer satisfaction. Learn how to automate ticket updates and generate insights to improve support efficiency.
Track sales revenue, regional performance, and top-selling products using dynamic visualizations. Create automatic reports to measure progress against sales targets.
Design a project management dashboard that tracks timelines, budgets, and milestones in real time. Automate status updates to identify risks or delays early.
Build dashboards that visualize key marketing metrics, such as conversions, impressions, and ROI. Automate reports to evaluate campaign success and optimize marketing strategies.
Design and normalize relational databases using primary keys,foreign keys, and normal forms to optimize storage and scalability.
Analyze customer data with JOINs, GROUP BY, and HAVING to identify trends, segment groups, and generate insights for marketing.
Use window functions and CTEs to track sales metrics, revenue, and product performance, generating actionable insights.
Leverage subqueries, UNION, and CASE to track inventory, product stock, and sales velocity for decision-making.
Apply ranking functions (e.g., RANK(), DENSE_RANK()) to evaluate employee performance, track KPIs, and enhance workforce management.
Retrieve financial data using aggregate functions and GROUP BY to automate real-time reports for balance sheets and P&L statements.
A piece of paper means nothing if you can’t apply the skills. Our certifications are industry-recognized and backed by hands-on training—ensuring you’re not just qualified, but ready to perform from day one.
Eligibility:
On clearing post-training assessment.
View Sample CertificateShareable certificate
Add to your LinkedIn profile
Level : SPECIALIST
Certificate Code : EG-SPL-004
Eligibility:
On clearing post-training assessment.
Shareable certificate
Add to your LinkedIn profile
Limited Seats. Registration Closing Soon
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
Secondary Monitor (optional, but recommended)
Having a secondary monitor will greatly assist in following the pace of the trainer. It allows you to view instructions and your own workspace simultaneously, enhancing your learning experience.
Mac Users: Power BI Desktop is Windows-only. If you're on a Mac, you can use Power BI Service (Cloud version) or run Windows via Parallels, Boot Camp, or a Virtual Machine.
Yes! We provide corporate invoices for employer-sponsored payments. You can either use a company card or request an invoice to forward to your finance team.
These options are available on the Sign-Up form.
Yes! We offer discounts for teams of 10 or more enrolling together. Customized corporate training is also available.
Contact us for group pricing.
We accept credit/debit cards, wire transfers, and corporate invoices for employer-sponsored payments.
No, prior SQL experience is not required. The course starts with Power BI fundamentals and gradually introduces SQL concepts to help you optimize data models and improve report performance.
Even if you’ve never written a SQL query before, we’ll guide you step-by-step so you can confidently use SQL alongside Power BI.
SQL helps in:
Yes, but SQL concepts make it easier to understand Advanced DAX. While you can start learning Essential DAX without SQL, this course gradually introduces SQL to help you master complex calculations and performance tuning in Power BI
This is a live, instructor-led course with hands-on exercises, real-world case studies, and Q&A discussions to ensure a highly engaging learning experience.
No, this is a live interactive course with hands-on projects. However, you’ll receive detailed assignments, documentation, and automation templates to practice.
If you miss a session, we provide class notes and exercises to help you catch up. Additionally, you can attend the same session in a future batch (subject to availability).
Yes! You will receive a Specialist Certificate upon successfully completing the course and final assessment.
You can retake sessions from a future batch (subject to availability), but full course re-enrollment may require an additional fee.
Unlike pre-recorded courses, this is a live, interactive program where you work on real-world datasets and get direct access to expert instructors for personalized guidance.
More questions ?
SQL Query Optimization
Database Integration
Data Modeling
DAX for SQL Reports
Advanced Data Analysis
Data Aggregation
Performance Tuning
SQL Reporting
Data Cleansing
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.
Government Institutions We've Worked With.
Build Real-World Solutions During the Course
We Spot Trends Before They Become Industry Standards
The analytics industry moves fast. We move faster. We constantly update our courses to match the latest industry needs, so you’re always learning what’s in demand—before everyone else.
Learn What Matters, Not Just What’s Trending
BI & Analytics isn’t about knowing one tool—it’s about knowing how to use the right tools together. Our courses don’t just teach software; they teach end-to-end reporting, automation, and cloud-driven analytics workflows—exactly what businesses need.
Tech-Enabled Learning,
Zero Hassles
Forget scattered emails and outdated PDFs. Our AI-powered student portal keeps everything in one place—live classes, assignments, progress tracking, instructor feedback, invoices, and instant support—so you stay focused on learning.
Real Projects, Real Experience, Real Confidence
No more theory-only learning—you’ll walk out of our courses with proven expertise in the tools and techniques hiring managers want.
Mr. Perrie Smith
Business Associate
Overall really enjoyed the course. Nice balance between demos, guided practice and independent practice. I really enjoyed the exercises where criteria was displayed and we had 20 minutes to build it up. Content felt very heavy on dashboard creation with an accelerated run thru PowerQuery material in the last several days; I think this could be a bit more balanced. My company had 5 students with stronger use needs for automated data manipulation than db's. The SQL review on Day10 was a bit fuzzy, I couldn't quite follow the benefits or use cases where this would be relevant. I would recommend adding a 5min break to the middle of each session for biological needs; 2.5 hrs is a long shot for some folks. We spent about 5 minutes at the beginning of each lesson setting up the day's folder structure, copying over data sets, etc. Could eliminate this and replace with a break if the overall folder structure was distributed with data sets already loaded in place at start of course. I.e. send zipped structure with folders for Days 1-10, each containing the ""Project X - Dashboard"" subfolders with Sales.Data.csv, etc, already saved in place. Thanks for the experience! looking forward to applying the knowledge!
Delaney Sullivan | Finance Transformation Project Manger | American Tower | United States (Power BI Training)
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
Iris Bradshaw | Data Analyst | Qnnect | United States (Power BI Training)
I liked the pace and content of this introduction to Power BI. The instructor was able to quickly troubleshoot most issues that people had, although some problems did stall the pace quite a bit at times (participants really should have a strong Excel skillset and ability to manage files). Perhaps on a daily basis before the training , a quick 'setup' email would be helpful (which folders to create and which files to copy) so that everyone could set themselves up ahead of time. (Or include day-by-day setup instructions in the content zip file with this info.) On another note, I would like to have spent more time on publishing and refreshing published reports (and the Power BI workspace) instead of the SQL server mini course. As it was, though, the lessons we learned in this training will be almost immediately applied and the results should be very helpful to people in my organization looking for dashboard summaries of their data. Thank you.
Michele Sabatino | Data Analytics Manager | Harbor Health | United States (Power BI Training)
Sami did a great job introducing the basics of Power BI through instruction and hands-on learning. This is a good course for a complete beginner, and would probably benefit some early intermediate students as well. My only complaint would be the amount of time needed to troubleshoot so many students' technical issues. We probably spend 40% of the total class time with Sami troubleshooting. It's not a knock on Sami or the course. Maybe a slightly smaller class would make it a little easier.
Zane Kinsey | Business Controller | Pacific Power Group | United States (Power BI Training)
This training was great! I've been working with Power BI for a little while now but was mostly self-taught so it was nice to learn some best practices for the way to do things. Also good to learn more about DAX and Power Query. Thank you Sami!
Michael Morrison | Platform Analyst | Cross First Bank | United States (Power BI Training)
Delaney Sullivan
Power BI Training
Finance Transformation Project Manger
American Tower
United States
Overall really enjoyed the course. Nice balance between demos, guided practice and independent practice. I really enjoyed the exercises where criteria was displayed and we had 20 minutes to build it up. Content felt very heavy on dashboard creation with an accelerated run thru PowerQuery material in the last several days; I think this could be a bit more balanced. My company had 5 students with stronger use needs for automated data manipulation than db's. The SQL review on Day10 was a bit fuzzy, I couldn't quite follow the benefits or use cases where this would be relevant. I would recommend adding a 5min break to the middle of each session for biological needs; 2.5 hrs is a long shot for some folks. We spent about 5 minutes at the beginning of each lesson setting up the day's folder structure, copying over data sets, etc. Could eliminate this and replace with a break if the overall folder structure was distributed with data sets already loaded in place at start of course. I.e. send zipped structure with folders for Days 1-10, each containing the ""Project X - Dashboard"" subfolders with Sales.Data.csv, etc, already saved in place. Thanks for the experience! looking forward to applying the knowledge!
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
Michele Sabatino
Power BI Training
Data Analytics Manager
Harbor Health
United States
I liked the pace and content of this introduction to Power BI. The instructor was able to quickly troubleshoot most issues that people had, although some problems did stall the pace quite a bit at times (participants really should have a strong Excel skillset and ability to manage files). Perhaps on a daily basis before the training , a quick 'setup' email would be helpful (which folders to create and which files to copy) so that everyone could set themselves up ahead of time. (Or include day-by-day setup instructions in the content zip file with this info.) On another note, I would like to have spent more time on publishing and refreshing published reports (and the Power BI workspace) instead of the SQL server mini course. As it was, though, the lessons we learned in this training will be almost immediately applied and the results should be very helpful to people in my organization looking for dashboard summaries of their data. Thank you.
Zane Kinsey
Power BI Training
Business Controller
Pacific Power Group
United States
Sami did a great job introducing the basics of Power BI through instruction and hands-on learning. This is a good course for a complete beginner, and would probably benefit some early intermediate students as well. My only complaint would be the amount of time needed to troubleshoot so many students' technical issues. We probably spend 40% of the total class time with Sami troubleshooting. It's not a knock on Sami or the course. Maybe a slightly smaller class would make it a little easier.
Michael Morrison
Power BI Training
Platform Analyst
Cross First Bank
United States
This training was great! I've been working with Power BI for a little while now but was mostly self-taught so it was nice to learn some best practices for the way to do things. Also good to learn more about DAX and Power Query. Thank you Sami!
I recently completed the Power BI training, and it was an excellent learning experience. The course was well-structured, covering everything from basic visualization techniques to advanced DAX functions. The instructor was highly knowledgeable and explained complex concepts in a clear and practical manner.
Sami was a great instructor. He took the time to make sure everyone could follow along and understand the material. While I already had experience with Power BI prior to this course, it was still a great refresher. If you're new to Power BI this is a great course to take!
Sami, our trainer, was really good. He was very thorough in explaining concepts as well as navigating the user interface. He kept a good pace while ensuring that nobody was left behind . I recommend this course.
Power BI
7 Advanced DAX Functions to Supercharge Your Power BI Reports
Power BI
Creating Mobile-Friendly Reports with Power BI
Power BI
The Fast-Food Chain Data Story with Power BI: Do’s & Don’ts of data storytelling
Power BI
7 Advanced DAX Functions to Supercharge Your Power BI Reports
Power BI
Creating Mobile-Friendly Reports with Power BI
Power BI
The Fast-Food Chain Data Story with Power BI: Do’s & Don’ts of data storytelling
End-to-End Reporting
Full Stack BI& Automation (On Prem)
Power BI | Adv. DAX | SQL (Query & Programming) | VBA | Python | Web Scrapping | API Integration
Course on Microsoft Power Platform
Full Stack BI& Automation (On Cloud)
Power BI | Power Apps | Power Automate | SQL (Query & Programming)
Select one or more checkboxes