8 months ago, I didn't know what a JOIN was.
Today, I just completed a full end-to-end analytics project on Samsung's Global Sales ā 52 countries, 4 years, 15,500 transactions.
Here's what the journey looked like š
āāāāāāāāāāāāāāāāāāāāā
š· The Problem
āāāāāāāāāāāāāāāāāāāāā
Raw data. 15,500 rows. 28 columns. No structure. No story.
Just numbers sitting in a CSV file ā doing nothing.
My job? Turn it into decisions.
āāāāāāāāāāāāāāāāāāāāā
š¢ļø Step 1 ā MySQL (The Foundation)
āāāāāāāāāāāāāāāāāāāāā
I built the entire database from scratch.
Schema design ā data import ā indexes ā validation.
Then I ran 7 analytical blocks to extract real insights:
ā Which category generates the most revenue? (Smart TV ā $5.6M)
ā Which region dominates globally? (Europe ā $7.9M)
ā Which product has the highest return rate? (Galaxy Z ā 10.87%)
ā Does 5G actually command a price premium? (Yes ā $130 higher avg price)
ā Who are the most valuable customers? (Government segment ā $4.7M)
SQL didn't just query data. It told a story.
āāāāāāāāāāāāāāāāāāāāā
š Step 2 ā Power BI (The Story)
āāāāāāāāāāāāāāāāāāāāā
Dark theme. Samsung Blue hashtag#1428A0 (https://www.linkedin.com/search/results/all/?keywords=%231428a0&origin=HASH_TAG_FROM_FEED). 3 pages.
š£š®š“š² š ā Executive Overview
KPIs + Global Map + Quarterly Trend + Channel Split
š£š®š“š² š® ā Customer & Product Analysis
Segments + Age Groups + Payment Methods + 5G vs Non-5G
š£š®š“š² šÆ ā Return & Performance
Return rates + Region Matrix + Revenue Impact
One dashboard. Every answer a business needs.
āāāāāāāāāāāāāāāāāāāāā
š” Key Findings
āāāāāāāāāāāāāāāāāāāāā
š° Total Revenue ā $22.91M across 4 years
šŗ Top Category ā Smart TV ($5.6M)
š Top Region ā Europe ($7.9M)
š Top Country ā Greece ($551K)
š Highest Returns ā Galaxy Z (10.87%)
š¶ 5G Premium ā $130 higher avg price vs Non-5G
š¤ Top Segment ā Government ($4.7M)
āāāāāāāāāāāāāāāāāāāāā
Full project ā SQL queries, Power BI file, dataset ā link in comments š
If this helped you or gave you an idea for your own project, drop a š„ below.
And if you're also on this data journey ā let's connect.
hashtag#DataAnalytics (https://www.linkedin.com/search/results/all/?keywords=%23dataanalytics&origin=HASH_TAG_FROM_FEED) hashtag#PowerBI (https://www.linkedin.com/search/results/all/?keywords=%23powerbi&origin=HASH_TAG_FROM_FEED) hashtag#MySQL (https://www.linkedin.com/search/results/all/?keywords=%23mysql&origin=HASH_TAG_FROM_FEED) hashtag#Samsung (https://www.linkedin.com/search/results/all/?keywords=%23samsung&origin=HASH_TAG_FROM_FEED) hashtag#DataVisualization (https://www.linkedin.com/search/results/all/?keywords=%23datavisualization&origin=HASH_TAG_FROM_FEED) hashtag#PortfolioProject (https://www.linkedin.com/search/results/all/?keywords=%23portfolioproject&origin=HASH_TAG_FROM_FEED) hashtag#SQL (https://www.linkedin.com/search/results/all/?keywords=%23sql&origin=HASH_TAG_FROM_FEED) hashtag#BusinessIntelligence (https://www.linkedin.com/search/results/all/?keywords=%23businessintelligence&origin=HASH_TAG_FROM_FEED) hashtag#DataAnalyst (https://www.linkedin.com/search/results/all/?keywords=%23dataanalyst&origin=HASH_TAG_FROM_FEED)
1
18
Satyam Sharma ā Data Analyst Portfolio
1
0