Introduction
~context~
Business Dashboard Part 1
Excel Data Analysis and Excel Data Visualization with Excel Pivot Tables, Formulas, Pivot Charts and Excel Dashboard

         The importance of having a budget while launching a business was stressed during Week 7. We were able to keep tabs on our earnings and expenditures thanks to our well crafted budget. Keep in mind that the goal of any budget is to have spending that are less than revenue. The full potential of Excel, however, has not been utilized until now. In this guide, you'll learn how to set up a dashboard in Excel for monitoring KPIs and other metrics. When you're done with this task, you'll have an Excel tool that would be the envy of any company and could save you thousands on hiring a developer to implement the same features.
Creating a Business Dashboard in Excel
An Excel Dashboard can be an amazing tool when it comes to tracking ​Key performance indicators (KPIs), comparing data points, and getting data-backed views that can help management make decisions. In this tutorial, you will learn how to create an Excel dashboard, best practices to follow while creating one and features and tools you can use in Excel.

KPIs are used to quantify a business's success in comparison to a set of targets, objectives, or industry peers. Financial KPIs include net profit (or the bottom line, gross profit margin), revenue less specified expenses, and the current ratio (liquidity and cash availability)

Note: Direct all questions to your Discord channel.

Submission Requirements

The following steps must be completed to receive the associated points for each step.
Any item marked with a * must be completed to receive a score above 0.

01

Follow the tutorial

-

By completing the tutorial, you would be  fulfilling all the requirements listed:

Download the Excel Dashboard data sheet listed in the resources area.

Review the excel data sheet provided in the resources area.

Add the 5- 6 questions to the Excel Dahsboard Sheet as shown in the tutorial listed in the resources area.

Add three screenshot images of 
dashboard examples you found online that best represents your business data .

Follow the tutorial listed in resources area and ​Download
Dashbaord Data Sheet.

25 points

02

Create Tabs & Folders

-

Create a document with your business name, a short description of what the business does or will do, and a short description of the type of product or customer data your business will be interested in using.  

I nclude your dashboard wireframe to a new tab on your worksheet as shown in the tu to rial. Make sure to name the tab "Wireframe"


Write the  six questions listed in the tutorial on the tab (worksheet) named "Main dashboard questions".

Create a new tab  and name it "Example Dashboards". Include 3 images of example dashboards you selected online.

Create a project folder on your Google drive or a cloud drive of your choice.

Make the folder sharable with a link for all.

Make sure to name the tabs exactly as the requirements mention above.

*

03

Submit the assignment

-

Upload your completed assignment to your project folder.

Submit your Google drive or cloud storage link to the Canvas

Upload a screenshot of your wireframe to the CIT 101 discord channel.

Include a screenshot image showing your Discord submission in your project folder.

Note:  If you decide to complete this assignment as a group, you must create a simple contract stating what each member will be responsible for.
The advantages of doing this project as a group are that the project's tasks can be spread out, and the team can turn in the same link. Please check with students on discord to understand how the contracts must be created. Forming a group is an option in this assignment and not a requirement.


ALERT: ​Any item marked with a * must be completed to receive a score above 0.

*

25 Points

Total Points if all the above steps are completed and submitted.

5u

5 unit credits when you receive 100% for all assignments in this pipeline.