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

Posts

• Marketing Promotion Campaign Analysis Using Feature Based Time Series Clustering

  Feature based time series analysis method is used to make recommendations to expand to new regions

  Feb 4, 2022

• Parameterizing Value.NativeQuery For Query Folding

  Passing parameters and lists to Value.NativeQuery to make queries foldable and dynamic

  Jan 25, 2022

• Adding Interactive Widgets To Visuals Using Deneb in Power BI

  Deneb custom visual can be used to create interactive, composite visuals that are highly responsive and are customizable

  Jan 22, 2022

• Generating Random Numbers With Triangular Distribution in Power Query

  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

• Generating Normally Distributed Random Numbers in Power Query

  Custom function to generate a column with normally distributed random numbers with specified mean and standard deviation

  Dec 22, 2021

• Dynamically Changing the Color Transparency in Power BI

  A very easy and effective way to dynamically and conditionally change the color transperancy in Power BI

  Sep 3, 2021

• Segmentation Using Multivariate Clustering in Power BI

  In this blog/video I explain how to use the clustering feature in Power BI to find insights.

  Aug 25, 2021

• Power BI AutoML Deep Dive

  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

• Selecting Columns by Data Type in Power Query

  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

• Operationalizing Machine Learning models with Azure ML and Power BI

  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

• The Magic of SHD

  A simple yet fast and powerful forecasting algorithm

  Mar 8, 2021

• Removing Non-Alphanumeric Characters From A Column

  Removing non-alphanumeric characters and special symbols from a column in Pandas datafarme

  Mar 5, 2021

• Introduction to Azure ML SDK

  Presentation notebook from 'Azure Saturday, Hamburg 2021' event.

  Feb 22, 2021