2074: Designing and Implementing OLAP Solutions with Microsoft SQL Server 2000

2074: Designing and Implementing OLAP Solutions with Microsoft SQL Server 2000 Course Description

Intended Audience for the 2074: Designing and Implementing OLAP Solutions with Microsoft SQL Server 2000 Course

• Student should have a basic understanding of database design, administration, and implementation concepts.
• A satisfactory level of comfort within the Microsoft Windows 2000 environment.
• Before attending this course, students must have a basic understanding of database design, administration, and implementation concepts and a satisfactory level of comfort within the Microsoft Windows 2000 environment.

2074: Designing and Implementing OLAP Solutions with Microsoft SQL Server 2000 Course Objectives

• Define the term OLAP and its role within data warehousing.
• Design multidimensional data marts by using star and snowflake schemas.
• Recognize the fundamental components of a cube.
• Understand the architecture of Analysis Services.
• Create dimensions from relational dimension tables.
• Understand the many types of dimensions.
• Utilize various dimension properties and settings.
• Design OLAP dimensions based on underlying source data.
• Create cubes by using the Cube Wizard and Cube Editor.
• Create and manipulate measures.
• Develop and understand virtual cubes.
• Design cube storage and aggregations.
• Update dimensions and cubes when source data changes.
• Optimize the processing of dimensions and cubes.
• Create partitions within cubes.
• Implement simple calculations by using multidimensional expressions (MDX) and calculated members.
• Use Microsoft Excel 2000 as an OLAP front-end application.
• Understand how data mining fits within OLAP and the Microsoft data warehousing framework.
• Employ actions, drill-through, and writeback for data analysis.
• Design and implement cube and dimension security.
• Automate the processing of dimensions and cubes through Data Transformation Services (DTS).
• Create cubes and virtual cubes based on end-user requirements.

2074: Designing and Implementing OLAP Solutions with Microsoft SQL Server 2000 Course Outline

1. Introduction to Data Warehousing and OLAP
   1. Introducing Data Warehousing
   2. Defining OLAP Solutions
   3. Understanding Data Warehouse Design
   4. Understanding OLAP Models
   5. Applying OLAP Cubes
2. Introducing Analysis Manager Wizards
   1. Defining Terms
   2. Previewing Analysis Manager
   3. Preparing to Create a Cube
   4. Building the Sales Cube
   5. Processing the Cube
   6. Viewing the Results
3. Understanding Analysis Services Architecture
   1. Overview
   2. Microsoft Data Warehousing Overview
   3. Analysis Services Components
   4. Metadata Repository
   5. Cube Storage Options
   6. Client Architecture
   7. Office 2000 OLAP Components
4. Building Dimensions Using the Dimension Editor
   1. Understanding Dimension Basics
   2. Shared vs. Private Dimensions
   3. Working with Standard Dimensions
   4. Basic Level Properties
   5. Working with Parent-Child Dimensions
5. Using Advanced Dimension Settings
   1. Working with Levels and Hierarchies
   2. Working with Time Dimensions
   3. Creating Custom Rollups
   4. Introducing Member Properties
   5. Understanding Virtual Dimensions
6. Working with Cubes and Measures
   1. Introduction to Cubes
   2. Working with Cubes
   3. Introduction to Measures
   4. Working with Measures
   5. Defining Cube Properties
   6. Using the Disabled Property
7. Case Study - Creating the Store Expense Cube
   1. Building the Store Expense Cube
   2. Updating the Store Expense Cube
8. Managing Storage and Optimization
   1. Analysis Server Cube Storage
   2. The Storage Design Wizard
   3. Analysis Server Aggregations
   4. Usage-Based Optimization
   5. Optimization Tuning
9. Processing Dimensions and Cubes
   1. Introducing Dimension and Cube Processing
   2. Processing Dimensions
   3. Processing Cubes
   4. Optimizing Cube Processing
   5. Troubleshooting Cube Processing
10. Managing Partitions
    1. Introducing Partitions
    2. Creating Partitions
    3. Using Advanced Settings
    4. Merging Partitions
11. Implementing Calculations Using MDX
    1. Understanding Calculated Members
    2. Building Calculated Members
    3. Creating Non-Measure Calculated Members
    4. Using Functions Within Calculated Members
    5. Understanding Other Calculation Methods
    6. Introducing Solve Order
