My name is Sandeep Pawar. I am a Data Science professional. I write about Data Analytics, Data Visualization, Statistics, Machine Learning, Power BI, Azure ML, Python and Synapse Analytics
Simple solution to make data type changes query folding safe
Jun 1, 2022
Solution to extract words from a sentence in each row using a pre-defined list in Power Query
Mar 11, 2022
Few ways to get relative & abolsute refresh durations in Power BI
Feb 25, 2022
Feature based time series analysis method is used to make recommendations to expand to new regions
Feb 4, 2022
Passing parameters and lists to Value.NativeQuery to make queries foldable and dynamic
Jan 25, 2022
Deneb custom visual can be used to create interactive, composite visuals that are highly responsive and are customizable
Jan 22, 2022
Custom function to generate a column with triangular distribution using M. I have also included a video showing how to create Risk Model in Power BI using distributions
Jan 17, 2022
Custom function to generate a column with normally distributed random numbers with specified mean and standard deviation
Dec 22, 2021
A very easy and effective way to dynamically and conditionally change the color transperancy in Power BI
Sep 3, 2021
In this blog/video I explain how to use the clustering feature in Power BI to find insights.
Aug 25, 2021
I was invited to speak at Portland Power BI User Group about Power BI AutoML. In this session, I showed how to create business-focussed, robust, explainable machine learning models using the AutoML capabilities in Power BI
Aug 25, 2021
May 11, 2023
This blog shows how to select columns by data type. This is helpful if you have hundreds of columns and want to see, for example, only numerical or date columns.
May 4, 2021
I presented this session at Power Break on March 22, 2021. Topics coevered - limitations of using Python query in Power BI, importance of MLOps, deploying ML models in Azure ML and consuming them in Power BI
Apr 14, 2021
May 11, 2023