Business Intelligence with Excel (IL003)



Excel provides new technologies and tools for the business user to easily analyze data to create powerful reports and dashboards in a fraction of the time of traditional spreadsheets.

This course is for all business users who want to learn how to create management reports, analyze data, and create interactive dashboards using Excel 2013 or newer versions.

In this course we learn the following:

Power Query

Cleaning up Data
Merging Data
Appending Data
Grouping Data
Loading data to PowerPivot
Power Pivot

Create relationships between Tables
Manage millions of rows of data
Custom Calculations, Key Metrics and KPIs
Analyzing Data with Pivot Tables
Analyzing Date data
Power View

Creating Tables and Cards
Visualizing data with Graphs
Creating Interactive dashboards
Filter and Ask Questions of your Data
Powerful data analysis with ScatterPlots and BubblePlots
Visualize Geographical data and maps
Power Map

Mapping Data with Power Map
Changing the Method of Visualization
Changing the Method of Aggregation
Mapping Data over Time
Creating Tours
This course will provide you with an easy to follow step by step approach to using the new Business Intelligence technology in Excel 2013.


There are no reviews yet.

Be the first to review “Business Intelligence with Excel (IL003)”