Posts

How I Cleaned a Real University Bakery Sales Dataset in Excel (Part 1 of a Full Data Analysis Project)

Image
  How I Cleaned a Real University Bakery Sales Dataset in Excel (Part 1 of a Full Data Analysis Project) Published by Sadiqverse Digital Institute Every Great Analysis Starts with Clean Data Many aspiring data analysts are eager to jump into SQL queries or build interactive Power BI dashboards. However, one important step is often overlooked: data cleaning. Poor-quality data leads to inaccurate insights, misleading reports, and poor business decisions. That's why data cleaning is one of the most valuable skills every analyst should master. In this article, I'll walk you through the first stage of my Full Data Analysis Project, where I cleaned a real-world University Bakery Sales dataset using Microsoft Excel. About the Project This project follows a complete data analysis workflow in three parts: Part 1: Data Cleaning with Microsoft Excel ✅ Part 2: Data Analysis using SQL Part 3: Interactive Dashboard in Power BI By the end of the series, you'll see how raw business data be...

The Evolution of Data Analytics in 2026: Why Skills Matter More Than Ever

Image
The Evolution of Data Analytics in 2026: Why Skills Matter More Than Ever By Sadiq Jibrin Isa Introduction Not long ago, a data analyst's role was primarily focused on collecting data, cleaning spreadsheets, and producing reports. Creating charts in Microsoft Excel or preparing monthly dashboards was often enough to support business decisions. Fast forward to 2026, and the profession has transformed dramatically. Today, organizations expect data analysts to do much more than report what happened. They want professionals who can uncover hidden patterns, predict future trends, automate repetitive processes, and communicate insights that drive strategic decisions. At the center of this transformation is one key factor: technology. From cloud computing and business intelligence platforms to Artificial Intelligence (AI), the tools have changed rapidly. However, the core mission of data analytics remains the same—turning raw data into meaningful business value. A Brief Journey Through th...

The Biggest Misconception About People Who Use AI

Image
  The Biggest Misconception About People Who Use AI Artificial Intelligence has become one of the most transformative technologies of our generation. From writing content and generating code to creating dashboards and designing graphics, AI is changing how we work. Yet, one misconception continues to grow: "If someone uses AI, then AI did all the work." While this assumption is understandable, it overlooks something important. AI Doesn't Replace Skills—It Amplifies Them Many people only see the final result. They don't see the years of learning, practice, and experience that came before AI became part of the workflow. Before I ever used AI as an assistant, I had already invested time in learning and improving my skills. I learned: CorelDRAW Adobe Photoshop Canva PixelLab Microsoft Excel from scratch SQL Power BI Python (currently learning) None of these skills were developed overnight. They required patience, consistency, and a willingness to keep improving. The Diffe...

DATA CLEANNING

Image
 I almost started building a dashboard. Then I noticed something that changed everything. At first glance, the dataset looked perfect. The rows were complete. The columns were organized. Everything seemed ready for analysis. I opened Excel and was about to create charts when I decided to spend a few extra minutes reviewing the data. That decision saved me hours. I found duplicate records that would have inflated my totals. Some dates were stored in different formats, which would have affected my time-based analysis. There were missing values in key columns and inconsistent text entries that could have produced misleading insights. If I had skipped the data cleaning process, my dashboard might have looked impressive—but it would have told the wrong story. That experience reinforced an important lesson: Data cleaning isn't just a preparation step. It's the foundation of every reliable analysis. Before I analyze any dataset, I ask myself: • Are there duplicate records? • Are there...