Describe the four steps in data preprocessing

Assignment Help Basic Computer Science

Reference no: EM133398179

Assignment:

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 premium discounts

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

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

c. Split the account ID column by left-most delimiter, 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. Present your answers in a Microsoft Word document with Screenshots of all your tables, queries and data model.

Reference no: EM133398179

Questions Cloud

Discuss the rationale for administration of erythromycin : Discuss the rationale for administration of erythromycin ophthalmic ointment at delivery. What is the dose and route of administration?

Describe how epidemiological data influences changes : Describe how epidemiological data influences changes in health practices. Provide an example and explain what data would be necessary to make a change

Legal authority to create laws : Primary authority refers to any authority that is created by a legislative or judicial body or a government agency that has the legal authority to create laws

Applying developmental theory based on erickson : Describe the different physical characteristics/findings within the school-aged child. Explain how you would modify assessment techniques

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

Address these issues and prevent them in the future : find articles related to healthcare fraud, waist, and abuse in the U.S. and it impact on health care costs and provide 4 suggestions to address these issues

Describe three treatment strategies for the disorder : What challenges could arise in carrying out these strategies and providing care to the patient? What interventions could be utilized in order to overcome these

Depriving third-country national of right of residence : Does Article 20 TFEU preclude a Member State from depriving a third-country national (TCN) of the right of residence

Economic factors that should be taken into consideration : economic factors that should be taken into consideration when planning teaching and learning. Which of the following is NOT a social determinant of health

User Account

All Pages