Project: How Penn Foster Modernized its BI and Reporting Capabilities with SAP Analytics Cloud
Client: Penn Foster
Providing unique audiences with the knowledge and freedom to interact with customized reports is critical for Penn Foster. Offering vocational and certificate programs, high school diplomas, and workforce development through online education courses, this American education services company needed a solution to provide a more flexible, modern reporting experience to internal customers and external clients.
Challenge: Defining the Data Problem
Penn Foster and Dunn Solutions began their partnership in 2012, exploring the SAP BusinessObjects Business Intelligence product suite. As Penn Foster has grown and transformed, offering technology-based interactive courses as part of The Penn Foster Experience learning model, they saw the need to offer cloud-based interactive reporting for their partners. This way, partners could review the reports based on individual needs and slice and dice data to consider different perspectives in their analysis.
With a complex data landscape and an array of data sources, including Web Intelligence reports, Data Warehouse in SQL server, and combination of Universes, there were challenges in consolidating and modelling data to draw insights quickly and confidently. What's more, once reports were generated for internal and external audiences, they remained stagnant and static, lacking the next-level interactivity to filter, engage with, and gain insights from data to make the report the user's own.
Enter SAP Analytics Cloud alongside SAP BusinessObjects BI Suite 4.2 – a hybrid solution for Penn Foster leveraging cloud-based analytics technology with trusted on-premise data connectivity.
Solution: Creating the Connection
To address the challenge of data management and connections, the first step was to look at opportunities to import data into SAP Analytics Cloud. From SAP BusinessObjects BI Suite 4.2/ SAP BusinessObjects Web Intelligence to Excel, data is wrangled and modelled, with a scheduled importer from Excel to bring in the data to SAP Analytics Cloud. After simplifying the connections by using the scheduled import functionality from Excel to SAP Analytics Cloud, Penn Foster reduced manual effort from repeated data uploads and were ready to start bringing their data to life with interactive, visual dashboards.
Result: Real-time Reporting and Results
Highlighting the need for improved reporting capabilities with their analytics solution, Penn Foster looked to empower report recipients with SAP Analytics Cloud. Multiple reports were needed to provide internal customers and external clients with unique reporting requirements.
With visualizations that are easy to generate from pre-created models from SAP BusinessObjects Web Intelligence reports into SAP Analytics Cloud, Penn Foster was quickly on the way to offering report recipients a cloud-based self-service approach from any device.
With SAP Analytics Cloud, ad hoc reporting and storytelling is efficient and flexible. The ability to add customized filters, input controls, and linked analysis enables unique users to have self-service data analysis – filtering, drilling down into data hierarchies for more details, and more. There's so much for Penn Foster to look forward to in the world of smart features, interactive storytelling, and turning insights into action with SAP Analytics Cloud.
