PowerBI - Data Analytics and Report Building

Building Datasets and creating easily consumable reports from them
Overview

Microsoft Power BI is a powerful business analytics service that can be used to transform data from multiple sources into interactive, visual reports that can be viewed on any device. With Data Analysis and Business Intelligence being vital to business success, this course will give you the knowledge and tools to create accurate data models upon which you can make critical decisions for your organisation.

Course Code
PBI5DARB
Duration
5 Days
Delivery Style
Classroom
Course Type
Private Only
Max Delegates
12
Available as Nutshell
No

Book your team training at your premises

  • Date
  • Venue
  • Cost
  • More info
Purpose of this 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. Using these data models, delegates will then create interactive reports and dashboards. It will also explore the administrative side of Power BI to enable you to share reports and configure permissions.

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.

You will learn how to
  • Understand fundamental data analysis concepts.
  • Connect to common data sources such as Excel workbooks 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.
  • Implement a consistent theme for reports using templates and best practices.
  • Extend reports with custom visualisations.
  • Create dashboards with report items, drilldown, and navigation.
  • Enable report users to interact with the data using natural language queries.
  • Publish reports and datasets to the Power BI Service online.
  • Manage access to reports to meet business needs.
  • Provide extended reporting and actions using Power BI Alerts.
Benefits for your organisation

Power BI provides live insights throughout your organisation by making your vast amount of data easily consumable. Well-designed reports and dashboards, with a fundamentally well designed data model, can transform the way your staff work, facilitating day-to-day decision making and identifying problem areas rapidly. 

Benefits for you as an individual

Data Analytics and Data Science are some of the fastest-growing roles today. With the tools gained on this course, you can take the data provided by your data team and create concise, interactive reports to be used at all levels within an organisation.

Introduction to Power BI
  • What is Power BI?
  • Power BI within the data analysis toolkit.
  • Introduction to the Power BI Desktop interface.
  • Introduction to the Power BI Service interface.
Data Analysis Concepts
  • Facts, dimensions, and measures.
  • Data layouts – the star schema and the denormalised form.
  • Data types.
  • Relationships and keys.
  • Data models.
  • Naming conventions.
Data Sources
  • Excel workbooks
  • Databases
  • Web content.
Shaping Data
  • Preparing data for analysis.
  • Setting data types.
  • Exclude unnecessary columns.
  • Create calculated columns.
Modelling Data
  • Create and edit relationships.
  • Identify and create measures.
  • Build hierarchies of data.
Data Analysis Expressions (DAX)
  • Time intelligence functions and data tables.
  • __X functions (eg SUMX).
  • Calculate, Filter, All.
  • Variables.
  • Logical operations.
Creating Reports
  • Visualisations.
  • Tables and matrices.
  • Filters.
A Consistent Vision
  • Templates.
  • Layout best practices.
  • Bookmarks and Selections.
  • Themes.
Working with Reports
  • Interactions.
  • Drilldown.
  • Adding report objects – text, buttons etc.
  • Q&A natural language queries.
Extending Reports
  • Standard visualisations.
  • Marketplace.
  • Build your own.
Dashboards
  • Pinning.
  • Navigation.
  • Pin a Q&A.
Publishing and Sharing
  • Powerbi.com.
  • Sharing datasets.
  • Sharing reports.
  • Workspaces and groups.
  • Permissions.
  • Row-level security.
  • Using and creating Content Packs.
  • Managing data refresh.
  • Gateways to on-premise data.
  • Alerts – email and Flow.
Prerequisites

Whilst not essential, exposure to data analysis or manipulation would be highly recommended as this is an intense course. Advanced Excel and SQL users should consider themselves suitable for this course.

Pre-course work required

None.

More about the exam

N/A

About the Lead Trainer

Matt started life at Quanta working in tech dungeon in IT Support & Systems Admin, he still gets dragged into those things now and again but is mostly focused on development work now for the business. This can range from SharePoint to Visual Management to this very website you are reading now!