Imagine that you are a data analyst consulting with a company that is introducin
ID: 3857548 • Letter: I
Question
Imagine that you are a data analyst consulting with a company that is introducing a new product in the wireless smart home technology sector. You have been asked to design, develop, and implement a data warehouse so the organization can collect information for various, as-yet-undefined data mining projects.
A. Write a detailed proposal for this project.
B. Make three hypothetical sources of data for this purpose. You may use any public database for this purpose. Use an ETL system for formation of this data warehouse, preferably SAS.
C. This proposal should include sections that discuss data modeling; data warehouse architecture and design; construction of the database or databases; and implementation and testing activities.
Submission Requirements
Introduction: An introduction that explains the context of your proposal.
Problem statement: A brief description of the problem or context for the issue you are discussing.
Project description: The specific details of your proposed solution.
Conclusion: A brief summary that recaps the problem and recommended action (implementation of the solution).
Written communication: Written communication is free of errors that detract from the overall message.
APA formatting: Resources and citations are formatted according to APA style and formatting.
Number of resources: Minimum of four resources, cited in APA format.
Length of paper: 8–15 typed double-spaced pages.
Font and font size: Arial, 10 point.
Explanation / Answer
XYZ wireless smart home technology report
The points that are neede to be considered
Data source dor the smart home technology could be brought through the following:
a. House hold usage of electricity
b. Most useful appliances
c. Home automation techniques present in industry
d. Stabilization of product in the industry
e. Market competition for the product
f. Plan of survival in the industry
Above mentioned are basic plans to figure out the need and purpose of the smart home tech sector.
Either for a tech product or a automation method that could be implemented
The datawarehouse that we could consider will contain
1. Data of present automation technologies (Schema-1)
2. People that uses these technology (Schema-2)
3. Our product details (Schema-3)
4. Analysis (For inter-schema comparision)
Data analysis is that study of data that is useful for us. It is more important just not choose the data that is useful,
rather finding out the irrelevant data and making sure that will not impact our business
The whole document could be clearly understood by a scripting language like R/Python,
and could start making some analysis so that it will be helpful of analyzing
business needs.