Data Consolidation for Power BI Analysis
Budget: $250 – $750 USD
I am looking for a data expert who can take data from multiple sources and consolidate it into a data source - preferably Microsoft Azure - for real-time PowerBI dashboards and reports.
There are about 9 fields from Autotask, 3 from Quickbooks Online, and 4 fields from Excel which I need to have all in one place for analysis.
Key Responsibilities:
- Consolidate data from diverse sources, including Excel files, Google Sheets, Autotask, and Quickbooks Online.
- Focus on Financial and Sales data primarily.
- Ensure the data is clean, well-structured, and ready for analysis.
Ideal Skills:
- Proven experience with data consolidation from multiple sources.
- Strong proficiency in Excel and working with Google Sheets.
- Familiarity with Autotask and Quickbooks Online is a plus.
- Expertise in preparing data for analysis in Power BI.
I have full access to all these data sources. Total fields expected to be around 15, updated monthly. The goal is to have a comprehensive, well-organized database that can be used for in-depth analysis in Power BI.
There are about 9 fields from Autotask, 3 from Quickbooks Online, and 4 fields from Excel which I need to have all in one place for analysis.
Key Responsibilities:
- Consolidate data from diverse sources, including Excel files, Google Sheets, Autotask, and Quickbooks Online.
- Focus on Financial and Sales data primarily.
- Ensure the data is clean, well-structured, and ready for analysis.
Ideal Skills:
- Proven experience with data consolidation from multiple sources.
- Strong proficiency in Excel and working with Google Sheets.
- Familiarity with Autotask and Quickbooks Online is a plus.
- Expertise in preparing data for analysis in Power BI.
I have full access to all these data sources. Total fields expected to be around 15, updated monthly. The goal is to have a comprehensive, well-organized database that can be used for in-depth analysis in Power BI.