SQL for Analysts Auditing and Assurance
3 days|Delivered on request
This programme is written from the assurance side. Delegates learn to test whether report automation and scenario modelling are working as claimed, and how to evidence the conclusion. Assurance work is under scrutiny because most organisations have more dashboards than decisions that depend on them. Delegates leave able to work confidently with SQL querying, data quality management and visual encoding choices in their own organisation.
What delegates leave able to do
- Put SQL querying 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
- Review visual encoding choices and say plainly whether it is working
- Improve DAX and calculated measures within their own organisation
What the course covers
- Report automation
- Scenario modelling
- SQL querying
- Data quality management
- Visual encoding choices
- DAX and calculated measures
- Data modelling
Who should attend
- professionals moving into analytics
- finance professionals building reports
- management information officers
- business analysts
- operations managers using dashboards
