ProfBurnett.com

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

Course Outline:

Learn big data analytics directly in Excel 2013, 2016 and MS Office 365. PowerPivot, PowerView, PowerQuery, & PowerMap are free Excel add-ins developed by Microsoft. It is designed to deal with large complex data sets. No programming required! PowerBI is Microsoft's flagship application 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.

Prerequisites:


Excel III or equivalent experience.

Required Textbook & Materials

REQUIRED

  • Title:   Beginning Power BI with Excel 2013
  • Author:   Dan Clark
  • ISBN13:   978-1-4302-6445-3
  • Edition/Copyright:   1
  • Publisher:   Apress
  • Published Date:   October 4, 2014
  • Website:   apress.com

Materials:

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, Wendesday, Saturday
  • Dates:   3/21/2016 - 3/26/2016
  • Number of Sessions:   3
  • Time:   Monday & Wednesday - 06:30 PM - 09:30 PM
  • Time:   Saturday - 09:30 AM - 12:30 PM
  • Location:   Rockville HU 321

Lesson Plan:

Session I - Monday, March 21, 2016

  • Course Overview Presentation
  • Self-Service Business Intelligence & Power BI Application
  • Part I - Building Models in Power Pivot

Session II - Wendesday, March 23, 2016

  • Part II – Building Interactive Reports and Dashboards with Power View

Session III - Saturday, March 26, 2016

  • Part III – Exploring and presenting Data with Power Query and Power Map
  • Part IV - Power BI Desktop

Web Support: