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, 2020 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, 2020 by Gitika
• 65,970 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
• 58,140 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
• 11,380 points
+2 votes
11 answers

hadoop fs -put command?

Hi, You can create one directory in HDFS ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by nitinrawat895
• 11,380 points
–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,390 points
0 votes
1 answer
0 votes
1 answer

Can't connect to mysql server in workbench. Kindly please support. username: root & Password: 1234 (i gave)

Hey, @Arivukani, You can see once thing, the solution ...READ MORE

answered Mar 30, 2020 in Database by Gitika
• 65,970 points
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, 2020 in Database by Gitika
• 65,970 points