These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Thursday, April 17, 2014

JST BI Blitz!

By Sean Fisher, Tahna Black, Joseph Burwasser

The Brigham Young University Information Systems program currently provides students taking their introductory courses with opportunities to explore business intelligence. Unfortunately, this capability is only provided through Microsoft SQL Server and students must either install this software on their personal computers or use the school’s desktops, which are limited in quantity. We have provided a solution to this situation: enabling students to utilize the basic business intelligence functions by including them in a downloadable workbook called JST BI Blitz. 

The objective of this project is to provide business intelligence algorithms for free to students in a form doesn’t require Microsoft SQL Server.
These algorithms include:
  • K-Nearest Neighbors(KNN)
  • Naive Bayes (NB)
The workbook displays the results of these algorithms in an intuitive manner which can be easily analyzed.

Aside from the algorithms, this workbook aims on providing other Business Intelligence-related capabilities to users. A customized ribbon includes the following options:
  • Cleaning the data before it’s analyzed (removing rows with blank values)
  • Partitioning the data into a training and a validation set
  • Tutorial for effectively utilizing the workbook


With the Blitz workbook, students are able to gain experience with statistical analysis in a convenient manner on their own laptops. Students can learn to build BI models without any additional software or financial strain.

Project Files:

No comments:

Post a Comment

Blog Archive