Power BI Turnover dashboard using Azure & Power Apps
Location: Switzerland
Industry: Technology, Lubricant, Retail and E-commerce, Energy, Organizations, Government
Business Functions:
- Information Technology
- Sales
- Operations
Problems
The client needed Power BI reports following the available data to enhance strategic decision making. Client wanted to:
- Make informed decisions on strategic issues
- Improve their business decisions by data analysis from multiple data sets
- Analyze sales/revenue based on geographic regions
Solutions
Allied proposed Cloud Integration services for integrating applications and data where we can create automated workflows.
Microsoft Azure iPaaS (integration Platform as a Service) was used to serve as middleware to establish automated interaction and communication between different systems. It comprises reliable, secure, highly available, scalable, and maintainable integration services to build serverless automated workflows.
Azure Logic Apps
were used as integration engines to:
- Transform and enrich data/messages to store in Dataverse
- Communicate with HTTP compliant APIs
- Schedule processes
Azure Logic Apps
was used to:
- Persistently store unstructured data and files
- Leverage out of the box connection service to perform read-write operations from integration apps
Azure Service Bus
was used to:
- As a message broker service and a staging storage
- For implementing in-order delivery of messages and data
- Expose the middleware for systems to communicate
Azure Log Analytics
was used to:
- Get log run details of integration services
- Implement easy querying of logs for tracking purposes
- Have overall systemโs run history over a specific period
Microsoft Dataverse โ Power Apps
was used to:
- Secure data storage and management used by business applications coming from multiple data sources in single unit data repository
Microsoft Power BI
was used to:
- Turn different sources of data into coherent, visually immersive, and interactive insights
- Create interactive reports with data modeling tools from Power BI Desktop
- Create visuals to help in the analysis of sales/revenue by products, customers, and geographic regions that can be drilled up and down over time
Azure DevOps
was used to:
- Manage the code by version control in Azure Repos
- Build, test and deploy logic apps quickly
- Automate the process of continuous deployment to different environments
Benefits / Results:
- Data conversion from multiple sources into interactive dashboards and reports
- Data-driven business decisions
- Access to real-time information
- Dashboards updated in real-time
- Sales monitoring based on Customer, Product, and region
Tech Stack:
Microsoft Azure
- Azure Logic Apps
- Azure Service Bus
- Azure Key Vault
- Azure Storage Account
- Log Analytics
Microsoft Power BI
- Microsoft Power BI desktop
- Power Query
- DAX
- Custom visualization
- Power BI Workspaces
- Power BI Dashboards
Azure DevOps
- Azure DevOps Repos
- CI/CD Pipelines
Get In Touch With Us
we believe in cutting edge solutions and are committed to your success