creating a powerful dashboard using power bi...creating a powerful dashboard using power bi...
TRANSCRIPT
CREATING A POWERFUL
DASHBOARD USING POWER BI
Housekeeping
Check that slides
are visible
Mute your
microphoneSlides will be
made available
Chat function
for questions
Raise hand
for questions
Switch Off
Camera Feedback
8 September 2020
Ram Mahavadi
Creating Powerful Dashboards
via Microsoft Power BI
Agenda
09 September 2020 4
1 3
5
Data Preparation
Visualizations Questions and Answers
Introduction
Ha
2
Data Collection
64
Governance
iStock-840166882
Introduction 1
Introduction
09 September 2020 6
▪ Why?
▪ What is Microsoft Power BI?
Data
▪ Publicly Available (from regulator)
Visualizations
▪ Many possible – this is just a sample
N B: Hands-on
▪ Converting data to Value is a process
▪ A sample report to show the possibilities
▪ Please contact your Munich Re Client Manager
if you would like to pursue any opportunities
Take-aways
Background
4
2
iStock-663981890
Data Collection
Data Collection
09 September 2020 8
Analyst ReportsPublic Databases Annual Reports
Financial Regulators Internal Data
Data Preparation 3
iStock-838552526
Data Preparation
09 September 2020 10
Data classificationData cleanup Data enhancement
Sandton Vs Santon
Director Vs Dir
Client Vs Not Client
Global Vs Local
Missing Values
Enrich with outside data e.g PIN Codes
iStock-918855102
Governance 4
Governance
09 September 2020 12
Data Security Report Security
Folder location;
Database access controls
Location – Sharepoint;
Granularity access & Confidentiality
iStock-479446229
Power BI - Visualizations 5
Visualization
09 September 2020 14
Data
▪ Loading
▪ Verification
Visual tools
▪ Graphs Vs Tables
▪ Pie Vs Donuts
Calculated Columns
▪ Many possible – this is just a sample
Advanced Tools
▪ Calculating Ratios
▪ Bubble maps
Market Place
▪ Additional Visuals
Dashboards
▪ Publishing
Your feedback matters
Please visit: www.menti.com
Use the code: 69 24 91 4
Feedback Form - Creating a Powerful Dashboard using
Power BI
iStock-528612314
Q & A 6