Home / CPA Course / ISC

Data storage and the data life cycle

ISC Chapter 5 · Area I · Blueprint I.B

Area I now turns from systems to the data inside them. Brightwater's managers want one dashboard that shows sales, stock and margins by store and by day, and that means pulling data out of the ERP, the web store and the POS, and putting it somewhere built for analysis. Priya and Sam follow that journey: what kinds of data exist, how data is extracted, what a data warehouse, data mart and data lake are, how star and snowflake schemas are laid out, how data lives from creation to destruction, and how to judge whether the data is good enough to rely on. Chapters 6 and 7 build directly on this one.

In this chapter

1. Kinds of data and where they live
2. Getting data out: extraction methods and techniques
3. Data warehouse, data mart and data lake
4. Star and snowflake schemas
5. The data life cycle
6. Data quality and governance

This chapter has 6 lessons, 50 practice MCQs with explanations and 20 simulations, plus flashcards and a recall sheet.

What this chapter covers

• Extraction methods
• data warehouse, lake and mart
• star and snowflake schemas
• the data life cycle

Chapter 4: Change management · Chapter 6: Relational databases and SQL