Data Mentorship by Nitian Shubham

Big companies don't value your degree.

They value your SKILLS!

Become a Google Certified Data Analytics within a few months.

No payment is required!

1. Foundations: Data, Data, Everywhere

This course will help you gain an understanding of the practices and processes used by data analysts in their day-to-day job.

🔗 https://lnkd.in/dy-jNkC9

2. Ask Questions to Make Data-Driven Decisions

This course will help you learn how to ask effective questions to make data-driven decisions while connecting with stakeholders’ needs.

🔗 https://lnkd.in/dj-PrxrN
specialization=google-data-analytics

3. Process Data from Dirty to Clean

This course will help you learn how to check and clean your data using spreadsheets and SQL as well as how to verify and report your data cleaning results.

🔗 https://lnkd.in/dahQtajr

4. Data Analysis with R Programming

In this course, you’ll learn about the programming language known as R. You’ll find out how to use RStudio, the environment that allows you to work with R.

🔗 https://lnkd.in/dX5gvWZB

5. Share Data Through the Art of Visualization

In this course, you’ll learn how to visualize and present your data findings as you complete the data analysis process.

🔗 https://lnkd.in/dsYwdeiW

6. Analyze Data to Answer Questions

In this course, you’ll learn how to organize and format your data using spreadsheets and SQL to help you look at and think about your data in different ways.

🔗 https://lnkd.in/dsvn3W7a

7. Google Data Analytics:

🔗 https://lnkd.in/d88ggSEm

8. Learn Python Basics for Data Analysis

Learn how to use and write functions, practice with data analysis, and work on your first algorithm!

🔗 https://lnkd.in/d6psdqpq

9. Get Started with Python

🔗 https://lnkd.in/dx5T7JSX

10. Go Beyond the Numbers: Translate Data into Insights

🔗 https://lnkd.in/dWgC7hx3

11. The Power of Statistics

🔗 https://lnkd.in/dANEEWvW

12. Regression Analysis: Simplify Complex Data Relationships

🔗 https://lnkd.in/dAZu89Kg

13. The Nuts and Bolts of Machine Learning

🔗 https://lnkd.in/dRB-54dR

14. Google Advanced Data Analytics Capstone

🔗 https://lnkd.in/dG8MEyRz

YouTube is a FREE University.....

Top 7 YouTube Channel for Data Analyst

1. Sumit (Trendytech)

Topics : SQL

Start here :

SQL tutorial for everyone : https://lnkd.in/gW9yjTqg

Advanced SQL : https://lnkd.in/gR4fvRVu

2. Chandoo

Topics : Excel & Power BI

Start here : https://lnkd.in/gjCkWdD4

3. Alex Frebery (Alex The Analyst)

Topics : SQL,Excel,Python,BI Tools & Interviewing Tips

Start here : https://lnkd.in/gmkrkqiX

4. Lore (Lore So What)

Topics : SQL,Excel,Python,BI Tools & FAANG Interview Tips

Start here : https://lnkd.in/g3NMVSr2

5. Bas Dohmen (How to Power BI)

Topics : Power BI,DAX,Power Query & Dashboard Design

Start here : https://lnkd.in/gPTbR89w

6. Ruth Pozuelo Martinez (Curbal)

Topics : Power BI & DAX

Start here : https://lnkd.in/gXU2VECz

7. Mike Girvin (ExcellsFun)

Topics : Excel,Power BI,DAX,Power Query,Power Pivot & M

Start here : https://lnkd.in/g6wJNHmh

𝗙𝗿𝗲𝗲 Learning Path for 𝟮𝟬𝟮𝟯 🎯

1- Excel

🌀https://lnkd.in/d9Wbb-GK

2-Power BI

🌀https://lnkd.in/d9cwre8b

3-SQL

🌀https://lnkd.in/dJ-VpdeZ

4-R

🌀https://lnkd.in/dPVjmXJH

5-Python

🌀https://lnkd.in/daCYRmBN

6- Probability & Statistics

🌀https://lnkd.in/dxuCXtrg

7- Linear Algebra

🌀https://lnkd.in/dDvJBY-9

8- Linear Programming

🌀https://lnkd.in/dbpNnhVs

9- ML & AI

🌀https://lnkd.in/dhdWsXh4

10-Artificial Intelligence for Robotics

🌀https://lnkd.in/djqdFjM2

11- Introduction to Internet of Things

🌀https://lnkd.in/dWt6KRTi

12-Advanced Cybersecurity Program

