Data warehouse Archives | Page 2 of 4 | Data Warehouse Information Center

Data warehouse and Business Intelligence – Do Both Technologies Complement One Another?

If technicalities were to be put aside and the subject matter of this article was put in layman’s term, it would be “can the cookie cutter exist without the dough?”…

Posted byIqbal Ahmed Alvi
December 25, 2018
3 minute read
5

Data Warehouse Governance: Best Practices | Data Warehouse Information Center
[…] a short few years, data warehouse has become an indispensable and integral part of al...
January 24, 2019
Advanced Dimensional Modeling Techniques – An Overview
[…] which make life easier, and data more comprehensive and readable. If you want to buil...
January 24, 2019

Technical Resources

Cloud Technology Making its Way in Data Warehouse Architecture

A data warehouse creates a centralized source of data which facilitates business intelligence, strategy, and decision-making. Thus, having an effective and efficient data warehousing solution is extremely important for any…

Posted byAelia Haider
December 21, 2018
3 minute read
2

4 Data Warehouse Optimization Mistakes to Avoid | Data Warehouse Info Center
[…] forced enterprises to rethink their data warehousing strategy. Among the emerging alt...
September 11, 2019
Data Warehouse Governance: Best Practices | Data Warehouse Information Center
[…] project. The purpose of having business people in the governance body is to ensure th...
March 19, 2019

SQL Vs. NoSQL: Which data warehouse Approach is Better?

Technical Resources

SQL Vs. NoSQL: Which Database Approach is Better?

When it comes to database technology, there are two common categories: SQL and NoSQL or relational and non-relational database respectively. They are called SQL and NoSQL referring to whether they…

Posted byIrfan Ahmed
December 19, 2018
4 minute read
0

Technical Resources

Traditional vs. Cloud – Comparing the Shift in Data Warehouse Architecture

Data warehouse architecture is changing, and it has been changing for some time now. The traditional on-premise deployment model was succeeded by cloud deployment. However, cloud-based data warehouses are different…

Posted byNida Fatima
December 14, 2018
3 minute read
4

Iqbal Ahmed Alvi
Thank you....
March 27, 2020
kumari
Thanks for the informative blog...
March 20, 2020

Technical Resources DWAccelerator Blogs

Metadata Repositories: The Managers of a Data Warehouse

Metadata helps with data management and serves as a descriptor for an object that holds some data or information. In data warehouses, it is collectively organized in a catalog called…

Posted byFahad Fareed
December 11, 2018
4 minute read
0

Technical Resources

Gauging Agility: Testing for Agile Data Warehouse Environment

In this era of data-driven decision making, data quality holds immense significance. Accurate data has been gauged to be a priority factor in customer experience enhancement and creating a business…

Posted byIqbal Ahmed Alvi
December 10, 2018
4 minute read
0

Technical Blogs

Decoding the Abstraction Layer in Data Warehousing

Before the Xbox and iPhone, prior to the first Facebook Like or Tweet, and well before the cloud and tablets, there was the data warehouse. For over 30 years, businesses…

Posted byIqbal Ahmed Alvi
November 28, 2018
3 minute read
1

Justin
Great post....
March 25, 2020

Technical Blogs

How Data Masking Provides Security within a Data Warehouse

The immense amount of sensitive information stored in data warehouses makes them attractive targets for data hackers. This means that securing a data warehouse efficiently is of high importance. At…

Posted byTehreem Naeem
November 20, 2018
4 minute read
1

Best Security Practices For Data Warehouses | Data Warehouse Information Center
[…] information about security protocols and ensuring all the personnel in the proximity ...
December 27, 2018