Practical SQL for Analysts
3 days|Delivered on request
This is a hands-on programme. Delegates spend most of the time working through data cleaning and preparation and report automation on live scenarios rather than listening to theory about them. The practical emphasis is deliberate: analysts are frequently self taught in the tool and untrained in the reasoning, and reading about the method has repeatedly proved insufficient. Delegates leave able to work confidently with dashboard design, statistical fundamentals and DAX and calculated measures in their own organisation.
What delegates leave able to do
- Put dashboard design on a footing they can defend to a reviewer, measured against dimensional modelling practice
- Improve statistical fundamentals within their own organisation
- Explain DAX and calculated measures to someone who does not do the work
- Bring scenario modelling into line with current good practice
What the course covers
- Data cleaning and preparation
- Report automation
- Dashboard design
- Statistical fundamentals
- DAX and calculated measures
- Scenario modelling
- Data quality management
Who should attend
- data analysts
- management information officers
- business analysts
