---
title: "How Data Warehousing and Analytics Linked together"
description: "A quick comparison between Data Warehousing and Analytics. It's useful for beginners and computer programmers."
url: https://srinimf.com/2012/06/05/data-warehousing-tools/
date: 2012-06-05
modified: 2026-10-10
author: "Srini"
image: https://i0.wp.com/srinimf.com/wp-content/uploads/2012/06/data-warehousing-vs-analytics.jpg?fit=1200%2C700&ssl=1
categories: ["Data Warehousing & Tools"]
tags: ["Analytics Vs data warehousing"]
type: post
lang: en
---

# How Data Warehousing and Analytics Linked together

Here’s a quick comparison between [Data Warehousing](https://srinimf.com/2017/02/11/one-one-best-data-warehousing-question/) and Analytics.

## Data Warehousing Tools

In the mainframe environment, the top database is DB2. [How to](https://srinimf.com/2012/12/28/how-to-write-cics-wrapper-program/) get refined data? it is a big challenge. Check** [here](http://www.dwbiconcepts.com/)** 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

1. **production data sources- **Data generated in production boxes
2. **data extraction and conversion- **Extract the data from production boxes and convert into a suitable format.
3. **the [data warehouse](https://srinimf.com/2026/08/08/databricks-lakebase-vs-lakehouse-vs-data-warehouse-whats-the-difference/) database management system** – Management of Data warehouse performance.
4. **data warehouse administration- **Administration of the data warehouse.
5. **[business intelligence](https://srinimf.com/2012/07/02/dwh-cognos-basics/) (BI) tools**– BI tools like Tableau, QlikView etc.

Related[6 Exclusive Cognos Tools to Know Where They Use in Data Analytics](https://srinimf.com/2012/06/28/dwh-cognos-for-analytical-application/)

### 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.

### Top Analytics Tools

1. AWS Analytics
2. Cloudera
3. Microsoft Analytics
4. Splunk
5. Teradata

#### The Bottom Line

![Analytics](https://i0.wp.com/srinimf.com/wp-content/uploads/2012/06/analytics.jpg?resize=400%2C263&ssl=1)

Analytics play prime role in predictions and analysis of stream data. In the case of DW the data is not current.

## Analytics Flow Chart

![](https://i0.wp.com/srinimf.com/wp-content/uploads/2018/11/data-flow.jpg?resize=588%2C426&ssl=1)*Photo credit: Srini*

Related Posts

- [What is Business Intelligence and Why You Need](https://srinimf.com/2015/09/16/what-is-the-difference-between-data-warehousing-and-business-intelligence/)DateSeptember 16, 2015
- [2 ETL Interview Questions That have Asked Earlier](https://srinimf.com/2017/02/11/one-one-best-data-warehousing-question/)DateFebruary 11, 2017
- [6 Exclusive Cognos Tools to Know Where They Use in Data Analytics](https://srinimf.com/2012/06/28/dwh-cognos-for-analytical-application/)DateJune 28, 2012

### Share this:

-
- [Tweet](https://twitter.com/share)
- [![](https://i0.wp.com/assets.pinterest.com/images/pidgets/pinit_fg_en_rect_gray_20.png)](https://www.pinterest.com/pin/create/link/?url=https%3A%2F%2Fsrinimf.com%2F2012%2F06%2F05%2Fdata-warehousing-tools%2F&media=https%3A%2F%2Fi0.wp.com%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2012%2F06%2Fdata-warehousing-vs-analytics.jpg%3Ffit%3D1200%252C700%26ssl%3D1&description=How%20Data%20Warehousing%20and%20Analytics%20Linked%20together)
-
- [Share on Tumblr](https://www.tumblr.com/share)
- [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2012/06/05/data-warehousing-tools/?share=jetpack-whatsapp)
- [More](#)
-

- [Print (Opens in new window) Print](https://srinimf.com/2012/06/05/data-warehousing-tools/?share=print)
- [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2012/06/05/data-warehousing-tools/?share=reddit)
- [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2012/06/05/data-warehousing-tools/?share=telegram)
- [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%20How%20Data%20Warehousing%20and%20Analytics%20Linked%20together&body=https%3A%2F%2Fsrinimf.com%2F2012%2F06%2F05%2Fdata-warehousing-tools%2F&share=email)
-

### Like this:

Like Loading…