DATA ANALYSIS MADE EASY
Open in Telegram
8 760
Subscribers
-324 hours
-187 days
-6030 days
Posts Archive
Google Data Analytics certificate wonât help you land a job
Courses and certificates wonât help you
Hiring managers care about your portfolio of projects
Certificates donât guarantee you have a skill
Projects speak louder than any other thing
Learn the skill and build projects
If you want to learn SQL.
This article will help you for FREE:
Read and subscribe.
https://open.substack.com/pub/ezekielaleke/p/data-analysis-tools-breakdown-part-967?r=lwe3f&utm_campaign=post&utm_medium=web&showWelcomeOnShare=true
Dear Data Analyst!!
If you learn consistently and intentionally.
Youâll attract the right Jobs/Gigs.
And youâll be known.
Keep learning.
Keep buildingđĽ
Dear Data Analyst
For the next 6 months:
⢠Find a mentor
⢠Start with Excel
⢠Learn for at least 1hr/day
⢠Get DATA ANALYSIS MADE EASY
⢠Practice as you learn
⢠Learn Power BI
⢠Learn SQL
⢠Build 2 projects each after learning each skill
⢠Build portfolio
⢠Get a job
If youâre yet to start your 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
I studied Computer Science.
And I was very good in school.
A little bit better than @gbolahaannđ
I started learning Data Analytics in 2019.
On and Off.
I and Gbolahan took Data Analytics seriously in our final semester.
Using YouTube.
When we both realized there is no First Class for usđ
But at least we would still finish with good grades.
And it was easy for us to start with YouTube.
Because weâve been taught almost everything in class.
We graduated late 2021.
2022 we both got our first jobs.
It wasnât easy.
But it was easy for us because of our STEM Background.
If youâre not a STEM student.
You need Patience.
You need research.
You need Consistency.
You need a guide.
You need a mentor.
Iâm rooting for you.
Youâve got thisâ¤ď¸
Data Analysis Tools Breakdown Part 2:
https://open.substack.com/pub/ezekielaleke/p/data-analysis-tools-breakdown-part-e9a?r=lwe3f&utm_campaign=post&utm_medium=web&showWelcomeOnShare=true
Data Analysis tools and what they are best at:
⢠Excel - Data Organization and Storage
⢠Power BI - Data Visualization
⢠SQL - Data Storage and Retrieval
⢠Tableau - Data Visualization
⢠Python - Data Exploration
If youâre less than 2 months old Data Analysis do this:
⢠Learn Excel.
Then work on a project
⢠Learn Power BI
Then work on a project
⢠Learn SQL
Then work on a project
Itâs that easy. Donât complicate itâ¤ď¸
Dear Data Analyst.
DATA ANALYSIS MADE EASY has 1505 readers as of this time.
With a lot of positive reviews.
If youâre not one of them
Start NOW: http://selar.co/bpr5
Dear Data Analyst!!!
If you want to stop everything this year.
There are 2 things you should never stop doing.
1. Donât stop Learning.
2. Donât stop posting your work online.
You donât know who is watching.
A lot of people have gotten Jobs from Twitter.
Data Analysis Tools Breakdown Part 1:
Read and subscribe.
https://open.substack.com/pub/ezekielaleke/p/data-analysis-tools-breakdown-part?r=lwe3f&utm_campaign=post&utm_medium=web&showWelcomeOnShare=true
Data Aggregation Functions in Excel:
⢠SUM
=SUM(A1:A10)
⢠SUMIF
=SUMIF(A1:A10, "North", B1:B10)
â˘SUMIFS
⢠AVERAGE
=AVERAGE(B1:B10)
⢠AVERAGEIF
⢠AVERAGEIFS
⢠COUNT
=COUNT(C1:C10)
⢠COUNTA
=COUNTA(D1:D10)
⢠COUNTIF
=COUNTIF(E1:E10, ">50")
⢠COUNTIFS
⢠MAX
=MAX(F1:F10)
⢠MAXIFS
⢠MIN
=MIN(G1:G10)
⢠MINIFS
⢠PRODUCT
=PRODUCT(I1:tI10)
Dear Data Analyst!!!
A completed project.
Is better than a perfect project.
Learning is Good, but building is Better.
Read and subscribe.
https://open.substack.com/pub/ezekielaleke/p/learning-is-good-but-building-is?r=lwe3f&utm_campaign=post&utm_medium=web&showWelcomeOnShare=true
If you want to learn with a structured courses.
Check out this @udacity course.
Link: imp.i115008.net/QO7d23
They really helped me.
Hopefully they will be valuable to you too.
Dear Data Analyst!!!
If you want to start learning Data Analytics.
Donât start with YouTube.
It wonât do you any good.
Start with a structured course instead.
They will tell you what to learn and how to learn.
Step by step.
This 2025.
Hereâs all you need:
Excel + SQL + Power BI + Python + Networking = đ°đ°đ°
