- to transform and place into one storage all the business information gathered from a variety of data sources the company was used to work with. The sources were the following:
An IT provider is expected to be digital by default. But it’s impossible to become digital once and for all. The best thing you can do is to keep up with a rapidly changing world by constantly developing new solutions and improving the existing ones.
Our customer’s company was growing very fast (+30% annually) and their methods of data management and analysis were getting outdated and were no longer meeting their needs. The heads of the company felt that they did not possess the entire information about the company’s state which made the management and coordination more difficult. Such a situation could slow down the company’s growth.
The management team was really fragmented in terms of understanding the current business state. Lack of up-to-date information entailed the inability to make qualitative decisions. The company’s managers needed valuable insights on how the business was functioning, what was perfectly working, and what had to be improved. It meant quick access to real-time metrics about various aspects of the company’s state and life. It included but was not limited to project metrics, engineering power (e.g. seniority levels, the number of the developers on projects, bench status if there was any), the company’s money flow, various kinds of sales order statistics, etc.
Our customer understood that Business Intelligence is not just about using technology to bring people and information together, it’s about flexible experimentation at a rapid pace and fast decisions.
Using Power BI and cloud technologies, we’ve scaled them according to the customer’s needs. The relevant data is collected from sources, such as Jira Atlassian, Service Desk Atlassian, Confluence Atlassian, HQuickBooks, Zoho Recruit, ZOHO CRM, Closeweek, Google Sheets. Some part of this data goes straight to datasets, the other – to Azure Data Lake Storage, where all the actions described by a particular model are performed. After that, the information is presented in the dashboards. We’ve created 14 of them, which is not the final number, as, according to particular needs, the dashboards can be scaled up and down, grouped, and some derivatives can be added. Each dashboard represents an interactive analytical system and creates dozens of coherent reports with a variety of visualizations.
Our solution unifies real-time data from many sources and provides interactive, immersive dashboards for all the departments of the company: Finance, HR, Recruiting, Sales Management, Project Management, Development Units, BackOffice. Employees can easily integrate data, transform it into rich visualizations and reports, and then share those reports with stakeholders.
With this BI solution, individual employees have self-service access to intelligence that they can slice and dice in whatever ways are most helpful to them. They’ve also got an easy way to view and share their insights through interactive visualizations. It’s become possible to automate a lot of the preparation and reporting.
We have provided the decision-makers with all the metrics they need – gathered in one place – to do their job more efficiently and not have to wrangle the data to get the answers. The company’s stakeholders, managers, and decision-makers have got an opportunity to evaluate the current state of their business in a quick and reliable way.
The company got several levels of just-in-time analytics:
Each Unit got their own benefits of BI introduction into business processes.
1 / young sales managers were mentored by the experienced ones in customly defined complicated spheres;
2 / special sales courses were offered to some managers.
These measures allowed us to increase sales by 9,6% in the next 6 months.
Human Resources department: :