Automate Power BI Trend Dashboard
Budget: ₹1,500 – ₹12,500 INR
I need a Power BI dashboard that automatically updates with new monthly Excel files. The dashboard currently uses one month of data, and I'll be adding files monthly.
Requirements:
- Use a folder as a data source.
- Maintain a trend analysis, month over month.
- Handle a combination of consistent and variable columns/headers in Excel files.
- Leverage a month-year based naming convention for file recognition.
Ideal Skills:
- Proficiency in Power BI
- Experience with Excel data integration
- Familiarity with folder-based data sources
- Strong attention to detail for variable data structures
Please provide examples of similar work done.
Requirements:
- Use a folder as a data source.
- Maintain a trend analysis, month over month.
- Handle a combination of consistent and variable columns/headers in Excel files.
- Leverage a month-year based naming convention for file recognition.
Ideal Skills:
- Proficiency in Power BI
- Experience with Excel data integration
- Familiarity with folder-based data sources
- Strong attention to detail for variable data structures
Please provide examples of similar work done.