logo Use SA10RAM to get 10%* Discount.
Order Now logo

Ask This Question To Be Solved By Our ExpertsGet A+ Grade Solution Guaranteed

expert
Deborah AustinMathematics
(5/5)

546 Answers

Hire Me
expert
Natalia GCriminology
(5/5)

534 Answers

Hire Me
expert
Hemidov MuradManagement
(5/5)

534 Answers

Hire Me
expert
Paul BurlinggComputer science
(5/5)

803 Answers

Hire Me
Microsoft Excel
(5/5)

In this project, you have to create a Dashboard in Excel. A dashboard is a consolidated display of many worksheets

INSTRUCTIONS TO CANDIDATES
ANSWER ALL QUESTIONS

Excel Project

Guidelines

1. This project is mandatory to be submitted.

2. Submit the project before the deadline. Otherwise, it will result in

minus marking or cancellation of the assignment.

3. If anyone fails to submit the project, he/she may lose an opportunity for good

placement.

4. If we find anyone who has copied or submitted the same assignments. It will

result in the cancellation of submission or -10 Marks will be allocated to the

students.

5. You can use any type of Dataset.

6. The project Dataset should contain at least 300 rows and 8 columns.

7. Try to make it more creative and attractive so that you can use it in your

Resume, LinkedIn, Kaggle, or GitHub.

8. Research the project on the internet.

9. In this project, you have to create a Dashboard in Excel. A dashboard is a

consolidated display of many worksheets and related information in a single place.

It is used to compare and monitor a variety of data simultaneously. The different

data views are displayed all at once.

Dashboard Should Contain:

1. At least 10 -15 Problem Statements related to data.

2. Depending upon the Problem Statements you have to create different Charts.

3. Make a Dynamic Dashboard

4. Everything related to Chart should be well explained.

Steps to do the Project

1. Choose any Topic.

2. Find the Dataset for it.

3. Seek some knowledge about how to make a more attractive Dashboard with

additional functionality (if any) in Excel from the Internet.

4. Analyze the Dataset, and find the problem statement related to it.

5. Start building your Dashboard according to Problem Statement.

6. After the Project completes making a video explaining your Project and conclusion

(max 2 min). The video should be in a presentation format.

Video Format: http://bit.ly/2m8bxlP

● How to make Google Drive Folder Public: http://bit.ly/2m2Jkws

8. Prepare your Project report including:

● 1 slide on Problem statement and source of data.

● 1 Executive Summary slide explaining the outcome/results of the Analysis

● Basic Analysis slides (charts and visuals to be used mandatorily)

● Conclusion and Next Steps

● Excel file containing the detailed analysis

Data can be downloaded from the following links –

● https://data.gov.in/catalogsv2

● https://www.kaggle.com/datasets

9. Upload the Project Report and Excel File.

Marks Division

● Completion of the Project

● Conclusion of the project

● Project File

● Attractiveness of Dataset

● Cleanliness

What is a Dashboard and how it is created? (Reference Videos)

● https://www.youtube.com/watch?v=RM8T1eYBjQY

● https://www.youtube.com/watch?v=rBuiBNZWj

(5/5)
Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme

Get Free Quote!

328 Experts Online