Analyzing and Visualizing Data with Excel

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.

Microsoft Excel 3D Map Power Map Training Melaka Puchong Selangor Malaysia

Microsoft Excel Power View Training Melaka Puchong Selangor Malaysia

Microsoft Excel Power Pivot Training Melaka Puchong Selangor Malaysia

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