Simplified metrics using Power BI
Shreshthi Mehta, PMP®, PHR® | TrustRadius Reviewer
December 09, 2019

Simplified metrics using Power BI

Score 10 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with Microsoft Power BI

Power BI is being used by HR and IT departments. We use it typically to run weekly and monthly reports and for data analytics. It is hugely helpful in saving time as we can build in formats within the tool and schedule the metrics to run weekly/monthly. Weekly/ monthly data cuts are not required.
  • Saves time as regular reports do not need to be created every time.
  • The tool has several grafts and charts that can be created by the click of a button.
  • It is easy to analyze data by dwelling deeper in each data set.
  • Can be interfaced with several systems.
  • The system is useful in data analytics but there is a learning curve.
  • It is difficult to understand the linking of datasets while organizing data in the beginning.
  • You need to work with an IT person to interface Power BI with existing systems.
  • While the tool runs the required metrics, it does not tell a story to connect all the metrics. Human intervention is required in this phase.
We have an existing HRIS system. It does help in data analytics but it is difficult to configure charts and metrics to run on a regular or weekly basis. Like excel, Power BI has customizable data labels. The metrics can also be created within a template like a power point presentation.
We interface Power BI with Dayforce. The report from Dayforce feeds into Power BI once everyday and the metrics are updated. We realized that there could be an issue with obtaining real time data as the two systems are different. Hence, we use data only for the previous day or date for our analysis. It works as per our needs.
We used to run reports in excel, then create a power point presentation and then email it to our clients. With Power BI, the metrics can be configured into templates and scheduled to be sent to the email in the required format.
The set up took time in the beginning. But after that was done the process is easy to manage.
Within the HR department we receive report requests from other departments on a regular basis. We have used Power BI to create a process where the reports are automatically delivered to our clients. This saves a lot of time for both of us.
Like I mentioned before, there is a learning curve to understanding this tool. It needs practice. Microsoft organizes free in house training for Power BI. Anyone can sign up and learn. The training materials are very useful and the staff is very knowledgeable and polite. The information can be obtained within the tool updates.

Microsoft Power BI Feature Ratings

Pixel Perfect reports
10
Customizable dashboards
10
Report Formatting Templates
10
Drill-down analysis
10
Formatting capabilities
10
Integration with R or other statistical packages
10
Report sharing and collaboration
10
Publish to Web
10
Publish to PDF
10
Report Versioning
10
Report Delivery Scheduling
10
Delivery to Remote Servers
10
Pre-built visualization formats (heatmaps, scatter plots etc.)
10
Location Analytics / Geographic Visualization
10
Predictive Analytics
10
Multi-User Support (named login)
10
Role-Based Security Model
10
Multiple Access Permission Levels (Create, Read, Delete)
10
Single Sign-On (SSO)
9
Responsive Design for Web Access
10
Dedicated iOS Application
8
Dedicated Android Application
8
Dashboard / Report / Visualization Interactivity on Mobile
10
REST API
9
Javascript API
9
iFrames
9
Java API
9
Themeable User Interface (UI)
9
Customizable Platform (Open Source)
9