![phoenix](https://d1a29h5kxv3oc2.cloudfront.net/dist/img/phoenix.81914efc7207f6a059bd10f5d3fd5f89.png)
Excel dashboard
- or -
Post a project like this2339
$$$
- Posted:
- Proposals: 11
- Remote
- #1877903
- Awarded
Microsoft Certified Power BI Data Analyst & Advance Excel Specialist¦Professional Power BI consultant ¦ (ACCA)- Chartered Certified Accountant ¦ Accounting- Reconciliations ¦DAX ¦Data Models ¦
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
: Data Mining, Internet Research, Lead Generation, Typing, Adobe Photoshop, Photo Editing, PDF Conversion, Data Extraction, logo design
Husband & Wife Team - Software Engineer, Public Relations Guru & Graphics Designer
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
Copy Writer, Web design, Logo Maker, Landing Pages, Sales Pages, Email, Marketing, Click on your ads, Youtube views, write reviews or comments, Do your Maths or Science home work, Free Classifieds,
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
207391614494731990325199154914064161991037112981718209483616757689661576568
![Harry H.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/93540e439933196f77341a1ba7289bc5_70x70.jpg)
![Islam A.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/53b4c035e3aec1d8e81471dedcd326c8_70x70.jpg)
![Ved P.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/2c1e6b28f511cfe8304858fd48d4f727_70x70.jpg)
![James P.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/d639594db2103947551981d2f2555cc2_70x70.jpg)
Description
Experience Level: Expert
I would like to my incident form which has 20 columns to be presented in a Dashboard format.
I want the following things to be done.
Create a Dashboard with the data in bar graphs form showing the following data
1. The number of issues raised by issue.
2. The number of repeat issues.
3. The number of issues by product/platform
4. The count of service affecting (Y/N)
5. The number of issues raised by priority
6. Number of issues resolved at first call
7. Count of repeat issues by product/platform
8. I want to be able to filter the above data by quarter( june, july, august - Q1, Sept, Oct, Nov -Q2, Dec, Jan and Feb -Q3...e.t.c
The most important of all this.
I want the first quarter to be given an index value of 100. For subsequent quarters, the scores are calculated as follows, (Issues on current quarter/issues in Q1) X 100. In this way we can see if the incidents are increasing or decreasing.
Please create a different tab for the Dashboard. Look and feel of the Dashboard is important. I want to be able to affix a logo somewhere on the Dashboard area to look nice (I can affix the logo myself) so create a place for this.
I want the following things to be done.
Create a Dashboard with the data in bar graphs form showing the following data
1. The number of issues raised by issue.
2. The number of repeat issues.
3. The number of issues by product/platform
4. The count of service affecting (Y/N)
5. The number of issues raised by priority
6. Number of issues resolved at first call
7. Count of repeat issues by product/platform
8. I want to be able to filter the above data by quarter( june, july, august - Q1, Sept, Oct, Nov -Q2, Dec, Jan and Feb -Q3...e.t.c
The most important of all this.
I want the first quarter to be given an index value of 100. For subsequent quarters, the scores are calculated as follows, (Issues on current quarter/issues in Q1) X 100. In this way we can see if the incidents are increasing or decreasing.
Please create a different tab for the Dashboard. Look and feel of the Dashboard is important. I want to be able to affix a logo somewhere on the Dashboard area to look nice (I can affix the logo myself) so create a place for this.
![Teju B.](https://www.peopleperhour.com/imgs/default_avatar_light_70x70.png)
Teju B.
100% (2)Projects Completed
1
Freelancers worked with
1
Projects awarded
67%
Last project
3 Oct 2016
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Teju,
Need a sample from your Database to understand where the Dashboard will get the information? (Use dummy data rather than "real" inputs) as it is not clear:
1. How you define "issues" on the Database?
2. How the Dashboard can find whether an "issue" has been repeated?
3. How you show different products and platforms, as it seems you can have different issues on the different formats?
Can you also explain what you mean by "the count of service affecting ?
Look forward to clarification so I can make a sample that works.
582367
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies