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 24 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 with Power Query, 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.
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.
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.
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.
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.
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.
Data visualization is the art and science of presenting data in a clear, engaging, and meaningful way. It can help you communicate insights, tell stories, and persuade audiences. In this course, you will learn the fundamental skills to create better, more effective graphs, charts, and diagrams in Excel and Power BI.
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.
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.
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.