Server Modernization & Proprietary Data Valuation Dashboard
Case Study: A North American firearms and defense manufacturer initially approached Intertech for assistance in upgrading their server’s performance. Their Microsoft SQL Server that was used across the company was slow and causing a drag on company efficiency, making even routine tasks take longer than they should. Once Intertech resolved that problem, the company expanded the project to create a way to provide their team further value and insights from their massive collection of proprietary data.
Featured Aerospace & Defense
Case-Study
SQL Server
SSRS
SSAS
SSIS
Methodology
Hybrid Agile-Waterfall
Additional Services
Legacy Modernizations
Pre-Project Diagnostics
Project
Improve System Performance and Provide Value and Insights From Their Proprietary Data To Include New Sales Dashboard
Project Requirements
The client initially tried an internal server upgrade from Microsoft SQL Server 2002 to 2014, expecting to see significant performance gains. However, those gains didn’t materialize as expected, and so they called in Intertech’s expert consultants to diagnose and suggest remedies for the performance issues.
Result
As a result of the presented and implemented optimizations, the client has seen a dramatic drop in runtime for SQL queries and reports. The upshot is greater employee efficiency, more accessible access to data, and cost savings on storage and computing resources.
In addition, the new sales and forecasting dashboard that went along with the upgrade, now brings the client’s data to life, allowing sales reps, managers, and executives to drill down into sales numbers based on product type and distribution chain. The client can quickly and easily add and modify the products they offer, displaying side-by-side comparisons of budget forecasts versus current sales and allowing the client to immediately pinpoint where the company is performing well and where there are challenges. The benefits in strategic planning and a shortened sales feedback loop allow the client to be more responsive to customers’ needs and capture more revenue from the market.
Overview
After meeting initially with project stakeholders to define the goals for the server optimization, Intertech’s consultants began a suite of diagnostic tests and queries to identify bottlenecks on server performance. Finding multiple opportunities for improvement, from hardware upgrades to query optimization and restructuring data storage methods, Intertech presented optional pathways and, once approved, worked with the client’s internal development and IT teams to provide training and resources for making the necessary changes. Over the course of the initial six-month engagement, Intertech’s recommendations drove a significant improvement in server performance.
Thanks to the success of the server optimization project, the client requested recommendations for further projects to gain value and insights from their proprietary data. As a manufacturer, they work with various end retailers and bulk purchasers to provide retail and specialty products. Intertech consultants recommended a sales management and strategic planning dashboard that would enable real-time, granular sales data, and budget forecasting.
Once reviewed and approved, the client retained Intertech to structure the data and build the sales dashboard using Intertech’s development expertise. Intertech developers took the client’s sales and orders database and created a data warehouse, atop which they built a reporting cube for SQL Server Reporting and Analysis Services. They then made the data available via a dashboard so that stakeholders would have easy access to up-to-the-minute sales information and budget projections.
Development followed a hybrid agile-waterfall approach. Intertech initially pre-defined critical requirements with the client and built and delivered the core product. Over time, the client has requested additional functionality that Intertech has built in a series of agile sprints, becoming a trusted partner.
Intertech has been in business for nearly 30 years. Many of our projects are considered confidential by our clients. For this reason, and out of respect for our customer’s privacy, we do not mention companies by name regarding specific projects, with the clear understanding that the project outlined and presented is actual work Intertech and their consultants have completed successfully.
The Fastest Way To Build Software Is “Right” The First Time!
Understanding your industry is one thing. Understanding the technology you are using is another. When you read studies that tell you that 75% of projects are doomed from the beginning, it has to make you pause before signing your name to the outcome.
Consider letting our proven professionals take a look at your project. They’ve seen what can go wrong and know how to avoid costly errors.
We build custom software from start to finish. We plug into your environment with the proven expertise you need for us to work independently or in co-development. And, we bring the soft-skills that make the task enjoyable, and the experience to leave your team stronger and ready to take over.
We Bring You…
Team-Complete™ Development
Soft-Skills For A Winning Experience
Sometimes the most critical person in the room is the one with a calm voice and the knowledge to select the right words. Bringing a development team together or presenting a clear concept for stakeholders can make all the difference between success or failure. Intertech consultants are at the top of their field. They navigate challenging decisions, guide with a confident voice, and know when to get out of the way.
Intertech takes the worry out of custom software development.
Three Great Reasons To Let Intertech Build Your Software Independently Or In Co-Development With Your Team!
To understand why so many companies rely on Intertech for their software consulting and software education needs, you must understand the importance we place on staying up-to-date with the most current technologies and methodologies.
“When an outside firm asked over 4000 of our customers these questions, we immediately understood why they trusted Intertech!”
Say “Yes” To Intertech!
- Would you use Intertech again? 99.55%
99.55% of customers answered YES!
- Are you happy with Intertech? 99.55%
99.55% of customers answered YES!
- Would you refer Intertech to others? 99.70%
99.70% of customers answered YES!