Explored and tested the capabilities of Excel Power Query using the Titanic Dataset.
Modules Learned:
- Create Connections
- Add Columns from Examples
- Add Custom Columns
- Add Conditional Columns
- Group Tables of Data
- Transform Nested Queries
- Merge Connections