Goal: a fast, self-updating Power BI report that tracks earthquakes in the European–Mediterranean region (with a global table for comparison), highlights activity hotspots, and surfaces clean KPIs for decision-making. Scope: Earthquakes in the European-Mediterranean region with magnitude 4.5 or greater within the last 720 days or the last 2 years. Source: ETH Zürich - Swiss Seismological Service (HTML daily data): http://www.seismo.ethz.ch/en/earthquakes/europe/last90daysMa

Power Query is often seen as a tool for just loading and cleaning data — but it offers far more than the basics. Most users rely on a handful of transformations, while the UI hides powerful features that can make your workflow faster, cleaner, and easier to maintain. In this post, I’ll walk you through the best Power Query UI functions and hidden gems — no M code required. I repeat, no M-code, just UI!!! "Discover the Top 10 Power Query UI Gems: From automatic data type detec

Excel has been around for decades, but it’s still one of the most powerful tools for analytics, reporting, and automation. While most...

Managing business performance doesn’t always require complex BI tools. With the right Excel setup, you can track sales, purchases, costs, and margins in a clean, interactive way. This Financial & Business Analytics template is designed for small to medium businesses who want a ready-to-use reporting system. In this post, I’ll walk you through the workbook page by page, explain how calculations work, and show how to interpret the dashboards. At the end, you’ll find a practical

This tool is designed to help you manage customers, employees, services, and sales, all in one place, with automated dashboards and KPIs. Below is the data flow of the dashboard and a short explanation of the pages. (link for download is below) Data flow diagram illustrating an Excel CRM template, showcasing interactions between the Customer Database, Employee Database, KPI Plan, and Order Form, all converging into the All Orders module, which then feeds into Processing/Setti

Power BI’s Power Query (M language) allows creating custom functions and reusable query steps to simplify common tasks. Below are five versatile M-code solutions – a mix of data transformation helpers and analysis utilities – that you can copy into your Power BI queries with minimal adjustments. Each function includes the full M code, an explanation of its purpose, and an example use case in real-world projects. PRACTICE MATERIAL BELOW!👇 Explore the Top 5 essential M-Code fu