Business Automation Solution
Python, Microsoft Power BI
The client is a leading U.S provider of healthcare and pharmacy software solutions for long-term care. The company’s mission is to improve healthcare by strengthening the role of independent pharmaceutical organizations by providing affordable and high-quality specialized software. The client’s software allows for managing patient information, orders, pharmaceutical product delivery, billing, and electronic prescriptions.
To boost the team’s productivity and optimize workflows, the client approached NIX to reinforce their software for data analytics. The existing solution didn’t provide enough flexibility and had a lack of functionality.
The NIX team’s scope included:
Redesign existing dashboards for better user experience
Develop a new BI solution to boost productivity and increase business functionality
After thoroughly analyzing the client request, we suggested using Power BI and Python, which perfectly covers the desired objectives without constructing a complex data engineering solution, thus saving the client’s budget.
As data sources, we used:
We connected to the VersionOne tracking system, Zoho API, and SharePoint using the Power Query Web connector—a data transformation engine that works with API requests to Power BI. This allowed us to load data into Power BI and perform custom calculations for the dashboards using DAX programming language.
The NIX team reinvented existing dashboards and created new ones with custom visualization and expanded functionality. Using custom Python scripts, we provided the ability to perform complex calculations and then display them on the dashboards that Power BI does not have out of the box.
New dashboards can also automatically generate and display reports for the management department, saving time spent on mundane report-generation tasks.
Interactive Power BI reports for the company’s major departments can be assessed by roles and provide the following features:
Personal performance and velocity per sprint and average score
Velocity by team proportional per sprint and average overall velocity
Automatically generated reports for management
Amount of closed tasks and defects per task
Open and closed change requests
Custom KPI reports for teams
As a result, the newly implemented Power BI analytics solution empowered the client with comprehensive analytics that dramatically boosted the productivity for the teams and individuals.
Due to custom visualization, calculations, and automatically generated performance reports, managers can track productivity and easily modify workflows to meet KPIs, thus saving time and funds.
Project Manager, 2 Business Data Analysts, QA Engineer
Python, Microsoft Power BI, DAX, PowerQuery(M)
Microservice-based web platform for all-in-one pharmacy management to increase efficiency and improve patient care.
Robust data engineering and analytics solution that enables real-time reports for efficient pharmacy management.
Reinforced web platform empowers pharmaceutical companies with up-to-date marketing insights, boosts revenue via increased sales, and helps to stay ahead of the competition.
Using the ServiceNow platform to optimize workflows, increase employee efficiency, and grow customer satisfaction.
Interactive NLP chatbot empowered with conversational AI for web, mobile, and desktop that accelerates internal operations.
AWS data analytics platform for an educational 3D platform that provides actionable insights on marketing and product activities.
How NIX helped leverage data science and artificial intelligence for digital transformation of Assisted Reproduction field.
Telehealth system with sophisticated AI-based analytics for physicians to monitor a patient’s state in real-time and remotely using IoT devices.
Web platform for building curricula with pre-built 3D lessons and slides from anatomy educators across the globe.
See more success stories
Our representative gets in touch with you within 24 hours.
We delve into your business needs and our expert team drafts the optimal solution for your project.
You receive a proposal with estimated effort, project timeline and recommended team structure.
NIX United at ITEXPO 2023
14 - 17 Feb 2023
Broward County Convention Center, Fort Lauderdale, USA
Meet Us at The Event