Nai Biao Zhou

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
Title Category Date
Get Started with Data Analysis and Visualization with SQL Server and R SQL Server 20172026-06-04
SharePoint File Management in a Document Library using Python Python2026-05-13
Build a WordPress Application on an AWS EC2 Instance Application Development2024-08-21
Setup a WordPress Environment – Apache, MySQL and phpMyAdmin Application Development2024-01-26
Build a Multi-Node Apache Hadoop Cluster using AWS EC2 Step by Step Big Data2023-12-13
Power Query M Language in Excel Tutorial Power BI2023-09-25
DAX in Excel Step-by-Step Tutorial Microsoft Excel Integration2023-08-24
Combine Data from Multiple Sheets in an Excel file with Power Query Microsoft Excel Integration2023-07-18
Pivot Tables in Excel – A Step-by-Step Tutorial for Beginners Microsoft Excel Integration2023-06-12
Learn how to use Power Query in Excel to Transform Data Microsoft Excel Integration2023-05-17
Data Warehouse Architecture for Small and Medium Businesses Data Warehousing2023-05-04
Create MSI Installer for a Python Application for Easy Distribution Python2023-04-11
Build Standalone Python Executable Application Python2023-03-29
Build Python GUI with Tkinter Python2023-03-06
How to Run a Python Script as a Windows Service using NSSM Python2022-07-26
Python as a Windows Service Example Python2022-07-11
Build a Web Crawler in Python for a Website Content Audit Python2022-03-02
Python Web Scraping to Conduct a Web Content Audit Python2022-01-25
How to Run a Python Script in Windows Python2022-01-12
Python Regex Explained with Examples Python2021-12-23
Run Python Scripts in a SQL Server Agent Job SQL Server Agent2021-12-22
Download Data from an HTML Table to an SQL Server Database with Python Python2021-11-18
SharePoint List CRUD Operations using Python Python2021-10-28
Multiple Linear Regression for Estimation and Prediction in SQL Server TSQL2021-10-14
Time Series Forecasting Methods with R Examples R Language2021-03-11
Simple Index and Weight Index Examples in R R Language2021-02-18
Python Django Tutorial for Website with SQL Server Database Python2021-02-04
CRUD Operations in SQL Server using Python Python2021-01-11
What is a Relational Database Management System Database Design2020-12-11
SSRS Interactive Sorting and Charts Reporting Services Development2020-11-12
SSRS Report Security Management Reporting Services Development2020-10-22
SQL Server Stored Procedure Custom Templates SSMS and Visual Studio Stored Procedures2020-10-08
Explore the Role of Normal Forms in Dimensional Modeling Database Design2020-10-06
Recursion in Python Explanation and Code Samples Python2020-09-17
Cross Tab Report in SSRS Reporting Services Development2020-09-03
Multiple Row Grouping Levels in SSRS Report Reporting Services Development2020-08-25
Python Programming Tutorial with Top-Down Approach Python2020-08-10
Using Simple Linear Regression to Make Predictions R Language2020-07-24
Discovering Insights in SQL Server Data with Statistical Hypothesis Testing TSQL2020-07-08
Learning Python in Visual Studio 2019 Python2020-06-09
Statistical Parameter Estimation Examples in SQL Server and R TSQL2020-04-28
Selecting a Simple Random Sample from a SQL Server Database TSQL2020-03-12
Using SQL Server RAND Function Deep Dive TSQL2020-02-11
Basic Concepts of Probability Explained with Examples in SQL Server and R TSQL2020-01-15
Numerically Describing Dispersion of a Data Set with SQL Server and R SQL Server 20172019-05-28
SQL Server 2017 Machine Learning Visualization and Data Analysis SQL Server 20172019-02-21
Create SSRS Report with External Images and Repeating Table Header Reporting Services Formatting2018-11-28
Data Analysis on the Microsoft Platform – Examining Data SQL Server 20172018-11-05
Including Predetermined Datasets in a Microsoft Database Project Database Administration2018-10-16
Create Star Schema Data Model in SQL Server with Microsoft Toolset Database Design2018-09-17
Using Advanced Publish Settings for Visual Studio Database Project Database Administration2018-05-11