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

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

Sale Page

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.

Get immediately download Business Intelligence with Excel 2013(Ian) from Stone River eLearning

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.

We guarantee that all our online courses will meet or exceed your expectations. If you are not 100% satisfied with a course – for any reason at all – simply request a full refund.

That’s our promise to you. We hate games, gimmicks and tricks as much as you do. We guarantee no hassles if you want a refund, so ahead and order with confidence. You have absolutely nothing to lose.

Course Curriculum

Introduction

Introduction to Excel Business Intelligence Technologies (2:58)

Activating Addins (2:20)

Working with Power Query

Introduction to Power Query

Power Query Interface (8:39)

HR Master

Cleaning and Transforming Data with Power Query (14:39)

Download the Append Data Files

Appending Data with Power Query (9:22)

Download Merge Data Files

Merge Data with Power Query (8:53)

Sales Data

Using the Group By Feature (8:06)

Load Data to Power Pivot (10:14)

Working with Power Pivot / Data Model

Get immediately download Business Intelligence with Excel 2013(Ian) from Stone River eLearning

Introduction to Power Pivot

Introduction to Power Pivot (1:49)

Download the Employee Master Training File

Loading Data into PowerPivot (7:28)

Creating Relationships (3:41)

Analyzing Data with Pivot Tables (8:56)

Calculated Columns (12:11)

Calculated Fields (11:33)

Pivot Tables and Pivot Charts (14:29)

Creating Interactive Dashboards (14:31)

Excel Power View

Introduction to Power View

Introduction to Power View (4:12)

Tables and Tiles in Power View (8:15)

Visualization Column and Bar Charts (14:27)

Visualizations Line (5:55)

Interactive Dashboard (9:54)

Using Filters in Power View (6:03)

Download the Sales Training Data Source

Creating Scatterplots in Power View (7:12)

Creating ScatterPlots over Time (4:24)

Mapping Data (7:49)

Power Map

Power Map

Introduction to Power Map (3:00)

Mapping Data in Power Map (3:39)

Changing the Method of Visualization (5:31)

Mapping Over Time (1:42)

Changing the Method of Aggregation in Power Map (4:43)

Creating Tours of Power Map Data (3:03)

Conclusion

Conclusion (0:50)

Get immediately download Business Intelligence with Excel 2013(Ian) from Stone River eLearning