Data Analysis - Multi-Dimensional Visualization on Power bi Dashboard
Marnikrish9
session_3_slides_1.pptxPerformance Management (BPM and Dashboards)
Wilmington University SEC.6050 Business Intelligence
1
Session 3
+
Session 3 Learning Objectives
Define business reporting and understand its historical evolution
Recognize the need for and the power of business reporting
Understand the importance of data/information visualization
Learn different types of visualization techniques
Appreciate the value that visual analytics brings to BI/BA
Know the capabilities and limitations of dashboards
Understand the nature of business performance management
Learn the closed-loop BPM methodology
Describe the basic elements of balanced scorecards
Wilmington University SEC.6050 Business Intelligence
2
+
Business Reporting
Self-service BI
Ad hoc query and reporting tools
SAP Business Objects
IBM Cognos Workspace
MicroStrategy Web
Query vs Reporting
Formatting
Naming
Automatic Metric Calculation
Wilmington University SEC.6050 Business Intelligence
3
+
Business Reporting (cont’d)
Reporting Cycle
Wilmington University SEC.6050 Business Intelligence
4
+
Business Reporting (cont’d)
Visual Data Discovery
Wilmington University SEC.6050 Business Intelligence
5
+
Business Reporting (cont’d)
Dashboards
Intuitive – highly-visual
Intuitive – minimal training
Multi-sourced
Drill-down, drill-through
Dynamic view, automatically refreshed
Minimal coding to develop, deploy, and maintain
Wilmington University SEC.6050 Business Intelligence
6
+
Business Reporting (cont’d)
Executive-style Dashboard
Wilmington University SEC.6050 Business Intelligence
7
+
Business Reporting (cont’d)
Operation-style Dashboard
Wilmington University SEC.6050 Business Intelligence
8
+
Business Reporting (cont’d)
Scorecards
Baseline Forecast or Target
Key Performance Indicators
RAG Indications
Wilmington University SEC.6050 Business Intelligence
9
+
Other Types of Reporting
Production Reporting
Operational/Enterprise/Pixel Perfect Reporting
Reports embedded into the transactional system
Static , not ad hoc reporting
Regulatory Reporting
Mobile BI
Distinct Applications for mobile devices
OLAP
Multi-Dimensional
Fast
Interactive
Aggregation Levels
Cross-dimensional calculations
Excel
Wilmington University SEC.6050 Business Intelligence
10
+
Visualization
SAS Visual Analytics Architecture
Big data + In memory + Massively parallel processing RAG Indications
Wilmington University SEC.6050 Business Intelligence
11
+
Data Visualization
Line Charts
Bar Chart
Pie Chart
Scatter Plot
Bubble Chart
Histogram
Gantt Chart
PERT Chart (Network Diagrams)
Bullet
Heat Map
Highlight Table
Tree Map
Wilmington University SEC.6050 Business Intelligence
12
+
Business Performance Management
Closed-loop BPM Cycle
Wilmington University SEC.6050 Business Intelligence
13
Process Steps
Strategize
Plan
Monitor/analyze
Act/adjust
Each with its own process steps
+
Balanced Scorecards
Wilmington University SEC.6050 Business Intelligence
14
+
Balanced Scorecards
Wilmington University SEC.6050 Business Intelligence
15
+
Measuring Success
ROI
BI User Saturation
Increased Customer Service
Increased Employee Satisfaction
Process Time Efficiencies
Reporting Consolidation
Advanced and Predictive Analytics
Wilmington University SEC.6050 Business Intelligence
16
+
Six Sigma Performance Measurement System
“Lean Manufacturing” relationship
Six Sigma Steps:
Define
Measure
Analyze
Improve
Control
Wilmington University SEC.6050 Business Intelligence
17
+
Multi-Dimensional Visualization
Decimation of Napoleon’s Army During the 1812 Russian Campaign
Wilmington University SEC.6050 Business Intelligence
18
+
KPIs and Operational Metrics
Key performance indicator (KPI)
A KPI represents a strategic objective and metrics that measure performance against a goal
Distinguishing features of KPIs
Wilmington University SEC.6050 Business Intelligence
19
Strategy
Targets
Ranges
Encodings
Time frames
Benchmarks
+
KPIs and Operational Metrics
Wilmington University SEC.6050 Business Intelligence
20
Key performance indicator (KBI)
Outcome KPIs vs. Driver KPIs
(lagging indicators (leading indicators
e.g., revenues) e.g., sales leads)
Operational areas covered by driver KPIs
Customer performance
Service performance
Sales operations
Sales plan/forecast
+
Data
Repositories
Business Functions
UOB 1.0X
UOB 2.2
UOB 2.1XUOB 3.0
1
Machine
Failure
SymbolCountDescription
Exception Event
Transactional Records
PHASE 5
DEPT 4
DEPT 3
DEPT 2
DEPT 1
PHASE 4PHASE 3PHASE 2PHASE 1
DEPLOYMENT CHART
1
2
3
4
5
Information
(reporting)
Decision
Maker
Action
(decision)
Data
