Jones International University – Analytics

Client and Need

  • Online university
  • Efficient method to grade leads from partners and measure effectiveness/productivity of advisors


  • Designed data warehouse and in-memory tabular model for use with Power Pivot in Microsoft Excel
  • Utilized SQL Server 2012 Enterprise Edition, SSIS for data transformation and data warehouse population, SSAS tabular instance for data hierarchy and measure definition, and Power Pivot in Microsoft Excel for data analytics
  • Implemented optimized data warehouse and Power Pivot solution to increase overall process efficiency and analytical capabilities

Value Added

  • Reduction of overall process length from hours to minutes
  • In-memory tabular model (SSAS) containing all data needed for analysis
  • Proper hierarchies and measures for data aggregation