|
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
Complete SQL Server 2005 Analysis Services video course for DW/BI analysts, software engineers, DBAs, database architects, systems analysts, and managers who design, develop, implement and manage OLAP applications. MDX, DMX, C#, VB, Java, C++, .NET and database developers who need to apply multi-dimensional analysis 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. Discover requirements gathering, data source analysis, management buyin, multi-dimensional modeling and data warehouse/business intelligence project life cycle. Explore data warehouse architecture and Analysis Services cube design. Visualize slicing and dicing OLAP cubes based on the Foodmart 2005 and AdventureWorksDW sample data warehouses. Discover the MOLAP, ROLAP and HOLAP storage models for Analysis Services cubes. Investigate Analysis Services cubes by using the MDX multi-dimensional query language. Get acquainted with the guidelines for a successful DW/BI projects. Explore the previous and new data mining algorithms. Discover cube browsing and data mining from Excel 2007. Student will learn the usage of Microsoft DW/BI tools: Management Studio, Business Intelligence Development Studio. Students will get overview of Integration Services (input tool for data warehouse/ OLAP cubes) and Reporting Services (output/interactive analysis tool for OLAP reporting). (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: 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.
|
