Automated Data Analysis & Dashboard Development Using Power BI, Python, and Excel
Budget: $10 – $30 USD
We are looking for a skilled freelancer with expertise in data analysis, Power BI, Python, automation, and Excel to help streamline our data processes and create insightful dashboards.
The project involves cleaning and analyzing raw datasets using Python and Excel, identifying trends and key metrics. You will design interactive and visually appealing Power BI dashboards, connecting multiple data sources and ensuring real-time updates where applicable. Additionally, we need automation of repetitive Excel tasks using Python or VBA, along with scripts to fetch, clean, and transform data automatically. The final deliverables should include summary reports with actionable insights, ensuring data accuracy and consistency across platforms.
Required skills include advanced Power BI (DAX, Power Query, visualizations), Python (Pandas, NumPy, automation libraries), and Excel (advanced formulas, pivot tables, VBA is a plus). Experience in data cleaning, transformation, and automation is essential.
The expected deliverables are clean processed datasets in CSV/Excel format, an interactive Power BI dashboard with drill-down capabilities, Python automation scripts if applicable, and documentation on methodology and key findings.
Timeline and budget are open for discussion based on scope. Please share examples of similar projects you’ve worked on, your estimated timeline and budget, and any suggestions to improve this project.
Looking forward to your proposal!
The project involves cleaning and analyzing raw datasets using Python and Excel, identifying trends and key metrics. You will design interactive and visually appealing Power BI dashboards, connecting multiple data sources and ensuring real-time updates where applicable. Additionally, we need automation of repetitive Excel tasks using Python or VBA, along with scripts to fetch, clean, and transform data automatically. The final deliverables should include summary reports with actionable insights, ensuring data accuracy and consistency across platforms.
Required skills include advanced Power BI (DAX, Power Query, visualizations), Python (Pandas, NumPy, automation libraries), and Excel (advanced formulas, pivot tables, VBA is a plus). Experience in data cleaning, transformation, and automation is essential.
The expected deliverables are clean processed datasets in CSV/Excel format, an interactive Power BI dashboard with drill-down capabilities, Python automation scripts if applicable, and documentation on methodology and key findings.
Timeline and budget are open for discussion based on scope. Please share examples of similar projects you’ve worked on, your estimated timeline and budget, and any suggestions to improve this project.
Looking forward to your proposal!