Mastering SQL Window Functions | Joseph Ogbenna

This conference sparks conversations on youth leadership and features the pitch and award presentation for the top 10 finalists of the Fembol Student Innovation Grant (Fembol SIG 2.0). The Student Innovation Grant is a flagship initiative of Fembol Group designed to empower students across Nigeria to develop and scale innovative solutions that address real-world social and economic challenges. Through funding, mentorship, and capacity-building support, the Grant nurtures the next generation of impactful entrepreneurs and change-makers.

Speaker: Joseph Ogbenna Topic: Mastering SQL Window Functions Abstract: Most SQL users are comfortable with `GROUP BY`, `SUM()`, and `COUNT()`, but many business questions require more advanced analytical techniques. How do you rank top-performing products within each category? Calculate running sales totals without losing transaction-level detail? Compare a customer's current purchase to their previous one? Identify sales trends, customer inactivity, or consecutive periods of growth? In this practical and hands-on webinar, participants will learn how to use SQL Window Functions in Microsoft SQL Server Management Studio (SSMS) to perform advanced analytical calculations that go beyond traditional aggregations. Through realistic sales, customer, and product data scenarios, we will explore powerful functions such as `ROWNUMBER()`, `RANK()`, `DENSERANK()`, `LAG()`, `LEAD()`, and windowed aggregates to solve real business problems. By the end of the session, attendees will be able to write more efficient analytical queries, generate deeper insights from data, and apply modern SQL techniques commonly used by experienced data analysts and business intelligence professionals. Profile: Joseph Ogbenna is a specialized data analyst and analytics trainer who focuses on customer intelligence and business performance. With a technical background in SQL, Power BI, and Python, Joseph is an expert at transforming complex data into clear, actionable insights. He is known for his ability to simplify high-level analytical concepts for professionals of all skill levels. In this live session, Joseph will demonstrate how to bridge the gap between traditional spreadsheets and the future of work by integrating AI Copilot into your daily Excel workflow. Connect with the speaker: https://www.linkedin.com/in/joseph-ogbenna/ See you in the online live class session! RSVP:https://www.meetup.com/microsoft-excel-and-data-analysis-learning-community/events/316777271/ Joining link: https://v

Start your Friday morning after Moonshot with breakfast, honest conversation, and 50 founders building across Africa. Founders Breakfast returns for its second edition, hosted by Seye Bandele, with two fireside conversations about building through difficult conditions and preparing for what comes next. First, Foluso Ogunwale, Founder & CEO of iFitness, joins Seye for “Scaling in a Market That Fights You Back.” We’ll explore what it takes to build physical scale in Nigeria: financing expansion, navigating infrastructure challenges, finding talent, and keeping operations running when every input works against you. Then, Samson "The Oracle" Esemuede, Chief Investment Officer at Zrosk IML, sits down for “Positioning for 2027, Before the Market Moves.” This conversation looks ahead at Nigerian finance and trade, the shifts founders should be watching, and how to prepare their businesses before those changes arrive. Each conversation includes an open Q&A. Bring the questions you rarely get to ask, the challenges you’re working through, and a willingness to share what you’re learning. No slides or pitch decks—just breakfast and candid discussion with people who understand the work of building. We’re keeping the room small: 50 seed-to-pre-Series A founders, gathering in Ikoyi, Lagos, on Friday, 30 October 2026, from 10:30 AM to 12:35 PM WAT. Attendance is by invitation only. Venue details will be shared with confirmed guests.