Learning Data Visualization with Power BI

Global Suicide Rate Analysis & Visualization

Purity Supaki
Apr 25 · 7 min read

Introduction

Power BI Components

Power BI Components & Tools

Power BI Desktop & Power BI Service Comparison

Data Sources

Sample dataset

Data Preprocessing

Think of DAX as Excel functions and formulas.

#AgeGeneration Group calculated columnAgeGeneration Group = IF(master[age] ="5-14 years", "Generation Z", IF(master[age] = "15-24 years", "Generation Z", IF(master[age] = "25-34 years", "Millenials",IF(master[age] = "35-54 years", "Generation X", IF(master[age] = "55-74 years","Boomers", IF(master[age] = "75+ years", "Silent/G.I Generation"))))))
New Generation Column (My Workspace)
Sort suicide_no by age data field (My Workspace)
Sort by Column (My Workspace)
Sort Age Relationship View (My Workspace)
// New Column in master table
RELATED('Sort Age'[age])
Comparison charts between the unsorted and sorted age columns

Power BI Reports

Global Suicide Rate Analysis

My Workspace
My Workspace
My Workspace
My Workspace
My Workspace
My Workspace

Conclusion

Geek Culture

Proud to geek out. Follow to join our 1M monthly readers.