Part $1$:

Submit the screenshot of the completed Power BI Module.

Part $2$: Data Assessment Questions

Using the attached "Financial Data Set", complete the following fixes and provide answers to the questions.

Describe the way$($s$)$ that the data set does not comply with "tidy data" principles. How would you prepare the data so that they were tidy for analysis? Apply the fix you describe to the data set.

Describe other problems with the data and the associated fixes for them. Apply these fixes to ensure the data are clean.

In an interview with the head of the Channel Partners segment, you learn that they code their sales data on a fiscal$-$year basis rather than a calendar year, as the other segments do$.$ Prepare the data such that all segments, including Channel Partners, report their sales data on a calendar$-$year basis.

Are there any unusual values in the data set for the variables Units Sold, Sales Price, Manufacturing Price, or Gross Sales? If so$,$ what is the unusual value. Explain how to deal with any unusual values for purposes of preparing the data for analysis.

Calculate the correlation between $($a$)$ the units sold and profit and $($b$)$ sales price and profit. Which is more strongly correlated to profit, units sold or sales price? Provide an explanation with support.

Part $3$: Cleaned Data Screenshot

Provide a screenshot of your fixes from Part $2.$

Part $4$: Data Quality Control Analysis

In $250-500$ words, answer the following:

Discuss the impact data quality control can have on data analysis.

Describe data controls or other processes that could have prevented the data issues identified in Part $2.$

In your discussion, elaborate on the role and responsibilities of the business analyst in data quality control.

For an issue such as the one identified in Part $2$ number $3,$ is it important that each segment within the company use consistent measurement for the year or are differences in segments tolerable?

What considerations would you suggest that the Channel Partners segment head keep in mind when making decisions about whether to record sales on a fiscal$-$year or calendar$-$year basis?

There was no screen shot attached?