Microsoft Power BI Training

Access Duration - 365 Days
4.5( 4 REVIEWS )
129 STUDENTS
£.00
 

What Will I Learn?

Learn concepts like Data Visualisation and Integration
Learn about Power Pivot, Power View, Power Map etc
Understand DAX and SSBI
Explore Power BI Q&A
Perform Data Binding and Formatting
Master Power BI Embedded and Workspace Collection
Understand and use Data Gateways, Content packs, Power BI Report Server

Overview

Power BI is the collective name for an assortment of cloud-based apps and services that help organisations collate, manage, and analyse data from a variety of sources, through a user-friendly interface. Primarily, Power BI pulls data together and processes it, turning it into intelligible insights, often using visually compelling and easy-to-process charts and graphs. This allows users to generate and share clear and useful snapshots of what’s happening in their business.

Power BI is an incredibly powerful tool for both modeling and visualising data. It has the same base as Power Query so if you have experience with M or DAX you can start making calculated columns, measures, and even shaping your data before you import it without having to learn an entirely new language. This course will also introduce you to Power BI Q&A, which enables you to discover, explore and visualise enterprise data using Natural Language.

Why You Should Consider Taking this Course at Global Edulink?

Global Edulink is a leading online provider for several accrediting bodies, and provides learners the opportunity to take this exclusive course awarded by CPD. At Global Edulink, we give our fullest attention to our learners’ needs and ensure they have the necessary information required to proceed with the Course.  Learners who register will be given excellent support, discounts for future purchases and be eligible for a TOTUM Discount card and Student ID card with amazing offers and access to retail stores, the library, cinemas, gym memberships and their favourite restaurants.

  • Access Duration
  • Who is this Course for?
  • Entry Requirement
  • Method of Assessment
  • Certification
  • Awarding Body
  • Career Path & Progression
The course will be delivered directly to you, and from the date you joined the course you have 12 months of access to the online learning platform. The course is self-paced, and you can complete it in stages at any time.
  • Statisticians and Analysts
  • Business Analysts
  • Business Intelligence Manager
  • Data Scientists
  • Learners should be over the age of 16, and have a basic understanding of English, ICT and numeracy.
  • Basic knowledge in Microsoft Excel and Python
In order to complete the course successfully, learners will take an online assessment. This online test is marked automatically, so you will receive an instant grade and know whether you have passed the course.
Upon the successful completion of the course, you will be awarded the ‘Microsoft Power BI Training’ certificate by CPD.
CPD is an internationally recognised qualification that will make your CV standout and encourage employers to see your motivation at expanding your skills and knowledge in an enterprise.

Once you successfully complete the course, you will gain an accredited qualification that will prove your skills and expertise in the subject matter. With this qualification you can further expand your knowledge by studying related courses on this subject, or you can go onto get a promotion or salary increment in your current job role. Below given are few of the jobs this certificate will help you in, along with the average UK salary per annum according to http://payscale.com/

  • Business Analysts - Up to £50k per annum
  • Business Intelligence Manager - Up to £95k per annum
  • Data Scientists - Up to £90k per annum
  • Statisticians and Analysts - Up to £58k per annum
  • Project Manager - Up to £68k per annum

Key Features

Gain an Accredited UK Qualification
Access to Excellent Quality Study Materials
Personalised Learning Experience
Support by Phone, Live Chat, and Email
Eligible for TOTUM Discount Card
UK Register of Learning Providers Reg No : 10053842

Course Curriculum

1: Introduction to Power BI
Business Intelligence
Self Service Business Intelligence
SSBI Tools
What is Power BI
Why Power BI?
Key Benefits of Power BI
Flow of Power BI
Components of Power BI
Architecture of Power BI
Building Blocks of Power BI
2: Power BI Desktop
Overview of Power BI Desktop
Data Sources in Power BI Desktop
Connecting to a data Sources
Query Editor in Power BI
Clean and Transform your data with Query Editor
Combining Data – Merging and Appending
Cleaning irregularly formatted data
Views in Power BI Desktop
Modelling Data
Manage Data Relationship
Cross Filter Direction
Create calculated tables and measures
Optimizing Data Models
3: Data Analysis Expressions (DAX)
Essential concepts in DAX
Why is DAX important?
DAX Syntax
Calculation Types
DAX Functions
Measures in DAX
DAX Operators
DAX tables and filtering
DAX queries
DAX Parameter Naming
4: Data Visualization
Introduction to visuals in Power BI
Charts in Power BI
Matrixes and tables
Slicers
Map Visualizations
Gauges and Single Number Cards
Modifying colors in charts and visuals
Shapes, text boxes, and images
What Are Custom Visuals?
Page layout and formatting
KPI Visuals
Z-Order
5: Introduction to Power BI Q&A and Data Insight
Introduction to Power BI Service
Dashboard vs. Reports
Quick Insights in Power BI
Creating Dashboards
Configuring a Dashboard
Power BI Q&A
Ask questions of your data with natural language
Power BI embedded
6: Direct Connectivity
ntroduction to using Excel data in Power BI
Exploring live connections to data with Power BI
Connecting directly to SQL Azure, HD Spark, SQL Server Analysis Services/ My SQL
Introduction to Power BI Development API
Import Power View and Power Pivot to Power BI
Power BI Publisher for Excel
Content packs
Introducing Power BI Mobile
7: Power BI Report Servers
Report Server Basics
Web Portal
Paginated Reports
Row level Security
Data Gateways
Scheduled Refresh
Resources (Rest API/ SOAP API’s/ URL Access)
8: Advanced Analytics in Power BI using R & Python
R Integration in Power BI Desktop
R Visuals in Power BI Service
R Powered Custom Visuals
Creating R visuals in Power BI
R Visuals in Power BI Service
R Scripts Security
Creating visual using Python
9: In-class Project

Students feedback

4.5

Average rating (4)
4.5
5 Star
4 Star
3 Star
2 Star
1 Star
    M S

    Montgomery Saunders

    January 12, 2021
    Practical course

    I learned much more than I expected. The course really helped me apply all the learning from the course and helped me understand how to practically work on each element.

    A P

    Anaya Poole

    December 13, 2020
    Superb

    Superb Course with a detail & point to point explanation of all the content of Microsoft Power BI. Thank you for building up a wonderful course like this.

    C S

    Chase Stewart

    November 21, 2020
    Good content

    I liked all of the content and this course provided me to understanding of Microsoft Power BI. It’s helpful concepts that I have learned here.

    A H

    Aya Houghton

    October 17, 2020
    Interesting course

    Very well explained and course is updated to reflect the latest PowerBI interface. Looking forward to some more interesting courses.

£.00
WhatsApp chat