ITI 257 Data Analysis I: Data Analysis with Excel - Overview

Course Outline:

Learn big data analytics directly in Excel 2010 or 2013. Power Pivot is free Excel add-in developed by Microsoft. It is designed to deal with large complex data sets. No programming required! PowerBI is Microsoft's flagship tool for making big data analysis accessible to the average Office Power User. Always working on real examples - the course is specifically based on real world use cases. No long slides, but rather hands on examples. Learn how to work with large datasets, combining data from totally different data sources, use effective best practices on working with pivot tables and pivot charts Using Power Pivot and PowerBI. Learn how create interactive dashboards, and build custom dashboards to answer business questions. All material used in lectures is available for download. Students are highly encouraged to experiment with data themselves.


Excel III or equivalent experience.

Required Textbook & Materials


  • Title:   High Impact Data Visualization with Power View Power Map and Power BI
  • Author:   Asam Aspin
  • ISBN13:   978-1-4302-6616-7
  • Edition/Copyright:   0
  • Publisher:   Apress
  • Published Date:   June 18, 2014
  • Website:


Please bring a Flash Drive/Memory Stick 512MB or larger to class which will enable you to save your class work.

Meeting Information:

  • Days:   Monday and Wendesday
  • Dates:   10/12/2015 - 10/19/2015
  • Number of Sessions:   3
  • Time:   Monday & Wednesday - 06:30 PM - 09:30 PM
  • Location:   GBTC 440

Lesson Plan:

Session I - Monday, October 12, 2015

  • Course Overview Presentation
  • Chapter 1 - Self-Service Business Intelligence
  • Chapter 2 - Power View and Tables

Session II - Wendesday, October 14, 2015

  • Chapter 9 - PowerPivot Basics

Session III - Monday, October 19, 2015

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

Web Support:

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