Dear Data Analyst!!

If you just started learning Data Analysis.

This 8 YouTube videos is all you need🔥

🧵 1. Data Analysis Roadmap

This website is literally helps you Analyze Data with just prompts😳

It is an open-source AI Analyst that allows you:

•Chat with your data warehouse
•Generate SQL & Python code from questions
•Auto-build Excel dashboards
•Centralize metric definitions

🧵 That’s exactly what this new open-source project does.

An AI data layer that connects your favorite LLM (GPT, Claude.) directly to your company’s databases.

In short:
- Ask questions in English
- Get SQL, Python, or dashboards instantly

Check it out: github.com/bagofwords1/ba…

35 SQL Interview Questions & Answers You Should Know.

Repost for others

5 Dashboard inspirations you can learn from.

From the best Analysts I know.

1. 2.

35 Excel shortcuts you never knew existed:

Alt + E + S + S: Split text to columns.
Alt + E + S + P: Remove duplicate values.
Alt + E + S + V: Paste values. Alt + E + S + D: Text to columns (delimited).
Alt + E + S + E: Text to columns (fixed width).
Alt + E + A + S: AutoSum (sum selected cells).

35 SQL Interview Questions & Answers You Should Know.

Repost for others

35 SQL Interview Questions & Answers You Should Know.

Repost for others

I spent a week compiling these Data Analysis Cheat Sheets for you.

Open this: 1

You're in an interview, and the interviewer asks,

"Can you tell me about yourself?"

Here is how you can answer: 1. Start with a Brief Introduction about you:

When asked about yourself in an interview.

Mention your name, where you're from, and a bit about your educational background.

Keep it concise and relevant to the job you're applying for.

For example: "My name is [Your Name]. I grew up in [Your City/Town] and recently graduated with a degree in [Your Field]."

If you are looking for Public Datasets to work on Data Analysis or Data Science.

Here are 5 Free Data Sources where you can find one for your next Project:

Rt 1. Awesome Data Github Repository
⁠
github.com/awesomedata/aw…

Dear Data Analyst.

Here is a MEGA thread on courses you need to master EXCEL and SQL on YOUTUBE.

Zero-to-Hero.

For absolutely FREE 1. Ezekiel ''DATA ANALYSIS MADE EASY''

youtube.com/@EzekielAleke

35 Excel shortcuts you never knew existed:

Alt + E + S + S: Split text to columns.
Alt + E + S + P: Remove duplicate values.
Alt + E + S + V: Paste values. Alt + E + S + D: Text to columns (delimited).
Alt + E + S + E: Text to columns (fixed width).
Alt + E + A + S: AutoSum (sum selected cells).

CISCO is offering FREE trainings and certifications for:

- Data Analytics
- Data Science
- Cybersecurity
- Web Dev
- Python
- Operating Systems & IT
- Digital Literacy

Self-paced courses, practice as you learn.

You will get certified after completing the course.

Open this THREAD to get started on your learning.

RT for someone on your TL. Data Analytics

skillsforall.com/course/data-an…

35 Excel shortcuts you never knew existed:

Alt + E + S + S: Split text to columns.
Alt + E + S + P: Remove duplicate values.
Alt + E + S + V: Paste values. Alt + E + S + D: Text to columns (delimited).
Alt + E + S + E: Text to columns (fixed width).
Alt + E + A + S: AutoSum (sum selected cells).

YouTube Channels that helped me when I was starting my career as a Data Analyst.

I am sure they will be helpful to you too.

Like and Retweet for others. If you’re yet to start your Data Analysis journey and looking for where to start.

Or you want to improve your skills.

DATA ANALYSIS MADE EASY is all you need to master Data Analytics.

It will teach you: Excel, SQL, Power BI, DAX and Python

Get it here: selar.co/bpr5

Dear Data Analysts,

Here is a MEGA thread on courses to master EXCEL and SQL on YOUTUBE.

Zero-to-Hero.

For absolutely FREE

RT First learn how to install SQL Server here

Dear Data Analysts,

Master Power BI and Tableau with these YOUTUBE courses, Zero-to-Hero.

Some give Certificate after completion, YES.

For absolutely FREE: 1. Power BI series @Alex_TheAnalyst

m.youtube.com/playlist?list=…

Want to Analyse Data using Excel?

Here are the 10 Most Common Excel Functions I teach all my students.

You should Master it too:

- Thread - As a Data Analyst, you are responsible for collecting, cleansing, and analyzing datasets to aid in problem-solving.

Dear Data Analyst.

If you want to become a Data Analyst.

Here is my New Year gift to you.

Data Analysis Zero-to-Hero FREE resources.

rt 1. Excel @learnitanywhere

m.youtube.com/playlist?list=…

2024 is a year you should take ACTIONS,

Enough of Bookmarking every tweets you see for later.

Bellow are list of Courses you need to start in 2024.

To improve your Resume and get yourself a JOB.

rt for others If you prefer reading books.

Then DATA ANALYSIS MADE EASY is all you need to master Data Analysis in 2024.

It will teach you:

- Excel
- SQL
- Power BI
- Python

Get it here: selar.co/bpr5

Everyone should learn EXCEL irrespective of your profession.

It will put you ahead of the curve.

Here are 5 YouTube videos that will help you master Excel: Excel Functions Playlist YouTube:

m.youtube.com/playlist?list=…