Advanced SQL for Analysts
5 days|Delivered on request
This advanced programme assumes delegates already work in the field. It goes past the basics into self service analytics, scenario modelling and the judgement calls that sit outside established visualisation principles. At this level the constraint is rarely knowledge. It is judgement under pressure, which matters because most organisations have more dashboards than decisions that depend on them. Delegates leave able to work confidently with DAX and calculated measures, data warehouse concepts and statistical fundamentals in their own organisation.
What delegates leave able to do
- Improve DAX and calculated measures within their own organisation, measured against established visualisation principles
- Bring data warehouse concepts into line with current good practice
- Review statistical fundamentals and say plainly whether it is working
- Put KPI definition on a footing they can defend to a reviewer
What the course covers
- Self service analytics
- Scenario modelling
- DAX and calculated measures
- Data warehouse concepts
- Statistical fundamentals
- KPI definition
- Dashboard design
Who should attend
- finance professionals building reports
- management information officers
- operations managers using dashboards
- data analysts
- team leaders responsible for KPIs
