Data handling in an organization - Analytical Questions

This article discusses data handling in an organization, including the types of data collected, the use of technology, data mining, query and reporting tools, and data warehouses. It also provides references for further reading.

Running Head: ANALYTICAL QUESTIONS 0
Analytical Questions
Data handling in an organization
(Student Details:)
23-Sep-18

Analytical Questions 1
Contents
Solution: 1........................................................................................................................................2
Solution 2:........................................................................................................................................2
Solution 3:........................................................................................................................................2
Solution 4:........................................................................................................................................3
Solution 5:........................................................................................................................................3

Analytical Questions 2
Analytical Questions
Solution: 1
Our Organization ‘donhauefavret contractors’ collect data being a commercial general
contractor for various sector organizations such as restaurants, corporate offices, educational
buildings, medical office buildings, retail shopping centers and hospitality. This company is
having its own Global information system (referred as GIS), which is an asset in providing high
quality services and data to its clients. This data is helpful in providing construction management
services, design building as well as pre-construction services of the above organizations.
Following kind of data, our company collects:
 Customer, enterprise and supply chain data through Soft wares like CRM, ERP and SCM.
 Surveys data for supplementing operational data of the firm
 Firm’s Operational data through Data acquired from External sources which can be used
for providing the firm competitive edge.
 After above data collection, data will be converted into information and knowledge
subsequently to use for the organization functions (University of Lousiana, 2018).
The organization uses this data to approach the big customers for improved commitments in
global purchasing through negotiating lesser prices in exchange. This will further improve
manufacturing capacity, labor conditions (Harvard Business Review, 2018).
Solution 2:
If our company could implement new technology to collect data then it could have machine
learning data through high sample rate sensors which will further help in following areas:
 To overcome variation of data due to collection equipment errors.
 To collect real-time data efficiently (Youtube, Machine Learning, 2018).
 To give accurate predictions in the real market.

Analytical Questions 3
 Data mining tool of artificial intelligence which contains Expert systems and genetic
algorithms is can be used as a novel technology (Youtube, Machine Learning, 2018). The
data analytics will leverage the firm in competitive advantage, by providing real strategic
tool for boosting performance and surging sales through tracked transactions as well as
increased insights within an organization.
Solution 3:
After collecting data, utilizing it for specific purpose is also a challenge so Data mining is
used to explore data in order to find hidden patterns to build large data models.
There are different ways to collect data for data ware houses are:
 Flat files
 Documents and previous work files
 Databases of different local and government organization (University of Lousiana, 2018)
Customer segmentation, marketing targeting, promotion targeting, market basket analysis,
collaborative filtering, and moreover fraud detection as well as financial modeling can be done
for implementing collected data (Kimball & Ross, 2011).
Solution 4:
Query and Reporting tools are very useful in business intelligence, for an example Canned
reports give regular summaries of data information in a well-organized format to request data,
select, sort, calculate, compare the data whenever needed. Ad hoc reporting tool is also used for
creating reports to analyze fields, ranges and some critical parameters (University of Lousiana,
2018). Dashboards are useful to display critical indicators, providing graphical analytical data in
order to analytical data application. A competent business analytics should be driven through
three major elements:
 Business knowledge
 Business statistics
 Information technology (University of Lousiana, 2018)

Analytical Questions 4
Solution 5:
Data warehouses and data marts are the hub of large amount of transactional data utilized
for analytics and reporting functionality of the company.
Data warehouse is delivers enhanced reports for business intelligence. There are lot of
advantages of data warehouse, such as saves time, data quality, consistency, and integration of
data. Data warehouse provide large amount of historical data (Harvard Business Review, 2018).
Basically, data warehouse work on data collected from different resources. Data
warehouse extract the data from different resources like flat files and databases. After extracting
the data from different resources, it is transformed in a same format and loads that data in data
warehouse for different type of processing, such as online transaction processing and online
analytical processing. OLAP and OLTP both are so useful for business intelligence (Kimball &
Ross, 2011).
Source: (Last Night Study, 2018)

Analytical Questions 5
References
Harvard Business Review. (2018). Artificial Intelligence. Retrieved from University of Lousiana:
https://moodle.louisiana.edu/pluginfile.php/1679981/mod_resource/content/1/
ArtificialIntelligence.pdf
Kimball, R., & Ross, M. (2011). The data warehouse toolkit: the complete guide to dimensional
modeling. London: John Wiley & Sons.
University of Lousiana. (2018). Textbook on imformation systems. Retrieved from University of
Lousiana: Textbook :
https://moodle.louisiana.edu/pluginfile.php/1679978/mod_resource/content/3/11-
Information-Systems-A-Managers-Guide-to-Harnessing-Technology.pdf
Youtube. (2018). Artifical Intelligence. Retrieved from Youtube: https://youtu.be/t4kyRyKyOpo
Youtube. (2018). Machine Learning. Retrieved from Youtube: https://youtu.be/bHvf7Tagt18