For week 1, I did a data connection is done through online services, data.world instead of uploading the excel data file. This acts as a web connector.
Below are the steps I followed to achieve loading in the data:
1. Get Data
2. Select online services
3. Select data.world
4. Enter the owner and Dataset ID values from data.world
5. Authenticate – signing into data.world
In this challenge, the data has to be cleaned by excluding the FBA Totals and null values from FBS Conferences field. Remove all Conference Medians within NCAA Subdivision and create data model properly relating two dim tables to the fact table.
After selecting the needed tables for the task, I transformed the data instead of loading it in.
1. Once the data is loaded, selecting the fact table, and the FBS Conferences field, I deselected the FBA Totals and null values and applied these changes.
2. Also selecting NCAA Subdivision field and deselecting the Conference Medians from the field.
3. To save the changes, click on close & apply.
1. In order to create a relationship between the two dimension tables and the fact table properly, select the database icon to see the schema and edit the relationship as needed.
Steps in pictures for details.
Hurray, I made it – week 1 challenge completed.