IT Fundamentals of Data Analytics using Power BI

Who is this course for

IT Technicians, Data Analysts and Business Analysts who need to analyse data using Power BI - the core concepts can also be applied to other BI software.

Purpose of the course

This course will cover the fundamentals of data analytics, enabling delegates to prepare data models for analysis in Power BI using data from multiple sources.

As the course progresses, delegates will delve into more complex data shaping in the Power Query Editor using the M language, and data modelling with Data Analysis Expressions (DAX).

You will learn how to

• Understand fundamental data analysis concepts


• Create and manage connections to data sources, and schedule data refreshes including on-premise data


• Shape data from multiple sources and prepare the data for analysis


• Understand and create data models


• Analyse data using Data Analysis Expressions (DAX) to solve complex calculations


• Use data analysis concepts, functions, and techniques to create reports with visualisations


• Publish reports and datasets to the Power BI Service online


• Create Workspaces


• Manage access to reports to meet business needs

Benefits for you as an individual

Data analytics and data science are among the fastest-growing roles today. As companies become increasingly data-driven, there is a growing demand for professionals who can interpret data to accelerate key business decisions.

Benefits for your organisation

Power BI provides insights across your organisation by making vast amounts of data easily consumable. A well-set-up data model enables report makers to create interactive reports and dashboards that accelerate and improve decision-making.