Simple Linear Regression in Excel
Linear regression analysis is used to predict the value of a variable based on the value of another […]
relationship
Data Model Examples in Excel
Do you want to work with a few small & sample data models in Excel to practice the […]
Power Pivot Filtering
As an example, let’s look at the FoodMart database in Excel’s Power Pivot. The first thing to do […]
Tiny IMDB Average Rating for each Person
This post follows from the previous post in this series of posts using a tiny made-up database that […]
IMDB and the Excel Data Model
What if we wanted to import this database into Microsoft Excel and work with it? We want to […]
Excel Table Relationships
Suppose you have two tables of data in Excel that are related. As an example, you might have […]
SQL Sever Many-To-Many
Do you have a database that has two tables that have a many-to-many relationship? What do I mean […]
Itzik Ben-Gan’s SQL Database
In Itzik’s book T-SQL Querying, published by Microsoft Press in 2015, he uses several tables as examples. Here […]
SQL Server Burton’s Database
There exists a SQL Server online course at Udemy.com that prepares you for the 70-461 exam. The couse […]