Welcome to the 8-Week Data Analysis Challenge repository! This repository is dedicated to helping you enhance your skills in SQL, Python, and all things related to data analysis. Over the next 8 weeks, I'll be posting daily content covering various topics in data analysis, starting with SQL. Additionally, you'll find two interview questions each day to help you prepare for data analysis interviews.
The 8-Week Data Analysis Challenge is designed to help you build and strengthen your data analysis skills. Whether you're a beginner or an experienced data analyst, this challenge will provide valuable insights and practice opportunities to enhance your knowledge and prepare you for real-world scenarios.
- Duration: 8 weeks
- Frequency: Daily posts
- Content: SQL topics, Python programming, MS Excel, Power BI, Tableau, data analysis techniques, and more
- Interview Questions: 2 interview questions related to data analysis each day
- SORTING AND FILTERING (ORDER BY, GROUP BY, HAVING)
- JOIN OPERATIONS (INNER, LEFT, FULL OUTER, SELF, CROSS)
- INSERT, UPDATE, DELETE OPERATIONS
- AGGREGATE FUNCTIONS (SUM, AVG, COUNT, MIN, MAX)
- USE CASES OF JOINS
- SUBQUERIES (SCALAR, COULUMN, ROW, TABLE)
Each day, a new post will be added covering a specific topic in SQL, Python, or data analysis. The posts will include:
- Detailed explanations
- Code snippets and examples
- Practice exercises
- Solutions to previous exercises
To help you prepare for data analysis interviews, I'll be posting two interview questions each day. These questions will cover various aspects of data analysis, including SQL, Python, statistics, and problem-solving.
If you have any questions or suggestions, feel free to reach out to me:
- GitHub: poojithaganta
- Email: poojithaganta95@gmail.com
Happy learning!
Let's make the most of these 8 weeks and take our data analysis skills to the next level!