Titanic Dataset Dashboard - Power BI

In this project the infamous Titanic dataset was used in an effort to gain more understanding of the voyage as well as the tragic outcome. Data was imported directly into Power BI. Immediately there were some necessary steps in Power Query to make the data presentable in dashboard format of which are detailed below.

Link to Power BI file: https://github.com/ryandeuter/PortfolioProjects/blob/main/Titanic.pbix

Link to dataset: https://data.world/nrippner/titanic-disaster-dataset

BACKGROUND: Raw data imported into Power BI to find insights about voyage and outcome.

PROCESS: There was some data cleaning necessary in Power Query to make the visualizations more accessible.

Conditional columns were needed for the Survived column to display "Yes" and "No" values instead of Boolean numbers:

Here we can see values were replaced to allow for easier understanding in visuals.

The same conditional columns process was performed on the "Embarked" cities column, whereas values such as "S" were then replaced into the full city name column (i.e., "Southampton").

As fare was planned on being a Card visual, it was formatted properly to currency.

Here is our data view in Power Query before we Closed and Applied, ready for the dashboard.

Things are looking good, so I decided to add a nice crinkled paper background below the visuals under the Canvas Background options.

Two DAX measures were added using CALCULATE and COUNTROWS: Total Survived and Total Casualties.

Card values indicate average age, number of survivors, average ticket place, and total casualties.

Values can then be broken down by gender and port embarked from.

Thanks for checking out my Power BI report, if you have any comments please feel free to let me know!