Management asked Elliott Davis: “We are spending too much time manually entering data vs. completing the analysis we need to identify our financial results. Can you help us build a dashboard reporting tool?”
Context
Software developer that provides solutions to optimize prescription healthcare
Goal: Maximize patient engagement with their healthcare
Over 750 employees
Issue:
Manual, monthly financial data entry
Timeline: One week to complete entries
File contains multiple circular references and dependencies that added unnecessary time and complexity to month-end closing process
Our Approach
Experienced Microsoft™ Power BI® and automation consultants created a dashboard report with financial statements, key performance indicators (KPIs), and executive level dashboards.
The approach included:
Collaborated with the Director of Financial Planning and Analysis to build a structured MS Excel® file that met data management and automation requirements
Created dashboards for high-level, immediate review in areas of executive concern
Developed interactive dashboards that track and slice through data to offer insights to operations in financial and personnel KPIs
Customer Impact
Standardized report visuals enable quick Power BI refreshes saving time to focus on analysis of the numbers/results
Decreased report creation time from multiple weeks to less than one week
Increased report creation abilities
Provided stakeholders actionable insights to areas of concern and allow management to constantly overview performance
We Can Help
For more information on how Elliott Davis can assist you and your business, contact a member of our team.
The information provided in this communication is of a general nature and should not be considered professional advice. You should not act upon the information provided without obtaining specific professional advice. The information above is subject to change.
“Elliott Davis" is the brand name under which Elliott Davis, LLC (doing business in North Carolina and D.C. as Elliott Davis, PLLC) and Elliott Davis Advisory, LLC and its subsidiary entities provide professional services. Elliott Davis, LLC and Elliott Davis Advisory, LLC and its subsidiary entities practice as an alternative practice structure in accordance with the AICPA Code of Professional Conduct and applicable law, regulations and professional standards. Elliott Davis, LLC is a licensed independent CPA firm that provides attest services to its customers. Elliott Davis Advisory, LLC and its subsidiary entities provide tax and business consulting services to their customers. Elliott Davis Advisory, LLC and its subsidiary entities are not licensed CPA firms. The entities falling under the Elliott Davis brand are each individual firms that are separate legal and independently owned entities and are not responsible or liable for the services and/or products provided by any other entity providing services and/or products under the Elliott Davis brand. Our use of the terms “our firm” and “we” and “us” and terms of similar import, denote the alternative practice structure conducted by Elliott Davis, LLC and Elliott Davis Advisory, LLC.