Case Smart: smarter data management through business intelligence
For big companies, it isn’t always easy to keep track of their data flow. Who needs which information when? And how do employees access that data safely? A streamlined data management and centralised database are key. Smart called on an Ormit Talent business intelligence analyst to get their data organised.
The client: Smart
Smart is a shared enterprise that clusters freelancers and lets them have all the perks of being a regular employee, without losing any of their independence. Think training, work spaces and a stable income.
The assignment: Developing a Power BI dashboard and data warehouse
Initially, the challenge was to develop a Power BI dashboard that would integrate the reports generated by all of Smart’s divisions. By filtering, users would find their data in a heartbeat. Because there was no business intelligence unit in-house, we started by thoroughly analysing Smart’s needs. What data is out there and what do the different departments want to distil from it? Gradually, it became clear that the company didn’t just need a Power BI dashboard, we’d have to set up a data warehouse as well.
Our approach
1
Let’s talk about you
During our intake meeting, we understood that Smart would need a business intelligence analyst who could join the company right after their traineeship. While we’re not lacking in talent that’s ready to go, we do take pride in finding the perfect match at Ormit Talent. To get there, we zoomed in on Smart’s needs and expectations.
2
Meet & greet your datatalent
Wanted: a young data expert with sharp analytic and human skills. Jeremy had already successfully finished two data projects and had completed most of his coaching sessions at Ormit Talent. We set up a first rendez-vous for Jeremy and Smart to meet. It was a hit: Smart agreed to a collaboration and the project was a go.
3
Work in progress
Thanks to his earlier experiences as a data analyst, Jeremy knew exactly where to start. He set up a series of interviews to chart every department’s needs. Based on his analysis, he concluded Smart would need a data warehouse.
4
Data in action
To set up the data warehouse, Jeremy worked in close collaboration with a few BI consultants and a BI developer. Jeremy drew the dimensional model and sketched the ETL process. Because he’d quickly found his place in the team and had a good understanding of what was needed on the data side, he was appointed project manager, too. He became the one to organise weekly meetings and follow up on all the development tickets.
The result: A data warehouse that’s ready to be showcased
When the project came to an end after four months, the data warehouse was still under construction. Smart was happy with how the project had evolved and offered Jeremy a contract. Today, he’s employed with Smart as a business intelligence analyst. The coaching and training he enjoyed at Ormit Talent still come in handy, he says. “I’ll soon be presenting the data warehouse to Smart’s general managers. Ormit Talent’s storytelling training will definitely help. Thanks to the presentation techniques I picked up there, I can easily talk people through complex concepts like a data warehouse, making it both clear and attractive.”
Give your company a data injection with Ormit Talent and ORTEC’s Data Chiefs
Our Data Chiefs are young potentials with a background in data. During a two-year traineeship that involves bootcamps, training and client assignments, we turn them into data specialists with strong human skills. We do this in collaboration with ORTEC, an authority in the field of advanced analytics, IT and business processes.