Simple Index and Weight Index Examples in R
Learn about index numbers with R to study changes in a phenomenon that we cannot measure directly such as the Consumer Price Index.
Nai Biao Zhou has twenty years of experience in software development, with strong analytical skills and a broad range of computer expertise.
He has fifteen years of experience in development and maintenance of database applications on SQL Server in OLTP/OLAP/BI environments.
He has a master's degree in Control Engineering and is pursuing a Master of Science degree in Predictive Analytics. Knowledge/Skills Advanced computer programming skills and well versed with C/C#, Java, ASP.NET, JavaScript, and SQL.
In depth knowledge of Solution Architecture, and Software Development Life Cycle (SDLC).
Microsoft Certified Application Developer (MCAD) since 2004.
- MSSQLTips Awards: Author of the Year - 2021 | Rising Star (50+ tips) - 2024 | Author Contender - 2020, 2023
Python Django Tutorial for Website with SQL Server Database
Learn how to create a website using Python Django with a SQL Server backend as we walk through the steps to get this up and running.
CRUD Operations in SQL Server using Python
This article goes through a process to show how you can use Python to perform create, read, update, and delete (CRUD) operations on SQL Server data.
What is a Relational Database Management System
This article covers the relational database system evolution and covers terms used in relational models such as relation, tuple, attribute, domain, schemas, and key.
SSRS Interactive Sorting and Charts
This article presents step-by-step instructions for the creation of a SSRS report with charts and interactive sorting buttons.
SSRS Report Security Management
Learn how to use SQL Server database security settings to dynamically display different SSRS report results to a user based on their security settings.
SQL Server Stored Procedure Custom Templates SSMS and Visual Studio
In this article we look at how to build a custom stored procedure template that can be used in either SSMS or Visual Studio for all new development.
Recursion in Python Explanation and Code Samples
In this article we discuss recursive programming techniques using Python.
Cross Tab Report in SSRS
This tip provides a step by step process to create a cross tabulation report in SQL Server Reporting Services.
Multiple Row Grouping Levels in SSRS Report
This article provides a step-by-step procedure to create an SSRS report with multiple row grouping levels.
Python Programming Tutorial with Top-Down Approach
In this article we will demonstrate how to apply the top-down approach to design a Python program with a real-world problem.
Using Simple Linear Regression to Make Predictions
The first part of this article focuses on using an R program to find a linear regression equation and the second part is devoted to simple linear regression analysis.
Discovering Insights in SQL Server Data with Statistical Hypothesis Testing
In this article we cover several elements of statistical hypothesis testing and how this can be done with SQL Server.
Learning Python in Visual Studio 2019
In this article we look at how to get familiar with writing Python code with several different examples of code.
Statistical Parameter Estimation Examples in SQL Server and R
This tip shows a step-by-step solution to use sample statistics to estimate population parameters using SQL Server and R.
Selecting a Simple Random Sample from a SQL Server Database
This tip is devoted to two topics: sampling techniques, and sampling distributions.
Using SQL Server RAND Function Deep Dive
This tip explores the concepts of random variable and distribution by introducing three named discrete probability distributions.
Basic Concepts of Probability Explained with Examples in SQL Server and R
The purpose of this tip is to provide enough knowledge of probability to evaluate pattern interestingness using SQL Server and R.
Numerically Describing Dispersion of a Data Set with SQL Server and R
To describe the association of two variables in a bivariate dataset, we are going to study two important measures of association: covariance and correlation coefficient using SQL Server 2017 and R.
SQL Server 2017 Machine Learning Visualization and Data Analysis
In this tip we look at several examples of creating charts and graphs using SQL Server 2017 Machine Learning Services.
Get Started with Data Analysis and Visualization with SQL Server and R
In this tip we will look at various ways to visualize your SQL Server data using R tools.
Create SSRS Report with External Images and Repeating Table Header
Learn how to develop a report in SQL Server Reporting Services that has a repeated table header with external images.
Data Analysis on the Microsoft Platform – Examining Data
The Microsoft platform enables us to work with SQL Server databases and R together. With powerful statistical tools we can get started using statistical methods to extract meaningful information from voluminous amounts of data.
Including Predetermined Datasets in a Microsoft Database Project
In this tip we look at how to include fixed data sets to be included with a Microsoft database project when deploying the project to a database server.