This two day course shows experienced Excel users how to use Excel’s self-service BI tools: Power Query, PowerPivot, Power Map and Power View. Delegates will learn to connect to a variety of data sources and create data models, reports, maps, tables, charts and dashboards.
What is PowerPivot for Excel, Importing Your Data, Creating a PowerPivot Data Model, Creating PivotTables with PowerPivot, Creating a Date Table, Using Slicers to Filter Data, Connecting Slicers to more than one PivotTable, Using Charts and Slicers to create interactive Dashboards, Using DAX, Creating Calculated Columns, Creating Calculated Fields, Implicit and Explicit Calculated Fields, Using DAX aggregate functions in a PowerPivot PivotTable, Using CountRows and DistinctCount Functions, The difference between evaluations using Row Context and evaluations using Filter Context, Advanced DAX functions: SUMX and CALCULATE, Time Intelligence Functions, Creating Key Performance Indicators, Using PowerPivot Sets
Adding Data to Power Query from various data sources, Creating a Query, the Query Editor Window, Load to Worksheet and Load to Data Model, Remove Duplicate Data in Columns, Split and Merge Columns of Data, Group data to create summary Queries, Merge and Append Queries, Transpose Data to swap Rows and Columns, Filling data Down to populate missing values, Unpivot Columns: flatten a “cross tab” table, Duplicate Columns, Creating Custom Columns and Additional Date Columns, Working with Applied Steps, Importing Data From a Folder
The Power View Field List, Using Text Boxes, Creating Tables, Changing Table Visualisations, Using a Matrix and Enable Drill Down, Using Cards; Setting up Titles and Pictures for Cards, Creating Chart Visualisations and Interactive Charts, Creating Power View Slicers, Using Tiles, Using Power View Filters, Working with interactive Bubble Charts using the Play Axis, Creating Power View Maps
Create a Power Map and Plot Geographic Data, Creation Visualisation; Column, Bubble, Heatmap, Regions, Using the 3-D Environment, Using Charts with Power Maps, Working with Layers and adding Scenes, Adding Annotations, Visualising Data over Time, Playing the Tour
Overview of Power BI for Office 365
Getting started with Power BI , What you need for Power BI , Sharing and using Power Queries , Sharing a Power View report , Using the Power BI sites , Adding synonyms to a data model