Stone River eLearning – Business Intelligence with Excel 2013(Ian)

Description

Stone River eLearning – Business Intelligence with Excel 2013(Ian)

Archive: https://archive.is/3yeOY

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.
Get Stone River eLearning – Business Intelligence with Excel 2013(Ian) download