Wrangling & exploring data

Wrangling & exploring data - caseys carwash

Assignment Help Financial Management

Reference no: EM134010309

Analytics in Accounting and Finance

Assessment Title: Wrangling & Exploring Data - Casey's Carwash

Your Task
You are required to wrangle data provided for a business. This will involve cleaning, structuring and standardising data in an Excel worksheet. Concepts related to Accounting and business data handling may assist in understanding the assessment requirements.

You will then be asked to draw on your updated dataset data to answer a series of questions.

Assessment Instructions

You will be provided with an Excel workbook file containing numerous worksheets which contain a raw records table, customer master record, data rules and the questions you are required to answer. A separate worksheet is provided for you to provide responses to the questions asked.

Caseys Carwash.

Familiarise yourself with the assessment instructions and questions shown in the "Questions" worksheet.

Data Wrangling - you will need to use Excel to validate the accuracy and completeness of the data held in both "Customer Master" and "Raw Records" worksheets. You will be required to use Excel to perform corrective tasks to standardise and structure the data - this could include performing counts, splits, joins, vlookups, ifs, averages, substitutes, pivot tables etc. Techniques associated with Data Mining may also support data exploration and analysis tasks.

Data Wrangling - ensure all your workings remain in the Excel file worksheets.

Data Exploring - once you have structured your data, use your updated dataset to answer the fifteen (15) questions shown on the "Questions" tab.

Data Exploring - a separate worksheet called "Answers" has been provided for you to easily provide an answer to each of the questions.

You may use Generative AI to assist in the development of your assessment as per the guidance provided for Level 2 assessment which is outlined on page 5. With respect to the use of GenAI for this assessment:

You CAN:

Use GenAI/ChatGPT to understand concepts, create ideas, and assist in your general understanding of the assessment requirements.

Use the ideas/information generated by GenAI after cross-referencing them with other reliable sources. You must appropriately reference all resources used including GenAI (Referencing). Knowledge of Corporate Finance can also help when analysing accounting and financial datasets.

Reference no: EM134010309

Questions Cloud

Social media posts that mention their brand : What should the brand manager look for when reviewing thousands of social media posts that mention their brand?

Explain underlying organizational challenge to be addressed : Explain the underlying organizational challenge to be addressed. Explain why the case study is of particular interest and relevance.

What are some effective strategies for managing conflict : What are some effective strategies for managing conflict within a team, and when might each strategy be most appropriate?

Role of money in lobbying that affects the legislative : And what about the role of money in lobbying that affects the legislative and other public policy-making processes?

Wrangling & exploring data - caseys carwash : Wrangling & Exploring Data - Caseys Carwash - validate the accuracy and completeness of the data held in both "Customer Master" and "Raw Records" worksheets

Discuss a situation you have experienced : Discuss a situation you've experienced when you made an inaccurate estimation for the duration of some activity.

What have you learned about yourself throughout the course : What areas are your strengths? Where could you improve? What have you learned about yourself throughout this course?

Why is poverty so persistent among african americans : Why is poverty so persistent among African Americans?

Why might it be important to analyze a policy history : Why might it be important to analyze a policy's history?

User Account

All Pages