Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using the Practice_Data attached to this Assignments tool: 1. Load all tabs with data to power Query, pre-process the data, and save as connection-only 2.
Using the Practice_Data attached to this Assignments tool: 1. Load all tabs with data to power Query, pre-process the data, and save as connection-only 2. Create the Data Model 3. 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 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. Present your answers in a Microsoft Word document with Screenshots of all your tables, queries and data model
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started