Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Business Intelligence with Excel 2013

Video Introducing this tutorial


Introduction :
Introduction to Excel Business Intelligence Technologies
Activating Add Ins for Excel 2013

Working with Power Query :
Introduction to Power Query
Power Query Interface
Download the Training Data File
Cleaning and Transforming Data with Power Query
Download the Append Training Data
Appending Data with Power Query
Download the Merge Data Files
Merging Data with Power Query
Download the Sales Data Files
Using the Group By Feature
Loading Data into PowerPivot

Working with Power Pivot / Data Model :
Introduction to Power Pivot
Introduction to Power Pivot
Download the Employee Master Training File
Loading Data into Power Pivot
Creating Relationships in Power Pivot
Analysing Data with Power Pivot
Creating Calculated Columns
Creating Calculated Fields
Pivot Tables and Pivot Charts
Interactive Dashboards

Excel Power View :
Introduction to Power View
Introduction to Power View
Tables and Tiles in Power View
Column and Bar Visualizations
Line Graph Visualization
Power View Interactive Dashboards
Using Filters in Power View
Download the Sales Training Data Source
ScatterPlots in Power View
ScatterPlots over Time
Mapping Geographical Data

Power Map :
Introduction to Power Map
Introduction to Power Map
Mapping your Geographical Data
Changing the Method of Visualization
Mapping over Time
Changing the Method of Aggregation
Creating Tours

Conclusion :
Conclusion

You Have Got Gift 25% OFF

Use this Coupon Code “J3JKN396