Skip to main content Skip to navigation
Mauricio Featherman Marketing Analytics
WeekTopic
wsusmall
Week 1
8/25, 8/27
excel
Discussion: Introduction to BI concepts, the Microsoft BI Stack,
and to the course vision and format.

Hands on: External Data Connections in Excel, SSMS, SSRS

Module 1 Overview
wsusmall
Week 2 & 3
9/3, 9/8, 9/10
sqlServer
Discussion: Database concepts: retrieving filtered and totaled data

Hands-on: T-SQL SELECT, JOIN and GROUP BY in SSMS, SSRS

Featherman's TSQL Primer.docx (please open this file, open up SSMS, open up a VPN connection as needed and copy/paste the TSQL syntax into a new query

Before beginning your T-SQL experimentation you are strongly advised to watch 5 hours of Youtube video on T-SQL Select Statements.

Module 2 Overview

HW#3 Part 1: Please provide your 2.5 or 3 page summary of chapter 1 of the course textbook. Cover the contents of the chapter and include external readings based on your related research.

Part 2: Here is a hands-on component -
Intro SQL Assignment (due 9.19.14).

------------------------------------------------------------------

HW#4 Part 1: Please provide your 2.5 or 3 page summary of chapter 2 of the course textbook. Cover the contents of the chapter and include external readings based on your related research.

Part 2: Second SQL Assignment- (due 9.26.14)
wsusmall
Week 4
9/15, 9/17
sqlServerlogo-sql-2012-reporting-services
Discussion: Reporting strategies for different levels if management

Hands-on: SSRS
Module 3 Overview

Video Review Assignment #1 of 3 (3.33% of class grade)
Video 1 - Big data, Analytics
Video 2 - Big Business: Unlocking Value from Big Data with Analytics (this assignment in preparation for Big data seminar). Check the syllabus for grading criteria- one 2 or 3 page write-up is sufficient for the two videos combined.
wsusmall
Week 5
9/22, 9/24
sharepoint-logologo-sql-2012-reporting-services
Discussion: Data visualization strategies

Hands-on: Intermediate SSRS reports
(matrix, parameters, sparklines)

Module 4 Overview

HW #5 SSRS Intro Assignment.docx (due 10.11.14)
wsusmall
Week 6
9/29, 10/1
sharepoint-logologo-sql-2012-reporting-serviceslinkerimg
Discussion: Integrative Reporting strategy options

Hands-on: Advanced SSRS topics and deployment to Sharepoint (maps, gauges)

Module 4 Overview
wsusmall
Week 7,8
10/6, 10/8,
10/13, 10/15
imgFsharepoint-logologo-sql-2012-reporting-serviceslinkerimg
Discussion: Performance Management using Dashboards and Scorecards

Hands-on: Sharepoint, SSRS topics

Module 5 Overview

HW#6 - Second SSRS Reporting Project Due 10-26-14.

Book Review #1 (worth 5% of grade) Read the first 5 chapters (which together is part 1) and chapter 14 of the Business Dashboards (Rasmussen et.al) book shown above (from Skillport). The chapters are short. Pay close attention to SMART principal. Provide a 4 page summary of the content (does not include the title page) and a one-page plan for your likely use of different levels of dashboards in your future career. You may bring in external sources (please add to bibliography). Please turn in high quality work as this project is worth a lot of points.
wsusmall
Week 9
10/20, 10/22
sqlServer
Database Management: From 0 to Hero:
Creating Database Tables, Views and Stored Procedures


Module 6 Overview

HW#7 - Pivot Tables Assignment.docx Due 11-5-14.

HW#8 - Creating Stored Procedures Due 11-9.14

Video Review Assignment #2 of 3 (3.33% of class grade)
PowerBI for Office 365 Check the syllabus for grading criteria- one 2 or 3 page write-up is sufficient for the two videos combined.
wsusmall
Week 10
10/27, 10/29
sqlServerpowerpivotLogoexcelpowerview-logo
Module 7: Creating Excel tabular models with PowerPivot
Module 7 Overview
wsusmall
Week 11
11/3, 11/5
10.3 - self study
10.5 - guest lecturer Chris Califf provides hands-on Tableau experience.

HW#9 - Creating a Tableau Dashboard. Use the provided hand-out and training to create a dashboard of one of the Tableau sample databases. Due 11.16.14

Video Review Assignment #3 of 3 (3.33% of class grade)

Choose 1 to 2 hours of video on a BI topic that you want to learn more about.
Check the syllabus for grading criteria- one 2 or 3 page write-up is sufficient for the combines video content.
wsusmall
Week 12
11/10, 11/12
sqlServerpowerpivotLogoexcellinkerimg
Briefing on Final Projects: PowerBI - PowerView, PowerMap, PowerQuery, PowerPivot

Module 8 Overview

Instructions: Final Project.
Data --> SeattlePD_Incidents.zip

You can also access the data online
Server: cb-ot-devst03.ad.wsu.edu
UserID: mfstudent
Password BIAnalyst
Database: Featherman_Analytics
Table: SeattlePD_Incidents
wsusmall
Week 13
11/17, 11/19
9781430266167sqlServerpowerpivotLogoexcellinkerimg
Module 8 PowerBI: PowerView, PowerMap, PowerQuery,

Module 8 Overview

Book Review #2 (worth 5% of grade). Provide a 3 page summary (does not include the title page) of the first 5 chapters of the above book. Include a personal statement of how you might use PowerView (including maps if you wish) in your career. Please turn in high quality work as this project is worth a lot of points.
Book Review #3 (worth 5% of grade). Provide a 3 page summary (does not include the title page) Please turn in high quality work as this project is worth a lot of points.
The topic is spreadmarts and strategies for managing them. Due 12.12.14

Content Link #1
Content Link #2
wsusmall
Week 15
12/1, 12/3
sqlServerpowerpivotLogoexcel
Review, work on final projects
12.1.14 Exam - Study Guide
wsusmall
Week 16
12/8, 12/10
Work on final projects - due 12.12.14

Recap of skills transferred