Description

Before you start using Power BI to analyze and visualize your data, it is essential to understand how data is stored and structured. This module will teach you some of the basic theories and terminology you will need to know when working with data.

Learning Objectives

---

1. Identify the differences between structured and unstructured data, including their storage methods and typical use cases.
2. Recognize the importance of data types in tables and how they determine formatting and allowable values.
3. Analyze the advantages and disadvantages of flat file storage versus relational table storage, including the concept of data redundancy.
4. Evaluate the four types of data analysis (descriptive, diagnostic, predictive, and prescriptive) and their applications in business decision-making.
5. Use tools like Excel, SQL, and Azure to organize and manage structured data effectively.