Download Course OutlineMicrosoft Excel 2016 Business Intelligence Tools 

Duration: 2 Days

Including Power Pivot, Queries, 3D Map & Microsoft Power BI Visualisations.
Are you a power Excel user? Are you forever trying to make sense of ever-growing piles of data?  Do you need easy, intuitive tools to allow data discovery, visualisations, and collaboration? Excel, always great for analysing data, is now even more powerful with its suite of Power BI tools.  With the Excel 2016 Business Intelligence tools you can give everyone in your organization a powerful new way to work with data. On this course, learn about the skills you need to provide faster data insights to your organisation, including Power Pivot, Queries, 3D Map and Power BI Viualisations.  


 Call us on 0800 0199 746  


Microsoft Excel 2016 Business Intelligence Tools - course content

  You can download a PDF course outline using the link on the top right of this page.

PowerPivot

  • 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
  •  

    Queries

  • 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
  •  

    3D Map

  • Create a 3D Map and Plot Geographic Data
  • Creating Visualisation; Column, Bubble, Heatmap, Regions
  • Using the 3-D Environment
  • Using Charts with 3D Maps
  •  

    Microsoft Power BI Visualisations

  • What are Power BI Visualisations
  • Creating a Microsoft Power BI Account
  • Downloading Power BI Desktop
  • Importing data into Power BI
  • Transforming & Cleaning data in Power BI
  • Creating Calculations in Power BI
  •  

     

  • Using DAX
  • Creating Calculated Columns & 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
  •  

  • 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
  •  

     

  • Working with Layers and adding Scenes
  • Adding Annotations
  • Visualising Data over Time
  • Playing the Tour
  •  

     

  • Creating a variety of interactive visualisations
  • Publishing visualisations to PowerBI.com
  • Creating Dashboards
  • Sharing your Dashboards
  •  

     


     Call us on 0800 0199 746