Enthusiastic about enabling commercial excellenceExtremely Powerful visual calculation in Power BI- Provide automatic calculation based on time…We need to make some calculations based on the time frame and compare them (e.g., running sum, moving average, versus previous) to help…Oct 31Oct 31
Enthusiastic about enabling commercial excellenceBuild automatic process on Power Automate to reduce efforts of routine tasksMany of us have the same experience delivering reports and email documents regularly. We spend a lot of effort pulling out data…Sep 13Sep 13
Enthusiastic about enabling commercial excellenceConcept of enterprise transformation from my commercial excellence experienceA few general concepts about transformation that you can find on the internet are as follows:Sep 5Sep 5
Enthusiastic about enabling commercial excellenceThe job interviews should be like marketing promotions.The UEFA European Football Championship just finished this month. We found different leader stories from different teams. Some people are…Jul 17Jul 17
Enthusiastic about enabling commercial excellenceMost important tasks(MIT) in a day- how to use your day efficiently and make it productivityWe will have tons of tasks, including personal and business-related tasks, coming up in a day, and if we prioritize them well, we can…Mar 22Mar 22
Enthusiastic about enabling commercial excellenceTo build matrics of the same period last year and YTD numbers from data with different…Many times, we face challenges of data with different granularities. For example, we have weekly sales targets by region but not product…Mar 4Mar 4
Enthusiastic about enabling commercial excellenceThree critical components for data analysis and how SQL can realize these componentsAn analysis can help business owners or commercial leaders understand their current position and further derive strategies to modify pace…Feb 8Feb 8
Enthusiastic about enabling commercial excellenceAn efficient process to detect the discrepancy when you take control of an existing system/reportMany of you may have this experience that you need to find out why there is a discrepancy between two reports/systems when you take over…Dec 18, 2023Dec 18, 2023
Enthusiastic about enabling commercial excellenceA demo for Power Automate — an integration of capturing specific data from worksheets and sending…Power Automate is a useful automated flow to help you with periodic routine tasks. This article will cover a process that starts with…Nov 20, 2023Nov 20, 2023
Enthusiastic about enabling commercial excellenceTalk about the pros and cons of data transformation at each level (Source, Middle Marts, and Power…Commonly, a dashboard contains a variety of data sources. There must be some preliminary cleaning and transforming work before building…Nov 13, 2023Nov 13, 2023