Data Science Projects in PakistanData Science Projects in PakistanBuilt a full YouTube analytics dashboard in Google Looker Studio using real channel data from Dark Psychology Archive.
The dashboard tracks 6 KPIs — Views (18,582), Watch Time (51.2 hrs), CTR (4.32%), Likes (1,302), Subscribers Gained (105), and Engagement Rate (10.31%). A monthly trend line reveals the growth curve peaking at 4,266 views in November. Content-type breakdown shows Shorts drive 71% of total views. Top performer: Hoovering at 1,232 views with 8.2% CTR.
Built to help content creators make data-driven decisions on what to post, when, and in what format — without exporting CSVs manually. I Developed an interactive Excel dashboard to analyze sales performance, profitability, and customer behavior using transactional retail data.
The dashboard enables quick insights into regional performance, monthly trends, product profitability, and high-value customers.
Key metrics such as total sales, total profit, total orders, and average discount are highlighted using KPI indicators, while dynamic slicers allow users to filter the analysis by region, customer segment, and product category.
The project demonstrates the ability to transform raw business data into clear and actionable insights using spreadsheet analytics. 
