848 enable Leicester College to access better learning insights and a more effective approach to business information 

Key facts

Industry sector
Education 

Size
1,333 Employees 
26,000 students 

Solution
Power BI and Azure 

Overview

  • Leicester College needed a more efficient and agile way to provide management information  

  • The existing solution was difficult to change and lacked modern features and set up 

  • Organic growth of management information had introduced inefficiencies in the structure and processing of data 

  • A migration was implemented to use the existing reports to design and build a modern and efficient dashboard in Power BI supported by Azure data services. 

Background

Leicester College provide further education, post16 training and Higher Education qualifications. They support over 26,000 students ranging in age from 14 to 75. They required better insights into the information they collected and needed to improve the way they shared that information. Leicester College chose Microsoft Power BI and the 848 Group to support in this business change. 

The challenge

Leicester College had several dashboards and reports which were built on the legacy business information platform. The team needed to accurately replicate these before the new academic year to facilitate license cost savings and user adoption. 

The solution

848 introduced a Microsoft MVP to help the organisation move from their old solution. The consultant worked with the colleges business information staff to ensure that knowledge was transferred during the process. A mentoring approach was taken to allow the college staff to learn through practice. However, where time was short, the consultant delivered the work to ensure deadlines were achieved. During the engagement the consultant: 

  • Setup Dedicated Power BI database and tables  
  • Wrote and tested SQL  
  • Advised on SQL query practice  
  • Created and tested ETL SSIS packages   
  • Created a Power BI underlying model including relationships 
  • Created Power BI drilldowns, drill-throughs, and hierarchies  
  • Created a Power BI dashboard of visualisations 
  • Advised on security aspects such as row level security 

    The result

    The immediate result is a more efficient and effective management reporting dashboard that is both accurate and timely. In addition, sharing information is simpler and better integrated with the wider Microsoft estate. 

    However, this first phase also laid the foundations for a better approach to business information. The tools and platform will provide the basis for further phases. At the time of writing plans are being agreed to transform the reporting of room utilisation. 

    PLAN

    The Microsoft Certified 848 Consultant took time to understand the client needs and designed a project that would enable better information sharing and insights. 

    BUILD

    848 created a Power BI environment supported by Azure and aligned to the college’s requirements, before mentoring key users in how to utilise the solution. 

    RUN

    The platform has enabled and are continuing to work with the client to transform reporting and more. 

    Let’s Work Together!

    Contact us

    Unit 3,
    Marconi Gate,
    Staffordshire Technology Park,
    Stafford,
    ST18 0FZ
    ///hours.gone.dusty

    03449 848 848

    Find out more

    Privacy Policy

    Make a complaint 

    Remote Support Session

    848 Group Support

    Copyright © 2021 The 848 Group.
    All Rights Reserved. 

    Contact us

    Unit 3,
    Marconi Gate,
    Staffordshire Technology Park,
    Stafford,
    ST18 0FZ
    ///hours.gone.dusty

     

    03449 848 848

    Find out more

    Privacy Policy

    Make a complaint 

    Remote Support Session

    848 Group Support

    Copyright © 2021 The 848 Group.
    All Rights Reserved.