Statistical Process Control

Introduction In inferential statistics, sample data is analyzed to make general assumptions and estimate a population parameter. The confidence interval provides the probability of accuracy, which falls between the range of interval of numbers, the upper boundary, and...

VLOOKUP

At a point, it becomes essential to code categorical variables or sometimes numeric variables to represent rankings or to provide additional insight. VLOOKUP can combine tables’ common fields: the tables with the coded field used to reference the table to be...

Pivot Tables with Dashboard

Pivot tables make it easy to aggregate and summarize tables. It saves time and always comes with a succinct table of the raw datasets. On the other hand, a Pivot chart can be created with an adjustable chart or visualization alongside the Pivot table. Data need to be...

Power BI Dashboard

Power BI Dashboard The essence of graphical representation or visualization is to provide CFO or stakeholders with the understanding needed to enable effective business decisions. It visually summarizes the KPI, which illustrates the organization’s financial health....