Titanic Logistic Regression
This post will discuss the building of a logistic regression model on the Titanic dataset provided by Kaggle. […]
pivot
Pivoting Data in R
When organizing or tidying your data using R, you might need to convert wide data to long data […]
Excel Pivot and Unpivot
Many of the transformations in Power Query are fairly easy to grasp but other ones, such as Pivotting […]
Pivot Table Sales Data Example
Let’s look at some Sales data in a simple example and use Pivot Table to summarize the data. […]
Power Pivot Kevin Cookie
Let’s work with Kevin here on the fictitious Kevin Cookie Company’s data. Have a look at the YouTube […]
Unpivot in Power Query
What is unpivot and when would you use it? The unpivot operation converts columns to rows. It creates […]
Excel Power Pivot Introduction
What is Power Pivot? It is an add-in, and according to Microsoft: “Power Pivot is a data modeling […]
Excel Pivot Tables Date Grouping
Dates can be a bit tricky. For the best solution to working with dates in our Pivot Table […]
Excel Table Relationships
Suppose you have two tables of data in Excel that are related. As an example, you might have […]
Create a Pivot Table from Multiple Sheets using Power Query
Do you have an Excel workbook (file) that has multiple worksheets of data that you need to combine […]
Pivot Table Example
Here is a simple example of how to create a pivot table in Excel that is based on […]
Excel Pivot Tables Introduction
What are Pivot Tables in Microsoft Excel? First of all, let’s discuss tables. In Excel, a table is […]