Resource Center Search

The Resource Center is your source to find information on faculty preparation, learning activities, presentation material and reference information.

Search

  in      
Advanced Search


Categories

Author
Computer Science Areas
Level
Technologies
Usage Type

Special Collaboration Areas

Business Intelligence Robotics
Compilers, Languages, Runtimes Sensor Networks
Embedded Systems Software Engineering
Gaming and Graphics Technology in Learning
Mobility Trustworthy Computing
Networking Updates from Microsoft Research
Operating Systems

Home > Business Intelligence   (48 Object(s) in 12 Usage Type(s) found)

All: Miscellaneous Back to top
fdasfd  - 05/23/2008
afdf das fdas                                                                                                                                    


Faculty Preparation: Professional Development Back to top
Business Intelligence – BI Fundamentals – BI Videos  - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.                                        


Learning Activities: Executable Program Back to top
Business Intelligence – SQL Learning Suite 2.1  - 11/17/2007
The Microsoft SQL Learning Suite provides platform for those who don't have basic knowledge of SQL. It is intended for two types of users, those with no knowledge of SQL and those that need a quick refresher. The SQL Learning Suite application introduces users to the basic keywords and query syntax of SQL using the interactive GUI features.


Learning Activities: Exercise/Exam Back to top
Business Intelligence – SQL Learning Suite 2.1  - 11/17/2007
The Microsoft SQL Learning Suite provides platform for those who don't have basic knowledge of SQL. It is intended for two types of users, those with no knowledge of SQL and those that need a quick refresher. The SQL Learning Suite application introduces users to the basic keywords and query syntax of SQL using the interactive GUI features.
Business Intelligence – Queries  - 11/17/2007
These exercises provide hands-on experience using Microsoft SQL Server Management Studio to write and execute intermediate level Structured Query Language (SQL) using the Dillard’s Department Store and Sam’s Club databases.
Business Intelligence – BI Reference Materials  - 11/17/2007
This material provides hands-on experience connecting and querying databases using Visual Basic .NET. In addition there are Case Studies and White Papers about using Business Intelligence on the Microsoft Platform.
Business Intelligence – Structured Query Language (SQL)  - 11/17/2007
These exercises provide hands-on experience using Microsoft SQL Server Management Studio to write and execute Structured Query Language (SQL) against the Hallux Productions database.
Business Intelligence – Data Modeling  - 11/17/2007
This material demonstrates how to create Entity Relationship Diagrams (ERDs) using Microsoft Visio Professional 2003. The diagrams generated using Visio are not “traditional” ERDs, but are based on the same concepts, contain similar structures, and include some very powerful features.


Learning Activities: Lab Back to top
Business Intelligence – Structured Query Language (SQL)  - 11/17/2007
These exercises provide hands-on experience using Microsoft SQL Server Management Studio to write and execute Structured Query Language (SQL) against the Hallux Productions database.
Business Intelligence – Database Administration  - 11/17/2007
This material contains the steps needed to install and configure the Business Intelligence demo server for use in the classroom.                 
Business Intelligence on the Microsoft Platform - Building a BI Demo Server  - 03/16/2006
This file is a supplemental component of the "Business Intelligence on the Microsoft Platform" lecture module set (See Object ID 6326: MicrosoftBI.ZIP) - Business Intelligence is an area of great interest to students and faculty in light of the huge job growth in the data/business analysis industry. Microsoft has created these modules to provide faculty with tools to fill this need.


