Mobile Game Data Analysis

Summary

Report submitted for FP20 Analytics ZoomCharts Challenge 18 (August 2024). The report was built with the Mobile Game Analysis dataset and includes ZoomCharts custom Drill Down PRO visuals for Power BI. 

Author's description:
In this project, I conducted an in-depth analysis of the mobile gaming industry, focusing on data from 2008 to 2019. The primary objective was to answer key questions and provide actionable insights into the industry's trends and performance.
The project began with importing raw data from Excel into SQL using Python, allowing for efficient data management and querying. The next step involved extensive data cleaning and transformation to ensure accuracy and relevance.
After preparing the data, I built a robust data model, which served as the foundation for the analysis. I created several measures and calculated columns to meet specific analytical requirements, ensuring the data was fully optimized for visualization.
Finally, I connected the SQL database to Power BI and utilized ZoomCharts to create a dynamic and interactive dashboard. This dashboard provides a comprehensive view of the mobile gaming industry's evolution over the years, offering valuable insights for stakeholders and decision-makers.