Random Information on BI #Data Warehouse #Data Warehouse – 001 #Data Warehouse #Data Warehouse Misc

  • Real internet money/business lies in B2B not in B2C.
  • Decision Support System (DSS):
    • Full spectrum of systems that allow/help management to take decisions, such as, reporting, OLAP, data mining.
  • Java provides support for web enabled DSS
  • JDM is Java’s Data mining/BI API.
  • BI Applications: Balanced Score-card, Activity Based Costing.
  • Data warehouse elements
    • Operational Environment: Maintains day to day activities. Raw Data
    • Independent data mart: A small data warehouse specific to one topic/area/subject
    • Extraction: Extraction of data from operational systems
    • Extraction Store: Data storage after extraction
    • Transformation and cleansing: Before putting data into the central/main warehouse data needs to be cleaned up
    • Extraction log: Create a log in the transformation and cleansing process
    • External source: Data originated outside the organization is also incorporated into the data warehouse.
    • Data administrator: The person who ensures the quality of data
    • Central Repository: Stores all data and meta-data
    • Meta data: Data about data. Example: the extraction log.
    • Dependent Data Mart: Relies on the data warehouse for the sources of its data
  • Distributed Data Warehouse: Warehouse data is physically distributed across a company’s information infrastructure.
  • Data mining types: classification, and estimation.
    • Classification: categorize customers,
    • Estimation: predict or estimate some numerical value
  • Decision trees: modeling technique helps in deciding. Different alternatives are drawn as paths where nodes represent the selected alternative. edges/paths may carry some probability values as selection/influencing criteria.
  • Neural networks: Try to mimic the work nature of human brain to take a decision.
  • General modeling: Well-suited for categorizing.
  • Balanced Scorecard application: views the health and well-being of the organization by more than its financial data. We need to define: Vision, Strategy, Strategic themes, Strategic Objectives, Key performance indicators.
  • Activity based costing application:
  • Three types of organizations:
    • Engineer driven: They know how to make a product. Than sales it through sales force.
    • Sales Driven: They know how to sale a particular product, then make the product and sell it.
    • Customer driven: They Know what customers want, then make the products and sale them. Customer driven organizations are the most successful.

From: http://sitestree.com/?p=3567
Categories:Data Warehouse, Data Warehouse – 001, Data Warehouse, Data Warehouse Misc
Tags:
Post Data:2016-07-04 15:22:58

Shop Online: https://www.ShopForSoul.com/
(Big Data, Cloud, Security, Machine Learning): Courses: http://Training.SitesTree.com
In Bengali: http://Bangla.SaLearningSchool.com
http://SitesTree.com
8112223 Canada Inc./JustEtc: http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning)
Shop Online: https://www.ShopForSoul.com/
Medium: https://medium.com/@SayedAhmedCanada