Đang Thực Hiện

Excel Task

The task is the following

Create an Excel dashboard to analyse international sales of electronic devices. Use the data of a fictional company called Contoso. Contoso supplies consumers with eight different types of electronic goods in four sales channels. Examine sales over time and per product type. What conclusions can you make regarding your company's sales? Make suggestions on how to prioritize sales channels. Use Excel Power Pivot Add-in for analysis, as the data is in the [login to view URL] file repository.

1. Learn about the data warehouse in [login to view URL] file that contains the sales data of the fictitious electronics company Contoso. Study the contents of the tables.

2. How does the sales volume change by sales channel and quarterly?

3. Display sales data based on different timeframes, using slicers. What do you think about the 2007-2009 period?

4. How do sales change by product category and quarterly?

5. Show additional sales figures by using more slicers. What do you think about the 2007-2009 period?

6. Apply a perspective within the extension. Justify your choice.

Make a report on the completed analysis and upload it along with the calculations to the available online learning management system. The formal requirements of the report are the following: 5-10 pages long, presentation of your findings and conclusions with illustration.

Source file: [login to view URL]

The project assessment method is published in the LMS system.

1. task 1 point Activating Power Pivot, exploring the data warehouse

2. task 2 points Making a Power Pivot table and chart

3. task 2 points Adding slicers

4. task 2 points Making a Power Pivot table and chart

5. task 2 points Adding slicers

6. task 1 point Creating a perspective

You can find information about the extension here:

Microsoft (2018) Start the Power Pivot add-in for Excel. Available from: [login to view URL] [Accessed: 5th January 2018]

Microsoft (2018) PowerPivot for Excel Tutorial Introduction. Available from: [login to view URL](v=sql.110).aspx [Accessed: 5th January 2018]

Microsoft (2018) Power Pivot: Powerful data analysis and data modeling in Excel Available from: [login to view URL] [Accessed: 5th january 2018]

Kĩ năng: Phân tích kinh doanh, Nhập liệu, Xử lí dữ liệu, Excel, Research Writing

Xem nhiều hơn: excel task tracker template xls, weekly task list template excel, how to create a task tracker in excel, employee task list template, project task list template excel, daily task list template for work, excel task tracker dashboard template, excel task tracker template, online store csv upload, advanced excel test 2003 free online, online adult video upload, online commerce product upload, online flv converte upload, online jobs 2009 upload videos, vba excel task mapping sheet, online makeover games upload picture, online conveter flv upload, access vba excel task manager simple, online flv mp3 upload, free online ftp mass upload

Về Bên Thuê:
( 1 Nhận xét ) Budapest, Hungary

ID dự án: #19278455

Được trao cho:

souravind8

Dear Employer, We will you the best result by using my experience and academic skills on your project. You can chat with me and let’s get started. I’m ready to show you samples of similar project I’ve completed. Tha Thêm

€8 EUR trong 1 ngày
(0 Đánh Giá)
0.0

11 freelancer đang chào giá trung bình €17 cho công việc này

sn66

Hello, I am highly interested in this excel work. Can you please initiate chat to discuss further your project. So, I can start immediately. Regards, Salma Noreen

€28 EUR trong 1 ngày
(27 Nhận xét)
4.4
waqarkhattak07

Sir i hope you would be fine and having a good day. i can help you with your project As i have done it before Sir i assure you of 100% work and maximum [login to view URL] inbox me for further details. Thank You

€19 EUR trong 2 ngày
(0 Nhận xét)
0.0
thedarkhuman

Hello sir this is Darkhuman

€8 EUR trong 1 ngày
(0 Nhận xét)
0.0
Thahazakirh

Expert in Ms excel Relevant Skills and Experience Experience in Ms excel and typing

€23 EUR trong 3 ngày
(0 Nhận xét)
0.0
nisarahmed57786

Hi, I am looking for the project you have launched.I have related an experience of data entry. I am ready to complete the task. Would you like to discuss on chat. Thanks, Nisar

€8 EUR trong 1 ngày
(0 Nhận xét)
0.0
MrAnkhalifa

.......................................................................................................................................................................................................................... Thêm

€12 EUR trong 1 ngày
(0 Nhận xét)
0.0
akshayovhal215

Hiii I Have Work in Excel Previous 10 Year So Please give me this Opportunity. Regard's Satish Jagtap

€19 EUR trong 1 ngày
(0 Nhận xét)
0.0
furqanfazal12

Project will be completed on the time given.

€24 EUR trong 2 ngày
(0 Nhận xét)
0.0
rk8515024

SIR i am new freelancer and i am finishing my computer classes yet before 5 month ago and i am very gland to do your work.....i not say i am the best but i will try my best.

€12 EUR trong 5 ngày
(0 Nhận xét)
0.0
vempatisai

I'm think I'm able to do this work which you expect that

€23 EUR trong 5 ngày
(0 Nhận xét)
0.0