DATA ANALYSIS MADE EASY Academy by @ezekiel_aleke
Everywhere
- Tweets 1,472
- Following 1
- Followers 3,015
- Likes 3,126
Pinned Tweet
Do you wish to learn data analysis?
Here are some free courses you can get started on.
6
51
286
23,187
DATA ANALYSIS MADE EASY retweeted
Power BI vs Excel. What's the real difference in one sentence?
🔘 Power BI just looks nicer
🔘 Power BI connects to live data and updates automatically, Excel mostly doesn't
🔘 They're basically the same thing
1
2
138
DATA ANALYSIS MADE EASY retweeted
Dear Data Analyst!!
You are not competing with AI.
You are competing with the analyst who knows how to use AI.
Learn the tool.
And stay ahead.
8
24
192
6,908
Steps in Data Analysis process:
1. Ask the right question
2. Collect the data
3. Clean the data
4. Analyze the data
5. Visualize the results
6. Share the insight
1
3
186
Here are 5 Excel functions. Which one removes extra spaces from text?
PROPER()
TRIM()
LEN()
LEFT()
CONCATENATE()
2
97
DATA ANALYSIS MADE EASY retweeted
Python for Data Analysis is just:
• Data Collection (CSV, Excel, APIs, Web Scraping)
• Data Cleaning (pandas, numpy)
• Data Analysis (pandas, pivot_table)
• Data Visualization (matplotlib, seaborn, plotly)
• Data Automation (Scripts, Loops, Scheduling)
That’s it
5
40
292
8,864
Here are Logical functions in EXCEL:
IF()
IFS()
AND()
OR()
NOT()
IFERROR()
IFNA()
Comment the one you use the most 👇
6
223
Here are Aggregate functions in EXCEL:
SUM()
AVERAGE()
COUNT()
COUNTA()
COUNTIF()
COUNTIFS()
SUMIF()
SUMIFS()
AVERAGEIF()
MAX()
MIN()
MEDIAN()
Comment your most used one 👇
2
9
334
Take-home lesson: "Rare people get rare opportunities"
Analyst + Excel Only = Limited
Analyst + Excel + SQL = Capable
Analyst + Excel + SQL + Power BI = Valuable
Analyst + Excel + SQL + Power BI + Python = Rare
Analyst + Rare Skills + Portfolio + Network = Highly Paid
Rare people get rare opportunities.
Keep adding skills.
3
278
Here are SQL keywords every beginner should know:
SELECT
FROM
WHERE
GROUP BY
ORDER BY
JOIN
HAVING
LIMIT
DISTINCT
Comment the one you're familiar with👇
5
211
Here are Date functions in EXCEL:
TODAY()
NOW()
DATE()
DATEDIF()
YEAR()
MONTH()
DAY()
WEEKDAY()
NETWORKDAYS()
Bookmark/Save for later 🔥
5
280
New week Dear Data Analysts,
Here are things every beginner analyst should do this week:
1. Clean one messy dataset
2. Practice 3 formulas you're unsure about
3. Build one simple chart
4. Write 2 lines explaining what the data says
5. Ask one question in a data community
1
12
431
The summary of SQL :
SQL is just:
- Data Storage (Tables, Schemas, Databases)
- Data Cleaning (TRIM, REPLACE, CAST, COALESCE)
- Data Retrieval (SELECT, WHERE, ORDER BY, LIMIT)
- Data Analysis (GROUP BY, HAVING, JOINS, SUBQUERIES)
- Data Automation (Views, Stored Procedures, Triggers)
That’s it
2
111
Our students 🔥🔥🔥
Got something different to clean and work on..
#fypシ゚viral
#DataCentres
#data
#all
@DAME_Academy
I'm done with the cleaning process and will begin all navigations soon...
3
150
DATA ANALYSIS MADE EASY retweeted
Data Analyst + Critical Thinking na 5&6 oo
So I am done cleaning 🧹, Organising, EDAing and realistically bringing our messy data to reality.
What do you think guys?
The info worked on was about AI model training and contributors earning.
@ezekiel_aleke
@all
1
3
44
Here are Excel shortcuts every analyst should know :
Ctrl + 1 (Format Cells)
Ctrl + Shift + L (Filter)
Ctrl + T (Table)
Alt + = (AutoSum)
Ctrl + Arrow (Jump to end of data)
F4 (Repeat last action)
Ctrl + Shift + Enter (Array formula)
Comment the one you didn't know until now 👇
1
4
159