🤨 From Zero to Senior Data Analyst


This post will always be pinned📌 at the top👆🏻, and I will regularly add new materials here to help you:

1. Become a data analyst
2. Improve your skills: Python, SQL, Power BI, and other essential tools
3. Prepare for interviews
4. Find a job


Here are some useful posts:


🔥 Free Data Job Simulation Programs with Certificate

⚡️ 20 Step-by-Step Data Analysis Projects with Python Code

⭐️ Learn Python for Data Analysis: Easy Self-Study Roadmap

👨‍💻 5 Platforms to Get Your First Experience as a Data Analyst

📉 Free Data Analysis Course with Certificate

🔥 19 Step-by-step Data Analysis Projects with SQL

🤓 How to Prepare for a Data Analyst Interview?

👨‍💻 3 Free Services for Practicing SQL and Python

🧑‍💻 What laptop should a data analyst choose?

🔥 Free Data Analyst Career Guide and Interview Preparation by IBM*


Subscribe: Analytics and growth mindset

👨‍💻 A Day in the Life of a Data Analyst at Accenture: Free Simulator


Experience the role of a data analyst with this free simulator from Accenture.

Accenture specializes in IT and consulting, boasting a total capital of $26.46 billion and employing 733,000 people.


What's it about?

Your team has been assigned a new project for a client called Social Buzz, where you will act as a data analyst.

The simulator includes 4 tasks and takes about 2–3 hours to complete. During this time, you will perform real tasks from Accenture and learn:

🔻 The responsibilities of a data analyst at Accenture and the team structure
🔻 How to clean, model, and analyze data to gain valuable insights for the client
🔻 How to link business with data and convey current and interesting ideas in presentations
🔻 How to prepare and present ideas to the client in a presentation


Register 👉 Receive video instructions from real employees 👉 Complete the task 👉 Compare your work with the company's sample 👉 Upload your resume 👉 Receive a certificate and the opportunity to connect with recruiters.


Simulator is here: Accenture Data Analytics Simulator.


Other interesting simulators:

- Power BI (PwC)
- Data Visualisation: Empowering Business with Effective Insights (Tata)
- Artificial Intelligence (Cognizant’s)
- Inventory Analysis (lululemon)
- Excel for Businessд (Goldman Sachs)
- All Data Simulators
- All Simulators (not only data)

🤖 10 AI Tools for Data Analysts


These platforms leverage AI and:

- Support natural language queries
- Automate data analysis from import and cleaning to pattern detection, anomaly identification, and ML model development
- Enable analysts to be more productive and tackle complex tasks


⚡️ AI-Enabled Cloud Environment:

1. DataCamp Datalab: A platform for learning and working with data without the need for software installation. Automates routine tasks and ML model prototyping.

⚡️ AI Assistant for Learning and Analysis:

2. ChatGPT Data Analyst - A version of ChatGPT optimized for data analysis tasks.

⚡️ Visualization Platforms with AI:

Tools for creating informative dashboards and analyses.

3. Tableau
4. Microsoft Power BI
5. Polymer
6. IBM Cognos Analytics

⚡️ Simplified ML Model Creation:

Platforms that simplify the process of developing and deploying machine learning models.

7. Google Cloud AutoML
8. DataRobot

⚡️ Comprehensive Open Source Analytical Platform:

Offers a full range of analytical tools from preprocessing to data analysis.

9. KNIME

⚡️ Data Management:

Supports data integration, cleansing, and synchronization for effective data management.

10. Talend


Which one do you use?

✈️ I have several Telegram channels, and I know many of you want to create your own.

I'm planning to make a post or even a video explaining how to create, promote, and monetize Telegram channels.


Both experienced and beginner specialists can develop a Telegram channel, as everyone's experience can be helpful to others! Plus, it could become an additional source of income for you.

——

If you have questions about creating and developing a Telegram channel, leave them in the comments below👇🏻.

