Skip to content

I am sharing my Journey of 66DaysofData into Data Analytics by participating in Ken Jee's #66daysofdata challenge

License

Notifications You must be signed in to change notification settings

mrankitgupta/Data-Analyst-Roadmap

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

Data Analyst Roadmap πŸ“Š

I am sharing my journey of #66DaysofData into Data Analytics by participating in Ken Jee's #66daysofdata challenge

Data Analytics is the process of exploring and analyzing large datasets to find hidden patterns, unseen trends, discover correlations, and derive valuable insights to make business predictions.

It helps in Improved Decision Making, Better Customer Service, Efficient Operations, Effective Marketing and Improves the Speed and Efficiency of the business.

Businesses use many modern tools and technologies to perform Data Analytics.

Technologies used βš™οΈ

My Certifications πŸ“œ πŸŽ“ βœ”οΈ

What are my featured projects:question: πŸ‘¨β€πŸ’» πŸ›°οΈ

Spotify Data Analysis using Python πŸ“Š

Sales Insights - Data Analysis using Tableau & SQL πŸ“Š

Statistics for Data Science using Python πŸ“Š

Kaggle - Pandas Solved Exercises πŸ“Š

Complete Python Roadmap πŸ“‘

Python Libraries for Data Science πŸ—‚οΈ

Library Management System using Python on Django πŸ‘¨β€πŸ’»

You can reach me πŸ‘‡

MrAnkitGupta_

MrAnkitGupta MrAnkitGupta_ https://bio.link/AnkitGupta MrAnkitGupta

Timeline

