Multi-Office Excel Dashboard Creation
Budget: $750 – $1,500 AUD
I am seeking a skilled data analyst to create a comprehensive dashboard from multiple Excel sheets that compiles data from various office locations. This dashboard will be used primarily for trend analysis, with a focus on sales figures and operational efficiency.
Key Responsibilities:
- Consolidate data across multiple tabs into a single spreadsheet
- Identify and visualize month-on-month trends
- Use pivots, charts and PowerBI for data representation
- Create a state and national overview that updates with each new monthly data set
Ideal Candidate:
- Proficient in Excel, PowerBI and data visualization techniques
- Experience with trend analysis
- Ability to categorize data by office location
Non-disclosure Document is required for data security and privacy
The goal is to have a dynamic and visually engaging dashboard that supports our understanding of our performance across different locations over time.
I will happily show you what is currently being updated weekly/monthly so you can design.
Key Responsibilities:
- Consolidate data across multiple tabs into a single spreadsheet
- Identify and visualize month-on-month trends
- Use pivots, charts and PowerBI for data representation
- Create a state and national overview that updates with each new monthly data set
Ideal Candidate:
- Proficient in Excel, PowerBI and data visualization techniques
- Experience with trend analysis
- Ability to categorize data by office location
Non-disclosure Document is required for data security and privacy
The goal is to have a dynamic and visually engaging dashboard that supports our understanding of our performance across different locations over time.
I will happily show you what is currently being updated weekly/monthly so you can design.