Vidi Corp

Open Accessibility for Clients:

The client’s primary goal was to create a data portal accessible without complex login procedures. They wanted an online space where their clients could seamlessly access relevant data insights without needing technical support or additional authentication.

Real-Time Data Visualization:

Given the dynamic nature of retail data, it was crucial that the solution displayed real-time information. This requirement underscored the need for a reliable data visualization tool that could dynamically update information as it became available.

Interactive and Engaging Dashboard Experience:

Beyond static reports, the client needed an interactive dashboard that allowed users to engage with the data. They wanted end-users to filter, sort, and drill down into data metrics without any coding or specialized software skills.

Scalability and Future Growth:

As the client’s data needs were likely to evolve, they needed a flexible solution that could adapt to new data types and accommodate additional reports as their business expanded.

After assessing various options, Microsoft Power Pages emerged as the ideal platform for embedding Power BI real-time, interactive reports. This approach would allow us to deliver a solution that aligned perfectly with the client’s requirements, offering flexibility, scalability, and cost-effectiveness.

In today’s data-driven business environment, timely and accurate data collection is essential for making informed decisions. Many organizations rely on publicly available online data to track market trends, competitor information, or customer feedback. However, manually gathering data from websites can be labor-intensive, prone to errors, and inefficient. To overcome these challenges, our team implemented a solution using Microsoft Power Automate Desktop to automate the process of web data scraping, data storage in Excel, and data preparation for analytics.

This case study details how we designed and executed an automated workflow, significantly reducing manual effort and enhancing data accuracy and availability for business intelligence (BI) purposes.

Our client wanted to ensure that their warehouse teams are following several good practices. The KPIs in our Power BI warehouse dashboard helped to ensure that those practices are followed. 

Some of the KPIs that we analysed were:
1. Storage Location Occupancy % – this KPI measures how many storage locations already have products on them. It was important to ensure that some buffer is left for newly arriving items.
2. Pallets received, put away and not put away – once there is a delivery of items to the warehouse, the pallets need to be stored away on the same day. We built alerts to the warehouse managers from the Power BI dashboard in case they were not.
3. Order Status Analysis – Status of items that were about to be sent out of the warehouse (allocated, picked, palletised, staged). This is important to ensure that items do not get stuck on a certain status.
4. Number of days that orders are late – This is important to know which orders should be prioritised.5. Number of items on lifts – the client wanted to ensure that the warehouse teams don’t leave any items on forklifts overnight. If the forklifts were free, it meant that they could be used to pick the deliveries up in the morning. On the other hand, if the forklifts had items on them overnight, this meant potential delays in accepting deliveries the next day.

One of the recurring requests that we receive from our clients is to build them a Power BI Real Estate dashboard. This is a common requirement from real estate investors who want to monitor their investment portfolio performance. We have also built Power BI real estate dashboards for property management companies who are responsible for all the operational work around the real estate properties. 

In this article we will show an example of a typical Power BI real estate dashboard that we build, explain the process of building one and tell you more about how our clients use them.

As a Power Bi Consultancy we often work with pharma companies helping them create interactive dashboards. In this article we will talk about one project where we developed a Power BI pharma dashboard for a biotech company. Our client was a biotech company that recently rolled out a new drug. We were tasked with the development of a Power BI dashboard analysing the roll-out of the new drug on the US market.