Advanced Excel Masterclass
5 days|Delivered on request
This advanced programme assumes delegates already work in the field. It goes past the basics into SQL querying, data cleaning and preparation and the judgement calls that sit outside recognised data governance frameworks. At this level the constraint is rarely knowledge. It is judgement under pressure, which matters because most organisations have more dashboards than decisions that depend on them. Delegates leave able to work confidently with data modelling, pivot table analysis and data governance in their own organisation.
What delegates leave able to do
- Spot where data modelling is failing before it becomes a finding, measured against recognised data governance frameworks
- Put pivot table analysis on a footing they can defend to a reviewer
- Review data governance and say plainly whether it is working
- Improve visual encoding choices within their own organisation
What the course covers
- SQL querying
- Data cleaning and preparation
- Data modelling
- Pivot table analysis
- Data governance
- Visual encoding choices
- Statistical fundamentals
Who should attend
- finance professionals building reports
- operations managers using dashboards
- data analysts
- professionals moving into analytics
- business analysts
