Courses Solutions Case Studies & Testimonials News & Insights About Us Contact Us
Public Sector Graduate Training Schemes Learning & Development Corporate & Volume Pricing Custom Learning Paths

Public Sector

We've had the pleasure of working with UK and overseas central and local government departments, including Healthcare (NHS and Foundation Trusts), Defence, Education (Universities and colleges), many of the main Civil Service departments, Emergency Services; also public-owned corporations including the BBC, Bank of England, Ordnance Survey, and regulatory bodies such as Ofgem.

We are registered on Crown Commercial Service’s (CCS) Dynamic Purchasing System (RM6219 Training and Learning) and also with numerous tender portals such as Ariba, Coupa and Delta E-Sourcing.

Read more...

Graduate Training Schemes

Framework Training has a strong track record of providing a solid introduction into the working world for technical graduates across myriad industries. We provide the opportunity to learn and gain valuable hands-on experience in a supportive, friendly and sociable training environment.

Attract & retain the brightest new starters

We know it is vital for our clients to invest in the future of their talented grads; not only to provide them with high-quality, professional training essential for their roles, but to embed them within the organisation’s culture and guide them on the right path to a successful career.

After all, your new hires could well be the next leaders and their creative ideas and unique insights are invaluable to your business.

Read more ...

Learning & Development

Our unique portfolio of high-quality technical courses and training programmes are industry-respected. They’re carefully designed so that delegates can seamlessly apply what they’ve learnt back in the workplace. Our team of domain experts, trainers, and support teams know our field — and all things tech — inside out, and we work hard to keep ourselves up to speed with the latest innovations. 

We’re proud to develop and deliver innovative learning solutions that actually work and make a tangible difference to your people and your business, driving through positive lasting change. Our training courses and programmes are human-centred. Everything we do is underpinned by our commitment to continuous improvement and learning and generally making things much better.

Read more...

Corporate & Volume Pricing

Whether you are looking to book multiple places on public scheduled courses (attended remotely or in our training centres in London) or planning private courses for a team within your organisation, we will be happy to discuss preferential pricing which maximise your staff education budget.

Enquire today about:

  • Training programme pricing models  

  • Multi-course voucher schemes

Read more...

Custom Learning Paths

We understand that your team training needs don't always fit into a "one size fits all" mould, and we're very happy to explore ways in which we can tailor a bespoke learning path to fit your learning needs.

Find out about how we can customise everything from short overviews, intensive workshops, and wider training programmes that give you coverage of the most relevant topics based on what your staff need to excel in their roles.

Read more...

SQL Server BI Training Course | SSRS, SSIS, SSAS

Begin your data journey with Microsoft's enterprise Business Intelligence platform - comprehensive training in SSRS, SSIS, and SSAS, plus Power BI integration

About the course

This course, led by a Microsoft BI specialist, covers essential techniques for building and deploying BI solutions.

Develop practical skills in SQL Server Business Intelligence, from data integration with SSIS to reporting with SSRS and multidimensional and tabular modeling with SSAS.

You'll also learn how to leverage Power BI for enhanced visualisation and explore modern data warehousing concepts with Azure Synapse Analytics.

Online and in-house face-to-face options are available - as part of a wider customised training programme, or as a standalone workshop, on-site at your offices or at one of many flexible meeting spaces in the UK and around the World.

    • Master the core SQL Server BI tools: SSRS, SSIS, and SSAS, to design and deploy end-to-end BI solutions.
    • Develop hands-on expertise in data integration with SSIS, creating ETL packages to extract, transform, and load data from various sources.
    • Design and build interactive reports with SSRS, incorporating advanced visualization techniques to communicate data insights effectively.
    • Create and manage multidimensional data models with SSAS, enabling efficient online analytical processing (OLAP) for data analysis.
    • Utilise DAX to create tabular models
    • Integrate SQL Server BI solutions with Power BI to deliver interactive dashboards and reports for business users.
    • Explore modern data warehousing concepts and learn how to leverage Azure Synapse Analytics for cloud-based BI solutions.
    • Implement best practices for optimising the performance, security, and scalability of SQL Server BI deployments.

  • If you're a database programmer, business analyst, or project manager looking to enhance your skills with SQL Server's Business Intelligence tools, this course is for you.

  • To make the most of this course, you should have some experience with SQL. This could include writing SQL queries to select, update, and present data in SQL Server, Oracle, PostgreSQL, MySQL, or a similar relational database platform.

  • This Business Intelligence course is available for private / custom delivery for your team - as an in-house face-to-face workshop at your location of choice, or as online instructor-led training via MS Teams (or your own preferred platform).

    Get in touch to find out how we can deliver tailored training which focuses on your project requirements and learning goals.

  • Introduction to Modern Business Intelligence

    • What is Business Intelligence in the modern data landscape?

    • On-premises vs. Cloud BI

    • Overview of the Microsoft BI ecosystem (SQL Server, Power BI, Azure Synapse Analytics)

    • Introduction to the Modern Data Warehouse

    SQL Server Reporting Services (SSRS) - Core Reporting

    • Report Designer and Report Builder

    • Creating parameterized and interactive reports

    • Data visualization best practices in SSRS

    • Mobile reporting with SSRS

    • Deploying and managing SSRS reports

    SQL Server Integration Services (SSIS) - Data Integration

    • SSIS Control Flow and Data Flow

    • Extracting, transforming, and loading (ETL) with SSIS

    • Advanced SSIS transformations and data cleansing

    • Error handling, logging, and debugging in SSIS

    • SSIS deployment and package management

    SQL Server Analysis Services (SSAS) - Multidimensional Modeling

    • SSAS Multidimensional model concepts

    • Designing and building data warehouses for SSAS

    • Creating cubes, dimensions, and measure groups

    • MDX for querying SSAS cubes

    • Advanced SSAS features (KPIs, Actions, Perspectives)

    SQL Server Analysis Services (SSAS) - Tabular Modeling

    • Introduction to SSAS Tabular Model

    • Comparing Tabular vs Multidimensional

    • Creating Tabular Models

    • DAX for Tabular Models

    Integrating SQL Server BI with Power BI

    • Connecting SSRS, SSAS to Power BI

    • Using Power BI to visualize SQL Server data

    • Hybrid BI scenarios (on-premises SQL Server with cloud Power BI)

    Modern Data Warehousing with Azure Synapse Analytics

    • Introduction to Azure Synapse Analytics

    • Synapse SQL Pools for Data Warehousing

    • Synapse Data Flows for ETL

    • Integrating SQL Server with Azure Synapse

    Advanced Topics

    • SSAS Partitioning

    • SSAS Aggregations

    • SSIS Performance Tuning

    • SSRS Custom Code

Trusted by

OVO Energy company logo CAPITA company logo BBC logo

Public Courses Dates and Rates

Please get in touch for pricing and availability.

Related courses