Gord Burtch

Here is the link.

I’ll be referring to these slides today. Sorry for the late post, I just made these as I decided it would help to have the reference.

When you work through the Pivot table assignment, there will be some questions that talk about seasonality. For the purposes of the assignment, the seasons are defined as follows…

Fall: September to […]

Hello all,

I have updated the syllabus to reflect updated assignment deadlines. I have pushed many of the due dates back by two days, in order to allow for TA office hours on the Tuesday before each […]

Think for about 100 seconds what you learnt in class during week 7 (pivot tables) and summarize your thoughts here. What was the most novel thing you learned? What is the most useful thing? 1-3 sentences should be […]

This one is simple. Just setup your SAS OnDemand account and report your username as a comment on this post by 3pm on October 24th (Wednesday of next week), and receive a bonus of 0.25% toward your final grade.

Here are the slides. We will be covering these next week.

Hello all,

We are going to push the due date of the pivot tables assignment to Wednesday, October 24th at 3pm. We are slightly ahead of the other sections, so I am going to delay the due date for this in order […]

Here is the link. The class capture should be accessible once the class is over.

Here is the link.

Here is the exercise.

And here is the spreadsheet for the exercise.

And here is the solution.

Here is the assignment.

And here is the Food Emporium spreadsheet.

Here is the link.

On Wednesday we will be working through this in-class exercise on pivot tables. This will be useful in preparing you for your next assignment, which will be due one week after your first exam. Please download a […]

Here are some slides we can look at during next week’s exam review. I plan to build on these and look at example questions during the class, to walk through how they would be answered.

Send me any particular […]

Give an example from your experience, or from the media, where a company wished to answer a particular business question. Considering that context, state the performance metric that would be used to evaluate that […]

This is another article that discusses the large amounts of data that are now becoming available from all kinds of sources (e.g., telemetry/sensor data from digitally enabled products, like phones or cars, or […]

Study for your first exam instead! It takes place on October 15th.

Here is the link.

Here is an example Excel workbook that contains raw data you can use to generate pivot tables off of, to slice and dice sales summaries. You can refer to this workbook at your leisure; it will prove useful when […]