Learning Activities: Project Back to top
Business Intelligence – Database Administration  - 11/17/2007
This material contains the steps needed to install and configure the Business Intelligence demo server for use in the classroom.                 
SQL Server 2005 Express Absolute Beginner Video #5 – Manipulating Database Data  - 01/23/2007
SQL Server beginners will learn about ADO.NET objects and execution of SQL statement from ADO.NET. Explore SQL and learn about insert, update, and delete statements. Visit http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx#5 to download the project.
SQL Server 2005 Express Absolute Beginner Video #7 – Understanding Security & Network Connectivity  - 01/23/2007
SQL Server beginners will learn to differentiate between SQL Server database files and SQL Server processes. Explore scenarios for connecting to SQL Server Express databases, enabling and disabling user instances, login permissions, and other security precautions. Visit http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx#7 to download the project.
SQL Server 2005 Express Absolute Beginner Video #8 – Connecting your Web Application  - 01/23/2007
SQL Server beginners will walkthrough the entire workflow of creating a database driven Web application and use visual tools to quickly create an administration application. Visit http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx#8 to download the project.


Presentation Materials: Audiovisual Content Back to top
Video Import Test  - 04/14/2009
A test video.                                                                                                                                    
Microsoft Academic Days on Business Applications, Relational Databases, and Security - Strange Bedfellows: Lawyers, Accountants, and Computer Scientists  - 11/30/2007
In this session David L. Baumer discusses how US companies that acquire, process, and transmit personally identifying information are increasingly burdened by statutes and government regulations.
Microsoft Academic Days on Business Applications, Relational Databases, and Security - Latest Updates on Denial of Information Attacks and Defenses  - 11/30/2007
In this presentation Kang Li provides a summary of our latest findings in 2007 on the various tricks used by spammers.                           
Microsoft Academic Days on Business Applications, Relational Databases, and Security - An On-Line Instructor Support System to Support Business/Engineering Classrooms  - 11/30/2007
In this presentation Chetan S. Sankar discusses the Instructor Support System (ISS) based on Microsoft® SQL database system by Auburn University‘s Laboratory for Innovative Technology and Engineering Education.
Microsoft Academic Days on Business Applications, Relational Databases, and Security - Security Measures Conceived Within Business Process Models  - 11/30/2007
In this presentation Joseph Barjis discusses his proposal for an innovative Security-Driven Business Processes Modeling that delivers secure models, bringing security implementation up to the business process level.
Microsoft Academic Days on Business Applications, Relational Databases, and Security - A Roadmap for Sustainable Enterprise Digital Policy Management  - 11/30/2007
In this presentation Jean-Henry Morin discusses approaches addressing current issues in the field of Enterprise DRM such as: document management, email, communications, retention policies, classification, and compliance.
Microsoft Academic Days on Business Applications, Relational Databases, and Security - Connecting the Dots with Business Applications  - 11/30/2007
How can we move the business application experience beyond data entry and the simple concepts of data storage and retrieval? What is the connection to business process automation? In this presentation Lori Thalmann-Pytlik discusses how software can be used to help students visualize the connections between real business functions.
Microsoft Academic Days on Business Applications, Relational Databases, and Security - Microsoft Enterprise Consortium  - 11/30/2007
The Microsoft Enterprise Consortium is a joint program between the Department of Information Systems in the Sam M. Walton College of Business at the University of Arkansas, Fayetteville, and Microsoft to provide to the academic community access to large and compelling real-world datasets for both teaching and research.
Microsoft Academic Days on Business Applications, Relational Databases, and Security - Office Tech: A New Paradigm in Office Services?  - 11/30/2007
Susan Winter will introduce her own refereed JIT case paper in a presentation on Office Tech: A New Paradigm in Office Services? She will describe the characteristics of a good teaching case, how one is formulated, how her case can best be used, and the value of the investment made in producing the paper.
Microsoft Academic Days on Business Applications, Relational Databases, and Security - Reshaping the Information Systems Curricula for Business Students  - 11/30/2007
In this presentation Olajinka David-West shares and reviews how our information systems course is delivered to our business students on the MBA and other executive management programs at the Lagos Business School, Lagos, Nigeria.
Microsoft Academic Days on Business Applications, Relational Databases, and Security - Building Vendor Capabilities Using Web 2.0 Collaboration to Improve Offshore Business Process Outsourcing  - 11/30/2007
In this presentation Biswadip Ghosh studies the role of activities that facilitate the adoption and use of collaboration technologies to improve vendor capabilities.
Microsoft Academic Days on Business Applications, Relational Databases, and Security - Virtual Collaboration  - 11/30/2007
In this presentation Lorraine Willoughby will demonstrate how Microsoft SharePoint has been incorporated into a Systems Analysis and Design class as a collaborative tool.
Business Intelligence – BI Fundamentals – Module 4 of 4  - 11/17/2007
Modules 1, 2 and 3 covered the end result of a BI project discussed the basics of what it takes to get there: ETL, building cubes containing measures and dimensions, and then accessing that data. Module 4 looks further at the kinds of data that can be examined and how it can be analyzed to help all manner of business users.
Business Intelligence – BI Fundamentals – Module 3 of 4  - 11/17/2007
Modules 1 and 2 covered the end result of a BI project and learned the basics of what it takes to get there: ETL, building cubes containing measures and dimensions, and then accessing that data. Module 3 examines the tools that make building, delivering, and maintaining a BI solution a reality.
Business Intelligence – BI Fundamentals – Module 2 of 4  - 11/17/2007
Module 1 started by showing the end result of a BI project: the output being used by a variety of different users in the organization. Module 2 takes students a level deeper and peeks under the covers at the concepts involved in building a BI solution.
Business Intelligence – BI Fundamentals – Module 1 of 4  - 11/17/2007
This module introduces the concepts of Business Intelligence, or BI. It does this by presenting the different types of users in an organization and describing how they use BI. It shows a demonstration of the kinds of tools that could be used by each group of users in order to gain benefits from a BI solution.
Business Intelligence – BI Fundamentals – BI Videos  - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.                                        
Business Intelligence – Data Modeling  - 11/17/2007
This material demonstrates how to create Entity Relationship Diagrams (ERDs) using Microsoft Visio Professional 2003. The diagrams generated using Visio are not “traditional” ERDs, but are based on the same concepts, contain similar structures, and include some very powerful features.
SQL Server 2005 Express Absolute Beginner Video #1 - What is a Database  - 01/23/2007
This introduction covers the questions and terminology SQL Server beginners need to create and manage databases, such as: What is a SQL Server database? How is a SQL Server database different from an Excel spreadsheet? What do SQL Server databases do in my website or software applications? What’s SQL Server Express’ relation to Visual Studio Express?
SQL Server 2005 Express Absolute Beginner Video #2 – Understanding Database Tables & Records  - 01/23/2007
SQL Server beginners will learn about tables and definitions of data types, properties, keys, etc. in this second video. Find out how table rows, columns, and fields interrelate and whether columns can be empty.
SQL Server 2005 Express Absolute Beginner Video #3 – More about Column Data Types & Other Properties  - 01/23/2007
SQL Server beginners will explore data integrity, learn which data types to use for what, and avoid common data type pitfalls.                   
SQL Server 2005 Express Absolute Beginner Video #4 – Designing Relational Database Tables  - 01/23/2007
Why are relational databases the most popular? SQL Server beginners will learn to differentiate between primary and foreign keys, design relational database tables, and learn about normalization rules and de-normalization.
SQL Server 2005 Express Absolute Beginner Video #5 – Manipulating Database Data  - 01/23/2007
SQL Server beginners will learn about ADO.NET objects and execution of SQL statement from ADO.NET. Explore SQL and learn about insert, update, and delete statements. Visit http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx#5 to download the project.
SQL Server 2005 Express Absolute Beginner Video #6 – More Structured Query Language  - 01/23/2007
SQL Server beginners will discover more SQL statements like sub-select and learn stored procedures and their counterparts in C# and VB methods.  
SQL Server 2005 Express Absolute Beginner Video #7 – Understanding Security & Network Connectivity  - 01/23/2007
SQL Server beginners will learn to differentiate between SQL Server database files and SQL Server processes. Explore scenarios for connecting to SQL Server Express databases, enabling and disabling user instances, login permissions, and other security precautions. Visit http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx#7 to download the project.
SQL Server 2005 Express Absolute Beginner Video #8 – Connecting your Web Application  - 01/23/2007
SQL Server beginners will walkthrough the entire workflow of creating a database driven Web application and use visual tools to quickly create an administration application. Visit http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx#8 to download the project.
SQL Server 2005 Express Absolute Beginner Video #9 – Using SQL Server Management Studio Express  - 01/23/2007
SQL Server Management Studio Express will typically be your main interface into SQL Server Express. This lesson demonstrates the essential techniques and skills you’ll need to successfully connect to database instances, navigate the query window and scripting database objects, attaching, detaching and backing up databases, and much more.
SQL Server 2005 Express Absolute Beginner Video #10 – Getting Started with Reporting Services  - 01/23/2007
SQL Server Reporting Services allows you to design and deploy nicely formatted and interactive reports representative of your data. This video demonstrates how to set up Reporting Services and the Business Intelligence Development Studio to build reports using the wizards and designers, and deploy them to your Report Server.
SQL Server 2005 Express Absolute Beginner Video #11 – Embedding, Packaging & Deploying SQL Server Express Reporting Services  - 01/23/2007
Building on the previous lesson, we dive into building reports from scratch and modifying the reports that were created using the wizards and designers. We also demonstrate how to embed your reports into your ASP.NET Web Form applications.
SQL Server 2005 Express Absolute Beginner Video #12 – Creating & Using Stored Procedures  - 01/23/2007
This video expands on the topic of Stored Procedures which was introduced several lessons ago. In this video we explain the basic syntax to create and update stored procedures, including using input and output parameters, declaring variables and adding other T-SQL programming elements and the Visual Basic and C# syntax required to utilize stored procedures in your own applications.
SQL Server 2005 Express Absolute Beginner Video #13 – Enabling Full-Text Search in your Text Data  - 01/23/2007
Full-Text search allows you to save large portions of text – even Microsoft Word documents, or other file formats – into your database and perform complex queries based on this textual data while expecting great performance. This lesson demonstrates how to creating full-text indexes, configuring the index population settings and performing queries.
Business Intelligence on the Microsoft Platform - Module 1 Training Videos  - 03/16/2006
This file is a supplemental component of the "Business Intelligence on the Microsoft Platform" lecture module set (See Object ID 6326: MicrosoftBI.ZIP) - Business Intelligence is an area of great interest to students and faculty in light of the huge job growth in the data/business analysis industry. Microsoft has created these modules to provide faculty with tools to fill this need.
Business Intelligence on the Microsoft Platform - Module 2 Training Videos  - 03/16/2006
This file is a supplemental component of the "Business Intelligence on the Microsoft Platform" lecture module set (See Object ID 6326: MicrosoftBI.ZIP) - Business Intelligence is an area of great interest to students and faculty in light of the huge job growth in the data/business analysis industry. Microsoft has created these modules to provide faculty with tools to fill this need.
Business Intelligence on the Microsoft Platform - Module 3 Training Videos  - 03/16/2006
This file is a supplemental component of the "Business Intelligence on the Microsoft Platform" lecture module set (See Object ID 6326: MicrosoftBI.ZIP) - Business Intelligence is an area of great interest to students and faculty in light of the huge job growth in the data/business analysis industry. Microsoft has created these modules to provide faculty with tools to fill this need.
Business Intelligence on the Microsoft Platform - Module 4 Training Videos  - 03/16/2006
This file is a supplemental component of the "Business Intelligence on the Microsoft Platform" lecture module set (See Object ID 6326: MicrosoftBI.ZIP) - Business Intelligence is an area of great interest to students and faculty in light of the huge job growth in the data/business analysis industry. Microsoft has created these modules to provide faculty with tools to fill this need.


Presentation Materials: Demo Back to top
BI – Business Intelligence  - 12/11/2007
Conceitos de Business Intelligence (BI) e suas aplicações.                                                                                       
Microsoft Academic Days on Business Applications, Relational Databases, and Security - Strange Bedfellows: Lawyers, Accountants, and Computer Scientists  - 11/30/2007
In this session David L. Baumer discusses how US companies that acquire, process, and transmit personally identifying information are increasingly burdened by statutes and government regulations.
Microsoft Academic Days on Business Applications, Relational Databases, and Security - Latest Updates on Denial of Information Attacks and Defenses  - 11/30/2007
In this presentation Kang Li provides a summary of our latest findings in 2007 on the various tricks used by spammers.                           
Microsoft Academic Days on Business Applications, Relational Databases, and Security - An On-Line Instructor Support System to Support Business/Engineering Classrooms  - 11/30/2007
In this presentation Chetan S. Sankar discusses the Instructor Support System (ISS) based on Microsoft® SQL database system by Auburn University‘s Laboratory for Innovative Technology and Engineering Education.
Microsoft Academic Days on Business Applications, Relational Databases, and Security - Security Measures Conceived Within Business Process Models  - 11/30/2007
In this presentation Joseph Barjis discusses his proposal for an innovative Security-Driven Business Processes Modeling that delivers secure models, bringing security implementation up to the business process level.
Microsoft Academic Days on Business Applications, Relational Databases, and Security - A Roadmap for Sustainable Enterprise Digital Policy Management  - 11/30/2007
In this presentation Jean-Henry Morin discusses approaches addressing current issues in the field of Enterprise DRM such as: document management, email, communications, retention policies, classification, and compliance.
Microsoft Academic Days on Business Applications, Relational Databases, and Security - Connecting the Dots with Business Applications  - 11/30/2007
How can we move the business application experience beyond data entry and the simple concepts of data storage and retrieval? What is the connection to business process automation? In this presentation Lori Thalmann-Pytlik discusses how software can be used to help students visualize the connections between real business functions.
Microsoft Academic Days on Business Applications, Relational Databases, and Security - Microsoft Enterprise Consortium  - 11/30/2007
The Microsoft Enterprise Consortium is a joint program between the Department of Information Systems in the Sam M. Walton College of Business at the University of Arkansas, Fayetteville, and Microsoft to provide to the academic community access to large and compelling real-world datasets for both teaching and research.
Microsoft Academic Days on Business Applications, Relational Databases, and Security - Office Tech: A New Paradigm in Office Services?  - 11/30/2007
Susan Winter will introduce her own refereed JIT case paper in a presentation on Office Tech: A New Paradigm in Office Services? She will describe the characteristics of a good teaching case, how one is formulated, how her case can best be used, and the value of the investment made in producing the paper.
Microsoft Academic Days on Business Applications, Relational Databases, and Security - Reshaping the Information Systems Curricula for Business Students  - 11/30/2007
In this presentation Olajinka David-West shares and reviews how our information systems course is delivered to our business students on the MBA and other executive management programs at the Lagos Business School, Lagos, Nigeria.
Microsoft Academic Days on Business Applications, Relational Databases, and Security - Building Vendor Capabilities Using Web 2.0 Collaboration to Improve Offshore Business Process Outsourcing  - 11/30/2007
In this presentation Biswadip Ghosh studies the role of activities that facilitate the adoption and use of collaboration technologies to improve vendor capabilities.
Microsoft Academic Days on Business Applications, Relational Databases, and Security - Virtual Collaboration  - 11/30/2007
In this presentation Lorraine Willoughby will demonstrate how Microsoft SharePoint has been incorporated into a Systems Analysis and Design class as a collaborative tool.
Business Intelligence – BI Fundamentals – Module 4 of 4  - 11/17/2007
Modules 1, 2 and 3 covered the end result of a BI project discussed the basics of what it takes to get there: ETL, building cubes containing measures and dimensions, and then accessing that data. Module 4 looks further at the kinds of data that can be examined and how it can be analyzed to help all manner of business users.
Business Intelligence – BI Fundamentals – Module 3 of 4  - 11/17/2007
Modules 1 and 2 covered the end result of a BI project and learned the basics of what it takes to get there: ETL, building cubes containing measures and dimensions, and then accessing that data. Module 3 examines the tools that make building, delivering, and maintaining a BI solution a reality.
Business Intelligence – BI Fundamentals – Module 2 of 4  - 11/17/2007
Module 1 started by showing the end result of a BI project: the output being used by a variety of different users in the organization. Module 2 takes students a level deeper and peeks under the covers at the concepts involved in building a BI solution.
Business Intelligence – BI Fundamentals – Module 1 of 4  - 11/17/2007
This module introduces the concepts of Business Intelligence, or BI. It does this by presenting the different types of users in an organization and describing how they use BI. It shows a demonstration of the kinds of tools that could be used by each group of users in order to gain benefits from a BI solution.


