Data Mining with SQL Server 2008 Business Intelligence Development Studio A Hands-on Approach

Data mining is an emerging field of study in Information Systems programs. The purpose of this tutorial is to provide a hands-on approach on how to utilize SQL Server 2008 Business Intelligence platforms to teach a senior level data mining methods class in an Information Systems program. Our intention is to highlight the capabilities of the platform to faculty currently teaching a business intelligence course and are interested in expanding their teaching portfolio to the data mining area with hands-on exercises and projects. The platform allows faculty to focus on teaching the analytical aspects of data mining and the usage of algorithms through practical hands-on demonstrations, homework assignments and projects. As a result, students are expected to gain a conceptual understanding of data mining and the application of data mining algorithms for the purpose of decision support. Such a platform allows faculty to provide a comprehensive coverage of the topic with practical hands-on experience. The availability of this set of tools transforms the role of a student from a programmer of data mining algorithms (doing low level IT) to a business intelligence analyst

Active Learning via a Sample Database: The Case of Microsoft\u27s Adventure Works

This paper describes the use and benefits of Microsoft’s Adventure Works (AW) database to teach advanced database skills in a hands-on, realistic environment. Database management and querying skills are a key element of a robust information systems curriculum, and active learning is an important way to develop these skills. To facilitate active learning and produce a compelling narrative, the data structure and content of a useful pedagogically-oriented database should be realistic and lifelike. It should contain data that accurately depicts the business processes, functions, and entities of a realistic organization, structured in a way that demonstrates best practices in database design. Most database textbooks include sample databases, but these are often small and sparse of data. By contrast, Microsoft’s AW database presents a robust, realistic, and comprehensive framework for many important educational objectives in an IS curriculum. This paper introduces the AW business case and database, and illustrates several pedagogical uses in an undergraduate CIS program

Pedagogical Opportunities Of Microsoft’s Adventure Works Business Case And Data Model

Database management and querying skills are a key element of a robust information systems curriculum. The data structure and content of a useful pedagogically-oriented database should be realistic and lifelike, and the database should contain data that accurately depicts the business processes, functions, and entities of a realistic organization, organized in a way that demonstrates best practices in database design. Most database textbooks include some sample databases, but these are often relatively small and sparse of data. By contrast, Microsoft’s Adventure Works (AW) database presents a robust, realistic, and comprehensive framework for many important educational objectives in an Information Systems curriculum. This paper introduces the AW business case and database, and illustrates several pedagogical uses in an undergraduate CIS program

Design and Delivery of Multiple Server-Side Computer Languages Course

Given the emergence of service-oriented architecture, IS students need to be knowledgeable of multiple server-side computer programming languages to be able to meet the needs of the job market. This paper outlines the pedagogy of an innovative course of multiple server-side computer languages for the undergraduate IS majors. The paper discusses the rationale of why the proposed pedagogy is different from and improves the traditional methods. The paper provides a description of the approach to teaching a multiple server-side computer languages course. Based on our experiences in the past years, it is concluded that a single course of multiple server-side computer languages is useful and feasible for the IS programs

Chapter XII: A Comparison and Scenario Analysis of Leading Data Mining Software

Finding the right software is often hindered by different criteria as well as by technology changes. We performed an analytic hierarchy process (AHP) analysis using Expert Choice to determine which data mining package was best suitable for us. Deliberating a dozen alternatives and objectives led us to a series of pair-wise comparisons. When further synthesizing the results, Expert Choice helped us provide a clear rationale for the decision. The issue is that data mining technology is changing very rapidly. Our article focused only on the major suppliers typically available in the market place. The method and the process that we have used can be easily applied to analyze and compare other data mining software or knowledge management initiatives

Developing a Filter Kit System Database: Procedure and Analysis

A thesis presented to the faculty of the College of Science and Technology at Morehead State University in partial fulfillment of the requirements for the Degree Master of Science by He Shi on April 30, 2010

Business Intelligence Tools: overview and comparison study of analytic solutions

