- 6 Sections
- 14 Lessons
- 52 Weeks
Expand all sectionsCollapse all sections
- Data analytics7
- 1.1Activate power pivot15 Minutes
- 1.2Data sets5 Minutes
- 1.3Module 1: Converting excel spreadsheets into the database
- 1.4Module 2: Changing Excel into a database – another way
- 1.5Module 3: Build database relationships
- 1.6Module 4: Creating a basic pivot table, graph and slicers
- 1.7Power pivot – Youtube video31 Minutes
- The basics5
- Role players in the design of the dashboard1
- Sources of data - input, process and output phases1
- Documenting the process1
- Multiple financial analysis1
Power pivot – Youtube video
Power Pivot - how to optimize the use
Step 1: The video uses a different data set, but it is instrumental in reminding you about the steps one can take to optimize the use of PowerPivot