reed.co.uk Courses

Header

Analyzing Data with Power BI


Focus-on-Training

Summary

Price
£499 - £649 inc VAT
Study method
Classroom
Duration
Full-time
Qualification
No formal qualification
Additional info
  • Tutor is available to students

3 students enquired about this course

Add to basket or enquire

Enquire now

Location & dates

Location
Address
International House
St Katharines Way
East London
London
E1W1UN
United Kingdom

Overview

Please note: for Attend from Anywhere customers an additional screen is required. The additional screen must have a minimum screen size of 19 inch and minimum resolution of 1280x1024, with the vertical resolution (1024) being the most critical.

The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App.

Target Audience

The course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data

Description

Learning Objectives

After completing this course, students will be able to:

  • Perform Power BI desktop data transformation.
  • Describe Power BI desktop modelling.
  • Create a Power BI desktop visualization.
  • Implement the Power BI service.
  • Describe how to connect to Excel data.
  • Describe how to collaborate with Power BI data.
  • Connect directly to data stores.
  • Describe the Power BI developer API.
  • Describe the Power BI mobile app.

Pre-Requisites

Before attending this course, students must have:

  • Some basic knowledge of data warehouse schema topology (including star and snowflake schemas)
  • Some exposure to basic programming constructs (such as looping and branching)
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
  • Familiarity with Microsoft Office applications – particularly Excel

Course Content

Module 1: Introduction to Self-Service BI Solutions

  • Lesson 1: Introduction to Business Intelligence
  • Lesson 2: Introduction to Data Analysis
  • Lesson 3: Introduction to Data Visualization
  • Lesson 4: Overview of Self-Service BI
  • Lesson 5: Considerations for Self-Service BI
  • Lesson 6: Microsoft Tools for Self-Service BI
  • Lab: Exploring an Enterprise BI Solution

Module 2: Introducing Power BI

  • Lesson 1: Power BI
  • Lesson 2: The Power BI Service
  • Lab: Creating a Power BI Dashboard

Module 3: Power BI Data

  • Lesson 1: Using Excel as a Data Source for Power BI
  • Lesson 2: The Power BI Data Model
  • Lesson 3: Using Databases As a Data Source for Power BI
  • Lesson 4: The Power BI Service
  • Lab: Importing Data into Power BI

Module 4: Shaping and Combining Data

  • Lesson 1: Power BI Desktop Queries
  • Lesson 2: Shaping Data
  • Lesson 3: Combining Data
  • Lab: Shaping and Combining Data

Module 5: Modeling Data

  • Lesson 1: Relationships
  • Lesson 2: DAX Queries
  • Lesson 3: Calculations and Measures
  • Lab: Modeling Data

Module 6: Interactive Data Visualizations

  • Lesson 1: Creating Power BI Reports
  • Lesson 2: Managing a Power BI Solution
  • Lab: Creating a Power BI Report

Module 7: Direct Connectivity

  • Lesson 1: Cloud Data
  • Lesson 2: Connecting to Analysis Services
  • Lab: Direct Connectivity

Module 8: The Developer API

  • Lesson 1: The Developer API
  • Lesson 2: Custom Visuals
  • Lab: Using the Developer API

Module 9: Power BI Mobile

  • Lesson 1: Power BI Mobile Apps
  • Lesson 2: Using the Power BI Mobile App
  • Lesson 3: Power BI Embedded

Regular dates at venues across the UK, enquire now for more details.

London
Aberdeen
Manchester
Glasgow
Bristol
Newbury
Reading
Birmingham
Edinburgh
Southampton
Leeds
Bournemouth
Great Yarmouth
Milton Keynes
Whitehaven
Nottingham

Questions and answers

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

FAQs

What does study method mean?

Study method describes the format in which the course will be delivered. At reed.co.uk courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

What are CPD hours/points?

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on reed.co.uk, many of which can be completed online.

What is a ‘regulated qualification’?

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

What is an ‘endorsed’ course?

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body’s logo if they wish. Certain awarding bodies - such as ABC Awards and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.

Modals

Mobile Navigation