1. Introducing the Transportation Dataset
2. Loading the Dataset to Power Query and Power Pivot in Excel
3. Writing M Code for Age Group using GPT
4. Fact Table Transformation
5. Using GPT to create Time Group and Utilization Segment
6. Creating a DateTable in Power Query
7. Intro to Power Pivot in Excel
8. Creating Relationships in the Power Pivot
9. PivotTable Overview
10. Write Your Frist Measures in Excel (DAX)
11. Dashboard 01 Overview
12. Important KPIs
13. Dashboard Background Layout
14. Adding the KPI card to the Dashboard
15. Visualizing Time Range
16. Peak time and Off Peak Hour of Operation
17. Using GPT-4 to Prove read charts
18. Yearly Analysis
19. Best Visual for Year, Month and Weekdays
20. Weekday and Average analysis
21. Weekday chart Caption
22. Analyzing Bus Utilization Rate
23. Total Riders base on Moment of Trips
24. Intro to Second Dashboard
25. Create Page Navigation and new Background
26. Writing DAX Measures for Total Revenue
27. Verifying our measure using GPT
28. Total Riders Distribution by Routes
29. Custom Chart for Gender Distribution
30. Custom chart Explained
31. Switching Chart in Excel
32. Riders by Age Group
33. Custom chart with curved chart
34. Formatting Custom Chart
35. Riders by Occupation
36. Extracting the Peak Hour for every Occupations
37. Name all the Pivot Table created
38. Using GPT to write VBA code to Hide and show Object on our Dashboard
39. Connecting and formatting our slicers
40. How to Re Save your Dashboard after using VBA
41. How to create Report in from Dashboard using GPT
42. Use GPT to check if our dashboard follow the Dashboard creation Principles
