Space Mission Report in Power BI
Embedded Files
Project Description:
As a Power BI Analyst, my task was to complete the Space Mission report, focusing on various insights related to the history and outcomes of space missions. The analysis encompassed key metrics, trends over time, and in-epth examinations of mission success, failure, companies involved, rockets utilized, and the contributions of different countries.
Project Objectives:
Project Objectives:
Comprehensive Mission Overview:
Visualize and analyze essential metrics, including the total number of space missions, distribution of mission outcomes, companies involved, and trends over the years.
Top Performances Analysis:
Identify and highlight top-performing entities, such as companies with the most successful missions, and analyze rocket contributions to guide strategic decisions.
Project Tasks:
Project Tasks:
Total Number of Missions:
Calculated and visualized the total number of space missions.
Total Successful Missions:
Calculated and visualized the total number of successful space missions.
Total Failure:
Calculated and visualized the total number of failed space missions.
Total Prelaunch Failure:
Calculated and visualized the total number of space missions experiencing prelaunch failures.
Total Partial Failure:
Calculated and visualized the total number of space missions with partial failures.
Total Number of Companies:
Determined and visualized the total number of companies involved in space missions.
Mission Trend Over the Years:
Analyzed and visualized the trend of space missions over the years.
Most Successful Missions by Company (Top 5):
Identified and presented the top 5 companies with the most successful space missions.
Missions Carried Out by Each Rocket:
Explored and visualized the distribution of missions across different rockets.
Missions by Mission Status:
Provided insights into the distribution of missions based on their status (success, failure, partial failure).
Missions Carried Out by Each Country:
Examined and visualized the distribution of space missions conducted by each country.
Project Dashboards/Visualization
Project Live Analysis Link:
Space Mission Project Report
https://www.linkedin.com/posts/isaac-adewumi-b3827086_dataanalytics-datadriven-quantumanalytics-activity-7148791866115723264-A9U5?utm_source=share&utm_medium=member_ios
My Achievements:
Comprehensive Mission Insights:
Delivered a comprehensive overview of key metrics, including total missions, success rates, failure types, and company involvement.
Trend Analysis:
Conducted a detailed analysis of mission trends over the years, offering insights into the evolution of space exploration.
Top Company Performances:
Identified and highlighted the top-performing companies with the highest number of successful space missions.
Rocket Contribution Analysis:
Explored the contributions of each rocket to space missions, providing clarity on their utilization.
Country-Specific Mission Contributions:
Analyzed and visualized the distribution of space missions carried out by each country.
Recommendations to Management:
Strategic Company Collaborations:
Encourage strategic collaborations between successful companies to enhance overall mission success rates.
R&D Investments:
Suggest increased research and development investments to address prelaunch and partial failure issues.
International Collaboration:
Advocate for international collaboration in space missions, leveraging the expertise of top-performing countries.
Rockets Performance Evaluation:
Evaluate and optimize the utilization of rockets for future missions based on their historical contributions.
Continuous Monitoring and Analysis:
Recommend ongoing monitoring and analysis of mission data to adapt strategies and capitalize on emerging trends.
Page updated
Google Sites
Report abuse