Data Analytics/Analysis Life Cycle
Data undergoes various stages throughout its life, during its creation, testing, processing, consumption, and reuse. The Data Analytics […]
data
Google Data Analytics at Coursera
What is the Google Data Analytics course at Coursera all about? Learn how to process and analyze data, […]
Data Analytics Introduction
What is data analytics? Here is what Wikipedia says about data analysis: “Data analysis is a process of […]
Business Intelligence (BI) Introduction
Business Intelligence (BI) is all about gathering and organizing the data your business or organization generates in its […]
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 […]
Microsoft’s FoodMart Database
It’s always very helpful to have a database to work with when you are learning software such as […]
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 and the Excel Data Model
What if we wanted to import this database into Microsoft Excel and work with it? We want to […]
Excel Data Entry Forms
Using Excel’s forms you can make your life easier. How? Forms can help you reduce the number of […]
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. […]