Microsoft BI Certification Training
Access Duration - 365 Days
4.5( 4 REVIEWS )
113 STUDENTS
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 : 10053842Course 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 | |||
Coates Booth
This is one of the best courses I have taken online. Very well explained and course is updated to reflect the latest PowerBI interface.
Dean Robbets
Very detailed course covering a lot of topics in the PowerBI universe. Pace was great and explanations easy to understand.
Goodwin Cox
Everything is properly structured. The course was nice including the pacing, level of details, order of topics and practical examples.
Casper Rogers
I really enjoyed each and every module and understood it to the full. Overall it was one good course.