PJ retweetledi
Yesterday’s class @TechSphereAcad with @ezekiel_aleke marked my transition from Excel to Power BI
We covered:
-Power Query in Excel vs Power Query in Power BI
-Data modeling
-Connecting tables & building relationships
English
PJ
969 posts
PJ
@Praisee__
Data analyst📊 | Learning data analytics in public | Sharing what clicks and what challenges me
Lagos, Nigeria Katılım Şubat 2026
118 Takip Edilen137 Takipçiler
PJ retweetledi
Trying to prove you’re hardworking by not using AI is not the flex.
Today, speed and efficiency matter.
AI is your assistant.
The people who will thrive are not the ones avoiding AI, but the ones who learn how to work with it.
Work smart. Use the tools. Stay relevant
Rishika Gupta@rishikagupta__
Believe it or not AI is making us lazy programmers.
English
PJ retweetledi
Don’t fear AI, work with it.
Just completed a task that would usually take a week in less than 4 hours.
This thing is a beast.
English
PJ retweetledi
AI + your creativity is what is magic.
If you’re not smart.. still, sorry.
English
PJ retweetledi
I finished my first data analytics project on Excel yesterday.
I analyzed sales data for a fictional bike store and shared my findings on Medium.
@faladeoluwasemilore/analyzing-a-bike-stores-6-year-sales-performance-030afe85b80f" target="_blank" rel="nofollow noopener">medium.com/@faladeoluwase…
English
PJ retweetledi
Visualising data in my school 😭
Gentle | Aspiring Data Analyst@databygentle
Nigerian universities teach the right skills on paper but assess them in ways that don't build actual competency
English
PJ retweetledi
Let's take a look at this table:
Messy right?
2 different Orders in a single Orders column
This is a messy data and needs Normalization
What is Normalization? 🧵
Wittig Lyon@ibn_wittig
Should we talk about Normalization in Databases? 1NF, 2NF and 3NF
English
PJ retweetledi
PJ retweetledi
Day 37/120 of my Data Analytics Challenge with Tina
Today, I focused on data cleaning and preparation using Power Query Editor in Power BI, a critical step before building any meaningful analysis.
I learned that good analysis starts with clean, structured data.
English
PJ retweetledi
Currently, this is how it is going.
My students are responsive and are eating good tutorials that are digestine well in them.
EKANEM 📊💹📉@ekanemjr_99
You don’t need to be a data analyst to master Excel! You can boost your productivity, save hours of work, and make smarter decisions with practical Excel skills. We also offer corporate training, helping company teams and staff master Excel for everyday work and reporting.
English
PJ retweetledi
After cleaning the data, computing KPIs, and summarizing with Pivot Tables, My first Excel dashboard is ready. @TechSphereAcad
Thanks to my tutor’s resources @ezekiel_aleke & also got some ideas from @ObohX YouTube channel 🙏
Raji Mariam@Raji_Mariam01
After computing the key KPIs, I summarized the dataset using Pivot Tables to better understand the data and identify patterns. This step made it easier to break down performance and prepare the data for visualization. Next step: Dashboard creation.
English
PJ retweetledi
This is actually my first dashboard on Excel still learning but improving daily.
Started with Excel dashboards, next “Power BI”
If you’re into Data Analytics let’s connect
English
PJ retweetledi
Today , I looked at GROUP BY and AGGREGATE
Nothing much to say here. If you know SQL, it's basically a walk in the park
I honestly see myself using SQL for data cleaning, I have to say it again😹
I just see python a little off
Dare@Dare_0x
Treated INDEXING today Been a while I tried understanding commands in python but I can definitely see how you can use indexing and even multi indexing to greatly improve your filter options when cleaning data
English
PJ retweetledi
SQL Week 1 @TDataImmersed . Ngl, at first it felt overwhelming — esp understanding why my queries kept throwing errors 😅.
By the end of the week,I was able to
✔ Create tables
✔ Insert and update records
✔ Retrieve and filter data
✔ Understand the difference between
Itunu|DataNerd📊🌸✨@mosesmaryy
I'm confused here, in SQL, does it mean 'delete' dont work, because why is every query I wrote by mistake still in the database? and so the new corrected ones runs with an error of 'it already existed'? I have an assignment with deadline😥It my first time📷
English
PJ retweetledi
DAY 9 of MySQL/Git Series
Major statements in SQL can be written in different ways.
Today, I focused on writing multiple CTEs
CTEs are like subqueries… but with headers. You can nest a query inside another, then reference that result from a different CTE.
#buildinpublic
English
PJ retweetledi
Day 36/120 of my Data Analytics Challenge with Tina.
Today’s focus was on understanding Power BI, what it is, why it matters, and how it fits into the data visualization workflow.
Power BI is more than just a reporting tool; it’s a powerful platform that transforms raw data into
English
PJ retweetledi
6. Ctrl + Shift + $ → Apply currency format instantly
7. Ctrl + ` (backtick) → Show all formulas
8. Alt + H + V + S → Open Paste Special menu
9. F2 → Edit active cell quickly
10. Ctrl + Shift + Enter → Create array formula
English
PJ retweetledi
No time is too late for learning a new skill.
I mean no time. I just motivated a close family member very close to 50 to learn AI for video creation.
What this person is creating with AI now come dey fear me… just 3 months in.
Still building confidence but not where she started..
English
PJ retweetledi
Question: Which item was purchased first by the customer after they became a member?
Framework:
WHAT do I need to show?
WHERE is the data?
HOW do I connect them?
HOW do I summarise it?
lets do this together shall we?
using the framework given, try to write an SQL query to answer the above question
GIF
English
PJ retweetledi