If you find the topic interesting but don't have specific questions, just leave a 🔥.

👨‍💻 2 Free Projects to Practice Data Analysis and Python Skills

Here are free hands-on projects from Coursera with no trial periods or card attachments required.

Each project takes about 8 hours to complete.


1. Web Scraping and Analyzing Data Analyst Job Listings with Python

In this project, you will help a recruitment agency find suitable job listings for their clients, giving them an edge over other job seekers. You'll need to extract job listing data from several websites, visualize, and analyze it.

👉 Project

2. Analyzing Social Media Usage Data with Python

In this project, you will work as a data analyst at a marketing firm specializing in brand promotion on social media. Your task is to use Python to extract, clean, and analyze tweets in specific categories (health, family, food, etc.) and create visualizations.

👉 Project

👨‍💻 Working from the Beach and Hot Data Analyst Jobs in Thailand


I'm starting a series of posts about where and how to work as a data analyst abroad.

The first country on the list is Thailand, where I currently live. Thailand actively hires foreigners and offers work visas.


A few facts:

➡️ Many international companies have headquarters in Thailand.

➡️ Thailand attracts IT expats, creating a multinational and innovative environment.

➡️ Digital nomads love Thailand for its fast internet and low cost of living.

➡️ In many IT companies, the working language is English, which is convenient for expats.

Thailand is also a very friendly country.


Key employers in Thailand that hire foreigners:

〰Agoda: A popular online hotel and flight booking company with competitive prices. Over 4000 employees worldwide. Why do we work at Agoda?
〰Grab: The leading ride-hailing app in Southeast Asia, also offering food delivery, grocery delivery, and cashless payments. 6000+ employees.
〰FoodPanda: A tech company with a strong presence in Thailand, with over 9000 employees from 50+ countries. They deliver food with authentic recipes from around the world.
〰Lazada: The largest e-commerce platform in Southeast Asia, offering a wide range of products and services.


Hot job openings:

🔹 Hot analyst jobs (data, marketing, finance, etc.) at Agoda
🔹 Business Intelligence-Data Analysis at Lazada
🔹 [Cooperative Internship 2024] Machine Learning Intern, Data Team at Agoda
🔹 ManEx Data Visualization - Homecare SEA Intern at Unilever
🔹 Sales Operations Analyst at Grab


📍 This list of companies and job openings is not exhaustive. You can search for jobs on company websites and job search websites like LinkedIn Job, JobsDB (these links lead to analyst jobs).


P.S. In the photo, I'm working with my laptop on the beach. I do this about once a week. I've noticed that by the sea, I have a high level of concentration, and work hours fly by. There's a canopy for shade, and there are outlets and Wi-Fi near the loungers, although I use mobile internet because it's excellent here.

🤩🤩🤩 IBM has announced free courses in data analysis and cybersecurity


IBM is one of the leading companies in information technology.

IBM SkillsBuild is their educational program with 1,000 courses in 20 languages, aimed at increasing access to tech education.

Skills in cybersecurity and data analysis are essential for AI innovation, allowing professionals to extract valuable insights, protect data, and make informed decisions in today's world, writes IBM.

Some facts:

〰️ All courses are completely free
〰️ Designed for beginners, providing the basics
〰️ You can get a certificate at the end
〰️ Can be completed within 10 hours


➡️ Data Course: introduces the basic skills for successful work in data
➡️ Artificial Intelligence: basics of AI and machine learning
➡️ Cybersecurity: analysis and protection against cyber threats
➡️ IT Project Management: project management and teamwork
➡️ Web Development: creating and maintaining websites
➡️ Data Science: basics of working with big data and data analysis tools
➡️ Information Technology: IT systems support and maintenance


If you find this content useful, give it a 🔥.

📝📝📝📝 Google has opened applications for a Data Analytics Apprenticeship

The Data Analytics Apprenticeship starts in January 2025 and lasts for 18 months.

