Using the Practice$\_$Data attached to this Assignments tool:

$1.$Load data from all tabs into Power Query, preprocess the data and save as connection only.

$2.$Create a data model by adding this data to the Power Pivot data model.

$3.$Using the connection$-$only query as a reference:

a$.$ Using the Statistics function to determine the highest amount owed.

b$.$ Apply new discounts to new customers and calculate the "New YTD Balance for Q$1"($refer to the "read me$"$ sheet for a series of calculations$).$

c$.$ Calculate the average and median of the $"$YTD balances" owed by customer status.

d$.$ Split the Account ID column by the number of characters$/$positions; determine the count of Regular, High Risk, Government Affiliate, and Premium customers, respectively, and display YTD balances owed in each category.

e$.$ Determine the total amount lost by the company as discounts during this period.

f$.$ Identity customers that purchased additional licenses during the period and specify the associated products.

$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 answers.