Python Mindmap
👇👇
https://www.linkedin.com/posts/sql-analysts_how-to-master-python-from-scratch-1-setup-activity-7208056029719195648-IYWF?utm_source=share&utm_medium=member_android

SQL Roadmap
👇👇
https://www.linkedin.com/posts/sql-analysts_essential-list-of-topics-to-master-sql-in-activity-7209505465687322624-1uI-?utm_source=share&utm_medium=member_android

Full Data Analyst Roadmap:

1. Optimize LinkedIn

Add a friendly, professional profile photo; create a headline that starts with the job title you want (data analyst, not aspiring);

add a banner photo (Canva can help with this); create an about section that goes deeper into your skills and background and why you’re good at what you do (add some personality);

Highlight transferrable skills in your work and education history sections, quantify your impact where applicable; add your portfolio and anything else you want to show off to your featured section (once you have a portfolio);

Use keywords throughout including tools, years of experience, and job titles (data analyst)

Learn Data Analytics

2. Learn Microsoft Excel:

Software: Microsoft Excel Online (it’s not the best, but it will do.)

YouTube & Telegram channels to learn: Teacher’s Tech, Excel for Data Analysis, Kevin Stratvert, Leila Gharani, Alex the Analyst

Learn Data Analytics

3. Learn SQL

Software: MySQL

Free courses: Khan Academy, W3Schools, SQL Bolt, SQL Zoo, Luke Barousse and Alex the Analyst on YouTube

Telegram channel: SQL for data analysis

Practice problems: Hacker Rank, Leet Code, Data Lemur

Games: SQL Island, SQL Murder Mystery

Learn Data Analytics

4. Learn Tableau

Software: Tableau Public

Learn with Tableau Public website and YouTube channels such as Alex the Analyst, Andy Kriebel, and Tableau Tim

Learn Data Analytics

Data Analyst is NOT a Business Analyst.

BOTH Works with DATA,but the way they do it is Vastly Different.

Data Analyst Mainly :-

✔️ Work in DATABASE.
✔️ Use SQL.
✔️ Propose actionable INSIGHTS.
✔️ Report to Team Memeber's.

Business Analyst Mainly :-

✔️ Work in SPREADSHEET.
✔️ Use EXCEL.
✔️ Make Strategic Recommendations.
✔️ Report to Upper Management.

Awareness of the difference's between Data Analyst & Business Analyst.

5. Build a portfolio to showcase your skills

There are a ton of options for hosting portfolios including GitHub Pages, Carrd, and Maven Portfolio Showcase.

Learn Data Analytics

6. Build a great resume

Highlight transferrable skills from past experience, add a project section to showcase your analytics skills, and link your portfolio in the header.

Alex the Analyst did a great video on this like a year ago including a portfolio template I’ve used.

Learn Data Analytics

7. Start applying to jobs

Leverage any connections you have including friends, family, and former colleagues.

If you already work for a company that hires data analysts, transitioning to a data role within the company can be the easiest route.

Once you have the skills, it’s your job to get the attention of recruiters and hiring managers.

Learn Data Analytics

There are a lot of data analyst jobs that don’t use SQL.

There are a lot of jobs that don’t use Tableau/Power BI.

There are even jobs that don’t use Excel/Google sheets.

BUT, the probability you’ll use at least one of those tools in your data analyst job is close to 100%.

That’s why I recommend every data analyst learn SQL, Excel, and Tableau or Power BI.

That way you’re ready for almost all entry-level data analyst jobs.

8 (and forever): keep learning!

The learning doesn’t stop when you start applying for jobs or even when you get one!

Always be learning something new.

Note: even with hard work, this can be a tough, time-intensive process.

Hang in there and keep the faith!

You got this.

Learn Data Analytics

Imp interview Q&A for numpy in Data analyst

1.Creating an array and performing basic operations:
import numpy as np

# Creating a 1D array
array = np.array([1, 2, 3, 4, 5])
print("Original array:", array)

# Adding 10 to each element
array_plus_ten = array + 10
print("Array after adding 10:", array_plus_ten)

# Multiplying each element by 2
array_times_two = array * 2
print("Array after multiplying by 2:", array_times_two)


2. Creating a 2D array and accessing element:
# Creating a 2D array (matrix)
matrix = np.array([[1, 2, 3], [4, 5, 6], [7, 8, 9]])
print("Original matrix:\n", matrix)

# Accessing a specific element
element = matrix[1, 2]
print("Element at row 2, column 3:", element)

# Accessing a specific row
row = matrix[1, :]
print("Second row:", row)

# Accessing a specific column
column = matrix[:, 2]
print("Third column:", column)

3.Basic statistical operations on an array:
# Creating an array
data = np.array([10, 20, 30, 40, 50])

# Calculating the mean
mean = np.mean(data)
print("Mean:", mean)

# Calculating the median
median = np.median(data)
print("Median:", median)

# Calculating the standard deviation
std_dev = np.std(data)
print("Standard Deviation:", std_dev)


4.Creating arrays using different functions and reshaping:
# Creating an array of zeros
zeros_array = np.zeros((3, 3))
print("Array of zeros:\n", zeros_array)

# Creating an array of ones
ones_array = np.ones((2, 4))
print("Array of ones:\n", ones_array)

# Creating an array with a range of values
range_array = np.arange(10)
print("Array with a range of values:", range_array)

# Reshaping an array
reshaped_array = range_array.reshape(2, 5)
print("Reshaped array (2x5):\n", reshaped_array)

5. Element-wise operations and broadcasting:
# Creating two arrays
array1 = np.array([1, 2, 3])
array2 = np.array([4, 5, 6])

# Element-wise addition
addition = array1 + array2
print("Element-wise addition:", addition)

# Element-wise multiplication
multiplication = array1 * array2
print("Element-wise multiplication:", multiplication)

# Broadcasting: adding a scalar to an array
scalar_addition = array1 + 10
print("Array after adding 10 to each element:", scalar_addition)

Microsoft Excel Shortcut Keys A-Z

https://www.linkedin.com/posts/sql-analysts_microsoft-excel-shortcuts-a-to-z-everyone-activity-7213733019700912129-V1mX?

Data Analyst Remote Job will be posted in this channel today
👇👇
https://t.iss.one/jobs_SQL

Skills need for everyday data analysis jobs