Certified Data Analyst, Sales Copywriter and a certified Virtual assistant
Joined February 2024
- Tweets179
- Following108
- Followers19
- Likes281
I don’t care if you are doing better than I am..
The reason for my fear is that I am not good enough..
I doubt myself because I haven’t gotten so good that I can no longer be ignored.
I will work on my own pace and I will be so good that I’d be hard to ignore.
May your days be long.
Did you guys know it's illegal to say:
"Go into PowerShell and type
irm get.activated.win | iex"
It's also illegal to say:
"Then select your Office or Windows version for activation."
Incredibly illegal.
Franklin retweeted
FREE Introduction to Data Analytics folder.
Contains:
- Data Analytics Starter Kit
- 7+ hours of video lectures
- PDF and .pptx class files
- 1 SQL project and solution
- 1 Business Intelligence project
- 1 complete Power BI dashboard
- Steps to Take
- Data Analytics WhatsApp Group
If you’re interested, like and retweet then comment interested and I’d share the link with you
You make it look easy sir !!!
It’s a Saturday.
What are you learning today?
If nothing let’s talk about SUBQUERY:
Most people struggle with SQL subqueries because they treat them like magic.
They’re not.
A subquery is simply a question inside another question.
Example 👇:
You want employees who earn more than the average salary.
- 1st question (the inner query):
What’s the average salary?
SELECT AVG(salary)
FROM employees
- 2nd question:
Who earns more than that average?
SELECT *
FROM employees
WHERE salary > query1
Full Query:
SELECT *
FROM employees
WHERE salary > (
SELECT AVG(salary)
FROM employees
);
Read it like English:
“Give me employees whose salary is greater than the average salary.”
That’s all a subquery is.
3 rules that will save you pain:
1. Inner query runs first
2. Inner query must return one value (or a compatible set)
3. If you can explain it in English, SQL will obey you
Stop memorizing SQL, but of course you need to know the syntax structure.
Start asking better questions.
That’s how senior analysts think.
#SaturdaySQLTribe.
Group by comes when you perform an aggregation like..
Select jobs, count(application) Num_of application
From Job_Search
Group by jobs
Order by Num_of_appliction Desc;
You group your aggregated column by the non-aggregated column(s) in your select statement.
Data Cleaning is one, if not the most crucial process in Data Analytics.
The veracity of your insight lies mainly on how well your data is cleaned.
Data Cleaning is not only about removing Nulls, Standardization or removing of Duplicates, You clean Data based on NEED.
Using data from #30days data journey with @JudeRaji_
To produce a Bin..
I felt so good doing it, I visualized it and wrote it and it worked 🫡
