Automate Bringing Public Data Into Power BI using Power Query/Automate
Budget: $250 – $750 USD
I am looking for a freelancer who can help me automate the process of bringing public data into Power BI using Power Query/Automate. Here are the details of the project:
Source of Public Data:
Economic Indicators: Macroeconomic indicators such as GDP, unemployment rate, inflation rate can provide a broader perspective on your hiring practices. For example, in a booming economy, it might be more challenging to source candidates, reflected in a higher time-to-fill. A good source for such data is the Bureau of Economic Analysis and the Bureau of Labor Statistics.
Industry Hiring Trends: Data on hiring trends in your specific industry can provide a useful benchmark. For example, are you filling positions faster or slower than the industry average? The BLS provides data on job openings, hires, and separations by industry.
Salary Surveys: Data on average salaries for different roles and locations can help contextualize your bill rates and pay rates. Are you paying competitive rates for the roles you're hiring for? Glassdoor and Payscale provide salary data for a wide range of roles.
Labor Market Supply/Demand Data: Data on the availability of talent in the labor market can impact your ability to fill positions. For example, in a tight labor market, it might be more difficult to fill positions, leading to longer cycle times. You can access labor market data through the U.S. Bureau of Labor Statistics.
Workforce Demographics Data: Data on the demographics of the workforce, including age, gender, ethnicity, and education level can provide additional context for your hiring practices. This data is available through the U.S. Census Bureau and the Bureau of Labor Statistics.
Technological Trends: If you are hiring for technical roles, information about the popularity of different technologies could be relevant. Stack Overflow, for instance, provides an annual developer survey that provides insight into the most commonly used programming languages and technologies: Stack Overflow Developer Survey.
Desired Format for Data Presentation:
- The client wants the data to be presented in tables format in Power BI.
Skills and Experience Required:
- Proficiency in Power Query/Automate
- Strong knowledge of Power BI
- Experience in working with public data sources
- Ability to recommend relevant data sources based on project requirements
- Attention to detail and ability to create well-formatted tables in Power BI
If you have the required skills and experience, please submit your proposal for this project.
Source of Public Data:
Economic Indicators: Macroeconomic indicators such as GDP, unemployment rate, inflation rate can provide a broader perspective on your hiring practices. For example, in a booming economy, it might be more challenging to source candidates, reflected in a higher time-to-fill. A good source for such data is the Bureau of Economic Analysis and the Bureau of Labor Statistics.
Industry Hiring Trends: Data on hiring trends in your specific industry can provide a useful benchmark. For example, are you filling positions faster or slower than the industry average? The BLS provides data on job openings, hires, and separations by industry.
Salary Surveys: Data on average salaries for different roles and locations can help contextualize your bill rates and pay rates. Are you paying competitive rates for the roles you're hiring for? Glassdoor and Payscale provide salary data for a wide range of roles.
Labor Market Supply/Demand Data: Data on the availability of talent in the labor market can impact your ability to fill positions. For example, in a tight labor market, it might be more difficult to fill positions, leading to longer cycle times. You can access labor market data through the U.S. Bureau of Labor Statistics.
Workforce Demographics Data: Data on the demographics of the workforce, including age, gender, ethnicity, and education level can provide additional context for your hiring practices. This data is available through the U.S. Census Bureau and the Bureau of Labor Statistics.
Technological Trends: If you are hiring for technical roles, information about the popularity of different technologies could be relevant. Stack Overflow, for instance, provides an annual developer survey that provides insight into the most commonly used programming languages and technologies: Stack Overflow Developer Survey.
Desired Format for Data Presentation:
- The client wants the data to be presented in tables format in Power BI.
Skills and Experience Required:
- Proficiency in Power Query/Automate
- Strong knowledge of Power BI
- Experience in working with public data sources
- Ability to recommend relevant data sources based on project requirements
- Attention to detail and ability to create well-formatted tables in Power BI
If you have the required skills and experience, please submit your proposal for this project.