In this project we will cover importing data sources into excel using Power Query, setting up relational databases in the Excel Data Model, and finally visualizing data using Power BI. If you are using a Mac, you will need to remote into a virtual lab session to get access to the advanced data management features in Excel. The course Google Drive includes five datasets with college football statistics from the 2021 season in CSV (comma separated value) format. You will need to download these to your local computer to work with the data.

First you should build links to each of your locally saved CSV data files using PowerQuery (Video 2). You do not need to import the data, just link the data to Excel. Then you should link the individual datasets together in the workbook Data Model (Video 3). Using this data model you should build five interesting PowerPivot tables using the available data (Video 4). Finally, you should import the Data Model into Power BI desktop and create five interesting visualizations in Power BI (Video 5). You can email the excel file and Power BI file (.pbix) directly to me.