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?

Regards,
Jun 1, 2020 in Database by Edureka
• 140 points
1,013 views

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. 

I hope this will be helpful.

Get your data warehousing certification to become a certified expert.

Thanks.

answered Jun 1, 2020 by Gitika
• 65,890 points

Related Questions In Database

0 votes
0 answers

SQL how to compare two tables for same data content?

I have two tables, TableA and TableB, ...READ MORE

Aug 25, 2022 in Database by Kithuzzz
• 38,020 points
830 views
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,830 points
10,171 views
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,830 points
1,818 views
+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,100 points
1,528 views
+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
10,988 views
+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
108,570 views
–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
4,589 views
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,890 points
1,755 views
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,890 points
1,115 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP