SQL for Analysts Reporting and Analytics
3 days|Delivered on request
SQL for Analysts Reporting and Analytics focuses on the measurement layer: what to count, what it means and how to present it. Delegates work through storytelling with data and spreadsheet controls and the reporting built on top of them. The reporting layer matters because reporting effort scales badly when the underlying model is wrong. Delegates leave able to work confidently with DAX and calculated measures, data cleaning and preparation and data warehouse concepts in their own organisation.
What delegates leave able to do
- Spot where DAX and calculated measures is failing before it becomes a finding, measured against dimensional modelling practice
- Improve data cleaning and preparation within their own organisation
- Put data warehouse concepts on a footing they can defend to a reviewer
- Bring self service analytics into line with current good practice
What the course covers
- Storytelling with data
- Spreadsheet controls
- DAX and calculated measures
- Data cleaning and preparation
- Data warehouse concepts
- Self service analytics
- Dashboard design
Who should attend
- business analysts
- team leaders responsible for KPIs
- reporting specialists
- finance professionals building reports
