Looking for a Tutor Near You?

Post Learning Requirement »
x

Choose Country Code

x

Direction

x

Ask a Question

x

x
x
For better view click here
x
Hire a Tutor
DISCOVER

Presentation On Data Warehouse

Loading...

Published in: DBMS & RDBMS
16,043 Views

Data warehouse is one of resources for any project. ETL method define total architecture and uses. Data warehouse is processed for business decisions, reporting and analysis.

Bindiya 7 / Jaipur

15 years of teaching experience

Qualification: M.Sc (Rajasthan College of Engineering for Women (RCEW), Jaipur - 2003)

Teaches: Handwriting, Personality Development, Advanced Excel, Basic Computer, GST Training, MS Office, School Level Computer, Tally ERP 9, CA - IPCC, Computer Science, IT & Computer Subjects, B.Ed Tuition, BA Tuition, BCA Tuition, IT, M.Sc Tuition, Big Data & Hadoop, Cloud Computing, Data Structures, DBMS & RDBMS, PL/SQL

Contact this Tutor
  1. CRM Billing ERP Data Warehouse Data:- Raw Facts Ware House:- Godown Data Ware House Reporting Analytics Business Decisions
  2. Questions raise in our mind when we want to start any new business or work in existing one:- QI Is our business gives us profit? Q2 How we manage our goods(raw and finished)? Q3 How does the data we have today compare with the same set of data this time last month, or last year? Q4 How much quantity we have to store in our godown for any festival or occasion?
  3. Yes! We have a answers all these questions. Data Warehouse l)lt is not a new concept, but method is new. Successful storing method of our important data. 2)These data gives us best decision making power and make our business intelligent.
  4. Definition of Data Warehouse A data warehouse is constructing by integrating data from multiple heterogeneous sources that support analytical reporting, structured and queries, and decision making.
  5. Examples of Data stored In Data warehouse The data stored in the warehouse is uploading from customer information from a company's point-of-sale, information collected for a research paper, Qualitative data, Quantitative data, marketing or sales data, aeronautic Data ,weather data, Law and regulations etc. Now! we fully understand that leverage the data we are collecting has become more and more apparent.
  6. Using Data Warehouse Information 'Production Strategies — Repositioning and managing the product portfolios by comparing the sales quarterly or yearly. 'Customer Analysis —Analyzing the customer's buying preferences, buying time, budget cycles, etc. 'Operations Analysis relationship customer management, making environmental corrections and analyze business operations.
  7. 'A data warehouse provides a centralized view of all data being collected across the enterprise and provides a means for determining data that is inconsistent. 'By having a data warehouse, snapshots of data can be taken over time. This creates a historical record of data, which allows for an analysis of trends. These all area where we use data warehouse. Now ! We discuss about tools and utilities.
  8. Tools and Utilities of Data Warehouse The following are the functions of data warehouse tools and utilities 'Extraction — Involves gathering data from multiple heterogeneous sources. 'Cleaning — Involves finding and correcting the errors in data. 'Transformation — Involves converting the data from legacy format to warehouse format.
  9. 'Loading Involves sorting, summarizing, consolidating, checking integrity, and building indices and partitions. 'Refreshing — Involves updating from data sources to warehouse. Data cleaning and transformation are important steps in improving the quality of data. All data loaded into the data warehouse would have to be converted to use this standard format is called Extraction-Transformation-Load (ETL).
  10. Designing a data warehouse Bottom-Up Approach Finance Marketing Sales Data Ware House Accounts Management The Bottom-Up Approach creating small data marts, to solve specific business problems. As these data marts can be combined into a larger data warehouse.
  11. Top-Down Approach Finance Data Ware House Marketing Production Accounts The Top-Down Approach suggests that start by creating an enterprise-wide data warehouse and then, as specific business needs are identified, create smaller data marts.
  12. Summary These data warehouses assemble data from different areas of business, maintain the integrity of facts and dimensions. So, we can look up the information we need across our systems. In this lesson we learn Data warehouse, meaning, uses, tools, utilities and design. Data recourse are one component of Information system.

Need a Tutor or Coaching Class?

Post an enquiry and get instant responses from qualified and experienced tutors.

Post Requirement

Related PPTs

Upload PPTs

If you have your own PowerPoint Presentations which you think can benefit others, please upload on LearnPick. For each approved PPT you will get 100 Credit Points and 100 Activity Score which will increase your profile visibility.

Upload Now
Home > PowerPoint Slides > Presentation On Data Warehouse