Business Intelligence with Excel 2013

Course details

Business Intelligence with Excel 2013

Excel 2013 is a game changer for any Excel user. Excel 2013 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.

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.