Prepare a depiction of an analytics data environment typical to an online retail

Question

Prepare a depiction of an analytics data environment typical to an online retailer. Include a data warehouse repository that depicts various sources of available data. Also include at least one data mart that is sourced at least in part from the data warehouse.

Source Data Systems: Identify at least two source data systems that are typical to an online retailer and that might be useful to a data mining initiative to better understand the retailer's customers.

Data Warehouse: Describe the contents of a data warehouse typical to an online retailer, emphasizing sources (transactional system, supply chain management system, etc.) and data subject areas (sales, customer, supply, etc.).

Data Mart: Identify the benefits and limitations of a data mart that is sourced from the warehouse to support customer analytics for a typical online retailer.

External Data: Identify a source of external data a typical online retailer might wish to include in a customer analytics data mart. What benefit is gained by the addition of this external data? What challenges are presented by the integration of this external data source?

*Answer must be at least one page long.

Explanation / Answer

Solution: -

PART A: - Identifying two sources of data system that are typical to an online retailer

Business are totally aware of many external sources of data present in the internet and businesses are utilizing this data more appropriately that will transform the understanding of markets, risks, targeted audience and business expansions. Here two sources of data system that are being used by an online retailer:

Part B: - Contents of data warehouse used by online retailer and other sources

With the growing market of the e-commerce retailers are getting bit complexed as the proper utilization of data is equally important. So, data warehouse is an ultimate option that helps in estimation of the future impact on the business.

Part C: - Benefits and limitations of Data Mart

Data Mart are usually the fastest as well as the easiest way in implementing their payback immediately. Data mart are good at building data warehousing.

Benefits: -

Limitations: -

Part D: - source of external data and benefits, a typical online retailer might wish to include in a customer analytics data mart

Since these are maintained externally, some those data can be untrusted data, and it may cause a huge loss to the business. May be the impact will be much more in case of any security threats. As each and every data of these organizations are highly sensitive and a business can’t risk those, so there may be high probability of data leakage as these external sources uses huge amount of data.

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects