Nat Sundar

Nat Sundar is working as an independent SQL BI consultant in the UK with a Bachelor’s Degree in Engineering. He has considerable years of experience with the UK Financial Services Industry (mainly in Insurance and Investment Banking). He is passionate about SQL Server, SSIS, SSAS, SSRS and MDX. He has presented at SQLBits, SQLPass and the SQL London User Group. He has special interest towards Continuous Integration, Continuous Delivery and Deployment automation for the SQL BI (SSIS, SSAS and SSRS) stack. He can be contacted at sqlnat@gmail.com, via LinkedIN and on Twitter at @SQLNat.

Articles: 38

DevOps

Getting Started with GitHub for SQL Server Developers

Learn some of the basics of GitHub and how this can be utilized for your SQL Server development projects.

Nat Sundar
December 20, 2018

Python

Data Science: Cleansing Your Data Using Python

In this tip we learn about data cleansing and how this can be achieved using Python.

Nat Sundar
June 5, 2018

Data Science

Beginners Guide to Python for SQL Server Professionals

In this tip we cover some basics on how to get started with Python.

Nat Sundar
May 24, 2018

Career Development

Data Science for SQL Server Professionals

In this tip we do an overview of Data Science and the high level process. Take a look at this tip to get started.

Nat Sundar
May 14, 2018

Import and Export

Importing Complex JSON files using SSIS

In this tip we look at how we can use SQL Server Integration Services to import complex JSON file formats.

Nat Sundar
April 26, 2018

Import and Export

Import Nested JSON Files to SQL Server with SSIS

Check out this tip and learn how to import nested JSON files into SQL Server using SQL Server Integration Services.

Nat Sundar
April 10, 2018

Integration Services Development

Importing JSON Files Using SSIS

In this tip we look at how to import JSON files using SQL Server Integration Services.

Nat Sundar
March 23, 2018

Import and Export

Different Ways to Import JSON Files into SQL Server

In this tip we look at different ways to read JSON files to load the data into SQL Server.

Nat Sundar
March 1, 2018

Partitioning

Implementation of Sliding Window Partitioning in SQL Server to Purge Data

In this tip we look at how to implement sliding window partitioning in SQL Server to quickly purge or archive old data.

Nat Sundar
February 22, 2018

Power BI Charts

Creating Custom Maps to Display Data with Power BI

In this tip we look at how to use custom maps in Power BI to display data in a more visual way.

Nat Sundar
February 13, 2018

Power BI

Analyzing Multiple Pages of UK Petition Data Using Power BI

Check out this tip to learn how to build a function in Power BI to iterate through multiple web pages to load data.

Nat Sundar
January 31, 2018

Power BI

Analyze UK Petition Data Using Power BI

In this tip we look at how to load and analyze UK Petition data using Power BI.

Nat Sundar
January 18, 2018

Integration Services Administration

Deploy SSIS Projects to Multiple Environments Using C#

Read this tip to learn how to deploy SSIS projects to many target servers (Dev, SIT, UAT and other test environments) using C#.

Nat Sundar
December 22, 2017

Integration Services Administration

Deploy Multiple SSIS Projects Using C#

Check out this tip to learn how to deploy multiple SSIS projects using C# code.

Nat Sundar
December 11, 2017

Integration Services Administration

Deploy SSIS Projects Using C#

In this tip, I will demonstrate a method to automate SQL Server Integration Services (SSIS) Deployments using a C# console application.

Nat Sundar
November 17, 2017

Import and Export

SSIS Import and Export VARCHAR(MAX) Data

In this tip we cover how to import and export data using SSIS that contains large text data types.

Nat Sundar
November 6, 2017

Power BI

Analyzing Multiple Personal Accounts using Power BI

Learn how to analyze multiple personal financial accounts such as checking, savings and credit cards using Power BI.

Nat Sundar
August 22, 2017

Power BI

Analyzing Personal Finances with Power BI – Expenses Versus Budget

In this tip we take a look at how to extend our Power BI personal calculator to show how to compare expenses versus budget.

Nat Sundar
July 24, 2017

Power BI

Analyzing Personal Finances using Power BI

In a previous tip we developed a Personal Finance Calculator in Power BI. In this tip, we will enhance what we did in the first part of the series to get a better understanding of how to use Power BI features.