Scribd Logo
Upload

Welcome to Scribd!

  • 114 views

    20466C 00

    Uploaded by

    douglas
    123

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd

    20466C 00

    Uploaded by

    douglas
    114 views13 pages
    123

    Original Title

    20466C_00

    Copyright

    © © All Rights Reserved

    Available Formats

    PPTX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    123

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    114 views13 pages

    20466C 00

    Uploaded by

    douglas
    123

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    You are on page 1of 13

    Microsoft Official Course

    20466C
    Implementing Data Models and
    Reports with Microsoft® SQL
    Server®
    Welcome!
    Thank you for joining us today.
    We’ve worked together with today’s experience. We value your
    Microsoft Learning Partners and feedback!
    Microsoft IT Academies to bring you
    Certification Benefits. After training,
    a world-class learning experience,
    consider pursuing a Microsoft
    including:
    Certification, to help distinguish your
    Microsoft Certified Trainers + technical expertise and experience.
    Instructors. Your instructor is a Ask your instructor about available
    premier technical and instructional exam promotions and discounts.
    expert who meets ongoing
    We wish you a great learning
    certification requirements.
    experience and ongoing career
    Customer Satisfaction Guarantee. success!
    Our Partners offer a satisfaction
    guarantee and we hold them
    accountable for it. At the end of class,
    please complete an evaluation of
    Hello

    • Instructor: <Instructor Name>


    • <Title or other credentials, e.g. Microsoft
    Certified Trainer>
    • <Affiliation/Company>
    • <A few words about my technical and
    professional experience>
    Student Introductions

    • Name
    • Company affiliation
    • Title/function
    • Job responsibility
    • Office 365 experience
    • Exchange, SharePoint and Lync experience
    • Active Directory experience
    • Your expectations for the course
    Facilities

    • Class hours
    • Building hours
    • Parking
    • Restrooms
    • Meals
    • Phones
    • Messages
    • Smoking
    • Recycling
    About This Course

    • Audience
    • Course Prerequisites
    • Course Objectives
    • What You Can Expect
    Your Course Materials
    Designed to optimize your classroom learning experience.
    And support you back on the job.

    Microsoft Official Course Handbook


    • Organized by Modules
    • Includes Labs + Lab Answer Keys
    • Module Reviews + Takeaways—
    great for on-the-job reference
    Course Outline
    • Module 1, “Introduction to Business Intelligence and Data Modeling”
    • Module 2, “Creating Multidimensional Databases”
    • Module 3, “Working with Cubes and Dimensions”
    • Module 4, “Working with Measures and Measure Groups”
    • Module 5, “Introduction to MDX”
    • Module 6, “Enhancing a Cube”
    • Module 7, “Implementing an Analysis Services Tabular Data Model”
    • Module 8, “Introduction to DAX”
    • Module 9, “Implementing Reports with SQL Server Reporting
    Services”
    • Module 10, “Enhancing Reports with SQL Server Reporting Services”
    • Module 11, “Managing Report Execution and Delivery”
    • Module 12, “Delivering BI with SharePoint PerformancePoint
    Services”
    • Module 13, “Performing Predictive Analysis with Data Mining”
    Related Courses

    • 20461: Querying Microsoft SQL Server


    • 20462: Administering Microsoft SQL Server Databases
    • 20463: Implementing a Data Warehouse with Microsoft
    SQL Server
    • 20464: Developing Microsoft SQL Server Databases
    • 20465: Designing a Data Solution with Microsoft SQL
    Server
    • 20466: Implementing Data Models and Reports with
    Microsoft SQL Server
    • 20467: Designing Self-Service Business Intelligence and
    Big Data Solutions

    See the full line of Microsoft Training and Certification resources at:
    http://www.microsoft.com/learning/
    Microsoft Certification Program

    Get trained. Get certified.


    Get ahead.
    Microsoft Certifications demonstrate you
    have the skills to design, deploy, and
    optimize the latest technology solutions.

    Ask your Microsoft Learning Partner how you


    can prepare for certification.

    Also see:
    http://www.microsoft.com/learning/
    certification
    Preparing for the Labs

    Your lab activities will be centered around Adventure Works


    Cycles, a fictitious manufacturer and seller of cycles and related
    products.

    To complete the labs, you will work in a virtual


    machine (VM) environment.

    11
    Virtual Machine Environment

    Virtual Machine Name: Use as:

    20466C-MIA-DC Domain controller

    20466C-MIA-SQL Database and BI server

    ADVENTUREWORKS.MSFT

    MIA-DC

    MIA-SQL
    Demonstration: Using Hyper-V Manager
    In this demonstration, you will learn how to:
    • Open Hyper-V Manager
    • Navigate the various sections/panes within Hyper-V Manager
    • Virtual Machines, Snapshots, and Actions: Server-specific and VM-
    specific
    • Identify the VMs used in the labs for this course
    • Take a Snapshot and Apply a Snapshot
    • Connect to a VM
    • Start and log on to a VM
    • Switch between full screen and window modes
    • Revert to the previous Snapshot
    • Shut down a VM
    • When to use Shut Down or Turn off
    • Close Hyper-V Manager

    You might also like