Loading published writing…
Explore practical notes, useful methods, and thoughtful stories, written clearly and shared with care
7 posts
The query executes cleanly without syntax errors, but reported order totals suddenly multiply compared to official ledger records. Behind this silent discrepancy lies row duplication, a direct outcome of treating JOIN as a simple column append rather than an operation generating an entirely new dataset.
No syntax warnings, no runtime errors, but the query yields zero rows. In SQL, unexpectedly empty results rarely come from complex logic; instead, they usually happen because of how the database behaves when encountering a NULL value.
You define a new column right at the beginning of an SQL statement, but when you attempt to filter data based on that column, the database management system returns an error stating that the column does not exist. Behind this familiar error message lies a frequently overlooked principle: the lexical order in which you write the code is completely different from the logical execution order of the Database Engine.
The sight of rigid lines of code often leads people to mistakenly believe that switching to SQL means starting from scratch. In reality, the relational data mindset you developed through Power Query already covers half of SQL's statement structure. This article explores the similarities between the two tools, helping you realize that mastering SQL is simply a matter of applying new terminology to operations you already perform daily in Power Query
Excel is capable of processing massive datasets smoothly without the heavy weight of repetitive VLOOKUPs. This blogs guides you in shifting your mindset from "flattening data" to "data modeling" using Power Pivot. Discover how to link independent data tables according to BI standards, ensuring smooth system performance and reducing file size by up to 80%.
Raw data is rarely ready for immediate analysis. In this case study, we will explore how to transform a complex, unstructured public health dataset from Singapore into a clean, standardized data structure. By applying advanced Power Query techniques, such as the "Unpivot" operation, skillful handling of specific text formats (e.g., '2026Feb'), and noise removal via a smart workflow, we will turn chaos into valuable insights while building a robust data schema ready for high-performance Power BI dashboards.
In the era of Modern Excel, smart users handle tens of thousands of rows of messy data without writing a single line of formulas. This blog details the process of automating data cleanup and table linking, shifting from VLOOKUP and XLOOKUP to Power Query, using the Superstore Sales dataset. With just a single "Refresh" click, step into the automated world of Power Query and transform the recurring nightmare of data cleanup into a stress-free experience!