تفاصيل العمل

bike buyers dashboard I created two copied one from workbook original data to keep original one as reference for checking or rewrite accidently deleted cells and copy from data sheets After I made copy from bike Byers I changed to working-sheet I removed duplicate data from Working-Sheet I Replace the values in Marital Status column each M To Married and S to Single I Replace the values in Gender column each M To Male and F to Female I create custom column from Age column to categorize the age to different categorizing(Adolescent, Middel Age, Old) I replace the value 10+ Miles in Commute Distance column with More than 10 miles I Created three pivot tables in new sheet and named with Pivot Tables and created three charts for each of the three pivot table Copied the three to new sheet name Dashboard and organza it by add title for dashboard, changed color, etc.… Edited charts by add axis, axis titles, chart titles, … Create three slicers for three charts Created Report connection for each slicers

بطاقة العمل

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