12. Working with Virtual Cubes
    1. Understanding Virtual Cubes
    2. Obtaining Logical Results
    3. Building a Virtual Cube
    4. Creating Calculated Members
13. Using Excel as an OLAP Client
    1. Office 2000 OLAP Components
    2. Using Excel PivotTables
    3. Using PivotCharts
    4. Working with Local Cubes
    5. Creating OLAP-Enabled Web Pages
14. Using Actions, Drillthrough, and Writeback
    1. Creating Actions
    2. Performing Drillthrough
    3. Understanding Writeback
15. Implementing Security
    1. Introducing Analysis Services Security
    2. Understanding Administrator Security
    3. Helping Protect User Authentication
    4. Understanding Database Roles
    5. Implementing Dimension Security
    6. Managing Cube Roles
16. Deploying an OLAP Solution
    1. Introducing DTS
    2. Executing and Scheduling Packages
    3. The Analysis Services Processing Task
    4. Copying and Archiving OLAP Databases
17. Introduction to Data Mining
    1. Introducing Data Mining
    2. Training a Data Mining Model
    3. Building a Data Mining Model with OLAP Data
    4. Browsing the Dependency Network
18. Case Study - Working with the Foodmart Database
    1. Building the Warehouse Cube
    2. Building the Sales Cube
    3. Building the Warehouse and Sales Virtual Cube

Benefits of taking the 2074: Designing and Implementing OLAP Solutions with Microsoft SQL Server 2000 course at NetCom

• Why choose Microsoft - Technical Training at NetCom Learning?
  As a recognition for training excellence, NetCom Learning was chosen by Microsoft as the 2007 Worldwide Learning Solutions Partner of the year out of 1400 training companies.

  In addition, we have won numerous other training awards for quality and customer satisfaction by CompTIA, EC-Council and other vendors. We are simply passionate about learning and achieving the highest customer satisfaction in your learning experience!

  See the training value proposition below:

  Why Microsoft - Technical Training at NetCom? NetCom Learning is a Microsoft Gold Certified Partner for Learning Solutions (CPLS). CPLS is the premier training channel and delivery mechanism for Microsoft training content. NetCom was honored by Microsoft as the 2007 Worldwide Partner of the Year for Learning Solutions. Selected as the Number One CPLS from over 1400 worldwide CPLSs, Microsoft recognized our commitment and ability to deliver high-quality learning services using a consultative engagement model. Microsoft Certified Partner for Learning Solutions Value Proposition: Microsoft Certified Partner for Learning Solutions Non-authorized Training Center Only MCT (Microsoft Certified Trainers) are authorized to teach the class Non MCT can teach the course Taught using Microsoft Authorized Courseware (MOC), includes free evaluation software and online training Do not have access to official courseware Partners adhere to stringent Microsoft designated lab requirements Computer and lab equipment may not be up to requirements of course Successful candidates are awarded Certificate of Completion directly from Microsoft for most of the courses Not authorized to issue Certificate of Completion Software Assurance Vouchers can only be redeemed at a CPLS Cannot redeem Software Assurance Vouchers from Microsoft Overall, a better quality training experience Substandard training experience Here are some important web links: Certifications Career Tracks Course Catalog (PDF Version) Course Listing by Vendor Sign up for Free Workshops Student Loan as low as $25 per month Our Recognition List What our students have to say Why NetCom? Locations

• NetCom provides Authorized Training
  NetCom Learning is a Microsoft Gold Certified Partner for Learning Solutions (CPLS), Cisco Learning Partner, CompTIA Platinum Partner, EC-Council Accredited Training Center, Adobe Authorized Training Center, Autodesk Authorized Training Center and many others. We are proud to offer the highest quality, authorized training solutions from our many partners for our customers.

  See our comprehensive list of partner authorizations.

