Course Description
Students will learn how to implement PowerPivot and tabular data models, create and deliver rich data visualizations with Power View and SQL Server Reporting Services, and discover business insights by using data mining.
Lesson 14: Performing Predictive Analysis with Data MiningOverview of Data Mining Using the Data Mining Add-In for Excel Creating a Custom Data Mining Solution Validating a Data Mining Model Connecting to a and Consuming a Data-Mining Model Lab : Performing Predictive Analysis with Data Mining
Lesson 1: Introduction to Business Intelligence and Data ModelingIntroduction to Business Intelligence The Microsoft Business Intelligence Platform Lab : Reporting and Analyzing Data
Lesson 2: Implementing Reports with Reporting ServicesIntroduction to Reporting Services Creating a Report with Report Designer Grouping and Aggregating Data in a Report Showing Data Graphically Filtering Reports Using Parameters Lab : Implementing Reports with Reporting Services
Lesson 3: Supporting Self-Service ReportingIntroduction to Report Builder Creating Reusable Report Items Lab : Supporting Self-Service Reporting
Lesson 4: Managing a Reporting InfrastructureManaging Security Managing Report Execution Delivering Reports with Subscriptions Troubleshooting Reporting Services Lab : Implementing Report Subscriptions
Lesson 5: Creating Multidimensional DatabasesIntroduction to Multidimensional Analysis Creating Data Sources and Data Source Views Creating a Cube Overview of Cube Security Lab : Creating a Multidimensional Database
Lesson 6: Working with Cubes and DimensionsConfiguring Dimensions Defining Attribute Hierarchies Sorting and Grouping Attributes Lab : Working with Cubes and Dimensions
Lesson 7: Working with Measures and Measure GroupsWorking With Measures Working with Measure Groups Lab : Configuring Measures and Measure Groups
Lesson 8: Introduction to MDXMDX Fundamentals Adding Calculations to a Cube Using MDX To Query a Cube Lab : Using MDX
Lesson 9: Customizing Cube FunctionalityImplementing Key Performance Indicators Implementing Actions Implementing Perspectives Implementing Translations Lab : Customizing a Cube
Lesson 10: Implementing a Tabular Data Model by Using Microsoft PowerPivotIntroduction to Tabular Data Models and PowerPivot Technologies Creating a Tabular Data Model by Using PowerPivot for Excel Sharing a PowerPivot Workbook and Using PowerPivot Gallery Lab : Using PowerPivot for Excel
Lesson 11: Introduction to Data Analysis Expression (DAX)DAX Fundamentals Using DAX to Create Calculated Columns and Measures in a Tabular Data Model Lab : Creating Calculated Columns and Measures by Using DAX
Lesson 12: Implementing an Analysis Services Tabular Data ModelIntroduction to Analysis Services Tabular Data Model Projects Implementing an Analysis Services Tabular Data Model in Business Intelligence Development Studio Lab : Working with an Analysis Services Tabular Data Model
Lesson 13: Creating Data Visualizations With Power ViewIntroduction to Power View Visualizing Data with Power View Lab : Creating Interactive Reports with Power View
Comments
Virtual 10778 Implementing Data Models and Reports with Microsoft SQL Server 2012 (Beta) Online Live training option
Imagine an industry-leading classroom training experience from wherever you have access to the Internet.
The Virtual Online Live events listed here gives you an effective and proven online virtual learning experience with the freedom to attend virtually from anywhere.
There is also an option of experiencing Online Live from one of the many national partner centers where a computer and headset will be provided for you.
This rich and engaging virtual classroom environment lets you conveniently interact with instructors and other students.
You will hear and see your instructor as they teach the course and answer your questions via voice or text.
Choose the online live virtual training option and you can access the recorded version even after the class has finished.
The onDemand labs give you access to the same client and server technologies covered in class so you can test, apply and hone your skills by accessing the labs before and even after the class.
Technical Requirements: a computer or laptop with a modern browser and high speed internet access along with one or two monitors.