Application dates: August 5 to August 15, 2024.

👉The program combines Google's training and on-the-job practice
👉You will gain the skills and practical experience needed for a data analyst
👉You will receive a certificate upon completion

The apprenticeship is paid, with a salary range of $41,000 to $54,500, depending on the hiring process.

Requirements:

👉You should NOT have a bachelor's, master's, or PhD degree in data analytics
👉Less than 1 year of experience as a data analyst
👉Applications are open to residents of any country. However, to participate in the program, you must be in the United States for the entire duration of the training. The apprenticeship guidelines also state that you need a work permit in the US, but you can receive a relocation bonus from Google.

To apply, you need:

1. Resume
2. Essay (answers to 2 questions: why you want to join the program and an example of when you took the initiative to gain new skills and knowledge)

Apply here: Data Analytics Apprenticeship, January 2025 Start

Other upcoming apprenticeships from Google:

👉Information Technology Apprenticeship, January 2025 Start
👉Digital Marketing Apprenticeship, January 2025 Start
👉Project Management Apprenticeship, January 2025 Start
👉User Experience Design Apprenticeship, January 2025 Start

Resources for preparing to work at Google:

1. Resume: tips from Google
2. Google Data Analytics Certificates
3. Interview Warmup: free service from Google to prepare for interviews
4. Interview tips at Google: tips from Google
5. How the hiring process works at Google


If you want to learn about other internships around the world, click 🔥.

👋Guys, I want to share useful materials here. So please answer the questions below👇.

This will help me provide content that's most relevant and beneficial for you.

👨‍💻How to Find a Job When It Seems Impossible?


Especially relevant for beginners.

Job hunting can be compared to a funnel 👆🏻 because the process involves several stages that gradually narrow down from the number of job openings in the market to the number of offers you receive.

You can always manage the funnel at each stage: if you notice problems, adjust your actions.

Few job openings? Expand your search:

👉 Look beyond your usual job sites; explore Telegram channels, other social media, company websites directly, and use networking.
👉 Even if you feel your skills don't perfectly match the job description, apply anyway—sometimes it works out.
👉 Reevaluate your initial criteria. Maybe you need to lower your expectations for now (e.g., location or salary).

Applying to many jobs but getting few interviews? The issue might be your resume:

👉 Tailor your resume to meet the specific job requirements.
👉 If you can't do it on your own, work on your resume with an experienced mentor.

Not getting a second interview after the first one with HR? Analyze your interview:

👉 Review how you answer HR's questions.
👉 Research the company beforehand (how it makes money, who its clients and competitors are); this helps.
👉 Practice on your own or ask a mentor to conduct a mock interview with you.

Failed the technical interview? Analyze the interview:

👉 Identify which topics or tasks were the most challenging.
👉 If possible, ask the employer what specific areas you struggled with during the interview.
👉 Take additional courses or training, and work on practical projects to fill knowledge gaps.
👉 Prepare answers to common questions.
👉 Solve practice problems on free platforms.
👉 Conduct several mock interviews with a mentor.

When job hunting, it's essential to constantly analyze and improve your strategies at each stage. Tracking your conversion rate at each stage can also be helpful.

How does this help?

👉You control the process. You see specific numbers and can influence them (e.g., by improving your resume or changing your job search strategy).
👉Detailing the process helps identify problem areas more effectively.
👉It's easier to track progress at each step, which helps maintain motivation.
👉It helps you realize that rejections are a normal part of the process and that you can influence them.

Useful Resources:
How to Prepare for a Data Analyst Interview?
3 Free Services for Practicing SQL and Python
Free Data Analyst Career Guide and Interview Preparation by IBM
A Day in the Life of a Data Analyst at Accenture: Free Simulator

🔘 Free data analytics courses from Google: for beginner and advanced level


👉 Google Data Analytics Professional Certificate for Beginners.

This course teaches the basics of data analytics, including data cleaning, analysis, and visualization, using tools like spreadsheets, SQL, and R.

