Spreadsheet Controls
3 days|Delivered on request
This Spreadsheet Controls programme gives delegates a working command of DAX and calculated measures and storytelling with data, grounded in established visualisation principles. Organisations invest here because reporting effort scales badly when the underlying model is wrong. Delegates leave able to work confidently with report automation, data quality management and SQL querying in their own organisation.
What delegates leave able to do
- Put report automation on a footing they can defend to a reviewer, measured against established visualisation principles
- Explain data quality management to someone who does not do the work
- Make a decision about SQL querying without waiting for a specialist
- Bring data cleaning and preparation into line with current good practice
What the course covers
- DAX and calculated measures
- Storytelling with data
- Report automation
- Data quality management
- SQL querying
- Data cleaning and preparation
- Data warehouse concepts
Who should attend
- data analysts
- business analysts
- reporting specialists
