Turn a business question into a tested T-SQL metric with explicit time zones, cancellations, returns, and a hand-checked sample.
SQL SERVER – All the Features not Listed While Installing SQL Server
Analysis, Reporting and Integration Services were missing from the Features page while installing SQL Server. The cause was missing MSI files in my setup media.
Pareto Analysis in T-SQL: Which Products Make 80 Percent of Sales
Build Pareto analysis in T-SQL with product totals, stable running sums, and explicit ABC thresholds that handle ties and boundary choices.
SQL SERVER – What is Biml and How Can it Help Me with SQL Server BI? – Notes from the Field #036
What is Biml, and how can it help with SQL Server BI? Reeves Smith explains Business Intelligence Markup Language and how it adds automation to BI work.
Data Science: A Step Forward from Business Intelligence – Data Scientist
Who can predict which customer is going to cancel a newspaper subscription before it actually happens? It’s a Data Scientist.
What a Data Scientist Does: The Skills That Still Matter
What a data scientist does is turn a vague question into an answer that people can trust and act on. This post walks through the work as a loop, and shows the summary statistics step in T-SQL on a small bike rental log.
Big Data Analytics: Descriptive, Diagnostic, Predictive and Prescriptive
Big Data Analytics answers four kinds of questions: what happened, why it happened, what will happen next and what to do about it. This post climbs that ladder with one small business and shows each step in T-SQL window functions.