Free Projects for Aspiring Data Analysts

Oct 4, 2024

Lecture Notes: Free Guided Projects for Data Analyst Jobs

Introduction

  • Discussing five free projects that help subscribers get data analyst jobs.
  • Projects include all materials, such as resume samples.

Projects Overview

1. Generating Sales Insights for Consumer Goods

  • Tools used: SQL and Power BI.
  • Available as a guided playlist on YouTube.
  • Covers full data analytics project cycle: problem statement to dashboard.
  • Created with industry experience from Europe and the US.
  • Successful job placements reported by participants.
  • Includes resume sample.

2. T20 Cricket World Cup Data Analytics

  • Data collection from ESPN Cricinfo using web scripting.
  • Tools used: Pandas and Python for data cleaning and transformation.
  • Insights discussed with a subject matter expert.
  • Emphasizes both technical skills and soft skills.
  • Free YouTube video with all materials and resume sample.

3. HR Data Analytics

  • Uses real data from IT organization Atlake Technologies.
  • Involves discussions with HR managers to understand pain points.
  • Dashboard created in Power BI.
  • Includes relevant resume skills.

4. Generating Revenue Insights in Hospitality

  • Data from hotels used for bookings and room analytics.
  • Part of resume project challenge on codebasic.io.
  • Free materials and Discord support.
  • Participants' profiles shared with employers for job opportunities.
  • Promoted on LinkedIn for visibility.

5. Supply Chain Data Analytics in FMCG

  • Relevant for supply chain data analyst job roles.
  • Helps build domain knowledge in supply chain fundamentals.
  • Materials available on resume challenge portal.
  • Working on projects enhances both technical and business skills.

Bonus Project: Business Insights 360 Degree

  • Premium dashboard covering all business functions: finance, supply chain, marketing, etc.
  • Part of a paid course on codebasics.io.
  • Includes domain-specific and project management skills.
  • Free videos available for preview.

Conclusion

  • Data analytics field is growing rapidly, especially in Power BI.
  • Open to all educational backgrounds; no specific degree required.
  • Focus on learning key tools: Power BI, SQL, Excel.
  • Encouragement and best wishes for job seekers.
  • Call to action: thumbs up and share the video.
  • Emphasized the importance of practical projects in building a resume and gaining job interviews.
  • Highlighted community and resource support available for participants.