Tyrecheck (known as Tirecheck in the USA) offers a complete professional tyre management system and can equip you with gauges capable of automatically reading and transferring your tyre data to the appropriate database: an ideal service for tyre producers and dealers, garages, or for managing a bus line, a trucking company, even your corporate car fleet.
Tyrecheck customers can be found all over the world and with every customer having its database in the cloud, some reports were overloading source databases and making it difficult to provide joint reporting. The company realized that a Data Warehouse (DWH) redesign was needed and after some preliminary work, Tyrecheck ran into many technical problems which were beyond their scope. At this point they called Adastra.
Adastra was asked to help Tyrecheck with two areas in particular:
Initially, we focused on designing a new DWH to fulfill present requirements and to consolidate all customers and their related data. We customized the DWH on an MS Azure platform for each Tyrecheck customer. MS Azure runs on Microsoft's global datacenter network. The MS Azure cloud platform is geographically redundant and virtually ensures high data availability (SLA 99.9 %). Data are easily and quickly accessible and can be readily and transparently reported. This is a boon for Tyrecheck and its customers as they rely on data security and scalability: services can quickly scale up or down to match planned and unplanned demands.
All customers now have their own tailor-made dashboard to meet their needs and expectations as data are designed just for them. Tyrecheck chose DataZen as its reporting tool and Adastra's consultants competently integrated it into a Tyrecheck web environment incl. single sign-on request.
Although separate databases are not huge (Adastra is capable of working with hundreds of millions, even billions of records and there are only millions of records), the multiple databases of Tyrecheck were located around the globe in different time zones. While servers physically placed in Europe communicate with each other quickly, connecting to a server physically placed in America or Asia takes slightly more time, but the lag is insignificant and fully satisfies Tyrecheck and its customers.
The project was successfully finished and passed on to our customer with the first dashboards designed for Tyrecheck's largest customers. After presenting sample dashboards to its customers, Tyrecheck discussed specific forms of dashboards and designed simplifications to suit each customer better (the less data displayed, the more transparent the dashboard and the better the view in mobile applications). Data are loaded on a day-to-day basis.
Key project benefits are:
Loading procedures from Stage to DWH are managed by metadata and associated parameters (a generated procedure can do this for selected customers). Tyrecheck specializes in using several DWHs (35 today with more to come in the future). Using an Adastra engine to generate ETL procedures would result in an unnecessary conflation of metadata and generated procedures (35 times), so Adastra adapted the engine to do everything once and to manage procedures by parameters.
Average loading time for one customer database is 5 minutes.
How do you create a data warehouse and bank reporting for a newly established bank? Would you like to know? Keep reading! Equa bank is exactly such a case. Not only that, the bank requested some data from an online data warehouse. No small feat considering the data had to keep its consistency and be integrated in the data warehouse to provide an…
Adastra consultants oversaw the migration of 30 detailed commission performance reports from an Oracle data warehouse to a new Enterprise Data Warehouse from Teradata with no business interruption at Vodafone. A complete re-implementation, including business and technical analyses, the specification and acceptance of required data marts, report…
The client is an international company that sells its products worldwide which must report results in an exact and precise way on a monthly basis. Adastra provides the company with a system that guarantees complete overview and accountability of all key indicators, generates annual closing numbers, in addition to forecasts for the end of the…