IEnovate

[IEnovate @IE_novate]

🚀 Day 2 of #30DaysOfData! 📊

Mastered Excel sorting & filtering today! Analyzed student performance and uncovered a strong insight: 100% of students with <75% attendance failed their course.

Data speaks volumes! 💡

#DataAnalytics #Excel #LearningInPublic #Data

[IEnovate @IE_novate]

Day 10 of #30DaysOfData! 🚀 Automating my database:🔹 Procedures: Saved code to easily reuse.
🔹 Triggers: Auto-copied new workers to a 2nd list.
🔹 Events: Timer to auto-delete old records. Working smarter! 💻✨ #SQL #DataAnalytics

[IEnovate @IE_novate]

Day 9 of #30DaysOfData: CTEs & Temp Tables! 📊

Covered two ways to handle intermediate data in SQL: 🔹 Common Table Expressions (CTEs) for cleaner, readable subqueries and multi-table joins 🔹 Temporary Tables to store working datasets for a session
#DataAnalytics #SQL

[IEnovate @IE_novate]

Day 8/30 of my #DataAnalysis challenge! 🚀

Today was all about leveling up my SQL skills:
🔹 CASE statements for conditional logic
🔹 CONCAT() to merge string columns
🔹 Stored Procedures with parameters

Building solid foundations! 💻📊

#30DaysOfData #SQL #DataAnalytics

[IEnovate @IE_novate]

@GlobalEllah I’m interested

[IEnovate @IE_novate]

@ChuksEmma947401 How do I apply

[IEnovate @IE_novate]

@ChuksEmma947401 Then

[IEnovate @IE_novate]

@thoughtsbyyinka I’m inn🔥

[IEnovate @IE_novate]

Calculating Salary Increases
•⁠ ⁠WHEN salary < 50000 THEN salary * 1.05 gives a 5% raise.
•⁠ ⁠WHEN salary > 50000 THEN salary * 1.07 applies a 7% raise.
•⁠ ⁠Using salary * 0.05 calculates only the raise amount, not the new total!

[IEnovate @IE_novate]

Day 7 of my 30-Day Data Analysis Challenge! 🚀

Dived deep into CASE Statements in SQL today:
•⁠ ⁠Built conditional logic
•⁠ ⁠Chained WHEN...THEN rules
•⁠ ⁠Created column aliases (AS Age_Bracket)
•⁠ ⁠Prevented NULL values

[IEnovate @IE_novate]

Conditional Logic with CASE
•⁠ ⁠CASE acts like IF/ELSE statements inside your queries.
•⁠ ⁠Evaluates WHEN conditions sequentially from top to bottom.
•⁠ ⁠Returns specific values based on criteria like age <= 30 or BETWEEN 31 AND 50.

[IEnovate @IE_novate]

Day 6 of my 30-Day Data Analysis Challenge! 🚀

Mastered Unions & String Functions in SQL today:
• Stacked datasets & built custom labels (AS Label)
• Fixed data type mismatches
• Standardized text with UPPER(), LOWER() & RTRIM()
• Sliced strings using LEFT(), RIGHT() & SUBST

[IEnovate @IE_novate]

Day 4 of #100DaysOfCode / #30DaysOfData 🚀

Diving deeper into intermediate SQL querying! Covered: • GROUP BY & aggregates (AVG, MAX, MIN) • HAVING (filtering grouped data) • ORDER BY, LIMIT & Aliasing (AS)
One step closer to mastering database queries! 📊
#SQL #DataAnalytics

[IEnovate @IE_novate]

@officialladi_T 🥹💗🔥

[Thelma Etuk @officialladi_T]

So I got accepted into a 6 months Data Science/AI internship and I've been thinking about this a lot

I'm still learning SQL, I haven't even started Power BI yet and my plan has always been to get solid with Excel, SQL and Power BI first and hopefully get a Data Analyst job.

Now look at this curriculum 😭😂
Python, Machine Learning, NLP, GenAI and everything is just waiting for me.

I actually spoke to my mentor about it and he said I should go for it and learn as much as I can, so I've decided to do it.

But I still really want to hear from people already in the data field.

Do you think this is too much to take on this early in my Data Analytics journey?

Or would you take the opportunity and just learn everything along the way?

[IEnovate @IE_novate]

🚀 Wrapped up Day 3 of #30DaysOfData💻

SQL Server 2025 & SSMS are fully set up. Tomorrow, we move to the bigger phase: writing queries and diving deep into database operations! 📊

The real fun begins now. 🔥

#DataAnalytics #SQL #LearningInPublic

[IEnovate @IE_novate]

Day 3/30: Upgraded to SQL! 💻

Downloaded SQL Server 2025 & SSMS.

Translating my Excel skills into SQL queries: 🔹 Filter ➡️ WHERE 🔹 Sort ➡️ ORDER BY 🔹 Summary ➡️ AVG / SUM
#30DaysOfData #DataAnalytics #SQLServer

[IEnovate @IE_novate]

@Femiforge Love this energy! Just followed,looking forward to keeping up with your builds.

[IEnovate @IE_novate]

@_Frs23 I’m new in the space 😅, looking forward to meeting outstanding people with real skills and develop along the line 💯

[Timilehin @Timsedx]

Between SQL server and MySQL for building end to end project, which one will you recommend?