We are OPEN and delivering training as usual. View our COVID-19 statement.

MCSA: SQL Server 2016 BI(Business Intelligence) Certification

MCSA: SQL Server 2016 BI(Business Intelligence) Certification Course

SQL BI Training Overview:

Certification:

  • Microsoft Certified Solutions Associate(MCSA) SQL 2016 BI(Business Intelligence) Certification

Delivery:

  • SQL MSBI classroom training. Instructor led hands-on classes.

SQL MSBI Certification Exams:

  • 2 Exams, Real Time Simulation, Single and Multiple Choice Questions
  • MCSA: SQL 2016 BI training

SQL MSBI Course Length:

  • 4 Weeks or Fast Track 4 Days

SQL BI Training Includes:

  • Hands-on Training, Lab Exercises, Project work, Unlimited Lab Access, Free Re-training

SQL BI Training Locations:

  • Liverpool Street, London
  • London Bridge, London
  • Moorgate, London

Flexible Starting Dates:

  • SQL BI Training on Weekdays, Weekends and Evenings

Brochure Request



Live Instructor-Led Classes

Virtual Training is the same as Face-to-Face Training

Virtual Classroom is the best option for anyone wishing to get an instructor-led training - while staying in the comfort of their home or office.

Call Us: 0207 256 2268

 

COVID-19 Statement

We are open and delivering training as normal

Monday 30th June 2020

To all our valued students,

We are all experiencing incredibly confusing and unpredictable times. In consideration of the ongoing uncertainty regarding COVID-19, we wish to reassure you that we are taking necessary precautions to protect the health, safety and well-being of our customers, our employees and our partners.

We will continue to operate our business in accordance with government guidelines. We are accepting new registration and delivering on going training as normal.

We understand the importance of our customers feeling safe and comfortable in their homes. For your peace of mind, we are offering a safe and contact free LIVE online tutor led training too.

We are closely monitoring the advice and information provided by the government and commit to updating you if anything changes. Rest assured, our priority remains providing you with the quality training in the safest possible way.

We would also like to take some time to thank our incredible emergency services and NHS staff for their unbelievable and unprecedented support. We give thanks to those working tirelessly to keep us all safe and healthy. For more information, please click here.

As always our customer services team are available to help with any queries on 0207-256-2268 and through our contact us pages.

We wish good health to you, your friends and your family at this time.

Stay safe.

Training Square Team.

Yes we are open for training with a small number of students per class, considering government guidelines, and with social distancing in place.

- Our opening and closing hours are:
Mon to Fri - 10:00 till 17:00
Saturday - 10:00 till 1700

Yes, we have followed the government guidelines with social distancing. We are providing access to hand sanitizer to all our students, providing disposable masks and keeping the place clean and tidy.

Yes, the majority of our courses can be done LIVE online tutor led. You can join the scheduled classes with the tutor online. The online live classes are the same as the scheduled classes and the only difference is, you will be attending from wherever you wish to, as long as you have reliable internet access.

Finance Available

0% Interest

Spread The Cost of Your Training Across 12 Months

Course Fee: £1450

3 months - £290 Upfront and monthly payments of £387

6 months - £290 Upfront and monthly payments of £193

12 months - £290 Upfront and monthly payments of £97

Enquire Now



Time Table

Start Date End Date Session Time Location Learning Type Booking
28-08-2021 MCSA: SQL Server 2016 BI(Business Intelligence) Certification18-09-2021 Saturday 10:00-18:00 Central London Wilson Street , Liverpool Street , EC2M 2SJ -
23-10-2021 MCSA: SQL Server 2016 BI(Business Intelligence) Certification13-11-2021 Saturday 10:00-18:00 Central London Wilson Street , Liverpool Street , EC2M 2SJ -

MCSA: SQL Server 2016 BI(Business Intelligence) Certification Course Description

Get trained in Microsoft Certified Solutions Associate (MCSA) Certification - SQL Server 2016 BI(Business Intelligence) and gain the essential skills needed in all aspects of the Microsoft's premier database system – suitable for all sizes of businesses.

MCSA SQL Server 2016 MSBI will enable you to establish your technical skills required to build a sustainable career in IT. Be equipped with the skills that would facilitate you to demonstrate the ability to provide innovative solutions across multiple technologies to your clients. By achieving MCSA SQL 2016 certification you will quite simply be an expert in database technology and can provide solutions for complex business environments.

Microsoft SQL MSBI has become the most popular, secure, reliable and robust database platform in the IT industry currently. On achieving SQL Server 2016 certification, you will maximise your chances of becoming more employable and more marketable in the current competitive IT job market.

MSBI can perform 1 million commands in just 1 second which makes it the fastest, reliable and robust solution for small to large enterprises. MSBI 2016 also provides higher productivity for DBAs, System Admins and Application Developers. It is also capable to avoid mission critical outages or data loss and the Excellent BI and reporting tools, large scale data warehousing capabilities, make SQL Server 2016 stands out in the market.

Whether you are novice in database technology or a basic user, we have a well structured classroom based, hands-on, tutor led training on MSBI courses in London, delivered by our expert, certified and industry experienced trainers.

We would like to warmly welcome you to our SQL server 2016 course where you would be well equipped with SQL Server industrial skills and eventually be fully prepared for MCSA SQL 2016 MSBI Certification.

MCSA: SQL Server 2016 BI(Business Intelligence) Certification Course Highlight

  • MCSA MSBI EXAM 70-767 - Implementing a Data Warehouse using SQL (SSIS)
  • MCSA MSBI EXAM 70-768 - Developing SQL Data Models (SSAS)
  •  
  • MCSA: SQL Server 2016 BI Certification
 

MCSA: SQL Server 2016 BI(Business Intelligence) Certification

MCSA SQL Exam: Implementing a Data Warehouse using SQL (SSIS) 70-767

Introduction to Data warehouse SQL Server

  • Overview of Data Warehousing
  • Data warehouse concepts and architecture consideration
  • Data Warehouse Solution
  • Exploring data sources, ETL Process and Data warehouse

Planning Data Warehouse Infrastructure

  • Hardware Considerations for data warehouse infrastructure
  • Planning data warehouse hardware

Designing and Implementing a Data Warehouse

  • Designing and implementing a schema for a data warehouse
  • Designing dimension tables
  • Designing fact tables

Physical Design for a Data Warehouse

  • Implementing a Data Warehouse Schema
  • Implementing a star schema
  • Implementing a snowflake schema
  • Implementing a time dimension table

Columnstore Indexes

  • Introduction to Columnstore Indexes
  • Creating Columnstore Indexes
  • Working with Columnstore Indexes
  • Create a Columnstore index on the FactProductInventory table
  • Create a Columnstore index on the FactInternetSales table
  • Create a memory optimised Columnstore table

Implementing an Azure SQL Data Warehouse

  • Describes Azure SQL Data Warehouses and how to implement them
  • Advantages of Azure SQL Data Warehouse
  • Implementing an Azure SQL Data Warehouse
  • Developing an Azure SQL Data Warehouse
  • Migrating to an Azure SQ Data Warehouse
  • Copying data with the Azure data factory
  • Create an Azure SQL data warehouse database
  • Migrate to an Azure SQL Data warehouse database
  • Copy data with the Azure data factory

Creating an ETL Solution

  • Introduction to ETL with SSIS
  • Exploring Source Data
  • Implementing Data Flow
  • Data Flow in an SSIS Package
  • Exploring source data
  • Transferring data by using a data row task
  • Using transformation components in a data row

Implementing Control Flow in an SSIS Package

  • Introduction to Control Flow
  • Creating Dynamic Packages
  • Using Containers
  • Managing consistency
  • Using tasks and precedence in a control flow
  • Using variables and parameters
  • Using transactions
  • Using checkpoints

Debugging and Troubleshooting SSIS Packages

  • Debugging an SSIS Package
  • Logging SSIS Package Events
  • Handling Errors in an SSIS Package
  • Troubleshooting an SSIS Package
  • Debugging an SSIS package
  • Logging SSIS package execution
  • Implementing an event handler
  • Handling errors in data flow

Implementing a Data Extraction Solution/Incremental ETL

  • Introduction to Incremental ETL
  • Extracting Modified Data
  • Loading modified data
  • Temporal Tables
  • Using a date time column to incrementally extract data
  • Using change data capture + Using the CDC control task
  • Using change tracking + Loading data from CDC output tables
  • Using a lookup transformation to insert or update dimension data
  • Implementing a slowly changing dimension
  • Using the merge statement

Enforcing Data Quality

  • Introduction to Data Quality
  • Using Data Quality Services to Cleanse Data
  • Using Data Quality Services to Match Data
  • Cleansing Data + De-duplicating Data
  • Creating a DQS knowledge base
  • Using a DQS project to cleanse data
  • Using DQS in an SSIS package
  • Creating a matching policy + Using a DS project to match data

Using Master Data Services

  • Introduction to Master Data Services
  • Implementing a Master Data Services Model
  • Hierarchies and collections
  • Creating a Master Data Hub
  • Creating a master data services model
  • Using the master data services add-in for Excel
  • Enforcing business rules
  • Loading data into a model
  • Consuming master data services data

Extending SQL Server Integration Services (SSIS)

  • Using scripting in SSIS
  • Using custom components in SSIS
  • Using a script task

Deploying and Configuring SSIS Packages

  • Overview of SSIS Deployment
  • Deploying SSIS Projects
  • Planning SSIS Package Execution
  • Creating an SSIS catalogue
  • Deploying an SSIS project
  • Creating environments for an SSIS solution
  • Running an SSIS package in SQL server management studio
  • Scheduling SSIS packages with SQL server agent

Consuming Data in a Data Warehouse

  • Introduction to Business Intelligence
  • An Introduction to Data Analysis
  • Introduction to reporting
  • Analysing Data with Azure SQL Data Warehouse
  • Business Intelligence Tools
  • Exploring a reporting services report
  • Exploring a PowerPivot workbook
  • Exploring a power view report