🌀https://lnkd.in/dwWT9xg9

💥 Happy Learning 💥
-------------------------------------------------
Follow me on LinkedIn for more such content
https://www.linkedin.com/in/shubham-tiwari-08b04513a/
---------------------------------------------

Join my Telegram for data analytics resources and job openings

link:https://t.me/dataacademybyshubh

Hey folks, diving into the world of data analytics?

🚀 Exciting news!

We're gearing up for personalized 1-1 mentorship classes, guiding you from the basics to landing that dream placement. With 4 years of hands-on experience in the field, I'm thrilled to share my insights. Keen to join? Drop me a message! 📈

Free Online courses with certificate from Microsoft

Python for beginners
https://learn.microsoft.com/en-us/training/paths/beginner-python/

Get started with Azure Cosmos DB for NoSQL
https://learn.microsoft.com/en-us/training/paths/get-started-azure-cosmos-db-sql-api/

Introduction to machine learning with Python and Azure Notebooks
https://learn.microsoft.com/en-us/training/paths/intro-to-ml-with-python/

Automate development tasks by using GitHub Actions
https://bit.ly/48E75xT

SQL, Power BI & AI Fundamentals
https://bit.ly/3ZL2820

Write your first code using C #
https://learn.microsoft.com/en-us/training/paths/get-started-c-sharp-part-1/

Join for more free resources

ENJOY LEARNING 👍👍

Want to master Excel for Free.💥

Learn from these courses by paying 0$ online.

1. Work Smarter with Microsoft Excel

🔗https://lnkd.in/dDpQ_Mz9

2. Getting started with Microsoft Excel

🔗https://lnkd.in/dvRNTv6k

3. Create a Project Management Tracker using Microsoft Excel

🔗https://lnkd.in/dgbCQ7ya

4. Create a Simple Gantt Chart using Microsoft Excel

🔗https://lnkd.in/dRqtadQb

5. Excel Skills for Business Specialization

🔗https://lnkd.in/dGDu7h7U

6. Excel for Beginners: Pivot Tables

🔗https://lnkd.in/d_GtkT7c

7. Excel/VBA for Creative Problem Solving Specialization

🔗https://lnkd.in/dVEB5gse

8. Excel for Beginners: Introduction to Spreadsheets

🔗https://lnkd.in/dXdQWMx3

9. Excel for Beginners: Advanced Functions

🔗https://lnkd.in/dKKkZcEQ

10. Using Advanced Formulas and Functions in Excel

🔗https://lnkd.in/dV-JV73f

11. IBM Data Analytics with Excel and R

🔗https://lnkd.in/dNFtFytU

12. Excel to MySQL: Analytic Techniques for Business Specialization

🔗https://lnkd.in/d_K_Yjmw

13. Using Basic Formulas and Functions in Microsoft Excel

🔗https://lnkd.in/dr6YuPm3?

14. Excel Skills for Business: Advanced

🔗https://lnkd.in/dwCi5bV6

15. Introduction to Data Analysis using Microsoft Excel

🔗https://lnkd.in/dNcZABCZ

16. Excel Basics for Data Analysis

🔗https://lnkd.in/d9Wbb-GK

17. Data Visualization with Advanced Excel

🔗https://lnkd.in/dyxKCfVD

18. Create Charts and Dashboards Using Microsoft Excel

🔗https://lnkd.in/dQbTBJbb

19. Create a budget with Microsoft Excel

🔗https://lnkd.in/degwYCQT

20. Create a Simple Project Timeline in Microsoft Excel

🔗https://lnkd.in/dh3sv-ix

21. Create a Financial Statement using Microsoft Excel

🔗https://lnkd.in/dPATK3db?

Happy learning.✔️

Join Telegram for more Free Coding & AI Courses with Proper Notes: telegram.me/CodeTreasure

LinkedIn Learning LinkedIn for Creators

LinkedIn This link will take you to a page that’s not on LinkedIn

🚀 Transitioning from Non-IT Background to Data Analytics? Let's Connect! 📊

Hey LinkedIn fam! 👋 If you're from a non-IT background and contemplating a move into the exciting realm of Data Analytics, I'm here to lend a helping hand!

Having journeyed from Chemical Engineering to Data Analytics, I understand the challenges and questions that come with making such a transition. Whether you're navigating through learning resources, choosing the right tools, or simply seeking advice on how to kickstart your journey, I've got your back.

Ping me or let's connect on a call, and I'd be more than happy to share insights, tips, and lessons from my own experience. Together, let's turn your aspirations into a reality! 🌐💡

