Monthly Archives: March 2016
Class Capture – 3/16/16
Here’s the link to today’s class capture. CC 3/16/16
16th Annual IT Awards
I encourage you to register for the 16th Annual IT Awards. It is our Institute of Business and Information Technology‘s biggest event of the year; IBIT is affiliated with the MIS department and is Fox’s connection to the IT industry.
The event is from 6:00 – 8:00 on Tuesday, April 12 on Main Campus.
There are three reasons to attend:
- Build your professional network. Building connections is a big reason why you’re here at Fox. It’s a fantastic, low pressure setting to meet people from the Philadelphia technology community. It is also well-attended (usually about 300 in total) by our alumni and our contacts from industry. Many of our alumni are now in positions where they influence hiring decisions and they love to promote Temple – get to know them!
- The award winners are really interesting. We are recognizing the CIO of QVC, the CEO and Founder of RJMetrics, and the North American CIO of Spencer Stuart.
- It’s a fun event and it’s easy to attend. It’s on Main Campus and the awards portion is short and informal. It leaves a lot of time for socializing with attendees. The food and drink are quite good too. And it’s free!
You can register here by APRIL 4!
If you have any questions about the event let me know. Hope to see you there!
Setting up R & R Studio
R is a widely-used, open source statistical analysis platform. RStudio is an integrated development environment for R – that means it makes using R easier!
You should install both software packages – R and RStudio! Don’t just install R or your life will be difficult!
We’ll be using this software to do some analytics! You can get a full copy of the software – PC or Mac – for free!
First download and install R:
- If you have Windows
- Download the installer file for R (this is a direct link to the install file).
- Make sure you keep track of where you save the installer.
- Double-click on the installer file and follow the instructions (just accept the default settings).
- If you have a Mac
- Download “R-3.2.1-snowleopard.pkg” if you have Mac OS X 10.6 or “R-3.2.4.pkg” if you have Mac OS X 10.9 or higher.
- Make sure you keep track of where you save the installer.
- Do whatever it is you “Mac people” do to install software! (I don’t have a Mac!)
Now download and install RStudio:
- Download the appropriate installer: Windows or Mac.
- Make sure you keep track of where you save the installer.
- Install the software! Just accept the default settings.
After both are installed, you’re always going to run RStudio, which will use R behind the scenes to give you a pleasing analytics experience!
In Class Exercise #9
Here’s the document: In-Class Exercise #9 – Descriptive Statistics Review
And here’s the key: In-Class Exercise #9 – Descriptive Statistics Review [KEY]
Exam 2 Study Guide
Here’s the study guide for exam 2. Exam 2 Study Guide
Advanced Analytical Deck Posted
The Advanced Analytical Deck has been posted here.
Assignment 5 – Due March 18th
Dimensional Data Deck Posted
Here’s the link to the deck for Dimensional Data Modeling – Decks
In Class Exercise – Pivot Tables
Here’s the document: In-Class Exercise #8 – Pivot Tables
Here’s the Salesperson Cube Data: In Class Exercise Salesperson Cube
Assignment 4 – ETL – Due March 11
Here’s the information you need to complete Assignment #4. This assignment will walk you through the process of ETL in Excel. You will learn some basic Excel formulas that will be helpful for the future as well! Simply work through the instructions in the Word document and as always, let me know if you have questions!
Follow the instructions for submission as well – just email me your completed Excel workbook by the morning of 3/11.
Word Doc: Assignment #4 – ETL
Excel Workbook: ETL Workbook