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

Jihwan Kim
Sep 12, 20223 min read
What are use cases of adding ranking column in Power Query Editor in Power BI
In this blog post, I want to share how I use Power Query Editor in Power BI to get ranking-column and what were the use cases in my...
205 views0 comments

Jihwan Kim
Sep 9, 20222 min read
List customers of Top50%-Sales in each month, in Power BI
In this blog post, I want to share how I try to write DAX measures in order to show a list of customers who made TOP 50% of sales in each...
248 views0 comments

Jihwan Kim
Sep 7, 20222 min read
Running total by reset condition - DAX in Power BI
In this writing, I want to share my thought process about how I build it up to provide a solution for showing running total that is reset...
64 views1 comment

Jihwan Kim
Sep 6, 20223 min read
Create a Function in Power Query for getting Group Running Total
In this writing, I want to share how I learned to create a function in Power Query Editor in Power BI Desktop in order to get Running...
224 views0 comments

Jihwan Kim
Sep 3, 20222 min read
Writing CALCULATE two times? => CALCULATE ( CALCULATE (... ) ) in Power BI
In this writing, I want to share how I will going to find out what will happen if I write, for instance, CALCULATE ( CALCULATE (...
683 views0 comments

Jihwan Kim
Sep 2, 20222 min read
Create a calculated table that contains active employees on each date, using GENERATE in Power BI
In this writing, I want to share how I try to create a caluclated table that shows who are active employees on each date in Power BI....
366 views0 comments

Jihwan Kim
Sep 1, 20223 min read
NATURALINNERJOIN vs. TREATAS in Power BI
In this writing, I want to share how it is different when using NATURALINNERJOIN DAX function and TREATAS DAX function in Power BI. In...
155 views0 comments

Jihwan Kim
Sep 1, 20222 min read
TopN and Breaking Ties, in Power BI
In this writing, I want to share how I use TOPN DAX function in order to only visualize the most wanted categories, instead of...
381 views0 comments

Jihwan Kim
Aug 31, 20222 min read
Conditional formatting in matrix/table visualization - Power BI
In this writing, I want to share in detail how I create a measure in order to show conditionally format matrix/table visualization in...
35 views0 comments

Jihwan Kim
Mar 6, 20212 min read
Jordan vs LeBron Challenge, in Power BI, by Maven Analytics.
In this writing, I want to share how I analyzed and what I have found using Michael Jordan’s and LeBron Jame’s data posted by and thanks to
293 views0 comments

Jihwan Kim
Feb 28, 20212 min read
Analyzing my professional experiences in Power BI
In this writing, I want to share how I analyzed my professional experiences in Power BI, and what I have planned for my future.
69 views1 comment

Jihwan Kim
Feb 27, 20212 min read
Marketing Campaign Costs Analysis, in Power BI
Marketing Campaign Costs Analysis, in Power BI
96 views0 comments

Jihwan Kim
Feb 22, 20213 min read
Worldwide Trading Export & Import values (USD) & volumes (kg) analysis, in Power BI
Worldwide Trading Export & Import values (USD) & volumes (kg) analysis, in Power BI
42 views0 comments

Jihwan Kim
Feb 18, 20213 min read
Displaying Currency by utilizing Tabular Editor, in Power BI
In this writing, I want to share how I display currency together with a sum amount in a matrix visualization, in Power BI.
59 views0 comments

Jihwan Kim
Feb 17, 20215 min read
Cohort Analysis in Power BI, by telling the story.
I want to share how I created my own story and how I used the sample data when processing the Cohort Analysis, in Power BI.
254 views0 comments

Jihwan Kim
Feb 16, 20212 min read
SANDVIK and its competitors stock price trends analysis, in Power BI.
In this writing, I want to share what I have learned by researching Sandvik's and its competitors' recent one-year stock market prices. I...
52 views0 comments

Jihwan Kim
Feb 11, 20214 min read
Maven Marketing Challenge, by Power BI. & How to get a zip file from WEB and unzip in Power Query.
In this blog post, I want to share how I analyzed the data that is shared by Maven Analytics for mavenmarketingchallenge.
300 views0 comments
bottom of page