1. MS Exam 70-467 Mindmap by Tony Nguyen- Quantum IT (Australia)
2. Plan BI Infrastructure (15%)
   1. Plan for performance
      1. ETL
      2. Proactive Cache
      3. Partition
      4. Query Optimised
         1. MDX
         2. DAX
   2. Plan for scalability.
      1. ROLAP
      2. HOLAP
      3. MOLAP
   3. Plan and manage upgrades.
   4. Maintain server health.
      1. automation strategy
3. Design BI Infrastructure (16%)
   1. Design a security strategy
      1. impersonation
      2. Dynamic Dimension Security
      3. Kerberos security
      4. security roles for calculated measures
      5. tradeoffs between regular SSAS security and dynamic security
   2. Design a SQL partitioning strategy
      1. proper partitioning strategy
      2. partition switching
      3. data compression
   3. Design a backup strategy
      1. High Availability
      2. Disaster Recovery
      3. proactively prevent issues
   4. Design a logging & auditing strategy
      1. SSIS logging
      2. Catalog views
4. Design SSRS Solution (24%)
   1. Design SSRS dataset.
      1. Data query parameters
      2. MDX queries
      3. security
      4. balancing query-based processing versus filter-based processing
      5. stored procedures
   2. Manage Excel Services/ reporting for SharePoint.
      1. data refresh schedules
      2. PowerPivot
   3. Design a data acquisition strategy.
      1. Identify the data sources
      2. CDC
      3. Data owner
      4. Data archiving, aging
   4. Plan & manage SSRS services configuration.
      1. Native mode
      2. Sharepoint Integration
   5. Design BI reporting solution architecture
      1. Linked reports
      2. drill-down reports
      3. migration strategies
      4. report services API
      5. sub reports
      6. code-behind strategies
      7. identify when to use Reporting Services, Report Builder, or Crescent (PowerView)
      8. interlinking all types of reports
      9. Excel Services vs Performance Point vs Reporting Services
      10. subscription strategy
5. Design BI Data Models (34%)
   1. Design the data warehouse
   2. Design a schema
   3. Design cube architecture.
   4. Design fact tables
   5. Design BI semantic models.
   6. Design and create MDX calculation
6. Design ETL Solution (11%)
   1. Design SSIS package execution
   2. Plan to deploy SSIS solutions
   3. Design package configurations for SSIS packages