Calculation of employees’ KPIs

Provide the customer with an effective tool for calculating the KPIs of sales department employees.

We built Azure Cloud infrastructure. The architecture is based on containers in Azure Blob Storage. We performed automation of uploading local files to blob containers along with the data enrichment.
We created Azure Analysis Services (AAS) model for calculating employee KPIs based on business logic and customer data.
Building analytical dashboards in Power BI, integration between Power BI and the AAS model. Automation of daily data uploading processes, and recalculation of KPIs for both individual and full staff members with regard to the date, metrics, city, and branch.
Creation of three access groups in Active directory, defining AAS data filtering rules, and testing the process of transferring a user between groups.

Creation of a powerful tool for calculating KPIs of sales department employees. Building a robust Azure Analysis Services model and analytical dashboards in Power BI. In-depth analytics leveraging the insights from ML, Azure Cognitive Services and Enterprise Datawarehouse. Providing a single reliable reporting method.