Module 2 Data Profiling

What problems can the following excel tools solve in acccounting? Pivot tables:  Conditional formatting:  Data Analysis and Formulas:  Data Visualization (Charts & Graphs):

Identifying the condition of the data is part of which task?   A. Performing a data audit B. Performing extract, transform and load (ETL) C. Performing data analysis D. Conducting a data assessment

In the AMPS model, what step immediately precedes Performing the Analysis?   Multiple Choice   Master the Data   Mine the Data   Share the Story   Ask the Question

POS stands for Point of Sale. List the benefits they have over traditional data collecting methods.

Compare and contrast the difference between the retrospective analytics approachand the predictive analytics approach to data analytics.

2.

Summarizing data to understand what has happened is what type of analytics?   Multiple Choice   Predictive analytics   Diagnostic analytics   Descriptive analytics   Prescriptive analytics

What are POS Systems? Enumerate their advantages versus manual data collection systems.

Why is data quality so crucial to data warehousing? List excellent data's advantages and indications.

How can spreadsheet software, such as Excel, help with sensitivity analysis?

Based on your findings, do you recommend adopting Data Analytics or waiting for further research?

What challenges that may arise during implementation of Data Analytics?

6

In a dataset, what does the term 'imputation' refer to? a) Removing irrelevant features b) Handling missing data by substituting values c) Splitting the dataset into training and test sets d) Standardizing the data range

a. Definition of Sensitivity Analysis b. Discuss the Purpose and Application in Linear Programming.

Identify the factor that affects the faithful representation. a. Efficiency of computer systems b. The condition in the economy c. Level of measurement uncertainty d. Level of incompleteness

The Value of Data Visualization,  share your thoughts on what you learned about creating effective data visualizations and how important it is