{"id":21628,"date":"2020-09-24T10:30:13","date_gmt":"2020-09-24T10:30:13","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?page_id=21628"},"modified":"2021-05-27T13:23:48","modified_gmt":"2021-05-27T13:23:48","slug":"designing-business-intelligence-solutions-with-microsoft-sql-server-2012-70-467","status":"publish","type":"page","link":"https:\/\/www.testpreptraining.ai\/tutorial\/designing-business-intelligence-solutions-with-microsoft-sql-server-2012-70-467\/","title":{"rendered":"Exam 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012"},"content":{"rendered":"\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"400\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/09\/Salesforce-Identity-and-Access-Management-Designer-14.png\" alt=\"Designing Business Intelligence Solutions with Microsoft SQL Server 2012 (70-467) online Tutorial\" class=\"wp-image-21684\"\/><\/figure><\/div>\n\n\n\n<p>The <a href=\"https:\/\/www.testpreptraining.ai\/designing-business-intelligence-solutions-with-microsoft-sql-server-2012-70-467-practice-exam\" target=\"_blank\" rel=\"noreferrer noopener\">Designing Business Intelligence Solutions with Microsoft SQL Server 2012 (70-467)<\/a> examination is conducted by Microsoft. This examination prepares candidates for the Microsoft Exam 70-467. Also, this course will provide all the skills and knowledge for the following areas &#8211; Performance planning and Scalability planning.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Target Audience<\/strong><\/h5>\n\n\n\n<p>This certification will bring the best out of those candidates who are into business intelligence (BI) architecture, Also, for those who are responsible for the overall design of a BI infrastructure and how it relates to other data systems in use.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Exam Overview<\/strong><\/h3>\n\n\n\n<p>The Designing Business Intelligence Solutions with Microsoft SQL Server 2012 (70-467) consists of approximately 45-55 questions. This test format is multiple choice and multiple choice multiple answer. You may also see several scenario questions. The examination will cost you $165 USD. Also, the total time duration given to complete the examination is 120 minutes.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"400\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/09\/Salesforce-Identity-and-Access-Management-Designer-15.png\" alt=\"70-467 exam overview\" class=\"wp-image-21686\"\/><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Exam Registration<\/strong><\/h3>\n\n\n\n<p>For registering yourself for Designing Business Intelligence Solutions with Microsoft SQL Server 2012 (70-467)&nbsp; examination you are required to follow the following steps:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Click on <a href=\"https:\/\/examregistration.microsoft.com\/?action=1&amp;locale=en-us&amp;examcode=467&amp;examname=Designing%20Business%20Intelligence%20Solutions%20with%20Microsoft%20SQL%20Server&amp;returnToLearningUrl=https:\/\/docs.microsoft.com\/learn\/certifications\/exams\/70-467\" target=\"_blank\" rel=\"noreferrer noopener\">Schedule your exam<\/a> on the official <a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/certifications\/exams\/70-467\" target=\"_blank\" rel=\"noreferrer noopener\">Microsoft page<\/a>.<\/li><li>Login in your Microsoft account using your email id, if you haven&#8217;t created an account on Microsoft you are required to signup first before login in.<\/li><li>Follow the instructions given the site and select the available date and time slot and make the payment.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Exam Policies<\/strong><\/h3>\n\n\n\n<p>There are a few policies and regulations that candidates should adhere to. It not mandatory to go through these policies. However, it is highly recommended to read these<a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/certifications\/certification-exam-policies\" target=\"_blank\" rel=\"noreferrer noopener\"> policies<\/a> so as to avoid any kind of discomfort in the future.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Exam Retake Policy<\/strong><\/h4>\n\n\n\n<p>If the candidate failed to achieve the passing score, then he\/she has to wait for 24 hours before reapplying to the examination. The candidate can go to their certificate dashboard and reschedule the exam themselves. The candidate can reappear for the examination only five times. Failure in the second attempt will result in a waiting time of 14 days before rescheduling your third attempt. The waiting period for the fourth and the fifth attempts will also be 14 days.&nbsp;<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Exam Cancellation Policy<\/strong><\/h4>\n\n\n\n<p>Microsoft offers candidates to cancel or reschedule their exams within a minimum of 24 hours prior to the exam date. However, to prevent any cancellation fee, you must cancel or reschedule your exam, at least 6 business days prior to the date scheduled for your exam. Also, if you fail to appear in the exam, then you will not receive any refund of the exam fee.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Re-certification Policy<\/strong><\/h4>\n\n\n\n<p>Microsoft certification is expected to expire when the products are out of mainstream support although the person`s certification will be recognized. Officially, the certification will never expire.<\/p>\n\n\n\n<p>You can go through the full policies at: <a rel=\"noreferrer noopener\" href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/certifications\/certification-exam-policies\" target=\"_blank\">https:\/\/docs.microsoft.com\/en-us\/learn\/certifications\/certification-exam-policies<\/a><\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Clarify your doubts, visit <a rel=\"noreferrer noopener\" href=\"https:\/\/www.testpreptraining.ai\/tutorial\/70-467-designing-business-intelligence-solutions-with-microsoft-sql-server-2012-faq\/\" target=\"_blank\">Designing Business Intelligence Solutions with Microsoft SQL Server 2012 (70-467) FAQ.<\/a><\/strong><\/h5>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/70-467-designing-business-intelligence-solutions-with-microsoft-sql-server-2012-faq\/\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"400\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/09\/Salesforce-Identity-and-Access-Management-Designer-16.png\" alt=\"Designing Business Intelligence Solutions with Microsoft SQL Server 2012 (70-467) FAQ.\" class=\"wp-image-21688\"\/><\/a><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Course Outline<\/strong> <strong>for Exam 70-467<\/strong><\/h3>\n\n\n\n<p>The Designing Business Intelligence Solutions with Microsoft SQL Server 2012 (70-467) exam covers the following topics &#8211; <\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Plan business intelligence (BI) infrastructure (15\u201320%)<\/strong><\/h5>\n\n\n\n<p><strong>Plan for performance<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>optimize batch procedures: extract, transform, load (ETL) in SQL Server Integration (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/architecture\/data-guide\/relational-data\/etl\" target=\"_blank\" rel=\"noreferrer noopener\">Extract, transform, and load (ETL)<\/a>)<\/li><li>Services (SSIS)\/SQL and processing phase in Analysis Services (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/control-flow\/analysis-services-processing-task?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Analysis Services Processing Task<\/a>)<\/li><li>configure Proactively caching within SQL Server Analysis Services (SSAS) for different scenarios (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models-olap-logical-cube-objects\/partitions-proactive-caching?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Partitions &#8211; Proactive Caching<\/a>)<\/li><li>understand the performance consequences of named queries in a data source view (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/define-named-queries-in-a-data-source-view-analysis-services?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Define Named Queries in a Data Source View (Analysis Services)<\/a>)<\/li><li>analyze and optimize performance, including Multidimensional Expression (MDX) and Data Analysis Expression (DAX) queries (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/dax-for-multidimensional-models?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">DAX for multidimensional models<\/a>)<\/li><li>understand the difference between partitioning for load performance versus query performance in SSAS  (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/partitions\/partitioned-tables-and-indexes?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Partitioned Tables and Indexes<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/create-and-manage-a-local-partition-analysis-services?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Create and Manage a Local Partition<\/a>)<\/li><li>appropriately index a fact table<\/li><li>optimize Analysis Services cubes in SQL Server Data Tools <\/li><li>create aggregations (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/use-aggregate-functions?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Use Aggregate Functions<\/a>)<\/li><\/ul>\n\n\n\n<p><strong>Plan for scalability<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>change binding options for partitions (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/processing-options-and-settings-analysis-services?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Processing Options and Settings (Analysis Services)<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/data-sources-and-bindings-ssas-multidimensional?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Data Sources and Bindings (SSAS Multidimensional<\/a>)<\/li><li>choose the appropriate Multidimensional OLAP(MOLAP) (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/set-partition-storage-analysis-services-multidimensional?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Set Partition Storage (Analysis Services &#8211; Multidimensional)<\/a>)<\/li><li> Relational OLAP (ROLAP), and Hybrid OLAP (HOLAP) storage modes<\/li><\/ul>\n\n\n\n<p><strong>Plan and manage upgrades<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li> plan change management for a BI solution (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/guidance\/center-of-excellence-business-intelligence-solution-architecture\" target=\"_blank\" rel=\"noreferrer noopener\">BI solution architecture<\/a>)<\/li><\/ul>\n\n\n\n<p><strong>Maintain server health<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li> draft an automation strategy <\/li><\/ul>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Design BI infrastructure (15\u201320%)<\/strong><\/h5>\n\n\n\n<p><strong>Design a security strategy<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>configure security and impersonation between SQL Server service, analysis services, and front end (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/tabular-models\/impersonation-ssas-tabular?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Impersonation<\/a>)<\/li><li>implement Dynamic Dimension Security within a cube (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/desktop-tutorial-row-level-security-onprem-ssas-tabular\" target=\"_blank\" rel=\"noreferrer noopener\">Implement row-level security in an Analysis Services tabular model<\/a>)<\/li><li>configure security for an extranet environment <\/li><li>configure Kerberos security (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/windows-server\/security\/kerberos\/kerberos-authentication-overview\" target=\"_blank\" rel=\"noreferrer noopener\">Kerberos Authentication Overview<\/a>)<\/li><li>design authentication mechanisms<\/li><li>design security tests <\/li><li>build secure solutions end to end<\/li><li>design roles for calculated measures (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/tabular-models\/create-and-manage-measures-ssas-tabular?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Create and manage measures<\/a>)<\/li><li>understand the tradeoffs between regular SSAS security and dynamic security (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/desktop-tutorial-row-level-security-onprem-ssas-tabular\" target=\"_blank\" rel=\"noreferrer noopener\">Implement row-level security in an Analysis Services tabular model<\/a>)<\/li><\/ul>\n\n\n\n<p><strong>Design a SQL partitioning strategy<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>choose the proper partitioning strategy for the data warehouse and cube (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/partitions-in-multidimensional-models?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Partitions in Multidimensional Models<\/a>)<\/li><li>implement a parallel load to fact tables by using partition switching (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/tabular-models\/tabular-model-partitions-ssas-tabular?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Tabular model partitions<\/a>)<\/li><li>use data compression (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/data-compression\/data-compression?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Data Compression<\/a>)<\/li><\/ul>\n\n\n\n<p><strong>Design a high availability and disaster recovery strategy<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>draft a recovery strategy (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/database-engine\/sql-server-business-continuity-dr?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Business continuity and database recovery &#8211; SQL Server<\/a>)<\/li><li>back up and restore SSAS databases (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/backup-and-restore-of-analysis-services-databases?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Backup and Restore of Analysis Services Databases<\/a>)<\/li><li>back up and restore SSRS databases (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/install-windows\/backup-and-restore-operations-for-reporting-services?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Backup and Restore Operations for Reporting Services<\/a>)<\/li><li>move and restore the SSIS Catalog (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/catalog\/ssis-catalog?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">SSIS Catalog<\/a>)<\/li><li>design an AlwaysON solution. (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/database-engine\/availability-groups\/windows\/always-on-availability-groups-sql-server?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Always On availability groups: a high-availability and disaster-recovery solution<\/a>)<\/li><\/ul>\n\n\n\n<p><strong>Design a logging and auditing strategy<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>draft a new SSIS logging infrastructure (for example, information available through the catalog views) (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/performance\/integration-services-ssis-logging?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Integration Services (SSIS) Logging<\/a>)<\/li><li>validate data is balancing and reconciling correctly. <\/li><\/ul>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Design a reporting solution (20\u201325%)<\/strong><\/h5>\n\n\n\n<p><strong>Design a Reporting Services dataset<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>draft appropriate data query parameters (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/graph\/query-parameters\" target=\"_blank\" rel=\"noreferrer noopener\">Use query parameters to customize responses<\/a>)<\/li><li>create appropriate SQL queries (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/lesson-1-creating-database-objects?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Create and query database objects<\/a>)<\/li><li> create appropriate DAX queries for an application (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/dax\/dax-overview\" target=\"_blank\" rel=\"noreferrer noopener\">DAX overview<\/a>)<\/li><li> manage data rights and security<\/li><li> extract data from analysis services by using MDX queries(<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/mdx\/mdx-query-the-basic-query?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">MDX Query &#8211; The Basic Query<\/a>)<\/li><li> balance query-based processing versus filter-based processing (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/query-processing-architecture-guide?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Query Processing Architecture Guide<\/a>)<\/li><li>manage data sets through the use of stored procedures (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/data-collection\/manage-data-collection?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Manage Data Collection<\/a>)<\/li><\/ul>\n\n\n\n<p><strong>Manage Excel Services\/reporting for SharePoint<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>configure data refresh schedules for PowerPivot published to SharePoint (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sharepoint\/administration\/data-refresh-using-the-unattended-data-refresh-account\" target=\"_blank\" rel=\"noreferrer noopener\">Configure scheduled data refresh for Power Pivot by using the unattended data refresh account<\/a>)<\/li><li>publish BI info to SharePoint (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/canvas-apps\/sharepoint-scenario-embed-report#:~:text=Sign%20in%20to%20Power%20BI,we%20create%20a%20SharePoint%20page.\" target=\"_blank\" rel=\"noreferrer noopener\">Embed the Power BI project report in SharePoint Online<\/a>)<\/li><li>use SharePoint to accomplish BI administrative tasks <\/li><li>install and configure Power View (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/power-pivot-for-sharepoint-ssas?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Activate the report server and Power View integration features in SharePoint<\/a>)<\/li><li>publish PowerPivot and Power View to SharePoint (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/power-pivot-for-sharepoint-ssas?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Power Pivot for SharePoint<\/a>)<\/li><\/ul>\n\n\n\n<p><strong>Design a data acquisition strategy<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>identify the data sources that need to be used to pull in the data (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/desktop-data-sources\" target=\"_blank\" rel=\"noreferrer noopener\">Data sources in Power BI Desktop<\/a>)<\/li><li>determine the changes (incremental data) in the data source (time window) (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-query\/dataflows\/incremental-refresh\" target=\"_blank\" rel=\"noreferrer noopener\">Using incremental refresh with dataflows<\/a>)<\/li><li> identify the relationship and dependencies between the data sources (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/tabular-models\/relationships-ssas-tabular?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Relationships<\/a>)<\/li><li>determine who can access which data<\/li><li>determine what data can be retained for how long (regulatory compliance, data archiving, aging) <\/li><li>design a data movement strategy <\/li><li>profile source data <\/li><\/ul>\n\n\n\n<p><strong>Plan and manage reporting services configuration<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>choose the appropriate reporting services requirements (including native mode and SharePoint mode) (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/report-server-sharepoint\/reporting-services-report-server?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Comparing native and SharePoint Reporting Services report servers<\/a>)<\/li><\/ul>\n\n\n\n<p><strong>Design BI reporting solution architecture<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>linked drill-down reports, drill-through reports, and subreports (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/report-design\/drillthrough-drilldown-subreports-and-nested-data-regions?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Drillthrough, Drilldown, Subreports, and Nested Data Regions<\/a>)<\/li><li>design report migration strategies (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/plan-for-report-design-and-report-deployment-reporting-services?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Plan for report design and report deployment | Reporting Services<\/a>)<\/li><li>access report services API (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/developer\/rest-api?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Develop with the REST APIs for Reporting Services<\/a>)<\/li><li>design code-behind strategies <\/li><li>identify when to use Reporting Services (RS), Report Builder (RB), or Power View (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/report-builder\/finding-viewing-and-managing-reports-report-builder-and-ssrs?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Finding, Viewing, and Managing Reports (Report Builder and SSRS )<\/a>)<\/li><li>design and implement context transfer when interlinking all types of reports (RS, RB, Power View, Excel) (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-gb\/office\/power-view-explore-visualize-and-present-your-data-98268d31-97e2-42aa-a52b-a68cf460472e\" target=\"_blank\" rel=\"noreferrer noopener\">Power View: Explore, visualize, and present your data<\/a>)<\/li><li>implement BI tools for reporting in SharePoint (Excel Services versus PowerView versus Reporting Services) (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/report-server-sharepoint\/reporting-services-report-server?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Comparing native and SharePoint Reporting Services report servers<\/a>)<\/li><li>select a subscription strategy <\/li><li>enable Data Alerts (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/create-reports\/service-set-data-alerts\" target=\"_blank\" rel=\"noreferrer noopener\">Data alerts in the Power BI service<\/a>)<\/li><li>draft map visualization <\/li><\/ul>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Design BI data models (30\u201335%)<\/strong> <\/h5>\n\n\n\n<p><strong>Design the data warehouse<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>draft a data model that is optimized for reporting (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/guidance\/power-bi-optimization\" target=\"_blank\" rel=\"noreferrer noopener\">Optimization guide for Power BI<\/a>)<\/li><li>design and build a cube on top (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/create-a-cube-using-the-cube-wizard?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Create a Cube Using the Cube Wizard<\/a>)<\/li><li>draft enterprise data warehouse (EDW) and OLAP cubes (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/system-center\/scsm\/olap-cubes-overview?view=sc-sm-2019\" target=\"_blank\" rel=\"noreferrer noopener\">Overview of Service Manager OLAP cubes for advanced analytics<\/a>)<\/li><li>choose between natural keys and surrogate keys when designing the data warehouse (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/guidance\/star-schema\" target=\"_blank\" rel=\"noreferrer noopener\">Understand star schema and the importance for Power BI<\/a>)<\/li><li> use SQL Server to design, implement, and maintain a data warehouse, including partitioning <\/li><li>slowly changing dimensions (SCD) (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/data-flow\/transformations\/slowly-changing-dimension-transformation?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Slowly Changing Dimension Transformation<\/a>)<\/li><li>change data capture (CDC), Index Views, and column store indexes (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/track-changes\/about-change-data-capture-sql-server?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">About Change Data Capture (SQL Server)<\/a>)<\/li><li>identify design best practices <\/li><li>implement a many-to-many relationship in an OLAP cube (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-tutorial\/lesson-5-3-defining-a-many-to-many-relationship?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Defining a Many-to-Many Relationship<\/a>)<\/li><li>design a data mart\/warehouse in reverse from an Analysis Services cube (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/system-center\/scsm\/olap-cubes-overview?view=sc-sm-2019\" target=\"_blank\" rel=\"noreferrer noopener\">Overview of Service Manager OLAP cubes for advanced analytics<\/a>)<\/li><li>implement incremental data load (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/change-data-capture\/perform-an-incremental-load-of-multiple-tables?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Perform an Incremental Load of Multiple Tables<\/a>)<\/li><li>choose between performing aggregation operations in the SSIS pipeline or the relational engine (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/data-flow\/transformations\/aggregate-transformation?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Aggregate Transformation<\/a>)<\/li><\/ul>\n\n\n\n<p><strong>Design a schema<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>multidimensional modeling starting from a star or snowflake schema (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models-olap-logical-dimension-objects\/dimensions-introduction?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Dimensions &#8211; Introduction<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/guidance\/star-schema\" target=\"_blank\" rel=\"noreferrer noopener\">nderstand star schema and the importance for Power BI<\/a>)<\/li><li>design relational modeling for a Data Mart<\/li><\/ul>\n\n\n\n<p><strong>Design cube architecture<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>partition cubes and build aggregation strategies for the separate partitions  (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models-olap-logical-cube-objects\/partitions-analysis-services-multidimensional-data?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Partitions (Analysis Services &#8211; Multidimensional Data)<\/a>)<\/li><li>design a data model (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/design-model-power-bi\/\" target=\"_blank\" rel=\"noreferrer noopener\">Design a data&nbsp;model&nbsp;in Power BI&nbsp;<\/a>)<\/li><li>choose the proper partitioning strategy for the data warehouse and cube (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models-olap-logical-cube-objects\/partitions-analysis-services-multidimensional-data?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Partitions (Analysis Services &#8211; Multidimensional Data)<\/a>)<\/li><li>design the data file layout<\/li><li>identify the aggregation method for a measure in a MOLAP cube (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models-olap-logical-cube-objects\/aggregations-and-aggregation-designs?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Aggregations and Aggregation Designs<\/a>)<\/li><li>performance tune a MOLAP cube using aggregations<\/li><li>design a data source view (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-tutorial\/lesson-1-3-defining-a-data-source-view?view=asallproducts-allversions#:~:text=To%20define%20a%20new%20data,click%20New%20Data%20Source%20View.&amp;text=To%20create%20a%20data%20source,on%20a%20single%20data%20source.\" target=\"_blank\" rel=\"noreferrer noopener\">Defining a Data Source View<\/a>)<\/li><li>design for cube drill-through and write back actions (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-tutorial\/lesson-8-1-defining-and-using-a-drillthrough-action?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Defining and Using a Drillthrough Action<\/a>)<\/li><li>choose the correct grain of data to store in a measure group (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-tutorial\/lesson-5-4-defining-dimension-granularity-within-a-measure-group?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Defining Dimension Granularity within a Measure Group<\/a>)<\/li><li>draft analysis services processing by using indexes, indexed views, and order by statements (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/processing-options-and-settings-analysis-services?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Processing Options and Settings (Analysis Services)<\/a>)<\/li><\/ul>\n\n\n\n<p><strong>Design fact tables<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li> draft a data warehouse that supports many to many dimensions with factless fact tables (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/guidance\/star-schema\" target=\"_blank\" rel=\"noreferrer noopener\">Understand star schema and the importance for Power BI<\/a>)<\/li><\/ul>\n\n\n\n<p><strong>Design BI semantic models<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>plan for a multidimensional cube (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/system-center\/scsm\/olap-cubes-overview?view=sc-sm-2019\" target=\"_blank\" rel=\"noreferrer noopener\">Overview of Service Manger OLAP cubes for advanced analytics<\/a>)<\/li><li>support a many-to-many relationship between tables (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-tutorial\/lesson-5-3-defining-a-many-to-many-relationship?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Defining a Many-to-Many Relationship<\/a>)<\/li><li>choose between multidimensional and tabular, depending on the type of data and workload (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/comparing-tabular-and-multidimensional-solutions-ssas?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Comparing tabular and multidimensional solutions<\/a>)<\/li><\/ul>\n\n\n\n<p><strong>Design and create MDX calculations<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>draft MDX queries (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/mdx\/mdx-query-the-basic-query?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">MDX Query &#8211; The Basic Query<\/a>)<\/li><li>identify the structures of MDX and the common functions (tuples, sets, TopCount, SCOPE, VisualTotals, and more) (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/mdx\/working-with-members-tuples-and-sets-mdx?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Working with Members, Tuples, and Sets (MDX)<\/a>)<\/li><li>create calculated members in an MDX statement (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/mdx\/mdx-calculated-members-building-calculated-members?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">MDX Calculated Members &#8211; Building Calculated Members<\/a>)<\/li><li>identify which MDX statement would return the required result <\/li><li>implement a custom MDX or logical solution for a pre-prepared case task<\/li><\/ul>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Design an ETL solution (10\u201315%)<\/strong><\/h5>\n\n\n\n<p><strong>Design SSIS package execution<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>use the new project deployment model (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/packages\/deploy-integration-services-ssis-projects-and-packages?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Deploy Integration Services (SSIS) Projects and Packages<\/a>)<\/li><li>pass values at execution time (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/integration-services-ssis-package-and-project-parameters?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Integration Services (SSIS) Package and Project Parameters<\/a>)<\/li><li>share parameters between packages <\/li><li>plan for incremental loads versus full loads (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/change-data-capture\/perform-an-incremental-load-of-multiple-tables?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Perform an Incremental Load of Multiple Tables<\/a>)<\/li><li>optimize execution by using Balanced Data Distributor (BDD) (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/data-flow\/transformations\/balanced-data-distributor-transformation?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Balanced Data Distributor Transformation<\/a>)<\/li><li>choose optimal processing strategy (including Script transform, flat-file incremental loads, and Derived Column transform) (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/change-data-capture\/change-data-capture-ssis?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Change Data Capture (SSIS)<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/data-flow\/transformations\/derived-column-transformation?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Derived Column Transformation<\/a>)<\/li><\/ul>\n\n\n\n<p><strong>Plan to deploy SSIS solutions<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>deploy the package to another server with different security requirements (<strong>Microsoft Documentation: <\/strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/packages\/deploy-integration-services-ssis-projects-and-packages?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Deploy Integration Services (SSIS) Projects and Packages<\/a>)<\/li><li>secure integration services packages that are deployed at the file system <\/li><li>demonstrate awareness of SSIS packages\/projects and how they interact with environments (including recoverability) (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/integration-services-ssis-projects-and-solutions?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Integration Services (SSIS) Projects and Solutions<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/catalog\/ssis-catalog?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">SSIS Catalog<\/a>)<\/li><li>decide between performing aggregation operations in the SSIS pipeline or the relational engine (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/data-flow\/transformations\/aggregate-transformation?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Aggregate Transformation<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/data-flow\/data-flow-performance-features?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Data Flow Performance Features<\/a>)<\/li><li>plan to automate SSIS deployment (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/packages\/deploy-integration-services-ssis-projects-and-packages?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Deploy Integration Services (SSIS) Projects and Packages<\/a>)<\/li><li>plan the administration of the SSIS Catalog database. (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/catalog\/ssis-catalog?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">SSIS Catalog<\/a>)<\/li><\/ul>\n\n\n\n<p><strong>Design package configurations for SSIS packages<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>avoid repeating configuration information entered in SSIS packages, and use configuration files (<strong>Microsoft Documentation: <\/strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/lesson-5-2-enabling-and-configuring-package-configurations?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Enable and configure package configurations<\/a>)<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong> Preparatory Guide for Designing Business Intelligence Solutions with Microsoft SQL Server 2012 (70-467) <\/strong><\/h2>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"2000\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/09\/Preparatory-Guide-5-1.png\" alt=\"Preparatory Guide for Designing Business Intelligence Solutions with Microsoft SQL Server 2012 (70-467) \" class=\"wp-image-21694\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/09\/Preparatory-Guide-5-1.png 800w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/09\/Preparatory-Guide-5-1-160x400.png 160w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/figure><\/div>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Refer the Official Exam Guide <\/strong><\/h4>\n\n\n\n<p>There is nothing wrong to say that the guide serves as complete coverage of the Designing Business Intelligence Solutions with Microsoft SQL Server 2012 (70-467) exam and its related domains. Candidates who are looking for a comprehensive review of information must visit and bookmark this guide so that they can get access to it anywhere and anytime they want. <\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Learning Resources<\/strong><\/h4>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Instructor-led Training<\/strong><\/h5>\n\n\n\n<p>Microsoft provides this 5-day <a rel=\"noreferrer noopener\" href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/certifications\/courses\/20467\" target=\"_blank\">instructor-led course<\/a> for the candidates appearing in Designing Business Intelligence Solutions with Microsoft SQL Server 2012 (70-467) exam. This training helps the candidate to gain knowledge in the following domains:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Plan a BI solution.<\/li><li>Plan SQL Server BI infrastructure.<\/li><li>Design a data warehouse.<\/li><li>Draw an extract, transform and load (ETL) solution.<\/li><li>Design analytical data models.<\/li><li>Plan a BI delivery solution.<\/li><li>Design a Reporting Services solution.<\/li><li>Design a Microsoft Excel-based reporting solution.<\/li><li>Plan a SharePoint Server BI solution.<\/li><li>Monitor and optimize a BI solution.<\/li><li>Operate a BI solution.<\/li><\/ul>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Prerequisite required for the Instructor-Lead training<\/strong><\/h5>\n\n\n\n<p>This training will help the candidate to get a piece of better knowledge for preparing for the examination, however, there are few important skills that are required beforehand:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>A basic understanding of dimensional modeling (star schema) for data warehouses<\/li><li>Basic server hardware knowledge<\/li><li>The ability to create Integration Services packages that include control flows and data flows and a basic multidimensional cube with Analysis Services<\/li><li>Should be able to create create a basic tabular model with PowerPivot and Analysis Services<\/li><li>The ability to create Reporting Services reports with Report Designer<\/li><li>The ability to implement authentication and permissions in the SQL Server database engine, Analysis Services, and Reporting Services<\/li><li>Familiarity with SharePoint Server and Microsoft Office applications &#8211; particularly Excel<\/li><\/ul>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Microsoft Books<\/strong> <\/h5>\n\n\n\n<p>Microsoft provides reference books that can be helpful while studying for the exam. These books contain various useful resources that can be used while studying. Visit&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/www.microsoftpressstore.com\/search\/index.aspx?query=Windows+Operating+System+Fundamentals\" target=\"_blank\"><strong>Microsoft Press books<\/strong><\/a>, to find relevant books to get a deeper insight into the exam objectives, and hence crack the test, and earn your certification. You can also buy these books from leading online stores. These books will help you prepare for the examination in a structural way.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Reference Books<\/strong><\/h5>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignright size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/09\/51sM8xTWj8L._SX456_BO1204203200_-366x400.jpg\" alt=\"Microsoft SQL 2012 BI MCSE Exam package (70-467) Designing Business Intelligence Solutions with Microsoft SQL Server 2012 CD-ROM\" class=\"wp-image-21679\" width=\"135\" height=\"148\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/09\/51sM8xTWj8L._SX456_BO1204203200_-366x400.jpg 366w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/09\/51sM8xTWj8L._SX456_BO1204203200_.jpg 458w\" sizes=\"auto, (max-width: 135px) 100vw, 135px\" \/><\/figure><\/div>\n\n\n\n<p>Apart from the official Microsoft Books, there are plenty of more study books available in the market. Here, we have provided you with more books for your reference.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Microsoft SQL 2012 BI MCSE Exam package (70-467) Designing Business Intelligence Solutions with Microsoft SQL Server 2012&nbsp;CD-ROM<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Join Microsoft Community<\/strong><\/h4>\n\n\n\n<p>A healthy discussion is always beneficial, no matter where it is done. The prospects of getting resolutions to an issue increase steeply when a greater number of people are involved. These discussions make the studies more comprehensive.  Forums work really well to build a community that is essential for understanding others.&nbsp;Interacting with people of the same goal puts you one step forward in achieving those goals. It is suggested that you should join Microsoft Community.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Evaluate with Practice Tests<\/strong><\/h4>\n\n\n\n<p>The final step to success is to practice what you have learned. Taking a practice test is a great way to diversify your study strategy and ensure the best possible results for the final exam. Further, analyzing the practice test is very important so as to ensure complete preparation. We provide you with free sample papers to help you excel in the examination. <a rel=\"noreferrer noopener\" href=\"https:\/\/www.testpreptraining.ai\/designing-business-intelligence-solutions-with-microsoft-sql-server-2012-70-467-free-practice-test\" target=\"_blank\">Start practicing now<\/a>!<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><a href=\"https:\/\/www.testpreptraining.ai\/designing-business-intelligence-solutions-with-microsoft-sql-server-2012-70-467-free-practice-test\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/09\/Designing-Business-Intelligence-Solutions-with-Microsoft-SQL-Server-2012-70-467-1-750x117.png\" alt=\"70-467 free practice test\" class=\"wp-image-21699\" width=\"960\" height=\"150\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/09\/Designing-Business-Intelligence-Solutions-with-Microsoft-SQL-Server-2012-70-467-1-750x117.png 750w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/09\/Designing-Business-Intelligence-Solutions-with-Microsoft-SQL-Server-2012-70-467-1.png 960w\" sizes=\"auto, (max-width: 960px) 100vw, 960px\" \/><\/a><\/figure><\/div>\n","protected":false},"excerpt":{"rendered":"<p>The Designing Business Intelligence Solutions with Microsoft SQL Server 2012 (70-467) examination is conducted by Microsoft. This examination prepares candidates for the Microsoft Exam 70-467. Also, this course will provide all the skills and knowledge for the following areas &#8211; Performance planning and Scalability planning. Target Audience This certification will bring the best out of&#8230;<\/p>\n","protected":false},"author":1,"featured_media":21684,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"categories":[1226,5729],"tags":[2798,2799,2800,2801,4],"class_list":["post-21628","page","type-page","status-publish","has-post-thumbnail","hentry","category-microsoft","category-server","tag-designing-business-intelligence-solutions-with-microsoft-sql-server-2012-70-467-free-practice-test","tag-designing-business-intelligence-solutions-with-microsoft-sql-server-2012-70-467-online-tutorial","tag-designing-business-intelligence-solutions-with-microsoft-sql-server-2012-70-467-study-material","tag-designing-business-intelligence-solutions-with-microsoft-sql-server-2012-70-467-study-tutorial","tag-m4f"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>exam-70-467-designing-business-intelligence-solutions<\/title>\n<meta name=\"description\" content=\"Make your resume stand out and become a Certified Designing Business Intelligence Solutions with Microsoft SQL Server 2012 (70-467) !\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.testpreptraining.ai\/tutorial\/designing-business-intelligence-solutions-with-microsoft-sql-server-2012-70-467\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"exam-70-467-designing-business-intelligence-solutions\" \/>\n<meta property=\"og:description\" content=\"Make your resume stand out and become a Certified Designing Business Intelligence Solutions with Microsoft SQL Server 2012 (70-467) !\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/designing-business-intelligence-solutions-with-microsoft-sql-server-2012-70-467\/\" \/>\n<meta property=\"og:site_name\" content=\"Testprep Training Tutorials\" \/>\n<meta property=\"article:modified_time\" content=\"2021-05-27T13:23:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/09\/Salesforce-Identity-and-Access-Management-Designer-14.png\" \/>\n\t<meta property=\"og:image:width\" content=\"750\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"14 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/designing-business-intelligence-solutions-with-microsoft-sql-server-2012-70-467\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/designing-business-intelligence-solutions-with-microsoft-sql-server-2012-70-467\/\",\"name\":\"exam-70-467-designing-business-intelligence-solutions\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\"},\"datePublished\":\"2020-09-24T10:30:13+00:00\",\"dateModified\":\"2021-05-27T13:23:48+00:00\",\"description\":\"Make your resume stand out and become a Certified Designing Business Intelligence Solutions with Microsoft SQL Server 2012 (70-467) !\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/designing-business-intelligence-solutions-with-microsoft-sql-server-2012-70-467\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/designing-business-intelligence-solutions-with-microsoft-sql-server-2012-70-467\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/designing-business-intelligence-solutions-with-microsoft-sql-server-2012-70-467\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Exam 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"name\":\"Testprep Training Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\",\"name\":\"Testprep Training\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"contentUrl\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"width\":583,\"height\":153,\"caption\":\"Testprep Training\"},\"image\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"exam-70-467-designing-business-intelligence-solutions","description":"Make your resume stand out and become a Certified Designing Business Intelligence Solutions with Microsoft SQL Server 2012 (70-467) !","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.testpreptraining.ai\/tutorial\/designing-business-intelligence-solutions-with-microsoft-sql-server-2012-70-467\/","og_locale":"en_US","og_type":"article","og_title":"exam-70-467-designing-business-intelligence-solutions","og_description":"Make your resume stand out and become a Certified Designing Business Intelligence Solutions with Microsoft SQL Server 2012 (70-467) !","og_url":"https:\/\/www.testpreptraining.ai\/tutorial\/designing-business-intelligence-solutions-with-microsoft-sql-server-2012-70-467\/","og_site_name":"Testprep Training Tutorials","article_modified_time":"2021-05-27T13:23:48+00:00","og_image":[{"width":750,"height":400,"url":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/09\/Salesforce-Identity-and-Access-Management-Designer-14.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"14 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/designing-business-intelligence-solutions-with-microsoft-sql-server-2012-70-467\/","url":"https:\/\/www.testpreptraining.ai\/tutorial\/designing-business-intelligence-solutions-with-microsoft-sql-server-2012-70-467\/","name":"exam-70-467-designing-business-intelligence-solutions","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website"},"datePublished":"2020-09-24T10:30:13+00:00","dateModified":"2021-05-27T13:23:48+00:00","description":"Make your resume stand out and become a Certified Designing Business Intelligence Solutions with Microsoft SQL Server 2012 (70-467) !","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/designing-business-intelligence-solutions-with-microsoft-sql-server-2012-70-467\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/tutorial\/designing-business-intelligence-solutions-with-microsoft-sql-server-2012-70-467\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/designing-business-intelligence-solutions-with-microsoft-sql-server-2012-70-467\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Exam 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012"}]},{"@type":"WebSite","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","name":"Testprep Training Tutorials","description":"","publisher":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization","name":"Testprep Training","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","contentUrl":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","width":583,"height":153,"caption":"Testprep Training"},"image":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/21628","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/comments?post=21628"}],"version-history":[{"count":39,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/21628\/revisions"}],"predecessor-version":[{"id":42758,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/21628\/revisions\/42758"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media\/21684"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media?parent=21628"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/categories?post=21628"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/tags?post=21628"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}