My journey as a data analyst so far: https://www.linkedin.com/posts/sql-analysts_today-i-decided-to-share-my-journey-in-data-activity-7169341885914853376-GWnd?utm_source=share&utm_medium=member_android

Feel free to write down your experience in the comments.

I usually don't share my personal journey online but sometimes even small things like this help others.

I hope you guys can relate with me ❤️

Data Analyst Interview Questions

Here are some Excel shortcuts that are commonly used by data analysts:

1. Ctrl + C: Copy
2. Ctrl + V: Paste
3. Ctrl + X: Cut
4. Ctrl + Z: Undo
5. Ctrl + Y: Redo
6. Ctrl + S: Save
7. Ctrl + F: Find
8. Ctrl + H: Replace
9. Ctrl + Arrow Keys: Navigate to the edge of data
10. Ctrl + Shift + Arrow Keys: Select data range
11. Ctrl + Home: Go to cell A1
12. Ctrl + End: Go to last cell with data
13. Ctrl + Shift + L: Toggle filters
14. Alt + ; : Select visible cells only
15. F2: Edit active cell
16. Ctrl + Shift + Enter: Enter an array formula
17. Ctrl + D: Fill down
18. Ctrl + R: Fill right
19. Ctrl + 1: Format cells dialog box
20. Ctrl + Shift + 1, 2, 3, etc.: Apply different number formats

These shortcuts can significantly increase your efficiency when working with Excel as a data analyst.

One of the very important tool that a data analyst must be aware of is Excel

Best practices for writing SQL queries:

Join for more: https://t.iss.one/learndataanalysis

1- Write SQL keywords in capital letters.

2- Use table aliases with columns when you are joining multiple tables.

3- Never use select *, always mention list of columns in select clause.

4- Add useful comments wherever you write complex logic. Avoid too many comments.

5- Use joins instead of subqueries when possible for better performance.

6- Create CTEs instead of multiple sub queries , it will make your query easy to read.

7- Join tables using JOIN keywords instead of writing join condition in where clause for better readability.

8- Never use order by in sub queries , It will unnecessary increase runtime.

9- If you know there are no duplicates in 2 tables, use UNION ALL instead of UNION for better performance.

SQL Basics: https://t.iss.one/sqlanalyst/105

Huge Placement material giveaway 👇👇
https://www.linkedin.com/posts/sqlspecialist_huge-all-company-placement-material-kit-ugcPost-7171381573676740608-qcq8?utm_source=share&utm_medium=member_android

Want to practice for your next interview?

Then use this prompt and ask Chat GPT to act as an interviewer 😄👇 (Tap to copy)

I want you to act as an interviewer. I will be the
candidate and you will ask me the
interview questions for the position position. I
want you to only reply as the interviewer.
Do not write all the conservation at once. I
want you to only do the interview with me.
Ask me the questions and wait for my answers.
Do not write explanations. Ask me the
questions one by one like an interviewer does
and wait for my answers. My first
sentence is "Hi"

Now see how it goes. All the best for your preparation
Like this post if you need more content like this👍❤️

If you are confused about when to start applying for data analytics jobs, then this post is just for you 👇👇
https://www.linkedin.com/posts/sql-analysts_dataanalytics-careeradvice-jobsearchtips-activity-7171737653485133824-DuoT?utm_source=share&utm_medium=member_android

Free SQL Books Giveaway 👇
https://www.linkedin.com/posts/sqlspecialist_dataanalytics-datascientists-sqlbooks-activity-7172081021956354048-k1m9?utm_source=share&utm_medium=member_android

🥳🚀When delving into data analytics and initiating your SQL journey, prioritize mastering the fundamental concepts that address the majority of problems before delving into other topics.

👉🏻 Basic Aggregation function:
1️⃣ AVG
2️⃣ COUNT
3️⃣ SUM
4️⃣ MIN
5️⃣ MAX

👉🏻 JOINS
1️⃣ Left
2️⃣ Inner
3️⃣ Self (Important, Practice questions on self join)

👉🏻 Windows Function (Important)
1️⃣ Learn how partitioning works
2️⃣ Learn the different use cases where Ranking/Numbering Functions are used? ( ROW_NUMBER,RANK, DENSE_RANK, NTILE)
3️⃣ Use Cases of LEAD & LAG functions
4️⃣ Use cases of Aggregate window functions

👉🏻 GROUP BY
👉🏻 WHERE vs HAVING
👉🏻 CASE STATEMENT
👉🏻 UNION vs Union ALL
👉🏻 LOGICAL OPERATORS

Other Commonly used functions:
👉🏻 IFNULL
👉🏻 COALESCE
👉🏻 ROUND
👉🏻 Working with Date Functions
1️⃣ EXTRACTING YEAR/MONTH/WEEK/DAY
2️⃣ Calculating date differences