• Award winning, world-class Instructors

  Carmille A. - Highly-skilled in graphics and web software including Adobe CS3, CS4 & CS5 Photoshop, Dreamweaver, Illustrator, InDesign, Captivate, Acrobat and Quark; - Expert in Microsoft Office, including Excel, Word and PowerPoint. Licensed Application Instructor and Microsoft Certified Trainer since 2000. - Over 20 years of experience as Creative Director for multinational corporations such as McCann Erickson, Lintas, and Publicis. Bio: Carmille has been a Licensed Application Instructor and Microsoft Certified Trainer for years. She specializes in web development, business productivity and digital media applications such as SharePoint, Quark and the Adobe Creative Suite as well as numerous programming languages including XML, XHMTL, HTML and CSS. Carmille is passionate about educating and has a unique talent for making complex design and development principals seem "easy" to students from all levels of expertise. She currently teaches Adobe Graphic and Web Designer, Microsoft Office Specialist, SharePoint End User and the acclaimed Website Development Professional courses at NetCom Learning. Her 20+ years of experience as Creative Director for multinational corporations bring a special and innovative approach to her classes at NetCom Learning.

  Emilio G. - Vastly experienced working within multinational environments and capable of connecting to different audiences - In-depth expertise in the implementation, troubleshooting and documentation of networks and security systems, with strong "hands on" technical knowledge of CISSP, CEH and CHFI. - Master of Science in Electronics Engineering, and holder of several technical certifications. - Highly-skilled in diverse fields ranging from Security, Computer Forensics, Networking, Routing Protocols, Programming, Databases and Applications to name a few. Bio: With over 25 years of technical experience, Emilio brings a dynamic set of skills supported by a Masters Degree in Electronics Engineering and on-the-field experience working in multinational environments. He also holds more than 12 Cisco, CompTIA, and Microsoft certifications. Although he is well versed and thorough in multiple technological fields, his technical forte lies in the security domain, specifically CISSP, CEH and CHFI. Emilio�s skills have evolved over time, studying closely and constantly staying well informed of the growing cyber threats. These are just some of the few reasons why Emilio brings to his classes more than just what's in the books.

  Enayat M. - Bachelors Degree in Mathematics and holder of several Cisco, CompTIA and Microsoft certifications. - Experienced instructor working in the field since 1999 and Subject Matter Expert at NetCom Learning since 2006. - Worked as Technical Support at Solomon Smith Barney/Citibank. Bio: Enayat Meer has a Bachelors Degree in Mathematics and holds numerous certifications such as A+, Network+, Security+, CCNA, MCT, and MCTS to name a few. He is an experienced trainer, and has served as an A+, NT4.0, Window 2000 and Windows 2003 instructor in a variety of New York schools since 1999. Since that time, he has also provided technical support at Solomon Smith Barney/Citibank in its private banking and global assets management group. Enayat has trained over 800 students at NetCom Learning. He has been a Subject Matter Expert at NetCom Learning since 2006 and his hands-on project expertise is an invaluable addition to NetCom Learning�s classroom instruction, helping to bring theoretical topics to life.

  Erick P. - In-depth experience in all phases of project lifecycle: requirements gathering, specifications, development and team management, testing, end user training, and maintenance in addition to .NET, ASP, ADO, SQL, JavaScript, and SharePoint. - Developed the first online multimedia training content system to Harvard University as well as multiple online multimedia projects for the North Carolina State Government. - Highly rated instructor averaging 8.7 out of 9 on evaluation reports. Bio: Erick has been training business and IT professionals since 1989, when he developed and introduced the first online multimedia training content system to Harvard University. Since then he has honed his business, programming, and database skills providing highly customized software solutions and education programs for multiple clients such as North Carolina State Government, Cisco, IBM, and Time Warner Cable. Erick's teaching prowess and real-world experience leading a team of software application developers make him a top Instructor and Subject Matter Expert at NetCom Learning, where he averages 8.7 out of 9 on evaluation reports.

  Ignacio J. - Designs and architects Microsoft IT solutions since the early 1990s. - Hands-on experience in multiple Microsoft Dynamics products including CRM, GP, SL, AX and NAV since 2004. - Taught over 250 courses at NetCom Learning. Bio: Ignacio is a Senior Solutions Architect, Civil Engineer and Certified Expert Trainer. He has been designing and architecting Microsoft IT solutions since the early 1990s, and has extensive experience developing scalable and high performance integration solutions. In 2004, Ignacio expanded into business management and accounting software as well, where he gained hands-on experience in many Microsoft Dynamics products including CRM, GP, SL, AX and NAV. Ignacio holds a library of industry-wide certifications from Microsoft and other leading IT vendors. He has taught over 250 courses at NetCom Learning and is revered by students for his wide-ranging IT expertise.

  J Tom K. - Software Developer and sought-after Microsoft Certified Trainer (MCT) with over 30 years of hands-on experience. - Expert in Microsoft technologies: .NET Framework, C#, VB .NET, ASP .NET, XML Web Services, ADO .NET, SQL Server, SharePoint Portal Server, Content Management Server, Commerce Server, BizTalk, MSMQ, COM+, COM Migration to .NET and PocketPC development. - Extremely knowledgeable and rated as excellent by NetCom Learning students. Bio: Tom Kinser is an accomplished Software Developer and sought-after Microsoft Certified Trainer (MCT). Tom is also an expert in successfully designing software, managing and training programmers for over 30 years. Tom specializes in helping businesses, enterprises, and government agencies apply current technologies to solve their unique business problems. He accomplishes this via hands-on training in cutting-edge programming and database design techniques. Tom consistently delivers successful training engagements in both classroom and live-online settings and is rated as excellent by NetCom Learning students.

  Jayson F. - Over 32 years of experience as well as 18 certifications, including Cisco, CompTIA, and Microsoft. - Strong background, with web development & design of infrastructure for companies such as AT&T, Sports Illustrated, and Toys R Us. - Specialist in applying process and finding solutions to solve them in addition to training people in the skills to manage the process and meet goals. Bio: Jayson is a talented and valued Microsoft Certified Trainer (MCT) with over 32 years of IT experience. Along with web development & design of infrastructure for companies such as AT&T, Sports Illustrated, and Toys R Us, he holds several IT certifications. He is a CCDA, CCNA, Security+ certified, MCDBA, and MCSE to name a few. Jayson's focus is on finding solutions to problems and applying process to solve them. He instructs professionals in the skills to manage the process and meet goals, which makes him a respected trainer at NetCom Learning.

  Mark L. - Experience teaching beginner to advanced software engineering and development classes - Architectured NetCom Learning's Mobile Development Professional training package (Android & iPhone) - Acclaimed instructor at NetCom Learning, with evaluation score of 8.7 out of 9. Bio: Mark is an accomplished web and mobile development trainer and Subject Matter Expert. He has been teaching beginner to advanced software engineering and development classes since 2005. With an extensive background in corporate programming he easily understands the impact of new technologies and the knowledge developers need to succeed. Most recently Mark architectured NetCom Learning's Mobile Development Professional training package (Android & iPhone) to much critical acclaim. Mark's passion and aptitude for the subject matter is abundant, and clearly evident in his near-perfect post-class evaluation scores (8.7 out of 9) and praise from clients.

  Michael G. - Over 22 years of professional experience in the IT field, including more than a decade as a Certified Trainer. - An expert in Cisco's Routing, Switching, Security, Voice and Wireless areas, as well as select Microsoft, Novell, CompTIA, Sun and CWNP courses. - High-skilled and acclaimed instructor. Has trained over 900 students at Netcom Learning. Bio: Michael has over 22 years of professional experience in the IT field, including more than a decade as a Certified Trainer. An expert in Cisco's Routing, Switching, Security, Voice and Wireless areas, Michael also teaches select Microsoft, Novell, CompTIA, Sun and CWNP courses. Michael's dedication and passion for teaching is unmatched. He has trained over 900 students at Netcom Learning since 2006 and his evaluation scores average 8.7 out of 9.

  Mingya (Alan) T. - MBA in Information System from Montclair University, NJ. - Onsite training on behalf of Microsoft to numerous companies, including CITI Group Lehman Brothers, Prudential Insurance Company, Toshiba, and KPMG. - Microsoft Certified Trainer (MCT) since 2001. Bio: Alan is a highly experienced Microsoft Certified Trainer. In addition to his MBA in Information System, he is a member of the Microsoft Gold Certified Partner and has done onsite training for companies such as CITI Group Lehman Brothers, Prudential Insurance Company, Toshiba, and KPMG; on behalf of Microsoft. Alan has been teaching at NetCom Learning since 2007, focusing on SharePoint, .NET, and BizTalk.

  See more...  
