top of page
flow analysis
designed by Jihwan
Unlock the Power of Data with Dynamic Insights: Dive deep into comprehensive data flow analysis with Microsoft Power BI and Fabric. Experience the magic firsthand by requesting a personalized demonstration of my analysis reports, or explore the "powerbi works" page & "blog" pages for inspiration and generate your own unique insights. Let's embark on this data-driven journey together!
Search


.gitignore for Power BI Projects: A Simple Guide for the Modern BI Developer
In this writing, I’d like to share how I learned and understood one of the most important—and often overlooked—files I encountered as I...
Jihwan Kim
2 days ago4 min read
Â
Â
Â


Start Coding: A Modern Power BI Workflow with TMDL and VS Code
In this writing, I’d like to share how I am evolving my Power BI development process. For years, building semantic models has been a...
Jihwan Kim
Jun 295 min read
Â
Â
Â


Leveraging OFFSET for Dynamic Ranking and Related Analytical Patterns Power BI: A Deep Dive Beyond Time Intelligence
In this writing, I like to share how I learned understanding and writing OFFSET DAX function in Power BI. OFFSET function (DAX) - DAX |...
Jihwan Kim
Jun 223 min read
Â
Â
Â


Unlocking Next-Level Productivity with Power BI's TMDL View and AI
Introduction: A New Chapter in My Power BI Development Journey In this writing, I'd like to share my journey with a feature that has...
Jihwan Kim
Jun 148 min read
Â
Â
Â


Cohort Analysis in Power BI: Mastering WINDOW and PARTITIONBY
By Jihwan Kim In this writing, I like to share how I learned to tackle one of the more insightful business analyses – cohort analysis,...
Jihwan Kim
Jun 56 min read
Â
Â
Â


INFO.DAX + Fabric Notebooks Find Unused Columns
Measure Bloat You Can’t See—But Still Pay For Introduction In this writing, I like to share how I learned to uncover hidden VertiPaq...
Jihwan Kim
May 314 min read
Â
Â
Â


Direct Lake vs. Import vs. Direct Lake + Import: Learn Building Three Storage Patterns That Scale
Introduction In this writing, I like to share how I learned to create three distinct storage patterns for Power BI semantic models—...
Jihwan Kim
May 253 min read
Â
Â
Â


From Zero → Lakehouse: Loading AdventureWorks Sample into Microsoft Fabric (Notebook-Only)
In this writing, I like to share how I learn to populate a clean Fabric Lakehouse —AdventureWorks— using nothing but Spark notebooks. 1...
Jihwan Kim
May 171 min read
Â
Â
Â


The Power of VAR in DAX: Enhancing Performance and Readability
In this writing, I like to share how I learned to leverage the VAR in DAX to improve both the performance and readability of my Power BI...
Jihwan Kim
May 103 min read
Â
Â
Â


The Hidden Cost of Auto Date/Time in Large Power BI Models
Why performance and data model bloat may be silently hurting Power BI developments. In this writing, I like to share how I learn to...
Jihwan Kim
May 54 min read
Â
Â
Â


Power BI Style Presets: Visual Consistency and Efficiency
In this writing, I'd like to share how I started learning to configure stylePresets  in Power BI and why it’s an exciting breakthrough...
Jihwan Kim
Apr 275 min read
Â
Â
Â


Understanding the EARLIER and EARLIEST DAX Functions in Power BI – Beyond Their English Meaning
In this writing, I like to share how I started to learn about the EARLIER and EARLIEST DAX functions, which I felt quite confusing at...
Jihwan Kim
Mar 313 min read
Â
Â
Â


Finding Table.RemoveColumns function in M Code in Power Query Editor Using TMDL View
In this blog post, I’d like to share how I learned to find where Table.RemoveColumns function in M code is used in Power Query Editor and...
Jihwan Kim
Mar 94 min read
Â
Â
Â


Leveraging the TMDL View Feature in VSCode with GitHub Copilot: my experience
In this writing, I want to share how I start to use TMDL View feature with GitHub Copilot in VSCode. As a Power BI developer, staying...
Jihwan Kim
Feb 94 min read
Â
Â
Â


Getting Started with TMDL View in Power BI: My Experience
In this writing, I want to share how I start to use the TMDL (Tabular Model Definition Language) view in Power BI. This isn’t a deep dive...
Jihwan Kim
Feb 23 min read
Â
Â
Â


How I learn WINDOW DAX function in Power BI
In this writing I like to share how I learned WINDOW DAX function in Power BI. Over the past few months, I’ve had the opportunity to work...
Jihwan Kim
Jan 114 min read
Â
Â
Â


Unlocking Insights of users activity: Using "sempy_labs.admin.list_activity_events( )" in Fabric Notebooks
In this writing, I like to share how I start to learn, write, and use the "sempy_labs.admin.list_activity_events"Â function in Fabric...
Jihwan Kim
Dec 26, 20243 min read
Â
Â
Â


Tracking a Power BI Project (Improve Semantic Model Size) Using Semantic Link in Fabric
Recently, I started exploring the basics of Semantic Link, and it opened up new possibilities for me to track the progress of one of my...
Jihwan Kim
Dec 16, 20243 min read
Â
Â
Â


Making Dynamic Format String More Dynamic for End Users, in Power BI
In this writing, I want to share how I learned to make dynamic format strings more dynamic and flexible for Power BI end users. This...
Jihwan Kim
Dec 1, 20243 min read
Â
Â
Â


DAX Queries in Fabric Notebook - A Journey of Efficiency and Insight
In this writing, I like to share how I learn and try using Fabric Notebooks to write DAX queries, enabling me to extract the most...
Jihwan Kim
Nov 17, 20244 min read
Â
Â
Â
bottom of page