reed.co.uk Courses

Header

Power BI Online Training: Introduction to Power BI


G Com Solutions Limited

Summary

Price
£95 inc VAT
Study method
Online, self-paced
Duration
8 Hours
Qualification
No formal qualification
Additional info
  • Certificate of completion available and is included in the price

1 student enquired about/purchased this course

Add to basket or enquire

Overview

Our Microsoft Power BI Introduction will show you how to create compelling visualizations and reports which provide deep insights into your data.

Organizations rely on business intelligence to make better business decisions. Traditionally, BI always referred to Enterprise Business Intelligence. Enterprise BI was always a big deal! Enterprise BI software tools were extremely expensive, technically challenging, and designed for IT specialists.And enterprise BI projects took forever!

Microsoft Power BI offers users true Self-Service BI. Power BI enables business users to interact with corporate information and to extract the reports and intel they need. Power BI allows users to access reports and dashboards using familiar tools and devices.

Self-service BI has never been so user-friendly!

Description

Our Microsoft Power BI Introduction will show you how to create compelling visualizations and reports which provide deep insights into your data.

By the end of the course, you will be confident in using the three main components of Power BI:

  • Power BI Desktop
  • the Power BI Service
  • and Power BI Mobile Apps.

You will know how to connect to a wide variety of data sources, using both Power BI Desktop, and the Power BI Service.

You will be able to use the Query Editor to transform and morph data into the right format for your reporting purposes.

You will be able to perform complex data modelling operations using relationships, calculated columns, measures, and DAX expressions.

You will learn how to share dashboards and reports, with colleagues, business partners and potential clients.

And how to use Power BI’s sophisticated security features to control the exact content your audience is able to view.

In short, this Microsoft Power BI Introduction will equip you with all the skills you need, to start using Power BI with confidence.

COURSE OUTLINE

Getting started

The key components of Power BI; What is Power BI Desktop; The Power BI service; Power BI free vs Power BI Pro; Power BI vs Excel add-ins; Dashboards, reports and datasets

Connecting to software services

Understanding content packs for services; Google Analytics content pack; Salesforce content pack; Microsoft Dynamics CRM content pack

Getting data into Power BI

Connecting to data sources in the Power BI service; Connecting to data sources in Power BI Desktop; Importing excel workbooks; Importing Access databases; Connecting to SQL Server

Cleaning up and transforming data

Using the Query Editor; Creating a query; Understanding query steps; Automatically generated steps; Removing query steps; Modifying query steps; Renaming columns; Reordering and removing columns; Changing data types; The close & apply command

Data modelling

Working in data view; Working in relationship view; Auto-detection of table relationships; Creating table relationships manually; Setting cardinality; Cross filter direction

Using DAX

Creating Calculated columns; Creating measures; Understanding row context; Understanding filter context; The SUMX function; The CALCULATE function; The ALL function; The FILTER function; Using time intelligence functions

Creating reports

Working in report view; Creating tables and key metrics; Working with matrixes; Filtering data with slicers

Creating visualizations

Creating column and bar charts; Creating line and area charts; Creating scatter charts; Treemap visualizations; Using charts as slicers; Using maps with geographical data; Using custom visuals in your reports

Publishing content

Publishing Power BI Desktop reports; Printing and exporting dashboards and reports; Creating Groups in the Power BI service; Creating content Packs; Assigning groups to content packs; Sharing dashboards with your organization; Publishing reports to the web; Embedding a report in a web page

Creating Power BI Mobile Content

Optimising visuals for small viewports; Creating a phone version of a dashboard; Creating phone-optimised reports

Consuming and customizing content

Browsing group content; Using content packs; Creating read-only versions; Using Quick Insights in Power BI; Creating dashboards from your reports; Querying with natural language; Creating custom Q & A suggestions

Refreshing content

Setting up a personal gateway; Customizing dataset refresh settings; Scheduling a refresh frequency; Setting up enterprise gateways; Managing enterprise gateways; Adding and removing data sources, Creating live connections to data

Who is this course for?

This course is suitable for anyone who needs to become familiar with Microsoft's Power BI product, whether for work, study or career.

Requirements

Ability to use a PC and familiarity with general computing concepts and techniques, such as copying and pasting. Students will also be required to download Microsoft Power BI Desktop (free of charge) and to commence a Power BI Pro subscription (free trial available).

Career path

Data analyst. Data scientist. Business intelligence specialist.

Questions and answers

No questions or answers have been posted about this course.

Rating and reviews

There haven't been any reviews for this course yet.

Please sign in to review this course.