Microsoft BI Certification Training

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

What Will I Learn?

Learn DW concepts including ETL and Multidimensional modelling
Implement end-to-end ETL system using SQL Server Integration Services
Create Cubes and administer them in SSAS
Create multiple types of reports and visualisations using SSRS
Discuss the concepts and need for ad-hoc reports
Integrate various BI tools to build a complete BI solution
Load data using MDX and DAX queries

Overview

Microsoft Business Intelligence (BI) is a suite of products and tools that you can use to monitor, analyse and plan your business by using scorecards, dashboards, management reporting and analytics. Now, more than ever before, organisations need to get the right information to the right people faster. Microsoft BI solutions can help everyone within an organisation to quickly access the timely, relevant and accurate information that drives better decision making and impacts bottom-line.

It’s not hard to understand why Power BI is growing in popularity among businesses seeking better insights, interactive dashboards and rich reporting. Now is the time to leverage the many tools and services available that can help you prepare for a successful Power BI adoption and improve your data insights across the organisation. This course is designed to help you become a certified business intelligence analyst by giving you rich hands-on training on Microsoft’s business intelligence platform.

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 directly delivered to you, and you have 12 months access to the online learning platform from the date you joined the course.  The course is self-paced and you can complete it in stages, revisiting the lessons at any time.

Software or Analytics professionals having background/experience of any RDBMS, ETL, OLAP or reporting tools are the key beneficiaries of this MSBI course.

  • Learners should be over the age of 16, and have a basic understanding of English, ICT and numeracy.
  • A sound educational background

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 BI Certification 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 Analyst– Up to £58k per annum
  • Software Engineer – Up to £71k 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 Data Warehousing and MSBI
Fundamental concepts of Data Warehousing
Concepts of Dimensions, Measures, Metadata, Schemas
Data Marts and Design approaches
Normalization and Denormalization and Schema types
Online Analytical Processing and Transactional Processing concepts
OLAP Cube
Types of Slowly Changing Dimensions
Explain ETL process and various tasks involved in it
Discuss Business Intelligence concepts
How BI works with data-warehouse
Describe MSBI as One stop Solution
2: Introduction to SSIS
Understand the MSBI Architecture, Import and Export wizard
Understand SSIS Architecture
Control Flow & its Components (Tasks, Containers, Precedence Constraints)
Data Flow & its Components (Source and Destination Connections, different types of Transformations)
Scenarios by combining Control Flow and Data Flow components
System Variables and User-defined variables
3: Transformations and Use-Cases
Data Conversion transformation
Multicast transformation
Union all transformation
Conditional Split transformation
Merge and Merge Join transformation
Lookup transformation
Cached Lookup transformation
Foreach loop and use-cases
Advancing Execute SQL Task with Object return type and type of Outputs usage
Bulk-insert task
Archival process using dynamic variables and FST
4: Transactions and Event Handling
Parameters, Event Handling
Transaction Options, CheckPoints, Logging options, Log Provider
Configure Error Output and OnError event
Package Security: Package Protection Levels
5: SSIS (Configuration, Deployment and Scheduling)
Script Component, Package Configurations (5 types)
Debugging & Troubleshooting
Executing packages – DTExec and DTExecUI
Package Deployment
Package Scheduling using SQL Agent
Understand Package Performance Tuning
Learn SSIS Best Practices
Package Performance Tuning
SSIS Best Practices
6: SSAS Cube Design
Introduction to SASS
It’s Architecture
Features of SSAS
Modelling in SSAS
Tabular Model and Multidimensional Model
Data Sources, Data Source Views
Identify the Fact and Dimensions
Designing Dimensions
Dimension Hierarchies
Designing Measure Groups
Attribute Relationships
Storage Modes: MOLAP, ROLAP, HOLAP, Partitions
7: SSAS Deployment and MDX, DAX
SSAS Deployment
Methods of database deployment
Named Calculations and Named queries
Aggregation, KPIs, Actions, Perspectives, Translations
Cube Processing
Different Processing Options
Explain MDX and DAX Queries
Loading Data into DW using SSIS, MDX queries, DAX Queries
Performance Optimization of cube and Dimension, Best Practices
Schedule the Cube processing
8: SSRS Reporting
SSRS Features
Reporting Services Architecture & Lifecycle
Report Parameters and Multi-Valued
Cascaded Parameters
Types of Reports: Parameterized, Linked, Snapshot, Cached, Ad hoc, Clickthrough, Drillthrough, Subreports
Creating Groups, Filters, Expressions Sort and Interactive Sort, Alternate Row Colors, Repeating Row Headers and Column Headers
Describe Mobile report publisher
Exporting Reports to different formats
9: SSRS: Web Portal
Web Portal
Deploying Reports and Data Sources
Securing Access to Reports (Role based Security)
Aspects of security
Data Source Security, Caching Report and Snapshot Report
Report Subscriptions: Standard, Data-Driven
Managing Subscriptions, Ad-Hoc Reporting with Report Builder
Integration of Power BI with SSRS
10: Integration of SSIS, SSAS and SSRS
End to End Business Intelligence Business Scenario involving SSIS, SSAS, SSRS and MDX.
MS BI Best Practices

Students feedback

4.5

Average rating (4)
4.5
5 Star
4 Star
3 Star
2 Star
1 Star
    C B

    Coates Booth

    January 13, 2021
    Hugely helpful

    This is one of the best courses I have taken online. Very well explained and course is updated to reflect the latest PowerBI interface.

    D R

    Dean Robbets

    December 03, 2020
    Very detailed

    Very detailed course covering a lot of topics in the PowerBI universe. Pace was great and explanations easy to understand.

    G C

    Goodwin Cox

    November 13, 2020
    Properly structured

    Everything is properly structured. The course was nice including the pacing, level of details, order of topics and practical examples.

    C R

    Casper Rogers

    October 02, 2020
    Enjoyable course

    I really enjoyed each and every module and understood it to the full. Overall it was one good course.

£.00
WhatsApp chat