Mar 30, 2021
No image
Service categories
Service Lines
Artificial Intelligence
Big Data
Domain focus
Banking & Financial Services
Challenge
To provide the customer with an effective tool for measuring sales department staff KPIs.
To provide the customer with an effective tool for measuring sales department staff KPIs.
Solution
Building of Azure Cloud infrastructure. Azure Blob Storage containers formed the basis of the architecture. Process automation of uploading local files into blob containers along with data enrichment.
Creation of Azure Analysis Services model based on business logic and customer’s data to measure employee KPIs.
Building of Power BI business analysis dashboards, integration between Power BI and the AAS model. Process automation of daily data uploads, recalculation of both individual and total KPIs with regard to the date, metrics, city, and branch.
Three set AD access groups, defined AAS data filtering rules, proof tested process of user transaction from one group into another.
Building of Azure Cloud infrastructure. Azure Blob Storage containers formed the basis of the architecture. Process automation of uploading local files into blob containers along with data enrichment.
Creation of Azure Analysis Services model based on business logic and customer’s data to measure employee KPIs.
Building of Power BI business analysis dashboards, integration between Power BI and the AAS model. Process automation of daily data uploads, recalculation of both individual and total KPIs with regard to the date, metrics, city, and branch.
Three set AD access groups, defined AAS data filtering rules, proof tested process of user transaction from one group into another.
Results
Creation of a powerful tool for measuring sales department staff KPIs. Building of a robust Azure Analysis Services model and Power BI business analysis dashboards. In-depth analytics leveraging the insights of ML, Azure Cognitive Services and EDWH data. A single reliable reporting method has been ensured.
Creation of a powerful tool for measuring sales department staff KPIs. Building of a robust Azure Analysis Services model and Power BI business analysis dashboards. In-depth analytics leveraging the insights of ML, Azure Cognitive Services and EDWH data. A single reliable reporting method has been ensured.