The Role of a BI Professional: Understanding Data Modeling,Types of Data Systems,Differentiating Structured and Unstructured Data
Section 1: Understanding Data Modeling Data modeling is the process of creating a visual representation of an entire information system or its components, establishing connections between data points and structures. Its goal is to illustrate the types of data used and stored within the system, their relationships, grouping and organization methods, as well as their formats and attributes. By modeling data, businesses can gain valuable insights and facilitate effective decision-making processes. Section 2: Types of Data Systems Data systems consist of source systems, where data is imported and exposed, and target databases, where data is acted upon. Source systems include: Data lakes : store large amounts of raw data in its original format. OLTP databases : optimized for fast data processing and transactions. Target systems include: Data marts : subject‑oriented subsets of data warehouses. OLAP databases : designed for anal...