Study material for exam 70-467 Designing Business Intelligence Solutions with Microsoft SQL Server
By: Daniel Calbimonte | Comments (1) | Related: More > Professional Development Certifications
Problem
I want to pass the Designing Business Intelligence Solutions with Microsoft SQL Server exam 70-467. I failed twice and I do not want to fail again. Can you help me to pass the exam?
Solution
Yes, in this new tip, we will talk about books and material to pass this exam.
Which exam should I take before this one?
The Microsoft 70-463 Exam, Implementing a Data Warehouse with Microsoft SQL Server 2012/2014.
Is this exam difficult?
It is subjective, but in our opinion it is the most difficult exam. It is hard to find information to study and it is a complex exam that requires a lot of effort to study and pass.
What is the score to pass?
700/1000
Which books do you recommend for this exam?
Unfortunately, there is no Microsoft Training Kit book for this exam. However, here are some books that might be useful:
- Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX is a great book to study MDX and DAX.
- Professional Microsoft SQL Server 2014 Integration Services (Wrox Programmer to Programmer) is a great and complete book about SQL Server Integration Services (SSIS).
- Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer is another Excellent book about SSIS.
- Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model (Developer Reference) is my favorite book about Tabular. Any article or book with Marco Russo and/or Alberto Ferrari is a good book about SSAS.
- Professional Microsoft SQL Server 2012 Reporting Services 1st Edition.
- Visualizing Data with Microsoft Power View will exceed the requirements to pass the exam in the Power View topics.
- Microsoft SharePoint 2013 Step by Step will help you to start with SharePoint and in the chapter 13, you will find useful information about SharePoint with Business Intelligence including Power View.
- Expert Cube Development with Microsoft SQL Server 2008 Analysis Services.
- The Data Warehouse Toolkit, 3rd Edition.
What courses should I take for this exam?
The following courses will help you to pass the exam:
- Microsoft Virtual Academy: Designing Business Intelligence Solutions
- SSIS Design Patterns for Data Warehousing
- Advanced Integration Services
- Integration Services Fundamentals
- Organizational BI with SSAS 2012 Tabular - Intermediate
- Analysis Services Fundamentals
- Advanced Analysis Services
- Reporting Services Advanced Topics
- SSIS Online Training Course Contents
- COMP 4680 - Business Intelligence with SSIS, SQL Server Integration Services
- Microsoft SQL Server Integration Services (SSIS) Training
- Advanced SQL Server 2008/2008 R2 Analysis Services (SSAS) & Performance
- SSAS Cube Design (Course)
- Designing BI Report Solutions with SQL Server 2012 Reporting Services and SharePoint 2010
- Advanced MDX – Performance, Optimization, and the MDX Script
- Accelerated SQL Server 2012 Integration Services
- Ways of Improving MDX Performance and Improvements with MDX in Katmai (SQL 2008)
- Optimizing DAX expressions involving multiple measures
- SQL Server 2012 Analysis Services Partitioning Performance Demonstration
- Indexing the Data Warehouse
- SQL Server Analysis Services Aggregation Designs
- SSAS - Best Practices and Performance Optimization - Part 1 of 4
- Improve SQL Server Analysis Services Performance with the Usage Based Optimization Wizard
Which simulation exams do you recommend?
- Microsoft Practice Exam for 70-467 MSCert: Designing Business Intelligence Solutions with Microsoft SQL Server
- Actual test 70-467 exam
- Microsoft 70-467 Questions & Answers
What links do you recommend to study?
Here you have some links to help you pass the exam:
Plan business intelligence (BI) infrastructure
- Plan for performance
- SSIS Tutorial: Creating a Simple ETL Package)
- Building a Data Mart with Integration Services
- Designing SSIS Packages for High Performance
- 8 Ways to Optimize and Improve Performance of your SSIS Package
- Analysis Services MOLAP Performance Guide for SQL Server 2012 and 2014
- How To Implement Proactive Caching in SQL Server Analysis Services SSAS
- SQL Server 2008 R2 Analysis Services Operations Guide
- Query Performance Tuning in Microsoft Analysis Services: Part 2
- Designing Aggregations (Analysis Services - Multidimensional)
- Plan for scalability
- SQL Server Analysis Services Query Response Comparison by Storage Mode
- Query Binding Detail (Partition Source Dialog Box) (Analysis Services - Multidimensional Data)
- SQL Server 2012 Analysis Services Partitioning Performance Demonstration
- SQL Server 2008 R2 Analysis Services Operations Guide
- Create and Manage a Local Partition (Analysis Services)
- Partition Storage Modes and Processing
- Plan and manage upgrades
- Maintain service health
Design BI infrastructure
- Design a security strategy
- Lesson 2: Setting SSAS Server Security and Server Properties
- SQL Server 2008 R2 Analysis Services Operations Guide
- Configuring permissions for SQL Server Analysis Services
- Implement Dynamic Security by Using Row Filters
- SQL Server Analysis Services Security Tips
- The Additive Design of SSAS Role Security
- Designing a Security strategy for an OLAP Solution using SSAS
- Unit Testing Role Security in Analysis Services
- Grant cube or model permissions (Analysis Services)
- Design a SQL partitioning strategy
- Analysis Services MOLAP Performance Guide for SQL Server 2012 and 2014
- SQL Server 2012 Analysis Services Partitioning Performance Demonstration
- Analysis Services Partition Size
- SSAS Lessons Learned: 29% Better Compression and 11% Better Query Performance
- Connection String Properties (Analysis Services)
- Design a high availability and disaster recovery strategy
- SLA and Disaster Recovery Planning for Microsoft Business Intelligence
- Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery
- Simple script to backup all SQL Server databases
- Backup and Restore Operations for Reporting Services
- Package Backup and Restore (SSIS Service)
- Backup, Restore, and Move the SSIS Catalog
- Package Backup and Restore (SSIS Service)
- Partitioned Tables and Indexes
- Design a logging and auditing strategy
Design a reporting solution
- Design a Reporting Services dataset
- Report Parameters (Report Builder and Report Designer)
- SQL Server Reporting Services Parameters Tips
- Write DAX queries in Report Builder
- Configure Windows Authentication on the Report Server
- Using DAX to create SSRS reports: The Basics
- Simple SSRS Report using MDX Query
- Grant User Access to a Report Server (Report Manager)
- SSRS Using Store Procedure Part 20
- Report Performance – Dataset filters vs query parameters?
- Add Dataset Filters, Data Region Filters, and Group Filters (Report Builder and SSRS)
- Manage Excel Services/reporting for SharePoint
- Design a data acquisition strategy
- Three Principles for Establishing Exceptional ETL Design
- Designing an ETL process with SSIS: two approaches to extracting and transforming data
- Tracking changes to tables in your data warehouse using snapshot-based versioning
- A Framework for the Design of ETL Scenarios
- Transforming data in a data warehouse through SQL views
- Using the Data Profiling SQL Server Integration Services SSIS task
- ETL Architecture’s 34 Subsystems
- ETL Tutorial for Beginners -Part 1 | ETL Data Warehouse Tutorial | ETL Data Warehouse | Edureka
- Plan and manage reporting services configuration
- Design BI reporting solution architecture
- Drillthrough, Drilldown, Subreports, and Nested Data Regions (Report Builder and SSRS)
- Report Server Web Service
- Power BI vs Report builder and reporting service s
- Add Code to a Report (SSRS)
- CHOOSING BETWEEN PERFORMANCEPOINT, POWERVIEW, EXCEL SERVICES AND REPORTING SERVICES FOR YOUR DATA VISUALIZATIONS
- Subscriptions and Delivery (Reporting Services)
- Create, Modify, and Delete Standard Subscriptions (Reporting Services in Native Mode)
- Reporting Services Data Alerts
- Manage My Data Alerts in Data Alert Manager
- Tutorial: Map Report (Report Builder)
- Maps (Report Builder and SSRS)
- Different Ways to Update Data in PowerPivot
- Design the data warehouse
- Analysis Services MOLAP Performance Guide for SQL Server 2012 and 2014
- Designing SSAS Cube
- SSAS Design and Performance Best Practices - PASS
- Surrogate Key vs. Natural Key
- SQL Server Best Practices Article
- Partitioned Tables and Indexes
- Implementing Slowly Changing Dimensions
- Introduction to Change Data Capture (CDC) in SQL Server 2008
- Define Relationship Dialog Box (Analysis Services - Multidimensional Data)
- Incremental Data Loads (DW)---a Technical Reference Guide for Designing Mission-Critical DW Solutions
- Reverse engineering of your Data Warehouse
- When to use T-SQL or SSIS for ETL
- SSIS Architecture and Internals Interview Questions
- Set Aggregation Options (Usage-Based Optimization Wizard)
- Design a schema
- Design cube architecture
- Analysis Services MOLAP Performance Guide for SQL Server 2012 and 2014
- SQL Server Analysis Services Aggregation Designs
- About Cube Partitioning
- SQL Server Analysis Service Levels of Granularity
- Defining Dimension Granularity within a Measure Group
- Enabling Drillthrough in Analysis Services
- SQL Server Best Practices Article
- Improving cube processing time
- Create Indexed Views
- Design fact Tables
- Design BI semantic models
- Design and create MDX calculations
Design an ETL solution
- Design SSIS package execution
- Plan deploy SSIS solutions
- Deployment of Projects and Packages
- Deploying SSIS Packages
- How to Manage SSIS Packages Stored in Multiple SQL Server Database Instances
- Security Overview (Integration Services)
- Possible ways to secure SSIS Packages
- Backup, Restore, and Move the SSIS Catalog
- SQL Server Integration Services (SSIS) Tutorial
- How to automate your SSIS and SQL Agent Job Deployment
- When to use T-SQL or SSIS for ETL
- Design package configurations for SSIS packages
Next Steps
For more information, refer to these links:
About the author
Daniel Calbimonte is a Microsoft SQL Server MVP, Microsoft Certified Trainer and 6-time Microsoft Certified IT Professional. Daniel started his career in 2001 and has worked with SQL Server 6.0 to 2022. Daniel is a DBA as well as specializes in Business Intelligence (SSIS, SSAS, SSRS) technologies.
View all my tips