Microsoft Excel 2019 Step by Step, First Edition

15 Perform business intelligence analysis

In this chapter

• Define a Data Model

• Define relationships between tables

• Analyze data by using Power Pivot

• View data by using timelines

• Bring in external data by using Power Query

Practice files

For this chapter, use the practice files from the Excel2019SBS\Ch15 folder. For practice file download instructions, see the introduction.

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, ...