Excel BI
Video

Excel BI

12 Lessons      Easy

About this course

Legacy course. Superseded by Microsoft Power BI nevertheless Excel retains business intelligence capabilities and many have been enhanced and or new functionality added.

Course Structure

Members Only

Introduction Excel BI

Big Data - actionable business intelligence

Members Only

Preliminaries

Business Intelligence is about transforming your data into actions. The end game: Improve productivity and or return on investment.

Members Only

PowerQuery

Power Query is a tool that allows you to extract and important data into Excel for further analysis. For example, websites, CRM, accounting software, databases to name just a few.

Members Only

PowerPivot

Microsoft Power Pivot is a tool to build relationships between database tables. Doing so enables us to ask powerful questions of our data. To clarify our objective for Power Pivot. We are appending merging, combining tables into a data model but I should emphasis our tables remain separate. The key learning point here is we are building relationships to allow us, to interrogate our, data.

Members Only

Introduction Spatial Data

Excel Maps, applied to MS Power BI

Members Only

PowerView

Like Power Query and Power Pivot, Power View is another Excel self-service tool. Like Power Pivot we can build tables, charts, maps in Power View. However, Power View takes it a step further by allowing us to create remarkably integrated and multifaceted reports.

Members Only

Microsoft Power BI

MS Power BI gives us the ability to share power query and power view data with others who may be members of the team or with members who work with different teams.

Members Only

PowerPovitTables

Modelling Your Data using Power Pivot

Members Only

Enhancing Pivot Tables and Pivot Charts with Power Pivot

A pivot table is a data visualisation tool to summarise data. Users can control pivot table and or chart data by dragging and dropping fields graphically.

Members Only

Expanding the Data Model in Power Pivot

Expanding the data model in Microsoft Excel 2016 power pivot In this presentation I use Microsoft Contoso free retail database.

Members Only

Visualising Geospatial Data With Power Map

Presenting data graphically can help an audience to easily grasp complex numerical data.

Members Only

Creating and Formatting Power View Reports

Building and formatting power view reports.

Powered by Thrive Apprentice
>