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 […]
Blog
Tiny IMDB Data Model Introduction
Tiny Data In this series of posts (“Tiny IMDB Data Model”) we’ll look at the Internet Movie Database […]
IMDB Repeating Genre Values
In working with the IMDB database tables, you find that each moving picture can have one or more […]
IMDB and the Excel Data Model
What if we wanted to import this database into Microsoft Excel and work with it? We want to […]
Choosing a Chart Type
There are lots of graphs you could use. Not all are great choices. Many times choosing simple and […]
Excel SUMIFS Function
The SUMIFS function, adds all of its arguments that meet multiple criteria. First, let’s compare the SUMIF function. […]
Excel Data Entry Forms
Using Excel’s forms you can make your life easier. How? Forms can help you reduce the number of […]
Excel Slicers
What is a slicer? A slicer is a visual representation of a filter. They are available in Excel […]
Create a Slideshow in PowerPoint
Microsoft’s PowerPoint is a good choice for creating a slideshow of pictures. You can insert pictures one at […]
Itzik Ben Gan’s Database
As a more complex and realistic example, let’s look at the database that Itzik Ben-Gan used in his […]
Relationships and the Data Story
When we describe and present the data we are telling a story or narrative. Quantitative stories are always […]
Pivot Table Sales Data Example
Let’s look at some Sales data in a simple example and use Pivot Table to summarize the data. […]