ML Solutions, Marie-Lou Mailloux-Desrochers Optimize Your SQL Performance with Indexes 1. Introduction In my previous article, we explored how SQL views can improve your reports by simplifying data access and automating analysis. Today, we’ll focus on another essential tool for optimizi... BI SQL Oct 4, 2024
ML Solutions, Marie-Lou Mailloux-Desrochers Improve Your Reports with SQL Views 1. Introduction In my last article, we explored how to program a SQL function to calculate fiscal quarters .This function simplifies financial data analysis by breaking down periods based on the comp... BI SQL Sept 20, 2024
ML Solutions, Marie-Lou Mailloux-Desrochers How to Program a SQL Function to Calculate Fiscal Quarters Introduction Dans notre précédent article In our previous article, we explored how to calculate YoY (Year-over-Year) using Power BI and SQL. We briefly mentioned the importance of quarters for financi... PowerBI SQL Sept 6, 2024
ML Solutions, Marie-Lou Mailloux-Desrochers Calculating YoY (Year-over-Year) in DAX and SQL Introduction Today, for my first in-depth article, I present to you the intricacies of a commonly used measure in business intelligence: YoY, or "Year-over-Year." This measure is essential for evaluat... BI DAX PowerBI SQL Aug 23, 2024
%20in%20DAX%20and%20SQL?unique=4be2440)