- 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
Data sets
Step 1: Download the data sets for this exercise
The two excel spreadsheets will download and you will find the documents on the bottom of your screen. Download both sets of documents.