|
Invest
in Your Career
Learn Business Intelligence from a top industry expert.
Multi-Dimensional Microsoft Business Intelligence is now
available on full-motion CD-ROMs with narration. Learn the
fun way! Multimedia training is far more effective than
textbooks. It simulates the real-world environment for excellent
retention. You can replay the video and audio instructional
units as many times as you need to.
Learn Business Intelligence with this easy-to-follow CD-ROM
collection from Silico-Magnetic Intelligence. Whether you
are learning Data Warehousing/Business Intelligence for
the first time or adding to your professional skills set,
you will find that SMI’s Business Intelligence Training
via CD-ROM™ contains thorough, outstanding, well-prepared
content that is second to none.
7 CD-ROMs with Over 18 Hours of Instruction 
The instructor is Kalman
Toth, video MCDBA, Senior SQL Server Database, Data Warehouse
and Business Intelligence Architect. By mastering one CD-ROM
a day, you can become a Microsoft Data Warehouse/Business
Intelligence Analyst in just 7 days. You can also proceed
at your own pace. The thorough CD-ROM course is focused
on practical solutions to real-world Data Warehouse/Business
Intelligence design, building, population, deployment, delivery
and maintenance problems. Full-motion screen video and rich
audio make the subject matter understandable, and reusable
as reference material.
Audience
DW/BI analysts, software engineers, DBAs, database architects,
systems analysts, IT managers and project managers who design,
develop, implement and manage Microsoft SQL Server 2005
Analysis Services based applications. Network and Database
Administrator candidates, VB, Java, C++, ASP.NET and database
developers who need to know more about applying multi-dimensional
OLAP cubes and data mining in business environment.
Prerequisites
Data Warehouse architecture students must have a solid working
knowledge of the Windows environment. SQL Server 2005 and
programming experience in at least one computer language
are helpful. This is best Data Warehouse and Business Intelligence
multimedia training currently available in North America,
or anywhere in the World.
Objectives
The CD-ROM based course will teach students to define requirements
for Data Warehouse/Business Intelligence, identify facts,
measures and dimensions, define the ETL processes, design
fact and dimension tables, populate fact and dimension tables,
install and configure analysis services, create dimensions,
create multi-dimensional OLAP cubes, maintain and optimize
cubes. Student will learn the usage of Microsoft DW/BI tools:
Management Studio, Business Intelligence Development Studio.
Students will get overview of Integration Services and Reporting
Services(See full list below).
About the Trainer
Kalman
Toth, MCDBA,
is an IT professional with over 16 years of database administration
and development experience with SQL server 4.2, 6.5, 7.0,
2000 and 2005. Kalman Toth was a developer on IBM's marketing
Data Warehouse project operated by Dun & Bradstreet.
He has designed OLAP data warehouse/business intelligence
solutions for major online dating, diet and fitness websites.
His clients include: Citibank, Bank of Sweden, Deloitte-Touche,
Swiss Bank, Lehman Brothers, Salomon Brothers, Merrill Lynch,
and IBM. He holds M.Phil degree in Physics and M.Phil. degree
in Computing Science from Columbia University, where he
had taught computer science.
CD-ROM Features
SMI's CD-based training is like training one-on-one with
an expert -- full motion video allows you to see the steps,
hear the explanations, and perform the critical tasks. This
is the complete training solution for passing a certification
exam, excelling on an interview and performing well in the
workplace. It is convenient, giving you the freedom to learn
at your own pace, wherever and whenever it suits your schedule.
CD-ROM is easy to use, with streamlined interface featuring
one-click navigation. 100% guaranteed.
Bonus Book 1: Practical Business Intelligence with SQL
Server 2005
In this book(432 pages), two of Microsoft’s leading
consultants illustrate how to use SQL Server 2005 Business
Intelligence (BI) technologies to solve real-world problems
in markets ranging from retail and finance to healthcare.
Drawing on extensive personal experience with Microsoft’s
strategic customers, John C. Hancock and Roger Toren offer
unprecedented insight into BI systems design and step-by-step
best practices for implementation, deployment, and management.
Each chapter-length case study begins with the customer’s
business goals, and then guides you through detailed data
modeling. The case studies show how to avoid the pitfalls
that derail many BI projects. You’ll translate each
model into a working system and learn how to deploy it into
production, maintenance, and efficient operation. Whether
you’re a decision-maker, architect, developer, or DBA,
this book brings together all the knowledge you’ll
need to derive maximum business value from any BI project.
Leverage SQL Server 2005 databases, Integration Services,
Analysis Services, and Reporting Services; Build data warehouses
and extend them to support very large databases; Design
effective AS databases;Ensure the superior data quality
your BI system needs; Construct advanced enterprise scorecard
applications;Use data mining to segment customers, cross-sell,
and increase the value of each transaction;Design real-time
BI applications;Get hands-on practice with SQL Server 2005’s
BI toolset.
Bonus Book 2: Microsoft® SQL Server™ 2005 Analysis Services
Step by Step 
Your hands-on, step-by-step guide (400 pages) to building
business intelligence solutions for the enterprise. Teach
yourself the fundamentals of SQL Server Analysis Services—one
step at a time. With this practical, learn-by-doing tutorial,
you get the guidance you need to build flexible and powerful
solutions that meet the analytical needs of your organization.
Discover how to: Start building cubes using the Microsoft
Visual Studio 2005 Business Intelligence designers; Create
dimensions and measure groups to build, browse, and modify
OLAP cubes; Design objects to handle unique financial analysis
requirements; Improve query performance with aggregations
and user hierarchies; Customize cubes with multi-dimensional
expressions (MDX) and other advanced design techniques;
Use actions to integrate Web pages, reporting applications,
and drillthrough capabilities with cubes; Manage role-based
security and restrict data access; Deploy and maintain a
database in a production environment. CD features: All practice
exercises and answer files; Fully searchable eBook.
Bonus Book 3: MCTS Self-Paced Training Kit (Exam 70-445): Microsoft® SQL Server™ 2005 Business Intelligence—Implementation and Maintenance 
Ace your preparation for the skills measured by MCTS Exam 70-445—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce what you’ve learned by applying your knowledge to real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time. Maximize your performance on the exam by learning to:
• Install, configure, and manage SQL Server business intelligence components and tools
•Implement SQL Server Analysis Services cubes, create KPIs, work with MDX
•Build data mining models and configure algorithms
•Administer SQL Server Reporting Services and deploy information-rich solutions
•Develop and troubleshoot SQL Server Integration Services packages
•Implement package roles, protection levels, and passwords
|
