Digital Transformation in Self Service Analytics
3 days|Delivered on request
This programme examines how the practice is shifting, and what delegates should adopt, adapt or ignore. It works through data modelling and SQL querying as they stand today and where they are heading. The shift is worth understanding because reporting effort scales badly when the underlying model is wrong. Delegates leave able to work confidently with data cleaning and preparation, spreadsheet controls and KPI definition in their own organisation.
What delegates leave able to do
- Improve data cleaning and preparation within their own organisation, measured against recognised data governance frameworks
- Take ownership of spreadsheet controls rather than escalating it
- Bring KPI definition into line with current good practice
- Put data warehouse concepts on a footing they can defend to a reviewer
What the course covers
- Data modelling
- SQL querying
- Data cleaning and preparation
- Spreadsheet controls
- KPI definition
- Data warehouse concepts
- Visual encoding choices
Who should attend
- operations managers using dashboards
- business analysts
- reporting specialists
- data analysts
