PowerBI: A tool for bringing Big Data in class

Organizer: 
EAA Education Committee
Dates: 
November 16, 2021
Location: 
Online

Instructor: Dr Tawei (David) Wang, DePaul University

Live Q&A event: November 16, 2021, at 4-5pm CET

Check out the trailer by Dr. Wang - https://youtu.be/Kz-xeOo0_Mc

Learning Objectives

After completing this series of videos, participants should be able to:

  1. Understand the questions visual analytics can answer
  2. Import data into PowerBI desktop
  3. Model and manipulate data
  4. Create visualizations and dashboards

Asynchronous Material will cover the following topics:

  1. Introduction to visual analytics
  2. Introduction to PowerBI and the first visualization (What is it?, Benefits and limitations, Illustrative example in vendor management and datasets)
  3. Model data and data manipulations (Transform data, Working with multiple datasets and relationships, Calculated columns, dimensions, and measures, Aggregation, What do we find?)
  4. Predictive analytics with PowerBI (What is predictive analytics?, Limitations about prediction with visual anlaytics tools, An example, Assumptions and interpretations, Using PowerBI with Azure, R and Python)
  5. Building an interactive dashboard

PowerBI Interactive Session: “Designing and Implementing Data Analytics Exercises”

During this interactive session, Professor David Wang will share the do’s and don’ts when designing and implementing data analytics exercises. In addition, different design ideas will be discussed. Questions and comments can be submitted to the speaker under each video or posted on the chat during the live session.

Register for this November 16 one hour event here

Video Course Schedule

1.0.

Introduction

2.0.

Introduction to Power BI

2.1.

First visualization—trend and smart narrative

2.2.

First visualization—stacked bar (proportion)

3.0.

Transform data

3.1.

Relationships

3.2.

Calculated columns

3.3.

Dimensions

3.4.

Measures

4.0.

Predictive analytics

5.0.

Interactive dashboard

The datasets and the slides can be downloaded through the links in the description here.