Data Warehousing and OLAP mind maps
69 mind maps by 59 users · Page 1 of 2
This GoConqr page gathers Data Warehousing and OLAP mind maps on warehouse characteristics, ETL and dimensional modelling. University students and professional candidates can use them to practise these topics, while teachers can find ready-made material. There are more than 60 maps for university and professional study. Pick a map to begin.
Mind maps
-
67 nodesData Warehousing and Mining Data Warehousing · Building a Data Wareh... · Star Schema · OTLP System · Snowflake Schema · Starflake Schema
-
46 nodesDesigning and Developing the ETL System Step 1 — Draw the Hig... · Step 2 — Choose an ET... · Step 3 — Develop Defa... · Step 4 — Drill Down b... · Step 5 — Populate Dim... · Step 6 — Perform the ...
-
9 nodesData Warehouse Characteristics Subject-Oriented · Integrated · Time-variant · Non-volatile
-
32 nodesData Warehousing 2 Slowly Changing Dimen... · Designing DW · Data WH Analysis · Benefits of DW
-
55 nodesData Warehousing and Mining Decision-Support Systems · Data Warehousing · Data Mining · Classification · Association Rules · Clustering
-
153 nodesData Warehousing Data Warehouse (DW) · Data Marts · Operational Data Stor... · Metadata · Data integration · Enterprise Applicacti...
-
32 nodesA Model of Data Warehousing Process Maturity_1 DATA warehousing (DW)... · MOTIVATION FOR A DWP ... · EXTANT LITERATURE ON ... · DESIGNING A DWP MATUR... · DISCUSSION · CONCLUSION AND FUTURE...
-
31 nodesA Model of Data Warehousing Process Maturity DATA warehousing (DW)... · MOTIVATION FOR A DWP ... · EXTANT LITERATURE ON ... · DESIGNING A DWP MATUR... · DISCUSSION · CONCLUSION AND FUTURE...
-
16 nodesModel of Data Warehousing ProcessMaturity Data Warehousing · Metadata · Maturity Models · Maturity Levels
-
67 nodesData Warehousing and Mining Data Warehousing · Building a Data Wareh... · Star Schema · OTLP System · Snowflake Schema · Starflake Schema
-
77 nodesDimensional Model Design Cycle Identify Model Compon... · Identify business pro... · Identify the grain · Identify the dimensions · Identify the facts · Verify the model
-
64 nodesData Warehousing Definition · BI · Characteristics · TYPES · PROCESS OVERVIEW · Metadata
-
57 nodesData WareHouse Pool of data produced... · In the 2000's · Fundamental character... · whereas a data wareho... · 3 types of warehouses · Major components of t...
-
24 nodesA Model of Data Warehousing ProcessMaturity IS · MOTIVATION FOR A DWP ... · EXTANT LITERATURE ON ... · DESIGNING A DWP MATUR...
-
42 nodesA Model of Data Warehousing Process Maturity MOTIVATION FOR A DWP ... · EXTANT LITERATURE ON ... · DESIGNING A DWP MATUR... · DISCUSSION
-
39 nodesFrom ER Models to Dimensional Models Dimensional Model · Deriving Dimensional ...
-
39 nodesData WareHouse Is a pool of data pro... · Is a subject-oriented... · In the 2000s · Fundamental character... · 3 types of warehouses
-
35 nodesData Warehousing What is a Data Wareho... · DW Architecture · Representation of Dat... · Slowly Changing Dimen... · OLAP Operations · Steps in designing DW
-
24 nodesData Warehousing PROCESS OVERVIEW · DATA WAREHOUSING ARCH... · Alternative Data Ware... · Data Integration · Extraction, Transform...
-
30 nodesData Warehousing What is? · Characteristics · Data Marts · Operational Data Stor... · Enterprise Data Wareh... · Metadata
-
49 nodesData Warehousing DW · Fundamental · Characteristics · Data Marts · operational data stor... · enterprise data wareh...
-
18 nodesModel of Data Warehousing Process Maturity It requires huge inve... · MOTIVATION FOR A DWP ... · EXTANT LITERATURE ON ... · DESIGNING A DWP MATUR...
-
43 nodesData Warehousing Data produced to supp... · Conduct business proc... · Characteristics · Discipline that resul... · main types · Application Cases
-
45 nodesDimensional Models Designing Data warehouse · Can be used directly ... · OBJECTIVES · ER Model to Dimension... · ER model can be trans... · Advanced design
-
39 nodesData Warehousing Pool of data to suppo... · TYPES · Process · Architecture · Integration
-
41 nodesE-R Models to Dimensional Models Dimensional models · Why they work · Transformation process
-
29 nodesDIMENSIONAL MODELING Designing data wareho... · Database structures · ER -> DIMENSIONAL · OBJECTIVES · SCHEMAS · Issues examples
-
48 nodesCh. 2: Data Warenhousing Definition · Major Components · DW Arquitectures · Data Integration & ETL · Implementation approa... · History
-
42 nodesDimensional Model ER Model to dimensional · Produce easy database... · Optimize query perfor... · Schemas · Dimensions · Why it works?
-
9 nodesDimensional Modeling Primer Appoints a set of tec... · It's considered to be... · Dimensional modeling ... · This asset is almost ...
-
42 nodesData Warehousing A physical repository... · Characteristic · Types · ETL Process · Representation of Dat... · OLAP
-
58 nodesMethodologies of a Data Warehouse W.H. Inmon · Arquitectura · Diseño · Diseño de los proceso... · Metodologías para la ...
-
18 nodesOLAP operations Roll-up · Drill-down · Slice · Pivot · Dice
-
9 nodesData Warehouse Characteristics Subject-Oriented · Integrated · Time-variant · Non-volatile
-
10 nodesETL Functions Transform · Extract · Load
-
10 nodesETL Functions Transform · Extract · Load
-
21 nodesData Warehouse Recursos de datos Dat... · Back end tier · Data warehouse tier · OLAP tier · Front - end tier
-
17 nodesData warehousing Data warehouse types · Metadata · Processes · Dimensional modeling · Real-time data wareho...
-
49 nodesA Model of Data Warehousing Process Maturity Is · The Capability Maturi... · MOTIVATION FOR A DWP ... · EXTANT LITERATURE ON ... · DESIGNING A DWP MATUR... · DISCUSSION
-
22 nodesModel of Data Warehousing Process Maturity Motivation For a DWP ... · Ir requires huge inve... · Extant Literature on ... · designing a DWP matur...
More Data Warehousing and OLAP resources
About data warehousing and olap mind maps
GoConqr OriginalUsing Data Warehousing and OLAP mind maps
The maps on this page organise warehouse topics into branches you can follow and revisit. Data Warehouse Characteristics covers subject-oriented, integrated, time-variant and non-volatile characteristics. Designing and Developing the ETL System includes a high-level plan and the choice of an ETL tool. Other maps cover dimensional modelling, OLAP operations and data warehousing process maturity.
Build a revision route
Start with Data Warehouse Characteristics if you want to review the terms used to describe a warehouse. Read a branch, then look away and try to recall its main point. Move on to Dimensional Modeling Primer or a map on ETL when you want to focus on a particular part of the unit.
If you want to check your recall in a different way, switch to a quiz or flashcards on the unit page. Return to a map when a topic needs another look. Choose a branch and make it your starting point.
Frequently asked questions
Which mind map is a useful starting point?
Data Warehouse Characteristics is a useful place to start if you want to review how a warehouse is described. Its branches cover subject-oriented, integrated, time-variant and non-volatile characteristics. From there, you can move to a map on ETL, dimensional modelling or OLAP operations.
What topics do the mind maps cover?
The maps cover data warehouse characteristics, ETL, dimensional modelling, OLAP operations and data warehousing process maturity. For example, Designing and Developing the ETL System includes planning and tool choice. Data Warehousing and Mining includes potential benefits alongside costs and development time.
Are the mind maps free to use?
Yes. Every map listed here is free to open and study without an account. The resources were made by GoConqr users, rather than by GoConqr. A free account also lets you save quiz scores and make your own quizzes, mind maps, flashcards and notes.