This is my final project in Refocus, an online educational platform. Using hypothetical data, the goal of the company in this project is to expand and grow the health tracker smartwatch business to a new location. Excel, SQL, Power BI, and Python were utilized to make a comprehensive data analysis. Data was cleaned and transformed, and a cohesive narrative through visualization tools was made. Key trends were identified, and insights, conclusions, and recommendations were presented.
Skills Acquired
- Cleaning, Calculating, and Visualizing Data Using Excel and SQL
- Creating Pivot Tables in Excel
- Conducting Statistical Analysis Through Excel
- Running SQL Queries to Retrieve Information from Databases
- Processing Data and Creating Dashboards in Power BI
- Using Python Libraries for Data Acquisition, Cleaning, Exploration, Transformation, and Visualization
- Showcasing Analytical Findings and Offering Insights and Recommendations