Data Warehouses
Data Warehouses
Tiber Creek Consulting helps our clients design functional data warehouses to store, extract, load, and transform data, as well as manage directories. Data warehouses, also known as OLAP (Online Analytical Processing) databases, then help our clients access and analyze data quickly and efficiently.
The process of designing a data warehouse begins with data modeling. Tiber Creek will analyze all the data feeds that our customers would like to warehouse. We create a data warehouse blueprint that describes how all the data will be effectively and efficiently stored. When the model is approved, the data warehouse is designed using either star schema or snowflake schema. Then, using SQL Server Integration Service (SSIS), we design custom ETLs (Extract Transfer Load) to examine, cleanse, and load data into the data warehouse from all desired data feeds. Our experienced data team even builds consistent, thorough metadata for use in custom applications.
Tiber Creek has recently worked with the National Guard to modernize and unify their data warehouse. Our database design team helped establish a database that could receive input from dozens of sources and is updated daily with the most accurate, current information available. This enormous data warehouse is capable of collecting and compiling all of the data that is required to run a number of applications that support the National Guard’s G1 division. This data warehouse is updated constantly, either adding new data feeds in order to expand the amount of information we provide to the Army National Guard, or updating existing data feeds to facilitate corrections to the data that the Guard is viewing.
