{"id":21804,"date":"2020-09-25T09:10:03","date_gmt":"2020-09-25T09:10:03","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?page_id=21804"},"modified":"2021-05-27T13:22:55","modified_gmt":"2021-05-27T13:22:55","slug":"exam-70-466-implementing-data-models-and-reports-with-microsoft-sql-server","status":"publish","type":"page","link":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-466-implementing-data-models-and-reports-with-microsoft-sql-server\/","title":{"rendered":"Exam 70-466: Implementing Data Models and Reports with Microsoft SQL Server"},"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\/ArcGIS-Desktop-Entry-EADE-19-001-1-2.png\" alt=\"Exam 70-466 Online Tutorial\" class=\"wp-image-21863\"\/><\/figure><\/div>\n\n\n\n<p> The <a rel=\"noreferrer noopener\" href=\"https:\/\/www.testpreptraining.ai\/implementing-data-models-and-reports-with-microsoft-sql-server-2012-70-466\" target=\"_blank\">Microsoft 70-466: Implementing Data Models and Reports with Microsoft SQL Server 70-466<\/a>&nbsp;is specifically for participants to gain the knowledge and skills for making the appropriate job role decisions around implementing data models and reports with Microsoft SQL Server 2012.&nbsp;Achieving this certification puts you in an advantageous position and helps you gain mastery of Microsoft SQL Server<\/p>\n\n\n\n<p>However, the preparations don\u2019t come easy. You need constant practice to clear the exam. Here we provide you with our Tutorials and Preparatory Guide that will support you throughout your exam journey. This guide will define your rodmap to success.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Who should take the 70-466 exam?<\/strong><\/h4>\n\n\n\n<p>This exam is intended for business intelligence (BI) developers who focus on creating BI solutions that require implementing multi-dimensional data models, implementing and maintaining OLAP cubes, and creating information displays used in business decision making.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Key Responsibilities <\/strong><\/h4>\n\n\n\n<p>Primary responsibilities include:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Firstly, Implementing analytical data models, such as OLAP cubes.<\/li><li>Secondly, Implementing reports, and managing report delivery.<\/li><li>Thirdly, Creating business performance dashboards.<\/li><li>Also, Supporting data mining and predictive analysis.<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Certification Details<\/strong><\/h4>\n\n\n\n<p>The Microsoft 70-466 exam is a part of the requirements for:&nbsp;<a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/certifications\/mcse-data-management-analytics\" target=\"_blank\" rel=\"noreferrer noopener\">MCSE: Data Management and Analytics<\/a>. On successful completion of Microsoft 70-464, 70-465 and 70-466 you earn the MCSE: Data Management and Analytics certification.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"732\" height=\"400\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/09\/nfdsjk-732x400.png\" alt=\"70-466  certification details\" class=\"wp-image-21807\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/09\/nfdsjk-732x400.png 732w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/09\/nfdsjk.png 865w\" sizes=\"auto, (max-width: 732px) 100vw, 732px\" \/><figcaption>Source: Microsoft<\/figcaption><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"> <strong>Exam Details : Microsoft 70-466<\/strong><\/h3>\n\n\n\n<p>Before embarking on your preparations, it\u2019s always beneficial to be thorough with all the important exam information. You should know the details should beforehand. Therefore we have provided all the necessary information you may need before applying for the 70-466 exam<\/p>\n\n\n\n<p>The Microsoft 70-466 Implementing Data Models and Reports with Microsoft SQL exam comprises of 40-60 questions. Further, the exam duration is only 120 minutes. The exam fee is 165 USD. Moreover, the exam is available in English, Chinese (Simplified), French, German, Japanese, Portuguese (Brazil) languages.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-table aligncenter\"><table><tbody><tr><td>Exam Name<\/td><td>&nbsp;Implementing Data Models and Reports with Microsoft SQL Server 2012<\/td><\/tr><tr><td>Exam Code<\/td><td>70-466<\/td><\/tr><tr><td>Exam Duration<\/td><td>120 mins<\/td><\/tr><tr><td>Number of Questions<\/td><td>40-60 Questions<\/td><\/tr><tr><td>Exam Format<\/td><td>Multiple Choice and Multi-Response Questions<\/td><\/tr><tr><td>Exam Type<\/td><td>Server<\/td><\/tr><tr><td>Exam Fee<\/td><td>$165 USD<\/td><\/tr><tr><td>Exam Language<\/td><td>English, Chinese (Simplified), French, German, Japanese, Portuguese (Brazil)<\/td><\/tr><tr><td>Credit Towards<\/td><td>MCSE<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>How to Schedule the exam?<\/strong><\/h4>\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\/image-3-2.png\" alt=\"\" class=\"wp-image-21811\" width=\"216\" height=\"44\"\/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignright size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"245\" height=\"48\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/09\/image-2-3.png\" alt=\"\" class=\"wp-image-21812\"\/><\/figure><\/div>\n\n\n\n<p>The Microsoft 70-466  can be scheduled as follows-<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>For non-students interested in technology at Pearson Vue<\/li><li>For students or instructors at Certiport<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>70-466 Exam Retake Policy<\/strong><\/h4>\n\n\n\n<p>Microsoft allows 5 attempts per year for a specific exam. The exam retake policy for Microsoft 70-466 Exam is as follows-<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>If a candidate is not able to clear the exam in the first attempt, the candidate must wait at least 24 hours before retaking the exam.<\/li><li>If a candidate does not clear the exam the second time, candidate must wait at least 14 days before retaking the exam a third time.<\/li><li>A 14-day waiting period is also there for the fourth and fifth subsequent exam retakes.<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Cancellation and Reschedule Policy<\/strong><\/h4>\n\n\n\n<p>Microsoft allows free cancelling of the Exam within 24 hours prior to your scheduled appointment. But, if you fail to show up on your exam day without rescheduling or cancelling your exam, Microsoft reserves all rights to forfeit your entire exam fee. Rescheduling and Cancellation of your scheduled exams can be done through the Certification Dashboard.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Microsoft 70-466<\/strong> <strong>Exam FAQ<\/strong><\/h3>\n\n\n\n<p>It is essential to have complete clarity about the exam before beginning. Visit the <strong><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/microsoft-70-466-faq\/\" target=\"_blank\" rel=\"noreferrer noopener\">Microsoft 70-466 FAQ<\/a><\/strong><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/microsoft-70-466-faq\/\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"400\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/09\/ArcGIS-Desktop-Entry-EADE-19-001-2.png\" alt=\"Microsoft Exam 70-466 FAQ\" class=\"wp-image-21841\"\/><\/a><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Course Outline: Microsoft 70-466 exam<\/strong><\/h3>\n\n\n\n<p>The Official Exam Guide covers the descriptive details about the exam domains. These domains cover various subtopics. This is to help candidates prepare for the exam by identifying specific content within each topic that may be tested. Further, there are 4 domains in this exam-<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Domain 1- Build an analysis services multidimensional database (35-40%)<\/strong><\/h4>\n\n\n\n<p><strong>Design dimensions and measures<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>given a requirement, identify the dimension\/measure group relationship that should be selected (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models-olap-logical-cube-objects\/dimension-relationships?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Dimension Relationships<\/a>)<\/li><li>design patterns for representing business facts and dimensions (many-to-many relationships) (<strong>Microsoft Documentation:<\/strong> &nbsp;<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 dimensions to support multiple related measure groups (many related fact tables)<\/li><li>handle degenerate dimensions in a cube (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/error-configuration-for-cube-partition-and-dimension-processing?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Error Configuration for Cube, Partition, and Dimension Processing<\/a>)<\/li><li>identify the attributes for dimensions (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/dimension-attribute-properties-reference?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Dimension Attribute Properties Reference<\/a>)<\/li><li>identify the measures (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/measures-and-measure-groups?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Measures and Measure Groups<\/a>)<\/li><li>aggregation behavior for the measures (<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><li>build hierarchies <\/li><li>define the granularity of dimension relationships. (<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><\/ul>\n\n\n\n<p><strong>Implement and configure dimensions in a cube<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>translations (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/translations-in-multidimensional-models-analysis-services?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Translations in Multidimensional Models (Analysis Services)<\/a>)<\/li><li>define attribute relationships (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/attribute-relationships-define?view=asallproducts-allversions#:~:text=To%20define%20unique%20attribute%20relationships,member%20in%20a%20related%20attribute.\" target=\"_blank\" rel=\"noreferrer noopener\">Attribute Relationships<\/a>)<\/li><li>implement hierarchies (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models-olap-logical-dimension-objects\/user-hierarchies?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">User Hierarchies<\/a>)<\/li><li>implement SQL Server Analysis Services (SSAS) dimensions and cubes (<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>)<\/li><li>create the Attribute Relationships that should be made for a given set of attributes in a dimension (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/attribute-relationships-define?view=asallproducts-allversions#:~:text=To%20define%20unique%20attribute%20relationships,member%20in%20a%20related%20attribute.\" target=\"_blank\" rel=\"noreferrer noopener\">Attribute Relationships<\/a>)<\/li><li>develop new custom attributes on dimensions (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/bi-wizard-custom-member-formulas-for-attributes-in-a-dimension?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Custom Member Formulas for Attributes in a Dimension<\/a>)<\/li><li>detect possible design flaws in attribute relationships <\/li><li>implement time dimensions in cubes (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/define-time-intelligence-calculations-using-the-business-intelligence-wizard?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Define Time Intelligence Calculations using the Business Intelligence Wizard<\/a>)<\/li><li>manage SSAS parent-child dimensions (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/database-dimensions-finance-account-of-parent-child-type?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Database Dimensions &#8211; Finance Account of parent-child type<\/a>)<\/li><li>dimension type (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models-olap-logical-dimension-objects\/database-dimension-properties-types?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Database Dimension Properties &#8211; Types<\/a>)<\/li><\/ul>\n\n\n\n<p><strong>Design a schema to support cube architecture<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>multidimensional modeling starting from a star schema<\/li><li>relational modeling for a data source view (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/defining-a-data-source-view-analysis-services?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Defining a Data Source View (Analysis Services)<\/a>)<\/li><li>choose or create a topology <\/li><li>identify the appropriate data types with correct precision and size (<strong>Microsoft Documentation:<\/strong> <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>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/olap-physical\/data-types-in-analysis-services?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Data Types in Analysis Services<\/a>)<\/li><\/ul>\n\n\n\n<p><strong>Create and configure measures<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>logically group measures and configure Measure Group Properties (<strong>Microsoft Documentation: <\/strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/configure-measure-group-properties?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Configure Measure Group Properties<\/a>)<\/li><li>select appropriate aggregation functions (<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><li>format measures (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-tutorial\/lesson-3-1-modifying-measures?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Modifying Measures<\/a>)<\/li><li>design the measure group for the correct granularity (<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><\/ul>\n\n\n\n<p><strong>Implement a cube<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>use SQL Server Data Tools &#8211; Business Intelligence (SSDT-BI) to build the cube (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/creating-multidimensional-models-using-sql-server-data-tools-ssdt?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Creating Multidimensional Models Using SQL Server Data Tools<\/a>, <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>use SSDTBI to do non-additive or semi-additive measures in a cube (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/define-semiadditive-behavior?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Define Semiadditive Behavior<\/a>)<\/li><li>define measures (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/measures-and-measure-groups?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Measures and Measure Groups<\/a>)<\/li><li>specify perspectives (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-tutorial\/lesson-9-1-defining-and-browsing-perspectives?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Defining and Browsing Perspectives<\/a>)<\/li><li>define translations (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/translations-in-multidimensional-models-analysis-services?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Translations in Multidimensional Models (Analysis Services)<\/a>)<\/li><li>define dimension usage (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models-olap-logical-cube-objects\/dimension-relationships?view=asallproducts-allversions#:~:text=Dimension%20usage%20defines%20the%20relationships,measure%20groups%20in%20a%20cube.&amp;text=A%20cube%20can%2C%20and%20frequently,another%20dimension%20or%20measure%20group.\" target=\"_blank\" rel=\"noreferrer noopener\">Dimension Relationships<\/a>)<\/li><li>define cube-specific dimension properties (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/define-cube-dimension-properties?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Define Cube Dimension Properties<\/a>)<\/li><li>define measure groups (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/measures-and-measure-groups?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Measures and Measure Groups<\/a>)<\/li><li>implement reference dimensions (<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>)<\/li><li>implement many-to-many relationships (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/define-a-many-to-many-relationship-and-many-to-many-relationship-properties?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Define a Many-to-Many Relationship and Many-to-Many Relationship Properties<\/a>)<\/li><li>implement fact relationships (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-tutorial\/lesson-5-2-defining-a-fact-relationship?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Defining a Fact Relationship<\/a>)<\/li><li>implement role-playing relationships<\/li><li>create and manage linked measure groups and linked dimensions (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/linked-measure-groups?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Linked Measure Groups<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/define-linked-dimensions?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Linked Dimensions<\/a>)<\/li><li>create actions<\/li><\/ul>\n\n\n\n<p><strong>Create Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX) queries<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>identify the structures of MDX and the common functions (tuples, sets, TopCount, SCOPE, 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>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/mdx\/topcount-mdx?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">TopCount (MDX)<\/a>)<\/li><li>identify which MDX statement would return the required result (<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>implement a custom MDX or logical solution for a pre-prepared case task <\/li><li>identify the structure of DAX and common functions, including CALCULATE, EVALUATE, and FILTER (<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>identify which DAX query would return the required result (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/dax\/dax-overview\" target=\"_blank\" rel=\"noreferrer noopener\">DAX overview<\/a>)<\/li><\/ul>\n\n\n\n<p><strong>Implement storage design in a multidimensional model<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><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><li>create partitions, storage modes (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models-olap-logical-cube-objects\/partitions-partition-storage-modes-and-processing?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Partitions &#8211; Partition Storage Modes and Processing<\/a>)<\/li><li>define proactive caching (<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#:~:text=Proactive%20caching%20provides%20automatic%20MOLAP%20cache%20creation%20and%20management%20for%20OLAP%20objects.&amp;text=The%20timing%20specification%20defines%20the,table%20and%20the%20ProactiveCaching%20object.\" target=\"_blank\" rel=\"noreferrer noopener\">Partitions &#8211; Proactive Caching<\/a>)<\/li><li>manage write-back partitions (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/set-partition-writeback?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Set Partition Writeback<\/a>)<\/li><li>implement linked cubes (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/linked-measure-groups?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Linked Measure Groups<\/a>)<\/li><li>implement distributed cubes<\/li><\/ul>\n\n\n\n<p><strong>Select an appropriate model for data analysis<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>select Tabular versus Multidimensional based on scalability needs (<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>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/instances\/high-availability-and-scalability-in-analysis-services?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">High availability and Scalability in Analysis Services<\/a>)<\/li><li>traditional hierarchical, data volume <\/li><li>select appropriate organizational BI, such as corporate BI, and team and personal BI needs and data status (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/admin\/service-admin-licensing-organization\" target=\"_blank\" rel=\"noreferrer noopener\">Licensing the Power BI service for users in your organization<\/a>)<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Domain 2- Manage, maintain, and troubleshoot a SQL Server Analysis Services (SSAS) database (15-20%)<\/strong><\/h4>\n\n\n\n<p><strong>Analyze data model performance<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>identify the performance consequences of data source view design (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/defining-a-data-source-view-analysis-services?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Defining a Data Source View (Analysis Services)<\/a>)<\/li><li>optimize performance by changing the design of the cube or dimension (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-tutorial\/lesson-2-4-reviewing-cube-and-dimension-properties?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Reviewing Cube and Dimension Properties<\/a>)<\/li><li>analyze and optimize the performances of an MDX\/DAX query (<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>optimize queries for huge data sets <\/li><li>optimize MDX in the calculations (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/mdx\/mdx-scripting-fundamentals-analysis-services?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">MDX Scripting Fundamentals (Analysis Services)<\/a>)<\/li><li>performance monitor counters <\/li><li>select appropriate Dynamic Management Views for Analysis Services (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/instances\/use-dynamic-management-views-dmvs-to-monitor-analysis-services?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Dynamic Management Views (DMVs)<\/a>)<\/li><li>analyze and define performance counters (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/instances\/performance-counters-ssas?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Performance counters<\/a>)<\/li><li>monitor growth of the cache <\/li><li>define and view logging options (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/server-properties\/log-properties?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Log Properties<\/a>)<\/li><\/ul>\n\n\n\n<p><strong>Process data models<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>define processing of tables or partitions for tabular and multidimensional models (<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\/partitions-in-multidimensional-models?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Partitions in Multidimensional Models<\/a>)<\/li><li>define the processing of databases, cubes, and dimensions for multidimensional models (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/processing-analysis-services-objects?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Processing Analysis Services Objects<\/a>)<\/li><li>select full processing versus incremental processing (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/tabular-models\/process-database-table-or-partition-analysis-services?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Process database, table, or partition (Analysis Services)<\/a>)<\/li><li>define remote processing (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/remote-processing-analysis-services?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Remote Processing (Analysis Services)<\/a>)<\/li><li>define lazy aggregations (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/server-properties\/olap-properties?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">OLAP properties<\/a>)<\/li><li>automate with Analysis Management Objects (AMO) or XML for Analysis (XMLA) (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/xmla\/xml-for-analysis-xmla-reference?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">XML for Analysis (XMLA) Reference<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Analysis Services documentation<\/a>)<\/li><li>process and manage partitions by using PowerShell (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/powershell\/analysis-services-powershell-reference?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Analysis Services PowerShell Reference<\/a>)<\/li><\/ul>\n\n\n\n<p><strong>Troubleshoot data analysis issues<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>use SQL Profiler (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/instances\/use-sql-server-profiler-to-monitor-analysis-services?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Monitor Analysis Services with SQL Server Profiler<\/a>)<\/li><li>troubleshoot duplicate key dimension processing errors (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/error-configuration-for-cube-partition-and-dimension-processing?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Error Configuration for Cube, Partition, and Dimension Processing<\/a>)<\/li><li>error logs and event viewer logs of SSAS (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/instances\/log-operations-in-analysis-services?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Log operations in Analysis Services<\/a>)<\/li><li>mismatch of data<\/li><li>incorrect relationships or aggregations (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/attribute-relationships-define?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Attribute Relationships &#8211; Define<\/a>)<\/li><li>dynamic security issues <\/li><li>validate logic and calculations (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/tabular-models\/calculation-groups?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Calculation groups<\/a>)<\/li><\/ul>\n\n\n\n<p><strong>Deploy SSAS databases<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>deployment Wizard, implement SSDT-BI, deploy SSMS (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/deployment\/deploy-model-solutions-using-the-deployment-wizard?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Deploy solutions by using the Deployment Wizard<\/a>)<\/li><li>test solution post-deployment, decide whether or not to process, test different roles (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/grant-cube-or-model-permissions-analysis-services?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Grant cube or model permissions (Analysis Services)<\/a><a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/deployment\/deploy-model-solutions-using-the-deployment-wizard?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">)<\/a><\/li><\/ul>\n\n\n\n<p><strong>Install and maintain an SSAS instance<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>install SSAS (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-tutorial\/install-sample-data-and-projects?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Install sample data and multidimensional projects<\/a>)<\/li><li>install development tools <\/li><li>identify development and production installation considerations <\/li><li>upgrade SSAS instance (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/database-engine\/install-windows\/upgrade-analysis-services?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Upgrade Analysis Services<\/a>)<\/li><li>define data file and program file location <\/li><li>plan for Administrator accounts (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/grant-database-permissions-analysis-services?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Grant database permissions (Analysis Services)<\/a>)<\/li><li>define server and database level security<\/li><li>support scale-out read-only (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/analysis-services\/analysis-services-scale-out\" target=\"_blank\" rel=\"noreferrer noopener\">Azure Analysis Services scale-out<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/dynamics365\/business-central\/dev-itpro\/administration\/database-read-scale-out-overview\" target=\"_blank\" rel=\"noreferrer noopener\">Using Read Scale-Out for Better Performance<\/a>)<\/li><li>update SSAS (service packs)<\/li><li>install and maintain each instance type of Analysis Services, including PowerPivot (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/instances\/determine-the-server-mode-of-an-analysis-services-instance?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Determine the Server Mode of an Analysis Services Instance<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/instances\/install-windows\/install-analysis-services-in-power-pivot-mode?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Install Analysis Services in Power Pivot Mode<\/a>)<\/li><li>restore and import PowerPivot (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/tabular-models\/import-from-power-pivot-ssas-tabular?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Import from Power Pivot<\/a>)<\/li><li>back up and restore by using PowerShell <\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Domain 3- Build a tabular data model (15-20%)<\/strong><\/h4>\n\n\n\n<p><strong>Configure permissions and roles in a tabular model<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>configure server roles (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/roles-and-permissions-analysis-services?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Roles and Permissions (Analysis Services)<\/a>)<\/li><li>configure SSAS database roles (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/olap-logical\/security-roles-analysis-services-multidimensional-data?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Security Roles (Analysis Services &#8211; Multidimensional Data)<\/a>)<\/li><li>implement dynamic security (custom security approaches) (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/authorizing-access-to-objects-and-operations-analysis-services?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Authorizing access to objects and operations (Analysis Services)<\/a>)<\/li><li>role-based access (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/roles-and-permissions-analysis-services?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Roles and Permissions (Analysis Services)<\/a>)<\/li><li>test security permissions (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/roles-and-permissions-analysis-services?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Roles and Permissions (Analysis Services)<\/a>)<\/li><li>implement cell-level permissions (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/grant-custom-access-to-cell-data-analysis-services?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Grant custom access to cell data (Analysis Services)<\/a>)<\/li><\/ul>\n\n\n\n<p><strong>Implement a tabular data model<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>define tables (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/create-a-dimension-by-using-an-existing-table?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Create a Dimension by Using an Existing Table<\/a>)<\/li><li>import data (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/mdx\/multidimensional-model-data-access-analysis-services-multidimensional-data?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Multidimensional Model Data Access (Analysis Services &#8211; Multidimensional Data)<\/a>)<\/li><li>define calculated columns (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-tutorial\/lesson-6-1-defining-calculated-members?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Defining Calculated Members<\/a>)<\/li><li>define relationships (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models-olap-logical-cube-objects\/dimension-relationships?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Dimension Relationships<\/a>)<\/li><li>define hierarchies and perspectives (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models-olap-logical-dimension-objects\/attributes-and-attribute-hierarchies?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Attributes and Attribute Hierarchies<\/a>)<\/li><li>manage the visibility of columns and tables <\/li><li>embed links (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/deployment\/multidimensional-model-solution-deployment?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Multidimensional Model Solution Deployment<\/a>)<\/li><li>optimize BISM for Power View <\/li><li>mark a date table (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/tabular-models\/specify-mark-as-date-table-for-use-with-time-intelligence-ssas-tabular?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Specify Mark as Date Table for use with time intelligence<\/a>)<\/li><li>sort a column by another column (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/tabular-models\/sort-data-in-a-table-ssas-tabular?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Sort Data in a Table<\/a>)<\/li><\/ul>\n\n\n\n<p><strong>Implement business logic in a tabular data model<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>implement measures and KPIs (<strong>Microsoft Documentation: <\/strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/key-performance-indicators-kpis-in-multidimensional-models?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Key Performance Indicators (KPIs) in Multidimensional Models<\/a>)<\/li><li>implement Data Analysis Expressions (DAX) <\/li><li>define relationship navigation<\/li><li>implement time intelligence (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/define-time-intelligence-calculations-using-the-business-intelligence-wizard?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Define Time Intelligence Calculations using the Business Intelligence Wizard<\/a>)<\/li><li>implement context modification (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/extending-olap\/analysis-services-personalization-extensions?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Analysis Services Personalization Extensions<\/a>)<\/li><\/ul>\n\n\n\n<p><strong>Implement data access for a tabular data model<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>manage partitions (<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>processing (<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><li>select xVelocity versus DirectQuery for the data access (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/tabular-models\/directquery-mode-ssas-tabular?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">DirectQuery mode in tabular models<\/a>)<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Domain 4- Build a report with SQL Server Reporting Services (SSRS) (25-30%)<\/strong><\/h4>\n\n\n\n<p><strong>Design a report<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>select report components (crosstab report, Tablix, design chart, data visualization components) <\/li><li>design report templates (Report Definition Language) (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/reports\/report-definition-language-ssrs?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Report Definition Language (SSRS)<\/a>)<\/li><li>identify the data source and parameters (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/set-data-source-properties-ssas-multidimensional?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Set Data Source Properties (SSAS Multidimensional)<\/a>)<\/li><li>design a grouping structure (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-tutorial\/lesson-4-3-automatically-grouping-attribute-members?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Automatically Grouping Attribute Members<\/a>)<\/li><li>drill-down reports <\/li><li>drill-through reports (<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>determine if any expressions are required to display data that is not coming directly from the data source (<strong>Microsoft Documentation:<\/strong> <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><\/ul>\n\n\n\n<p><strong>Implement a report layout<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>formatting (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-tutorial\/lesson-3-1-modifying-measures?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Modifying Measures<\/a>)<\/li><li>apply conditional formatting (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/create-reports\/desktop-conditional-table-formatting\" target=\"_blank\" rel=\"noreferrer noopener\">Use conditional formatting in tables<\/a>)<\/li><li>page configuration<\/li><li>implement headers and footers <\/li><li>implement matrixes, table, chart, images, list, indicators, maps, and groupings in reports (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/report-design\/tables-matrices-and-lists-report-builder-and-ssrs?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Tables, Matrices, and Lists (Report Builder and SSRS)<\/a>)<\/li><li>use Report Builder to implement a report layout (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/dynamics365\/business-central\/dev-itpro\/developer\/devenv-howto-rdl-report-layout\" target=\"_blank\" rel=\"noreferrer noopener\">Creating an RDL Layout Report<\/a>)<\/li><li>create a range of reports using different data regions (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/report-design\/data-regions-and-maps-report-builder-and-ssrs?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Data Regions and Maps (Report Builder and SSRS)<\/a>)<\/li><li>define custom fields (implementing different parts of the report)<\/li><li>implement collections (global collections) <\/li><li>define expressions (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/report-design\/expression-examples-report-builder-and-ssrs?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Expression Examples (Report Builder and SSRS)<\/a>)<\/li><li>implement data visualization components<\/li><li>identify report parts (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/report-design\/report-parts-report-builder-and-ssrs?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Report Parts (Report Builder and SSRS)<\/a>)<\/li><li>implement group variables and report variables (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/report-design\/built-in-collections-report-and-group-variables-references-report-builder?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Built-in Collections &#8211; Report and Group Variables References (Report Builder)<\/a>)<\/li><li>design for multiple delivery extension formats (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/report-server-web-service\/net-framework\/reporting-services-delivery-extension-settings?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Reporting Services Delivery Extension Settings<\/a>)<\/li><\/ul>\n\n\n\n<p><strong>Configure authentication and authorization for a reporting solution<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>configure server-level and item-level role-based security (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/security\/role-definitions-predefined-roles?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Role definitions &#8211; predefined roles<\/a>)<\/li><li>configure reporting service security (setup or addition of role) (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/security\/grant-user-access-to-a-report-server?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Grant user access to a report server<\/a>)<\/li><li>authenticate against data source, store credential information <\/li><li>describe Report Server security architecture and site-level security <\/li><li>create system-level roles, item-level security (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/security\/role-definitions-predefined-roles?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Role definitions &#8211; predefined roles<\/a>)<\/li><li>create a new role assignment <\/li><li>assign Windows users to roles, secure reports using roles (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/security\/grant-user-access-to-a-report-server?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Grant user access to a report server<\/a>)<\/li><li>configure SharePoint groups and permissions (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sharepoint\/customize-sharepoint-site-permissions\" target=\"_blank\" rel=\"noreferrer noopener\">SharePoint site permissions<\/a>)<\/li><li>define varying content for different role memberships (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/exchange\/permissions\/role-groups?view=exchserver-2019\" target=\"_blank\" rel=\"noreferrer noopener\">Manage role groups<\/a>)<\/li><\/ul>\n\n\n\n<p><strong>Implement interactivity in a report<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>drill down<\/li><li>drill through (<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>interactive sorting (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/report-design\/add-interactive-sort-to-a-table-or-matrix-report-builder-and-ssrs?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Add Interactive Sort to a Table or Matrix (Report Builder and SSRS)<\/a>)<\/li><li>parameters: (databound parameters, multivalue parameters) (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/report-design\/add-a-multi-value-parameter-to-a-report?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Add a multi-value parameter to a Report<\/a>)<\/li><li>create dynamic reports in SSRS using parameters (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/report-design\/report-parameters-report-builder-and-report-designer?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Report Parameters (Report Builder and Report Designer)<\/a>)<\/li><li>implement show\/hide property<\/li><li>actions (jump to report) <\/li><li>filters (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/report-data\/add-a-filter-to-a-dataset-report-builder-and-ssrs?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Add a Filter to a Dataset (Report Builder and SSRS)<\/a>)<\/li><li>parameter list (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/report-design\/report-parameters-report-builder-and-report-designer?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Report Parameters (Report Builder and Report Designer)<\/a>)<\/li><li>fixed headers (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/report-design\/page-headers-and-footers-report-builder-and-ssrs?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Page Headers and Footers (Report Builder and SSRS)<\/a>)<\/li><li>document map, embedded HTML (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/report-design\/create-a-document-map-report-builder-and-ssrs?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Create a Document Map (Report Builder and SSRS)<\/a>)<\/li><\/ul>\n\n\n\n<p><strong>Troubleshoot reporting services issue<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>query the ReportServer database (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/report-server\/report-server-database-ssrs-native-mode?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Report Server Database (SSRS Native Mode)<\/a>)<\/li><li>view Reporting Services log files (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/report-server\/reporting-services-log-files-and-sources?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Reporting Services Log Files and Sources<\/a>)<\/li><li>use Windows Reliability and Performance monitor data for troubleshooting <\/li><li>use the ReportServer: define service and web service objects (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/report-server-web-service\/methods\/report-server-web-service-endpoints?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Report Server Web Service Endpoints<\/a>)<\/li><li>monitor for long-running reports, rendering, and connectivity issues (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/report-server\/process-large-reports?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Process Large Reports<\/a>)<\/li><li>use SQL Profiler (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/instances\/use-sql-server-profiler-to-monitor-analysis-services?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Monitor Analysis Services with SQL Server Profiler<\/a>)<\/li><li>perform data reconciliation for incorrect relationships or aggregations <\/li><li>detect dynamic security issues <\/li><li>validate logic and calculations <\/li><\/ul>\n\n\n\n<p><strong>Manage a report environment<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>manage subscriptions and subscription settings (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/subscriptions\/subscriptions-and-delivery-reporting-services?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Subscriptions and Delivery (Reporting Services)<\/a>)<\/li><li>define data-driven subscriptions (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/subscriptions\/data-driven-subscriptions?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Data-Driven Subscriptions<\/a>)<\/li><li>manage data sources (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/report-data\/manage-report-data-sources?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Manage Report Data Sources<\/a>)<\/li><li>integrate SharePoint Server (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/report-server-sharepoint\/reporting-services-report-server-sharepoint-mode?view=sql-server-2016\" target=\"_blank\" rel=\"noreferrer noopener\">Reporting Services Report Server (SharePoint Mode)<\/a>)<\/li><li>define email delivery settings (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/subscriptions\/e-mail-delivery-in-reporting-services?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">E-Mail Delivery in Reporting Services<\/a>)<\/li><li>manage the number of snapshots (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/report-server\/create-modify-and-delete-snapshots-in-report-history?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Create, Modify, and Delete Snapshots in Report History<\/a>)<\/li><li>manage schedules, running jobs, and report server logs (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/subscriptions\/create-modify-and-delete-schedules?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Create, Modify, and Delete Schedules<\/a>)<\/li><li>manage report server databases (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/report-server\/report-server-database-ssrs-native-mode?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Report Server Database (SSRS Native Mode)<\/a>)<\/li><li>manage the encryption keys<\/li><li>set up the execution log reporting (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/report-server\/report-server-executionlog-and-the-executionlog3-view?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Report Server ExecutionLog and the ExecutionLog3 View<\/a>)<\/li><li>review the reports <\/li><li>configure site-level settings (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/report-server-sharepoint\/site-settings-and-features-reporting-services?view=sql-server-2016\" target=\"_blank\" rel=\"noreferrer noopener\">Reporting Services site settings and site features (SharePoint mode)<\/a>)<\/li><li>design report lifecycle <\/li><li>automate the management of reporting services (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/tools\/reporting-services-tools?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Reporting Services Tools<\/a>)<\/li><li>create a report organization structure (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/dynamics365\/finance\/cost-accounting\/tasks\/create-an-organization-report-hierarchy\" target=\"_blank\" rel=\"noreferrer noopener\">Create an organization report hierarchy<\/a>)<\/li><li>install and configure reporting services (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/install-windows\/install-reporting-services?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Install SQL Server Reporting Services<\/a>)<\/li><li>deploy custom assemblies (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/custom-assemblies\/deploying-a-custom-assembly?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Deploying a Custom Assembly<\/a>)<\/li><\/ul>\n\n\n\n<p><strong>Configure report data sources and datasets<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>select appropriate query types (stored procedure versus table versus text only) (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/report-data\/text-based-query-designer-user-interface-report-builder?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Text-based Query Designer User Interface (Report Builder)<\/a>)<\/li><li>configure parameterized connection strings (dynamic connection strings) (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/report-data\/data-connections-data-sources-and-connection-strings-report-builder-and-ssrs?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Create data connection strings &#8211; Report Builder &amp; SSRS<\/a>)<\/li><li>define filter location (dataset versus query) (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/report-design\/filter-group-and-sort-data-report-builder-and-ssrs?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Filter, Group, and Sort Data (Report Builder and SSRS)<\/a>)<\/li><li>configure data source options, for example, extract and connect to multiple data sources (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/report-data\/create-modify-and-delete-shared-data-sources-ssrs?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Create, Modify, and Delete Shared Data Sources (SSRS)<\/a>)<\/li><li>shared and embedded data sources and datasets (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/report-data\/embedded-and-shared-datasets-report-builder-and-ssrs?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Embedded and Shared Datasets (Report Builder and SSRS)<\/a>)<\/li><li>use custom expressions in data sources (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/report-design\/expression-uses-in-reports-report-builder-and-ssrs?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Expression Uses in Reports (Report Builder and SSRS)<\/a>)<\/li><li>connect to Microsoft Azure SQL database<\/li><li>implement DAX and MDX queries to retrieve appropriate data sets (<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>work with non-relational data sources, such as XML or SharePoint lists  (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/report-data\/data-sources-supported-by-reporting-services-ssrs?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Data Sources Supported by Reporting Services (SSRS)<\/a>)<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Preparatory Guide for Microsoft Exam 70-466 <\/strong><\/h2>\n\n\n\n<p>The key to successfully pass an exam is by preparing right. Preparations demand consistency and determination. There are plenty resources available, for your preparations. You must have the right information and tools to crack the exam. We present you our specially curated preparatory guide to help you achieve the Microsoft 70-466 Exam Certification in the very first attempt. Let\u2019s discuss step by step.<\/p>\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\/Microsoft-70-466.png\" alt=\"70-466 preparatory guie\" class=\"wp-image-21842\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/09\/Microsoft-70-466.png 800w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/09\/Microsoft-70-466-160x400.png 160w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/figure><\/div>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Step 1 &#8211; Refer the Official <strong>Microsoft 70-466<\/strong><\/strong> <strong>Exam Guide<\/strong><\/h4>\n\n\n\n<p>Firstly start off by visiting the&nbsp;<a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/certifications\/exams\/70-466?tab=tab-learning-paths\" target=\"_blank\" rel=\"noreferrer noopener\">official website of Microsoft<\/a>. This is a smarter move because you should always go by the most trusted website to get the authentic information. You can easily locate all the information regarding the 70-466 exam. From exam pattern to all the included modules and study materials are covered on the portal itself. Familiarise yourself with all the objectives and course domains of the exam. Devote enough time to each topic and have in depth knowledge of the subject. Moreover, this will also result in strengthening your preparation.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Step 2 &#8211; Study the traditional way through books<\/strong><\/h4>\n\n\n\n<p>Books are the most important ingredient of preparation. Books are a good resource to acquire knowledge without any disturbance. There are a vast variety of books available in the market which you can use to prepare for the Microsoft 70-466 Exam. Therefore, our suggestion to you would be to find books for the Microsoft 70-466 exam from genuine sources.&nbsp; <\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Step 3 &#8211; Go for Training Course<\/strong><\/h4>\n\n\n\n<p>Microsoft provides its own Training Courses for the preparation of this Exam.&nbsp; We know that being a practical exam, it requires hands on training. To solve this issue Microsoft has come up instructor led training course.<\/p>\n\n\n\n<p>The Microsoft instructor led training is similar to the traditional classroom training setting. It features IT experts with in-depth knowledge of the 70-466 exam objectives to help you pass your exam at the first attempt.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/certifications\/courses\/20466\" target=\"_blank\" rel=\"noreferrer noopener\">Course 20466-D: Implementing Data Models and Reports with SQL Server 2014<\/a><\/strong><\/h5>\n\n\n\n<p>The focus of this five-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement multidimensional and tabular data models, deliver reports with Microsoft SQL Server Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining.<\/p>\n\n\n\n<p><strong>Skills gained<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\" id=\"skills-gained\"><li>Firstly, Describe the components, architecture, and nature of a BI solution.<\/li><li>Secondly, Create a multidimensional database with Analysis Services.<\/li><li>Thirdly, Implement dimensions in a cube.<\/li><li>Implement measures and measure groups in a cube.<\/li><li>Also, UseMDX Syntax.<\/li><li>Further, Customize a cube.<\/li><li>Furthermore, Implement a Tabular Data Model in SQL Server Analysis Services.<\/li><li>Moreover, UseDAX to enhance a tabular model.<\/li><li>Additionally, Create reports with Reporting Services.<\/li><li>Not to mention,  Enhance reports with charts and parameters.<\/li><li>Likewise, Manage report execution and delivery.<\/li><li>Then, Implement a dashboard in SharePoint Server with PerformancePoint Services.<\/li><li>Lastly, Use Data Mining for Predictive Analysis.<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Step 4 &#8211; Join Online Forums<\/strong><\/h4>\n\n\n\n<p>Joining a forum is an excellent way of preparing for an exam. You\u2019ll get to connect with other likeminded individuals preparing for the same exam. Such groups allow you and others to share tips, doubts, experiences and challenges with each other. You get to learn from the expertise of your peers and therefore joining a community is an important step while preparing.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Step 5 &#8211; Practice Tests<\/strong><\/h4>\n\n\n\n<p>Practice tests are significant to familiarise yourself with the exam format. They keep your preparations under check and are a great way to identify gaps in your knowledge that you can work upon. Further, practice tests provide exact insights about the exam. Also attempting multiple practice tests help you prepare well. There are plenty of practice tests available. Remember to choose the right and authentic ones. <a rel=\"noreferrer noopener\" href=\"https:\/\/www.testpreptraining.ai\/implementing-data-models-and-reports-with-microsoft-sql-server-2012-70-466-free-practice-test\" target=\"_blank\">Start practising for Microsoft 70-466 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\/implementing-data-models-and-reports-with-microsoft-sql-server-2012-70-466-free-practice-test\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/09\/1Z0-1054-20-2-750x117.png\" alt=\"70-466 practice tests\" class=\"wp-image-21847\" width=\"951\" height=\"150\"\/><\/a><\/figure><\/div>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Boost your career by qualifying for the Microsoft 70-466: Implementing Data Models and Reports with Microsoft SQL Server exam. <a href=\"https:\/\/www.testpreptraining.ai\/implementing-data-models-and-reports-with-microsoft-sql-server-2012-70-466\" target=\"_blank\" rel=\"noreferrer noopener\">Start Preparing Now!<\/a><\/strong><\/h5>\n","protected":false},"excerpt":{"rendered":"<p>The Microsoft 70-466: Implementing Data Models and Reports with Microsoft SQL Server 70-466&nbsp;is specifically for participants to gain the knowledge and skills for making the appropriate job role decisions around implementing data models and reports with Microsoft SQL Server 2012.&nbsp;Achieving this certification puts you in an advantageous position and helps you gain mastery of Microsoft&#8230;<\/p>\n","protected":false},"author":1,"featured_media":21863,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"categories":[1226,5729],"tags":[2818,2817,2815,4],"class_list":["post-21804","page","type-page","status-publish","has-post-thumbnail","hentry","category-microsoft","category-server","tag-70-466-preparatory-guide","tag-70-466-tutorials","tag-implementing-data-models-and-reports-with-microsoft-sql-server-2012-exam-guide","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-466: Implementing Data Models and Reports<\/title>\n<meta name=\"description\" content=\"Enhance your skills with Microsoft 70-466: Implementing Data Models and Reports with Microsoft SQL Server exam. Try Free Test Now!\" \/>\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\/exam-70-466-implementing-data-models-and-reports-with-microsoft-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Exam 70-466: Implementing Data Models and Reports\" \/>\n<meta property=\"og:description\" content=\"Enhance your skills with Microsoft 70-466: Implementing Data Models and Reports with Microsoft SQL Server exam. Try Free Test Now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-466-implementing-data-models-and-reports-with-microsoft-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Testprep Training Tutorials\" \/>\n<meta property=\"article:modified_time\" content=\"2021-05-27T13:22:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/09\/ArcGIS-Desktop-Entry-EADE-19-001-1-2.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=\"18 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-466-implementing-data-models-and-reports-with-microsoft-sql-server\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-466-implementing-data-models-and-reports-with-microsoft-sql-server\/\",\"name\":\"Exam 70-466: Implementing Data Models and Reports\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\"},\"datePublished\":\"2020-09-25T09:10:03+00:00\",\"dateModified\":\"2021-05-27T13:22:55+00:00\",\"description\":\"Enhance your skills with Microsoft 70-466: Implementing Data Models and Reports with Microsoft SQL Server exam. Try Free Test Now!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-466-implementing-data-models-and-reports-with-microsoft-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-466-implementing-data-models-and-reports-with-microsoft-sql-server\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-466-implementing-data-models-and-reports-with-microsoft-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Exam 70-466: Implementing Data Models and Reports with Microsoft SQL Server\"}]},{\"@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-466: Implementing Data Models and Reports","description":"Enhance your skills with Microsoft 70-466: Implementing Data Models and Reports with Microsoft SQL Server exam. Try Free Test Now!","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\/exam-70-466-implementing-data-models-and-reports-with-microsoft-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"Exam 70-466: Implementing Data Models and Reports","og_description":"Enhance your skills with Microsoft 70-466: Implementing Data Models and Reports with Microsoft SQL Server exam. Try Free Test Now!","og_url":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-466-implementing-data-models-and-reports-with-microsoft-sql-server\/","og_site_name":"Testprep Training Tutorials","article_modified_time":"2021-05-27T13:22:55+00:00","og_image":[{"width":750,"height":400,"url":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/09\/ArcGIS-Desktop-Entry-EADE-19-001-1-2.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"18 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-466-implementing-data-models-and-reports-with-microsoft-sql-server\/","url":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-466-implementing-data-models-and-reports-with-microsoft-sql-server\/","name":"Exam 70-466: Implementing Data Models and Reports","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website"},"datePublished":"2020-09-25T09:10:03+00:00","dateModified":"2021-05-27T13:22:55+00:00","description":"Enhance your skills with Microsoft 70-466: Implementing Data Models and Reports with Microsoft SQL Server exam. Try Free Test Now!","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-466-implementing-data-models-and-reports-with-microsoft-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-466-implementing-data-models-and-reports-with-microsoft-sql-server\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-466-implementing-data-models-and-reports-with-microsoft-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Exam 70-466: Implementing Data Models and Reports with Microsoft SQL Server"}]},{"@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\/21804","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=21804"}],"version-history":[{"count":19,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/21804\/revisions"}],"predecessor-version":[{"id":22398,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/21804\/revisions\/22398"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media\/21863"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media?parent=21804"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/categories?post=21804"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/tags?post=21804"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}