Loading published writing…
Explore practical notes, useful methods, and thoughtful stories, written clearly and shared with care
3 posts
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!