Hello there,
Please make sure you read the following and go through the data and instructions before anything. I do not have time to make another order and I need this to be done ASAP.
I need this assignment done please. It must contain dashboards, charts, graphs, ppivot tables, etc with the provided data. You may add an extra sheet to organise the data in a way that makes it wasier to work with.
The dashboards must incude:
at least three data points for the ‘Daily Outlook’ portion of your dashboard.
at least five data points for the ‘Monthly Outlook’ section of your dashboard.
use data validation to allow selection via a drop-down list of the day (“Daily Outlook” section).
use slicers to allow selection of the month (“Monthly Outlook” section)
your dashboard can have more data points and summarised details if you want.
You must also demonstrate:
Conditional formatting (use of a formula to color a row based on a cell within that row).
Basic functions (for example, SUM, MAX, MIN, COUNT).
Searching functions (XLOOKUP, VLOOKUP, INDEX, or similar).
Conditional functions (IF, COUNTIFS, etc).
Please make sure to use slicers, charts, conditional formatting, pivot tables.
Once the excel part is done, a user guide is needed.
Include in the user guide:
Title Page and Table of Contents
Introduction: Briefly outline the report’s purpose.
Dashboard Overview: Explain key design choices, highlight main components (from a user’s point-of-view), and provide clear instructions for user navigation, interpretation, and interactivity. Include relevant images of your dashboard screens when explaining your dashboard (from a user’s point-of-view).
Challenges and Limitations: Acknowledge data and dashboard limitations.
Future Developments: Propose potential enhancements and revisions you would like to see in the next version.
Conclusion: Summarise main points and provide recommendations.
References & Appendix: Include references and technical details or calculations used to inform the development of the dashboard if applicable.
The report should be tailored for a non-technical audience.
I will add screenshots of an idea of a few dashboards required. Note: that will be a lttle example of what I need. The months should be written out, unlike the example. It is shown as numbera 1-12, however, please make sure it is Jan, Feb, Mar,……, Dec. Same thing with the Station Numbers, please make sure it is the location not the station numbers.
This is a simple assignment, shouldn’t be too dfficult if you know what your’e doing. Writing about 500 words and a few dashboards and charts.
I will make sure to tip $20 once I recieve my grade, if my work is given a high / pretty good grade.
Once the work is done, I cannot have the excel as a pdf, I need to be able to use the drop down and the tables and charts as well as edit them, but I am not sure how you will be able to share it with me. Please message me regarrding this matter.
Thank you