Dissertation presented as the partial requirement for obtaining a Master's degree in Information Management, specialization in Knowledge Management and Business IntelligenceBusiness intelligence (BI) proves to bring the companies competitive advantages, providing for an easier and clear decision-making process through the analysis of data. The growth in the BI tools market is clear and can be verified by the increase in tools being offered and the number of users looking for the right system to apply in their companies. However, it can be overwhelming to choose one tool considering the ocean of BI tools available in the market. It is key to understand which tool applies the best to certain business specifications before committing to a sometimes rather considerable investment. This work aims to give business intelligence users proximity to some business specifications and the tools that most apply to them. This is possible through the creation of use cases that exemplify business needs of fictitious companies and by using six BI tools to then test how the tools answer to each business needs. The work carried out holds out a capability matrix as output that compares how each tool works when facing a specific topic, to understand at the end which is the best tool for each use case

TLAD 2011 Proceedings:9th international workshop on teaching, learning and assesment of databases (TLAD)

This is the ninth in the series of highly successful international workshops on the Teaching, Learning and Assessment of Databases (TLAD 2011), which once again is held as a workshop of BNCOD 2011 - the 28th British National Conference on Databases. TLAD 2011 is held on the 11th July at Manchester University, just before BNCOD, and hopes to be just as successful as its predecessors.The teaching of databases is central to all Computing Science, Software Engineering, Information Systems and Information Technology courses, and this year, the workshop aims to continue the tradition of bringing together both database teachers and researchers, in order to share good learning, teaching and assessment practice and experience, and further the growing community amongst database academics. As well as attracting academics from the UK community, the workshop has also been successful in attracting academics from the wider international community, through serving on the programme committee, and attending and presenting papers.Due to the healthy number of high quality submissions this year, the workshop will present eight peer reviewed papers. Of these, six will be presented as full papers and two as short papers. These papers cover a number of themes, including: the teaching of data mining and data warehousing, databases and the cloud, and novel uses of technology in teaching and assessment. It is expected that these papers will stimulate discussion at the workshop itself and beyond. This year, the focus on providing a forum for discussion is enhanced through a panel discussion on assessment in database modules, with David Nelson (of the University of Sunderland), Al Monger (of Southampton Solent University) and Charles Boisvert (of Sheffield Hallam University) as the expert panel

TLAD 2011 Proceedings:9th international workshop on teaching, learning and assesment of databases (TLAD)

This is the ninth in the series of highly successful international workshops on the Teaching, Learning and Assessment of Databases (TLAD 2011), which once again is held as a workshop of BNCOD 2011 - the 28th British National Conference on Databases. TLAD 2011 is held on the 11th July at Manchester University, just before BNCOD, and hopes to be just as successful as its predecessors.The teaching of databases is central to all Computing Science, Software Engineering, Information Systems and Information Technology courses, and this year, the workshop aims to continue the tradition of bringing together both database teachers and researchers, in order to share good learning, teaching and assessment practice and experience, and further the growing community amongst database academics. As well as attracting academics from the UK community, the workshop has also been successful in attracting academics from the wider international community, through serving on the programme committee, and attending and presenting papers.Due to the healthy number of high quality submissions this year, the workshop will present eight peer reviewed papers. Of these, six will be presented as full papers and two as short papers. These papers cover a number of themes, including: the teaching of data mining and data warehousing, databases and the cloud, and novel uses of technology in teaching and assessment. It is expected that these papers will stimulate discussion at the workshop itself and beyond. This year, the focus on providing a forum for discussion is enhanced through a panel discussion on assessment in database modules, with David Nelson (of the University of Sunderland), Al Monger (of Southampton Solent University) and Charles Boisvert (of Sheffield Hallam University) as the expert panel

MULTIDIMENSIONAL DATA MODELLING: DATA SETS AND TOOLS FOR BUSINESS INTELLIGENCE

Business Intelligence (BI) is an expanding data management area. BI analysis requires students to understand key concepts such as multidimensional data modelling, data cleansing and data mining algorithms, tools and techniques. Practical work for BI is often based around Excel which has a number of limitations as far as the teaching of BI is concerned. This paper discusses the experience of using the SSAS (SQL Server Analysis Services) tool to introduce students to multidimensional data modelling. We describe the way in which the tool was used, the issues encountered, the strengths and limitations of working with SSAS and possible future extensions. We also discuss issues with identifying and using data sets and outline a proposal to extend the data sets available to our student