Siddharth Mehta

Siddharth has more than 14 years of experience in the IT Industry, with more than a decade of experience in Business Intelligence and Analytics, for clients banking, logistics, government, Media Entertainment, products, life sciences and other domains.  He has been a lead architect for a portfolio of 40+ apps, containing apps in web, mobile, BI, Analytics, data warehousing, reporting, collaboration, CMS, NoSQL and other technologies.  He has several certifications and is a published author for online and print-media publications, as well as the MSDN Library. In his present role, he remains responsible for architecture design, technology stack selection, infrastructure design, 3rd party products evaluation and procurement, and performance engineering. These applications use technologies like Elasticsearch / Lucene, MongoDB, SharePoint 2013 and 2010, jQuery-based framework like Highcharts and GoJS, SQL Server and the Microsoft Business Intelligence stack (SSIS, SSAS, SSRS, MDX, PowerPivot, PowerView), jQueryMobile, Bootstrap, iOS xCode framework, and many others.
  • MSSQLTips Awards: Champion (100+ tips) - 2018 | Author of the Year - 2017 | Author Contender - 2016, 2018-2019
Title Category Date
Generate charts rapidly with SQL Server using R and T-SQL SQL Server 20162026-05-29
Machine Learning Services – Installation and Configuration R Language2026-05-20
Installing and Setting up SQL Server to use Python Python2026-05-20
Statistics Basics R Language2026-05-15
Bulk Insert Data into SQL Server Import and Export2025-01-12
SQL Substring Examples for T-SQL, R and Python Functions System2022-01-24
Relational Databases vs Graph Databases SQL Server 20172019-07-25
Estimate AWS RDS Cost for SQL Server Amazon AWS RDS2019-07-10
Time Series Analysis in Power BI using Timeline Visual Power BI Charts2019-06-20
Python vs PowerShell for System and SQL Server Administration Database Administration2019-06-04
How to Create a Burndown Chart in Excel from Scratch Microsoft Excel Integration2019-05-03
What is a GUID in SQL Server Database Design2019-04-23
Restore SQL Server Database to AWS RDS Instance Amazon AWS RDS2019-04-04
Enforce SSL for connecting to AWS RDS Instance of SQL Server Amazon AWS RDS2019-03-25
Transform Data in Power BI with R and Python Power BI2019-03-05
Power BI Pie Chart Tree to Analyze Hierarchical Distributions Power BI Charts2019-02-22
Visualize categorical scatterplots in Power BI with Python Power BI Charts2019-02-01
Generate visualizations in Power BI using Python Scripts Power BI Charts2019-01-25
Read and Import Data from PDF Files using Power BI Power BI2019-01-07
Match datasets using Fuzzy Joins in SQL Server 2017 with R SQL Server 20172018-12-04
Multivariate data analysis with Tableplot using SQL Server 2017 and R SQL Server 20172018-11-09
Developing and Querying a Graph with SQL Server 2017 and R – Part 2 SQL Server 20172018-10-23
Develop and Query a Graph with SQL Server 2017 and R – Part 1 SQL Server 20172018-10-05
Generate Network Graphs with R in SQL Server 2017 SQL Server 20172018-09-21
Faceted Search and Filtering in Power BI Reports Power BI2018-09-11
Read and Write Excel files in real-time with R in SQL Server 2017 SQL Server 20172018-08-21
Linear Regression with Python in SQL Server 2017 Python2018-08-08
Exploratory Data Analysis with Python in SQL Server 2017 Python2018-07-23
Image Processing with R and SQL Server 2017 SQL Server 20172018-07-12
Anomaly Detection without any coding using Power BI Power BI Charts2018-06-25
Visualizing patterns in high voluminous data using Hexbin Scatterplot in Power BI Power BI Charts2018-06-18
Load data from PDF file into SQL Server 2017 with R SQL Server 20172018-05-25
Geocoding and Generating Map Images Using R in SQL Server 2017 SQL Server 20172018-05-14
Multi-Variate Quantitative Analysis with Radar Charts in Power BI Desktop Power BI Charts2018-04-23
Analyze inter-relationships with chord diagram visualization in Power BI Desktop Power BI Charts2018-04-06
Integrate data driven Visio diagrams in Power BI Reports Power BI2018-03-22
Analyze entity data flow in Power BI Desktop using Sankey charts Power BI Charts2018-03-13
How to render D3.js custom charts in Power BI Desktop Power BI Charts2018-03-01
Performance Analysis using Ribbon Charts in Power BI Desktop Power BI Charts2018-02-19
Distribution analysis on hierarchical data using a Hierarchy chart in Power BI Desktop Power BI Charts2018-02-12
Schedule analysis using Gantt chart in Power BI Desktop Power BI Charts2018-01-29
Segmentation analysis using Mekko Charts in Power BI Desktop Power BI Charts2018-01-19
Data exploration, drill down, and analysis using decomposition tree in Power BI Desktop Power BI Charts2018-01-11
Data Analysis using a Journey Chart in Power BI Desktop Power BI Charts2018-01-02
Graph Analysis using Force Directed Graphs in Power BI Desktop Power BI Charts2017-12-15
Classification and Regression Analysis using Decision Trees in Power BI Desktop Power BI Charts2017-11-30
Analyze Categorical Data with a Mosaic Plot in SQL Server with R SQL Server 20172017-11-09
Analyze Geospatial Data with Power BI Desktop Power BI Charts2017-11-03
Analytics with Power BI Desktop for Data Clustering Power BI Charts2017-10-30
Analytics with Power BI Desktop for Trend Analysis Power BI Charts2017-10-16
Data Forecasting and Analytics with Power BI Desktop Power BI Charts2017-10-09
Analytics with Power BI Desktop Dynamic Line References Power BI Charts2017-10-02
Analytics with Power BI Desktop Using Constant Lines Power BI Charts2017-09-19
SQL Server 2017 and Python Basics Python2017-09-18
Python in SQL Server Ecosystem Python2017-09-18
Basic Python Concepts Python2017-09-18
Example of Using Python with T-SQL Python2017-09-18
Graphical Analysis with Python Python2017-09-18
Basics of Machine Learning with SQL Server 2017 and R R Language2017-08-21
Machine Learning Terms and Concepts R Language2017-08-21
Exploratory Data Analysis R Language2017-08-21
Graphical Analysis Using R and SQL Server R Language2017-08-21
Machine Learning Development Lifecycle R Language2017-08-21
How to visualize multivariate relationships using Power BI Power BI2017-08-15
Develop machine learning models for predictive analysis in SQL Server 2017 SQL Server 20172017-08-07
Install and configure Power BI Report Server and Power BI Desktop Power BI2017-07-28
Installing external R packages to use with SQL Server 2017 SQL Server 20172017-07-18
Getting started with R in SQL Server R Language2017-07-14
R in SQL Server Ecosystem R Language2017-07-14
Basic R Concepts R Language2017-07-14
R with T-SQL R Language2017-07-14
Graphical Analysis with R R Language2017-07-14
Ingest data from a web page into SQL Server 2017 using R SQL Server 20172017-07-11
How to setup Machine Learning Services in SQL Server 2017 CTP2 SQL Server 20172017-06-08
How to query prediction results from a data mining model in SSAS Analysis Services Development2017-05-24
How to partition data in Tabular SSAS Analysis Services Performance2017-05-10
How to report KPIs with gauges in SSRS Mobile Reports Reporting Services KPI2017-04-20
SQL Server Analysis Services 2016 (SSAS) Tutorial Analysis Services Tutorials2017-04-18
SQL Server Analysis Services Enhancements Analysis Services Tutorials2017-04-18
SQL Server Analysis Services Terms And Concepts Analysis Services Tutorials2017-04-18
SQL Server Analysis Services Installation Analysis Services Tutorials2017-04-18
SQL Server Analysis Services Sample Data Analysis Services Tutorials2017-04-18
SQL Server Analysis Services Multidimensional Fundamentals Analysis Services Tutorials2017-04-18
SQL Server Analysis Services Multidimensional Data Model Analysis Services Tutorials2017-04-18
SQL Server Analysis Services Multidimensional Deployment Analysis Services Tutorials2017-04-18
SQL Server Analysis Services Multidimensional MDX Analysis Services Tutorials2017-04-18
SQL Server Analysis Services Tabular Fundamentals Analysis Services Tutorials2017-04-18
SQL Server Analysis Services Tabular Data Model Analysis Services Tutorials2017-04-18
SQL Server Analysis Services Tabular Deployment Analysis Services Tutorials2017-04-18
SQL Server Analysis Services Tabular DAX Analysis Services Tutorials2017-04-18
SQL Server Analysis Services Reporting with Excel Analysis Services Tutorials2017-04-18
SQL Server Analysis Services Reporting with Power View Analysis Services Tutorials2017-04-18
How to setup a tabular data model in SSAS Azure Analysis Services Development2017-04-13
Cascading Parameters in SSRS using MDX and SSAS Multi-Dimensional Analysis Services Development2017-03-22
SSRS Mobile Reports Tutorial Outline Reporting Services Development2017-03-20
SSRS Mobile Reports Design Considerations Reporting Services Development2017-03-20
SSRS Mobile Reports Architecture Reporting Services Development2017-03-20
SSRS Mobile Reports Publisher Overview Reporting Services Development2017-03-20
SSRS Mobile Reports Data Grids Reporting Services Development2017-03-20
SSRS Mobile Reports Charts Reporting Services Development2017-03-20
SSRS Mobile Reports Gauges Reporting Services Development2017-03-20
SSRS Mobile Reports Maps Reporting Services Development2017-03-20
SSRS Mobile Reports Navigators Reporting Services Development2017-03-20
SSRS Mobile Report Publisher Compared to Power BI Reporting Services Development2017-03-20
SSRS Mobile Reports Mobile App Reporting Services Development2017-03-20
SSRS Mobile Reports Connection Settings Reporting Services Development2017-03-20
SSRS Mobile Reports Deploy Reports Reporting Services Development2017-03-20
SSRS Mobile Reports Testing Reporting Services Development2017-03-20
Create Custom Maps for SSRS Mobile Reports Reporting Services Development2017-03-02
How to manipulate data during import in SSAS Tabular vNext Analysis Services Development2017-02-22
How to import data for SSAS Tabular vNext Analysis Services Development2017-02-13
New Tabular Model Explorer for SSAS Tabular Projects Analysis Services Development2017-01-30
Port Tabular Databases to SSAS vNext CTP 1.1 Analysis Services Development2017-01-17
How to import data from SSAS Multi-dimensional to SSAS Tabular Analysis Services Administration2016-12-27
Automate Field Selection for SSAS Tabular Models Power View Reports Microsoft Excel Integration2016-12-19
Use Extended Events to Monitor DAX Queries for SSAS Tabular Databases Analysis Services Administration2016-11-25
Data Mining Tutorial Analysis Services Development2016-11-09
Data Mining Process Overview Analysis Services Development2016-11-09
Data Mining Algorithms Overview Analysis Services Development2016-11-09
Data Mining Build Model with OLTP Data Source Analysis Services Development2016-11-09
Data Mining Editor Analysis Services Development2016-11-09
Data Mining Accuracy Testing Analysis Services Development2016-11-09
Data Mining Prediction Analysis Services Development2016-11-09
Data Mining Build Model with OLAP Data Source Analysis Services Development2016-11-09
Data Mining Relationships Analysis Services Development2016-11-09
Data Mining Model Querying Data Analysis Services Development2016-11-09
Data Mining Model with Excel Analysis Services Development2016-11-09
Multi-language support for SSAS Tabular Models Analysis Services Development2016-11-08
Customize SSRS Reports Manager Portal Reporting Services Configuration2016-10-17
How to query a SSAS Data Mining Model with DMX Analysis Services Development2016-10-05
Create Project from a Deployed SSAS Tabular Database Analysis Services Administration2016-09-23
How to generate T-SQL scripts in SQL Server Management Studio with the collation settings SQL Server Management Studio Configuration2016-09-13
SQL Server DAX Tutorial Summary Integration Services Development2016-09-12
SQL Server DAX Tutorial Overview Integration Services Development2016-09-09
SQL Server DAX Basics an Introduction Integration Services Development2016-09-09
SQL Server DAX Terminology Integration Services Development2016-09-09
SQL Server DAX Data Types and Operators Integration Services Development2016-09-09
SQL Server DAX Formulas and Constructs Integration Services Development2016-09-09
SQL Server DAX Selecting Data Integration Services Development2016-09-09
SQL Server DAX Filtering Data Integration Services Development2016-09-09
SQL Server DAX Summarizing Data Integration Services Development2016-09-09
SQL Server DAX Joining Tables Integration Services Development2016-09-09
SQL Server DAX Parent Child Data Integration Services Development2016-09-09
SQL Server DAX Sorting and Ranking Data Integration Services Development2016-09-09
SQL Server DAX Data Validation Functions Integration Services Development2016-09-09
SQL Server DAX Calculating Data Integration Services Development2016-09-09
SQL Server DAX Date and Time Functions Integration Services Development2016-09-09
SQL Server DAX Setup Sample Databases Integration Services Development2016-09-09
Improve SSAS MDX Query Performance with Custom Aggregations Analysis Services Performance2016-09-02
How to Enable Localization Support for SSAS Dimension Attributes Analysis Services Dimensions2016-08-25
SQL Server Master Data Services Overview Master Data Services2016-07-18
SQL Server Master Data Services Considerations Master Data Services2016-07-18
SQL Server Master Data Services Architecture Master Data Services2016-07-18
SQL Server Master Data Services Installation Master Data Services2016-07-18
SQL Server Master Data Services Terminology Master Data Services2016-07-18
SQL Server Master Data Services Developing MDS Models Master Data Services2016-07-18
SQL Server Master Data Services Importing Data Master Data Services2016-07-18
SQL Server Master Data Services Constructing Hierarchies Master Data Services2016-07-18
SQL Server Master Data Services Business Rules Master Data Services2016-07-18
SQL Server Master Data Services Publishing Data Master Data Services2016-07-18
SQL Server Master Data Services Best Practices Master Data Services2016-07-18
Using Tabular Model Scripting Language with SSAS Analysis Services Development2016-07-13
How to create calculated tables in a tabular SSAS model Analysis Services Development2016-07-06
How to analyze dependencies in a SQL Sever 2016 Master Data Services data model Master Data Services2016-06-29
How to configure user permissions in SQL Server Master Data Services Master Data Services2016-06-23
How to version a SQL Server Master Data Services model Master Data Services2016-05-19
My First SQL Server Business Intelligence Project Tutorial Analysis Services Development2016-05-11
SQL Server Business Intelligence Requirements Analysis – Architecture Analysis Services Development2016-05-11
SQL Server Business Intelligence Requirements and Estimation Analysis Services Development2016-05-11
SQL Server Business Intelligence Analyzing Data Sources Analysis Services Development2016-05-11
SQL Server Business Intelligence Data Modeling Analysis Services Development2016-05-11
SQL Server Business Intelligence Staging Data Analysis Services Development2016-05-11
SQL Server Business Intelligence Master Data Management Analysis Services Development2016-05-11
SQL Server Business Intelligence Design Considerations Analysis Services Development2016-05-11
SQL Server Business Intelligence Dimensional Model Analysis Services Development2016-05-11
SQL Server Business Intelligence Cube Analysis Services Development2016-05-11
SQL Server Business Intelligence Reporting Analysis Services Development2016-05-11
SQL Server Business Intelligence Visual Intelligence Analysis Services Development2016-05-11
Publishing SQL Server Master Data Services Data Master Data Services2016-05-09
How to standardize attribute values in Master Data Services Master Data Services2016-04-27
How to deploy a Master Data Services model Master Data Services2016-04-22
SQL Server Analysis Services Administration Tutorial Analysis Services Administration2016-04-07
SQL Server Analysis Services Installation Prerequisites Analysis Services Administration2016-04-07
SQL Server Analysis Services Complementary Technologies Analysis Services Administration2016-04-07
SQL Server Analysis Services Server Modes Analysis Services Administration2016-04-07
SQL Server Analysis Services Editions Analysis Services Administration2016-04-07
SQL Server Analysis Services Configuration Best Practices Analysis Services Administration2016-04-07
SQL Server Analysis Services Server Properties Analysis Services Administration2016-04-07
SQL Server Analysis Services Server Security Analysis Services Administration2016-04-07
SQL Server Analysis Services User Security Analysis Services Administration2016-04-07
SQL Server Analysis Services Data Security Analysis Services Administration2016-04-07
SQL Server Analysis Services Query Log Analysis Services Administration2016-04-07
SQL Server Analysis Services Exception Log Analysis Services Administration2016-04-07
SQL Server Analysis Services Database Deployment Analysis Services Administration2016-04-07
SQL Server Analysis Services Synchronizing Databases Analysis Services Administration2016-04-07
SQL Server Analysis Services Backup and Restore Analysis Services Administration2016-04-07
SQL Server Analysis Services Performance Monitoring Tools Analysis Services Administration2016-04-07
SQL Server Analysis Services Flight Recorder Analysis Services Administration2016-04-07
Change Compatibility Level of SSAS Tabular Database Using SSDT Analysis Services Administration2016-03-16
Converting MS Access Reports to SSRS Reports Reporting Services Development2016-02-25
Using source data from an SSRS report in PowerPivot for Excel Microsoft Excel Integration2013-05-10
SQL Server APP_NAME function to control stored procedure execution Functions System2013-03-11
Distribution Analysis using a SSRS Box Plot Chart Reporting Services Charts2011-12-05
Enabling Drillthrough in Analysis Services Analysis Services Development2011-10-03
SSRS Developer Interview Questions Business Intelligence Interview Questions2011-09-09
Displaying Multiple Series on an SSRS Chart using Chart Area Reporting Services Charts2011-08-22
Creating Trellis Charts to Make SSRS Reports More Readable Reporting Services Charts2011-08-04
Optimize a SSAS Measure Group Partition for Performance Analysis Services Measure Groups2011-07-28
SSRS Scatter Chart for Data Correlation Reporting Services Charts2011-07-19
Highlighting repeating groups in SSRS 2008 R2 charts Reporting Services Charts2011-06-13
SSRS 2008 R2 KPIs with bullet graphs Reporting Services KPI2011-06-10
Creating a Reporting Services Histogram Chart for Statistical Distribution Analysis Reporting Services Charts2011-05-31
How to handle empty values in a line chart in SSRS Reporting Services Charts2011-05-05
SQL Server Analysis Services Glossary Analysis Services Development2011-05-05
SQL Server Analysis Services (SSAS) Tutorial Analysis Services Development2011-05-03
Creating a Sample SSAS Project and Cube Analysis Services Development2011-05-03
Installing AdventureWorks Sample Database Analysis Services Development2011-05-03
Creating a SSAS Project Analysis Services Development2011-05-03
Creating a Star Schema Using a Data Source View Analysis Services Development2011-05-03
Designing a Cube Analysis Services Development2011-05-03
Creating a Dimension Analysis Services Development2011-05-03
Creating a Hierarchy Analysis Services Development2011-05-03
Creating a Cube using the Cube Wizard Analysis Services Development2011-05-03
Processing and Deploying a Cube Analysis Services Development2011-05-03
Debugging Deployment Errors Analysis Services Development2011-05-03
Processing Dimensions and Cube Analysis Services Development2011-05-03
Calculated Measures and Named Sets Analysis Services Development2011-05-03
Developing a Calculated Measure Analysis Services Development2011-05-03
Developing Named Sets Analysis Services Development2011-05-03
Browsing a Cube Using Excel Analysis Services Development2011-05-03
Using Excel and Creating a Pivot Table Report Analysis Services Development2011-05-03
Remove parent as a child from a SSAS parent child dimension Analysis Services Dimensions2011-04-22
Limitations of Static Named Sets in SSAS Analysis Services Development2011-04-13
Controlling the use of linked objects in SSAS Analysis Services Development2011-04-05
Controlling dataset processing time in SSRS reports Reporting Services Performance2011-03-18
SSRS Reports Performance Debugging and Analysis Reporting Services Performance2011-03-14
SSRS Linked Reports Example Reporting Services Development2011-02-23
How to reduce MDX code redundancy in SSAS Analysis Services Development2011-02-08
Hiding parameters and using default parameter values in SSRS reports Reporting Services Parameters2011-01-19
How to use SSAS 2008 Warning Framework effectively Analysis Services Development2011-01-04
Handle Wrong SSAS Results for Unrelated Dimension and Measure Groups Analysis Services Dimensions2010-12-15
Edition specific SSAS development using BIDS Analysis Services Development2010-12-01
Capturing and Logging Data Load Errors for an SSIS Package Integration Services Error Handling2010-11-08
Commonly made mistakes with SSIS Conditional Split Transform Integration Services Data Flow Transformations2010-11-01
Intelligent Conditional Split in an SSIS Package Integration Services Data Flow Transformations2010-10-14
Designing a Robust and Reusable ETL Prototype using SSIS Integration Services Development2010-10-01
Standardize data storage for geography spatial data type in SQL Server Spatial Data Storage2010-09-24
Conditional report rendering based on render formats for SSRS Reports Reporting Services Dynamic Reports2010-09-03
Centralize and Control Data Access in SSRS 2008 R2 Reporting Services Security2010-08-16
Administering SSRS Using SQL Server Management Studio Reporting Services Administration2010-08-02
Undo feature in SSIS package designer Integration Services Development2010-07-14
Add NULL Defense to SSIS Packages for Operators and Functions Integration Services Development2010-07-01
How to add NULL Defense to your SSIS packages using scripting Integration Services Development2010-06-22
How to add NULL defense for dates in SSIS packages Integration Services Development2010-06-02
SSIS Package Data Source for SSRS Reporting Services Data Sources2010-05-13
Enable SSIS as data source type on SSRS Reporting Services Data Sources2010-04-30
Trick to search a SQL Server SSIS package for tasks and transforms Integration Services Development2010-04-12
Using Microsoft Quadrant for data analysis and modeling Database Design2010-04-05
How to serialize error logging in SSIS Integration Services Error Handling2010-03-22
Different Ways to Search for SQL Server Database Objects Database Administration2010-03-17
SSIS Merge Join Transformation Fail Safe from Sorting Irregularities Integration Services Data Flow Transformations2010-03-08
How to connect to SQL Azure using SSRS 2008 R2 Azure2010-02-25
Read and write data from SQL Azure using SSIS 2008 R2 Azure2010-02-08
Create a Simple SQL Server Database Server Object Report Database Design2010-02-01
Planning SQL Server ETL Strategy Using SSIS for Extracts Integration Services Development2010-01-19
Decouple context specific logic from SSRS reports using facades Reporting Services Dynamic Reports2010-01-05
Profiling SSIS packages for component level change tracking Integration Services Configuration Options2009-12-03