• Actual Client Testimonials

  May 15 2012 Good training, great instructor. -Kenneth C. Course(s) Taken MCTS and MCITP: Microsoft SharePoint 2010, Administration and Configuration - Boot Camp

  
  

  May 15 2012 The experience was everything I had hoped for plus more. Our instructor was very knowledgeable and great at presenting the content in a way that was easy to understand. -Zehrudin N. Course(s) Taken MCTS and MCITP: Microsoft SharePoint 2010, Administration and Configuration - Boot Camp

  
  

  May 15 2012 Instructor is very good at explaining things that are difficult to comprehend sometimes and he does it in a way that helps you better understand. -Juan G. Course(s) Taken MCTS and MCITP: Microsoft SharePoint 2010, Administration and Configuration - Boot Camp

  
  

  May 15 2012 Instructor knowledge of the product was in depth. Excellent training and real world example. Explained the course in easy manner to understand. -David T. Course(s) Taken MCTS and MCITP: Microsoft SharePoint 2010, Administration and Configuration - Boot Camp

  
  

  May 15 2012 I have enjoyed my training class and training facilities. I will come back. -James M. Course(s) Taken MCTS and MCITP: Microsoft SharePoint 2010, Administration and Configuration - Boot Camp

  
  

  May 11 2012 Been to NetCom several times and it's always been satisfying with the training area and staff. -Sal I. Course(s) Taken Microsoft Windows Server 2008

  
  

  May 02 2012 I have never learned and retained this much information in such a short period of time, everything about my experience has been positive. -Adam W. Course(s) Taken MCTS and MCITP: Windows 7 Configuration and Desktop Support Technician - Boot Camp

  
  

  Apr 20 2012 Overall great experience. Was very pleased with the way the course was handled by the instructor. -A. Moctezuma Course(s) Taken Programming in C# with Microsoft .NET Framework 4

  
  
