21 Aug 2025
DAY 60/60 LEARNING DATA ANALYSIS & LANDING A JOB.
I committed myself to a 60 days data analysis learning challenge, and today I’m proud to say I made it to the finish line 🎉
I appreciate everyone who went on this journey with me, thank you 🎉❤️
#60daysoflearningdataanalysis
20
23
344
13,761
18 Aug 2025
DAY 57/60 LEARNING DATA ANALYSIS & LANDING A JOB.
POWER BI PHASE
POWER QUERY EDITOR- this tool is used to import, clean, and transform your dataset before it is loaded into the report view.
#powerbi
#60daysoflearningdataanalysis
2
19
712
16 Aug 2025
DAY 55/60 LEARNING DATA ANALYSIS & LANDING A JOB.
POWER BI PHASE
Started out this phase by Exploring the Power BI interface and learnt how to import Excel data for Creating and managing relationships.
#powerbi
#60daysoflearningdataanalysis
1
9
348
15 Aug 2025
DAY 54/60 LEARNING DATA ANALYSIS & LANDING A JOB.
PYTHON PHASE
DATA VISUALIZATION IN PYTHON- is the using of Python libraries like Matplotlib, seaborn, plotly etc,to create charts, plots or graphs for better understanding of the Dataset.
#python
#60daysoflearningdataanalysis
2
3
16
745
14 Aug 2025
DAY 53/60 LEARNING DATA ANALYSIS & LANDING A JOB.
PYTHON PHASE
AGGREGATION WITH PANDAS- generally refers to combining or summarizing data to get useful insights often by grouping values and applying functions like sum(), mean() etc.
#python
#60daysoflearningdataanalysis
1
5
13
578
13 Aug 2025
DAY 52/60 LEARNING DATA ANALYSIS & LANDING A JOB.
PYTHON PHASE
DATA CLEANING IN PANDAS- is the process of preparing raw data for analysis by detecting and correcting (or removing) errors, inconsistencies, and missing values.
#python
#60daysoflearningdataanalysis
4
14
459
10 Aug 2025
DAY 49/60 LEARNING DATA ANALYSIS & LANDING A JOB.
PYTHON PHASE
MODULES- are files that contain Python code (functions, variables, classes, etc) reusable in other programs.
They help organize code into smaller, manageable pieces
#python
#60daysoflearningdataanalysis
3
12
401
8 Aug 2025
DAY 47/60 LEARNING DATA ANALYSIS & LANDING A JOB.
PYTHON PHASE
LOOPS- are used to execute a block of code repeatedly until a condition is met or a sequence is fully iterated. Eg FOR and WHILE Loops.
#python
#60daysoflearningdataanalysis
1
5
14
535
6 Aug 2025
DAY 45/60 LEARNING DATA ANALYSIS & LANDING A JOB.
PYTHON PHASE
LIST- is an ordered, mutable (changeable) collection of items. Lists can contain elements of any data type, including numbers, strings, and even other lists.
#python
#60daysoflearningdataanalysis
2
4
25
570
5 Aug 2025
DAY 44/60 LEARNING DATA ANALYSIS & LANDING A JOB.
PYTHON PHASE
CONDITIONAL STATEMENT- allow you to control the flow of Python program by executing code only when certain conditions are met, eg IF STATEMENT, ELIF STATEMENT, ELSE STATEMENT.
#python
#60daysoflearningdataanalysis
2
3
14
645
4 Aug 2025
DAY 43/60 LEARNING DATA ANALYSIS & LANDING A JOB.
PYTHON PHASE
DATA TYPE- are classifications that tell the interpreter what kind of value a variable holds, Data types can be checked using;
SYNTAX
Type()
#python
#60daysoflearningdataanalysis
1
3
21
533
3 Aug 2025
DAY 42/60 LEARNING DATA ANALYSIS & LANDING A JOB.
PYTHON PHASE
VARIABLES- is a defined name that reference an object, variables are used to store data to be used or manipulated.
variables are created by assigning it a value using the = sign.
#60daysoflearningdataanalysis
5
3
27
807
2 Aug 2025
DAY 41/60 LEARNING DATA ANALYSIS & LANDING A JOB.
PYTHON PHASE
Kicked off my Python journey by setting up Jupyter Notebook, explored the interface, basic navigations, and wrote my first line of code. Ready to dive deeper!!
#60daysoflearningdataanalysis
1
1
18
428
1 Aug 2025
DAY 40/60 LEARNING DATA ANALYSIS & LANDING A JOB
Concluded my SQL phase with an Exploratory Data Analysis Project which involved using SQL queries to investigate, summarize, and understand the structure, quality, and patterns within a dataset.
#SQL #60daysoflearningdataanalysis
1
6
34
1,103
27 Jul 2025
DAY 35/60 LEARNING DATA ANALYSIS & A JOB.
SQL PHASE
STRING FUNCTION- this functions are used to manipulate, process, or extract information from string/text data in a database.
Examples are LENGTH, CONCAT, SUBSTRING, TRIM, LOWER, UPPER etc.
#SQL #60daysoflearningdataanalysis
2
14
460
23 Jul 2025
DAY 31/60 LEARNING DATA ANALYSIS & A JOB.
SQL PHASE
MULTIPLE JOIN- this is using two or more JOINs in a single SQL query To combine data from three or more tables based on related columns.
#Dataanalysis #SQl #60daysoflearningdataanalysis
2
4
16
756
21 Jul 2025
DAY 29/60 LEARNING DATA ANALYSIS & A JOB.
SQL PHASE
OUTER JOIN
LEFT OUTER JOIN- returns all rows from the left table, & the matching rows from the RIGHT table, If there’s no match, NULLs are returned, and vice versa for the RIGHT OUTER JOIN
#SQl #60daysoflearningdataanalysis
2
5
28
605
17 Jul 2025
DAY 25/60 LEARNING DATA ANALYSIS & LANDING A JOB.
SQL PHASE
ORDER BY - this clause sorts query results in ascending or descending order.
SYNTAX
SELECT column1, column2, ...
FROM tablename
ORDER BY column_name ASC/DESC;
#DataAnalysis #SQl #60daysoflearningdataanalysis
1
3
14
4,606
14 Jul 2025
DAY 22/60 LEARNING DATA ANALYSIS AND LANDING A JOB.
SQL PHASE
WHERE - this clause helps to narrow down your results to specific data that meets your conditions.
SYNTAX
SELECT column1, column2, ..
FROM tablename
WHERE condition;
#DataAnalysis #SQL
#60daysoflearningdataanalysis
1
6
15
3,234
13 Jul 2025
DAY 21/60 LEARNING DATA ANALYSIS AND LANDING A JOB.
SQL PHASE
SELECT - this statement retrieves data from a database:
SYNTAX
SELECT column1, column2, (Specify columns to retrieve )
FROM tablename (Specify the table to retrieve from)
#Dataanalysis #60daysoflearningdataanalysis
1
4
13
618