👉 Google Advanced Data Analytics Professional Certificate for Advanced Level.

A more advanced course that covers Python, statistics, and machine learning for analyzing and interpreting data.

👉 Google Business Intelligence Professional Certificate for Advanced Level.

This course focuses on business analytics, data modeling, ETL processes, dashboards, and reporting.


❗Important! Instructions to get the course for free:

1. Go to each individual course. The full course consists of 8 individual courses. You can access each one at the bottom of the page.

2. Select "Enroll".

3. Choose the "Audit course" option, which is usually in smaller text.

This way, you gain the knowledge without a certificate. If you need a certificate, you can apply for financial aid from Coursera.

If anything is unclear, I’ve recorded a video with detailed instructions: Video link.

🆕 New data internships and jobs at TikTok, Netflix, and Tesla


New internships and job openings from some of the world’s top companies have become available. If you want to start your career in data analytics or advance it, take a look at these opportunities.


📱TikTok:

Data Analyst Intern (Global E-Commerce-Data Science-AMS Data Science) - Summer 2025 (BS/MS)
👉12-week program starting May/June 2025
👉Hourly rate: $33.25
👉Apply

Data Analyst Graduate (Global E-Commerce-Data Science-Search and Recommend) - 2025 Start (BS/MS)
👉 Base salary: $128,250 - $190,000 annually
👉 Apply

Senior Data Analyst - TikTok Shop (US Operations)
👉Base salary: $101,080 - $220,611 annually
👉Apply

Explore more TikTok opportunities: TikTok Careers


📱Netflix:

Machine Learning Intern, Research (Fall 2024)
👉Hourly range: $40 - $110
👉Apply

Business Analyst, CS Workforce Management
👉Remote work
👉Salary range: $50,000 - $190,000
👉Apply

Explore more Netflix opportunities: Netflix Careers


🔴 Tesla:

Internship, Data Analyst/Data Engineer, Energy (Winter/Spring 2025)
👉Start: January 2025, full-time
👉Salary range: $20.00 - $50.00/hour
👉Apply

Digital Performance Analyst, Energy Digital Platforms
👉Salary range: $68,000 - $234,000 annually
👉Apply

Explore more Tesla opportunities: Tesla Careers

🤩🤩🤩Hi friends! Remember I promised to tell you about Telegram channels?


🟥 I finally shot a video where I:

➡️Share how much I earn from Telegram channels
➡️Give tips based on my 2 years of experience growing Telegram channels

If you're even a beginner in data, I highly recommend starting a blog. It helps a lot. You don't necessarily have to create a blog on Telegram—you can choose the platform you like best.

But first, check out what I have to say about Telegram channels here 👉 THE VIDEO.

👋 The question from the interview for a Data Analyst position at Duolingo (Difficulty: Medium)⤵️


➖➖➖➖

Stories Difficulty

Duolingo is a language learning platform. When a student is learning a new language, Duolingo wants to recommend increasingly difficult stories to read.

How would you measure the difficulty level of a story based on how users interact with it?

The question and answers from data analysts are here.


➖➖➖➖

If you want to know the questions asked at different companies for a Data Analyst position and prepare for an interview:

- Non-coding questions are here (free).
- Coding questions are here (free).

❤️‍🔥 Thank you all, guys, for your answers!

As a data analyst, I know how difficult it is to find a data job as a beginner (or even if you're experienced but looking to enter a new market). And I understand your concerns:

➡️ The lack of practical experience and confidence that often holds people back.
➡️ The emotional burnout from constant learning and job searching.
➡️ The fear of not standing out in a highly competitive job market.

I know many people worry they won’t find a job and that all their hard work learning data analytics will be wasted.

That's why I’ve prepared something to help you get an internship or entry-level job and finally start building your career in data analytics.

🚀I will launch this in approximately 2 weeks, so stay tuned for updates!