Michal Shaffer

2024 Week 38 | Sigma: Can you create reference marks?

Introduction Welcome to Week 38! Sometimes there are events or notable data points that aren’t stored in your data, but you want to see how they effect the trends. Enter reference marks and conditional formatting! This week we practice using reference marks and conditional formatting to highlight specific dates and events. The formatting styles and …

2024 Week 38 | Sigma: Can you create reference marks? Read More »

2024 Week 26 | Sigma: Can you calculate RunRates?

Introduction Welcome to Week 26! When we dive into monthly data, it’s often more helpful to predict the current month’s numbers rather than relying on incomplete data for an incomplete month. This week, we’re trying out three different ways to estimate sales projections for the ongoing month, also known as the run rate. Dealing with …

2024 Week 26 | Sigma: Can you calculate RunRates? Read More »