skip navigation

MS SQL Server 2012: Data Management and Analysis Solutions

To request access to the Microsoft platform for you and your students, please do the following:

  1. For a faculty teaching or research account, please click†Request Account
  2. Please click†Request Student Accounts to request accounts for your students

Overview of SQL Server 2012 Management Studio and SQL Server Data Tools


How To


  • Remote Desktop Connection†PDFDOCX
  • Use Pre-built DILLARDS Cube in SQL Server 2012†PDFDOCX

Examples


  • SQL Server 2012 BI Cube Building using DILLARDS†PDFDOCX
  • SQL Server 2012 BI Cube Building using SAMSCLUB_STAR†PDFDOCX
  • SQL Server 2012 Report Designing†PDFDOCX


Database Fundamentals


SQL Fundamentals and Advanced SQL Curriculum


Data Mining Modules

The Microsoft Enterprise Consortium, hosted by the Sam M. Walton College of Business at the University of Arkansas, utilizes Microsoft SQL Server 2012 suite of software products to support a broad base of academic learning and research interests world-wide.†Over the†past two years, thousands of faculty and students world-wide have accessed the Consortium resources for a wide-variety of teaching and learning activities and courses.†† New server resources were implemented†in Fall 2009 to ensure strong performance for the anticipated growth in users.

MEC

The two major components of SQL Server 2012 are SQL Server Management Studio and SQL Server Data Tools (formerly Business Intelligence Development Studio).† Information Systems and Computer Science departments may seem to be the most obvious Consortium users but many other disciplines may also take advantage of the Consortium resources.† For example, marketing faculty and students may wish to slice-and-dice one of the pre-built cubes to demonstrate business analytics or any number of disciplines can easily demonstrate the power of data mining using the Excel 2007 interface to the underlying BI Analysis Services data mining capabilities.††

The Microsoft Enterprise Consortium is free of charge and can only be used for academic purposes.† Its Website includes easy-to-follow tutorials and examples to learning to do any of the following with a number of large real, world sets of data.

  • Create database tables †
  • Write and tune queries
  • Create stored procedures
  • Build and tune cubes
  • Use Integration Services to illustrate ETL in the cube building process
  • Add Key Performance Indicators and Dashboards
  • Conduct business analytics using pre-built cubes
  • Use the SQL Server Data Tools to develop and run data mining models
  • Do data mining models using SQL Serverís Excel Data Mining Add-in
Enterprise Systems
Business Building 225
Fayetteville, AR 72701
(479) 575-6114  p