Digital Transformation in SQL for Analysts
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 quality management and KPI definition as they stand today and where they are heading. The shift is worth understanding because analysts are frequently self taught in the tool and untrained in the reasoning. Delegates leave able to work confidently with SQL querying, pivot table analysis and DAX and calculated measures in their own organisation.
What delegates leave able to do
- Review SQL querying and say plainly whether it is working, measured against dimensional modelling practice
- Make a decision about pivot table analysis without waiting for a specialist
- Improve DAX and calculated measures within their own organisation
- Put spreadsheet controls on a footing they can defend to a reviewer
What the course covers
- Data quality management
- KPI definition
- SQL querying
- Pivot table analysis
- DAX and calculated measures
- Spreadsheet controls
- Statistical fundamentals
Who should attend
- reporting specialists
- management information officers
- finance professionals building reports
- professionals moving into analytics
