PCEC182

DATES:

1. Business Intelligence and Data Modeling Basics
   • Examine the PowerPivot Workbook and Power View Report.
2. SQL Server Reporting Services
   • Create interactive, free-form reports from relational, multidimensional, and XML-based data sources.
3. Report Designer
   • Use create query, report, and dataset parameters to filter, sort, and group data, access related reports, and report formatting.
4. Grouping and Aggregating Data
   • Evaluate a group expressions after the filters have been applied to the data and report data and data regions combined.
   • After the group expression has been created, customize a group.
5. Self-service Reporting
   • Enable Self-service Reporting.
   • Build reports from report parts previously published to a report gallery.
   • Structure report galleries efficiently to promote programmer productivity.
6. Report Execution and Delivery
   • Retain a copy of a processed report and return that copy when a user opens the report using caching.
7. Multidimensional Databases
   • Define and deploy a cube.
   • Define advanced attribute and dimension properties and code actions.
8. MDX
   • Add calculations to a cube and use MDX to query a cube.
9. Tabular Data Model
   • Use PowerPivot for MS Excel to create a tabular data model.
   • Create queries against tabular models that use the in-memory cache as the preferred query method.
10. DAX
    • Create expressions and formulas on MS SharePoint as a PowerPivot-enabled Excel workbook and on an instance of Analysis Services.
11. Creating Data Visualizations
    • Use Power View for creating a table and converting it to a number of visualizations: matrix, chart, and small multiples.
12. Performing Predictive Analysis
    • Test multiple data-mining models simultaneously with statistical scoring of errors and accuracy; confirm stability with cross-validation.

↓