Slowly Changing Dimensions (SCDs) are a concept in data warehousing used to manage and track changes in dimension data over time. Dimension tables typically contain descriptive attributes related to the facts in a data warehouse, such as customer or product information. However, these attributes can change over time, and different strategies are required to handle these changes while maintaining historical accuracy and data integrity.
Microsoft Business Intelligence (Data Tools)
Easy way to learn and implement the Microsoft technologies.
Tuesday, August 20, 2024
Data Warehouse — Slowly Changing Dimensions (SCDs)
Labels:
balanced hierarchies in data warehouse,
Conceptual Modeling of Data Warehousing,
Slowly Changing Dimensions
With over 17 years of experience in the Data Engineering stack across a variety of cloud and on-premises systems, I have successfully delivered more than ten complete business product solutions. My expertise lies in building robust infrastructure and architecture to support data engineering, data analytics, and machine learning processes. These solutions have significantly improved collaboration among cross-functional teams, including data scientists, business analysts, software engineers, and stakeholders.
Key Contributions
Data Modelling and Integration
• Data Modeling: Developed various data models to produce suitable data for business users, data analytics, data science, and data visualization teams.
• Legacy Systems and Cloud Technologies: Integrated legacy systems with modern cloud-based technologies (AWS, Azure, GCP), data lakes, and data warehouses.
• Streamlined Data Pipelines: Built efficient data pipelines, data warehouses, BI reports, and dashboards to streamline data access and insights.
Subscribe to:
Posts (Atom)