Data Workshop for The Data Analyst

From Absolute Beginner level to advanced level ++

01

Introduction

  •  

    The development of Self Service Business Intelligence 

  • Introducing Power BI

  • How does Power BI fit in?

  • Power BI Service, Power BI desktop & Power BI Mobile

  • When to use Power BI Desktop Free versus Pro Signing up to the Power BI online service

  • Which sources of Data can I use?

  • The Microsfoft Data Environment (Azure Synapse & SSAS)

02

Core content

  • The BI Process

  • Data Model & Transformation

  • Power Query UI

  • Data Modelling

  • Power BI Templates & Parameters

  • Advanced Visualisations

  • Extended Topic B – Query Parameters (Dynamic Web Query)

  • Power Query M Formula Language

  • DAX – Contexts & Relationships

  • DAX – The Rules of Evaluation

  • DAX – Evaluation Contexts

  • Row Level Security

  • Advanced Report Features

  • Streaming Data Sources

  • APIs Data Sources

  • DAX Tools & Performance & Optimization

  • Data Project Management

03

HAnds-on exercices

It’s time to power-up your business intelligence skills! Through hands-on exercises, you’ll work on your own data project