Data Analysis & Business Intelligence Roadmap

Weekly Breakdown (1 Hour/Day)

Week Day Topic to Study Details
Week 1 Day 1 Excel Basics Learn basic formulas: SUM, AVERAGE, PRODUCT.
Day 2 Excel Basics Learn MEAN, MEDIAN, IF, SUMIF.
Day 3 Excel Basics Practice Excel formulas with a budget sheet.
Day 4 Excel Advanced Learn VLOOKUP, MATCH, INDEX.
Day 5 Excel Advanced Practice VLOOKUP and INDEX with sample data.
Day 6 Excel Advanced Learn Pivot Tables in Excel.
Day 7 Excel Advanced Practice Pivot Tables and Charting.
Week 2 Day 8 Business Math Learn arithmetic, percentages.
Day 9 Business Math Practice YoY growth calculations.
Day 10 Business Math Learn market share calculations.
Day 11 Statistics Study mean, median, standard deviation.
Day 12 Statistics Learn bell curve and percentile.
Day 13 Business Math Practice business math problems.
Day 14 Revision Revise Excel and business math concepts.
Week 3 Day 15 Power BI Basics Start Power BI: Basics and Interface.
Day 16 Power BI Project Follow Power BI 'Sales Insights' project tutorial.
Day 17 Power BI Project Work on Power BI 'Personal Finance' project.
Day 18 Power BI Project Work on Power BI 'HR Analytics' project.
Day 19 Power BI Practice Practice creating dashboards in Power BI.
Day 20 Power BI Revision Revise Power BI concepts.
Day 21 Tableau Basics Explore Tableau basics (optional).
Week 4 Day 22 SQL Basics Learn SQL: SELECT, WHERE, LIKE.
Day 23 SQL Practice Practice SQL queries on W3Schools.
Day 24 SQL Basics Learn SQL: DISTINCT, GROUP BY, ORDER BY.
Day 25 SQL Practice Practice GROUP BY and ORDER BY queries.
Day 26 SQL Advanced Learn SQL: CTE, Subqueries.
Day 27 SQL Practice Practice CTE and Subqueries.
Day 28 SQL Advanced Learn SQL: Window Functions.
Week 5 Day 29 SQL Practice Practice SQL Window Functions.
Day 30 SQL Advanced Learn SQL: Joins (Left, Right, Inner, Full).
Day 31 SQL Practice Practice SQL Joins.
Day 32 SQL Revision Revise SQL concepts.
Day 33 Python Basics Start Python: Variables, Lists.
Day 34 Python Basics Learn Python: Dictionaries, Tuples.
Day 35 Python Practice Practice Python Lists and Dictionaries.
Week 6 Day 36 Python Basics Learn Python: If conditions, For loops.
Day 37 Python Practice Practice Python loops and conditions.
Day 38 Python Functions Learn Python: Functions, Modules.
Day 39 Python Practice Practice Python functions.
Day 40 Python File Handling Learn Python: File Handling.
Day 41 Python Practice Practice Python file handling.
Day 42 Python Revision Revise Python basics.
Week 7 Day 43 Pandas Basics Learn Pandas: Dataframe basics.
Day 44 Pandas Practice Practice Pandas with CSV/Excel files.
Day 45 Pandas Basics Learn Pandas: Handling missing data.
Day 46 Pandas Practice Practice Pandas Group By, Concat, Merge.
Day 47 Pandas Project Work on a small Pandas project.
Day 48 Pandas Revision Revise Pandas concepts.
Day 49 Kaggle Exploration Explore Kaggle datasets and notebooks.
Week 8 Day 50 Resume Building Work on your resume.
Day 51 LinkedIn Optimization Optimize LinkedIn profile (add tags, banner).
Day 52 SQL Interview Prep Practice SQL interview questions on DataLemur.
Day 53 Power BI Interview Prep Prepare for Power BI interview questions.
Day 54 Python Interview Prep Practice Python interview questions.
Day 55 Technical Revision Revise all technical concepts.
Day 56 LinkedIn Post Make a LinkedIn post about your learning journey.
Week 9 Day 57 Resume Challenge Participate in a resume project challenge.
Day 58 Cold Emailing Practice cold emailing for job applications.
Day 59 LinkedIn Networking Network on LinkedIn (comment on posts, connect with professionals).
Day 60 Business Fundamentals Revise business fundamentals (P&L, case studies).
Day 61 Behavioral Interview Prep Prepare for behavioral interview questions.
Day 62 Soft Skills Revision Revise all soft skills (communication, presentation).
Day 63 LinkedIn Video Post Make a final LinkedIn post with a video.
Week 10 Day 64 Final Revision Final revision of all topics.
Day 65 Job Applications Apply for jobs and track progress.
Day 66 Networking Continue networking and learning.
Day 67 Reflection Reflect on your progress and set new goals.
Day 68 Celebration Celebrate completing the roadmap!

Daily Breakdown (1 Hour/Day)