- 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
Financial analysis
Financial sustainability
Financial sustainability of municipalities are one of the key topics under discussion as South Africa is battling the sustainability of the electricity network, and the future of other public entities like SAA. It is thus important to look at the current financial affairs of Drakenstein when the dashboard is designed.
Process objectives versus control objectives versus KPA’s
Prev

