Microsoft Excel Step by Step (Office 2021 and Microsoft 365)

15. Perform business intelligence analysis

In this chapter

• Manage the Excel Data Model

• Define relationships between data sources

• Manage data by using Power Pivot

• Display data on timelines

• Import data by using Power Query

Organizations of all kinds generate and collect data from operations, sales, and customers. As the volume of data grows, so does the importance of generating useful insights into your operations from that data. Excel supports business intelligence analysis, which is the practice of examining data to improve business performance.

Analytical tools such as formulas, data tables, and PivotTables all provide valuable insights into your data, but their applications can be limited in size and scope. Excel for Microsoft 365 includes ...