Unveiling Volatility with Bollinger BandsEver felt like your sales data is a wild sea monster – all over the place and difficult to grasp? Fear not, intrepid analyst! In our last adventure, we slayed the trend obscurity beast with the trusty Simple Moving Average (SMA). But what if we crave...Jun 17, 2024 · 4 min readmoeabbas.hashnode.dev
Unveiling Trends with Simple Moving Averages (SMA)Ever felt like you're wrestling with a data kraken – a tangled mess of sales figures bouncing all over the place? Fear not, for we have a trusty tool in our arsenal: the simple moving average (SMA). Forget squinting at those wild fluctuations – SMAs ...May 9, 2024 · 3 min readmoeabbas.hashnode.dev
BigQuery Recursive CTEs for Data TransformationBusiness Intelligence Analysts juggle a diverse range of datasets. Some reside at the granular unit level, while others are pre-aggregated at the item or order level. Aggregating data upwards (unit -> item -> order) is a breeze. But when it comes to ...Apr 22, 2024 · 3 min readmoeabbas.hashnode.dev
Tailoring Insights for Every StakeholderGone are the days of one-size-fits-all reports in business intelligence. As an analyst, I'm constantly fielding requests from stakeholders across departments, each with unique needs. The core data might be the same, but the way they want it sliced an...Apr 20, 2024 · 5 min readmoeabbas.hashnode.dev