Excel Automation and Macros in the Public Sector
3 days|Delivered on request
Excel Automation and Macros in the Public Sector takes the discipline and works it through the constraints of this operating context, including scenario modelling, SQL querying and the compliance obligations that come with it. The sector framing is necessary because reporting effort scales badly when the underlying model is wrong, and generic training rarely survives contact with the local rules. Delegates leave able to work confidently with DAX and calculated measures, data cleaning and preparation and KPI definition in their own organisation.
What delegates leave able to do
- Put DAX and calculated measures on a footing they can defend to a reviewer, measured against dimensional modelling practice
- Bring data cleaning and preparation into line with current good practice
- Improve KPI definition within their own organisation
- Make a decision about data warehouse concepts without waiting for a specialist
What the course covers
- Scenario modelling
- SQL querying
- DAX and calculated measures
- Data cleaning and preparation
- KPI definition
- Data warehouse concepts
- Self service analytics
Who should attend
- operations managers using dashboards
- finance professionals building reports
- data analysts
- team leaders responsible for KPIs
