Microsoft 70-466:Implementing Data Models & Reports

Explore an introduction to business intelligence and examine the tools available for business intelligence used within sequel server.

Learn to perform e-tail extract transform and load using SQL Server Integration Services (SSIS), the primary, .NET-based ETL tool introduced in 2005, replacing data transformation services.

Explore SQL Server data tools in Visual Studio to build integration services, analysis services, and reporting services projects for business intelligence, enabling analysts to browse data with Excel and SharePoint.

Learn the evolution of SQL Server Reporting Services, including native and SharePoint integrated modes, report management, and exporting to formats such as Excel, Word, SML, images, and atom feeds.

Explore three report creation options—single server data tools, report builder, and Power View—and learn how reports publish to report manager or a SharePoint document library depending on installation.

Learn visual components in reporting services, including charts of various styles and embedded or external images. Use data bars, sparklines, indicators, and gauges to build dashboards.

Design and format a SQL Server report by centering headers, applying currency formatting to sales amounts, and configuring drill-down visibility for subcategories and categories to enhance readability.

Demonstrate creating SQL Server reports with drill-down, hide-on-click visibility, and parameterized navigation to a separate products report by passing the product ID.

Master SSRS management by deploying reports, configuring report security, handling report execution, setting up subscriptions, and enabling data alerts.

Explore the deployment of reports and other objects with reporting services, and discuss reporter security.

The report security model uses a hierarchical structure with inherited permissions, where breaking inheritance is rare; it governs report server access, report builder use, viewing rights, and data source security.

Define data alerts in Reporting Services 2012 to set notification rules and email settings for reports. Check data on a schedule and email reports when criteria are met.

Explore the introduction to cubes and how multidimensional OLAP cubes pre-calculate aggregations of facts like total sales, cost, tax, and discount, and slice by product and customer dimensions.

Learn to create and configure an Analysis Services cube, apply a star schema with fact and dimension tables, and process and deploy for user-friendly data browsing.

Explore how to create and configure multi-dimensional cubes, define measures in a fact table, and use hands-on practice with the Adventure Works DW 2012 database for exam readiness.

Explore the components of a multi dimensional cube through a hands-on demonstration, learn how to create and configure the cube, and practice by building your own multi dimensional cube.

Configure partial pre-calculated aggregations to balance performance and memory. Roll up leaf-level calculations to higher levels (week to month to quarter to year) rather than storing every calculation.

Explore how dimensions provide context for measures, with dimension tables (entities) and attributes, and learn to rename attributes for friendly user terms, organize into folders, and form hierarchies.

Configure measures, measure groups, and dimensions in the cube, adjust currency formatting with thousand separators for unit price and sales amount, and apply grid view with custom formats.

Learn to discretize the employee base rate into buckets, configure measures and formatting, deploy and process the cube, refresh data, and customize dimension and sort-by options in analysis services.

Understand measures, their properties and formatting, when to use measure groups and storage types for real-time cube browsing, and how dimensions, attributes, and hierarchies aid navigation.

Explore how measures are created for fact table columns, default aggregations (additive, semi-additive, non additive), and how measure groups and dimensions with hierarchies enable formatting and browsing.

Perspectives act as subset views of the cube in Analysis Services, guiding focused user attention without security control; permissions remain on the cube, not the perspective.

Explore key performance indicators (KPIs) that measure business success by evaluating a value against a goal using MDX expressions and calculated members, with status and optional icons.

Explore Analysis Services security by applying grant or deny permissions to principals, configuring server and database roles in SSMS, and setting cell and dimension permissions inside the cube.

Customize cubes and cube security by creating a KPI for cost ratio, defining value, goal, and status expressions, and enabling drill-through actions.

Explore how actions extend analysis services and enable client calls to server-stored code, with MDX-based indicators, perspectives for focused views, translations, and server role, cell and dimension permissions.

Introduces MDX, the query language for retrieving multi-dimensional data from an Analysis Services cube. Explore MDX syntax, sets, tuples, and named calculations, and its XMLA-based extensions for Analysis Services.

Learn MDX select syntax, including placing measures like sales amount on columns and rows, and understand from and where clauses in a basic MDX query from the Adventure Works cube.

Master MDX techniques for data modeling in Analysis Services, including using between and set expressions, creating calculated members for profit, and navigating calendar hierarchies with descendants and children.

Explore how tabular data models use an in-memory relational database powered by x velocity, created with power pivot and deployed to analysis services for Excel or Power View on SharePoint.

Explore exam scenarios for Power Pivot and tabular data models, covering project creation, relationships, pivot tables and charts, security, deployment, and Excel integration.

Explore an introduction to DAX, learning to use DAX functions, run DAX queries, and create calculated columns and measures for data modeling and reporting.

Explore DAX built-in functions categorized into date and time, information, logical, math and trigonometry, statistical, and text, and see how DAX extends beyond Excel in these areas.