Power BI Space Missions

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

​

Data Model: