In this tutorial, we dive into the powerful world of statistical data visualization by building a comprehensive sales dashboard in Power BI. The star of the show is the Box and Whisker chart, a custom visual that provides a deep dive into your data’s distribution, including minimum and maximum values, quartiles ($Q1$ and $Q3$), the…
In this video, the presenter demonstrates how to calculate basic statistics using Python script in Power BI and create a dashboard from those statistics using Power BI visuals. The video starts with importing the Pandas library and reading data from an Excel file into a data frame. The presenter then calculates mean, mode, median, standard…
In this video, the steps to create a bell curve using Microsoft Excel are demonstrated. A column named “Data” is created. 500 random values are generated between 100 and 200 using the “RANDBETWEEN” formula and entered into the “Data” column. The mean and standard deviation of these 500 values are calculated using the “AVERAGE” and…
