Scribd
Upload
4 views2 pages

Data Summarization & Visualization Guide

The document covers key concepts in data summarization and visualization, focusing on descriptive statistics, measures of central tendency and dispersion, and tools like Pivot Tables and Charts in Excel. It also discusses what-if analysis techniques and various data visualization methods, including bar charts, pie charts, and dynamic charts. Additionally, it highlights the importance of dashboards for presenting combined visual summaries using key performance indicators and clean layouts.

Uploaded by

gadhe.sona98
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views2 pages

Data Summarization & Visualization Guide

The document covers key concepts in data summarization and visualization, focusing on descriptive statistics, measures of central tendency and dispersion, and tools like Pivot Tables and Charts in Excel. It also discusses what-if analysis techniques and various data visualization methods, including bar charts, pie charts, and dynamic charts. Additionally, it highlights the importance of dashboards for presenting combined visual summaries using key performance indicators and clean layouts.

Uploaded by

gadhe.sona98
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

UNIT 2 – DATA SUMMARIZATION & VISUALIZATION (MBA Notes)

1. Descriptive Statistics

Descriptive statistics help in understanding the basic characteristics of data.

1.1 Measures of Central Tendency

Mean – Average of values, sensitive to outliers.

Median – Middle value, unaffected by outliers.

Mode – Most frequent value, useful for categorical data.

1.2 Measures of Dispersion

Range – Max − Min.

Variance – Measures spread from mean.

Standard Deviation – Square root of variance; widely used.

2. Data Summarization in Excel

Pivot Tables – Summarize large datasets with rows, columns, values, and filters.

Pivot Charts – Graphical summaries linked to Pivot Tables.

3. What-If Analysis

Data Tables – One/two variable sensitivity analysis.

Goal Seek – Finds required input to reach a target output.

Scenario Manager – Compares multiple business scenarios.

4. Data Visualization

Bar/Column Charts – Compare categories.

Pie Charts – Show proportions.

Line Graphs – Show trends over time.

Histograms – Show frequency distribution.


Scatter Plots – Show relationships/correlation.

5. Dynamic Charts & Sparklines

Dynamic Charts – Update automatically with data.

Sparklines – Mini-charts inside cells.

6. Dashboard Basics

Dashboards provide combined visual summaries using KPIs, charts, PivotTables, slicers, and clean
layouts.

You might also like