Objective:
The objective is to provide stakeholders with insights into mission details, success rates, and the usage of space rockets, facilitating informed decision-making and enhancing understanding of past, current, and future space missions.
Goals:
Track key performance metrics (KPIs) and trends for the company.
Empower stakeholders with real-time data for better decision-making.
Make it as simple and comprehensive as possible so that anyone can understand it.
Activities:
Data Integration: Connected to a CSV file to gather Space Missions information.
Data Cleaning & Transformation: Used Power Query to Prepare the data by ensuring accuracy and consistency, making it suitable for analysis.
Optimize the model: Make key DAX measurements that allow us to have all the information needed without loading the model.
Dashboard Design: Utilize Figma to make a beautiful and minimalist dashboard design able to showcase the most important information for the stake holder. It is intended to have an intuitive and friendly user experience. Since it has a fresh and minimalist look, a Q&A visual was added on the filter pane so that the user can get any other analytic that is not shown on the dashboard.
Key Findings and recommendations:
Success rate: It is safe to say that most of the missions performed have been successful.
Prelaunch Failures: The prelaunch failures are less than 1% of the total missions performed, which means that the process involved has been carefully crafted.
DAX Formulas used:
CALCULATE(
COUNTA(space_missions[MissionStatus]),
FILTER(space_missions,space_missions[MissionStatus]=“Failure”)
) + 0
CALCULATE(
COUNTA(space_missions[MissionStatus]),
FILTER(space_missions,space_missions[MissionStatus]=“Partial Failure”)
) +0
CALCULATE(
COUNTA(space_missions[MissionStatus]),
FILTER(space_missions,space_missions[MissionStatus]=“Prelaunch Failure”)
) +0
CALCULATE(
COUNTA(space_missions[MissionStatus]),
FILTER(space_missions,space_missions[MissionStatus]=“Success”)
) +0
- Success Rate = [Success]/COUNTA(space_missions[MissionStatus])
Screenshots:
Data Model: