Phone Dataset Business Case Study

In this case study, I applied real-world data management, SQL querying, and data visualization skills to analyze a comprehensive phone dataset. The goal was to generate actionable business insights and present recommendations through a professional dashboard.

Data Preparation and Loading

I first selected and cleaned a dataset containing information about mobile phones, their specifications, and user ratings. Data cleaning involved handling missing values, standardizing formats, and ensuring relational integrity. I then designed an Entity-Relationship Diagram (ERD) and loaded the cleaned data into a SQL database.

Description
Business Questions and SQL Analysis

Using SQL, I constructed multiple queries to answer critical business questions such as:

Description
Data Visualization and Storytelling

After deriving insights through SQL queries, I built dynamic visualizations using Tableau. These dashboards presented KPIs, brand comparisons, customer satisfaction heatmaps, and predictive trends. Visual storytelling allowed stakeholders to easily understand complex patterns hidden in the data.

Description
Skills Demonstrated
Reflection

This project solidified my ability to manage a full-cycle data analytics project: from dataset selection, cleaning and loading, business question framing, technical analysis, to storytelling and professional presentation. It represents a key foundation for my continued growth as a data scientist.