Using the Practice Data attached to this Assignments tool:

1. Load all tabs with data to power Query, pre-process the data, save as connection only

2. Create the data Model

3. Using the connection only query as reference:

a. Create a calculated field called "Actual Balance" and apply "new" discounts

What is the total balance now? What is the average, and median of the "actual balances" owed

b. Using the Statistics function what is the highest amount owed

c. Split the account ID column by # of characters/by positions, How many Regular, High Risk, Government Affiliate and Premium customers does the company have respectively? & Show balances owed in each category

d. Identify customer that bought additional licenses during the period and for which products

e. How much in total did the company lose as discounts during this period?

4. Describe the four steps in data preprocessing and explain how/if they apply with the practice data set you are working with.

5. Please provide your responses in a Microsoft Word document, including screenshots of all your tables, queries, and data model. Additionally, please submit your excel file along with the Word document.