How to design data warehouse for support whole business?

0 votes
Dear Expert,

Please kindly help to guide me what is the best practice to design or build data warehouse?

What point should we consider for develop it?

Jun 1 in Database by Edureka
• 140 points

1 answer to this question.

0 votes

Hi, @There,

So here are a few steps you need to follow into building a data warehouse:

Defining Business Requirements: 

  • Aligning department goals
  • Discovering your future needs and current needs by diving deep into your data
  • Creating a disaster recovery plan in the case of system failure

Setting Up Physical Environments: 

  • Data warehouses typically have three primary physical environments — development, testing, and production
  • You need a way to test changes before they move into the production environment.
  • Running tests can often introduce breakpoints and hang your entire server. That's definitely not something you want happening in your production environment.

Data Modeling: 

  • Data modeling is the process of visualizing data distribution in your warehouse. Think of it as a blueprint.
  • Data modeling is probably the most complex phase of data warehouse design.
  • Data modeling typically takes place at the data mart level and branches out into your data warehouse.

Extract, Transfer, Load (ETL) Solution:

  • You want optimal speeds, good visualization, and the ability to build an easy, replicable, and consistent data pipeline between all of your existing architecture and your new warehouse.
  • For most businesses, ETL will be your go-to for pulling data from systems into your warehouse. 

For some things in details you can go through this

I hope this will be helpful.

answered Jun 1 by Gitika
• 31,310 points

Related Questions In Database

0 votes
1 answer

How to schedule a job for SQL query to run daily?

down voteaccepted Expand the SQL Server Agent node ...READ MORE

answered Oct 25, 2018 in Database by Frankie
• 9,810 points
0 votes
1 answer

How to cache data in a MVC application?

Reference the System.Web dll in your model ...READ MORE

answered Oct 25, 2018 in Database by Frankie
• 9,810 points
+2 votes
1 answer

How to export data from MySql to a CSV file?

If you are using MySql workbench then ...READ MORE

answered Jan 4, 2019 in Database by Priyaj
• 57,530 points
0 votes
2 answers
+1 vote
1 answer

Hadoop Mapreduce word count Program

Firstly you need to understand the concept ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 10,920 points
+1 vote
11 answers

hadoop fs -put command?

put syntax: put <localSrc> <dest> copy syntax: copyF ...READ MORE

answered Dec 7, 2018 in Big Data Hadoop by Aditya
–1 vote
1 answer

Hadoop dfs -ls command?

In your case there is no difference ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by kurt_cobain
• 9,310 points
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

Generate mongod.conf for tarball installtion

Hi,@kailas, To run a mangod process as a daemon ...READ MORE

answered May 26 in Database by Gitika
• 31,310 points