👉🏻CTE
👉🏻Views & Triggers (optional)

Here is an amazing resources to learn & practice SQL: https://t.iss.one/sqlanalyst/195

Hope it helps in your SQL learning 📚

Data Analysis vs Data Science

Data analysis often focuses on interpreting and summarizing existing data, requiring skills like statistical analysis, SQL, and data visualization.
On the other hand, data science involves a broader set of skills, including machine learning, predictive modeling, and advanced programming.

In essence, data analysis is a subset of data science, with data scientists often having a more extensive toolkit for handling complex and unstructured data.

Free Resources to become data analyst -> https://www.linkedin.com/posts/sql-analysts_freecertificates-dataanalysts-python-activity-7113004712412524545-Uw4k

Steps to become data scientist -> https://t.iss.one/learndataanalysis/559

Skills need for everyday data analysis jobs

Data visualization is one of the steps of the data science process, which states that after data has been collected, processed and modeled, it must be visualized for conclusions to be made.

When a data scientist is writing advanced predictive analytics or machine learning (ML) algorithms, it becomes important to visualize the outputs to monitor results and ensure that models are performing as intended.

This is because visualizations of complex algorithms are generally easier to interpret than numerical outputs.

Learning Excel for data analytics can be a valuable skill. Here are some steps you can take to learn Excel topics for data analytics:

1. Take an online course: There are many online courses available that specifically focus on Excel for data analytics. Look for courses on platforms like Coursera, Udemy, or LinkedIn Learning.

2. Practice with datasets: The best way to learn Excel is by practicing with real-world datasets. You can find datasets online on websites like Kaggle or data.gov. Practice manipulating and analyzing the data using Excel functions and tools.

3. Learn important functions: Familiarize yourself with important Excel functions for data analysis such as VLOOKUP, INDEX-MATCH, SUMIFS, AVERAGEIFS, COUNTIFS, and PivotTables.

4. Master data visualization: Excel offers powerful tools for data visualization such as charts and graphs. Learn how to create visually appealing and informative charts to present your data effectively.

5. Explore advanced features: Excel has many advanced features that can be useful for data analytics, such as Power Query, Power Pivot, and macros. Take the time to explore these features and understand how they can enhance your data analysis capabilities.

6. Join online communities: Join online forums and communities dedicated to Excel and data analytics. This can be a great way to ask questions, share knowledge, and learn from others who are also interested in data analytics.

7. Practice regularly: Like any skill, learning Excel for data analytics requires regular practice. Set aside time each week to practice your Excel skills and work on different data analysis projects.

Join for more excel resources: https://t.iss.one/excel_analyst

If you’re trying to get a job in data analytics, simplify your roadmap through SPN(skills, portfolio, network) Method:

1. Learn the Skills :-

What to Learn: Focus on mastering SQL, Excel, and a data visualization tool like Tableau or Power BI.

How to Learn: Utilize online resources, tutorials, and practice exercises to hone your skills.

2. Build Your Portfolio :-

Why it's Important: A portfolio showcases your abilities to potential employers.

How to Build: Create a free website using platforms like Wix or Wordpress.

What to Include: Write-ups of your projects, detailing the business problems you've tackled and the methods you've used. Provide links to your code and dashboards.

3. Expand Your Network :-

Why Network: Building connections increases your chances of landing a job.

Where to Network: Connect with professionals on LinkedIn, attend local data meetups, and engage in industry-related events.

How to Network: Interact genuinely with others, avoiding spammy or impersonal outreach tactics.

4. Stay Positive and Persistent:-

Why it Matters: Job hunting can be challenging, but maintaining a positive attitude and persevering is key.

How to Stay Motivated: Believe in your abilities and keep pushing forward despite obstacles.

Conclusion: Keep Going!

Final Encouragement: You've got what it takes. Keep learning, networking, and persevering. You'll reach your goals!

If it's useful give us 👍

Top 10 Difficult SQL Interview Questions 👇👇
https://www.linkedin.com/posts/sql-analysts_top-10-difficult-sql-interview-questions-activity-7176816116885774339-rqrt?utm_source=share&utm_medium=member_android

Let me know in comments if you want to continue the series or need answers as well. Also ping your answers if you know any.
These are bit advanced questions, so I don't expect everyone to solve it but some of you can try 😄

Best Way to Learn SQL in 2024
👇👇
https://www.linkedin.com/posts/sql-analysts_codecademy-sql-dataanalytics-activity-7177170950881218560-MdKt?utm_source=share&utm_medium=member_android

Biggest Telegram channel for data analysts
👇👇
https://t.iss.one/sqlspecialist