Data Workshop for The Data Analyst

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)

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

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