Learn how to use Power Query to import and clean data automatically in Excel and Power BI. We'll show you how to clean, reshape, and combine your data with ease, no matter where it comes from, and refresh it with just a click. Power Query will help you master your data, saving you hours of time and manual effort.
Prepare to change your company's reporting game forever! In the Self Service BI Boot Camp, Ken Puls will teach you how to use Excel, Power Query, and Power BI together to build robust Self Service BI solutions. This hands-on guided training includes access to nearly 20 hours of recorded video and twice-monthly 'Ask Ken Anything' support sessions.
You can become a Power BI ninja if you learn getting and transforming your data, reporting with Power BI, and how to write DAX! This course developed by Matt Allington, a Microsoft MVP(Power BI) and expert trainer, who will teach you Power BI from end-to-end with hands-on experience. It includes bi-weekly (every 2 weeks) live online Q&A calls.
Power BI is better when you learn to write DAX! This online Power BI course, developed and delivered by Microsoft MVP (Power BI) and best-selling author Matt Allington, will teach you how to use the data modeling capabilities in Power BI Desktop and Power Pivot for Excel.
Become a Power BI expert by learning reporting and data modeling with DAX. This LIVE, online, instructor-led training is conducted over 6 half-days. It is developed by Matt Allington, MVP (Power BI) and author of the best-selling book 'Supercharge Power BI'. It is delivered by Jason Cockington, who is trained by Matt Allington and is certified by Microsoft.
In the Excel Fundamentals Boot Camp you’ll 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.
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? This on-demand course is intended to teach you the right way to build solid and scalable dimensional models. Registration includes both the Excel and Power BI versions of the course.
This online Power BI DAX course was developed and is delivered by Microsoft Power BI MVP and best-selling author Matt Allington. The course will help you take the important step of becoming self-sufficient with your data modeling capabilities using DAX in Power BI Desktop, Power Pivot for Excel, and/or SSAS Tabular.
This advanced course explores the data structure and measures required to build 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.
Power BI Desktop has a host of features available to build impactful reports. This demo-driven course will show you how to really make your reports shine by adding elements such as: drillthrough, bookmarks, report page tooltips, conditional formatting, custom visuals, and more.
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.
If you need to learn one new tool today, Power Query is it! This FREE course explains the fundamental concepts of Power Query, so you can have a basic understanding of what Power Query does and when to use it.