|
Advance 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 screencast 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 21 Hours of Instruction 
The instructor is Kalman
Toth MCDBA, MCITP, 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 Designer 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 screencast and rich
audio make the subject matter understandable, and reusable
as reference material.
Audience
Complete SQL Server 2008 Analysis Services video course for DW/BI architects, administrators and developers; 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 OLAP and data mining data sources in enterprise environment.
Prerequisites
Data Warehouse/Business Intelligence architecture students must have a solid working
knowledge of the Windows environment. SQL Server 2008 and
programming experience in at least one computer language
are helpful. This is the very best and most intensive Data Warehouse and Business Intelligence
multimedia screencast 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 hierarchies, 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 AdventureWorksDW2008 sample data warehouse. 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 data mining model 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 a brief 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,
MCITP, is an IT professional with over 17 years of database administration
and development experience with SQL server 4.2, 6.5, 7.0,
2000 2005, and 2008. 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 screencast 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: Microsoft SQL Server 2008 Analysis Services Unleashed
Microsoft SQL Server 2008 Analysis Services Unleashed (888 pages) is the ultimate guide for anyone who is planning to use the latest version of Analysis Services. It gives readers insight into the way Analysis Services functions, and explains practical methods for designing and creating multidimensional objects. It also provides valuable insight into the reasons behind the design decisions taken by the product development team. The authors have been involved with Analysis Services from its earliest days at Microsoft. They have documented in detail the internal features of Analysis Services 2008, explaining server architecture, main data structures, data processing, and query resolution algorithms. Discover the new functionality introduced in Analysis Services 2008 including MDX enhancements and new DMV (dynamic memory views) Work with the Business Intelligence Development Studio, the new Dimension Editor, and Aggregation Designer interfaces. Enjoy complete coverage of new Shared Scalable Databases scale-out infrastructure Learn the key concepts of multidimensional modeling. Explore the multidimensional object model and its definition language Integrate multidimensional and relational databases. Build client applications to access data in Analysis Services. Unravel the inner workings of the server architecture, including main data structures, data processing, and query resolution algorithms. Learn the main concepts of the MDX language and gain an in-depth understanding of advanced MDX concepts. Gain a deeper understanding of the internal and external protocols for data transfer, including the XML/A protocol. Discover how Analysis Services manages memory. Explore the security model, including role-based security, code-access security, and data security.
|
