How Data Warehousing and Analytics Linked together

Here’s a quick comparison between Data Warehousing and Analytics.

Data Warehousing Tools

In the mainframe environment, the top database is DB2. How to get refined data? it is a big challenge. Check here for fundamentals.

If we see the global markets, the business scenario is changing now. So business owners need strategic data for making decisions. Below are the tools to help work on Data Warehousing(DW).

Oracle BI tools
IBM BI tools
Microsoft BI tools

Data warehousing Top Components

production data sources- Data generated in production boxes
data extraction and conversion- Extract the data from production boxes and convert into a suitable format.
the data warehouse database management system – Management of Data warehouse performance.
data warehouse administration- Administration of the data warehouse.
business intelligence (BI) tools– BI tools like Tableau, QlikView etc.

SQL Queries in Warehousing

very large fact tables often running into billions of rows
a large number of dimension tables
a large number of joins
large aggregation queries
large amounts of data ingested into the warehouse

Analytics

The data stored in warehouse is not strategic level. The level of granularity is less. Future prediction is the big plus in Analytics. This you achieve through numerous computer models and statistical methods.