Artificial Intelligence 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 scenario modelling and spreadsheet controls 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 data modelling, data cleaning and preparation and pivot table analysis in their own organisation.
What delegates leave able to do
- Bring data modelling into line with current good practice, measured against established visualisation principles
- Put data cleaning and preparation on a footing they can defend to a reviewer
- Take ownership of pivot table analysis rather than escalating it
- Spot where visual encoding choices is failing before it becomes a finding
What the course covers
- Scenario modelling
- Spreadsheet controls
- Data modelling
- Data cleaning and preparation
- Pivot table analysis
- Visual encoding choices
- Self service analytics
Who should attend
- business analysts
- management information officers
- finance professionals building reports
- data analysts
