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.
Learn PowerBI and Advanced Analytics – Instructor-Led and Self Paced Training
Readers often ask me where to learn PowerBI and Advanced Analytics, a topic I rarely cover. Here is the instructor-led and self paced training I suggest.
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.
SQL – Business Intelligence: Derive Data or Information?
Do we derive data or information for decisions? Four questions managers should ask so their business intelligence comes from the right information.
What Is a Star Schema?
A star schema is one fact table surrounded by dimension tables. What facts and dimensions hold, why grain is the decision you cannot undo, why the data repeats on purpose, and a worked example in AdventureWorksDW.