Analytical Aakriti | The SQL Gal
@Aakriti_Sarma
Followers
71,663
Following
144
Media
313
Statuses
2,628
Open for DevRel roles! Data Nerd | Technical Writer | SQL Obsessed | Python Possessed | Let's dig into data the simple, effective and no nonsense way 📊
Mumbai, India
Joined September 2020
Don't wanna be here?
Send us removal request.
Explore trending content on Musk Viewer
Mbappe
• 486018 Tweets
Kante
• 184871 Tweets
Austria
• 124906 Tweets
Dudu
• 119203 Tweets
Game 5
• 95258 Tweets
JULIANA AL 9009
• 91744 Tweets
Ceci Flores
• 77372 Tweets
#WWERaw
• 65960 Tweets
Atlético
• 43840 Tweets
ニンダイ
• 42668 Tweets
Hulk
• 39994 Tweets
Seth
• 36576 Tweets
土砂降り
• 23711 Tweets
#ラヴィット
• 22934 Tweets
Finn
• 21775 Tweets
Juiz
• 20882 Tweets
Rony
• 20608 Tweets
Otis
• 19148 Tweets
كانتي
• 18341 Tweets
MITB
• 15404 Tweets
Estevão
• 14357 Tweets
大雨の中
• 13110 Tweets
大雨の日
• 10011 Tweets
Pinned Tweet
SQL is the undisputed king of the Data industry.
Data engineers, Data Scientists, Data Analysts all play with it on a daily basis. Here's how you hone your SQL skills for the upcoming hiring season 💰
177
2K
10K
FREE Linkedin Learning Courses for Data Analysis 👇📊
147
3K
10K
SQL is the most essential skill in the Data Industry.
Analysts, Scientists, Engineers all use it at some level. If you are eyeing any of these roles, learn it for free here ⤵️
87
2K
8K
It's 1st of October today.
You have 3 more months to crush SQL before 2022 ends.
A Zero to SQL 90 Days Roadmap 📆
154
2K
7K
SQL is the meat and potatoes of Data Analytics. A must-have skill no matter which industry you want to get into.
Sharpen your skills through case studies here ⏬
195
2K
7K
Love SQL? Love playing games?
Let's learn SQL through games! 🕹️
Presenting to you 4 fun games to practice your SQL skills 🔽
172
2K
7K
DATA ANALYSTS UNITE!
Google has launched 'Interview Warmup', a tool that lets you practice answering questions to get more confident and comfortable with the interview process and gain insights. Data Analytics is one of the 6 fields it currently offers.
116
2K
6K
SQL has changed my life and I am sure it'll change yours.
Here's how I learnt SQL ⏬
137
2K
6K
Friendly reminder to start your Data Analytics journey NOW.
Resources down below 👇
132
2K
6K
Getting paid for learning Data Analysis?
I wouldn't wanna miss this 👇
133
1K
5K
SQL is the backbone of Data Analysis.
The sooner you learn, the more you earn.
Here are 3 Youtube playlists that teach it to you for FREE👇
102
2K
5K
How I would study Data Analytics if I had to start over :
📚 Excel : Youtube + Projects
📚 Tableau : Youtube + Projects
📚 SQL : SQLBolt + Case Studies
📚 Python : learnpython .org + Projects
📚 Portfolio building
91
1K
5K
Data Analyst Skill Set Checklist
✅ Math and Statistics
✅ Excel
✅ SQL
✅ Data Visualization (Tableau/ Power BI)
✅ Data Cleaning
✅ Scripting Language ( Python / R )
✅ Data Storytelling
✅ Presentation
✅ Communication
Learn ALL these for $1. Details below 👇
62
1K
5K
SQL has been and continues to be the majority of the Data Analysis pipeline.
Make yourself SQL ready with these FREE courses now ⛳
86
1K
5K
Python is the
#1
in-demand skill in the tech world right now and the best addition to your Data Analysis toolbelt.
Learn it for FREE with these beginner friendly courses 🔽
65
1K
4K
'Learn SQL' is short for 'FUTUREPROOF YOUR GOD DAMN CAREER'
Period.
36
560
4K
Most recruiters prefer a Portfolio over a Resume.
Building your Data Analyst Portfolio is the biggest investment you can do to your career!
START here ⏬
66
840
4K
Crush Data Analytics in the second half of 2022 🎯
🏹July - Statistics
🏹August - Excel
🏹September - Tableau / Power BI
🏹October - SQL
🏹November - Python
🏹December - Projects + Interview Prep
112
858
3K
Learn the entire Data Analysis stack FOR FREE!
Resources 👇
109
1K
3K
10 Data Analysis Cheatsheets to kickstart your interview prep 🏁
Download links attached 👇
108
1K
3K
Top 5 SQL Concepts to get ready for interview season 🍂
+ FAANG questions to practice each ⏩
96
798
3K
I can't stress enough how big of a blessing Khan Academy is on the internet. High quality, free courses available for almost any skill you can think of.
Here's how you can leverage it for your Data journey ⏬
43
634
3K
I regret learning Python.
- said no one ever.
80
248
3K
This is your sign to practice SQL this weekend 🏆
A list of my favorite questions asked by FAANG and other top tech companies you can start with, no matter which learning level you are at 🏅
49
638
3K
Start your Data Analytics journey with courses that pay YOU 🤑
Here are the ones I recommend 🚀
( Offer ends tonight, Don't just bookmark, Act NOW )
63
743
2K
If you aspire to be in the Data industry. Make Kaggle your best friend. It's rich in content, beginner-friendly and free to use.
Here's how you can explore this goldmine today 🥇
48
692
2K
The Data Analysis End-to-End Project Tech stack📚
🎲 Data Collection - Python ( Scrapy, Beautiful Soup )
🎲 Data Cleaning - SQL / Python ( Pandas )
🎲 Data Visualization - Tableau / Microsoft PowerBI
🎲 Data Modelling - Python ( Scikit-learn, Pytorch...)
29
591
2K
FUTURE DATA ANALYSTS UNITE! 💪
If you are learning the Data Analysis tech stack and preparing for interviews I have some GOOD news for you! 🔥
Follow along 👇
38
477
2K
Data Analysis Roadmap with FREE resources to start your week on a high note 📈 👇
25
527
2K
5 Chrome Extensions to create a 10x effective Data Analysis Portfolio 📈
56
489
2K
Data Analysis Project Ideas that'll set you apart Part 2 ( from the community ):
💡 Energy Consumption Analysis
💡 Depression Rates Analysis
💡 Inflation Rates Evolution Analysis
💡 Air Quality Analysis
💡 Student Dropout Analysis
💡 Movie/TV series Sentiment Analysis
27
520
2K
5 Beginner Data Analysis projects that help you check all the boxes✅
🏅 Data visualization ( Tableau / BI )
🏅 Data Cleaning ( SQL / Excel )
🏅 EDA ( Python / R )
🏅 Web Scraping ( Python )
🏅 Sentiment Analysis ( Python / R )
35
409
2K
Data Cleaning is a HUGE part of a Data Analyst's day.
Here are some SQL functions that come in handy :
🧼 CAST
🧼 TRIM
🧼 SUBSTR
🧼 LEFT/RIGHT
🧼 STRPOS
🧼 EXTRACT
🧼 COALESCE
🧼 CONCAT
13
394
2K
1 Project >>>>>>>>>>>>>> 100 Tutorials
5 places to find datasets for your next Portfolio project:
💽 kaggle .com/datasets
💽 data .world
💽 datasetsearch .research .google .com
💽 paperswithcode .com/datasets
💽 archive .ics .uci .edu/ml/datasets.php
30
465
2K
SQL, Excel and Tableau : The Holy Trinity of Data Analytics 🎇
What's your superpower?⚔️
118
288
2K
My TOP 3 Data visualization books for all the aspiring Data Analysts out here -
📘 "Storytelling With Data” by Cole Nussbaumer Knaflic
📕 "Visualize This” by Nathan Yau
📙 "The Big Book of Dashboards” by Steve Wexler, Jeffrey Shaffer, and Andy Cotgreave
24
413
2K
Here's a step by step guide I would follow if I started Data Analytics today 👇
( and save you $100 )
38
411
2K
Twitter got me an internship y'all. Starting today🥳
106
17
2K
I went down the ultimate Data Analyst rabbit hole this weekend.
🤓Did so many SQL exercises, thanks to my newly found addiction of
🤓Learnt so many new ways of visualizing data in Tableau
Get ready for so many more threads on each!
26
302
2K
Must follow topics to follow on Medium to get top notch Data Analysis content :
📖 Data
📖 Data Analytics
📖 Data Analysis
📖 Python
📖 Data Visualization
📖 Tableau
📖 Power BI
📖 Data Analyst
15
277
2K
Data Analysis Project Ideas that'll set you apart:
💡Covid-19 Impacts Analysis
💡Russia-Ukraine War: Twitter Sentiment Analysis
💡Uber Trips Analysis
💡Water Quality Analysis
💡Worldwide Billionaires Analysis
💡Unemployment Analysis
💡Financial Budget Analysis
43
482
2K
Favorite Youtube channels for Data Analytics content Part 2 (from the community) :
📺 Codebasics
📺 Luke Barouse
📺 Thu vu analytics
📺 Shashank Kalanithi
📺 Sundas Khalid
📺The worklifeman
📺 David Data
📺 Tina Huang
22
330
2K
Top Data Analyst skills as listed on Linkedin job adverts :
🪄 SQL
🪄 Excel
🪄 Python
🪄 Tableau
🪄 R
🪄 Power BI
26
334
1K
Gold mine channels worth checking out -
🏅 StatQuest with Josh Starmer - Statistics and ML
🏅 Luke Barousse - Data Anlaytics
🏅 Alex the Analyst - Data Anlaytics
🏅 sentdex - Python
🏅 Abdul Bari - DSA
🏅 Krish Naik - Data Science and Analytics
17
331
2K
8000+ friends, thank you for everything 🌻
If you are interested in:
🐍 Python
🐼 Pandas
📗 Microsoft Excel
🗃️ SQL
📈 Tableau
👩🔬 Data Science
🤖 Machine Learning
📊 Data Analytics
Follow me ☑️
A thread of all the content I have shared on Twitter you won't want to miss.🥳
39
244
1K
Excel :
SQL :
Tableau :
Python :
42
427
1K
12k+ friends🥺, thank you for everything 🌻
If you are interested in:
🐍 Python
🐼 Pandas
📗 Microsoft Excel
🗃️ SQL
📈 Tableau
👩🔬 Data Science
🤖 Machine Learning
📊 Data Analytics
Follow me ☑️
A thread of all the content I have shared on Twitter you won't want to miss.🥳
24
189
1K
Weekends are for Portfolio Projects 📈
5 uncommon websites to find good quality datasets for your next project 👇
50
337
1K
The hiring season will be here before you know it 💰
Make yourself Data Science interview ready with these resources ⏬
21
333
1K
Data Visualization is an integral part of any Data Analysis process and an essential skill to have when breaking into tech, learn it here 👇
26
284
1K
Are you just getting started with SQL?
Here's a 6-part blog series to walk you through it.
Happy Learning🌻
45
309
1K
Excel is an essential requirement in the Data Analytics field and a great add-on to your skillset no matter what your field.
An excellent resource to learn EXCEL the easy way using illustrations for FREE🖼️
13
351
1K
Where my afraid to get started with coding folks at?
This one's for you. Kaggle launched a hands-on micro course, this time with no coding experience required.
A 5-hour course introducing you to one of the most in demand skills in the world, Python. Link below ⬇️
20
242
1K
PORTFOLIOS are replacing resumes in the hiring world. Here are some of the best Data Analyst portfolios I have come across :
✨ claudiatenhoope .com
✨ naledi .co.uk
✨ gerinberg .com
✨ ameskle .com/data-portfolio
✨ denacoduri .com/portfolio/
16
276
1K
Dear Data Analyst,
May 2023 be the year you ace Data Analysis!✨
A 4 step framework to help you through👇
20
210
1K
Where to host your Data Analyst Portfolio -
🍭 Python / SQL code files - Github
🍭 Visualizations - Tableau Public
🍭 Report/Presentation - Google Drive
Link them all together on your website and get paid🥳
20
246
1K
How I learnt my Data Analytics stack :
📊 Python - Sololearn
📊 SQL - High school textbook + Mode
📊 Tableau - Linkedin Learning
📊 Excel - Youtube
Upcoming -
📊 Salesforce - Trailhead
📊 BI - Linkedin Learning
12
222
1K
A Day as a Data Analyst -
What people think :
❎ Make charts and dashboards
What it really is :
✅ Gather data
✅ Clean data
✅ Analyze data
✅ Meet with stakeholders
✅ Share the results in a more understandable form
Who's up for the challenge?🔥
85
181
1K
For a Data Analyst, a portfolio is monumental in the hiring process, places you can host your Data Analyst portfolio -
👣 Personal website
👣 Tableau Public
👣 Github
👣 Wix
👣 Kaggle
10
254
1K
Machine Learning enthusiasts, open this 👇
23
250
1K
SQL is a must-have skill as a Data Analyst and comprises a huge part of the interview process.
Practice it here:
🧑💻Leetcode
🧑💻Hackerrank
🧑💻W3Schools
🧑💻StrataScratch
🧑💻Lintcode
🧑💻SQLPad
16
246
1K
Learn Tableau for FREE from there Youtube channels :
🏆 Alex the Analyst
🏆 Simplilearn
🏆 Edureka
🏆 Art of Visualization
🏆 Tableau Tim
19
272
1K
Hi 🌻
If you are interested in:
🐍 Python
🐼 Pandas
📗 Microsoft Excel
🗃️ SQL
📈 Tableau
🕰️ Microsoft Power BI
👩🔬 Data Science
🤖 Machine Learning
📊 Data Analytics
Follow me ☑️
I'm planning on using Twitter to share a lot of content that you won't want to miss.🥳
28
113
1K
5000+ friends, super grateful 🌻
If you are interested in:
🐍 Python
🐼 Pandas
📗 Microsoft Excel
🗃️ SQL
📈 Tableau
👩🔬 Data Science
🤖 Machine Learning
📊 Data Analytics
Follow me ☑️
A thread of all the content I have shared on Twitter you won't want to miss.🥳
19
165
1K
Thousands of people embark on their Data Analysis journey each day.
Good for you, not many continue.
So I created an easy to follow, effective, free curriculum that keeps you accountable. Introducing -
✨ 15 DAYS OF SQL ✨
28
239
995
Quality Projects are the best and ONLY way to stand out from the piles of resume recruiters receives every day!
4 FREE live trainings to create awesome Data Analysis projects 🔥 👇
29
258
972
50000+ followers on this bird app. Truly grateful ❤️
I talk about :
🐍 Python
🐼 Pandas
📗 Microsoft Excel
🗃️ SQL ( A lot )
📈 Tableau
📊 Data Analytics
If this is something that interests you, let's grow together ✨
GIVEAWAY details below 👇
32
191
948
What's stopping you from learning SQL?
121
140
929
Project-centered learning playlists for Data Analysts on Youtube🌭
🌭 Alex The Analyst's Data Analyst Portfolio Projects
🌭 codebasics' Data Analysis Projects
🌭 Ali Ahmad's Data Analyst Portfolio Project
17
220
942
Youtube is free university if you know how to leverage it properly.
Youtube channels providing top notch Excel content -
📗 excelisfun
📗 TeachExcel
📗 Excel Campus - Jon
📗 Alex the Analyst
📗 Kelvin Stratvert
14
264
940
Who's looking to learn Data Analysis in the coming months of 2022?
Blog dropping soon 👀
57
161
896
This week
@DataCamp
is giving away all it's courses for free.
Python. SQL. Tableau. Power BI.
And all things Data.
For FREE.
ALL WEEK.
11
244
892
Interesting websites to find data for your next project:
🔥 Crime Data -murderdata .org/
🔥 NYC Data - opendata.cityofnewyork .us/
🔥 NASA Data - data.nasa .gov/browse
🔥 WHO Covid Data - covid19.who .int/data
🔥 Yelp Data - www.yelp .com/dataset
Tutorial for each dropping soon!
19
273
903
Online tools to learn and practice SQL:
🐬 W3Schools
🐬 Hackerrank
🐬 DB-Fiddle
🐬 Datacamp
🐬 SQLZoo
🐬 Oracle LIVE SQL
Having practical knowledge of SQL is one of the key requirements for Data Analyst roles. Thanks to these tools, you can now practice them on your browser!
11
284
884
I get this question a lot so here's the best-detailed answer I could find.
Difference between Data Analyst📊 and Data Scientist🤖
10
242
872
Sites that teach you Python for FREE :
🐍 Freecodecamp
🐍 Sololearn
🐍 pythonforbeginners .com
🐍 Kaggle
🐍 learnpython .org
🐍 W3Schools
🐍 Programming with Mosh on Youtube
16
218
863
SQL is a superpower.
Master it.
Get started.
Get that tech bag💰
14
100
842
This is your sign to start learning Data Analytics and secure that tech bag💰
Not sure how? I got you!
Link in the comments ⬇️
14
177
825
Woke up early and brought this into existence!
Data wizards, let me know how you feel?
53
84
778
SQL Interview Checklist:
✅ Joins
✅ Datatypes
✅ Subqueries
✅ Nested Queries
✅ String formatting
✅ Window Functions
✅ DML Commands
✅ DDL Commands
✅ Views
✅ Pivot
✅ Keys
6
166
788
It's the last month of the year.
Make it count.
Learn SQL.
27
96
775
It's that time of the year round the corner again.
To help you, I have created a list of 100+ Data Analyst interview questions covering all areas and topics💼
Reply with your dream company/industry and I'll DM it to you.
Must be following so I can DM.
Go🚀
278
128
764
If you want to get started with Data but fear coding.
You don't have to learn a heck ton of languages.
1. SQL
2. R OR Python
Get started.
FREE Resources down below👇
26
156
773
SQL Queries I use daily as a Data Analyst:
🐷 Count per Category
🐷 Distinct Values
🐷 Selection by date component
🐷 Cumulative total
🐷 Joining tables
🐷 Pattern matching
🐷 Updating values
Reply below with yours!🐷
16
145
773
Data Visualization Tools you can learn as a Data Analyst:
🧩 Tableau
🧩 Microsoft Power BI
🧩 Qlik
🧩 Looker
🧩 ZOHO
🧩 IBM Watson
Pick ONE. Get started. Get Paid💰
25
174
760
Excel ✅
Data viz tool✅
SQL ✅
So what next? Here's what I suggest👇
🪐 Get experience with real world data
🪐 Build projects
🪐 Learn Python or R
🪐 Host your portfolio
🪐 Build an online presence
11
153
722
SQL is the most in-demand skill in the data industry. Here's why you should learn it :
📝Beginner friendly
📝The learning curve is easy and gradual
📝Can be integrated with almost any software and language.
📝Data Analyst/Scientist/Engineer, it is a key skill for all roles.
14
144
728
Basic Python Pandas that come in handy as a Data Analyst :
🐼 read_csv / read_excel
🐼 iloc
🐼 loc
🐼 map
🐼 apply
🐼 groupby
🐼 sort_values
🐼 rename
🐼 replace
🐼 concat
🐼 astype
🐼 fillna
🐼 join
19
162
712
How to launch your career as a freelancer in Data Analytics :
🚀 Learn SQL , Excel and Data Viz
🚀 Create a portfolio
🚀 Build your brand
🚀 Work on your communication skills
🚀 Network, network, network
15
145
717
My favorite channels on Youtube for Data Analytics content :
📺 Alex the Analyst
📺 Luke Barousse
📺 Krish Naik
Tell me yours👇
33
150
711
5 Project Ideas if you are getting started with Data Analytics / Data Science📈
☃️Dashboard using Tableau/Power BI
☃️Data Cleaning using Excel/Pandas
☃️Data Exploration using Excel/Pandas
☃️Data Wrangling using SQL
☃️Forecasting report
18
152
712
Data Analyst Portfolio Checklist📜
✅ Data viz dashboard
✅ EDA
✅ Data Cleaning with SQL
✅ Python scripting
✅ Report
14
133
698
Results came out. Officially an engineer now 🤸
57
19
698
Learn with case studies, code snippets and public datasets on the browser with Mode!
1
93
708
What People think Dashboard creation looks like :
Data -> Dashboard
What is actually looks like :
Scraping -> Data -> Excel/SQL -> Clean Data -> Palette Selection -> Figma -> Template -> Tableau -> Dashboard
Just saying🙃
12
115
699
Essential Python Pandas concepts for Data Analysts-
🐼 Dataframe creation
🐼 Merging dataframes
🐼 Concatenating dataframes
🐼 Filtering
🐼 Grouping
🐼 Sorting dataframe
🐼 Fill NaN cells
🐼 Apply Lamda Functions
🐼 Category counting
11
149
690
📂Data Analytics Learning Path
∟📂Overwhelming
∟DBT
∟Informatica
∟Databricks
∟Salesforce
∟Qlikview
∟Talend
∟Splunk <- NO NOT HERE❎
∟📂Essentials
∟Excel
∟SQL
∟Any Data viz tool <- START HERE✅
14
119
694
Planning to step up your SQL game?
Here's your one stop solution with challenges, crash courses, projects and datsets , a treat for us data nerds!
9
185
693
Here's a fun project idea for my Data nerds :
12
131
652
Woke up to my offer letter🥳 , it's a good day🌻
#100DaysOfCode
#webdevelopment
#DEVCommunity
#CodeNewbies
#WomenWhoCode
#WomenInTech
33
48
669