Top Tweets for #LearningDataAnalytics
WHAT IS DATA COLLECTION?
Definition
Data collection is the systematic process of gathering information from different sources to answer questions, understand problems, and make informed decisions.
#DataAnalytics #DataCollection #DataAnalysis #LearningDataAnalytics
Today I learned how to create charts and find simple insights from data.
#DataAnalytics #DataAnalysis #LearningDataAnalytics #Excel #DataVisualization #WomenInTech
Over the next 99 days, Iβll be documenting what I learn, the mistakes I make, the small wins, and how my understanding of data grows.
Letβs see where this journey takes me.π
Day 1/99 β
#LearningDataAnalytics #LearningInPublic
Day 12/30 of #LearningDataAnalytics (Excel)
Today I worked on a full analysis project π
-Explored a real customer dataset
-Derived new columns: age bands, customer value, order weekday, year-month
-Used SUMIFS to break down revenue by country, gender, and age group.
Day 11/30 of #LearningDataAnalytics (Excel)
Today I learnt π:
-Power Query editor Interface
- Use of Power Query
-How power query works
Power query is used for turning messy datasets into clean, structured data thatβs ready for analysis.
#LearningInPublic #LearningExcel
Day 14/30 of #LearningDataAnalytics (Excel)
Today was a full data cleaning practice dayπ
Got my dataset from Claude ai
-I converted the range into a Table, removed all duplicates.
- Checked and fixed spelling errors
- Split Customer Name into First name & Last Name using
Day 13/30 of #LearningDataAnalytics (Excel)
Continued the customer analysis project todayπ:
-I grouped customers by how much they spend, then checked which groups those spending patterns belong to.
Day 1/30 of #LearningDataAnalytics
Started today, and it was purely an introductory class π
Everything I learnt today:
- Meaning of data analysis
- Types of data analysis
- Data analysis process
- Role of a data analyst
- Statistics
#LearningInPublic
Iβm going to start this 30-day challenge of learning data analytics in July when I begin my classes π§πΎπ§πΎ
Day 11/30 of #LearningDataAnalytics (Excel)
Today I learnt π:
-Power Query editor Interface
- Use of Power Query
-How power query works
Power query is used for turning messy datasets into clean, structured data thatβs ready for analysis.
#LearningInPublic #LearningExcel
Day 10/30 of #LearningDataAnalytics (Excel)
Today I practiced π:
-VLOOKUP
-IFERROR
-INDEX/ MATCH
Started learning how to combine functions together. Small shift, but changing the way I think about formulas.
#LearningInPublic #LearningExcel
Day 10/30 of #LearningDataAnalytics (Excel)
Today I practiced π:
-VLOOKUP
-IFERROR
-INDEX/ MATCH
Started learning how to combine functions together. Small shift, but changing the way I think about formulas.
#LearningInPublic #LearningExcel
Day 9/30 of #LearningDataAnalytics (Excel)
Today I learnt π:
-Creating Pivot Tables
-Slicers
-Timelines
They make summarizing and filtering large datasets much faster, turning raw data into clear insights with ease.
#LearningInPublic #LearningExcel
Day 2/30 of #LearningDataAnalytics
Moved into Excel todayπ:
What I learnt:
-The structure : Workbook, Worksheet, Rows, Columns, Cells
-The Basics: save, edit, open files
-Autofill & Flash Fill
-Data Manipulation: Split, Join,Transpose
-Excel Operators
#LearningInPublic
Day 1/30 of #LearningDataAnalytics
Started today, and it was purely an introductory class π
Everything I learnt today:
- Meaning of data analysis
- Types of data analysis
- Data analysis process
- Role of a data analyst
- Statistics
#LearningInPublic
Day 5&6 /30 of #LearningDataAnalytics (Excel)
Missed posting on Day 5, so Iβm combining both days into one today πββοΈπ
I learnt
-Data Validation
-Removing duplicates
-Conditional formatting
-IF functions ( Nested IF, IFS, IFERROR etc )
#LearninginPublic
Day 4/30 of #LearningDataAnalytics (Excel)
Today was all about testing what Iβve learnt so farππ
Practice quiz: 79.16%
Graded quiz: 85.71%
I keep learning, day by day !π
#LearningInPublic
Day 7/30 of #LearningDataAnalytics (Excel)
Today I learnt π:
-Converting data ranges into Tables
-Data Sorting &
-Data Filtering
#LearninginPublic
Day 5&6 /30 of #LearningDataAnalytics (Excel)
Missed posting on Day 5, so Iβm combining both days into one today πββοΈπ
I learnt
-Data Validation
-Removing duplicates
-Conditional formatting
-IF functions ( Nested IF, IFS, IFERROR etc )
#LearninginPublic
Day 8/30 of #LearningDataAnalytics (Excel)
Today I learnt the lookup functionsπ:
-Vlookup (Vertical lookup)
-Hlookup (Horizontal lookup)
-Xlookup (performs both Vlookup & Hlookup)
-Index/Match
Theyβre used for pulling data from large datasets.
#LearninginPublic
Day 7/30 of #LearningDataAnalytics (Excel)
Today I learnt π:
-Converting data ranges into Tables
-Data Sorting &
-Data Filtering
#LearninginPublic
Day 3/30 of #LearningDataAnalytics (Excel)
What I learnt today π:
-Basic Excel Formulas using the equal to (=) sign to start any formula in excel
-Excel Functions( SUM, AVERAGE, MIN/ MAX) etc
-Cell Referencing (3 types)
Relative, Absolute, Mixed.
#Learninginpublic
Day 2/30 of #LearningDataAnalytics
Moved into Excel todayπ:
What I learnt:
-The structure : Workbook, Worksheet, Rows, Columns, Cells
-The Basics: save, edit, open files
-Autofill & Flash Fill
-Data Manipulation: Split, Join,Transpose
-Excel Operators
#LearningInPublic
Na everyday my brain dey fry for this data analysis ππ©π©
God help me oo
I dey class today confusion wan wound me
#learningdataanalytics
#laarningwithTsacademy
Slides are up! SQL class begins today. I hope God helps me understand it causeβ¦ Omo! Fingers crossed shaπ€πΎ. Countdown to 18:00pm π
@ezekiel_aleke @TechSphereAcad
#day55 #60DaysOfTech #SQL #dataanalystinthemaking #LearningWithTS #justagirlwholikesdataπ
Day 16/30 of #LearningDataAnalytics (Excel)
One lesson Iβve learnt from learning data analysis so far is that data tells a story but only when it is cleaned, organized and well interpreted.
#LearningInPublic #LearningExcel
Day 15/30 of #LearningDataAnalytics (Excel)
Today I Learnt the Date Functionsπ:
-TODAY()
-NOW()
-DAY()
-MONTH()
-YEAR()
-EDATE()
-EOMONTH()
-DATEDIF()
-WEEKDAY()
-WEEKNUM()
-Important of Date functions
#LearningInPublic #LearningExcel
Almost done with my capstone project
Completing this milestone means a lot to me cos I had to stretch myself to get thisβ¦.its been long I took up any challenges but this one was really cool π€anyways Iβll show you guys what I came up with once Iβm done
#learningdataanalytics
Day 4/30 of #LearningDataAnalytics (Excel)
Today was all about testing what Iβve learnt so farππ
Practice quiz: 79.16%
Graded quiz: 85.71%
I keep learning, day by day !π
#LearningInPublic
Day 3/30 of #LearningDataAnalytics (Excel)
What I learnt today π:
-Basic Excel Formulas using the equal to (=) sign to start any formula in excel
-Excel Functions( SUM, AVERAGE, MIN/ MAX) etc
-Cell Referencing (3 types)
Relative, Absolute, Mixed.
#Learninginpublic
Day 13/30 of #LearningDataAnalytics (Excel)
Continued the customer analysis project todayπ:
-I grouped customers by how much they spend, then checked which groups those spending patterns belong to.
Day 12/30 of #LearningDataAnalytics (Excel)
Today I worked on a full analysis project π
-Explored a real customer dataset
-Derived new columns: age bands, customer value, order weekday, year-month
-Used SUMIFS to break down revenue by country, gender, and age group.
Another milestone in my Data Analytics journey!
Built this in PowerBi
@ezekiel_aleke @TechSphereAcad
Every project makes me better.
Open to feedback!
#LearningDataAnalytics #PowerBI #ExcelToPowerBI #DataViz #TechNigeria #DevInNigeria #AspiringDataAnalyst #BuildInPublic
Day 9/30 of #LearningDataAnalytics (Excel)
Today I learnt π:
-Creating Pivot Tables
-Slicers
-Timelines
They make summarizing and filtering large datasets much faster, turning raw data into clear insights with ease.
#LearningInPublic #LearningExcel
Day 8/30 of #LearningDataAnalytics (Excel)
Today I learnt the lookup functionsπ:
-Vlookup (Vertical lookup)
-Hlookup (Horizontal lookup)
-Xlookup (performs both Vlookup & Hlookup)
-Index/Match
Theyβre used for pulling data from large datasets.
#LearninginPublic
Last Seen Hashtags on Sotwe
MGAI
Seen from Singapore
unexpected() filter:media
Seen from Mexico
aaliyah hadid
Seen from Malaysia
sexgames
Seen from Malaysia
sex libya
enginakyΓΌrek
Seen from Greece
vicpridecentre
Seen from United States
Ω
ΨΨ§Ψ±Ω
_Ψ³ΩΨ³
Seen from Egypt
rule34
Seen from Mexico
anxiouspandaaa
Seen from United States
Most Popular Users
Elon Musk 
@elonmusk
241.4M followers
Barack Obama
@barackobama
118.8M followers
Cristiano Ronaldo
@cristiano
114.5M followers
Donald J. Trump
@realdonaldtrump
111.9M followers
Narendra Modi
@narendramodi
107.1M followers
Rihanna
@rihanna
98.7M followers
NASA
@nasa
92.3M followers
Justin Bieber
@justinbieber
91.8M followers
KATY PERRY
@katyperry
90M followers
Taylor Swift
@taylorswift13
84M followers
Lady Gaga
@ladygaga
75.5M followers
Virat Kohli
@imvkohli
73.4M followers
Kim Kardashian
@kimkardashian
70.8M followers
YouTube
@youtube
68.7M followers
Neymar Jr
@neymarjr
66.4M followers
Bill Gates
@billgates
65.2M followers
Selena Gomez
@selenagomez
63.1M followers
The Ellen Show
@theellenshow
62.2M followers
CNN
@cnn
61.7M followers
X
@x
60.7M followers