Uniqbro (Unicbro) (Microsoft Power BI)

2018: Analysis of financial indicators based on Microsoft Power BI

UniqBro oversees the activities of the SPA network. To improve the company's performance, it is important to quickly track:

• interaction with clients - tracking of incoming calls, visiting guests, use of offers from the loyalty program;
• work of the personnel service - selection and training of employees, HR-analyst;
• financial indicators - control of income and expenses within branches and the entire company.

Since employees provide a lot of the same type of information on a daily basis, there is a high probability of an error when entering primary ones. data That is why Uniqbro business analysts uses cloudy the version. Power BI The client also actively uses other cloud services:, Microsoft Flow Sharepoint,, Office 365 StuffHub.

Cooperation with Awara IT was a logical step in using Power BI at Uniqbro:

• updated reports illustrating the effectiveness of the company's branches
• expanded the list of reports used
• Minimizes the risk of end-user errors when entering primary information.

Results:

• expanded reporting functionality for branches. Added analysis by time of day, days of week. In addition, analytics reflects the type of day - working, weekend, holiday;
• It became possible to track and analyze incoming calls by integrating data from the Mango Office billing system into Microsoft Power BI;
• expanded the functionality of reporting on the company's revenue analysis. Comparison in the cross-section of the same time intervals was implemented, growth rates, etc., were calculated;
• HR reporting, KPI dynamics, dividend analysis, revenue and expense analysis has been developed.

Thus, Power BI enhancements have been proposed for investors, senior management and mid-level executives. The company's management is pleased with the updated business analytics system and intends to improve it in the future.