Day πŸ“† Lessons/Tasks Done ⏰ Reference Links πŸ”—
Day 1 Learnt Basics of Advanced Excel (Functions, Formulas, Charts, Conditional Formatting) Data Visualization with Advanced Excel - by PWC
Day 2 Practiced taking sample data on Advanced Excel (Lookups, What-If Tool, Pivot Table, VBS & Macros, Power Pivot & Dashboards) YouTube βœ…
Day 3 Started with Data Structures (Arrays, Stack, Queue, Linked List & their Computational Complexity) Geeks for Geeks
Day 4 Continued with Data Structures (Doubly Linked List, Dictionaries, Trees) YouTube 1
Day 5 Completed with Data Structures (Tries, Heap, Sorting, Graph) YouTube 2 βœ…
Day 6 Started with DBMS (Concepts, Charachteristics & Architectures, File system vs DBMS Database storage structures, Data models, Data Schema) JavaTpoint - DBMS
Day 7 Continued with DBMS (Entity Relationship Model, Design, Relational Model, Relational Algebra, Functional Dependencies, keys) YouTube
Day 8 Continued with DBMS (Normalisation, types, purpose, keys, Schema, Transactional mngt. and Concurrency Control, Acid property, Deadlock) Geeks for Geeks
Day 9 Continued with DBMS (Indexing, B and B+ trees, File Organization, Joins, Hashing) JavaTpoint - Data Mining
Day 10 Continued with DBMS (Backup & recovery techniques, Database security & Authorization, Query processing & evaluation) JavaTpoint - Data Warehouse
Day 11 Completed with DBMS (Data Warehousing, Schemas - (Star schema, Snowflake schema), OLAP, OLTP, Data Mining) βœ…
Day 12 Started with SQL (RDBMS, SQL vs NoSQL, Hbase vs Rdbms, Basics, Constraints, Syntax- DDL, DML) JavaTpoint
Day 13 Continued with SQL (Syntax - DQL, DCL & TCL, Operators, Database, Table, Select) YouTube
Day 14 Continued with SQL (Clauses, Order by, Insert, Update, Delete, Join, Keys, Queries, Functions) TutorialsPoint
Day 15 Continued with SQL (SQL-Injection, Data Integrity, Constraints, Flow control, T-SQL) Databases and SQL for Data Science with Python - by IBM
Day 16 Completed with SQL (Backup & Restore, Pivot table, Alias Syntax, Wildcards, Truncate table) Project: Sales Insights - Data Analysis using Tableau & SQL βœ…
Day 17 Started with NoSQL JavaTpoint
Day 18 Continued with MongoDB YouTube
Day 19 Continued with MongoDB [Coursera]
Day 20 Completed with MongoDB [Project] βœ…
Day 21 Started with Tableau & Data Visualization (Data Cleaning, Blending, Data Joining, Data Blending, Data Sorting, Data Aggregation) JavaTpoint
Day 22 Continued with Tableau & Data Visualization (Tableau Calculations - Operators, Functions, Numeric Calculations, String Calculations, Date Calculations, Table Calculations, LOD Expressions) YouTube
Day 23 Continued with Tableau & Data Visualization (Filter Data, Filter Operations, Extract Filters, Quick Filters, Context Filters, Condition Filters, Data Source Filters, Top Filters, Sort Data, Build Groups, Build Hierarchy, Build Sets) Data Visualization with Tableau - by Simplilearn
Day 24 Continued with Tableau & Data Visualization (Charts & Graphs - Bar Chart, Line Chart, Pie Chart, Bubble Chart, Bump Chart, Gantt Chart, Crosstab Chart, Motion Chart, Waterfall Chart, Bullet Chart, Area Chart, Pareto Chart, Dual Axis Chart, Box Plot, Heat Map, Tree Map, Scatter Plot, Histogram) My Tableau Public Project
Day 25 Completed with Tableau & Data Visualization (Dashboard, Formatting, Forecasting, Trend Lines, Advanced Mapping - Point to point maps, Calculation distances between two points on a map, Dual axis map) Project: Sales Insights - Data Analysis using Tableau & SQL βœ…
Day 26 Started with Python (Python basics - Features Applications, Python 2 vs Python 3, Libraries uses) Python Lessons for Practice
Day 27 Continued with Python (Interpreter Prompt, Script mode programming, IDEs, Features of an IDE, Compiler vs Interpreter) JavaTpoint
Day 28 Continued with Python (Pycharm - Featues, Important tools, Useful Plugins) Geeks for Geeks
Day 29 Continued with Python (Modules, Comments, Pip, Docstrings) YouTube 1
Day 30 Continued with Python (Indentation, Packages in Python, Modules vs Packages) Youtube 2
Day 31 Continued with Python (Variables, Declaring & Assigning Values, Object references, Object identity, Variable names, Multiple Assignment, Variable Types) Data Analysis with Python - by IBM
Day 32 Continued with Python (Fundamentals of Python - Tokens, Keywords, Literals, Operators, Identifiers & Comments) Data Visualization with Python
Day 33 Continued with Python (Data Types - Numbers, Sequence Type, Dictionary, Set, Type Conversion) Databases and SQL for Data Science with Python - by IBM
Day 34 Continued with Python (Collection Module - String, List & Tuples) Statistics for Data Science with Python - by IBM
Day 35 Continued with Python (Collection Module - Sets, Dictionary & Different containers provided by collection module) HackerRank - Practice
Day 36 Continued with Python (Control Flows - Indentation, If-Else & ELIF Statements) Code With Harry - Python Notes & Tutorial
Day 37 Continued with Python (Control Flows - For, While & Nested Loops, Control statements & Patterns) Python Cheatsheet - Code With Harry
Day 38 Continued with Python (Functions - Types of Functions, Arguments & it's Types, Scope of Variables) Basic Python Projects - YouTube
Day 39 Continued with Python (Functions - Built-in Functions)
Day 40 Continued with Python (Functions - Lambda Functions, Decorators, Generators)
Day 41 Continued with Python (Arrays)
Day 42 Continued with Python (Hash Tables / Hash Map)
Day 43 Continued with Python (OOPs Concept - Class & Objects, Constructors, Destructors)
Day 44 Continued with Python (OOPs Concept - Inheritance)
Day 45 Continued with Python (OOPs Concept - Polymorphism, Encapsulation) Project 1: Spotify Data Analysis using Python
Day 46 Continued with Python (OOPs Concept - Data Abstraction, Python Super Function) Project 2: Statistics for Data Science using Python
Day 47 Completed with Python (Exception Handling, File Handling & Unit Testing in Python) βœ…
Day 48 Started with Python Libraries - NumPy (Basics, NumPy v/s MATLAB, NumPy v/s List, NdArray, Datatypes, Array Attributes) Python Libraries for Data Science - Exercises
Day 49 Continued with Python Libraries - NumPy (Indexing & Slicing, Array Creation, Broadcasting, Operations, Functions, Mathematics, Matrix, NumPy-Matplotlib) NumPy Tutorial - by Great Learning & JavaTpoint, YouTube, TutorialsPoint βœ…
Day 50 Continued with Python Libraries - Pandas (Basics, Data Structures - Series, DataFrame, Panel) Pandas Course - by Kaggle
Day 51 Continued with Python Libraries - Pandas (Operations - Slicing, Merging, Joining, Concatenation) Kaggle Notebooks on Pandas & GitHub Repo on Pandas
Day 52 Continued with Python Libraries - Pandas (Changing Index & Column Header, Pandas-Matplotlib, Data Munging) JavaTpoint, YouTube, TutorialsPoint βœ…
Day 53 Continued with Python Libraries - Matplotlib (Basics, Data Visualization, Architecture, Concepts) Matplotlib Course - by Great Learning
Day 54 Completed with Python Libraries - Matplotlib (Pyplot & Subplot, Functions, 7 Types of plots, Multiple plots) JavaTpoint, YouTube, TutorialsPoint βœ…
Day 55 Started with Statistics (Intro, Basics of Descriptive statistics - Mean, Median, Mode, Variance, & Standard deviation) Statistics for Data Science with Python - by IBM
Day 56 Continued with Statistics (Data Visualization, Probability & Probability distributions, Hypothesis testing) TutorialsPoint, GitHub Project
Day 57 Completed with Statistics (Regression Analysis, Project: Boston Housing Data Analysis using Python ) Real Estate Project βœ…
Day 58 Daily Practice while learning (SQL, Python, Data Structures, Databases) HackerRank βœ…
Day 59 Tableau Project : Sales Insights - Data Analysis using Tableau & SQL Project
Day 60 Tableau Project : Sales Insights - Data Analysis using Tableau & SQL Tableau Public Dashboard
Day 61 Tableau Project : Sales Insights - Data Analysis using Tableau & SQL YouTube βœ…
Day 62 Python Project : Spotify Data Analysis using Python Project
Day 63 Python Project : Spotify Data Analysis using Python Kaggle Notebook
Day 64 Python Project : Spotify Data Analysis using Python YouTube βœ…
Day 65 Project : Boston Housing Data Analysis using Python Project
Day 66 Challenge accomplished βœ…

Useful Repositories to learn Data Science: Complete Python Roadmap πŸ“‘ Python Libraries for Data Science πŸ—‚οΈ & Kaggle - Pandas Solved Exercises πŸ“Š

So happy to have followed the journey through for the past 66 days.

It has really been a great learning experience and I have learnt a lot.

More importantly, I have developed the habit of learning Data Science every day no matter how small.

Useful sites to learn Coding πŸ”—

YouTube Channels:

freeCodeCamp.org Code With Harry, Programming With Harry CodeBasics Edureka Gate Smashers Jenny's Lectures Simplilearn Intellipaat

Other Learning Platforms:

JavaTpoint TutorialsPoint Geeks For Geeks Code With Harry GitHub Kaggle DataCamp W3Schools Guru99 Dev

For Certifications:

Coursera Kaggle Simplilearn Great Learnings Forage Edureka HackerRank Udemy Codechef Upgrad Udacity

For Coding Practice:

HackerRank Leetcode Kaggle Codechef Unstop HackerEarth Codeforces Interviewbit Google Dev

Liked my Contributions:question:Follow MeπŸ‘‰ Nominate Me for GitHub Stars ⭐ ✨

For any queries/doubts πŸ”— πŸ‘‡

MrAnkitGupta_

MrAnkitGupta MrAnkitGupta_ AnkitGupta MrAnkitGupta