The Data warehousing the essential skill for Business intelligence

Sajjad Hussain
Feb 16 · 2 min read

Data warehousing plays a crucial role to elaborate the righteous decision of a business manager analyzing the large amount of data is not the easy task in today's high competitive world manufacturing, big retailers and banking system generate large volume of data mostly from structure data sources (ERP) the data contains logs of sock levels, delivery schedules, customer data, prices paid, product return rates, product development schedules and quality assurances If there is no system exists in organization which accumulate or conclude the data points many of the business prospects became answer less
let suppose single question “Does a 5 percent drop in production will create impact on expenses” To answer such question one must rely on the skill of properly implemented warehouse, the warehouse reveals the secrets of the manufacturing biases, the concerns of the logistic logs, the event based marketing strategy and the big retailer seasonal discounts all will be possible with the help of careful ware house implementation.

Financial services, retailers and manufacturing companies usually
have million of customers and it is not easy to predict the changes in the business needs when consumer behaviors mutate the performance largely depends on the data they collated and stores.

The prime responsibilities of data warehouse

  1. Extract the data from structure and unstructured sources
    2)Due to internet dependency much of the data from the web sources must transform into consistent format
    3)Load into the data repository
    4)The data must be in a shape for decisions makers
  2. The following are key points for data warehouse conceptual framework
    1)The senior management committed to data ware housing
    2)The board will be involved in decision making
    3)Satisfaction always collated with the quality of data
    4)Most stack holder considered their investment to be justified
    5)The reporting and analysis tools presents the clear and concise view benefits generated by business decision


Abbott, J. (2000), Data data everywhere and not a byte of use’’, Qualitative Market Research: An International Journal, Vol. 4 №3, p. 182.

Daffy (1996), Once a Customer, Always a Customer, OakTree Press, Dublin.Networks IT Marketing (2002), Data warehousing and business intelligence in the UK’’, Spotlight,sponsored by IBM.

Stone, M. and Woodcock, N. (2001), Defining CRM and assessing its quality’’, in Foss, B. and Stone, M.(Eds), Successful Customer Relationship Marketing,Kogan Page, London

Data Prophet

We have history of million years

Medium is an open platform where 170 million readers come to find insightful and dynamic thinking. Here, expert and undiscovered voices alike dive into the heart of any topic and bring new ideas to the surface. Learn more

Follow the writers, publications, and topics that matter to you, and you’ll see them on your homepage and in your inbox. Explore

If you have a story to tell, knowledge to share, or a perspective to offer — welcome home. It’s easy and free to post your thinking on any topic. Write on Medium

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store