+44 (0) 2080 049141info@londonittraining.co.uk

LONDON IT TRAINING

Find your next course

Explore our training courses by subject, skill or certification.

All courses

Classroom · Live online · Training for teamsFind the right course for your next step.
  1. Home
  2. »
  3. Microsoft Business Intelligence with SQL Server
Instructor-led training
Microsoft Business Intelligence with SQL Server Training in London and Live Online

Microsoft Business Intelligence with SQL Server

Build a Microsoft BI workflow using SQL Server integration and analytical modelling tools, with current reporting options. Practise data preparation, semantic models and controlled report delivery.

Request Course Information
Price:
Price on request

Contact us for current fees, dates and exam arrangements.

Intermediate

SQL querying skills and an understanding of relational databases and reporting requirements.

Contact us for duration to complete
Available online
& in class

Select your preferred method

Course overview
Course dates
  • In Classroom
  • Live Virtual
  • 1 - 1 Training
  • Corporate Training
  • Onsite Training
Introduction
Build a Microsoft BI workflow using SQL Server integration and analytical modelling tools, with current reporting options. Practise data preparation, semantic models and controlled report delivery.


This instructor-led course combines clear explanations with guided exercises and practical scenarios. Work through examples relevant to the subject, review alternative approaches and practise checking your results rather than relying on a demonstration alone.
You will develop a structured approach to implementation, troubleshooting and documentation. The trainer can adapt examples to the agreed learning needs and available training environment. Confirm the course duration, software or lab requirements, delivery arrangements and fees with London IT Training before booking.
This is professional development training. It does not automatically award a third-party vendor certification.
What the course covers
Flexible Ways to Learn

Study your way with flexible learning options designed to fit around your schedule.

Small Groups

With small groups of students, our instructors can work closely with each student

Flexible Class Schedules

Our class schedules are flexible on weekdays, weekend or evening to suit your schedule.

Experienced Instructors

Our instructors follow a modified and personalised approach to engage students during class

Hi-Tech lab Facilities

Lab arrangements vary by course. Confirm access and equipment requirements before booking.

Prerequisites
What you’ll gain

Apply bi architecture and tool selection in a practical course exercise.

Apply data warehousing design in a practical course exercise.

Apply integration services workflows in a practical course exercise.

Apply analysis services modelling in a practical course exercise.

Develop skills for your next step
Relevant career pathways
Technical Practitioner:

Apply the course skills to relevant technical tasks.

Technical Consultant:

Assess requirements and recommend practical implementation choices.

Syllabus

Course context and practical foundations
Review the course objectives and relevant concepts. Set up a suitable training environment, identify a realistic example and agree how to validate the results.

Define analytical needs and compare integration, modelling and reporting components. Agree supported software versions and licensing.

Model sample facts and dimensions, define keys and handle historical changes. Validate grain and business definitions.

Develop repeatable extraction and transformation packages. Add validation, logging and controlled error handling.

Build a small analytical model with relationships and measures. Validate calculations and role-based data access.

Create suitable report outputs and discuss Power BI Report Server as the current on-premises reporting direction.

Plan environment configuration, refresh, access and monitoring. Review legacy SSRS migration considerations without presenting retired certifications.

Complete an integrated exercise using sample data or an isolated training environment. Test the result, document decisions and troubleshooting steps, and identify improvements and next learning objectives.

1
2
3
4
5
6
7

FAQs

Who is this course for?
Build a Microsoft BI workflow using SQL Server integration and analytical modelling tools, with current reporting options. Practise data preparation, semantic models and controlled report delivery.

SQL querying skills and an understanding of relational databases and reporting requirements.

BI architecture and tool selection; Data warehousing design; Integration Services workflows; Analysis Services modelling; Paginated and interactive reporting; Deployment and lifecycle management.

No. This is professional development training. It does not automatically award a third-party vendor certification.

Contact London IT Training to discuss classroom, live online and corporate delivery arrangements.

Contact the training team for current duration, available dates, fees and software or lab requirements. Do not assume that licences, materials or examination fees are included.

Need help choosing the right course?

Talk to one of our advisers about dates, delivery options and certification routes. We’ll call you back within 1 working day.

LONDON IT TRAINING

Let’s plan
your next step.

Tell us what you would like to learn.

  • Course guidance
  • Dates and delivery
  • Training for teams

Your details are used to respond to your enquiry. Privacy Policy