Data Analyst Certifications Courses 🙌

1-Google Data Analytics: You’ll learn in-demand skills that will have you job-ready in less than 6 months.
🌀https://lnkd.in/duauUYDs

2-IBM Data Analyst :Those with limited time can enroll in IBM's professional certification and learn all of the skills .
🌀https://lnkd.in/dCKVya8h

3-Learn SQL Basics for Data Science: Want to start learning SQL from the beginner level of writing queries to assessing and creating datasets to solve business problems.
🌀https://lnkd.in/dueBEz63

4-Excel for Business : Learn not just the basics of manipulating the data or formatting the data but also analyzing and presenting the data in a user-friendly way.
🌀https://lnkd.in/d6euhXWX

5-Python for Everybody :Learn the fundamentals of Python through this course and also through the Capstone Project.
🌀https://lnkd.in/d5Afm9ZV

6-Data Analysis Visualization Foundations :Learn analyzing data and creating visualizations and dashboards .
🌀https://lnkd.in/dBQFvjmd

7-Machine Learning Specialization: Specialization is a series of courses that helps you master a skill.
🌀https://lnkd.in/dE9fdJxR

8-Introduction to Data Science: This Specialization will introduce you to what data science is and what data scientists do.
🌀https://lnkd.in/dW6v-gES

Happy learning!!!

👉𝗝𝗼𝗶𝗻 𝘁𝗵𝗶𝘀 𝘁𝗲𝗹𝗲𝗴𝗿𝗮𝗺 𝗴𝗿𝗼𝘂𝗽 𝗳𝗼𝗿 𝗝𝗼𝗯𝘀/𝗡𝗼𝘁𝗲𝘀
https://t.me/Freshers_Hub

👉Follow Srishti Kashyap for more such content

🚨 This post is a combination of both PDFs / textbook and video resources for
STATISTICS, EXCEL, PYTHON, R, SQL,POWER BI and TABLEAU

📢 The below links will take you to the respective pdfs and videos on each topic.

🎈STATISTICS
LINK TO TEXTS
https://lnkd.in/dfczXFe8

VIDEOS.
https://lnkd.in/dPF4RKCk

💛 MICROSOFT EXCEL
LINK TO TEXTS
https://lnkd.in/d-9FnuMw

LINK TO VIDEO
youtu.be/Vl0H-qTclOg

♣️ MICROSOFT POWER BI
LINK TO TEXTS
https://lnkd.in/dBJBfgT9

LINK TO VIDEO
https://lnkd.in/dug3DH94

♟️TABLEAU
LINK TO TEXTS
https://lnkd.in/dZ6cS7nB

LINK TO VIDEOS
https://lnkd.in/dgubncvS

https://lnkd.in/dvpsyT6P

♦️SQL
LINK TO TEXTS
https://lnkd.in/dSvunG-r

LINK TO VIDEOS
youtu.be/HXV3zeQKqGY

youtu.be/9URM1_2S0ho

https://lnkd.in/dM6RyYeV

https://lnkd.in/dMnSNgAA

💙 PYTHON
LINK TO TEXTS
https://lnkd.in/dwHNWMDG

LINK TO VIDEOS
https://lnkd.in/dF-BCxJa

https://lnkd.in/dwadiMb8

♠️ R
LINK TO TEXTS
https://lnkd.in/dCjdmSaB

LINK TO VIDEOS
youtu.be/_V8eKsto3Ug

📌 My advice to you is “DON’T overwhelm yourself, take each material one step at a time, you can’t consume all at once”. This is to avoid information overload.

📣 Secondly, it's not about how much text or videos you watch BUT how much you PRACTICE all that you have learned. As, it's only through practice that you can test your knowledge and skills.

Please repost/share for others to also benefit from these resources. Thanks 😊

🚨 This post is a combination of both PDFs / textbook and video resources for
STATISTICS, EXCEL, PYTHON, R, SQL,POWER BI and TABLEAU

📢 The below links will take you to the respective pdfs and videos on each topic.

🎈STATISTICS
LINK TO TEXTS
https://lnkd.in/dfczXFe8

VIDEOS.
https://lnkd.in/dPF4RKCk

💛 MICROSOFT EXCEL
LINK TO TEXTS
https://lnkd.in/d-9FnuMw

LINK TO VIDEO
youtu.be/Vl0H-qTclOg

♣️ MICROSOFT POWER BI
LINK TO TEXTS
https://lnkd.in/dBJBfgT9

