تفاصيل العمل

Built a complete end-to-end data analytics system on the TMDB 5,000 movie dataset, Performed data

cleaning and transformation of complex JSON structures using Power Query, engineering a Star Schema in

Power Query with 14 tables including 5 bridge tables to resolve many-to-many relationships between movies,

actors, directors, genres, and companies then migrated the full model to SQL Server using DAX Studio,

enforcing data integrity through primary and foreign key constraints. I have designed and developed five

interactive dashboards to analyze actor and director performance and uncover genre trends and seasonal

patterns to support business insights.

بطاقة العمل

اسم المستقل
عدد الإعجابات
0
تاريخ الإضافة