Data Marts are a subset of a data warehouse that is tailored to the needs of a particular business unit or department. Data marts often contain data important to a specific business area, such as sales, marketing, or finance.
Dashboarding & Visualization
Visualization and dashboarding are two related concepts that are used to communicate data to audiences & stakeholders in a way that is easy to understand.
Data Lakes
Data Lakes are a centralised repository of raw data & has the ability to store structured, semi-structured and unstructured data from various sources including databases, social media and sensors. Data lakes are frequently used to store data for future study, such as machine learning and AI.
Data Warehouses
Data Warehouses are a central repository for data that has been merged from one or more diverse sources. Data warehouses are used to support BI activities like data mining, online analytical processing (OLAP), and business reporting.
ETL vs ELT
ETL and ELT are two data integration methodologies that are used to extract data from different sources, transform it into a consistent format, and load it into a data warehouse or data lake.