Data Manipulation and Visualization

Class: BBA

Instructor: Muhammad Mustafa Mumtaz

Class details

Class Timing and Room 2:30 – 3:45 | Online only

Session Day(s) Tuesday / Thursday

Credit Hours: 3

Email mmmumtaz@iba.edu.pk

Contact # +61459692255

Course Description

Data Manipulation and Visualization is an applicative course aimed at building technical skills in
business graduates. The skills developed in this course will cover a data pipeline allowing students to
query data from SQL, fetch it in Excel, and visualize it in PowerBI. The course is designed to help students
understand data pipelines and basic database queries along with dashboard creation to prepare them
for leading similar projects in the corporate environment. It will also highlight the importance of Agile
approach in project management. It will also enable them to set realistic timelines and negotiate on
the same when working with resources from other departments and teams such as the DBAs or the
development teams.

BBA Program Learning Goals

1. Effective Communication Skills

Students will learn how to communicate results effectively through dashboards and visualizations

2. Knowledge of Core Business Disciplines

Students will be able to understand the integration of all business disciplines for problem solving

3. Critical Thinking Skills

Students will understand the linkages and limitations of different models and critically reflect on the
use of theory to understand practices and processes. Additionally, students will be able to identify and
analyze problems and apply appropriate problem-solving approaches
 Course Objectives and Learning Outcomes

1) Knowledge outcomes:
a. Understand different elements of a data pipeline
b. Be able to efficiently work through different phases of the pipeline
c. Apply the principles of good visualizations, tidy data, and efficient queries at different
stages of a data pipeline

2) Skills and abilities outcome:

a. Write intermediate level queries in SQL
b. Work proficiently in Excel
c. Set up intermediate level dashboards in PowerBI
d. Work in team using agile approach
e. Connect SQL, Excel and PowerBI automatically and create a complete data pipeline

Teaching and Learning Methodology

The pedagogy used for the course will be a combination of:

- Lectures
- Assignments
- Term project
- Presentations
- Exams
- Self-Study
- Case discussion
- Guest Lecture sessions
- Practical Lab sessions

Knowledge of
Communication Core Business
Critical
Skills Disciplines Ethics
Skills
Program Goals

Course
Learning
Outcomes

1 1 1

2 2 2
Module S. No, Topic Assignment Due
1 1 Course introduction
Introduction to Trello
Agile Team

1 2 Goal Seek and Scenario Builder Project Proposal

Team formation
Database creation

1 3 MS Excel Basics
Inputting basic formulas
SUM, COUNT, MIN, MAX, AVERAGE
Formatting

1 4-5 MS Excel intermediate formulas Excel Sprint 1: Use Excel to answer given
VLOOKUP, HLOOKUP, XLOOKUP, INDEX, questions on your datasets (S. No. 3,4,5)
MATCH, SUMIF, COUNTIF, AVERAGEIF,
IF, nested IF, AND, OR

1 6 Conditional formatting
Pivot tables

1 7 Data validation Excel Sprint 2: Use Excel to answer given

Macros questions on your datasets (S. No. 6,7)

1 8-9 Comprehensive Excel case study Excel Sprint 3: Report submission (Excel)
1 10 Project Discussion Trello Sprint 1: Dashboard Design
2 11 Installing SQL Accessing a database
Accessing a table
Load data into SQL

2 12 Connecting to Microsoft SQL from

Microsoft Excel

2 13-14 Retrieving data from a table

SELECT FROM WHERE commands with
text, date, and numeric data
Sorting results

2 15 Aggregating data with GROUP BY SQL Sprint 1: Write queries to answer

commands given questions on your dataset (S. No.
Types of aggregations 13, 14, 15)
Filtering aggregation through HAVING
commands
2 16 Joining tables
One-to-one, one-to-many, and many-
to-many joins
INNER, LEFT, RIGHT, and FULL joins

2 17 Subqueries in SELECT clause SQL Sprint 2: Write queries to answer

Subqueries in FROM clause given questions on your dataset (S. No.
Subqueries in WHERE clause 16, 17)

2 18 Comprehensive SQL case SQL Sprint 3: Report submission (SQL)

Import data into Power BI through
SQL/Excel connection
3 19 Set data types – differentiate between
attributes and measures
Define data structure and joins

3 20 Principles of good data display

Telling a story with dashboards

3 21 Choosing the right chart types

Making a chart in Power BI

3 22 Using tools and slicers PowerBI Sprint 1: Design PowerBI

dashboard

3 23 Setting hierarchies PowerBI Sprint 2: Make charts in Power BI

3 24-25 Advanced formulas and calculations with PowerBI Sprint 3: Dashboard Submission
Power BI Trello Sprint 2: Dashboard Submission

3 26-28 Group presentations

 Text Book and Reading Material.

Recommended Text
Excel 2016 for Dummies
Learning SQL (O Reily) by Alan Beaulieu’s
Microsoft Power BI Quick Start Guide

Secondary Texts

Handouts developed by teaching resource.

Online courses on Coursera/EdX

Prerequisite Skills and Knowledge to take this Course

Principles of Marketing
Introduction to Computer Applications
Business Mathematics
Be comfortable with using technology for learning
 GRADING PLAN
Trello Dashboard 10
SQL Assignments 20
Excel Assignments 20
Power BI Assignments 20
Group Presentation 20
Final Exam 10
TOTAL 100

Comments and/or Suggestions

Students may see the faculty any time for the purpose of term project/assignment discussion. They
may also contact the instructor in case of any problem or issue that needs attention.

Technology Requirements

Please bring your laptop to class when the instructor asks you.

Academic Conduct

No make-up mid-term test will be arranged.

Synergy in team dynamics & equitable contribution by members are integral to all successful
group projects. A ‘peer evaluation’ form submitted by all group members will therefore be used.
Social loafing will not be encouraged in this course. If a student is found guilty, he/she will be given no
marks for the project.

Please ensure all assignment submissions are made on time. In fairness to the other groups,
late submissions will be penalized a minimum 10%.

Attendance Policy

Attendance is important and will certainly be taken into account in the case of students on the
borderline between two grades.
This class follows IBA’s policy.

Plagiarism Policy

Plagiarism in any form is strongly discouraged. In case, a student or a group is found guilty, he/she will
be penalized as per the IBA procedures and laws.

Withdrawal Policy

This class follows IBA’s policy