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 to enable delegates to prepare data models, ready for analysis in Power BI, using data from multiple sources. It will also explore the administrative side of Power BI to enable you to share reports and configure permissions.

You will learn how to

Understand fundamental data analysis concepts.
Connect to common data sources such as Excel workbooks, CSV and SQL Server databases.
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, Dashboards, and Apps.
Manage access to reports to meet business needs.
 

Benefits for you as an individual

Data Analytics and Data Science are some of the fastest-growing roles today. Companies are increasingly becoming more-and-more data driven and people are needed to interpret this data to accelerate key business decisions.

Benefits for your organisation

Power BI provides insights throughout your organisation by making your vast amount of data easily consumable. A well setup data model will enable Report Makers to easily create interactive reports and dashboards to accelerate and improve decision making.