ProfBurnett.com

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

Session Outline:

  • Chapter 9 - PowerPivot Basics

Class Presentations

You can download the PowerPoint presentations

Student Exercise

Student Exercise 1

Student Exercise 1

  • SQL Server Connection Insructions
  • 1. Loading Data from SQL Server – Page 227

Student Exercise 2

  • Manipulating Data in Power View
  • Sort Data – Page 261
  • Filtering Data – Page 262
  • Clearing Filters – Page 264
  • Custom Filters: Text – Page 264
  • Custom Filters: Numeric – Page 265

Session 2 Support Links

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

Power BI

Public Data Search

The World Bank

eBook