VIP20
本课程属于：027-CAE Data Analytics & Crash Safety Engineering English Technical Courses · 共 20 门相关课程，组合学习更完整。
查看所属VIP全部课程 →
← 返回所属目录 咨询 / 购买

Power BI Crash Safety Dashboard Design and Visualization

30 Chapters
View Course Samples Online
01
Crash safety data landscape
sources, formats, and key metrics for dashboard design.
landscapedashboard
02
Power BI environment setup
installing Power BI Desktop, configuring options, and connecting to crash data sources.
environmentinstalling
03
Data ingestion from crash databases
importing CSV, Excel, and SQL Server crash records with Power Query.
ingestiondatabases
04
Data cleaning and transformation for crash safety
handling missing values, standardizing severity codes, and normalizing timestamps.
cleaningtransformation
05
Building a crash data model
designing star schema with fact tables for crashes, vehicles, and casualties.
Buildingdesigning
06
Creating relationships and hierarchies
linking crash, vehicle, and person tables for drill-down analysis.
Creatingrelationships
07
DAX fundamentals for crash safety metrics
calculating crash frequency, injury severity rates, and fatality ratios.
DAXcalculating
08
Time intelligence in crash analysis
year-over-year trends, seasonal patterns, and moving averages using DAX.
intelligenceanalysis
09
Geospatial visualization of crash locations
using map visuals, heatmaps, and custom shape maps for accident hotspots.
Geospatialvisualization
10
Designing crash severity dashboards
KPI cards, gauges, and conditional formatting for injury severity distribution.
Designingseverity
11
Interactive filtering with slicers
enabling dynamic analysis by date, region, road type, and vehicle category.
Interactivefiltering
12
Drill-through and tooltips
creating detailed crash reports and hover-over insights for specific incidents.
Drill-throughtooltips
13
Visualizing crash trends over time
line charts, area charts, and anomaly detection for accident frequency.
Visualizingdetection
14
Comparative analysis of crash causes
bar charts, treemaps, and decomposition trees for contributing factors.
Comparativeanalysis
15
Building a crash hotspot map with custom visuals
integrating ArcGIS for Power BI and heatmap layers.
Buildingintegrating
16
Dashboard layout and UX design for safety analysts
arranging visuals for intuitive navigation and quick insights.
Dashboardanalysts
17
Implementing bookmarks and navigation
creating guided stories and scenario-based views for crash investigations.
Implementingbookmarks
18
Row-level security for crash data
restricting access by region or jurisdiction using DAX filters.
Row-levelsecurity
19
Performance optimization
reducing model size, using aggregations, and optimizing DAX for large crash datasets.
Performanceoptimization
20
Publishing and sharing crash safety dashboards
Power BI Service workspaces, apps, and scheduled refreshes.
Publishingdashboards
21
Mobile dashboard design for field crash investigators
optimizing visuals for phone and tablet layouts.
dashboardinvestigators
22
Integrating real-time crash data
streaming datasets and push notifications for incident alerts.
Integratingreal-time
23
Advanced DAX for crash safety
calculating crash rates per vehicle mile traveled and severity indices.
AdvancedDAX
24
Custom visuals for crash analysis
using Chiclet Slicer, Bullet Chart, and Box Plot for severity comparisons.
analysisseverity
25
Creating a crash safety scorecard
combining multiple metrics into a composite safety performance indicator.
Creatingscorecard
26
Dashboard accessibility and compliance
ensuring color contrast, alt text, and screen reader support for safety reports.
Dashboardaccessibility
27
Case study
designing a national crash safety dashboard from raw police reports to interactive insights.
designingnational
28
Case study
building a city-level crash hotspot analysis dashboard with predictive risk indicators.
buildingcity-level
29
Automating crash data refresh and alerts
using Power Automate to trigger dataflows and email notifications.
AutomatingAutomate
30
Capstone project
end-to-end design of a crash safety dashboard with stakeholder requirements, data modeling, visualization, and deployment.
Capstoneend-to-end