Data analysts play internal data in analytics projects as daily work. Being familiar with internal data is a fundamental request for analysts. We've learned warehouse, database, and pipeline structures, know the data structure and the schema, and tried getting into daily business. These are what we practice in everyday work…

There are plenty of critical elements in an analytics project. This article does not cover the data analysis process but raises the level to a project leader's point of view and explains four factors that matter the most in a project. Target oriented, which correlates to expectation management. Quite a standard, right. But have you ever thought…

Every model/analysis comes from a phenomenon/problem we want to solve and the hypothesis we set. The iteration of our analysis and the hypothesis adjustment is the value of the data scientist/data analyst. So how can we accelerate the iteration to find a better explanation/solution? My suggestion is to start with…

Hey there, I want to use this article to go through 5 useful functions of power query. Please be noted that power query is to solve your routine job, not to replace SQL for questions due to the consumption of your calculation resources. …

The price strategy is essential in every industry. Price is one factor in the marketing textbook, and it will affect company margin significantly. Factors such as quantity, quality, delivery expectation, and so on may influence the price setting, which is why price analysis is essential in the real business world…

Business analysis, business intelligence, or data analysis are hot topics nowadays. Many courses, talents put focus on analytics skills and tools. There is no doubt skills are the foundation of analytics. But in the real business world, the critical thinking (so-called storyline)behind the analysis is more urgent, and critical thinking…

I believe many of you have been asked questions such as your advantages, characteristics, and project experience during interviews for the application of analyst or scientist. Since you are not a green hand(even you are), you have some previous experience that you can share with the interviewers. …

In my previous articles, I talked about data integration of data layer, DAX function of calculation layer, and some tips of the display layer. Today I want to talk about a function that makes your reports closer to business user needs. A toggle switch lets you display both chart and…

As an analyst and go-to-market strategist in the health care industry responsible for qPCR and Assay products, COVID product is our base currently. However, as the vaccination, healthy protocols, and treatments mature, we face a post-covid age challenge. Asymptomatic testing is getting more and more critical in the post-covid age…