Module 1 Conecpts of Data Warehouses
There are two approaches to building a data warehouse. One is called Bottom-Up. The other is called:
What is Top-Down?
A modeling scheme that uses fact and dimension tables.
What is Dimensional Modeling?
This cloud-based technology supports machine learning capabilities and geospatial analysis, allowing users to run complex queries on massive datasets.
What is Google BigQuery?
The three-step process crucial for moving and transforming data from multiple sources into a warehouse
What is ETL (Extract, Transform and Load)?
This software was introduced in module 5 and can provide key insights and analytics.
What is Alteryx?
Information collected and used for day-to-day business needs utilised by all types of employees.
What is Operational Data?
This type of table contains measures related to the subject of analysis. Attributes are typically numeric and used for computation and analysis.
What is a Fact Table?
This feature allows cloud data warehouses to quickly adjust resources to meet fluctuating demands without major upfront costs.
What is elasticity?
This type of processing system is designed specifically for querying and reporting, rather than processing transactions.
What is OLAP(Online Analytical Processing)?
This tool is used to remove duplicate rows in Alteryx.
What is the unique tool?
Information collected and used for further interpretation by decision makers.
What is Analytical Data?
A schema with a central fact table and surrounding dimension tables.
What is a Star Schema?
This aspect of cloud data warehousing involves ensuring data security and compliance with privacy regulations.
What is data security and governance?
This OLAP feature provides the capability to view data from multiple perspectives, aside from drilling up and down.
What is slicing and dicing?
This data preparation tool was used to create new columns by making mathematical equations based on the data.
What is Formula?
A subsest of data warehouses for specific business functions such as marketing or sales.
What is a data mart?
What is Snowflake Schema?
This pricing model common in cloud services allows companies to pay only for the resources they use, reducing capital expenditure.
What is pay-as-you-go pricing?
This ETL step allows a user to modify or clean the data to fit a data warehouse schema.
What is 'Transform'?
This tool is used in Alteryx to remove null values, modify capitalization, and remove unwanted characters.
What is the Data Cleansing Tool?
A structured repository of integrated, subject oriented, enterprise wide, historical and time variant data.
What is a Data Warehouse?
This schema has increased data redundancy, takes a lot of storage space and has limited scalability.
What is a Constellation Schema?
This Microsoft solution offers integration with various Azure services and supports querying large datasets using T-SQL or Spark.
What is Azure Synapse Analytics?
This stores raw and unstructured data in its native format
What is a Data Lake?
This is the main purpose of Alteryx.
What is Data Analysis and visualization?