ML Solutions, Marie-Lou Mailloux-Desrochers Power BI: How to Integrate Dynamic Date Parameters into Your SQL Queries Introduction In the previous article, we explored how automating SQL analyses with stored procedures can simplify and accelerate the process of obtaining actionable insights. With a well-designed stor... Nov 15, 2024
ML Solutions, Marie-Lou Mailloux-Desrochers Automate Your SQL Analyses with Stored Procedures 1. Introduction In my previous article, we explored how SQL indexes can improve query performance by optimizing data search and sorting. Today, we'll focus on another powerful technique to automate an... Oct 18, 2024
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
ML Solutions, Marie-Lou Mailloux-Desrochers Welcome to the ML Solutions Blog! Hello everyone and welcome to the ML Solutions blog! My name is Marie-Lou Mailloux-Desrochers, founder of ML Solutions. With over 12 years of experience in the field of data analysis and Business Inte... PowerBI Aug 9, 2024
