Installing The Project Manual Sample Databases For Sql Server: Fill & Download for Free

There is no Training Kit for this exam (at least not yet), the official Microsoft course for this certification (Course 20466: Implementing Data Models and Reports with Microsoft® SQL Server®) is very useful, but it is not enough to pass the exam (the official courses never cover all the Microsoft certification exam topics).So, what can we do to pass this exam?This tip will give you links and tips for this very complex and difficult exam.If you are a beginner in SQL Server Business Intelligence or you do not have experience in the Microsoft Certification exams, we strongly recommend taking exam 70-463 first. The 70-466 exam is very complex and difficult.If you already passed exam 70-463, this tip is for you. We will give you advice, books and useful links for your exam.Here the links to SQL Server web sites, books, manuals:Design dimensions and measuresGiven a requirement, identify the dimension/measure group relationship that should be selected.SQL Server Analysis Services (SSAS) Tutorial.SQL Server Analysis Services Interview Questions Part I.SSAS Interview Questions on Measures, Actions, and Storage.Design patterns for representing business facts and dimensions (many-to-many relationships).Using Many-to-Many Relationships in Multidimensional SQL Server Analysis Services.SSAS Interview Questions on Measures, Actions, and Storage. Design dimensions to support multiple related measure groups (many related fact tables. What is the purpose of Dimension Usage settings? Explain different types of relationships between Facts and Dimensions.Defining a Many-to-Many RelationshipHandle degenerate dimensions in a cube.SQL Server Analysis Services Interview Questions Part II - Dimensions - What is a Degenerate Dimension in SQL Server Analysis Services? In what scenarios do you use it?Data Warehousing: Degenerate Dimensions.Defining a Fact Relationship.Identify the attributes for dimensions.Add an Attribute to a Dimension.Dimension Attribute Properties Reference.SQL Server Analysis Services Interview Questions Part II - DimensionsIdentify the measures.Measures and measure groups.SSAS Interview Questions on Measures, Actions, and Storage.Aggregation behavior for the measures.SQL Server Analysis Services Aggregation Designs.Define Semi additive BehaviorBuild hierarchies.SQL Server Analysis Services Attribute Relationships.Define granularity of dimension relationships.SQL Server Analysis Service Levels of Granularity.Implement and configure dimensions in a cubeTranslations.SQL Server Analysis Services Interview Questions on Dimensions, Hierarchies and Properties - What are Dimension Translations?Defining and Browsing TranslationsDefine attribute relationships.SQL Server Analysis Services Attribute Relationships.Attribute Relationships.Implement hierarchies.Creating a Hierarchy.Implement SQL Server Analysis Services (SSAS) dimensions and cubes.Build a Cube From an Existing Data Source Using SQL Server Analysis Services.Multidimensional Modeling (Adventure Works Tutorial).Create the Attribute Relationships that should be made for a given set of attributes in a dimension.Lesson 5: Defining Relationships Between Dimensions and Measure Groups.SQL Server Analysis Services Attribute Relationships.Develop new custom attributes on dimensions.Custom Attribute Names in Role Playing Dimensions for SSAS.Add an Attribute to a Dimension.Detect possible design flaws in attribute relationships.Analysis Service Performance GuideImplement time dimensions in cubes.Built in Time Dimension and Time Intelligence in SQL Server Analysis.SSAS Time Account Dimension Intelligence.Create a Time Dimension by Generating a Time Table.Manage SSAS parent-child dimensions.Parent-Child Dimensions.SQL Server Analysis Services Interview Questions Part II - Dimensions.Dimension types.SQL Server Analysis Services Interview Questions Part II - Dimensions.Design a schema to support cube architectureMultidimensional modeling starting from a star schema.Creating a Star Schema Using a Data Source View.Designing the Star Schema DatabaseRelational modeling for a data source view.DWH SchemasIntroduction to the SQLBI MethodologyChoose or create a topology.DWH SchemasIdentify the appropriate data types with correct precision and size.Data Types in Analysis Services.Tips for Optimizing SQL Server OLAP/Analysis Services: Data Warehouse and Datamart Performance.Create and configure measuresLogically group measures and configure Measure Group Properties.SSAS - Best Practices and Performance Optimization - Part 3 of 4.Measures and Measure Groups.Select appropriate aggregation functions.Use Aggregate Functions.Format measures.Configure Measure Properties.Design the measure group for the correct granularitySQL Server Analysis Service Levels of Granularity.Defining Dimension Granularity within a Measure Group.Implement a cubeUse SQL Server Data Tools - Business Intelligence (SSDT-BI) to build the cube.Multidimensional Modeling (Adventure Works Tutorial).Creating a Sample SSAS Project and CubeUse SSDT-BI to do non-additive or semi-additive measures in a cube.Define Semiadditive Behavior.Define measures.Defining a Cube.Creating a Cube using the Cube Wizard.Specify perspectives.Lesson 9: Defining Perspectives and Translations.SQL Server Analysis Services Perspectives.Define dimension usage.Dimension Relationships.Define cube-specific dimension properties.Lesson 4: Defining Advanced Attribute and Dimension Properties.Define measure groups.Create Measures and Measure Groups.Implement reference dimensions.Dimension Relationships.Implement many-to-many relationships.Dimension Relationships.Using Many-to-Many Relationships in Multidimensional SQL Server Analysis Services.Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques.Implement fact relationships.Dimension Relationships.Implement role-playing relationships.Defining Role Playing Dimensions for SQL Server Analysis Services.Create and manage linked measure groups and linked dimensions.Controlling the use of linked objects in SQL Server Analysis Services.Define Linked DimensionsCreate actions.Lesson 8: Defining Actions.Create Multidimensional Expressions (MDX) queriesIdentify the structures of MDX and the common functions (tuples, sets, TopCount, SCOPE, and more).Working with Members, Tuples, and Sets (MDX).MDX Basic ConceptsMultidimensional Expressions (MDX) ReferenceSQL Server Analysis Services (SSAS) 2012 Top and Bottom Functions.TopCount (MDX)MDX Function Reference (MDX).Identify which MDX statement would return the required result.MDX Function Reference (MDX)Implement a custom MDX or logical solution for a prepared case task.How to reduce MDX code redundancy in SQL Server Analysis Services SSAS.Order and Sort with MDX in SQL Server Analysis Services.MDX Function Reference (MDX)SQL Server Analysis Services Rank and Row Number Ordering.Analysis Services MOLAP Performance Guide for SQL Server 2012 and 2014 (section 2.4 and 3.3).Implement custom logic in a data modelDefine key performance indicators (KPIs).Testing KPIs for SQL Server Analysis Services.Lesson 7: Defining Key Performance Indicators (KPIs).Define calculated members.Defining Calculated Members.Create relative measures (growth, YoY, same period last year).Handling Relative Time Periods.Percentage of total using MDX.Using MDX to Calculate Both Values and Percentages for Analysis Services.MDX for Percent of Total for a subset of a Hierarchy.Named sets.Create Named Sets.Implement ranking and percentile.Rank (MDX).Ranking results from MDX queries.Define MDX script to import partial PowerPivot model.Analysis Services MDX Query Designer (Power Pivot).Implement storage design in a multidimensional modelCreate aggregations.SQL Server Analysis Services Aggregation Designs.Optimize a SQL Server Analysis Services Measure Group Partition for Performance.Aggregations and Aggregation Designs.Create partitions.How To Define Measure Group Partitions in SQL Server Analysis Services SSAS.Create and Manage a Local Partition (Analysis Services).Analysis Services MOLAP Performance Guide for SQL Server 2012 and 2014 (section 2.2).Storage modes.Partition Storage Modes and Processing.How To Implement Proactive Caching in SQL Server Analysis Services SSAS.Define proactive caching.How To Implement Proactive Caching in SQL Server Analysis Services SSAS.Proactive Caching (Partitions).Manage write-back partitions.SQL Server Analysis Services Partition Maintenance and Processing, Write enable partition.Set Partition Writeback.Implement linked cubes.Controlling the use of linked objects in SQL Server Analysis Services.Define Linked Measure Groups.Implement distributed cubes.Create and Manage a Remote Partition (Analysis Services).Select an appropriate model for data analysisSelect Tabular versus Multidimensional based on scalability needs.Comparing Tabular and Multidimensional Solutions (SSAS).BISM: Multidimensional vs. Tabular.An Analysis Services Case Study: Using Tabular Models in a Large-scale Commercial Solution.Traditional hierarchical.Comparing Tabular and Multidimensional Solutions (SSAS).Data volume.Comparing Tabular and Multidimensional Solutions (SSAS).Select appropriate organizational BI, such as corporate BI or PowerBI, and team and personal BI needs and data status.Comparing Tabular and Multidimensional Solutions (SSAS).Manage, maintain, and troubleshoot a SQL Server Analysis Services (SSAS) databaseAnalyze data model performanceIdentify performance consequences of data source view design.Analysis Services MOLAP Performance Guide for SQL Server 2012 and 2014 (section 2.3).Optimize performance by changing the design of the cube or dimension.Analysis Services MOLAP Performance Guide for SQL Server 2012 and 2014 (section 2.1 and 2.2).Analyze and optimize performances of an MDX/DAX query.Analysis Services MOLAP Performance Guide for SQL Server 2012 and 2014 (section 3.3).Optimizing DAX Queries.Analysis Services Query Performance Top 10 Best Practices.Optimize queries for huge data sets.Analysis Services MOLAP Performance Guide for SQL Server 2012 and 2014 (section 3.3).Optimizing DAX Queries.Analysis Services Distinct Count OptimizationOptimize MDX in the calculations.Analysis Services MOLAP Performance Guide for SQL Server 2012 and 2014 (section 2.4).Performance monitor counters.Performance Counters (SSAS).Select appropriate Dynamic Management Views for Analysis Services.SQL Server 2012 Analysis Services (SSAS) DMVs.Use Dynamic Management Views (DMVs) to Monitor Analysis Services.SSAS Operation Guide, chapter 3.Analyze and define performance countersPerformance Counters (SSAS).SSAS Operation Guide, chapter 3.Monitor growth of the cachePart 5: An Introduction to SSAS Performance and SQL Sentry Performance Advisor for Analysis Services.Performance Counters (SSAS), Cache.Define and view logging optionsLog operations in Analysis Services.SSAS - Best Practices and Performance Optimization - Part 4 of 4.Process data modelsDefine processing of tables or partitions for tabular and multidimensional modelsProcessing Options and Settings (Analysis Services).Analysis Services 2005 Processing Architecture.Process Tabular Model Partitions (SSAS Tabular).Define processing of databases, cubes, and dimensions for multidimensional models.Analysis Services MOLAP Performance Guide for SQL Server 2012 and 2014 (section 4).SQL Server Best Practices Article.Select full processing versus incremental processing.Analysis Services MOLAP Performance Guide for SQL Server 2012 and 2014 (section 4).SQL Server Analysis Services ProcessAdd for a Partition.Processing Options and Settings (Analysis Services).Define remote processing;Remote Processing (Analysis Services).Define lazy aggregations.SSAS Processing Mode (Lazy Aggregations).Automate with Analysis Management Objects (AMO) or XML for Analysis (XMLA).Create SQL Server Analysis Services Partitions using AMO.Developing with Analysis Management Objects (AMO).Process and manage partitions by using PowerShell.Analysis Services PowerShellUsing PowerShell for SQL Server Analysis Services tasks - Part 1.Automate SQL Server Analysis Services Tasks with PowerShell - Part 2Troubleshoot data analysis issuesUse SQL Profiler.Use SQL Server Profiler to Monitor Analysis ServicesTroubleshoot duplicate key dimension processing errors.SQL Server Analysis Services SSAS Processing Error Configurations.You get “A duplicate attribute key has been found when processing ..” error message when processing a dimension.Error logs and event viewer logs of SSAS.Log operations in Analysis Services.Configuring the Analysis Services Query Log.Log Properties.Data collection for troubleshooting Analysis Services issues.Mismatch of data: incorrect relationships or aggregations.Debugging Deployment Errors.SSAS: Reference materialized dimension might produce incorrect results.SSAS Operation Guide, chapter 7.3.2.Dynamic security issues.Implement Dynamic Security by Using Row Filters.Dynamic Security in SSAS Cube.Analysis Services Dynamic Security.SSAS Dynamic Security Issues.Validate logic and calculations.Validating MDX Queries Without Running Them.Automate MDX Query Testing.SQL Server Best Practices Article: Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services.Deploy SSAS databasesDeployment Wizard.Using the SQL Server Analysis Services (SSAS) Deployment Wizard.Running the Analysis Services Deployment Wizard.Implement BIDS.Deploy Analysis Services Projects (SSDT).Deploying an Analysis Services Database into the Production Environment.How to: Build and Deploy an Analysis Services Project.Deploy SSMS.Deploy Model Solutions Using XMLA.Test solution post deployment.SQL Server : Unit Testing SQL Server OLAP Cubes Using C#SSAS Operation Guide, chapter 4.Decide whether or not to process.Avoid Common SQL Server Analysis Services Problems.Test different roles.SQL Server Analysis Services – Testing Cube Roles.Configuring permissions for SQL Server Analysis Services.Install and maintain an SSAS instanceInstall SSAS.Install Analysis Services in Tabular Mode.Install SQL Server 2012 from the Installation Wizard (Setup).Install development tools.SQL Server Data Tools (SSDT) is Missing After Installing SQL Server 2014.Download SQL Server Data Tools (SSDT or SSDT-BI).Identify development and production installation considerations.Deploying Analysis Services Development and Production SystemsUpgrade SSAS instances.Upgrade Analysis ServicesDefine data file and program file location.SSAS Operation Guide, chapter 2.5.Analysis Services Configuration - Data Directories.Plan for Administrator accounts.SSAS Operation Guide, chapter 5.4Define server and database level security.SSAS Operation Guide, chapter 5.Support scale-out read-only.SSAS Operation Guide, chapter 7.5Update SSAS (service packs).How to obtain the latest service pack for SQL Server 2012.How to obtain the latest service pack for SQL Server 2014.KB2755533 How to obtain the latest SQL Server 2012 service packKB2527041 How to obtain the latest SQL Server 2008 R2 service packMicrosoft SQL Server support lifecycleKB321185 How to determine the version and edition of SQL Server and its componentsKB957826 The builds for all SQL Server versionsKB822499 Naming schema and Fix area descriptions for SQL Server software update packagesKB824684Description of the standard terminology that is used to describe Microsoft software updatesInstall and maintain each instance type of Analysis Services including PowerPivot.SSAS Operation Guide, chapter 8.PowerPivot Server Administration and Configuration in Central Administration.SSAS Tabular-Part 3: Tabular Model Administration.Restore and import PowerPivot.Power Pivot and SSAS (Tabular) RestoreBack up and restore by using PowerShell.Automate SQL Server Analysis Services Tasks with PowerShell - Part 2.Backup-ASDatabase cmdlet.Restore-ASDatabase cmdlet.Build a tabular data modelConfigure permissions and roles in a tabular modelConfigure server roles.Installing Analysis Services 2012 - Tabular Model.Configure SSAS database roles.Roles and Permissions (Analysis Services).Securing the Tabular BI Semantic Model, Managing roles and permissionsImplement dynamic security (custom security approaches).Implement Dynamic Security by Using Row Filters.Securing the Tabular BI Semantic Model, Dynamic securityRole-based access.Roles (SSAS Tabular)Securing the Tabular BI Semantic Model, Managing roles and permissionsTest security permissions.Securing the Tabular BI Semantic ModelImplement cell-level permissions.Roles (SSAS Tabular).Implement a tabular data modelDefine tables, import data.Getting started with Tabular Model in SQL Server 2012 - Part 1Lesson 2: Add DataDefine calculated columns.Lesson 6: Create Calculated Columns.Define relationships.Lesson 5: Create Relationships.Define hierarchies and perspectives.Getting started with the SQL Server 2012 Tabular Model - Part 2Lesson 9: Create Perspectives.Lesson 10: Create Hierarchies.Manage visibility of columns and tables.Getting started with the SQL Server 2012 Tabular Model - Part 2Embed links.Getting started with the SQL Server 2012 Tabular Model - Part 2Optimize BISM for Power View.Optimizing High Cardinality Columns in VertiPaqPower View: Explore, visualize, and present your dataMark a date table.Getting started with the SQL Server 2012 Tabular Model - Part 2Lesson 4: Mark as Date Table.Sort a column by another column.Sorting Dates Columns in PowerPivot v2 and BISM Tabular.Implement business logic in a tabular data modelImplement measures and KPIs.Getting started with the SQL Server 2012 Tabular Model - Part 2Lesson 8: Create Key Performance IndicatorsImplement Data Analysis Expressions (DAX).Getting started with the SQL Server 2012 Tabular Model - Part 2Data Analysis Expressions (DAX) ReferenceDAX in the BI Tabular Model Whitepaper and SamplesDefine relationship navigation.Relationships (SSAS Tabular)Many-to-Many Relationships in DAX.Implement time intelligence.SQL Server Analysis Service DAX Time Intelligence.Time Intelligence Functions (DAX)Implement context modification.Understanding the SQL Server 2012 BI Semantic Model (BISM)Filter Functions (DAX)Implement data access for a tabular data modelManage partitions.Getting started with the SQL Server 2012 Tabular Model - Part 2Lesson 11: Create PartitionsProcessing.Processing tabular models 101Select xVelocity versus DirectQuery for data access.Tabular query modes: DirectQuery vs. In-Memory.Build a report with SQL Server Reporting Services (SSRS)Design a reportSelect report components (crosstab report, Tablix).Tablix Data Region (Report Builder and SSRS).SQL Server 2012 Tutorials: Reporting Services.Design chart.SQL Server Reporting Services Charts Tips.Data visualization components.Create a Simple Report with the Wizard.Design report templates (Report Definition Language).Report Definition Language (SSRS).Identify the data source and parameters.SQL Server Reporting Services Parameters Tips.Data Connections, Data Sources, and Connection Strings (SSRS).Design a grouping structure.Understanding Groups (Reporting Services).Drill-down reports.Drilldown Action (Report Builder and SSRS)SQL Server Reporting Services 2012 Drilldown Features.Drill Down Techniques in SSRS with the Visibility PropertyDrill-through reports.SQL Server Reporting Services Drill Through Tips.Drillthrough Reports (Report Builder and SSRS).Determine if any expressions are required to display data that is not coming directly from the data source.Data Connections, Data Sources, and Connection Strings (SSRS), Expression based connection strings.Implement a report layoutFormatting.Lesson 5: Formatting a Report (Reporting Services)SSRS Tutorial videos.Apply conditional formatting.SQL Server Reporting Services Expressions Tips and Tricks.Page configuration.Pagination in Reporting Services (Report Builder and SSRS)Implement headers and footers.Add or Remove a Page Header or Footer (Report Builder and SSRS).Implement matrixes, table, chart, images, list, indicators, maps, and groupings in reports.Creating an SSRS Map report with data pinpoints.Display Graphics Dynamically in SQL Server Reporting Services.Report Builder Table or Matrix Wizard.SQL Server Reporting Services Images Tips.Indicators (Report Builder and SSRS).Lists (Report Builder and SSRS).Use Report Builder to implement a report layout.Page Layout and Rendering (Report Builder and SSRS).Create a range of reports using different data regions.Data Regions and Maps (Report Builder and SSRS).Define custom fields (implementing different parts of the report).Dataset Fields Collection (Report Builder and SSRS).Implement collections (global collections).Built-in Globals and Users References (Report Builder and SSRS).Define expressions.Expressions (Report Builder and SSRS).Implement data visualization components.Tables, Matrices, and Lists (Report Builder and SSRS).Identify report parts.Report Design View (Report Builder)implement group variables and report variables.Report and Group Variables Collections References (Report Builder and SSRS).Design for multiple delivery extension formats.Interactive Functionality for Different Report Rendering Extensions (Report Builder and SSRS).Configure authentication and authorization for a reporting solutionConfigure server-level and item-level role-based security.SQL Server Reporting Services 2012 Permissions.Security and Protection (SSRS).Configure reporting service security (setup or addition of role).SQL Server Reporting Services 2012 Permissions.Authenticate against data source.Specify Credential and Connection Information for Report Data Sources.Store credential information.Specify Credential and Connection Information for Report Data Sources.Describe Report Server security architecture and site level security.OVERVIEW OF SQL SERVER REPORTING SERVICES 2012 ARCHITECTURE, FEATURES, AND TOOLS.Authorization in Reporting Services.Create system level roles, item level security.Predefined Roles.SQL Server Reporting Services 2012 Permissions.Create a new role assignment.SQL Server Reporting Services 2012 Permissions.Assign Windows users to roles.SQL Server Reporting Services 2012 Permissions.Secure reports using roles.SQL Server Reporting Services 2012 Permissions.Configure SharePoint groups and permissions.Set Permissions for Report Server Items on a SharePoint Site (Reporting Services in SharePoint Integrated Mode)Define varying content for different role memberships.SQL Server Reporting Services 2012 Permissions.Implement interactivity in a reportDrilldown.Drilldown Action (Report Builder and SSRS)SQL Server Reporting Services 2012 Drilldown Features.Drill Down Techniques in SSRS with the Visibility PropertyDrillthrough.Drillthrough Reports (Report Builder and SSRS).Interactive sorting.Interactive Sorting for a SQL Server Reporting Services Report.Parameters: (databound parameters, multi-value parameters).Working With Multi-Select Parameters for SSRS Reports.Create dynamic reports in SSRS using parameters.Creating Dynamic Report Filters in SQL Server Reporting Services SSRS.Implement show/hide property.Hide an Item (Report Builder and SSRS).Actions (jump to report).Add a Bookmark to a Report (Report Builder and SSRS)Filters.Creating Dynamic Report Filters in SQL Server Reporting Services SSRS.Parameter list.SQL Server Reporting Services Using Multi-value Parameters.Fixed headers.SQL Server Reporting Services Report Manager Tips and TricksDocument map.SQL Server Reporting Services Bookmarks and Document Maps.Embedded HTML.Add HTML into a Report (Report Builder and SSRS)Troubleshoot reporting services issuesQuery the ReportServer database.Retrieve SSRS report server database information.View Reporting Services log files.Reporting Services Logging.SQL Server Reporting Services (SSRS) Log Files for Troubleshooting.Use Windows Reliability and Performance monitor data for troubleshooting.Using PerfMon for SQL Server Reporting Services Performance Management.Performance Counters for the ReportServer:Service and ReportServerSharePoint:Service Performance Objects.Use the ReportServer: define service and web service objects.Report Server Web Service.Monitor for long-running reports.Controlling dataset processing time in SQL Server Reporting Services reports.Optimize Report Parameter Dropdowns in SQL Server Reporting Services.Reporting Services Performance and Optimization.Rendering, and connectivity issues.SQL Server Reporting Services 2012 SP2 CU3 Report Rendering Issues.Troubleshooting Reports: Report Performance.Use SQL Profiler.Using SQL Profiler for SSRS Reports - Missing main dataset SQL Query in trace.Perform data reconciliation for incorrect relationships or aggregations.TESTING SSRS REPORTSDetect dynamic security issues.SQL Server Reporting Services Security TipsValidate logic and calculations.SQL Server Reporting Services Best Practices Tips.Manage a report environmentManage subscriptions and subscription settings.Subscriptions and Delivery (Reporting Services).Define data-driven subscriptions.Data-Driven Subscriptions.Manage data sources.Data Sources Supported by Reporting Services (SSRS).Integrate SharePoint Server.Install Reporting Services SharePoint Mode for SharePoint 2013.Define email delivery settings.Configure a Report Server for E-Mail Delivery (Reporting Services).Manage the number of snapshots.Working with Report Snapshots in SQL Server Reporting Services SSRS.Creating, Modifying, and Deleting Snapshots in Report History.Manage schedules.Schedules.Running jobs, and report server logs.Manage a Running Process.Report Server Execution Log and the ExecutionLog3 View.Manage report server databases.Administer a Report Server Database.Manage the encryption keys.SQL Server Reporting Services (SSRS) Encryption Key.Configure and Manage Encryption Keys.Set up the execution log reporting.SQL Server Report Server 2008 R2 Execution Log Reports.Report Server Execution Log and the ExecutionLog3 View.Review the reports.SQL Server Reporting Services Best Practices Tips.Configure site-level settings.Site Settings Page (Report Manager)Design report lifecycle.Report Life Cycle: Creating, Managing, and Delivering Reports.Automate management of reporting services.SQL Server Reporting Services (SSRS) RS.EXE Utility.Automate SSRS Report Generation using PowerShell.Custom MSBuild Tasks: Automated Report and DB Deployment.Create a report organization structure.Reporting Services Concepts (SSRS)Install and configure reporting services.Install Reporting Services Native Mode Report Server (SSRS)Deploy custom assemblies.SQL Server Reporting Services Custom Code Assemblies.Deploying a Custom Assembly.Configure report data sources and datasetsSelect appropriate query types (stored procedure versus table versus text only).Pros and Cons: Stored Procedures–vs.- Embedded Queries–vs.- Views in an SSRS DatasetConfigure parameterized connection strings (dynamic connection strings).Data Connections, Data Sources, and Connection Strings (SSRS), Expression based connection strings.Define filter location (dataset versus query).MSBI(SSRS) Training --SSRS Report Parameters, Filters, Query Parameters.Add a Filter to a Dataset (Report Builder and SSRS).Configure data source options, for example, extract and connect to multiple data sources.Data Connections, Data Sources, and Connection Strings (SSRS)Shared and embedded data sources and datasets.Create, Modify, and Delete Shared Data Sources (SSRS)Embedded and Shared Datasets (Report Builder and SSRS)Use custom expressions in data sources.Data Connections, Data Sources, and Connection Strings (SSRS), Expression based connection strings.Connect to Microsoft Azure SQL database.SQL Azure Connection Type (SSRS)Connect to Microsoft Azure Marketplace.SSRS Report using dataset.Microsoft Azure Marketplace Language.Implement DAX and MDX queries to retrieve appropriate data sets.Analysis Services Connection Type for MDX (SSRS)Simple SSRS Report using MDX Query.Write DAX queries in Report Builder.Work with non-relational data sources, such as XML or SharePoint lists.SharePoint List Connection Type (SSRS)XML Connection Type (SSRS).Connect to HDInsight Server.SQL Server Reporting ServicesConclusionAs you can see, there are a lot manuals, links and videos to study. If you already have real life experience in these topics it usually takes 3 months to study the material. Otherwise, plan on 6 months or more.If you believe there are other useful links for the exam feel free to comment and share your material.source: Microsoft SQL Server Exam 70-466 - Implementing Data Models and Reports Preparation Materials

There is no Training Kit for this exam (at least not yet), the official Microsoft course for this certification (Course 20466: Implementing Data Models and Reports with Microsoft® SQL Server®) is very useful, but it is not enough to pass the exam (the official courses never cover all the Microsoft certification exam topics).So, what can we do to pass this exam?This tip will give you links and tips for this very complex and difficult exam.If you are a beginner in SQL Server Business Intelligence or you do not have experience in the Microsoft Certification exams, we strongly recommend taking exam 70-463 first. The 70-466 exam is very complex and difficult.If you already passed exam 70-463, this tip is for you. We will give you advice, books and useful links for your exam.Here the links to SQL Server web sites, books, manuals:Design dimensions and measuresGiven a requirement, identify the dimension/measure group relationship that should be selected.SQL Server Analysis Services (SSAS) Tutorial.SQL Server Analysis Services Interview Questions Part I.SSAS Interview Questions on Measures, Actions, and Storage.Design patterns for representing business facts and dimensions (many-to-many relationships).Using Many-to-Many Relationships in Multidimensional SQL Server Analysis Services.SSAS Interview Questions on Measures, Actions, and Storage. Design dimensions to support multiple related measure groups (many related fact tables. What is the purpose of Dimension Usage settings? Explain different types of relationships between Facts and Dimensions.Defining a Many-to-Many RelationshipHandle degenerate dimensions in a cube.SQL Server Analysis Services Interview Questions Part II - Dimensions - What is a Degenerate Dimension in SQL Server Analysis Services? In what scenarios do you use it?Data Warehousing: Degenerate Dimensions.Defining a Fact Relationship.Identify the attributes for dimensions.Add an Attribute to a Dimension.Dimension Attribute Properties Reference.SQL Server Analysis Services Interview Questions Part II - DimensionsIdentify the measures.Measures and measure groups.SSAS Interview Questions on Measures, Actions, and Storage.Aggregation behavior for the measures.SQL Server Analysis Services Aggregation Designs.Define Semi additive BehaviorBuild hierarchies.SQL Server Analysis Services Attribute Relationships.Define granularity of dimension relationships.SQL Server Analysis Service Levels of Granularity.Implement and configure dimensions in a cubeTranslations.SQL Server Analysis Services Interview Questions on Dimensions, Hierarchies and Properties - What are Dimension Translations?Defining and Browsing TranslationsDefine attribute relationships.SQL Server Analysis Services Attribute Relationships.Attribute Relationships.Implement hierarchies.Creating a Hierarchy.Implement SQL Server Analysis Services (SSAS) dimensions and cubes.Build a Cube From an Existing Data Source Using SQL Server Analysis Services.Multidimensional Modeling (Adventure Works Tutorial).Create the Attribute Relationships that should be made for a given set of attributes in a dimension.Lesson 5: Defining Relationships Between Dimensions and Measure Groups.SQL Server Analysis Services Attribute Relationships.Develop new custom attributes on dimensions.Custom Attribute Names in Role Playing Dimensions for SSAS.Add an Attribute to a Dimension.Detect possible design flaws in attribute relationships.Analysis Service Performance GuideImplement time dimensions in cubes.Built in Time Dimension and Time Intelligence in SQL Server Analysis.SSAS Time Account Dimension Intelligence.Create a Time Dimension by Generating a Time Table.Manage SSAS parent-child dimensions.Parent-Child Dimensions.SQL Server Analysis Services Interview Questions Part II - Dimensions.Dimension types.SQL Server Analysis Services Interview Questions Part II - Dimensions.Design a schema to support cube architectureMultidimensional modeling starting from a star schema.Creating a Star Schema Using a Data Source View.Designing the Star Schema DatabaseRelational modeling for a data source view.DWH SchemasIntroduction to the SQLBI MethodologyChoose or create a topology.DWH SchemasIdentify the appropriate data types with correct precision and size.Data Types in Analysis Services.Tips for Optimizing SQL Server OLAP/Analysis Services: Data Warehouse and Datamart Performance.Create and configure measuresLogically group measures and configure Measure Group Properties.SSAS - Best Practices and Performance Optimization - Part 3 of 4.Measures and Measure Groups.Select appropriate aggregation functions.Use Aggregate Functions.Format measures.Configure Measure Properties.Design the measure group for the correct granularitySQL Server Analysis Service Levels of Granularity.Defining Dimension Granularity within a Measure Group.Implement a cubeUse SQL Server Data Tools - Business Intelligence (SSDT-BI) to build the cube.Multidimensional Modeling (Adventure Works Tutorial).Creating a Sample SSAS Project and CubeUse SSDT-BI to do non-additive or semi-additive measures in a cube.Define Semiadditive Behavior.Define measures.Defining a Cube.Creating a Cube using the Cube Wizard.Specify perspectives.Lesson 9: Defining Perspectives and Translations.SQL Server Analysis Services Perspectives.Define dimension usage.Dimension Relationships.Define cube-specific dimension properties.Lesson 4: Defining Advanced Attribute and Dimension Properties.Define measure groups.Create Measures and Measure Groups.Implement reference dimensions.Dimension Relationships.Implement many-to-many relationships.Dimension Relationships.Using Many-to-Many Relationships in Multidimensional SQL Server Analysis Services.Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques.Implement fact relationships.Dimension Relationships.Implement role-playing relationships.Defining Role Playing Dimensions for SQL Server Analysis Services.Create and manage linked measure groups and linked dimensions.Controlling the use of linked objects in SQL Server Analysis Services.Define Linked DimensionsCreate actions.Lesson 8: Defining Actions.Create Multidimensional Expressions (MDX) queriesIdentify the structures of MDX and the common functions (tuples, sets, TopCount, SCOPE, and more).Working with Members, Tuples, and Sets (MDX).MDX Basic ConceptsMultidimensional Expressions (MDX) ReferenceSQL Server Analysis Services (SSAS) 2012 Top and Bottom Functions.TopCount (MDX)MDX Function Reference (MDX).Identify which MDX statement would return the required result.MDX Function Reference (MDX)Implement a custom MDX or logical solution for a prepared case task.How to reduce MDX code redundancy in SQL Server Analysis Services SSAS.Order and Sort with MDX in SQL Server Analysis Services.MDX Function Reference (MDX)SQL Server Analysis Services Rank and Row Number Ordering.Analysis Services MOLAP Performance Guide for SQL Server 2012 and 2014 (section 2.4 and 3.3).Implement custom logic in a data modelDefine key performance indicators (KPIs).Testing KPIs for SQL Server Analysis Services.Lesson 7: Defining Key Performance Indicators (KPIs).Define calculated members.Defining Calculated Members.Create relative measures (growth, YoY, same period last year).Handling Relative Time Periods.Percentage of total using MDX.Using MDX to Calculate Both Values and Percentages for Analysis Services.MDX for Percent of Total for a subset of a Hierarchy.Named sets.Create Named Sets.Implement ranking and percentile.Rank (MDX).Ranking results from MDX queries.Define MDX script to import partial PowerPivot model.Analysis Services MDX Query Designer (Power Pivot).Implement storage design in a multidimensional modelCreate aggregations.SQL Server Analysis Services Aggregation Designs.Optimize a SQL Server Analysis Services Measure Group Partition for Performance.Aggregations and Aggregation Designs.Create partitions.How To Define Measure Group Partitions in SQL Server Analysis Services SSAS.Create and Manage a Local Partition (Analysis Services).Analysis Services MOLAP Performance Guide for SQL Server 2012 and 2014 (section 2.2).Storage modes.Partition Storage Modes and Processing.How To Implement Proactive Caching in SQL Server Analysis Services SSAS.Define proactive caching.How To Implement Proactive Caching in SQL Server Analysis Services SSAS.Proactive Caching (Partitions).Manage write-back partitions.SQL Server Analysis Services Partition Maintenance and Processing, Write enable partition.Set Partition Writeback.Implement linked cubes.Controlling the use of linked objects in SQL Server Analysis Services.Define Linked Measure Groups.Implement distributed cubes.Create and Manage a Remote Partition (Analysis Services).Select an appropriate model for data analysisSelect Tabular versus Multidimensional based on scalability needs.Comparing Tabular and Multidimensional Solutions (SSAS).BISM: Multidimensional vs. Tabular.An Analysis Services Case Study: Using Tabular Models in a Large-scale Commercial Solution.Traditional hierarchical.Comparing Tabular and Multidimensional Solutions (SSAS).Data volume.Comparing Tabular and Multidimensional Solutions (SSAS).Select appropriate organizational BI, such as corporate BI or PowerBI, and team and personal BI needs and data status.Comparing Tabular and Multidimensional Solutions (SSAS).Manage, maintain, and troubleshoot a SQL Server Analysis Services (SSAS) databaseAnalyze data model performanceIdentify performance consequences of data source view design.Analysis Services MOLAP Performance Guide for SQL Server 2012 and 2014 (section 2.3).Optimize performance by changing the design of the cube or dimension.Analysis Services MOLAP Performance Guide for SQL Server 2012 and 2014 (section 2.1 and 2.2).Analyze and optimize performances of an MDX/DAX query.Analysis Services MOLAP Performance Guide for SQL Server 2012 and 2014 (section 3.3).Optimizing DAX Queries.Analysis Services Query Performance Top 10 Best Practices.Optimize queries for huge data sets.Analysis Services MOLAP Performance Guide for SQL Server 2012 and 2014 (section 3.3).Optimizing DAX Queries.Analysis Services Distinct Count OptimizationOptimize MDX in the calculations.Analysis Services MOLAP Performance Guide for SQL Server 2012 and 2014 (section 2.4).Performance monitor counters.Performance Counters (SSAS).Select appropriate Dynamic Management Views for Analysis Services.SQL Server 2012 Analysis Services (SSAS) DMVs.Use Dynamic Management Views (DMVs) to Monitor Analysis Services.SSAS Operation Guide, chapter 3.Analyze and define performance countersPerformance Counters (SSAS).SSAS Operation Guide, chapter 3.Monitor growth of the cachePart 5: An Introduction to SSAS Performance and SQL Sentry Performance Advisor for Analysis Services.Performance Counters (SSAS), Cache.Define and view logging optionsLog operations in Analysis Services.SSAS - Best Practices and Performance Optimization - Part 4 of 4.Process data modelsDefine processing of tables or partitions for tabular and multidimensional modelsProcessing Options and Settings (Analysis Services).Analysis Services 2005 Processing Architecture.Process Tabular Model Partitions (SSAS Tabular).Define processing of databases, cubes, and dimensions for multidimensional models.Analysis Services MOLAP Performance Guide for SQL Server 2012 and 2014 (section 4).SQL Server Best Practices Article.Select full processing versus incremental processing.Analysis Services MOLAP Performance Guide for SQL Server 2012 and 2014 (section 4).SQL Server Analysis Services ProcessAdd for a Partition.Processing Options and Settings (Analysis Services).Define remote processing;Remote Processing (Analysis Services).Define lazy aggregations.SSAS Processing Mode (Lazy Aggregations).Automate with Analysis Management Objects (AMO) or XML for Analysis (XMLA).Create SQL Server Analysis Services Partitions using AMO.Developing with Analysis Management Objects (AMO).Process and manage partitions by using PowerShell.Analysis Services PowerShellUsing PowerShell for SQL Server Analysis Services tasks - Part 1.Automate SQL Server Analysis Services Tasks with PowerShell - Part 2Troubleshoot data analysis issuesUse SQL Profiler.Use SQL Server Profiler to Monitor Analysis ServicesTroubleshoot duplicate key dimension processing errors.SQL Server Analysis Services SSAS Processing Error Configurations.You get “A duplicate attribute key has been found when processing ..” error message when processing a dimension.Error logs and event viewer logs of SSAS.Log operations in Analysis Services.Configuring the Analysis Services Query Log.Log Properties.Data collection for troubleshooting Analysis Services issues.Mismatch of data: incorrect relationships or aggregations.Debugging Deployment Errors.SSAS: Reference materialized dimension might produce incorrect results.SSAS Operation Guide, chapter 7.3.2.Dynamic security issues.Implement Dynamic Security by Using Row Filters.Dynamic Security in SSAS Cube.Analysis Services Dynamic Security.SSAS Dynamic Security Issues.Validate logic and calculations.Validating MDX Queries Without Running Them.Automate MDX Query Testing.SQL Server Best Practices Article: Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services.Deploy SSAS databasesDeployment Wizard.Using the SQL Server Analysis Services (SSAS) Deployment Wizard.Running the Analysis Services Deployment Wizard.Implement BIDS.Deploy Analysis Services Projects (SSDT).Deploying an Analysis Services Database into the Production Environment.How to: Build and Deploy an Analysis Services Project.Deploy SSMS.Deploy Model Solutions Using XMLA.Test solution post deployment.SQL Server : Unit Testing SQL Server OLAP Cubes Using C#SSAS Operation Guide, chapter 4.Decide whether or not to process.Avoid Common SQL Server Analysis Services Problems.Test different roles.SQL Server Analysis Services – Testing Cube Roles.Configuring permissions for SQL Server Analysis Services.Install and maintain an SSAS instanceInstall SSAS.Install Analysis Services in Tabular Mode.Install SQL Server 2012 from the Installation Wizard (Setup).Install development tools.SQL Server Data Tools (SSDT) is Missing After Installing SQL Server 2014.Download SQL Server Data Tools (SSDT or SSDT-BI).Identify development and production installation considerations.Deploying Analysis Services Development and Production SystemsUpgrade SSAS instances.Upgrade Analysis ServicesDefine data file and program file location.SSAS Operation Guide, chapter 2.5.Analysis Services Configuration - Data Directories.Plan for Administrator accounts.SSAS Operation Guide, chapter 5.4Define server and database level security.SSAS Operation Guide, chapter 5.Support scale-out read-only.SSAS Operation Guide, chapter 7.5Update SSAS (service packs).How to obtain the latest service pack for SQL Server 2012.How to obtain the latest service pack for SQL Server 2014.KB2755533 How to obtain the latest SQL Server 2012 service packKB2527041 How to obtain the latest SQL Server 2008 R2 service packMicrosoft SQL Server support lifecycleKB321185 How to determine the version and edition of SQL Server and its componentsKB957826 The builds for all SQL Server versionsKB822499 Naming schema and Fix area descriptions for SQL Server software update packagesKB824684 Description of the standard terminology that is used to describe Microsoft software updatesInstall and maintain each instance type of Analysis Services including PowerPivot.SSAS Operation Guide, chapter 8.PowerPivot Server Administration and Configuration in Central Administration.SSAS Tabular-Part 3: Tabular Model Administration.Restore and import PowerPivot.Power Pivot and SSAS (Tabular) RestoreBack up and restore by using PowerShell.Automate SQL Server Analysis Services Tasks with PowerShell - Part 2.Backup-ASDatabase cmdlet.Restore-ASDatabase cmdlet.Build a tabular data modelConfigure permissions and roles in a tabular modelConfigure server roles.Installing Analysis Services 2012 - Tabular Model.Configure SSAS database roles.Roles and Permissions (Analysis Services).Securing the Tabular BI Semantic Model, Managing roles and permissionsImplement dynamic security (custom security approaches).Implement Dynamic Security by Using Row Filters.Securing the Tabular BI Semantic Model, Dynamic securityRole-based access.Roles (SSAS Tabular)Securing the Tabular BI Semantic Model, Managing roles and permissionsTest security permissions.Securing the Tabular BI Semantic ModelImplement cell-level permissions.Roles (SSAS Tabular).Implement a tabular data modelDefine tables, import data.Getting started with Tabular Model in SQL Server 2012 - Part 1Lesson 2: Add DataDefine calculated columns.Lesson 6: Create Calculated Columns.Define relationships.Lesson 5: Create Relationships.Define hierarchies and perspectives.Getting started with the SQL Server 2012 Tabular Model - Part 2Lesson 9: Create Perspectives.Lesson 10: Create Hierarchies.Manage visibility of columns and tables.Getting started with the SQL Server 2012 Tabular Model - Part 2Embed links.Getting started with the SQL Server 2012 Tabular Model - Part 2Optimize BISM for Power View.Optimizing High Cardinality Columns in VertiPaqPower View: Explore, visualize, and present your dataMark a date table.Getting started with the SQL Server 2012 Tabular Model - Part 2Lesson 4: Mark as Date Table.Sort a column by another column.Sorting Dates Columns in PowerPivot v2 and BISM Tabular.Implement business logic in a tabular data modelImplement measures and KPIs.Getting started with the SQL Server 2012 Tabular Model - Part 2Lesson 8: Create Key Performance IndicatorsImplement Data Analysis Expressions (DAX).Getting started with the SQL Server 2012 Tabular Model - Part 2Data Analysis Expressions (DAX) ReferenceDAX in the BI Tabular Model Whitepaper and SamplesDefine relationship navigation.Relationships (SSAS Tabular)Many-to-Many Relationships in DAX.Implement time intelligence.SQL Server Analysis Service DAX Time Intelligence.Time Intelligence Functions (DAX)Implement context modification.Understanding the SQL Server 2012 BI Semantic Model (BISM)Filter Functions (DAX)Implement data access for a tabular data modelManage partitions.Getting started with the SQL Server 2012 Tabular Model - Part 2Lesson 11: Create PartitionsProcessing.Processing tabular models 101Select xVelocity versus DirectQuery for data access.Tabular query modes: DirectQuery vs. In-Memory.Build a report with SQL Server Reporting Services (SSRS)Design a reportSelect report components (crosstab report, Tablix).Tablix Data Region (Report Builder and SSRS).SQL Server 2012 Tutorials: Reporting Services.Design chart.SQL Server Reporting Services Charts Tips.Data visualization components.Create a Simple Report with the Wizard.Design report templates (Report Definition Language).Report Definition Language (SSRS).Identify the data source and parameters.SQL Server Reporting Services Parameters Tips.Data Connections, Data Sources, and Connection Strings (SSRS).Design a grouping structure.Understanding Groups (Reporting Services).Drill-down reports.Drilldown Action (Report Builder and SSRS)SQL Server Reporting Services 2012 Drilldown Features.Drill Down Techniques in SSRS with the Visibility PropertyDrill-through reports.SQL Server Reporting Services Drill Through Tips.Drillthrough Reports (Report Builder and SSRS).Determine if any expressions are required to display data that is not coming directly from the data source.Data Connections, Data Sources, and Connection Strings (SSRS), Expression based connection strings.Implement a report layoutFormatting.Lesson 5: Formatting a Report (Reporting Services)SSRS Tutorial videos.Apply conditional formatting.SQL Server Reporting Services Expressions Tips and Tricks.Page configuration.Pagination in Reporting Services (Report Builder and SSRS)Implement headers and footers.Add or Remove a Page Header or Footer (Report Builder and SSRS).Implement matrixes, table, chart, images, list, indicators, maps, and groupings in reports.Creating an SSRS Map report with data pinpoints.Display Graphics Dynamically in SQL Server Reporting Services.Report Builder Table or Matrix Wizard.SQL Server Reporting Services Images Tips.Indicators (Report Builder and SSRS).Lists (Report Builder and SSRS).Use Report Builder to implement a report layout.Page Layout and Rendering (Report Builder and SSRS).Create a range of reports using different data regions.Data Regions and Maps (Report Builder and SSRS).Define custom fields (implementing different parts of the report).Dataset Fields Collection (Report Builder and SSRS).Implement collections (global collections).Built-in Globals and Users References (Report Builder and SSRS).Define expressions.Expressions (Report Builder and SSRS).Implement data visualization components.Tables, Matrices, and Lists (Report Builder and SSRS).Identify report parts.Report Design View (Report Builder)implement group variables and report variables.Report and Group Variables Collections References (Report Builder and SSRS).Design for multiple delivery extension formats.Interactive Functionality for Different Report Rendering Extensions (Report Builder and SSRS).Configure authentication and authorization for a reporting solutionConfigure server-level and item-level role-based security.SQL Server Reporting Services 2012 Permissions.Security and Protection (SSRS).Configure reporting service security (setup or addition of role).SQL Server Reporting Services 2012 Permissions.Authenticate against data source.Specify Credential and Connection Information for Report Data Sources.Store credential information.Specify Credential and Connection Information for Report Data Sources.Describe Report Server security architecture and site level security.OVERVIEW OF SQL SERVER REPORTING SERVICES 2012 ARCHITECTURE, FEATURES, AND TOOLS.Authorization in Reporting Services.Create system level roles, item level security.Predefined Roles.SQL Server Reporting Services 2012 Permissions.Create a new role assignment.SQL Server Reporting Services 2012 Permissions.Assign Windows users to roles.SQL Server Reporting Services 2012 Permissions.Secure reports using roles.SQL Server Reporting Services 2012 Permissions.Configure SharePoint groups and permissions.Set Permissions for Report Server Items on a SharePoint Site (Reporting Services in SharePoint Integrated Mode)Define varying content for different role memberships.SQL Server Reporting Services 2012 Permissions.Implement interactivity in a reportDrilldown.Drilldown Action (Report Builder and SSRS)SQL Server Reporting Services 2012 Drilldown Features.Drill Down Techniques in SSRS with the Visibility PropertyDrillthrough.Drillthrough Reports (Report Builder and SSRS).Interactive sorting.Interactive Sorting for a SQL Server Reporting Services Report.Parameters: (databound parameters, multi-value parameters).Working With Multi-Select Parameters for SSRS Reports.Create dynamic reports in SSRS using parameters.Creating Dynamic Report Filters in SQL Server Reporting Services SSRS.Implement show/hide property.Hide an Item (Report Builder and SSRS).Actions (jump to report).Add a Bookmark to a Report (Report Builder and SSRS)Filters.Creating Dynamic Report Filters in SQL Server Reporting Services SSRS.Parameter list.SQL Server Reporting Services Using Multi-value Parameters.Fixed headers.SQL Server Reporting Services Report Manager Tips and TricksDocument map.SQL Server Reporting Services Bookmarks and Document Maps.Embedded HTML.Add HTML into a Report (Report Builder and SSRS)Troubleshoot reporting services issuesQuery the ReportServer database.Retrieve SSRS report server database information.View Reporting Services log files.Reporting Services Logging.SQL Server Reporting Services (SSRS) Log Files for Troubleshooting.Use Windows Reliability and Performance monitor data for troubleshooting.Using PerfMon for SQL Server Reporting Services Performance Management.Performance Counters for the ReportServer:Service and ReportServerSharePoint:Service Performance Objects.Use the ReportServer: define service and web service objects.Report Server Web Service.Monitor for long-running reports.Controlling dataset processing time in SQL Server Reporting Services reports.Optimize Report Parameter Dropdowns in SQL Server Reporting Services.Reporting Services Performance and Optimization.Rendering, and connectivity issues.SQL Server Reporting Services 2012 SP2 CU3 Report Rendering Issues.Troubleshooting Reports: Report Performance.Use SQL Profiler.Using SQL Profiler for SSRS Reports - Missing main dataset SQL Query in trace.Perform data reconciliation for incorrect relationships or aggregations.TESTING SSRS REPORTSDetect dynamic security issues.SQL Server Reporting Services Security TipsValidate logic and calculations.SQL Server Reporting Services Best Practices Tips.Manage a report environmentManage subscriptions and subscription settings.Subscriptions and Delivery (Reporting Services).Define data-driven subscriptions.Data-Driven Subscriptions.Manage data sources.Data Sources Supported by Reporting Services (SSRS).Integrate SharePoint Server.Install Reporting Services SharePoint Mode for SharePoint 2013.Define email delivery settings.Configure a Report Server for E-Mail Delivery (Reporting Services).Manage the number of snapshots.Working with Report Snapshots in SQL Server Reporting Services SSRS.Creating, Modifying, and Deleting Snapshots in Report History.Manage schedules.Schedules.Running jobs, and report server logs.Manage a Running Process.Report Server Execution Log and the ExecutionLog3 View.Manage report server databases.Administer a Report Server Database.Manage the encryption keys.SQL Server Reporting Services (SSRS) Encryption Key.Configure and Manage Encryption Keys.Set up the execution log reporting.SQL Server Report Server 2008 R2 Execution Log Reports.Report Server Execution Log and the ExecutionLog3 View.Review the reports.SQL Server Reporting Services Best Practices Tips.Configure site-level settings.Site Settings Page (Report Manager)Design report lifecycle.Report Life Cycle: Creating, Managing, and Delivering Reports.Automate management of reporting services.SQL Server Reporting Services (SSRS) RS.EXE Utility.Automate SSRS Report Generation using PowerShell.Custom MSBuild Tasks: Automated Report and DB Deployment.Create a report organization structure.Reporting Services Concepts (SSRS)Install and configure reporting services.Install Reporting Services Native Mode Report Server (SSRS)Deploy custom assemblies.SQL Server Reporting Services Custom Code Assemblies.Deploying a Custom Assembly.Configure report data sources and datasetsSelect appropriate query types (stored procedure versus table versus text only).Pros and Cons: Stored Procedures–vs.- Embedded Queries–vs.- Views in an SSRS DatasetConfigure parameterized connection strings (dynamic connection strings).Data Connections, Data Sources, and Connection Strings (SSRS), Expression based connection strings.Define filter location (dataset versus query).MSBI(SSRS) Training --SSRS Report Parameters, Filters, Query Parameters.Add a Filter to a Dataset (Report Builder and SSRS).Configure data source options, for example, extract and connect to multiple data sources.Data Connections, Data Sources, and Connection Strings (SSRS)Shared and embedded data sources and datasets.Create, Modify, and Delete Shared Data Sources (SSRS)Embedded and Shared Datasets (Report Builder and SSRS)Use custom expressions in data sources.Data Connections, Data Sources, and Connection Strings (SSRS), Expression based connection strings.Connect to Microsoft Azure SQL database.SQL Azure Connection Type (SSRS)Connect to Microsoft Azure Marketplace.SSRS Report using dataset.Microsoft Azure Marketplace Language.Implement DAX and MDX queries to retrieve appropriate data sets.Analysis Services Connection Type for MDX (SSRS)Simple SSRS Report using MDX Query.Write DAX queries in Report Builder.Work with non-relational data sources, such as XML or SharePoint lists.SharePoint List Connection Type (SSRS)XML Connection Type (SSRS).Connect to HDInsight Server.SQL Server Reporting ServicesConclusionAs you can see, there are a lot manuals, links and videos to study. If you already have real life experience in these topics it usually takes 3 months to study the material. Otherwise, plan on 6 months or more.If you believe there are other useful links for the exam feel free to comment and share your material.source: Microsoft SQL Server Exam 70-466 - Implementing Data Models and Reports Preparation Materials

If you are a total beginner, in short your path should look like this:Learn SQL, and Python.Then learn Machine learning from a couple of basic courses.Learn probability theory, and some computational mathematics.The world of statistics is vast, but very interesting: THE WORLD OF STATISTICSThen dive into Your Home for Data Science and see what others are working on.Then spend your time on Scikit learn website:http://scikit-learn.org/https://www.quora.com/What-are-some-Machine-Learning-algorithms-that-you-should-always-have-a-strong-understanding-of-and-why/answer/Rohit-MalsheThen practice on your own, and grow bit by bit.If you need a curated list to follow, you can start here: https://github.com/bulutyazilim/awesome-datascienceHere is a cool visualization on how a modern data scientist looks like:I work with people who write C/C++ programs that generate GBs of data, people who manage TBs of data distributed across giant databases, people who are top notch programmers in SQL, Python, R, and people who have setup an organization wide databases working with Hadoop, Sap, Business Intelligence etc.My inspiration to anyone and everyone would be following:Learn all the basics from Coursera, but if I really have to compare what you would get out of Coursera compared to the vastness of data science, let us say ~ Coursera is as good as eating a burrito at Chipotle Mexican Grill. You certainly can satiate yourself, and you have a few things to eat there.The pathway to value adding data science is really quite deep, and I consider it equivalent to a five star buffet offering 20 cuisines and some 500 different recipes.Coursera is certainly a good starting point, and one should certainly go over these courses, but I personally never paid any money to Coursera, and I could easily learn a variety of things bit by bit over time.Kaggle is a really good resource for budding engineers to look at various other people’s ideas and build on them.My own learning came from actually building things. I started with SQL, then I learned Python, then I learned R, then I learned many libraries in Python and R. Then I learned html, decent GUI programming using VB script, C# programming. Then I learned Scikit learn. Finally I talked to various statisticians at my work place whose day in day out job is to derive conclusions out of data, and in the process I learned JMP/JSL scripting. I learned a lot of statistics in the process.Here is an overall sequence of how I progressed myself.The first thing I want to inspire anyone and everyone is to learn the “science”. Data science is 90 % Science, and 10 % managing data. Without knowing science, and without knowing what you want to achieve and why you want to achieve it, you would not be able to use whatever you learn on Coursera in any way. I can almost guarantee you that.I have seen my friends going through some of those courses, but at the end of the day, they do not build anything, they do not derive correct conclusions, and they do not really “use” anything that they learn. More than that, they do not even really use the skills they acquire.The way all this happened to me is as follows:I dived deep into data, understood their structure, understood their types. I understood why we were even collecting all those data, how we were collecting them, how we were storing them, and how we were processing them before storing them.I learned how data could be handled with these programming languages effectively. I learned to clean the data, process them as much as I wanted to, and plot them with with every possible way I could. Just plotting the data took me hours and hours to see how various plots could show the data in one way compared to another.I learned from my friends who manage databases how they did that and what went in the background. I learned the structures of the database tables.Then I learned how to plot some relevant plots, and calculate the return on investment for doing anything. Here is where Data science started coming together. There is no plot that I cannot plot. Basically - every plot I saw on the internet, I learned how to plot it. This is extremely important, and this is what will lead you to story telling.Then I learned automating things, and this is really amazing, because you would be able to do a few things automatically, which would save you a lot of time.Automation came really easily with Python, R, VBscript, C# programming.I can tell you that there is roughly speaking nothing that is not automated for me. I have a computer program for anything and everything, and most of my things are done by a button click ~ Or lets say - a few button clicks.Then I learned report writing. What I learned is that I had to send a lot of data and plots to others over a mail. And believe me, people have no time, and no interest. But if you make colorful plots, write down a coherent report demonstrating what you want to say, and pack enormous and powerful information in few really colorful plots, you can make a case.Then I learned story telling. What this simply means is that you should be able to tell the vice president of the company what the topmost problems of your division are. And they way you should be able to derive these conclusions are by creating engaging plots that tell a story. Without this, you would not be able to convince anyone. People are not interested in numbers. All they remember is names, places, things, inspiration, and why someone wants to do something. A true data scientist is also a true presenter of the data.Then I read every possible blog on the internet to see how others were doing these things. How people were writing their programs, how they were creating various plots, how they were automating things and so on. I also derived a lot of ideas from how someone used their skills to do an amazing project. This is a really nice way to see how others imagine. Then you can borrow their imagination and build things, and eventually as things are easier for you, you would begin imagining things yourself.Just take a look at the number of blogs available to you from where you can learn a lot of things.The Ultimate Guide to Data Science Blogs.I have gone through many of these blogs, and I have read them in depth. This took weeks of efforts and multiple Saturdays and Sundays experimenting with data, and programming languages.My most frequently used websites:Stack OverflowPython Programming TutorialsThe Comprehensive R Archive NetworkSeaborn: statistical data visualizationYour Home for Data Science16+ Free Data Science Booksipython/ipythonvinta/awesome-pythonscikit-learn: machine learning in PythonGrace: GalleryCheck out the amazing plots here.Practical Programming for Total BeginnersLearn python the hard wayYouTube. Yes! Just type your question here, and you should get an answer.Toad WorldSQL TutorialCodeAcademy: Pythonhttp://mahout.apache.org/http://www.netlib.org/lapack/http://www.netlib.org/eispack/http://www.netlib.org/scalapack/RegExr: Learn, Build, & Test RegExRegex for JavaScript, Python, PHP, and PCREStatsModels: Statistics in Python: This one is a killer one! You can do a lot with this.Installing NLTK - NLTK 3.0 documentationMost read books:Learning PythonThe Art of R ProgrammingArt of R programming http://shop.oreilly.com/product/...I really don’t think I am a books person, but I do like to read them once in a while when I am in “There-is-no-way-but-to-read-the-manual” mode. I have read many statistics books, and I will update them here.I would now give you a more comprehensive approach, so that you have a lot of inspiration to hold on to.How does a typical engineer’s job look like, and how can data science help on those lines?Decision making: In my job, I have several decisions to make and several actions to take in a day. In addition, I have various stake holders to update, various people to give guidance to, various data sets to look at, and various tools and machines to handle. Some of these machines are physical machines making things, and some others are simply computer programs and software platforms creating settings for these machines.Data: Most of the data we have is on various servers which are distributed across various units, or is on some shared drive, or on some hard disk drive available on a server.Databases: These database servers can be used to get data with SQL, or direct data pull, or by grabbing them somehow (Say copying by FTP), sometimes even manually copying, and pasting into excel, CSV or notepad. Usually we have multiple methods to do direct data pull from the servers. There are various SQL platforms such as TOAD, Business Intelligence, and even in house built platforms.SQL can be learned easily using these platforms, and one can create plenty of SQL scripts.You can even create scripts that can write scripts.I would inspire you to learn SQL as it is one of the most used language for just getting data.Data again: The data on these databases can be highly structured, or somewhat unstructured - such as human comments or so on.These data can often have a fixed number of variables, or varying number of variables.Sometimes data can be missing too, and sometimes they can be incorrectly entered in the databases.Every time something like this is found, and immediate response is sent to database managers, and they correct the bugs if there are any in the system.Usually before setting up a whole giant project of setting up a database, multiple people unite and discuss how the data should look like, how they should be distributed into various tables, and how the tables should be connected.Such people are true data scientists, as they know what the end user is going to want on a daily basis over and over.They always try to structure the data as much as possible, because it makes it very easy to handle it.Scripting and scheduling: Using multiple scripts that are scheduled to run at specific timings, or sometimes setup to run on an adhoc basis, I get and dump data in various folders on a dedicated computer. I have a decently large HDD to store a lot of data.Usually I append new data to existing data sets, and purge out older data in a timely way.Sometimes I have programs running with sleep commands, that at scheduled timings merely check something quickly, and sleep back again.More scripting: Furthermore, there are multiple scripts that are setup to crunch these data sets and create a bunch of decisions from them.Cleaning data, creating valuable pivot tables, and plots is one of the biggest time hold ups for anyone trying to achieve value out of this.To achieve something like this, first you would have to understand your data in and out, and you should be very capable of doing all sorts of hand calculations, generating excel sheets, and visualizing data.Science: What I would inspire you with is that before you do data-science, do the science, learn the physics behind your data, and understand it in and out. Say ~ If you work in a T-Shirt industry, you should know every aspect of a T-shift in and out, you should have access to all possible information around T-shirts, and you should know very well what the customers want and like, without even looking at any of the data.Without understanding the science, data-science is valueless, and trying to achieve something with it may be a fruitless effort.Caveats: I have seen plenty of people not even knowing what to plot against what.The worst I have seen is that people plot just about some random variables against each other and they derive conclusions out of them.True, that correlations exist in many things, but you should always know if there is any causation.Example: There is a significant correlation between number of Nobel Laureates and per-capita chocolate consumption of various countries; But is it a causation? May be not!Back to programs: There is usually a sequence in which all the scripts run, and create all sorts of tables, and plots to look at.Some scripts are sequential, whereas some programs are mere executables. Executables usually are written for speed, and C, C++, C# etc can be used for them.Scripts can be written in Python, VB etc.Decision making: When certain {If/Then} conditions are met, more computer programs self trigger and run more data analysis.Data science: This usually unfolds into a lot of statistics, classification, regression.Here is where machine learning comes in. One can use programming languages such as Python or R to do this.Based off the machine learning algorithms’ results, more computer programs are ran and more plots are generated or more programs are triggered.Plotting: Ultimately, a lot of plots are stored in a coherent fashion for humans to make decisions.Self sustaining reports: The reports are self triggering, self sustained programs that tell me what to do.The feeling of being ironman: I usually look at the results from all the reports in 10 mins, and make decisions on what to do next for many hours. Every now and then I look at the reports again to re-define the decisions or change them on the fly if this has to be done.What are the advantages of doing all this?First of all, when a computer does something, it would do it at a much faster speed than a human.A computer will do it tirelessly, and endlessly.Computer programs need sufficient amount of training, and multiple levels of testing for varying inputs, but once all that is done, it would keep doing that job for ever until either the sample space itself changes, or something drastically changes to the input itself.By programming it to the level that the entire output is set on a dashboard, it is very easy to see what the order of the projects should be.How do you now create value from something like this?One should always be behind science! and by knowing your data as well as possible you would be able to order the implementation of your projects.The decision you would make, and the actions you would take would be harder, better, faster, stronger.You would be able to derive conclusions and generate some lean sigma projects.You would be able to update the stakeholders well ahead of time, and be able to be on the top of your projects.You would be able to focus only on the science aspect instead of just trying to manually create plots.You would be able to find out trends in your data more easily, and say things one way or the other if the data tell you to make decisions in favor of one choice over other.Last but not the least, you can reduce human efforts significantly and automate all the things for you.I even have scripts that push buttons for me or fill up forms for me.I have several image analysis programs that analyze images and make decisions on the fly without humans looking at them.I hope this answer is elaborate and gives you some insight on what you can work on.Stay blessed and stay inspired!