Report Automation Masterclass
5 days|Delivered on request
This advanced programme assumes delegates already work in the field. It goes past the basics into report automation, DAX and calculated measures and the judgement calls that sit outside dimensional modelling practice. At this level the constraint is rarely knowledge. It is judgement under pressure, which matters because reporting effort scales badly when the underlying model is wrong. Delegates leave able to work confidently with spreadsheet controls, pivot table analysis and data warehouse concepts in their own organisation.
What delegates leave able to do
- Make a decision about spreadsheet controls without waiting for a specialist, measured against dimensional modelling practice
- Review pivot table analysis and say plainly whether it is working
- Bring data warehouse concepts into line with current good practice
- Improve data quality management within their own organisation
What the course covers
- Report automation
- DAX and calculated measures
- Spreadsheet controls
- Pivot table analysis
- Data warehouse concepts
- Data quality management
- Forecasting techniques
Who should attend
- operations managers using dashboards
- data analysts
- professionals moving into analytics
- reporting specialists
- business analysts
