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
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
Mar 8, 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
Mar 8, 2023
A simple yet fast and powerful forecasting algorithm
Mar 8, 2021
Removing non-alphanumeric characters and special symbols from a column in Pandas datafarme
Mar 5, 2021
Presentation notebook from 'Azure Saturday, Hamburg 2021' event.
Feb 22, 2021