Customer Profile
The company is a part of the group of companies Bridgera belongs to. The company focuses on providing skills across a wide variety of platforms and services, across US, Canada and Puerto Rico. The need was to build BI dashboards for the HR Onboarding data of the company and to embed the same in the company’s Onboarding portal.
Background
Onboarding data for each of the candidates likely to join the company, from offered to joining stages was residing in the Amazon Aurora database on the Amazon cloud. It had to be analyzed and visualized using Business Intelligence and Visualization tools to get meaningful insights from this data. The BI dashboards include the key KPIs (Key Performance Indicators), other related metrics, and trend over time. The company wanted the BI dashboards to be embedded in the onboarding portal.
Why Bridgera?
Bridgera is the IoT (Internet of Things) arm of the company and has a depth of experience in delivering actionable insights through data collection, cleansing, analyzing, and visualizing huge volumes of data. Bridgera developed business intelligence projects on the IoT data over diverse industries and client base, across multiple locations. Our consultants used a variety of tools spanning both data warehousing, business intelligence and visualizations. Bridgera has been developing state-of-the-art enterprise BI solutions for organizations across the globe. Onboarding data for each of the candidates likely to join the company, from offered to joining stages was residing in the Amazon Aurora database on the Amazon cloud. It had to be analyzed and visualized using Business Intelligence and Visualization tools to get meaningful insights from this data. The BI dashboards include the key KPIs (Key Performance Indicators), other related metrics, and trend over time. The company wanted the BI dashboards to be embedded in the onboarding portal. Onboarding data for each of the candidates likely to join the company, from offered to joining stages was residing in the Amazon Aurora database on the Amazon cloud. It had to be analyzed and visualized using Business Intelligence and Visualization tools to get meaningful insights from this data. The BI dashboards include the key KPIs (Key Performance Indicators), other related metrics, and trend over time. The company wanted the BI dashboards to be embedded in the onboarding portal.
Results
BI Dashboards built for tracking
- Top Customers /Regions who attributed to the company’s revenue from skill sourcing
- Diversity of candidates over time / Industry/Stages of Onboarding
- Efficiency of onboarding specialists over time
- Ageing of candidate status over time
- Drilling of cumulative company data, down to the candidate, day, location, gender, and onboarding status levels
Dashboards shared across segments of users
- Defined by group-based access
- Restricted by row-level security of data
- Scheduled by daily timeslots
- Restricted by features of filtering & downloading of outputs
- Embedded in the Onboarding portal
360 Degree View
Prepared views of linked tables in Amazon QuickSight
Data Visualization
Built various analysis over time, customer, region, gender & onboarding status
Restricted Data Access
Defined user groups for access level and controls for the dashboards
Dashboarding
Prepared and scheduled dashboards derived from the analysis
Embedded Dashboards
Captured code for the dashboard and embedded the same in the onboarding portal, for visualizations directly from the portal