MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Analysis Services Fundamentals

Course Summary

This course explains how to develop Analysis Services databases, beginning with the dimensional modeling process and continuing with the development of dimensions and cubes. It also covers the integration of business logic into the cube by adding calculat


  • +

    Course Syllabus

    ● Introduction to Analysis Services
        ◦ Introduction to Analysis Services
        ◦ Business Intelligence Queries
        ◦ Architecture Options
        ◦ Database Development
        ◦ Development, Management, and Client Tools
        ◦ Summary
    ● Dimensional Model Development
        ◦ Dimensional Model Development Overview
        ◦ Data Sources
        ◦ Top Down versus Bottom Up Design
        ◦ Schema Generation Wizard
        ◦ Data Source View
        ◦ Named Calculations
        ◦ Named Queries
        ◦ Summary
    ● Dimension Development I
        ◦ Dimension Development Overview
        ◦ Dimension Wizard
        ◦ Dimension Designer
        ◦ Attributes
        ◦ Unknown Member
        ◦ Basic Attribute Properties
        ◦ Summary
        ◦ Dimension Development 2
        ◦ Dimension Development 2 Overview
        ◦ Date Dimension Properties
        ◦ Best Practice Warnings
        ◦ User Hierarchies
        ◦ Parent-child Hierarchy
        ◦ Attribute Relationships
        ◦ Translations
        ◦ Dimension Development Tasks
        ◦ Summary
    ● Cube Development I
        ◦ Cube Development Overview
        ◦ Cube Wizard
        ◦ Cube Designer
        ◦ Measure Properties
        ◦ Aggregate Functions
        ◦ Role-Playing Dimension
        ◦ Additional Measures
        ◦ Dimension Usage
        ◦ Summary
        ◦ Cube Development 2
        ◦ Cube Development 2 Overview
        ◦ Aggregations
        ◦ Perspectives
        ◦ Translations
        ◦ Cube Development Tasks
        ◦ Summary
        ◦ Calculations 1
        ◦ Overview
        ◦ Calculation Designer
        ◦ Color and Font Expressions
        ◦ Summary
        ◦ Calculations 2
        ◦ Overview
        ◦ Calculated Members of a Dimension
        ◦ Named Sets
        ◦ Key Performance Indicators
        ◦ Summary
    ● Database Processing
        ◦ Overview
        ◦ BIDS Deployment
        ◦ Project Properties
        ◦ Deployment Wizard
        ◦ Storage Modes
        ◦ Effect of Updates
        ◦ Processing
        ◦ Process Options
        ◦ Summary
    ● Security
        ◦ Overview
        ◦ User Security
        ◦ Dimension Security
        ◦ Cell Security
        ◦ Administrator Security
        ◦ Service Account Configuration
        ◦ Summary

     


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top