LINK TO VIDEO
https://lnkd.in/dug3DH94

♟️TABLEAU
LINK TO TEXTS
https://lnkd.in/dZ6cS7nB

LINK TO VIDEOS
https://lnkd.in/dgubncvS

https://lnkd.in/dvpsyT6P

♦️SQL
LINK TO TEXTS
https://lnkd.in/dSvunG-r

LINK TO VIDEOS
youtu.be/HXV3zeQKqGY

youtu.be/9URM1_2S0ho

https://lnkd.in/dM6RyYeV

https://lnkd.in/dMnSNgAA

💙 PYTHON
LINK TO TEXTS
https://lnkd.in/dwHNWMDG

LINK TO VIDEOS
https://lnkd.in/dF-BCxJa

https://lnkd.in/dwadiMb8

♠️ R
LINK TO TEXTS
https://lnkd.in/dCjdmSaB

LINK TO VIDEOS
youtu.be/_V8eKsto3Ug

📌 My advice to you is “DON’T overwhelm yourself, take each material one step at a time, you can’t consume all at once”. This is to avoid information overload.

📣 Secondly, it's not about how much text or videos you watch BUT how much you PRACTICE all that you have learned. As, it's only through practice that you can test your knowledge and skills.

Please repost/share for others to also benefit from these resources. Thanks 😊

LinkedIn This link will take you to a page that’s not on LinkedIn

🔶Important SQL Concepts You Should Know For Data Analyst

✅Understanding of Basic Commands
➡SELECT & FROM: to retrieve the attributes of data from the mentioned table.
➡SELECT DISTINCT: it eliminates duplicate rows and displays only the unique records.
➡WHERE: it filters the record and shows only the ones that satisfy the given condition.
➡AND, OR, NOT: logical operators
➡ORDER BY: it sorts the data in ascending or descending order
➡GROUP BY: it groups identical data.
➡HAVING: data aggregated by Group By can be further filtered out here.
➡Aggregate functions: aggregate functions like COUNT(), MAX(), MIN(), AVG(), and SUM() are used to perform operations on the given data.

✅Joins
➡Inner Join: inner join shows only those rows from both tables that meet the given condition. It can be referred to as an intersection in terms of set terminology.
➡Left Join: it returns all the records from the LEFT table while only the matching records from the right table are displayed.
➡Right Join: It is just the opposite of what left join does.
➡Full Join: it contains all the rows from both the table and if it does not have a corresponding matching entry a NULL value is displayed.

✅String Formatting
➡CONCAT: it is used to add two or more strings together.
➡SUBSTR: it returns the portion of the string and takes the starting position and the length of the substring to be returned in its parameters.
➡TRIM: the main job of trim is to remove the characters from the beginning of strings, the ending of strings or both if specified.
➡COALESCE: it can be used to replace the null values with user-defined values that are often required in data science.

✅ Window functions
➡Aggregate functions: it displays the aggregate values from the numerical columns like AVG(), COUNT(), MAX(), MIN(), SUM(), etc.
➡Value functions: each partition is assigned some values using the value window functions. Some of the most commonly used value functions are LAG(),LEAD(), FIRST_VALUE(), LAST_VALUE(), and NTH_VALUE().
➡Ranking Functions: they are useful to assign a ranking to rows based on some predefined ordering. ROW_NUMBER(), RANK(), DENSE_RANK(),PERCENT_RANK(),NTILE() .
✅Case When
✅Subqueries
✅Stored Procedures

Free courses to learn Data Science in 2023:


1️⃣ Python
https://lnkd.in/dWqrNydB

2️⃣ SQL
https://lnkd.in/dqQDJhBc

3️⃣ R
https://lnkd.in/dFtnh_TB

4️⃣ PowerBI
https://lnkd.in/dfZZapxx

5️⃣ Mathematics
https://lnkd.in/d8kYV4qi

6️⃣ Tableau
https://lnkd.in/dyBPu-Bj

7️⃣ Excel and PowerBI
https://lnkd.in/dSZ9yiGP

8️⃣ Probability
https://lnkd.in/dqKjH7S9

9️⃣ Statistics
https://lnkd.in/df6qksMB

🔟 Linear Algebra
https://lnkd.in/dJSBGzMB

11. Machine Learning
https://lnkd.in/dHwX9RRD

12. Deep Learning
https://lnkd.in/djcdRiWe

13. Data Analysis
https://lnkd.in/dr5P-qui

14. Data Visualization
https://lnkd.in/d6XzweXf