Digital Transformation in Spreadsheet Controls
3 days|Delivered on request
This programme examines how the practice is shifting, and what delegates should adopt, adapt or ignore. It works through pivot table analysis and DAX and calculated measures as they stand today and where they are heading. The shift is worth understanding because most organisations have more dashboards than decisions that depend on them. Delegates leave able to work confidently with scenario modelling, SQL querying and data governance in their own organisation.
What delegates leave able to do
- Take ownership of scenario modelling rather than escalating it, measured against recognised data governance frameworks
- Improve SQL querying within their own organisation
- Bring data governance into line with current good practice
- Put report automation on a footing they can defend to a reviewer
What the course covers
- Pivot table analysis
- DAX and calculated measures
- Scenario modelling
- SQL querying
- Data governance
- Report automation
- Data quality management
Who should attend
- data analysts
- reporting specialists
- business analysts
- team leaders responsible for KPIs
