Introduction to DAX
Welcome to the first lesson in our DAX series on Smart Tutorials! If you are looking to analyze data, create […]
DAX Functions
Excel Functions Cheat Sheet: From Basics to Advanced
Mastering Excel functions is the key to becoming an efficient MIS analyst, data professional, or even a power user in
10 Advanced Excel Questions for MIS Interview
Are you ready to push your Excel skills beyond the basics? In Part-1 we covered 20 practical Excel questions that
Think You Know Excel? Try These 20 Real-World Excel Questions
If you are preparing for an Excel interview or want to sharpen your skills for MIS and reporting jobs, practice
Google Sheets
Other Google Sheets Functions
Google Sheets is a powerful tool, not just for creating spreadsheets, but also for analyzing, automating, and visualizing data. While
Blinkit Sales Dashboard in Power BI
Power BI has become one of the most powerful tools for data visualization and business intelligence. In this project, I
Google Sheets
SPLIT Function in Google Sheets
When you are working in Google Sheets, many times you get data that is combined in one cell — like
Google Sheets
UNIQUE Function in Google Sheets
When you are working with large datasets in Google Sheets, one of the most common problems is dealing with duplicate
Google Sheets
FILTER function in Google Sheets
When you are working with large datasets in Google Sheets, scrolling endlessly or applying manual filters again and again can
Google Sheets
QUERY Function in Google Sheets
When you work with large data in Google Sheets, using formulas like VLOOKUP or FILTER sometimes feels slow or complex.
Google Sheets
ARRAYFORMULA in Google Sheets
Google Sheets has many hidden gems, and one of them is ARRAYFORMULA(). If you are tired of dragging formulas down
Flipkart Sales Dashboard in Power BI
In today’s data-driven world, e-commerce platforms like Flipkart generate huge amounts of data every day. As analysts, our job is