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 Operating Systems
Compilers, Languages, Runtimes Robotics
Embedded Courseware Sensor Networks
Embedded Systems Software Engineering
Gaming and Graphics Technology in Learning
Mobility Trustworthy Computing
Networking Updates from Microsoft Research

Home > Business Intelligence   (94 Object(s) in 11 Usage Type(s) found)

Faculty Preparation: Professional Development Back to top
Microsoft Dynamics Customer Model Departments  - 07/17/2008
The Microsoft Dynamics Customer Model describes how people in departments do work within and across organizations.                               
Business Intelligence – BI Fundamentals – BI Videos - 1 of 21 (Slides)  - 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.                 


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://www.microsoft.com/express/sql/previous/default.aspx for more information about this product.
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.
SQL Server 2005 Express Absolute Beginner Video #8 – Connecting your Web Application  - 01/23/2007
SQL Server beginners will walk through the entire workflow of creating a database driven Web application and use visual tools to quickly create an administration application. Visit http://www.microsoft.com/express/sql/previous/default.aspx for more information about this product.


Presentation Materials: Audiovisual Content Back to top
Microsoft Academic Days on Business Applications, Relational Databases, and Security - Security Measures Conceived Within Business Process Models - 1 of 2 (Video)  - 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.
Business Intelligence – BI Fundamentals – Module 4 of 4 - 1 of 6 (Video)  - 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 4 of 4 - 2 of 6 (Video)  - 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 4 of 4 - 3 of 6 (Video)  - 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 4 of 4 - 4 of 6 (Video)  - 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 4 of 4 - 5 of 6 (Video)  - 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 - 1 of 20 (Video)  - 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 3 of 4 - 2 of 20 (Video)  - 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 3 of 4 - 3 of 20 (Video)  - 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 3 of 4 - 4 of 20 (Video)  - 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 3 of 4 - 5 of 20 (Video)  - 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 3 of 4 - 6 of 20 (Video)  - 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 3 of 4 - 7 of 20 (Video)  - 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 3 of 4 - 8 of 20 (Video)  - 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 3 of 4 - 9 of 20 (Video)  - 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 3 of 4 - 10 of 20 (Video)  - 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 3 of 4 - 11 of 20 (Video)  - 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 3 of 4 - 12 of 20 (Video)  - 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 3 of 4 - 13 of 20 (Video)  - 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 3 of 4 - 14 of 20 (Video)  - 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 3 of 4 - 15 of 20 (Video)  - 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 3 of 4 - 16 of 20 (Video)  - 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 3 of 4 - 17 of 20 (Video)  - 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 3 of 4 - 18 of 20 (Video)  - 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 3 of 4 - 19 of 20 (Video)  - 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 - 1 of 6 (Video)  - 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 2 of 4 - 2 of 6 (Video)  - 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 2 of 4 - 3 of 6 (Video)  - 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 2 of 4 - 4 of 6 (Video)  - 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 2 of 4 - 5 of 6 (Video)  - 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 - 1 of 14 (Video)  - 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 – Module 1 of 4 - 2 of 14 (Video)  - 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 – Module 1 of 4 - 3 of 14 (Video)  - 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 – Module 1 of 4 - 4 of 14 (Video)  - 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 – Module 1 of 4 - 5 of 14 (Video)  - 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 – Module 1 of 4 - 6 of 14 (Video)  - 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 – Module 1 of 4 - 7 of 14 (Video)  - 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 – Module 1 of 4 - 8 of 14 (Video)  - 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 – Module 1 of 4 - 9 of 14 (Video)  - 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 – Module 1 of 4 - 10 of 14 (Video)  - 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 – Module 1 of 4 - 11 of 14 (Video)  - 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 – Module 1 of 4 - 12 of 14 (Video)  - 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 – Module 1 of 4 - 13 of 14 (Video)  - 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 - 2 of 21 (Video)  - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.                                        
Business Intelligence – BI Fundamentals – BI Videos - 3 of 21 (Video)  - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.                                        
Business Intelligence – BI Fundamentals – BI Videos - 4 of 21 (Video)  - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.                                        
Business Intelligence – BI Fundamentals – BI Videos - 5 of 21 (Video)  - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.                                        
Business Intelligence – BI Fundamentals – BI Videos - 6 of 21 (Video)  - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.                                        
Business Intelligence – BI Fundamentals – BI Videos - 7 of 21 (Video)  - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.                                        
Business Intelligence – BI Fundamentals – BI Videos - 8 of 21 (Video)  - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.                                        
Business Intelligence – BI Fundamentals – BI Videos - 9 of 21 (Video)  - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.                                        
Business Intelligence – BI Fundamentals – BI Videos - 10 of 21 (Video)  - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.                                        
Business Intelligence – BI Fundamentals – BI Videos - 11 of 21 (Video)  - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.                                        
Business Intelligence – BI Fundamentals – BI Videos - 12 of 21 (Video)  - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.                                        
Business Intelligence – BI Fundamentals – BI Videos - 13 of 21 (Video)  - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.                                        
Business Intelligence – BI Fundamentals – BI Videos - 14 of 21 (Video)  - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.                                        
Business Intelligence – BI Fundamentals – BI Videos - 15 of 21 (Video)  - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.                                        
Business Intelligence – BI Fundamentals – BI Videos - 16 of 21 (Video)  - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.                                        
Business Intelligence – BI Fundamentals – BI Videos - 17 of 21 (Video)  - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.                                        
Business Intelligence – BI Fundamentals – BI Videos - 18 of 21 (Video)  - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.                                        
Business Intelligence – BI Fundamentals – BI Videos - 19 of 21 (Video)  - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.                                        
Business Intelligence – BI Fundamentals – BI Videos - 20 of 21 (Video)  - 11/17/2007
This material contains a series of high and low resolution videos on the basics of Business Intelligence.                                        
Business Intelligence – BI Fundamentals – BI Videos - 21 of 21 (Video)  - 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://www.microsoft.com/express/sql/previous/default.aspx for more information about this product.
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.
SQL Server 2005 Express Absolute Beginner Video #8 – Connecting your Web Application  - 01/23/2007
SQL Server beginners will walk through the entire workflow of creating a database driven Web application and use visual tools to quickly create an administration application. Visit http://www.microsoft.com/express/sql/previous/default.aspx for more information about this product.
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.


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 - 2 of 2 (Slides)  - 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 - Security Measures Conceived Within Business Process Models - 2 of 2 (Slides)  - 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.
Business Intelligence – BI Fundamentals – Module 4 of 4 - 6 of 6 (Slides)  - 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 - 20 of 20 (Slides)  - 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 - 6 of 6 (Slides)  - 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 - 14 of 14 (Slides)  - 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
Хранилища данных. Анализ данных.  - 08/29/2009
В курсе изучаются технологии OLAP (OnLine Analytical Processing) для разработки многокритериальных иерархических хранилищ данных.                
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 - 2 of 2 (Slides)  - 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 - Security Measures Conceived Within Business Process Models - 2 of 2 (Slides)  - 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.
Business Intelligence – BI Fundamentals – Module 4 of 4 - 6 of 6 (Slides)  - 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 - 20 of 20 (Slides)  - 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 - 6 of 6 (Slides)  - 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 - 14 of 14 (Slides)  - 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  - 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 - 1 of 21 (Slides)  - 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://www.microsoft.com/express/sql/previous/default.aspx for more information about this product.
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.
SQL Server 2005 Express Absolute Beginner Video #8 – Connecting your Web Application  - 01/23/2007
SQL Server beginners will walk through the entire workflow of creating a database driven Web application and use visual tools to quickly create an administration application. Visit http://www.microsoft.com/express/sql/previous/default.aspx for more information about this product.
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.