| Featured Analytics Articles |
| Power BI Sales Report Demo Power BI Sales report displaying MTD, QTD, YTD and Year on Year. Slice by Store type and month.  |
| Building a Lifetime Value Model with Python Script for importing data from MS SQL server data warehouse and building a model using logistical regression (with a little help from ChatGTP)  |
| DAX Running Total Measure – Quick Measure vs. Human Measure The quick measure for running totals include a complex INONORAFTER() function. How do we break it down and is there an easier calculation?  |
| Looking for Outliers with Seaborn Graphs The quickest way to search outliers and get a whole view of your data visually.  |
| Statistical Analysis Basic Statistical techniques you need to know, including outlier analysis.  |
| Graphing Data in Python A look at graphing data for exploratory analysis of our dataset.  |
| Building a Date Table with DAX Building a date table in DAX is a good way of learning time intelligence functions, but it should be stored centrally.  |
| Investigating the Sales Tables in the Contoso Retail Data Warehouse A look around the Contoso Retail Data warehouse.  |
| Correlation with Python Using correlation to diagnose which fields are the best for predicting lifetime value, so we can use them in our predictive model.  |
| Building a Power BI Survey Report Airline survey results demo and export to pdf  |
| Adding a Last Refresh Date in DAX A useful guide for adding the last refresh date to your report  |