Presentation Materials: Slides Back to top
BI – Business Intelligence  - 12/11/2007
Conceitos de Business Intelligence (BI) e suas aplicações.                                                                                       
Microsoft Academic Days on Business Applications, Relational Databases, and Security - Strange Bedfellows: Lawyers, Accountants, and Computer Scientists  - 11/30/2007
In this session David L. Baumer discusses how US companies that acquire, process, and transmit personally identifying information are increasingly burdened by statutes and government regulations.
Microsoft Academic Days on Business Applications, Relational Databases, and Security - Latest Updates on Denial of Information Attacks and Defenses  - 11/30/2007
In this presentation Kang Li provides a summary of our latest findings in 2007 on the various tricks used by spammers.                           
Microsoft Academic Days on Business Applications, Relational Databases, and Security - An On-Line Instructor Support System to Support Business/Engineering Classrooms  - 11/30/2007
In this presentation Chetan S. Sankar discusses the Instructor Support System (ISS) based on Microsoft® SQL database system by Auburn University‘s Laboratory for Innovative Technology and Engineering Education.
Microsoft Academic Days on Business Applications, Relational Databases, and Security - Security Measures Conceived Within Business Process Models  - 11/30/2007
In this presentation Joseph Barjis discusses his proposal for an innovative Security-Driven Business Processes Modeling that delivers secure models, bringing security implementation up to the business process level.
Microsoft Academic Days on Business Applications, Relational Databases, and Security - A Roadmap for Sustainable Enterprise Digital Policy Management  - 11/30/2007
In this presentation Jean-Henry Morin discusses approaches addressing current issues in the field of Enterprise DRM such as: document management, email, communications, retention policies, classification, and compliance.
Microsoft Academic Days on Business Applications, Relational Databases, and Security - Connecting the Dots with Business Applications  - 11/30/2007
How can we move the business application experience beyond data entry and the simple concepts of data storage and retrieval? What is the connection to business process automation? In this presentation Lori Thalmann-Pytlik discusses how software can be used to help students visualize the connections between real business functions.
Microsoft Academic Days on Business Applications, Relational Databases, and Security - Microsoft Enterprise Consortium  - 11/30/2007
The Microsoft Enterprise Consortium is a joint program between the Department of Information Systems in the Sam M. Walton College of Business at the University of Arkansas, Fayetteville, and Microsoft to provide to the academic community access to large and compelling real-world datasets for both teaching and research.
Microsoft Academic Days on Business Applications, Relational Databases, and Security - Office Tech: A New Paradigm in Office Services?  - 11/30/2007
Susan Winter will introduce her own refereed JIT case paper in a presentation on Office Tech: A New Paradigm in Office Services? She will describe the characteristics of a good teaching case, how one is formulated, how her case can best be used, and the value of the investment made in producing the paper.
Microsoft Academic Days on Business Applications, Relational Databases, and Security - Reshaping the Information Systems Curricula for Business Students  - 11/30/2007
In this presentation Olajinka David-West shares and reviews how our information systems course is delivered to our business students on the MBA and other executive management programs at the Lagos Business School, Lagos, Nigeria.
Microsoft Academic Days on Business Applications, Relational Databases, and Security - Building Vendor Capabilities Using Web 2.0 Collaboration to Improve Offshore Business Process Outsourcing  - 11/30/2007
In this presentation Biswadip Ghosh studies the role of activities that facilitate the adoption and use of collaboration technologies to improve vendor capabilities.
Microsoft Academic Days on Business Applications, Relational Databases, and Security - Virtual Collaboration  - 11/30/2007
In this presentation Lorraine Willoughby will demonstrate how Microsoft SharePoint has been incorporated into a Systems Analysis and Design class as a collaborative tool.
Business Intelligence – BI Fundamentals – Module 4 of 4  - 11/17/2007
Modules 1, 2 and 3 covered the end result of a BI project discussed the basics of what it takes to get there: ETL, building cubes containing measures and dimensions, and then accessing that data. Module 4 looks further at the kinds of data that can be examined and how it can be analyzed to help all manner of business users.
Business Intelligence – BI Fundamentals – Module 3 of 4  - 11/17/2007
Modules 1 and 2 covered the end result of a BI project and learned the basics of what it takes to get there: ETL, building cubes containing measures and dimensions, and then accessing that data. Module 3 examines the tools that make building, delivering, and maintaining a BI solution a reality.
Business Intelligence – BI Fundamentals – Module 2 of 4  - 11/17/2007
Module 1 started by showing the end result of a BI project: the output being used by a variety of different users in the organization. Module 2 takes students a level deeper and peeks under the covers at the concepts involved in building a BI solution.
Business Intelligence – BI Fundamentals – Module 1 of 4  - 11/17/2007
This module introduces the concepts of Business Intelligence, or BI. It does this by presenting the different types of users in an organization and describing how they use BI. It shows a demonstration of the kinds of tools that could be used by each group of users in order to gain benefits from a BI solution.
Metrics & Business Intelligence for the Network-centric Enterprise  - 06/04/2007
Presentation presented at the Microsoft Dynamics Academic Alliance sessions at Convergence 2006. This presentation examines the "Network Enterprise Model" and "Next Generation" Solutions.
Development of a Network-Centric Business Intelligence System for a Medium-sized Manufacturing Enterprise & its Incorporation into Business School Curriculum  - 06/04/2007
Presentation presented at the Microsoft Dynamics Academic Alliance sessions at Convergence 2007. This presentation examines the strategic benefit of investments in sophisticated enterprise systems.
Business Intelligence on the Microsoft Platform  - 03/16/2006
Business Intelligence is an area of great interest to students and faculty in light of the huge job growth in the data/business analysis industry. Microsoft has created these modules to provide faculty with tools to fill this need.
Business Intelligence  - 03/08/2006
A brief (but dense) set of slides containing introductory material on Business Intelligence. Includes reference to software tools.               


