Date Warehouse Development for Electronics Company
Please find under a summary covering project details and feedback. The innate facts are kept as they are, private information is amended.
A fast induction on the buyer’s organisation
I am the fruit director for a consumer electronics manufacturer. During the engagement with Waypoint, I was the program director for our business intelligence program.
What challenge were you trying to address with Waypoint Consulting?
We were looking to communize our reporting platform. The initial intent was to set up a number of data marks athwart the organisation and communize on the Cognos platform. During our initial engagements with Waypoint, they recommended doing an enterprise data warehouse.
What particular tasks were Waypoint Consulting responsible for?
The aim verity changed excellently a bit. We implemented an enterprise data warehouse over the next few years. This implicated setting up an totally new platform and edifice an totally new database and data warehouse. Waypoint developed it and they also maintain it.
We not only communized the software, but we communized the data standard. It’s a ordinary information standard that enables us to share and maintain careful information athwart the business.
We used real-time reporting in a number of areas, which I ponder is fairly sole. Our business-critical functions rely on this. We can approach information as late as a few minutes old. The method alerts nation almost the information, which we can act on and run reports on.
We mainly used IBM fruits. It was Cognos on the frontend, DataStage as the ETL (Extract, Transform, and Load) engine, and we used Netezza as the backend database.
Was there a dedicated team?
We worked with data standarders, an ETL professional, and a Cognos generalist. They granted expertise almost the administration all the way down to report writing. There were a number of those roles throughout the project, but those were the three first roles that were filled.
How did you come to work with Waypoint Consulting?
They were a leading aspirant when I took the role. It was between three or four companies, and the last determination to stay with Waypoint was based on the condition of nation they granted. They were also very answering to any concerns that we had. It was a good relationship from that standpoint.
How much have you invested in them?
We ‘ve spent separate million dollars.
What is the terminal result of working with Waypoint Consulting?
We began working with them in 2015, and the work is quiet ongoing.
Are there any measureable or plum results?
In general, we came in on time and budget with personal efforts. The platform has been lucky. While that’s not a direct result of Waypoint, they were heavily implicated.
Across the total structure, we last to swell the extend of that platform and it is now very much business-critical. There’s a total lot of business sharing athwart the structure since precedently a lot of it was still.
We set it up very much like a self-service type of platform, which empowered excellently a few nation in the structure to explore the information we had. This resulted in some pretty pivotal capabilities in provisions of our business reporting.
How did Waypoint Consulting accomplish from a project treatment standpoint?
The team varied and the nation varied over time. They were very answering almost finding the right fit for our structure.
We ended up not using a lot of their project treatment behind the initial few months owing we took that on in-house. We were primarily on-website, and there wasn’t much distant work being done.
What is (from your point of view) the key factor to pay observation while intercourse with Waypoint Consulting?
Their answeringness and willingness to work with us to find the right fit was forcible. We have an interesting culture and not just anyone is lucky in our environment. They worked with us over time to find and locate the right nation to fix we would be lucky.
What fronts of their work would you like to get betterd?
They could better the project treatment front of it. They initially tried to do that distantly, but they weren’t answering sufficient. This is why we took that internally. I ponder that’s more owing of the essence of our culture.