Tableau Dashboard Tool

What is Tableau?

Tableau is a data visualization and business analytics tool. It is used To build interactive dashboards that allow the user to analyze and explore data. It is developed in Stanford University, Computer Science department between 1999 and 2002. Tableau software was acquired by Salesforce in Aug 2019. The acquisition cost was $15.7 Bn which was the most expensive deal of that time.

In Tableau, you can connect many data sources. Eg Excel, SQL, SAP etc. You can drag various data fields to the desired part of the sheet. Tableau automatically makes the inner join. We can add the different data sources in a single table.

Tableau Products:-

1. Tableau Server
2. Tableau Desktop
3. Tableau Prep
4. Tableau Public
5. Tableau Online
6. Tableau Public Server
7. Tableau Public Desktop
8. Tableau Mobile

Fact Table

Fact Table

Type of Fact-

1-Additive- Additive facts are facts that can be summed through all of the dimensions in the fact table.
2-Semi-Additive- Semi-aditive facts are that can be summed through some of the dimensions and cannot be summed through some dimensions.
3-Non-Additive- Non-additive facts are that can not be summed up for any dimensions in fact table

Factless Fact table-

A factless table is fact table which does not contains any measure. It is just an intersection of dimenstions.

Dataware Housing Concept

Data warehousing concept is a process of collecting, organizing, and managing data from different data sources to create and provide useful business insights. 

The main features of a data warehouse are as below:

• Subject Oriented- A data-ware house provides information about subject (area) of organization. like sales, marketing etc.

• Integrated- A data warehouse integrates data from different heterogeneous sources. They should not have naming conflicts and differences between values of measures.

• Non-Volatile- Non-volatile means, data should not be removed over the time. because data is used for analysis purpose.

• Time Variant- Data in data warehouse changes with time. It stores more data as time passes.

How to design a Data Warehouse?

What is Data Warehouse?

A  data warehouse is a relational database which is used for reporting and data analysis. Data warehouse is a main component of BI.

Data warehouse can be defined under two main concept-

According to Bill Inmon-

A data warehouse is subject-oriented,integrated,time-variant and non-volatile collection of data in support of management's decision-making process.

According to Ralph Kimball-

A data warehouse is a copy of transaction data specifically structured for query and analysis.