Reference Materials: Case Study Back to top
Business Intelligence – BI Reference Materials  - 11/17/2007
This material provides hands-on experience connecting and querying databases using Visual Basic .NET. In addition there are Case Studies and White Papers about using Business Intelligence on the Microsoft Platform.


Reference Materials: Readings Back to top
Business Intelligence – Datasheets and More  - 11/17/2007
This material contains SQL Server 2005 datasheets about: Top 30 Features of SQL Server 2005, Express, Workgroup Edition, Analysis Services, Data Mining, Integration Services, Report Builder, Reporting Services, and Migration Assistant.
Business Intelligence – BI Reference Materials  - 11/17/2007
This material provides hands-on experience connecting and querying databases using Visual Basic .NET. In addition there are Case Studies and White Papers about using Business Intelligence on the Microsoft Platform.


Reference Materials: Tutorial Back to top
Business Intelligence – BI Fundamentals – BI Videos  - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.                                        
SQL Server 2005 Express Absolute Beginner Video #1 - What is a Database  - 01/23/2007
This introduction covers the questions and terminology SQL Server beginners need to create and manage databases, such as: What is a SQL Server database? How is a SQL Server database different from an Excel spreadsheet? What do SQL Server databases do in my website or software applications? What’s SQL Server Express’ relation to Visual Studio Express?
SQL Server 2005 Express Absolute Beginner Video #2 – Understanding Database Tables & Records  - 01/23/2007
SQL Server beginners will learn about tables and definitions of data types, properties, keys, etc. in this second video. Find out how table rows, columns, and fields interrelate and whether columns can be empty.
SQL Server 2005 Express Absolute Beginner Video #3 – More about Column Data Types & Other Properties  - 01/23/2007
SQL Server beginners will explore data integrity, learn which data types to use for what, and avoid common data type pitfalls.                   
SQL Server 2005 Express Absolute Beginner Video #4 – Designing Relational Database Tables  - 01/23/2007
Why are relational databases the most popular? SQL Server beginners will learn to differentiate between primary and foreign keys, design relational database tables, and learn about normalization rules and de-normalization.
SQL Server 2005 Express Absolute Beginner Video #5 – Manipulating Database Data  - 01/23/2007
SQL Server beginners will learn about ADO.NET objects and execution of SQL statement from ADO.NET. Explore SQL and learn about insert, update, and delete statements. Visit http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx#5 to download the project.
SQL Server 2005 Express Absolute Beginner Video #6 – More Structured Query Language  - 01/23/2007
SQL Server beginners will discover more SQL statements like sub-select and learn stored procedures and their counterparts in C# and VB methods.  
SQL Server 2005 Express Absolute Beginner Video #7 – Understanding Security & Network Connectivity  - 01/23/2007
SQL Server beginners will learn to differentiate between SQL Server database files and SQL Server processes. Explore scenarios for connecting to SQL Server Express databases, enabling and disabling user instances, login permissions, and other security precautions. Visit http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx#7 to download the project.
SQL Server 2005 Express Absolute Beginner Video #8 – Connecting your Web Application  - 01/23/2007
SQL Server beginners will walkthrough the entire workflow of creating a database driven Web application and use visual tools to quickly create an administration application. Visit http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx#8 to download the project.
SQL Server 2005 Express Absolute Beginner Video #9 – Using SQL Server Management Studio Express  - 01/23/2007
SQL Server Management Studio Express will typically be your main interface into SQL Server Express. This lesson demonstrates the essential techniques and skills you’ll need to successfully connect to database instances, navigate the query window and scripting database objects, attaching, detaching and backing up databases, and much more.
SQL Server 2005 Express Absolute Beginner Video #10 – Getting Started with Reporting Services  - 01/23/2007
SQL Server Reporting Services allows you to design and deploy nicely formatted and interactive reports representative of your data. This video demonstrates how to set up Reporting Services and the Business Intelligence Development Studio to build reports using the wizards and designers, and deploy them to your Report Server.
SQL Server 2005 Express Absolute Beginner Video #11 – Embedding, Packaging & Deploying SQL Server Express Reporting Services  - 01/23/2007
Building on the previous lesson, we dive into building reports from scratch and modifying the reports that were created using the wizards and designers. We also demonstrate how to embed your reports into your ASP.NET Web Form applications.
SQL Server 2005 Express Absolute Beginner Video #12 – Creating & Using Stored Procedures  - 01/23/2007
This video expands on the topic of Stored Procedures which was introduced several lessons ago. In this video we explain the basic syntax to create and update stored procedures, including using input and output parameters, declaring variables and adding other T-SQL programming elements and the Visual Basic and C# syntax required to utilize stored procedures in your own applications.
SQL Server 2005 Express Absolute Beginner Video #13 – Enabling Full-Text Search in your Text Data  - 01/23/2007
Full-Text search allows you to save large portions of text – even Microsoft Word documents, or other file formats – into your database and perform complex queries based on this textual data while expecting great performance. This lesson demonstrates how to creating full-text indexes, configuring the index population settings and performing queries.