Debkalpa Dasđź‘‹
Innovative and enthusiastic CSE Professional. Proficient in data visualization,
manipulation
and analysis. Skilled in problem solving,
creative thinking, leadership and management.
MS Excel Data Analysis
Video Games Sales Dashboard
Overview
In this project, I have created a dashboard which highlights the various video games sales by different companies throughout the course of our modern history. It displays trends, profit and the demand of such video games over 3 decades.
Preprocessing: I have taken the "video_games.csv" dataset. The data has been preprocessed using Tableau Prep. All errors, null values and inconsistencies have been removed and adjusted to as to reduce the error margin.
Design: Using various tools and features provided by MS Excel, I have added action filters, charts and graphs to visualize the data. The right amount of charts and filtering enables and visually appealing display of the data in the dashboard.
Challenges
Every project comes with its challenges. This dashboard was no different. It took some proper inspection and verification to find and deal with the problems.
- Challenge: Inconsistency in the dataset values.
- Solution: Going through the data systematically and then doing selective preprocessing and proper data cleaning to remove null values and other inconsistencies in the dataset.
- Challenge: Proper visualization.
- Solution: Its rather easy to create a visualization, but to make the perfect one requires tests and trials. So trying out the proper charts and graphs which can provide a better and more visually appealing display is very important.
- Challenge:Performance Issues.
- Solution: Excel dashboards often become sluggish when handling large datasets, complex formulas, and excessive conditional formatting. This was improved by using Pivot Tables for data summarization, simplifying complex formulas with helper columns, and limiting conditional formatting to essential cells.
Results/Conclusion:
This dashboard visually depicts the sales of videogames over the last 3 decades providing valuable insight on the trends and demands. It provides specific and targeted visualization of the given data which is crucial for a proper analysis. The combination of graphs, filters, pivot tables and charts make it visually appealing and easy to handle for new and experienced users.
