Full-Day Webinar - Hosted Using Teams
Course Objective: Have you spent hours trying to bring data from multiple sources into a single spreadsheet to analyze your data? This three-day boot camp explores the fundamentals of data transformation using Get & Transform (PowerQuery), data analysis and reporting with PowerPivot, and presenting geographical data visually using 3D Maps in Excel.
Learn to easily incorporate data from multiples sources to model data and create powerful visual reports in Power BI Desktop. You will learn to use the data model, build tables, charts, relationships, measures, hierarchies, KPI's, and drill downs of your data, as well as publish a completed Power BI Desktop file to the cloud.
This Boot Camp is designed to provide an introduction to using the Excel Power Tools and Power BI. As these are very powerful Data Analysis tools, you may need additional training to learn all of their capabilities.
Prerequisites: To ensure your success, we recommend that you first take Excel Level 1, Level 2, and In-Depth PivotTables, or have equivalent knowledge and skills - such as knowledge of advanced features and functions.
Course Objectives:
- Introduction to Get & Transform (Power Query), PowerPivot, 3D Maps, Power BI Desktop and Power BI Online
- Learn to analyze data in Pivot Tables and Pivot Charts created from Power BI Tools
- Visualize data and create reports
- Understand what a Data Model is and load data to the Data Model
- Transform data in a query
- Create relationships between data sources instead of using VLOOKUP
- Add calculated columns and measures
See the full outline here.
