Power BI, ETL, DWH Development, Data Analytics📊
We create dashboards
Business Intelligence & interactive reporting of any complexity from all IT systems
Dashboards development:
- Develop dashboards based on Power BI, Microstrategy BI, Power BI Report Builder
- Redesign the existing dashboards
- Brush up or redo the dashboards created by other companies and integrators
- Support of the implemented business analytics system
- Data visualization for the analytics systems: Google Analytics, ERP, CRM, API, Excel etc.
- Set up data automatic updates
- Scale the reporting system currently in use, including those developed by other companies
Integration and data management:
- Integrate Power BI with any IT systems
- Power BI and ERP integration
- ERP data structuring for analytics reports
- Build DWH data marts
- Build ETL processes
- Develop OLAP cubes based on SQL Server Analysis Services (SSAS)
- Develop ETL & DWH based on SQL Server Integration Services (SSIS)
- Set up marketing end-to-end traffic analytics
- Visualization of data arrays and Excel-based management reports
- DAX data analysis & development
- Power BI license purchase consulting
Power BI Consulting
- Consult in the sphere of BI system or analytics development and implementation
- Develop the strategy for company data management and data governance
- Employee workshops on working with interactive dashboards
- Employee workshops on how to create dashboards
- Mentor the implementation (if you decided to do it on your own) to speed up the process
3 Languages
- English
- Russian
- Ukrainian
3 Timezones
- EET
- PST
- EST
headquarters
other locations
Bi & Analytics for Mining Company
the project
"Their level is really high, and the prices are good too."
the reviewer
the review
The client submitted this review online.
Please describe your company and your position there.
Big mining holding under NDA, my position executive.
For what projects/services did your company hire Cobit Solutions?
We hired this company for the highly technological business intelligence solution for the holding and branches. Our ERP system needed a reporting solution and personal dashboards for the owners. The order was financial reporting metrics in Power BI and personal reporting dashboards.
How did you select this vendor and what were the deciding factors?
We prefer to get recommendations for the companies for the partnership. We got the good one for Cobit Solution from the people we know.
Describe the project in detail and walk through the stages of the project.
The company asked all the detailed questions about the highly technological business intelligence solution for us, the booking system and sources of data for the BI system. We planned the dashboards for holding owners and branches. They developed the drafts of them to show on the next step. Later they have got the data from our ERP system to calculate and reflect in reporting solutions.
The system was implemented and personal dashboards developed for the owners. The order was ready and personnel studied how to work with reporting dashboards and create new ones.
How many resources from the vendor's team worked with you, and what were their positions?
Well they were Chief Executive Officer, Project Manager and 3 programmers
Can you share any outcomes from the project that demonstrate progress or success?
Highly technological business intelligence solution with a universal interpreter of the logic for calculating the indicators of management reporting articles, which, if the logic changes in ERP, would change the calculation algorithm in Power BI. Holding and branches got reporting solutions and personal dashboards for the owners to see financial reporting metrics.
How effective was the workflow between your team and theirs?
The mutual effectiveness and agreed terms for works were great. We liked the experience and would recommend Cobit Solutions!
What did you find most impressive or unique about this company?
Company has seasoned specialists so that our complicated order was realized fast and on the high level.
Are there any areas for improvement or something they could have done differently?
No, I don’t think so. Their level is really high, and the prices are good too.
Focus
Portfolio
Tehnomart, Alfa Insurance, Dobrobut, Meest China, Helen Marlen Group
Fashion retail analytics dashboards
Today we're sharing a case of implementing Power BI in fashion retail. What's interesting about this case is that we had to start off on a platform created by someone else.
The issues Helen Marlen Group faced:
- The company already had a working BI that extracted data. But it often missed certain pieces of data, so the output needed frequent checks
- In-house implementation didn't quite work. The employee to whom the project was delegated didn't fully master Power BI
- The oursourcing team worked slowly and needed constant observation
Here's a list of what we did:
Implementation
- Develop Power BI reports and dashboards
Dashboard design & development
- Develop dashboards based on Power BI, Microstrategy BI, Power BI Report Builder
- Redesign the existing dashboards
- Brush up or redo the dashboards created by other companies and integrators
- Support of the implemented business analytics system
- Set up data automatic updates
Integration & data management
- Integrate Power BI with any IT systems
- ERP data structuring for analytics reports
- DAX data analysis & development
Consulting
- Consult regarding development and implementation of BI system and analytics
Conclusion
All the planned works have been delivered in time and approved by the customer.
Cobit Solutions currently carries out maintenance and designs new dashboards for Helen Marlen Group.
Power BI in Healthcare Industry
One huge Medical network came to us with three things in mind.
The Medical netword needed:
- more swift info updates
- data visualisation
- precision for budget predictions
We broke this into the following problems:
- daily info updates on what happenes in each doctor's office, how many appointments, what services have been provided, how many rooms are booked etc.
- swift reports on financial data, detailed P&L, income and spendings
- automatic reports on operative business indicators, current and predicted
- comparison between different facilities with decentralized coordination
- all reports visually comprehensive and easy to read
- accurate budget predictions based on P&L
We've addressed all of the above and more.
Here's what we've done:
BI Implementation
- Design of the architecture of a future BI system - Develop a roadmap and plan the stages for Power BI implementation - Develop Power BI reports and dashboards
Dashboards creation & design
- Develop dashboards based on Power BI, Microstrategy BI, Power BI Report Builder - Set up data automatic updates
Integration & data management
- Integrate Power BI with any IT systems - Power BI and ERP integration- - ERP data structuring for analytics reports - Build DWH data marts - Visualization of data arrays and Excel-based management reports - DAX data analysis & development
Consulting
- Consult regarding development and implementation of BI system and analytics - Develop the strategy for company data management and data governance - Employee workshops on working with interactive dashboards - Employee workshops on how to create dashboards
Conclusion
All of the problems the Medical netword came to us with have been addressed and resolved.
We can gladly confirm that our cooperation contitues - we do the maintenance and introduce the changes our client wishes to test out, beyond the initial project.
Power BI in Energy Industry
One of the largest organizations in the power industry has contacted us at Cobit Solutions.
This case is an example of how BI implementation in the power industry can provide the company with competitive advantages.
What did they need?
Donbass Energo was trying to stay ahead of the competition and was willing to see what Power BI could contribute.
Despite the large money turnover in this industry, the energy companies tend to stay conservative. Which means that the ability to enhance technology could potentially give Donbass Energy a huge competitive advantage, but must be carried out with extreme care
What did they get?
- Dashboard with the dynamics of marginal income;
- Understanding of the topicality of their price and volume proposal;
- Info on the distribution of the daily average electrical power generation in Ukraine and the company’s share;
- Understanding of the market growth and decline trends, the power market structure with a breakdown into energy types;
- Control over the condition of generating units in the whole market, see how many units are in emergency operation;
- Updates on the electrical power generation with a breakdown into units and companies;
- Understanding of the daily supply and demand generation;
- Regular comparisons of the company’s efficient tariff to the daily average market price;
- Understanding of the fuel restrictions, which means analyzing and forecasting the financial result.
Conclusion
In addition to getting timely and comprehensive reports, Donbass Energo managed to free up noticeable chunks of time for several of their financial specialists, who previously were in charge of creating regular reports. Hence, more time and energy to dedicate to the new challenges.
Donbass Energo has stated that the newly implemented analytics had already made a real difference. At Cobit Solutions we're wishing them all the best and we're happy to watch them evolve and expand.
Logistics problems solved through Power BI
A ligistics company approached us with a challenging question.
The problem:
They had tens of thousands parcels each month, and some of them would get stuck.
Obviously, the customers were unhappy with that, and unhappy customers means less money.
With as much volume as they had, and their parcel tracking system at that time, pinpointing the problematic stage was impossible.
Basically, the info on different parcels and different transitional stages would be stored in different ERP reports. Pinpointing the problems would take manual revision, with no guarantee that one wouldn't miss the problem having to go through thousands of reports.
What we offered:
- dashboards to watch the delays and distractions in supply chains;
- statistics on where the disruptions occur most often;
- the cost of delays or distraction
Conclusion
We calculated the sum of money the company would have lost if they kept looking for the problem with their own hands. It amounted to hundreds of thousands of dollars over a couple of months - this is how much time it would've taken them to locate the problem.
Thanks to Power BI the logistics company didn't have to pay that much to find their problem.
Daily Insurance Premiums Reporting Automation
Services that we've provided:
- Developed a roadmap and plan the stages for Power BI implementation
- Developed the strategy for company data management and data governance
- Power BI dashboard development
- Integrated Power BI with ERP systems
- Build DWH data marts
- Build ETL-processes
- Provided employee workshops on working with interactive dashboards
- Provided financiers workshops on how to create dashboards
Cost of Good Sold Analytics
Here is what we have done in this project:
- Visualization of data arrays and Excel-based management reports
- Power BI development
- DAX development
- Consultancy regarding development and implementation of BI system and analytics
Power BI & ERP integration for daily reporting
Power BI development services in this project:
- Develop a roadmap and plan the stages for Power BI implementation
- Develop dashboards based on Power BI
- Build ETL-processes
- Developments based on SQL Server Integration Services (SSIS)
- Power BI and ERP integration
Power BI with API data integration & visualization
As for the source for dashboards data from API was integrated into Power BI.
We have made a great design and visualization work for Jira data to look clear and beautiful.
RFM analysis in Power BI
Works under this project:
- Design of the architecture of a future BI system
- Power BI development
- DAX data analysis & development
- ETL development
- Power BI and ERP integration
- Set up marketing end-to-end traffic analytics
- Data visualization for the analytics systems: Google Analytics, ERP, CRM, API, Excel etc.
Reviews
the project
Bi & Analytics for Mining Company
"Their level is really high, and the prices are good too."
the reviewer
the review
The client submitted this review online.
Please describe your company and your position there.
Big mining holding under NDA, my position executive.
For what projects/services did your company hire Cobit Solutions?
We hired this company for the highly technological business intelligence solution for the holding and branches. Our ERP system needed a reporting solution and personal dashboards for the owners. The order was financial reporting metrics in Power BI and personal reporting dashboards.
How did you select this vendor and what were the deciding factors?
We prefer to get recommendations for the companies for the partnership. We got the good one for Cobit Solution from the people we know.
Describe the project in detail and walk through the stages of the project.
The company asked all the detailed questions about the highly technological business intelligence solution for us, the booking system and sources of data for the BI system. We planned the dashboards for holding owners and branches. They developed the drafts of them to show on the next step. Later they have got the data from our ERP system to calculate and reflect in reporting solutions.
The system was implemented and personal dashboards developed for the owners. The order was ready and personnel studied how to work with reporting dashboards and create new ones.
How many resources from the vendor's team worked with you, and what were their positions?
Well they were Chief Executive Officer, Project Manager and 3 programmers
Can you share any outcomes from the project that demonstrate progress or success?
Highly technological business intelligence solution with a universal interpreter of the logic for calculating the indicators of management reporting articles, which, if the logic changes in ERP, would change the calculation algorithm in Power BI. Holding and branches got reporting solutions and personal dashboards for the owners to see financial reporting metrics.
How effective was the workflow between your team and theirs?
The mutual effectiveness and agreed terms for works were great. We liked the experience and would recommend Cobit Solutions!
What did you find most impressive or unique about this company?
Company has seasoned specialists so that our complicated order was realized fast and on the high level.
Are there any areas for improvement or something they could have done differently?
No, I don’t think so. Their level is really high, and the prices are good too.
the project
BI & Analytics for Mineral Water Company
"The order was made fast and up to our expectations."
the reviewer
the review
The client submitted this review online.
Please describe your company and your position there.
Our company produces mineral water worldwide for 130 years. I am responsible for the sales and finances as CFO.
For what projects/services did your company hire Cobit Solutions?
The project was our own BI system which was really poorly developed by our own means. Cobit Solutions has realized the visualization of P&L dashboard and dashboards on top of ERP data exported into the intermediate Microsoft Azure SQL database.
How did you select this vendor and what were the deciding factors?
Our managers searched for the vendors and interviewed all of them. We had certain budgeting limits and were looking for professionals with serious experience.
Describe the project in detail and walk through the stages of the project.
Well we started from the situation discussion and creation the working Power BI system on the plant. The vendor asked to prepare all the important metrics to track and dashboards to develop. The next stage was drafts approving and the system creation. The development and implementation took two more months. In the end the personnel were studying the workflow and how to adjust and create dashboards up to our tastes.
How many resources from the vendor's team worked with you, and what were their positions?
The staff for our order was 3 developers, CEO and financial PM.
Can you share any outcomes from the project that demonstrate progress or success?
The new retuned and implemented BI system finally works and there are no mistakes or failures. We started using the P&L dashboard to look at the change in the share of articles in relation to sales. This showed how much faster gross and general production costs are growing relative to sales.
How effective was the workflow between your team and theirs?
The work with the vendor was professional, up to timing and really clear. We liked it immensely, so that we can recommend this team for the significant tasks as they are positioning on their website.
What did you find most impressive or unique about this company?
The ratio of quality and service is perfect here. Great job Cobit Solutions. The order was made fast and up to our expectations.
Are there any areas for improvement or something they could have done differently?
Great marks to Cobit Solutions
the project
BI & Analytics for Digital Marketing Agency
"We will admit the fast and professional work of the vendor when you get all in terms."
the reviewer
the review
The client submitted this review online.
Please describe your company and your position there.
We are providing digital marketing services as a top 10 Internet marketing company. I am Chief Financial Officer
For what projects/services did your company hire Cobit Solutions?
Our company ordered the digital marketing services analytics to see the profits and losses, daily reports and compare the effectiveness of different marketing channels of advertisement. Report for sales: how much and who sold from their sales plan after the fact for today, how much money went in.
How did you select this vendor and what were the deciding factors?
We searched for the vendor of course on the Internet and tried to get the recommendations about them. I liked the offer and prices.
Describe the project in detail and walk through the stages of the project.
The first stage was negotiations for the order and digital marketing channels we want to track. For the analytics of profits and losses, and daily reports we prepared all the valuable indexes to track and treat. After the technical tasks were ready we got drafts of the system and dashboards themselves. We provided all the information about our bookkeeping programs to get the data and connect with BI analytics. The company wrote our order during two months and implemented the end-to-end traffic analytics, report for sales and all our daily reports.
How many resources from the vendor's team worked with you, and what were their positions?
We got a group of 5 specialists among which are 3 developers, CEO and PM.
Can you share any outcomes from the project that demonstrate progress or success?
The end-to-end traffic analytics found a marketing channel with a 450% ROMI efficiency. Normal figure for ROMI 70-150%. Plus we found $3,500 wasted by a targetologist - without a link to the target site. The system also highlighted the wasted $ 16,000 of advertising costs on YouTube without tags and the possibility of analysis.
How effective was the workflow between your team and theirs?
The vendor's personnel were experienced and the stages of the projects took only 4 months after we gave all the valuable indexes.
What did you find most impressive or unique about this company?
We will admit the fast and professional work of the vendor when you get all in terms.
Are there any areas for improvement or something they could have done differently?
Our team is happy with the new dashboards and BI analytics, I see the drawbacks when they can occur. Perfect work.
the project
Teamwork Reporting Solution for Software Development Company
"They are a great team."
the reviewer
the review
The client submitted this review online.
Please describe your company and your position there.
I am the founder of the SaaS IT company. We are a professional software development company for customers from all over the world. Established in 2009 as a small software development team in Ukraine.
For what projects/services did your company hire Cobit Solutions?
Our order was development of the software solution for teamwork reporting design in a popular task manager. Next implementation of Jira data and Power BI via API integration. Plus visualization of Jira data, implementation of interactive elements and DAX development.
How did you select this vendor and what were the deciding factors?
The most deciding factor was high proficiency and wide experience of the company.
Describe the project in detail and walk through the stages of the project.
Cobit Solutions arranged the meetings and for the plans negotiation and specifications. They asked to highlight all the important indexes for the reporting system. After that the process stepped to the stage of drafts and system architecture. The dashboard designs were ready and the process of development started. After the reception our staff was studying the system work and how to create customized dashboards on its base.
How many resources from the vendor's team worked with you, and what were their positions?
The CEO worked with us during the whole process plus 3 programmers and project manager from the vendor.
Can you share any outcomes from the project that demonstrate progress or success?
Our company was suffering while software development processes because of poor software solution for teamwork reporting. We use the popular task manager to set the plans and orders of customers. Jira data and Power BI integration, we saw the drawbacks and real reports of the workflows. Plus visualization of Jira data and DAX development were too necessary.
How effective was the workflow between your team and theirs?
I would admit that the professional attitude of the vendor is very high, so that we didn’t have any problems or hitches.
What did you find most impressive or unique about this company?
The costs and level of quality are great. We received the professionally developed order and paid a moderate price.
Are there any areas for improvement or something they could have done differently?
The discussions and clear technical tasks did all. The design and realization of the dashboards gave us new possibilities and knowages.
the project
Power BI Analysis for Entertainment Company
"Our cooperation was fruitful in a professional way."
the reviewer
the review
The client submitted this review online.
Please describe your company and your position there.
My position is financial director of the largest entertainment company group successfully acting from 2009
For what projects/services did your company hire Cobit Solutions?
We were looking for the development of corporate reporting at the board level of the largest media group. Cobit Solutions has developed for us financial analysis Power BI dashboards by key business indicators for various areas and divisions.
How did you select this vendor and what were the deciding factors?
I have searched the top Power BI providers for the real prices on the Internet.
Describe the project in detail and walk through the stages of the project.
Well we started from the meetings and plans negotiation for our industry and specifications. After we highlighted all the important indexes to report the process stepped to the stage of drafts and system architecture. The dashboards designs were ready and the process of development started. Finally we were studying the system work and how to create customized dashboards on its base.
How many resources from the vendor's team worked with you, and what were their positions?
There were 4 persons for the project, CEO from the beginning and during the order, PM and 2 developers.
Can you share any outcomes from the project that demonstrate progress or success?
The company got the corporate reporting at the board level, so that each head and managers see their numbers in dashboards. As the largest media group you can understand how important it was for us and our financial analysis. Power BI dashboards showed losses and together with key business indicators we see the profits for various divisions.
How effective was the workflow between your team and theirs?
Our cooperation was fruitful in a professional way. The meetings took place in time and the specialists worked fast to make the project.
What did you find most impressive or unique about this company?
I was surprised by the numerous industries they worked for. My first opinion was they will not have a notion of our specific.
Are there any areas for improvement or something they could have done differently?
My experience was positive and highly effective. The marks are high.
the project
Analytics Services for Digital Marketing Company
"The costs and level of quality are great."
the reviewer
the review
The client submitted this review online.
Please describe your company and your position there.
I am Chief Executive Officer. We are providing digital marketing services as a top 10 Internet marketing company.
For what projects/services did your company hire Cobit Solutions?
Our company ordered the digital marketing services analytics to see the profits and losses, daily reports and compare the effectiveness of different marketing channels of advertisement. Report for sales: how much and who sold from their sales plan after the fact for today, how much money went in.
How did you select this vendor and what were the deciding factors?
Our managers searched for the vendors and made interviews with all of them. We had certain budgeting limits and were looking for professionals with serious experience.
Describe the project in detail and walk through the stages of the project.
We made the first negotiations for the order and digital marketing channels we want to track. For the analytics of profits and losses, and daily reports we prepared all the valuable indexes to track and treat. After the technical tasks were ready we got drafts of the system and dashboards themselves. We provided all the information about our bookkeeping programs to get the data and connect with BI analytics. The company wrote our order during two months and implemented the end-to-end traffic analytics, report for sales and all our daily reports.
How many resources from the vendor's team worked with you, and what were their positions?
The CEO worked with us during the whole process plus 3 programmers and project manager from the vendor.
Can you share any outcomes from the project that demonstrate progress or success?
The end-to-end traffic analytics found a marketing channel with a 450% ROMI efficiency. Normal figure for ROMI 70-150%. Plus we found $3,500 wasted by a targetologist - without a link to the target site. The system also highlighted the wasted $ 16,000 of advertising costs on YouTube without tags and the possibility of analysis.
How effective was the workflow between your team and theirs?
The work with the vendor was professional, up to timing and really clear. We liked it immensely, so that we can recommend this team for the significant tasks as they are positioning on their website.
What did you find most impressive or unique about this company?
The costs and level of quality are great. We received the professionally developed order and paid a moderate price.
Are there any areas for improvement or something they could have done differently?
The discussions and clear technical tasks did all. The design and realization of the dashboards gave us new possibilities and knowages.
Cobit Solutions delivered high-quality service in a timely manner. They ensured an effective workflow and a great experience, meeting the client's expectations. Their cost-effectiveness, seasoned workforce, and fast delivery methods were hallmarks of their work.