gnlonline-blog

[gnlonline-blog]

One of the London borough councils has an ambitious digital customer transformation programme. The council sought GNL’s help in developing a fully-responsive UI for their website, resolving issues with their older website, and migrating the website to Sitecore. GNL not only resolved these issues and redesigned the website, but brought in fresh ideas to the project by reducing build time, improving accessibility, ensuring secure data transfer, and ensuring that the code was readable and easy to maintain. The new design helps customers access the services easily.

[gnlonline-blog]

GNL helps to keep major international company (£30bn turnover) ahead of their competitors.

BI Development:

At GNL we are asked to solve a wide range of problems for our clients. Working closely with them we identify the problem, apply the solution and allow our clients to move forward to achieve their goals safe in the knowledge that we at GNL are always there to support them.

Project overview

Our client, a large manufacturer, wanted GNL to help them enhance the support they provided to all the business lines in their organisation. The Business Services group, whose primary responsibility was to provide reports, dashboards, and KPIs had issues with reports being generated slowly, data queries not being optimised, and inefficient SQL queries and stored procedures. Key decisions such as product strategy, marketing strategy, company strategy, and so on, which were based on these reports, were delayed. This, in turn, resulted in the products not reaching the market on time. The client wanted GNL’s expertise in BI and SQL to help them resolve the issues with their deliverables.

Company overview

The client is a multinational manufacturing company specialising in products for healthcare, electronics, safety, and so on. They have a strong focus on innovation. The client has markets in more than 200 countries and has global sales of $30bn.

Challenges

The current SQL scripts used for ETL did not follow industry standards. The data query was not optimised for speed and performance.

Solution

GNL’s consultant analysed the scripts to identify gaps and areas for improvement. The consultant followed best practices of the industry to optimise the SQL queries using indexing strategies and query optimization techniques. The consultant enhanced the performance of queries by removing unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary. The reports now ran faster.

Result

Through GNL’s efforts, experience, and expertise, the client was able to generate reports more efficiently using the optimised SQL scripts. Key stakeholders could access reports quickly and make crucial decisions sooner, thus decreasing time to market for the products.

If you would like to know more about how we can help you – then please contact me. Call me on 0845 519 2204 or Mail Us At  services@gnlonline.com. Visit http://www.gnlonline.com/