Why and for whom?
Always working with large data set and wishing to analyse them in Excel, BUT don’t know how to get started?
Having problem to use multiple data sources/tables to analyse in one PivotTable?
With this training, Analyzing And Visualizing Data with Excel, all your doubt will be answered! In this training we will guide you on how to import big data from various types of data source, create relationships between different sources, analyse and visualize your data in an efficient manner.You can do all these tasks without requiring IT assistance!
You will learn how to use Excel's Power Pivot, Power View and Power Map tools to view, analyze, and process large amounts of data. You will learn how to combine the functionality of Power View, Power Map and Power Pivot that lets you create interactive charts, maps, and other visuals that bring your data to life using simple drag and drop actions.
Power Map
Power Map lets you discover insights you might not see in traditional two-dimensional (2-D) tables and charts
With Power Map, you can plot geographic and temporal data on a 3-D globe or custom map, show it over time, and create visual tours you can share with other people.
Power View
Power View allows you to create quick and interactive dashboard reports, with built-in drill-down, perform information analysis rapidly, and share insights easily.
In Power View, you can quickly create a variety of visualizations, from tables and matrices to pie, bar, and bubble charts and sets of multiple charts.
Time based scatterplot and bubbleplot advanced visual analysis techniques will be covered too.
Power Pivot
Power Pivot allows you to import millions of rows of data from virtually any data source, including Access databases, SQL Server, text files, CSV file, Excel files, and data from the Web into a single Excel workbook. Allow you to create data relationships between different sources just like Microsoft Access.
This training is ideal for data analysts, financial analysts, business analysts, managers, executives and anyone who wants to harness Excel's business intelligence capabilities.
What will you learn?
In this training, you will learn how to use Excel's Power Map, Power View, and Power Pivot tools to view, analyze, and process large amounts of data. You will learn how to combine the functionality of Power View, Power Map and Power Pivot that lets you create interactive charts, maps, and other visuals that bring your data to life using simple drag and drop actions. You will learn a new way to build complex graphs and Power View reports and then combine them into dynamic dashboards.
3D Map / Power Map
~ Enabling 3d Map/Power Map
~ Creating Your First 3d Map/Power Map
~ Saving Your Tour
~ Exploring Your Data In A 3d Map/Power Map Tour
~ Changing The Look Of Your 3d Map/Power Map
~ Showing A Heat Map In 3d Map/Power Map
~ Changing Scene Options
~ Filter Data In A 3d Map/Power Map Tour
~ Play A Tour
Creating Visual Reports With Power View
~ Enabling Power View Add-In For Excel
~ Data Sources For Power View
~ Creating A Power View Report
~ Creating Charts And Other Visualizations
~ Creating A New Table
~ Inserting A Power View Report
~ Filtering And Highlighting In Power View
~ Using The Multiples Feature To Easily Create Many Charts
~ Formatting Power View Reports
~ Creating Map Visualization
~ Creating A Scatter Chart
~ Creating A Bubble Chart
~ Play Axis
~ Displaying Tiles With Images
|
Power Pivot
~ Enabling Power Pivot Add-In For Excel
~ Getting Started With Power Pivot
~ Importing Data Into Power Pivot
~ Loading Data From Excel
~ Refreshing Data
~ Managing Power Pivot Data
Extending The Excel Data Model Using Power Pivot
~ Data View And Diagram View
~ Creating Relationships
~ Preparing A Date Table
~ Creating Calculated Column
~ Calculated Fields
~ Creating Pivot Tables From Power Pivot
~ Creating A Measure And KPI
Case Study: Visualizing The Olympics With Power View In Excel
~ Import Data Into Excel And Create A Data Model
~ Extend Data Model Relationships Using Excel, Power Pivot, And DAX
~ Creating Map-Based Power View Reports
~ Incorporate Internet Data, And Set Power View Report Defaults
~ Creating Amazing Power View Reports
|
Training Exercise
During the training, you will be doing hand-on exercise:
|
Plotting geographic and temporal data with 3D Map/Power Map
|
Creating visual tours with 3D Map/Power Map |
Creating quick and interactive dashboard reports with Power View
|
Importing millions of rows of data from any data source |
Case Study: Visualizing The Olympics With Power View In Excel |
|
|
What will you receive?
Participants will receive our Analyzing and Visualizing Data with Excel training handouts with exercises files.