MCSA BI Exam 70-768 - Developing SQL Data Models (SSAS)

Introduction to Business Intelligence and Data Modelling

  • Introduction to Business Intelligence
  • The Microsoft business intelligence platform
  • Exploring a Data Warehouse
  • Exploring a data model

Creating Multidimensional Databases

  • Introduction to Multidimensional Analysis
  • Creating Data Sources and Data Source Views
  • Creating a Cube
  • Overview of Cube Security
  • Configure SSAS
  • Monitoring SSAS
  • Creating a multidimensional database
  • Creating a Data Source
  • Creating and Modifying a data Source View
  • Creating and Modifying a Cube

Working with Cubes and Dimensions

  • Configuring Dimensions
  • Defining Attribute Hierarchies
  • Sorting and Grouping Attributes
  • Slowly Changing Dimensions
  • Cubes and Dimensions
  • Configuring Dimensions
  • Defining Relationships and Hierarchies
  • Sorting and Grouping Dimension Attributes

Working with Measures and Measure Groups

  • Working with Measures
  • Working with Measure Groups
  • Configuring Measures
  • Defining Dimension Usage and Relationships
  • Configuring Measure Group Storage

Introduction to MDX

  • MDX fundamentals
  • Adding Calculations to a Cube
  • Using MDX to Query a Cube
  • Querying a cube using MDX
  • Creating a Calculated Member

Customizing Cube Functionality

  • Introduction to Business Intelligence
  • The Implementing Key Performance Indicators
  • Implementing Actions
  • Implementing Perspectives
  • Implementing Translations
  • Customizing a Cube
  • Implementing a KPI
  • Implementing an action
  • Implementing a perspective
  • Implementing a translation

Implementing a Tabular Data Model by Using Analysis Services

  • Introduction to Tabular Data Models
  • Creating a Tabular Data Model
  • Using an Analysis Services Tabular Data Model in an Enterprise BI Solution
  • Creating an Analysis Services Tabular Data Model
  • Configure Relationships and Attributes
  • Configuring Data Model for an Enterprise BI Solution

Introduction to Data Analysis Expression (DAX)

  • DAX Fundamentals
  • Using DAX to Create Calculated Columns and Measures in a Tabular Data Model

Creating Calculated Columns and Measures by using DAX

  • Creating Calculated Columns
  • Creating Measures
  • Creating a KPI
  • Creating a Parent - Child Hierarchy

Performing Predictive Analysis with Data Mining

  • Overview of Data Mining
  • Creating a Custom Data Mining Solution
  • Validating a Data Mining Model
  • Connecting to and Consuming a Data-Mining Model
  • Using the Data Mining add-in for Excel
  • Creating a Data Mining Structure and Model
  • Exploring Data Mining Models
  • Validating Data Mining Models
  • Consuming a Data Mining Model
  • Using the Excel Data Mining add-in

Price Info: £1450

  • Hands-on Tutor Led Training
  • Classroom Based Practical Training
  • Unlimited Practice Lab Access
  • Small Size Class and Interactive Sessions
  • Lab Exercises
  • Mock Exam
  • WiFi Internet
  • Refreshments
  • Completion Certificate
  • Free Re-training
  • Cost is calculated at 70 percent Tuition Vatable and 30 percent Training Book(s) with 0 rated Vat

 

 

 

 

 

Package Offer: Great Savings!!!

Professional Package

£4200Saving £550

Request Info 0207 256 2268
Package Includes
MCSA SQL Server 2012 - £1250
+
Oracle 11g OCP - £3500

Total Price £4750

Offer Price £4200

Saving £550

MOST
POPULR

Career Package

£4000Saving £750

Request Info 0207 256 2268
Package Includes
MCSA SQL Server 2012 - £1250
+
MCSE SQL Server 2012 - £3000 +
MCSE Server 2012 - £1750

Total Price £4750

Offer Price £4000

Saving £750

Specialised Package

£2700Saving £300

Request Info 0207 256 2268
Package Includes
MCSA SQL Server 2012 - £1250
+
MCSE Server 2012 - £1750

Total Price £3000

Offer Price £2700

Saving £300

Trustpilot Training Square Review

The following reviews were taken at the end of the course and are 100% verifiable


Kolade

Tutor takes his time to explain and uses various examples to clarify a point.

Trainer:

Facilities:

Recommend friends and families? Yes

Consider future courses with us? Yes


Steven

Tutor has extensive knowledge of the subject and was very helpful

Trainer:

Facilities:

Recommend friends and families? Yes

Consider future courses with us? Yes


Mark

Tutor was very good at explaining concepts and applying real world examples…

Trainer:

Facilities:

Recommend friends and families? Yes

Consider future courses with us? Yes


Lee

Tutor was very knowledgeable and answered all questions

Trainer:

Facilities:

Recommend friends and families? Yes

Consider future courses with us? Yes


Ali

Tutor was very helpful and professional.

Trainer:

Facilities:

Recommend friends and families? Yes

Consider future courses with us? Yes




Recently Trained Customers

"Your success is our goal"