At Skillwave Training, we offer a variety of courses for Power BI and Excel users that range from beginner to advanced level. Explore our training options below to find which course suits your skill level and area of interest. If you need more help in identifying the course that’s right for you, please contact us.
This FREE course explains the fundamental concepts of Power Query. Gain a basic understanding of what Power Query does and how to use it to gather and transform your data from a variety of sources.
Registration to this on-demand course includes access to the online videos and downloadable example files
Power Query allows you to clean, reshape, and combine your data with ease, no matter where it comes from. This course starts at the beginning and takes you to the point where you will master your data, saving you hours of time and manual effort. Simply put, you won’t find a more comprehensive Power Query course anywhere! Plus, everything you learn in applicable to both Excel and Power BI.
Registration to this on-demand course includes access to the online videos and downloadable example files, as well as our exclusive Discussions Forum for help with your questions.
This course contains all of the material in the Power Query Fundamentals course, plus simple data transformation techniques such as pivoting and unpivoting columns, splitting columns, sorting, filtering, and more.
Learn all the core skills for the Excel analyst, beginning with a refresher on Excel formulas and functions (including the powerful VLOOKUP), and then moving into PivotTables, data visualizations, and using Power Query to gather, clean, and transform your data.
This course include weekly live, online Q&A calls for help with questions on the week’s course materials, as well as ongoing support through monthly Ask Ken AMA sessions where you can get help with challenges as you apply what you’ve learned to your own work. You also have access to our exclusive Discussions Forum for help with questions between calls.
While several modules of the course cover Power Query, it does not cover the same breadth and depth as Power Query Academy.
Learn Power BI from end to end, including how to build and share reports, get and transform your data with Power Query, and use DAX for data modeling. This course will help an absolute beginner as well as anyone that is self-taught that has realized they are missing key learning concepts.
Registration includes access to our live online Q&A calls scheduled bi-weekly (every 2 weeks) for help with your questions and challenges. You also have access to our exclusive Discussions Forum for help with questions between calls.
While one third of this course covers Power Query, it does not cover the same breadth and depth as Power Query Academy.
The same content as in the video course (above) except it is delivered live, online (over 6 half-days) by a qualified instructor. If you prefer the live learning experience, this is the course for you.
Registration includes 12 months of access to the video online course (above) once the live training is complete. You can also attend the live online Q&A calls scheduled bi-weekly (every 2 weeks), and you have access to our exclusive Discussions Forum for help with questions between calls.
While 2 half-days of this course cover Power Query, it does not cover the same breadth and depth as Power Query Academy.
Power BI is better when you learn to write DAX! Data Analysis eXpressions is the data modelling language of Power BI and Power Pivot for Excel. Data modeling and DAX are interrelated, and you should learn both, together to derive the business insights from your data.
Registration includes access to weekly live online Q&A calls for help with your questions and challenges. You also have access to our exclusive Discussions Forum for help with questions between calls.
This course goes much deeper into the DAX language than Power BI for the Business Analyst. However, it does not go into data modeling as deeply as Dimensional Modeling for the Excel and Power BI Pro.
Learn Power BI from end to end, including how to build and share reports, get and transform your data with Power Query, and use DAX for data modeling. This course will help an absolute beginner as well as anyone that is self-taught that has realized they are missing key learning concepts.
Registration includes access to our live online Q&A calls scheduled bi-weekly (every 2 weeks) for help with your questions and challenges. You also have access to our exclusive Discussions Forum for help with questions between calls.
While one third of this course covers data modeling with DAX, it does not cover the same breadth and depth of data modeling as Dimensional Modeling for the Excel and Power BI Pro.
The same content as in the video course (above) except it is delivered live, online (over 6 half-days) by a qualified instructor. If you prefer the live learning experience, this is the course for you.
Registration includes 12 months of access to the video online course (above) once the live training is complete. You can also attend the live online Q&A calls scheduled bi-weekly (every 2 weeks), and you have access to our exclusive Discussions Forum for help with questions between calls.
While 2 of the half-days are dedicated to data modeling with DAX, it does not cover the same breadth and depth of data modeling as Dimensional Modeling for the Excel and Power BI Pro.
Prepare to change your company’s reporting game forever! Learn how to use Excel, Power Query, DAX, and Power BI together to build robust Self Service BI solutions.
This course include weekly live, online Q&A calls for help with questions on the week’s course materials, as well as ongoing support through monthly Ask Ken AMA sessions where you can get help with challenges as you apply what you’ve learned to your own work. You also have access to our exclusive Discussions Forum for help with questions between calls.
While several modules of the course cover data modeling, it does not cover the same breadth and depth as Dimensional Modeling for the Excel and Power BI Pro.
Power BI is better when you learn to write DAX! Data Analysis eXpressions is the data modelling language of Power BI and Power Pivot for Excel. Data modeling and DAX are interrelated, and you should learn both, together to derive the business insights from your data.
Registration includes access to weekly live online Q&A calls for help with your questions and challenges. You also have access to our exclusive Discussions Forum for help with questions between calls.
This course goes much deeper into the DAX language than Power BI for the Business Analyst.
Prepare to change your company’s reporting game forever! Learn how to use Excel, Power Query, DAX, and Power BI together to build robust Self Service BI solutions.
This course include weekly live, online Q&A calls for help with questions on the week’s course materials, as well as ongoing support through monthly Ask Ken AMA sessions where you can get help with challenges as you apply what you’ve learned to your own work. You also have access to our exclusive Discussions Forum for help with questions between calls.
While several modules of the course cover DAX, it does not cover the same breadth and depth as Supercharge Power BI Online.
Learn Power BI from end to end, including how to build and share reports, get and transform your data with Power Query, and use DAX for data modeling. This course will help an absolute beginner as well as anyone that is self-taught that has realized they are missing key learning concepts.
Registration includes access to our live online Q&A calls scheduled bi-weekly (every 2 weeks) for help with your questions and challenges. You also have access to our exclusive Discussions Forum for help with questions between calls.
While one third of this course covers DAX, it does not cover the same breadth and depth as Supercharge Power BI Online.
The same content as in the video course (above) except it is delivered live, online (over 6 half-days) by a qualified instructor. If you prefer the live learning experience, this is the course for you.
Registration includes 12 months of access to the video online course (above) once the live training is complete. You can also attend the live online Q&A calls scheduled bi-weekly (every 2 weeks), and you have access to our exclusive Discussions Forum for help with questions between calls.
While 2 half-days of this course cover DAX, it does not cover the same breadth and depth as Supercharge Power BI Online.
Learn Power BI from end to end, including how to build and share reports, get and transform your data with Power Query, and use DAX for data modeling. This course will help an absolute beginner as well as anyone that is self-taught that has realized they are missing key learning concepts.
Registration includes access to our live online Q&A calls scheduled bi-weekly (every 2 weeks) for help with your questions and challenges. You also have access to our exclusive Discussions Forum for help with questions between calls.
One third of this course covers report building and data visualization with Power BI Desktop.
The same content as in the video course (above) except it is delivered live, online (over 6 half-days) by a qualified instructor. If you prefer the live learning experience, this is the course for you.
Registration includes 12 months of access to the video online course (above) once the live training is complete. You can also attend the live online Q&A calls scheduled bi-weekly (every 2 weeks), and you have access to our exclusive Discussions Forum for help with questions between calls.
One third of this course covers report building and data visualization with Power BI Desktop.
Learn all the core skills for the Excel analyst, beginning with a refresher on Excel formulas and functions (including the powerful VLOOKUP), and then moving into PivotTables, data visualizations, and using Power Query to gather, clean, and transform your data.
This course include weekly live, online Q&A calls for help with questions on the week’s course materials, as well as ongoing support through monthly Ask Ken AMA sessions where you can get help with challenges as you apply what you’ve learned to your own work. You also have access to our exclusive Discussions Forum for help with questions between calls.
One module of this course covers data visualizations in Excel, including conditional formatting, Sparklines, and different types of charts.
Prepare to change your company’s reporting game forever! Learn how to use Excel, Power Query, DAX, and Power BI together to build robust Self Service BI solutions.
This course include weekly live, online Q&A calls for help with questions on the week’s course materials, as well as ongoing support through monthly Ask Ken AMA sessions where you can get help with challenges as you apply what you’ve learned to your own work. You also have access to our exclusive Discussions Forum for help with questions between calls.
One module in this course covers report and dashboard building, as well as data visualization, with Power BI Desktop.
Learn Power BI from end to end, including how to build and share reports, get and transform your data with Power Query, and use DAX for data modeling. This course will help an absolute beginner as well as anyone that is self-taught that has realized they are missing key learning concepts.
Registration includes access to our live online Q&A calls scheduled bi-weekly (every 2 weeks) for help with your questions and challenges. You also have access to our exclusive Discussions Forum for help with questions between calls.
Several lessons cover sharing Power BI Desktop reports.
The same content as in the video course (above) except it is delivered live, online (over 6 half-days) by a qualified instructor. If you prefer the live learning experience, this is the course for you.
Registration includes 12 months of access to the video online course (above) once the live training is complete. You can also attend the live online Q&A calls scheduled bi-weekly (every 2 weeks), and you have access to our exclusive Discussions Forum for help with questions between calls.
Part of Day 2 covers sharing Power BI Desktop reports.
Prepare to change your company’s reporting game forever! Learn how to use Excel, Power Query, DAX, and Power BI together to build robust Self Service BI solutions.
This course include weekly live, online Q&A calls for help with questions on the week’s course materials, as well as ongoing support through monthly Ask Ken AMA sessions where you can get help with challenges as you apply what you’ve learned to your own work. You also have access to our exclusive Discussions Forum for help with questions between calls.
One module in this course covers sharing and managing Power BI Desktop reports and dashboards.
Power Query allows you to clean, reshape, and combine your data with ease, no matter where it comes from. This course starts at the beginning and takes you to the point where you will master your data, saving you hours of time and manual effort. Simply put, you won’t find a more comprehensive Power Query course anywhere! Plus, everything you learn in applicable to both Excel and Power BI.
Registration to this on-demand course includes access to the online videos and downloadable example files, as well as our exclusive Discussions Forum for help with your questions.
This course contains several intermediate modules on merging and appending data, connecting to different data sources, and an introduction to conditional logic.
Prepare to change your company’s reporting game forever! Learn how to use Excel, Power Query, DAX, and Power BI together to build robust Self Service BI solutions.
This course include weekly live, online Q&A calls for help with questions on the week’s course materials, as well as ongoing support through monthly Ask Ken AMA sessions where you can get help with challenges as you apply what you’ve learned to your own work. You also have access to our exclusive Discussions Forum for help with questions between calls.
While several modules of the course cover Power Query, it does not cover the same breadth and depth as Power Query Academy.
Power BI is better when you learn to write DAX! Data Analysis eXpressions is the data modelling language of Power BI and Power Pivot for Excel. Data modeling and DAX are interrelated, and you should learn both, together to derive the business insights from your data.
Registration includes access to weekly live online Q&A calls for help with your questions and challenges. You also have access to our exclusive Discussions Forum for help with questions between calls.
This course goes much deeper into the DAX language than Power BI for the Business Analyst. However, it does not go into data modeling as deeply as Dimensional Modeling for the Excel and Power BI Pro.
Prepare to change your company’s reporting game forever! Learn how to use Excel, Power Query, DAX, and Power BI together to build robust Self Service BI solutions.
This course include weekly live, online Q&A calls for help with questions on the week’s course materials, as well as ongoing support through monthly Ask Ken AMA sessions where you can get help with challenges as you apply what you’ve learned to your own work. You also have access to our exclusive Discussions Forum for help with questions between calls.
While several modules of the course cover data modeling, it does not cover the same breadth and depth as Dimensional Modeling for the Excel and Power BI Pro.
At the core of every good Power Pivot or Power BI solution is the Data Model. But do you really know how to work with it properly? We’ll teach you the right way to build solid and scalable dimensional models.
Registration to this on-demand course includes access to the online videos and downloadable example files, as well as our exclusive Discussions Forum for help with your questions.
It’s one thing to know how to write a DAX formula. It’s a completely different level of competency to understand how to write the correct formula and understand why it works. Geared towards users with at least 6 months’ experience, this advanced course will help you become self-sufficient with your data modeling capabilities using DAX in Power BI Desktop, Power Pivot for Excel, and/or SSAS Tabular.
Registration includes access to our live online Q&A calls scheduled twice per week for help with your questions and challenges. You also have access to our exclusive Discussions Forum for help with questions between calls.
While this course covers advanced DAX techniques, it does not cover the same breadth and depth of data modeling as Dimensional Modeling for the Excel and Power BI Pro.
Are you a Power BI user who runs into questions and challenges during your day-to-day work? Get direct help with all your Power BI questions from an experienced Power BI consultant and Microsoft Certified Trainer during these bi-weekly (every 2 weeks), live online Q&A calls.
Registration also includes access to our exclusive Discussions Forum for help with your questions between calls.
Prepare to change your company’s reporting game forever! Learn how to use Excel, Power Query, DAX, and Power BI together to build robust Self Service BI solutions.
This course include weekly live, online Q&A calls for help with questions on the week’s course materials, as well as ongoing support through monthly Ask Ken AMA sessions where you can get help with challenges as you apply what you’ve learned to your own work. You also have access to our exclusive Discussions Forum for help with questions between calls.
While several modules of the course cover DAX, it does not cover the same breadth and depth as Supercharge Power BI Online, or the advanced Demystifying DAX Online.
Power BI is better when you learn to write DAX! Data Analysis eXpressions is the data modelling language of Power BI and Power Pivot for Excel. Data modeling and DAX are interrelated, and you should learn both, together to derive the business insights from your data.
Registration includes access to weekly live online Q&A calls for help with your questions and challenges. You also have access to our exclusive Discussions Forum for help with questions between calls.
It’s one thing to know how to write a DAX formula. It’s a completely different level of competency to understand how to write the correct formula and understand why it works. This advanced course will help you become self-sufficient with your data modeling capabilities using DAX in Power BI Desktop, Power Pivot for Excel, and/or SSAS Tabular.
Registration includes access to our live online Q&A calls scheduled twice per week for help with your questions and challenges. You also have access to our exclusive Discussions Forum for help with questions between calls.
Geared towards users with at least 6 months’ experience, this course is more advanced than Supercharge Power BI Online.
Are you a Power BI user who runs into questions and challenges during your day-to-day work? Get direct help with all your Power BI questions from an experienced Power BI consultant and Microsoft Certified Trainer during these bi-weekly (every 2 weeks), live online Q&A calls.
Registration also includes access to our exclusive Discussions Forum for help with your questions between calls.
Prepare to change your company’s reporting game forever! Learn how to use Excel, Power Query, DAX, and Power BI together to build robust Self Service BI solutions.
This course include weekly live, online Q&A calls for help with questions on the week’s course materials, as well as ongoing support through monthly Ask Ken AMA sessions where you can get help with challenges as you apply what you’ve learned to your own work. You also have access to our exclusive Discussions Forum for help with questions between calls.
One module in this course covers report and dashboard building, as well as data visualization, with Power BI Desktop.
This demo-driven course will show you how to really make your Power BI reports shine by adding elements such as bookmarks, tooltips, conditional formatting, custom visuals, and more. If you have a basic working knowledge of Power BI, this training will help fill in any gaps in your knowledge and show you what a stunning Power BI report looks like.
Registration to this on-demand course includes access to the online videos and downloadable example files, as well as our exclusive Discussions Forum for help with your questions.
Learn Power BI from end to end, including how to build and share reports, get and transform your data with Power Query, and use DAX for data modeling. This course will help an absolute beginner as well as anyone that is self-taught that has realized they are missing key learning concepts.
Registration includes access to our live online Q&A calls scheduled bi-weekly (every 2 weeks) for help with your questions and challenges. You also have access to our exclusive Discussions Forum for help with questions between calls.
One third of this course covers report building and data visualization with Power BI Desktop.
The same content as in the video course (above) except it is delivered live, online (over 6 half-days) by a qualified instructor. If you prefer the live learning experience, this is the course for you.
Registration includes 12 months of access to the video online course (above) once the live training is complete. You can also attend the live online Q&A calls scheduled bi-weekly (every 2 weeks), and you have access to our exclusive Discussions Forum for help with questions between calls.
One third of this course covers report building and data visualization with Power BI Desktop.
Are you a Power BI user who runs into questions and challenges during your day-to-day work? Get direct help with all your Power BI questions from an experienced Power BI consultant and Microsoft Certified Trainer during these bi-weekly (every 2 weeks), live online Q&A calls.
Registration also includes access to our exclusive Discussions Forum for help with your questions between calls.
Prepare to change your company’s reporting game forever! Learn how to use Excel, Power Query, DAX, and Power BI together to build robust Self Service BI solutions.
This course include weekly live, online Q&A calls for help with questions on the week’s course materials, as well as ongoing support through monthly Ask Ken AMA sessions where you can get help with challenges as you apply what you’ve learned to your own work. You also have access to our exclusive Discussions Forum for help with questions between calls.
One module in this course covers sharing and managing Power BI Desktop reports and dashboards.
Learn Power BI from end to end, including how to build and share reports, get and transform your data with Power Query, and use DAX for data modeling. This course will help an absolute beginner as well as anyone that is self-taught that has realized they are missing key learning concepts.
Registration includes access to our live online Q&A calls scheduled bi-weekly (every 2 weeks) for help with your questions and challenges. You also have access to our exclusive Discussions Forum for help with questions between calls.
Several lessons cover sharing Power BI Desktop reports.
The same content as in the video course (above) except it is delivered live, online (over 6 half-days) by a qualified instructor. If you prefer the live learning experience, this is the course for you.
Registration includes 12 months of access to the video online course (above) once the live training is complete. You can also attend the live online Q&A calls scheduled bi-weekly (every 2 weeks), and you have access to our exclusive Discussions Forum for help with questions between calls.
Part of Day 2 covers sharing Power BI Desktop reports.
Are you a Power BI user who runs into questions and challenges during your day-to-day work? Get direct help with all your Power BI questions from an experienced Power BI consultant and Microsoft Certified Trainer during these bi-weekly (every 2 weeks), live online Q&A calls.
Registration also includes access to our exclusive Discussions Forum for help with your questions between calls.
Power Query allows you to clean, reshape, and combine your data with ease, no matter where it comes from. This course starts at the beginning and takes you to the point where you will master your data, saving you hours of time and manual effort. Simply put, you won’t find a more comprehensive Power Query course anywhere! Plus, everything you learn in applicable to both Excel and Power BI.
Registration to this on-demand course includes access to the online videos and downloadable example files, as well as our exclusive Discussions Forum for help with your questions.
This course contains several advanced modules on using M code, web-based data sources, parameter and custom functions, time intelligence, allocating values over periods, query optimization, and dataflows.
In this advanced course, we will explore creating the key requirements behind building a robust set of financial statements in Excel using the DAX language. We’ll review the required Chart of Account setup and follow this with key DAX patterns for creating Profit & Loss, Balance Sheet, Statement of Cash Flow, Expected Actuals statements, as well as General Journal, General Ledger and Trial Balance reports.
Registration to this on-demand course includes access to the online videos and downloadable example files, as well as our exclusive Discussions Forum for help with your questions.
This course leverages Power Query to gather and prepare data before loading it to Power Pivot reports.
At the core of every good Power Pivot or Power BI solution is the Data Model. But do you really know how to work with it properly? We’ll teach you the right way to build solid and scalable dimensional models.
Registration to this on-demand course includes access to the online videos and downloadable example files, as well as our exclusive Discussions Forum for help with your questions.
It’s one thing to know how to write a DAX formula. It’s a completely different level of competency to understand how to write the correct formula and understand why it works. Geared towards users with at least 6 months’ experience, this advanced course will help you become self-sufficient with your data modeling capabilities using DAX in Power BI Desktop, Power Pivot for Excel, and/or SSAS Tabular.
Registration includes access to our live online Q&A calls scheduled twice per week for help with your questions and challenges. You also have access to our exclusive Discussions Forum for help with questions between calls.
While this course covers advanced DAX techniques, it does not cover the same breadth and depth of data modeling as Dimensional Modeling for the Excel and Power BI Pro.
In this advanced course, we will explore creating the key requirements behind building a robust set of financial statements in Excel using the DAX language. We’ll review the required Chart of Account setup and follow this with key DAX patterns for creating Profit & Loss, Balance Sheet, Statement of Cash Flow, Expected Actuals statements, as well as General Journal, General Ledger and Trial Balance reports.
Registration to this on-demand course includes access to the online videos and downloadable example files, as well as our exclusive Discussions Forum for help with your questions.
One module of this course covers data modeling specifically for finance.
It’s one thing to know how to write a DAX formula. It’s a completely different level of competency to understand how to write the correct formula and understand why it works. Geared towards users with at least 6 months’ experience, this advanced course will help you become self-sufficient with your data modeling capabilities using DAX in Power BI Desktop, Power Pivot for Excel, and/or SSAS Tabular.
Registration includes access to our live online Q&A calls scheduled twice per week for help with your questions and challenges. You also have access to our exclusive Discussions Forum for help with questions between calls.
In this advanced course, we will explore creating the key requirements behind building a robust set of financial statements in Excel using the DAX language. We’ll review the required Chart of Account setup and follow this with key DAX patterns for creating Profit & Loss, Balance Sheet, Statement of Cash Flow, Expected Actuals statements, as well as General Journal, General Ledger and Trial Balance reports.
Registration to this on-demand course includes access to the online videos and downloadable example files, as well as our exclusive Discussions Forum for help with your questions.
Several modules of this course focuses on DAX measures and patterns specifically for financial statements.
In this advanced course, we will explore creating the key requirements behind building a robust set of financial statements in Excel using the DAX language. We’ll review the required Chart of Account setup and follow this with key DAX patterns for creating Profit & Loss, Balance Sheet, Statement of Cash Flow, Expected Actuals statements, as well as General Journal, General Ledger and Trial Balance reports.
Registration to this on-demand course includes access to the online videos and downloadable example files, as well as our exclusive Discussions Forum for help with your questions.
This course focuses on building financial reports using Excel Power Pivot.
Check back for more information
Subscribe to our monthly newsletter for the latest content from our experts and info on courses, events, and promotions. PLUS, receive our free eBook, Magic Tricks for Data Wizards.
