Customer Story: Public Service Agency

Microsoft Consulting Services positions Agency for success with automation

Company Overview:

The Agency provides a range of services to the community including the provision of medical facilities and healthy living campaigns for over five million Australians.

Challenge:

The Agency needed to update the devices that were in use across the organisation and were running both outdated and unsupported operating systems. In order to ensure security updates and technical support would be available when needed, the Agency needed to migrate over 70,000 desktop PCs, and more than 6,000 types of applications, from Windows XP to Windows 7. Given the numbers involved, it was vital that the Agency could minimise manual processes and simplify the overall management and deployment of the new solution.

Solution:

The new solution leveraged Data#3’s partnership with Microsoft Consulting Services, to build a central application SQL data warehouse to collect application information. SQL Server Reporting Services (SSRS) reports were built to manage the migration progress. Data#3 assigned a SQL and BI specialist to work collaboratively with the Agency’s team to understand the current warehouse status and what was needed for the extract, transform, load (ETL) and reporting.

Furthermore, SQL Server optimisation and configuration, along with refinement of the ETL database functions, were undertaken. The data model was enhanced to improve performance, with potential improvements identified by the development of complex queries and reports. A number of additional measures, such as index creation and building a performance optimisation and backup plan, were included to ensure the desired outcome could be achieved.

Outcome:

A stable, well-supported SQL environment has been created, not only to support the immediate project, but to support future development, testing and production activities.

The automated ETL functions delivered by the Data#3 and Microsoft alliance enable fast, up-to-date reporting. Business intelligence reports have been developed to encourage collaboration and sharing between branches of the service, reducing duplication and increasing efficiency.

As a result, the migration rate has been increased from 1000 PCs per week to 9000, so the project will be completed far sooner, and users will be better protected by working on updated machines.

Technology:

  • SQL Server
  • SQL Server Integration Service
  • Data Warehousing
  • Windows 7 Migration

“Increasing the migration rate nine-fold was a great outcome for the customer, saving them a lot of time that can now be better used on other projects and servicing their customers.”
Scott Gosling, National Practice Manager – Microsoft, Data#3 Limited


Tags: Consulting, Microsoft, Microsoft Windows 7, IT Lifecycle Management, Integration, Project Services, Data & Analytics, Data Migration, Migration, Microsoft SQL Server

Featured

Subscribe to our blog

Related

The Here and Now of Asset Management Considerations for COVID-19

As more and more organisations are rapidly moving their workforce to work from home (“WFH”) on a large scale,…

Azure Resource Tagging
Masterclass Episode 1 – Microsoft Azure Resource Tagging

Welcome to Data#3’s five-part series focusing on the detail outlined in our recent blog, which covers our top five…

Blog VPN and VDI
VPN and VDI: Quick solutions for connecting and securing remote workers

Due to changing work patterns from the response to COVID-19 globally, the demand on IT teams is fierce to quickly deliver suitable systems to keep…

Customer Story: St Mary’s College

St Mary’s College Safeguards Staff and Students with Next-Generation Firewall Solution Objective As one of Tasmania’s most respected educators, St…

Hobart’s St Mary’s College Safeguards Staff and Students with Next-Generation Cybersecurity Solution from Data#3

March 19, 2020; Brisbane, Australia: Leading Australian technology services and solutions provider, Data#3, today announced that it has worked with…

Customer Story: An Energy Company

Data#3 Helps to Mitigate Software Licence Compliance Risk with Audit Defence Services Objective After learning about an impending audit of…

Adelaide Festival Centre Azure customer story
Customer Story: Adelaide Festival Centre

Adelaide Festival Centre’s 50% Reduction in Azure Costs Allows More Community Investment Objective Adelaide Festival Centre had little visibility of…

Wesley Mission Queensland Enhances Customer Experience through Digital Transformation with Data#3
Customer Story: Wesley Mission Queensland

Wesley Mission Queensland Introduces Modern Network to Power Digitisation and enhance the customer experience in the Care Sector Objective With…