Summary
Mass Mutual is a leading life insurance provider and other financial products and services. Read why the company turned to Microsoft Power BI and ExistBI to find a better way to analyze data from their employee surveys so they could deliver results promptly.
About Mass Mutual
MassMutual is a prominent American life insurance company and financial services organization that offers a wide range of financial products and services, including life, disability income and long-term care insurance, retirement planning, annuities, and investment management. The company caters to individuals, families, and businesses.
With over 10,000 employees, including a network of financial professionals and advisors, one of Mass Mutual’s corporate objectives is to transform its business to reach more people with broader solutions and better experiences.
Challenge
Mass Mutual conducts frequent employee surveys to understand how the company is performing and identify areas of improvement. While only a select number of employees are required to answer the bi-annual surveys, they require a significant commitment to analyze the data as the surveys were long and divided into multiple surveys.
Each time a new set of survey results is received, it took the team at Mass Mutual almost 40 hours to analyze, review, and create the visualizations using standard spreadsheet software. They knew there was a better way that required less time and would enable them to deliver well-crafted visualizations promptly. Mass Mutual turned to ExistBI to help them solve the problem.
Solution
After speaking with the consulting team at ExistBI, the survey team at Mass Mutual decided to move away from using Microsoft Excel and start using Microsoft Power BI to analyze their employee survey data. Power BI provides many benefits compared to spreadsheets and other data analytics and visualization software.
Some of these benefits include:
- Can connect to over 120 data sources, including survey applications like SurveyMonkey
- Able to handle data sets of various sizes
- Availability of advanced features like cross-filtering between charts
- Users can apply visual-level, page-level and report-level filters
- Only users with approved credentials can access reports
- Users cannot access the underlying data which ensures the integrity of data results
- Reports can be viewed on mobile phones.
The consulting team at ExistBI team worked with the management team at Mass Mutual to create the infrastructure, so they simply had to upload the most recent data to a folder, and the Power BI application would extract and transform the data to create the appropriate visualizations. The application would also compare the current and previous survey results to highlight positive changes and areas of improvement.
Results
After switching to Power BI, analyzing survey data takes about 30 minutes, compared to 40 hours previously. This not only reduced the effort required by the team to analyze the data, but it also delivered results to the management team faster.
Interested in Power BI or Power Platform?
ExistBI offers Microsoft Power Platform, Power BI consulting and Microsoft Power BI training services. Their courses include:
- Analyzing Data with Power BI (4-day) – Learn methods and best practices that align with business and technical requirements for modelling, visualizing, and analyzing data with Power BI.
- Power BI Data Analyst Bootcamp PL300 (3-day) – Learn how to access and process relational and non-relational data, implement proper security standards and policies, and manage and deploy reports and dashboards.
- Power Apps For Beginners (2-day) – Learn how to create PowerApps from existing data sources, brand PowerApps, customise PowerApps beyond just using the automated wizards, connect to a range of data sources from Excel to Azure SQL, understand the difference between canvas apps and model-driven apps, integrate PowerApps with other Office 365 systems and Administer PowerApps.
- Power Automate Desktop (2-day) – Lear to create flows from scratch and from existing templates. Work with triggers, actions, conditions, and approvals.
Work with variables, loops, functions, and expressions. Use the Power of RPA Automation and Use Error handling.