Overview
Clean, transform, and analyze datasets in Excel using formulas, pivot tables, and advanced functions to uncover actionable insights., Build interactive dashboards in Excel and Power BI that communicate key trends and performance metrics effectively., Connect, shape, and model data in Power BI using Power Query and DAX to create accurate, dynamic reports., Visualize data with clarity and impact by applying best practices for charts, slicers, and drill-through pages., Design and publish a professional portfolio website to showcase dashboards, reports, and analytical projects to potential employers or clients.
Beginners in data analysis who want to build a solid foundation using Excel and Power BI., Students or recent graduates looking to develop job-ready analytical skills for internships or entry-level roles., Professionals from non-technical fields who want to analyze data, create dashboards, and make data-driven decisions., Career switchers aiming to break into analytics, business intelligence, or related tech roles., Entrepreneurs and business owners who want to understand their numbers and track performance with interactive reports.
No prior experience with Excel or Power BI is required — this course starts from the basics and builds up to advanced concepts., Access to a computer (Windows or Mac) with a stable internet connection to download and practice with the tools., Microsoft Excel (2019 or later) and Power BI Desktop installed — both have free or trial versions available., Willingness to learn by doing — you’ll get more out of this course if you follow along with the exercises and projects., Basic computer literacy — knowing how to navigate files, folders, and install software will help you move faster.
This course takes you through a complete, practical journey into data analytics, helping you build the technical and analytical skills needed to work confidently with real-world data.
You’ll begin with Excel, learning how to clean, structure, and analyze datasets using essential functions, Power Query, PivotTables, lookup formulas, conditional logic, and data validation techniques. You’ll also explore effective spreadsheet modeling and best practices for organizing data for analysis.
From there, you’ll move into SQL, where you’ll learn how to write queries that extract, filter, join, and summarize data from relational databases. You’ll gain confidence in using SQL to support reporting, analytics, and decision-making processes.
The course then guides you into Power BI, where you’ll learn to build interactive dashboards, create data models, work with DAX formulas, and design visualizations that clearly communicate insights. You’ll practice transforming complex data into meaningful, easy-to-understand visuals that support business decisions.
You’ll apply everything you learn through hands-on, project-based exercises that mimic real industry scenarios. You’ll work with messy datasets, uncover trends, generate insights, and present your findings just like a data analyst in a modern workplace.
By the end of the course, you will be able to complete an end-to-end analytics workflow: collecting data, cleaning and transforming it, analyzing trends, building dashboards, and presenting insights with confidence.
Samuel Okon
Hi! I’m Samuel. I have a degree in Industrial Chemistry from the Federal University of Technology, Akure, and you might call me a bit of a data geek.
After getting into data analytics just for fun, I quickly discovered that it wasn’t just interesting — it was also a highly valuable career path. I left my science background behind and fully embraced analytics, and I haven’t looked back since.
I’m passionate about teaching people how to make sense of data. That’s why I created this course — to help beginners and non-technical professionals feel confident working with Excel, SQL, and Power BI.
You wouldn’t believe how empowering it is to truly understand your data. Sign up and see for yourself why so many learners are building data skills to grow their careers. I genuinely believe this course gives you everything you need to get started — and if you don’t agree, I’ll happily refund your money.
Join me in this data adventure — I can’t wait to see what you’ll discover.