BIG DATA ANALYTICS VISUALIZATION EXCEL

Course details

MODULE 1: Introduction
•Business Intelligence & Big Data today
•What is Story Telling & Data Visualization?
•Story Telling vs Data Visualization
•Data-driven narratives & Dashboards
•Components of a good Dashboard

MODULE 2: Using PivotTables
•Creating Excel Tables & operating them efficiently
•Building a PivotTable
•Sorting, Formatting & Filtering PivotTables
•Grouping records in PivotTables
•PivotTable calculations & formulas
•Slicers & Timelines

MODULE 3: Excel Power Query
•What is Power Query?
•Connecting to various data sources & importing data
•Using Power Query to replace the VLOOKUP
•Shaping & customizing a data model from multiple data sources
•Merging, appending & exporting queries

MODULE 4: Excel PowerMap
•Creating & visualizing data in PowerMap
•Integrating PowerMap into dashboards
•User interaction & form design

MODULE 5: Exploring & visualizing data in Power View
•Exploring data, creating charts & maps
•Slicing, filtering, highlighting & sorting data
•Power View dashboard design

MODULE 6: Excel Power Pivot
•Getting started with Power Pivot
•Importing data into Power Pivot
•Understanding Power Pivot & Relationships
•Creating Relationships between Tables
•KPIs
•Hierarchies
•Data Analysis Expressions (DAX) language overview
•Visualizing data from Power Pivot Updated on 11 May, 2020