Microsoft Office® Excel:
Introduction to Excel Power Tools

Learn the fundamentals of the Excel Power BI tools, such as Power Query, Power Pivot, Power Map, Power View and Power BI Desktop.

Full Course Description:

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 PowerMap 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.

Microsoft Office Excel: Introduction to Excel Power BI Tools (3 Days) Course Objectives: • Introduction to Power Query, Power Pivot, Power Maps, Power BI Desktop and Power BI Online • 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 • Learn to analyze data in Pivot Tables and Pivot Charts created from Power BI Tools • Visualize data and create reports Agenda   Days 1 & 2- Class Times 8:45AM - 5:00PM   Power Query   Explore the Power Query/Get & Transform • Power Query in Excel 2013 vs Get & Transform • Identify Data Source Types Available for Import   Connect to and Load Data using Power Query • Connect to Data Sources • Use Query Editor to View Data • Data Load Options and Query Navigation Panel  Transform and Shape Data using Columns • Column Options in Query Editor • View and Modify Query Steps • Sort and Filter Data in Query Editor   Group Data, Append and Merge • Group Data in a Column • Append Data from Two Queries • Merge Two Queries Together   Aggregate Data and Analyze Data • Use Query Editor to Aggregate Data from a Column • Analyze Query Data in a Pivot Table     Power Pivot   Getting Started with Power Pivot • Explore the Power Pivot Application • Import Data from Various Data Sources • Refresh Data from a Data Source • Create Linked Tables   Manipulating Power Pivot Data • Organize and Format Tables • Create Calculated Columns • Sort and Filter Power Pivot Data • Work with Table Relationships and the Data Model  Creating Power Pivot Reports • Create PivotTables from Power Pivot • Create PivotCharts from Power Pivot • Filter Data Using Slicers • Present PivotTable Data Visually   Introduction to DAX Measures in Power Pivot • Using Calculated Columns with Measures • Manipulate Power Pivot Data Using DAX Measures   Distributing Power Pivot Data • Protect Reports • Manipulating Power Pivot Data Using DAX Measures   Day 3 - Class Times 8:45AM - 5:00PM   Power BI Desktop   Introduction to Power BI Desktop • Understand the Power BI Desktop Interface • Utilize the File Types; PBIX vs. PBIT • Examine Data Sources • Transform Data with Query Editor • Build a Data Model • Add Calculated Columns to Data Tables • Create Measures using DAX • Build Reports Using Visual Tiles • Refresh Data Sources • Publish to Power BI Online   Power BI (Online)   Introduction to Power BI (Online) • View the Online Interface • Publish Excel File to Power BI (Office 365 Only) • Examine the Workspace • Create Visuals and Reports Online • Create Dashboards using Pinned Tiles • Set Favorites and Featured Dashboards • Introduction to Share Options   Power Map   Getting Started with Power Map • Power Map Overview • Power Map Environment • Data Source • Launch and Navigate Options through Power Map   Create a Power Map • Create and Delete Tours • Scene Settings and Options • Add and Use Layers • Layer Manager  Organizing the Source Data in Power Maps • Work with Tables and Filters • Field List Options • Geography • Mapping Options (Column, Bubble, Heat, and Region) • Value, Time, Categories   Visualization for Power Maps • Work and Modify Themes • Map Display Options • Insert Graphical Contents (Charts, Text Boxes, Legends)   Play Power Map • Run Power Map Tours • Copy a Power Map Tour • Export a Power Map to Video • Save Options

Contact us for more information or to enroll in this boot camp

Return to top of page.