Managing Spreadsheet Controls
3 days|Delivered on request
This programme is for the person accountable for the work rather than the person doing it. It covers SQL querying and data governance from the position of someone who must review, approve and answer for the output. Managers carry this because most organisations have more dashboards than decisions that depend on them, and the accountability does not delegate cleanly. Delegates leave able to work confidently with data warehouse concepts, report automation and storytelling with data in their own organisation.
What delegates leave able to do
- Put data warehouse concepts on a footing they can defend to a reviewer, measured against established visualisation principles
- Review report automation and say plainly whether it is working
- Make a decision about storytelling with data without waiting for a specialist
- Explain visual encoding choices to someone who does not do the work
What the course covers
- SQL querying
- Data governance
- Data warehouse concepts
- Report automation
- Storytelling with data
- Visual encoding choices
- Dashboard design
Who should attend
- reporting specialists
- data analysts
- operations managers using dashboards
- professionals moving into analytics
- business analysts
