Exp22_Excel_Ch10_CumulativeAssessment – Movie Rentals
Exp22_Excel_Ch10_CumulativeAssessment – Movie Rentals
Excel Chapter 10 Cumulative Assessment – Movie Rentals
You are the systems manager for Blue City Movies Rentals and you have been asked to create a report on historical sales data. To complete your task you will combine and edit data from multiple sources using Excel’s Power add-ins, XML, and text functions.
Start Excel. Download and open the file named Exp22_Excel_Ch10_CumulativeAssessment-MovieRentals.xlsx. Grader has automatically added your last name to the beginning of the filename.
Use Get & Transform (Power Query) to load the file e10c2Movies.txt to the existing worksheet starting in cell A1. After loading the information to the worksheet, add it to the data model.
Rename the worksheet Movies.
Use Get & Transform (Power Query) to load the Account table from the xml file e10c2Contacts.xml into a new worksheet. Be sure to add the information to the data model.
Rename the worksheet Contacts.
Use Get & Transform (Power Query) to load the Rates table from the file e10c2Rates.xlsx into a new worksheet. Be sure to add the information to the data model.
Rename the worksheet Rates.
Use Get & Transform (Power Query) to load the StoreInfo table located in the database e10c2Transactions.accdb into a new worksheet. Be sure to add the information to the data model.
Rename the worksheet StoreInfo.
Use Get & Transform (Power Query) to load the Transactions table located in the database e10c2Transactions.accdb in the Power Query Editor. Use the Power Query Editor to change the format of the Date column from Date and Time to Date. Load the edited data to a new worksheet, making sure to add the information to the data model.
Rename the worksheet Transactions.
Create a relationship between the Account table Account field and Transactions table Account field.
Create a relationship between the StoreInfo table Store# and the Transactions table Store#.
Use PowerPivot to create a PivotTable and clustered column PivotChart Horizontal on a new worksheet. Name the worksheet TotalEarnings. Use the Transactions table Date field in the Filters area, Account table Type field and Last field in the Rows area, and Transactions table Total field in the Values area.
Add the chart title Total Earnings.
Use 3D Map (Power Maps) to create a geographical visualization of sales data by store. Use the StoreInfo Zip as the location dimension and the Transactions Total as the height dimension. Zoom in as needed to view results.
Save and close Exp22_Excel_Ch10_CumulativeAssessment-MovieRentals.xlsx. Exit Excel. Submit the file as directed.
Try it now!
How it works?
Follow these simple steps to get your paper done
Place your order
Fill in the order form and provide all details of your assignment.
Proceed with the payment
Choose the payment system that suits you most.
Receive the final file
Once your paper is ready, we will email it to you.
Our Services
Custom Writings Help is a Quality-Oriented Company in Online Writing as a result of hiring exceptional professionals to execute clients' tasks.
Essays
At Custom Writings Help,We understand the struggle of research paper writing, and that is why at Custom WritingS Help, we are all out to help you. We pride ourselves on having a team of clinical writers. The stringent and rigorous vetting process ensures that only the 'BEST' Writers are chosen for the job. We have highly qualified Ph.D. and MA writers working with us; we equally offer these experienced writers specific bonuses and incentives to make them deliver highly original, unique, and informative content at reasonably low prices.
Admissions
Thesis Writing Service
Worlwide, Many Masters Students are struggling with Thesis Completion. A thesis is likely to be the longest and most challenging piece of work a student has ever completed. However, unlike essays and other assignments, a student can pick a particular interest topic and work on their initiative. Fortunately, we are there for you. At Custom Writings Help, you are assured of an authentic, imaginative, informative, linguistically great, and advantageous thesis that adheres to all your needs. So, why continue considering different writers when you have discovered the best in the field?
Editing
Custom Papers
Not a single student can avoid writing custom papers. However, a total lack of experience, skills, and time makes it very hard to produce a superb writing piece. Therefore, if you are seeking professional help, turn to us. Our specialized and experienced writers compose a variety of model papers, including custom essays, college term papers, research papers, book reports, MBA essays, executive summaries, dissertations, Ph.D. theses, admission essays, and research proposals for college and university students at any level.
Coursework
Essay Writing
Most of the students disregard the critical principles of essay writing and compose papers below sensible guidelines. Therefore, with Custom Writings Help, one should not worry about his/her essay. Our Writers compose informative and engaging content on all complexities and topics. We write meaningful and smart essays while prioritizing all aspects that bring about a good grade, such as impeccable grammar, proper structure, zero-plagiarism, and conformance to guidelines.
Coursework
Coourse Work Writing
Don't let the seemingly never-ending onslaught of writing assignments get you down. If you are looking where to get course work assistance online, the writers at Custom Writings Help are here to assist you with all of your writing needs. We undertake to unique delivery of papers that meet the professor's requirements. The content is proofread, edited, and checked plagiarism before submission to customers. No matter how big or small your work is, we will deliver on time. Try US Now! !
Coursework
Dissertation Writing Service
High-Quality Dissertation Writing Services are rare. They require Ph.D. academicians – not easily found. However, are an exception. The years, time, and resources we have invested in the dissertation world has given us a competitive advantage over others. Choose to come to Custom Writings Help; You will find perfect Ph.D. consultants who have written hundreds of dissertations theses ready to help you. Let our dissertation-writing services help you craft your dissertation, for you are assured we will give you the results.