reed.co.uk Courses

Header

Microsoft Power BI for End Users

Online class with electronic courseware and tutor support


Combined Knowledge Limited

Summary

Price
£1,170 inc VAT
Or £97.50/mo. for 12 months... Read more
Study method
Online with live classes
Duration
2 days, Full-time
Qualification
No formal qualification
Additional info
  • Tutor is available to students
  • Certificate of completion available and is included in the price

Add to basket or enquire

Overview

Classes Available:

10th December 2020

This course delivers an instructor-led breakdown of Microsoft Power BI. Students will be taught how to design reports that will work with a variety of data sources. Power BI lends something to everyone from beginners who wish to leverage existing data sources to build engaging dashboards right up to knowledgeable users who may query data sources and construct data models to fuel business reports. We will take users through a selection of well-crafted lessons to help them build new reporting capabilities for their business.

Course media

Resources

  • Microsoft Power BI for End Users - download

Description

Module 1: An introduction to Power BI

  • What is business intelligence? Introducing Power BI
  • Power BI tools and services
  • Case studies
  • Data stories
  • Support and information

Module 2: Requirements gathering

  • Welcome to House Rules Board Games Beginning a Power BI project
  • Grain statements
  • Data discovery
  • Refining information Modelling data
  • Building reports
  • Creating dashboards
  • Choosing workspaces
  • Create and share a report in Power BI

Module 3: Extract, transform and load data

  • Creating a project with Power BI desktop
  • What is a PBIX file?
  • Connecting to data sources Managing data connections Refine data with the query editor
  • Applied steps
  • M code language Designing your query
  • Choose columns; Rename columns; Moving columns; Formatting columns; Replacing values; Expand related columns; Star schemas
  • Mere columns
  • Custom and conditional columns

Module 4: Creating a data model

  • Understanding relationships Cardinality
  • Cross filter direction
  • Hiding tables and columns Formatting columns
  • Introducing DAX
  • Designing calculated columns Creating measures
  • Adding lookup tables
  • Structuring data with dimensional hierarchies
  • Roles and row level security

Module 5: Designing reports

  • Adding pages and navigation buttons Using shapes, text and images Creating a theme
  • Adding visualisations
  • Using filters and slicers Adding drill throughs Adding custom visualisations Configure phone layouts Report tips

Module 6: Using workspaces and dashboards

  • Topics Covered
  • Power BI licensing My workspaces
  • App workspaces
  • Premium capacity workspaces Publishing a project
  • Parallels with Microsoft Excel
  • Publishers and viewers
  • Reconnecting with data sources
  • Scheduling the data refresh frequency
  • Introducing the on-premises data gateway
  • Assigning security roles
  • Creating and populating dashboards
  • Customising dashboard tiles
  • Creating tiles using Q&A and quick insights
  • Creating a mobile dashboard Sharing reports and dashboards Publishing apps in a workspace Publishing content to websites

Who is this course for?

This course is for students that are looking to learn how to use the range of Microsoft Power BI tools to refine and model their data into a visual and interactive format. Students considering adopting this course are not required to have any prerequisite knowledge of Power BI or experience working on data modelling related tasks.

Requirements

Delegates should have some exposure to a Windows operating system and Microsoft Office.

Career path

IT Service Developer, Business Analyst, Reporting Specialist, Data Modeller

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Reviews

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

Price history

Like any other product, a course price can vary over time, due to demand, seasonality or promotional campaigns run by the course provider.
This graph will help you measure the value of the course over time.

|

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