Condividi tramite


Analyze business data in Excel

Enabled for Public preview General availability
Users by admins, makers, or analysts Jul 1, 2024 Oct 30, 2024

Business value

The Analyze in Excel feature in Business performance analytics enhances data analysis capabilities by integrating Business performance analytics data directly with Excel. With this feature, you can use Excel's powerful tools to create custom analyses, pivot tables, and charts. You can leverage familiar functions to explore data in depth. The feature supports real-time decision-making with automatically refreshed data, ensuring that your analyses are always current.

Feature details

The Analyze in Excel feature in Business performance analytics (BPA) delivers substantial business value by allowing you to harness the full potential of Excel for data analysis directly within the BPA platform. This integration enables seamless access to BPA data in Excel, where you can leverage familiar tools and functions to create custom analyses, pivot tables, and charts. By providing direct interaction with Business performance analytics data in Excel, you can efficiently perform detailed and complex data analysis. The ability to refresh data automatically ensures that analyses are always up to-date, facilitating real-time decision-making.

Analyze in Excel enhances productivity by combining the robust data capabilities of Business performance analytics with the versatile analytical tools of Excel. This integration simplifies the data analysis process, reduces the learning curve for users already familiar with Excel, and fosters a data-driven culture within the organization. It empowers users to make informed decisions, driving operational excellence and business growth. With the complete BPA data model available in Excel, users can unlock deeper insights and tailored reports, ensuring comprehensive and accurate business performance analysis.

Screenshot of reporting hub

Additional resources

Business performance analytics Excel add-in (docs)