Go Green One tree
One life

Project Overview

The project is about developing a Power BI-based software solution for a pharmaceutical company that focuses on quality prescriptions and OTC medications. The client was keen to design and develop a business intelligence solution that is capable of tracking daily stock on hand in each warehouse for each sales team performance daily, logistics of stocks on a daily basis, and organizational sales performance.

The client was finding it difficult to track and analyze different parameters like daily stock status, sales performance, order analysis, stock taking, etc. They wanted an in-depth visualization application that could offer stakeholders an insightful view of business analytics and performances.

SPEC INDIA followed the Time & Material process with the Agile approach to develop the roadmap and architecture of the product. We designed and launched the Power BI app in the app store, after identifying and researching various modern methodologies.

Key Components of Passwordless Identity Apps
  • Data warehousing
  • Data integration
  • Triggers for sending mail alerts
  • Insightful and alluring dashboards and reports
pharmaceutical-firm-slide 1

Core Highlights

Our Power BI-based software application aims at empowering users with  Stock on Hand (SOH), Logistics, Sales & Sales Team Performance Dashboard insights to clients after integrating data from various sources like mails, SFTP, OneDrive, etc.

We developed an automation process to get & transform data using ADF/Logic Apps from which data was used to develop a data warehouse following warehousing standards. This data was then leveraged to develop Power BI Dashboards along with mail alerts.

Key Inclusions

Master file download, creation, and update


Sales & Sales Team Performance


Data warehousing and integration

Project Screens

Technology Stack

Microsoft Power BI
Azure Data Factory
Azure Logic Apps

Do you want to create out-of-the-box IT applications?

Leverage our skilled pool of software experts to offer an exemplary and robust solution.

Get In Touch