Self Service Analytics Masterclass
5 days|Delivered on request
This advanced programme assumes delegates already work in the field. It goes past the basics into SQL querying, report automation 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 most organisations have more dashboards than decisions that depend on them. Delegates leave able to work confidently with DAX and calculated measures, visual encoding choices and spreadsheet controls in their own organisation.
What delegates leave able to do
- Improve DAX and calculated measures within their own organisation, measured against dimensional modelling practice
- Bring visual encoding choices into line with current good practice
- Spot where spreadsheet controls is failing before it becomes a finding
- Put data cleaning and preparation on a footing they can defend to a reviewer
What the course covers
- SQL querying
- Report automation
- DAX and calculated measures
- Visual encoding choices
- Spreadsheet controls
- Data cleaning and preparation
- Data warehouse concepts
Who should attend
- operations managers using dashboards
- professionals moving into analytics
- management information officers
- business analysts
- finance professionals building reports