• Awards won by NetCom
  NetCom Learning is an award winning, customer focused company. We are simply Passionate About Learning!

  See our list of awards.

• Specialized Boot Camp Training

  

  This training is also available as a boot camp. NetCom is world famous for delivering specialized boot camp training to our clients.

  For answers to questions regarding our boot camp training delivery format, please refer to our Boot Camp FAQ section.

Enrollment Options for the 2074: Designing and Implementing OLAP Solutions with Microsoft SQL Server 2000 course

• Contact us to customize this class with your own dates, times and location. You can also call 1-888-563-8266 or chat live with an Educational Consultant.

Training Delivery Methods

• Classroom Training
  NetCom’s classroom training ensures that you have state-of-the-art tools, techniques and practices you need to succeed on the job. Our instructors are active practitioners and true masters in their fields. With convenient classes at multiple learning centers across the US, you never have to go far to get ahead.

• Live Online Training (LOT)
  NetCom’s premium Live Online Training (we call it LOT) is the ultimate in convenience and cost-effectiveness. LOT combines interactive video instruction via the latest web conference technology, and post-class access to learning labs for a best-in-class learning experience.
  Learn more about LOT

• Boot Camp Training
  NetCom’s intensive boot camps are designed to advance your skills in the shortest possible amount of time and get you certified. Boot camps go at a faster pace and often run for longer days, so you must have some level of subject matter experience before enrolling. Boot camps have mandatory assessment tests to ensure no one will slow down the class for other students. Learn more about Boot Camps

• Private Onsite Training
  With NetCom’s private training programs, you decide where and when courses are held. Tailor the training to reflect your industry, corporate culture, goals and schedule. You pick the course content, length of training and instructional technique. Save money by doing bulk customized training.
  Learn more about Private Onsite Training

• Private 1-on-1 Training
  NetCom’s private 1-on-1 training focuses on the highest quality training possible. You get individualized, full attention from the instructor and you decide where and when courses are held. The training is custom tailored to reflect your industry, corporate culture, goals and schedule. You pick the course content, length of training and instructional technique.
  Learn more about Private 1-on-1 Training

Call us Toll-free at 1-888-563-8266 FREE Training Inquiry form Website Live Chat Contact us via Email: info@netcomlearning.com