About The Project

The client provides elevator diagnostics, remote monitoring, and predictive maintenance solutions that:

  • Utilize IoT to connect elevators/lifts to the Cloud
  • Gather data from the sensors
  • Transform that data into valuable business insights

They weren’t able to see a clear picture of the elevator operations (i.e. KPI monitoring and reporting). They partnered with Marici to implement Power BI for data visualization and analytics.

Technology

  • Azure SQL DB
  • IoT
  • Power BI

Requirements

  • Solve data inconsistency issues
  • Integrate a business intelligence tool for data visualization and analytics
  • Ease and accuracy in KPI monitoring and reporting

Challenges

  • Developing custom, interactive reports
  • Using Power Query to load data
  • Using Data Analysis Expressions (DAX) to solve a number of basic calculation and data analysis problem

Benefits

  • Intuitive custom reports
  • Data visualization capabilities
  • Increase in the bottom-line performance of elevators

SOLUTION

1

Provided Power BI walk through and understanding

2

Developed interactive reports that use real-time elevator data by establishing a seamless connection with Azure SQL DB

3

Utilized Power Query to load data in the application

4

Made use of Data Analysis Expressions (DAX) to solve data analysis problems that include UTC handling

5

Generated Power BI PDF reports and enabled automated sending of these reports