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. Below are some key highlights.
- International experience of working across geographies (US, UK, Singapore) for multi-national clients in Banking, Logistics, Government, Media Entertainment, Products, Life Sciences and other domains
- Lead architect for a portfolio of 40+ apps, containing apps in web, mobile, BI, Analytics, Data warehousing, Reporting, Collaboration, CMS, NoSQL and other technologies.
- Official inventor of an Accenture patented application (File # 02749-PR-US)
- Published author:
- Online publications (mssqltips.com, sqlservercental.com, techrepublic.com and others)
- Print-media publication (Manning publication, Packt publication)
- MSDN Library (Whitepaper Title: Bulk report generation using SSIS and SSRS 2008 R2)
- TOGAF 9 Part I & II certified architect
- CITA-F certified architect
- HCAHD (Hortonworks Hadoop certified)
- MCSD.Net, and MCTS in SQL Server maintenance as well as Developing BI apps using SQL Server
- Accenture certified Sr. Technology Architect as well as Digital Architect
- Internal Awards: Capgemini BI Envoy Award, Accenture Inventor Award, Accenture ACE Award, and others
- External Awards: Microsoft MVP for 3 years on SQL Server - BI, MSSQLTips - Trend Setter Award, Rising Star Award and others.
- Blog: http://siddhumehta.blogspot.com
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.
2019 Awards
2018 Awards
2017 Awards
2016 Awards
2013 Awards
2010 Awards
Amazon AWS
- Enforce SSL for connecting to AWS RDS Instance of SQL Server (last update: 3/25/2019)
- Estimate AWS RDS Cost for SQL Server (last update: 7/10/2019)
- Restore SQL Server database backup to an AWS RDS Instance of SQL Server (last update: 4/4/2019)
Analysis Services Administration
- Create Project from a Deployed SSAS Tabular Database (last update: 9/23/2016)
- How to change compatibility level of a SSAS Tabular Database using SSDT (last update: 3/16/2016)
- How to import data from SSAS Multi-dimensional to SSAS Tabular (last update: 12/27/2016)
- Using Extended Events to monitor DAX queries for SSAS Tabular Databases (last update: 11/25/2016)
Analysis Services Development
- Add Cascading Parameters in a SSRS Report using MDX and SSAS Multi-Dimensional (last update: 3/22/2017)
- Controlling the use of linked objects in SQL Server Analysis Services (last update: 4/5/2011)
- Edition specific SSAS development using BIDS (last update: 12/1/2010)
- Enabling Drillthrough in Analysis Services (last update: 10/3/2011)
- How to create calculated tables in a tabular SQL Server Analysis Services SSAS model (last update: 7/6/2016)
- How to import data for SSAS Tabular vNext (last update: 2/13/2017)
- How to manipulate data during import in SSAS Tabular vNext (last update: 2/22/2017)
- How to query a SQL Server Analysis Services Data Mining Model with DMX (last update: 10/5/2016)
- How to query prediction results from a data mining model in SQL Server Analysis Services (last update: 5/24/2017)
- How to reduce MDX code redundancy in SQL Server Analysis Services SSAS (last update: 2/8/2011)
- How to setup a tabular data model in SSAS Azure (last update: 4/13/2017)
- How to use SSAS 2008 Warning Framework effectively (last update: 1/4/2011)
- Limitations of Static Named Sets in SQL Server Analysis Services SSAS (last update: 4/13/2011)
- Multi-language support for SSAS Tabular Models (last update: 11/8/2016)
- New Tabular Model Explorer for SSAS Tabular Projects (last update: 1/30/2017)
- Port SQL Server Analysis Services Tabular Databases to SSAS vNext CTP 1.1 (last update: 1/17/2017)
- Using Tabular Model Scripting Language with SQL Server Analysis Services (SSAS) (last update: 7/13/2016)
Analysis Services Dimensions
- Handle wrong results in SSAS for unrelated dimension and measure groups (last update: 12/15/2010)
- How to Enable Localization Support for SQL Server Analysis Services Dimension Attributes (last update: 8/25/2016)
- Remove parent as a child from a SQL Server Analysis Services SSAS parent child dimension (last update: 4/22/2011)
Analysis Services Measure Groups
- Optimize a SQL Server Analysis Services Measure Group Partition for Performance (last update: 7/28/2011)
Analysis Services Performance
- How to partition data in Tabular SSAS (last update: 5/10/2017)
- Improve SQL Server Analysis Services MDX Query Performance with Custom Aggregations (last update: 9/2/2016)
Azure
- How to connect to SQL Azure using SQL Server Reporting Services 2008 R2 (last update: 2/25/2010)
- Read and write data from SQL Azure using SQL Server Integration Services 2008 R2 (last update: 2/8/2010)
Database Administration
- Different Ways to Search for SQL Server Database Objects (last update: 3/17/2010)
- Python vs PowerShell for System and SQL Server Administration (last update: 6/4/2019)
Database Design
- Create a Simple SQL Server Database Server Object Report with Minimum Effort (last update: 2/1/2010)
- Using Microsoft Quadrant for data analysis and modeling (last update: 4/5/2010)
- What is a GUID in SQL Server (last update: 4/23/2019)
Functions - System
- SQL Server Substring Function Example with T-SQL, R and Python (last update: 5/16/2019)
- Using the SQL Server APP_NAME function to control stored procedure execution (last update: 3/11/2013)
Import and Export
- Bulk Insert Data into SQL Server (last update: 8/5/2019)
Integration Services Configuration Options
- Profiling SSIS packages for component level change tracking (last update: 12/3/2009)
Integration Services Data Flow Transformations
- Commonly made mistakes with SSIS Conditional Split Transform (last update: 11/1/2010)
- How to make an SSIS Merge Join transformation fail safe from sorting irregularities (last update: 3/8/2010)
- Intelligent Conditional Split in an SSIS Package (last update: 10/14/2010)
Integration Services Development
- Designing a Robust and Reusable ETL Prototype using SSIS (last update: 10/1/2010)
- Planning the SQL Server ETL implementation strategy using SSIS for Extracts (last update: 1/19/2010)
- Trick to search a SQL Server SSIS package for tasks and transforms (last update: 4/12/2010)
- Undo feature in SSIS package designer (last update: 7/14/2010)
Integration Services Error Handling
- Capturing and Logging Data Load Errors for an SSIS Package (last update: 11/8/2010)
- How to serialize error logging in SSIS (last update: 3/22/2010)
Integration Services NULL Management
- How to add NULL defense for dates in SSIS packages (last update: 6/2/2010)
- How to add NULL Defense to your SSIS packages for Operators and Functions (last update: 7/1/2010)
- How to add NULL Defense to your SSIS packages using scripting (last update: 6/22/2010)
Master Data Services
- How to analyze dependencies in a SQL Sever 2016 Master Data Services data model (last update: 6/29/2016)
- How to configure user permissions in SQL Server Master Data Services (last update: 6/23/2016)
- How to deploy a Master Data Services model (last update: 4/22/2016)
- How to standardize attribute values in Master Data Services (last update: 4/27/2016)
- How to version a SQL Server Master Data Services model (last update: 5/19/2016)
- Publishing SQL Server Master Data Services Data (last update: 5/9/2016)
Microsoft Excel Integration
- Automate field selection from SSAS Tabular Models in Power View reports (last update: 12/19/2016)
- How to Create a Burndown Chart in Excel from Scratch (last update: 5/3/2019)
- Using source data from an SSRS report in PowerPivot for Excel (last update: 5/10/2013)
Power BI
- Analytics with Power BI Desktop Dynamic Line References (last update: 10/2/2017)
- Analytics with Power BI Desktop for Data Clustering (last update: 10/30/2017)
- Analytics with Power BI Desktop for Trend Analysis (last update: 10/16/2017)
- Analytics with Power BI Desktop Using Constant Lines (last update: 9/19/2017)
- Analyze entity data flow in Power BI Desktop using Sankey charts (last update: 3/13/2018)
- Analyze Geospatial Data with Power BI Desktop (last update: 11/3/2017)
- Analyze inter-relationships with chord diagram visualization in Power BI Desktop (last update: 4/6/2018)
- Anomaly Detection without any coding using Power BI (last update: 6/25/2018)
- Classification and Regression Analysis using Decision Trees in Power BI Desktop (last update: 11/30/2017)
- Correlation Analysis using Correlation Plot in Power BI Desktop (last update: 11/27/2017)
- Data Analysis using a Journey Chart in Power BI Desktop (last update: 1/2/2018)
- Data exploration, drill down, and analysis using decomposition tree in Power BI Desktop (last update: 1/11/2018)
- Data Forecasting and Analytics with Power BI Desktop (last update: 10/9/2017)
- Distribution analysis on hierarchical data using a Hierarchy chart in Power BI Desktop (last update: 2/12/2018)
- Faceted Search and Filtering in Power BI Reports (last update: 9/11/2018)
- Generate visualizations in Power BI using Python Scripts (last update: 1/25/2019)
- Graph Analysis using Force Directed Graphs in Power BI Desktop (last update: 12/15/2017)
- How to render D3.js custom charts in Power BI Desktop (last update: 3/1/2018)
- How to visualize multivariate relationships using Power BI (last update: 8/15/2017)
- Install and configure Power BI Report Server and Power BI Desktop (last update: 7/28/2017)
- Integrate data driven Visio diagrams in Power BI Reports (last update: 3/22/2018)
- Multi-Variate Quantitative Analysis with Radar Charts in Power BI Desktop (last update: 4/23/2018)
- Performance Analysis using Ribbon Charts in Power BI Desktop (last update: 2/19/2018)
- Power BI Pie Chart Tree to Analyze Hierarchical Distributions (last update: 2/22/2019)
- Read and Import Data from PDF Files using Power BI (last update: 1/7/2019)
- Schedule analysis using Gantt chart in Power BI Desktop (last update: 1/29/2018)
- Segmentation analysis using Mekko Charts in Power BI Desktop (last update: 1/19/2018)
- Time Series Analysis in Power BI using Timeline Visual (last update: 6/20/2019)
- Transform Data in Power BI with R and Python (last update: 3/5/2019)
- Visualize categorical scatterplots in Power BI with Python (last update: 2/1/2019)
- Visualizing patterns in high voluminous data using Hexbin Scatterplot in Power BI (last update: 6/18/2018)
Professional Development Interview Questions BI
- SSRS Developer Interview Questions (last update: 9/9/2011)
Python
- Exploratory Data Analysis with Python in SQL Server 2017 (last update: 7/23/2018)
- Linear Regression with Python in SQL Server 2017 (last update: 8/8/2018)
Reporting Services Administration
- Administering SSRS Services Using SSMS (last update: 8/2/2010)
Reporting Services Charts
- Creating a Reporting Services Histogram Chart for Statistical Distribution Analysis (last update: 5/31/2011)
- Creating Trellis Charts to Make SSRS Reports More Readable (last update: 8/4/2011)
- Displaying Multiple Series on an SSRS Chart using Chart Area (last update: 8/22/2011)
- Distribution Analysis using a SQL Server Reporting Services Box Plot Chart (last update: 12/5/2011)
- Highlighting repeating groups in SSRS 2008 R2 charts (last update: 6/13/2011)
- How to handle empty values in a line chart in SSRS (last update: 5/5/2011)
- SQL Server Reporting Services Scatter Chart for Data Correlation (last update: 7/19/2011)
Reporting Services Configuration
- Customize SQL Server Reporting Services Reports Manager Portal (last update: 10/17/2016)
Reporting Services Data Sources
- Enable SSIS as data source type on SQL Server Reporting Services (last update: 4/30/2010)
- How to use SSIS package as a data source for SQL Server Reporting Services 2008 R2 (last update: 5/13/2010)
Reporting Services Development
- Converting MS Access Reports to SQL Server Reporting Services Reports (last update: 2/25/2016)
Reporting Services Dynamic Reports
- Conditional report rendering based on render formats for SSRS Reports (last update: 9/3/2010)
- Decouple context specific logic from SSRS reports using SQL Server facades (last update: 1/5/2010)
Reporting Services KPI
- How to report KPIs with gauges in SQL Server Reporting Services Mobile Reports (last update: 4/20/2017)
- SSRS 2008 R2 KPIs with bullet graphs (last update: 6/10/2011)
Reporting Services Maps
- Create Custom Maps for SQL Server Reporting Services Mobile Reports (last update: 3/2/2017)
Reporting Services Parameters
- Hiding parameters and using default parameter values in SSRS reports (last update: 1/19/2011)
Reporting Services Performance
- Controlling dataset processing time in SQL Server Reporting Services reports (last update: 3/18/2011)
- SQL Server Reporting Services Reports Performance Debugging and Analysis (last update: 3/14/2011)
Reporting Services Security
- Centralize and Control Data Access in SSRS 2008 R2 (last update: 8/16/2010)
Reporting Services Subreports
- SQL Server Reporting Services Linked Reports Example (last update: 2/23/2011)
SharePoint
- Creating Customized SharePoint Permissions (last update: 9/2/2010)
- Enabling and Using Usage Analysis Reporting in MOSS 2007 (last update: 2/8/2011)
- How to Configure PerformancePoint Services in SharePoint 2010 - Part I (last update: 3/30/2011)
- How to configure PerformancePoint services in SharePoint 2010 - Part II (last update: 4/12/2011)
- How to Prevent SharePoint 2010 users from using SharePoint Designer (last update: 2/23/2011)
- How to use SharePoint 2010 Performance Point Decomposition Trees (last update: 6/8/2011)
- Setting Row Limits on InfoPath Repeating Tables (last update: 11/26/2010)
- Using InfoPath 2007 User Roles (last update: 1/26/2011)
- What-If analysis using SharePoint 2010 Excel Services (last update: 8/25/2011)
SharePoint Administration
- How to show recent activities under My Newsfeed in SharePoint 2010 (last update: 8/2/2011)
SharePoint Configuration
- How to Push Membership Data in My Profile of SharePoint 2010 (last update: 9/29/2011)
- Sharepoint BI Features for SQL Server BI Professionals (last update: 6/9/2010)
Sharepoint Design
- Creating a SharePoint List of Links (last update: 8/5/2010)
- How to Create a Reusable Custom Style for the Content Query Web Part (last update: 2/3/2011)
- Using SharePoint Calculated Fields (last update: 10/14/2010)
- Using SharePoint Web Part Connections (last update: 9/29/2010)
Spatial Data Storage
- Standardize data storage for geography spatial data type in SQL Server (last update: 9/24/2010)
SQL Server 2016
- Generate charts rapidly with SQL Server using R and T-SQL (last update: 6/2/2017)
SQL Server 2017
- Analyze Categorical Data with a Mosaic Plot in SQL Server with R (last update: 11/9/2017)
- Develop and Query a Graph with SQL Server 2017 and R – Part 1 (last update: 10/5/2018)
- Develop machine learning models for predictive analysis in SQL Server 2017 (last update: 8/7/2017)
- Developing and Querying a Graph with SQL Server 2017 and R - Part 2 (last update: 10/23/2018)
- Generate Network Graphs with R in SQL Server 2017 (last update: 9/21/2018)
- Geocoding and Generating Map Images Using R in SQL Server 2017 (last update: 5/14/2018)
- How to setup Machine Learning Services in SQL Server 2017 CTP2 (last update: 6/8/2017)
- Image Processing with R and SQL Server 2017 (last update: 7/12/2018)
- Ingest data from a web page into SQL Server 2017 using R (last update: 7/11/2017)
- Installing external R packages to use with SQL Server 2017 (last update: 7/18/2017)
- Load data from PDF file into SQL Server 2017 with R (last update: 5/25/2018)
- Match datasets using Fuzzy Joins in SQL Server 2017 with R (last update: 12/4/2018)
- Multivariate data analysis with Tableplot using SQL Server 2017 and R (last update: 11/9/2018)
- Read and Write Excel files in real-time with R in SQL Server 2017 (last update: 8/21/2018)
- Relational Databases vs Graph Databases (last update: 7/25/2019)
SQL Server Management Studio
- How to generate T-SQL scripts in SQL Server Management Studio with the collation settings (last update: 9/13/2016)
