Strategic Advanced Excel
5 days|Delivered on request
Strategic Advanced Excel looks at this work from the level at which it is resourced and defended. The focus is on pivot table analysis, SQL querying and how both connect to what the organisation is actually trying to achieve. This matters at the strategic level because reporting effort scales badly when the underlying model is wrong. Delegates leave able to work confidently with statistical fundamentals, self service analytics and data warehouse concepts in their own organisation.
What delegates leave able to do
- Review statistical fundamentals and say plainly whether it is working, measured against dimensional modelling practice
- Make a decision about self service analytics without waiting for a specialist
- Put data warehouse concepts on a footing they can defend to a reviewer
- Spot where data quality management is failing before it becomes a finding
What the course covers
- Pivot table analysis
- SQL querying
- Statistical fundamentals
- Self service analytics
- Data warehouse concepts
- Data quality management
- Storytelling with data
Who should attend
- business analysts
- reporting specialists
- team leaders responsible for KPIs
- professionals moving into analytics
- finance professionals building reports
