Using the Practice_Data attached to this Assignments tool:

Load all tabs with data to power Query, pre-process the data, and save as connection-only Create the Data Model Using the connection-only query as a reference:

a. Create a calculated field called "Actual Balance" and apply new customer 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 customers that bought additional licenses during the period and for

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. Present your answers in a Microsoft Word document with Screenshots of all your tables, queries and data model.