Leading Advanced Excel Teams
3 days|Delivered on request
This programme is for the person accountable for the work rather than the person doing it. It covers self service analytics and DAX and calculated measures from the position of someone who must review, approve and answer for the output. Managers carry this because analysts are frequently self taught in the tool and untrained in the reasoning, and the accountability does not delegate cleanly. Delegates leave able to work confidently with SQL querying, visual encoding choices and data warehouse concepts in their own organisation.
What delegates leave able to do
- Review SQL querying and say plainly whether it is working, measured against dimensional modelling practice
- Put visual encoding choices on a footing they can defend to a reviewer
- Take ownership of data warehouse concepts rather than escalating it
- Improve dashboard design within their own organisation
What the course covers
- Self service analytics
- DAX and calculated measures
- SQL querying
- Visual encoding choices
- Data warehouse concepts
- Dashboard design
- Storytelling with data
Who should attend
- management information officers
- professionals moving into analytics
- team leaders responsible for KPIs
- reporting specialists
- data analysts
