10 Steps to Landing a High Paying Job in Data Analytics
1. Learn SQL - joins & windowing functions is most important
2. Learn Excel- pivoting, lookup, vba, macros is must
3. Learn Dashboarding on POWER BI/ Tableau
4. โ Learn Python basics- mainly pandas, numpy, matplotlib and seaborn libraries
5. โ Know basics of descriptive statistics
6. โ With AI/ copilot integrated in every tool, know how to use it and add to your projects
7. โ Have hands on any 1 cloud platform- AZURE/AWS/GCP
8. โ WORK on atleast 2 end to end projects and create a portfolio of it
9. โ Prepare an ATS friendly resume & start applying
10. โ Attend interviews (you might fail in first 2-3 interviews thats fine),make a list of questions you could not answer & prepare those.
Give more interview to boost your chances through consistent practice & feedback ๐๐
1. Learn SQL - joins & windowing functions is most important
2. Learn Excel- pivoting, lookup, vba, macros is must
3. Learn Dashboarding on POWER BI/ Tableau
4. โ Learn Python basics- mainly pandas, numpy, matplotlib and seaborn libraries
5. โ Know basics of descriptive statistics
6. โ With AI/ copilot integrated in every tool, know how to use it and add to your projects
7. โ Have hands on any 1 cloud platform- AZURE/AWS/GCP
8. โ WORK on atleast 2 end to end projects and create a portfolio of it
9. โ Prepare an ATS friendly resume & start applying
10. โ Attend interviews (you might fail in first 2-3 interviews thats fine),make a list of questions you could not answer & prepare those.
Give more interview to boost your chances through consistent practice & feedback ๐๐
๐13โค10
Data Analysis is not Power BI.
Data Analysis is not Python.
Data Analysis is not Excel.
Data Analysis is not SQL.
Data Analysis is the silent hero pulling strings behind the curtain to transform raw, unstructured data into meaningful insights.
It's an art form that goes beyond the tools. Perhaps it's time we shift our focus from the tools to the art and science of data analysis itself.
Data Analysis is not Python.
Data Analysis is not Excel.
Data Analysis is not SQL.
Data Analysis is the silent hero pulling strings behind the curtain to transform raw, unstructured data into meaningful insights.
It's an art form that goes beyond the tools. Perhaps it's time we shift our focus from the tools to the art and science of data analysis itself.
๐10โค9
Being analytical is a skill, but it's more of a mindset and a second nature
Focusing on just numbers could be analysis, but doesn't necessarily mean you're analytical. E.g. "Sales dropped in Q1 by 5% as compared to Q1 last year in XYZ Region."
What caused this exactly? Season? Event? Product reviews/quality? Customer service decline? Marketing spend? PR? Supply chain? Stock depletion? Price increase? Rebranding?
Or, when validating the data and understanding the root causes, having a very limited approach. "If that data is missing, it's missing..."
Why is it missing? Is it the source? Is it the business decision to not undertake an activity for a time period? Was it there yesterday? Was it supposed to be there? Who can I talk to for understanding the root cause?
A LOT of business users I know are more analytical than the data people in their teams.
So what makes you analytical?
- It's the questions you ask yourself
- It's the dots you connect
- It's the different avenues you explore
- It's the inferences you make
- It's the bigger picture you look at
It's not just numbers or data.
Focusing on just numbers could be analysis, but doesn't necessarily mean you're analytical. E.g. "Sales dropped in Q1 by 5% as compared to Q1 last year in XYZ Region."
What caused this exactly? Season? Event? Product reviews/quality? Customer service decline? Marketing spend? PR? Supply chain? Stock depletion? Price increase? Rebranding?
Or, when validating the data and understanding the root causes, having a very limited approach. "If that data is missing, it's missing..."
Why is it missing? Is it the source? Is it the business decision to not undertake an activity for a time period? Was it there yesterday? Was it supposed to be there? Who can I talk to for understanding the root cause?
A LOT of business users I know are more analytical than the data people in their teams.
So what makes you analytical?
- It's the questions you ask yourself
- It's the dots you connect
- It's the different avenues you explore
- It's the inferences you make
- It's the bigger picture you look at
It's not just numbers or data.
๐9โค5๐ฅ2
I hate to tell you this but...
Bootcamps that tell you they can get you a 6-figure data analyst job within 6 weeks (or even 6 months) are lying to you.
Don't focus on the salary that you might get.
Instead, focus on...
- learning the tools
- starting your portfolio
- revamping your resume
- getting active on LinkedIn
- putting the skills into practice
I guarantee you'll be more successful.
Bootcamps that tell you they can get you a 6-figure data analyst job within 6 weeks (or even 6 months) are lying to you.
Don't focus on the salary that you might get.
Instead, focus on...
- learning the tools
- starting your portfolio
- revamping your resume
- getting active on LinkedIn
- putting the skills into practice
I guarantee you'll be more successful.
๐27โค16๐5
Forwarded from Data Analytics
Someone asked me today if they need to learn Python & Data Structures to become a data analyst. What's the right time to start applying for data analyst interview?
I think this is the common question which many of the other freshers might think of. So, I think it's better to answer it here for everyone's benefit.
The right time to start applying for data analyst positions depends on a few factors:
1. Skills and Experience: Ensure you have the necessary skills (e.g., SQL, Excel, Python/R, data visualization tools like Power BI or Tableau) and some relevant experience, whether through projects, internships, or previous jobs.
2. Preparation: Make sure your resume and LinkedIn profile are updated, and you have a portfolio showcasing your projects and skills. It's also important to prepare for common interview questions and case studies.
3. Job Market: Pay attention to the job market trends. Certain times of the year, like the beginning and middle of the fiscal year, might have more openings due to budget cycles.
4. Personal Readiness: Consider your current situation, including any existing commitments or obligations. You should be able to dedicate time to the job search process.
Generally, a good time to start applying is around 3-6 months before you aim to start a new job. This gives you ample time to go through the application process, which can include multiple interview rounds and potentially some waiting periods.
Also, if you know SQL & have a decent data portfolio, then you don't need to worry much on Python & Data Structures. It's good if you know these but they are not mandatory. You can still confidently apply for data analyst positions without being an expert in Python or data structures. Focus on highlighting your current skills along with hands-on projects in your resume.
Hope it helps :)
I think this is the common question which many of the other freshers might think of. So, I think it's better to answer it here for everyone's benefit.
The right time to start applying for data analyst positions depends on a few factors:
1. Skills and Experience: Ensure you have the necessary skills (e.g., SQL, Excel, Python/R, data visualization tools like Power BI or Tableau) and some relevant experience, whether through projects, internships, or previous jobs.
2. Preparation: Make sure your resume and LinkedIn profile are updated, and you have a portfolio showcasing your projects and skills. It's also important to prepare for common interview questions and case studies.
3. Job Market: Pay attention to the job market trends. Certain times of the year, like the beginning and middle of the fiscal year, might have more openings due to budget cycles.
4. Personal Readiness: Consider your current situation, including any existing commitments or obligations. You should be able to dedicate time to the job search process.
Generally, a good time to start applying is around 3-6 months before you aim to start a new job. This gives you ample time to go through the application process, which can include multiple interview rounds and potentially some waiting periods.
Also, if you know SQL & have a decent data portfolio, then you don't need to worry much on Python & Data Structures. It's good if you know these but they are not mandatory. You can still confidently apply for data analyst positions without being an expert in Python or data structures. Focus on highlighting your current skills along with hands-on projects in your resume.
Hope it helps :)
๐8โค3๐ฅฐ2
Websites to practice SQL queries
๐๐
https://www.linkedin.com/posts/sql-analysts_learning-sql-is-not-enough-you-need-to-practice-activity-7217873462596386816-E65q?
Like for more โค๏ธ
๐๐
https://www.linkedin.com/posts/sql-analysts_learning-sql-is-not-enough-you-need-to-practice-activity-7217873462596386816-E65q?
Like for more โค๏ธ
๐9
Forwarded from Data Analyst Jobs
Many people ask this common question โCan I get a job with just SQL and Excel?โ or โCan I get a job with just Power BI and Python?โ.
The answer to all of those questions is yes.
There are jobs that use only SQL, Tableau, Power BI, Excel, Python, or R or some combination of those.
However, the combination of tools you learn impacts the total number of jobs you are qualified for.
For example, letโs say with just SQL and Excel you are qualified for 10 jobs, but if you add Tableau to that, you are qualified for 50 jobs.
If you have a success rate of landing a job youโre qualified for of 4%, having 5 times as many jobs to go for greatly improves your odds of landing a job.
Does this mean you should go out there and learn every single skill any data analyst job requires?
NO!
Itโs about finding the core tools that many jobs want.
And, in my opinion, those tools are SQL, Excel, and a visualization tool.
With these three tools, you are qualified for the majority of entry level data jobs and many higher level jobs.
So, you can land a job with whatever tools youโre comfortable with.
But if you have the three tools above in your toolbelt, you will have many more jobs to apply for and greatly improve your chances of snagging one.
The answer to all of those questions is yes.
There are jobs that use only SQL, Tableau, Power BI, Excel, Python, or R or some combination of those.
However, the combination of tools you learn impacts the total number of jobs you are qualified for.
For example, letโs say with just SQL and Excel you are qualified for 10 jobs, but if you add Tableau to that, you are qualified for 50 jobs.
If you have a success rate of landing a job youโre qualified for of 4%, having 5 times as many jobs to go for greatly improves your odds of landing a job.
Does this mean you should go out there and learn every single skill any data analyst job requires?
NO!
Itโs about finding the core tools that many jobs want.
And, in my opinion, those tools are SQL, Excel, and a visualization tool.
With these three tools, you are qualified for the majority of entry level data jobs and many higher level jobs.
So, you can land a job with whatever tools youโre comfortable with.
But if you have the three tools above in your toolbelt, you will have many more jobs to apply for and greatly improve your chances of snagging one.
โค8๐5
โค4๐3๐1
Guys, please avoid making excuses or procrastinating. The provided data analytics resources are more than sufficient to start your journey in this field. Stay focused, be consistent, and make the most of these materials. If you're unsure where to start, begin with the SQL tutorials. I'll also include resources for practicing SQL problems online.
The key is to take the initiative. Once you start, you'll better understand how everything works. Engage in the hands-on projects mentioned in the sessions. I'll try enhancing this product in the future without requiring any extra cost.
Feel free to reach out to me if you need any help or guidance. All the best for your future ๐๐
The key is to take the initiative. Once you start, you'll better understand how everything works. Engage in the hands-on projects mentioned in the sessions. I'll try enhancing this product in the future without requiring any extra cost.
Feel free to reach out to me if you need any help or guidance. All the best for your future ๐๐
๐14โค8๐4
๐7
If you're thinking about building a data analytics projects, you don't need another book, video, or blog post.
Just start.
You'll learn 10x more by failing big time than by reading someone else's advice ๐คทโ๏ธ
Just start.
You'll learn 10x more by failing big time than by reading someone else's advice ๐คทโ๏ธ
๐14โค3
Starting exploratory data analysis (EDA) can be tricky. Many of us often feel lost at the beginning. Here's a simple way to get on track: start by creating hypothesis questions and defining KPIs based on your dataset and the field you are working in.
๐ ๐จ๐ฅ๐ฅ๐จ๐ฐ ๐ญ๐ก๐๐ฌ๐ ๐ฌ๐ญ๐๐ฉ๐ฌ ๐ญ๐จ ๐ ๐ฎ๐ข๐๐ ๐ฒ๐จ๐ฎ๐ซ ๐๐๐:
1. ๐ผ๐๐ ๐๐๐๐๐๐๐ ๐๐๐๐ ๐ญ๐๐๐๐ : Learn about the industry and the specific problems you're trying to solve. This will help you know what to look for in your data.
2. ๐ฐ๐ ๐๐๐๐๐๐ ๐ฒ๐๐ ๐ด๐๐๐๐๐๐: Decide on the most important KPIs for your analysis. These should align with your business goals and provide clear insights.
3. ๐ช๐๐๐๐๐ ๐ฏ๐๐๐๐๐๐๐๐๐: Formulate questions that your EDA will try to answer. This keeps your analysis focused and purposeful.
Using these steps will make your EDA process smoother and ensure your results are valuable and relevant.
๐ ๐จ๐ฅ๐ฅ๐จ๐ฐ ๐ญ๐ก๐๐ฌ๐ ๐ฌ๐ญ๐๐ฉ๐ฌ ๐ญ๐จ ๐ ๐ฎ๐ข๐๐ ๐ฒ๐จ๐ฎ๐ซ ๐๐๐:
1. ๐ผ๐๐ ๐๐๐๐๐๐๐ ๐๐๐๐ ๐ญ๐๐๐๐ : Learn about the industry and the specific problems you're trying to solve. This will help you know what to look for in your data.
2. ๐ฐ๐ ๐๐๐๐๐๐ ๐ฒ๐๐ ๐ด๐๐๐๐๐๐: Decide on the most important KPIs for your analysis. These should align with your business goals and provide clear insights.
3. ๐ช๐๐๐๐๐ ๐ฏ๐๐๐๐๐๐๐๐๐: Formulate questions that your EDA will try to answer. This keeps your analysis focused and purposeful.
Using these steps will make your EDA process smoother and ensure your results are valuable and relevant.
๐5โค2