ProfBurnett.com

ITI 257 Data Analysis I: Data Analysis with Excel - Session III

Session Outline:

  • Chapter 12 - Discovering and Loading Data with Power Query
  • Chapter 15 - Self-Service Business Intelligence (BI) with Power BI

Class Presentations

Session, Chapter, Presentation, Files & Solution Sets
Session Chapter Presentation Datafiles PDF File Solution File
3 Chapter 12: Power Query None None None
3 Chapter 15: Power BI Desktop

You can download the PowerPoint presentations.

Student Exercises

Exercise, Files & Solution Sets
Exercise Datafiles PDF File Solution File
Exercise 1 - Loading Data From a Public Data Sources Import a Public Data Source: Housing
Import a Public Data Source: Movies		 None Solution File
Complete Exercise 2a or 2b
Exercise 2a - Facebook Analytics None
Exercise 2b - Importing Web Page Data None

You can download the PDF Files and print out.

Session 3 Support Links

Title:   High Impact Data Visualization with Power View Power Map and Power BI

Power BI

Public Data Search

The World Bank

eBook