Microsoft 70-466:Implementing Data Models & Reports
3.6 (8 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
152 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft 70-466:Implementing Data Models & Reports to your Wishlist.

Add to Wishlist

Microsoft 70-466:Implementing Data Models & Reports

Implementing Data Models & Reports with MSSQL Server 2012
3.6 (8 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
152 students enrolled
Last updated 12/2016
English
Current price: $10 Original price: $200 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 5.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • This course will prepare you to pass the exam Microsoft 70-466 Implementing Data Models & Reports with MSSQL Server 2012
  • You will be able to implement data models and reports with Microsoft SQL Server 2012.
View Curriculum
Requirements
  • Interest in implementing data models and reports with Microsoft SQL Server 2012
Description

This course 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. 

This course is designed for BI Developers who most-likely focus on hands-on work creating the BI solution including implementing multi-dimensional data models, implementing and maintaining OLAP cubes, and creating information displays used in business decision making. Primary responsibilities may include but are not limited to:

  • Working with large data sets across multiple database systems
  • Cube/warehouse/views fundamentals
  • Data model decisions: Unified Dimension Model (UDM) versus Business Intelligence Semantic Model (BISM)
  • Develop Cubes and Multidimensional Expressions (MDX) queries to support analysts
  • Online Analytical Processing (OLAP) cube performance
  • Building pivot tables from cubes
  • Building PowerPivot solutions
  • Design and test report models, layouts and templates
  • Manage reporting system: configuration and subscriptions
  • Using report builder to create reports
  • Develop complex SQL queries for reports
  • Building reports Using Crescent

This training course on implementing data models and reports with Microsoft SQL Server 2012 prepares participants for the Microsoft Exam 70-466.

This course will provide all the skills and knowledge for the following areas:

  • Designing dimensions and measures
  • Implementing and configuring dimensions in a cube
  • Designing a schema to support a cube architecture
  • Creating measures
  • Implementing a cube
  • Creating Multidimensional Expressions (MDX) queries
  • Implementing custom logic in a data model
  • Implementing storage design in a multidimensional model
  • Selecting an appropriate model for data analysis
  • Analyzing data model performance
  • Processing data models
  • Troubleshooting data analysis issues
  • Deploying SSAS databases
  • Installing and maintaining an SSAS instance
  • Configuring permissions and roles in a Business Intelligence Semantic Model (BISM)
  • Implementing a tabular data model
  • Implementing business logic in a tabular data model
  • Implementing data access for a tabular data model
  • Designing a report
  • Implementing a report layout
  • Configuring authentication and authorization for a reporting solution
  • Implementing interactivity in a report
  • Troubleshooting reporting service issues
  • Managing a report environment
  • Configuring report data sources and datasets

We create the highest quality course curriculum possible, ensuring you receive the training and knowledge needed to succeed. 

Who is the target audience?
  • IT Professionals
Students Who Viewed This Course Also Viewed
Curriculum For This Course
144 Lectures
05:17:55
+
Implementing Data Models and Reports with Microsoft SQL Server 2012
2 Lectures 01:47

Course Modules
01:11
+
Module 1
9 Lectures 17:17
SQL Server 2012 Business Intelligence
00:08


Introduction to Business Intelligence Part2
01:12

Data Warehouse
05:51

Extract, Transform and Load (ETL)
00:44

SQL Server Integration Services
00:54

SQL Server 2012 BI Tools
05:23

Developer Tools
02:00

Exam Scenarios
00:55
+
Module 2
19 Lectures 48:41

Introduction to SSRS Part1
00:13

Introduction to SSRS Part2
01:22

Creation and Delivery
01:21

SSRS Reports
02:34

Report Grouping
01:05


Drilldown Report Part1
01:58

Drilldown Report Part2
01:07

Parameters
03:40

Visual Components
00:48

Creating SQL Server Part1
05:43

Creating SQL Server Part2
06:03


Creating SQL Server Part4
05:27

Creating SQL Server Part5
05:25

Creating SQL Server Part6
01:55

Exam Scenarios
02:15

Module Review
01:16
+
Module 3
16 Lectures 38:50

Deploying Reports Part1
00:07

Deploying Reports Part2
00:39

Report Security Part1
00:49

Report Security Part2
03:20

Executing Reports
01:23

Report Caching
02:48

Report Snapshot
02:52


Data Alerts
02:03

Managing Reporting Services Part1
04:38

Managing Reporting Services Part2
05:19

Managing Reporting Services Part3
05:27

Managing Reporting Services Part4
05:09

Exam Scenarios
01:31

Module Review
00:53
+
Module 4
11 Lectures 32:05
Multidimensional Cubes
00:05


Cube Components
01:21

Creating & Configuring Analysis Services Cube Part1
05:25

Creating & Configuring Analysis Services Cube Part2
06:56

Creating & Configuring Analysis Services Cube Part3
04:08

Creating & Configuring Analysis Services Cube Part4
02:48

Creating & Configuring Analysis Services Cube Part5
04:12

Creating & Configuring Analysis Services Cube Part6
01:56


Module Review
00:40
+
Module 5
18 Lectures 45:44
Advanced Cube Concepts
00:07

Measures
01:02


Measure Groups
01:58

Measure Group Storage
03:28

Aggregations
01:01

Dimensions Part1
00:08

Dimensions Part2
00:51


Grouping and Sorting
02:27

Working with Measures Part1
03:57

Working with Measures Part2
04:39

Working with Measures Part3
05:51

Working with Measures Part4
04:41

Working with Measures Part5
04:16


Exam Scenarios
02:14

Module Review
01:04
+
Module 6
14 Lectures 31:56

Actions
01:26

Perspectives
01:33

Key Performance Indicators
02:32

Translations
00:46

SSAS Security
01:04


Dimension Permissions
00:51

Customizing Cubes & Cube Security Part1
06:32

Customizing Cubes & Cube Security Part2
04:44

Customizing Cubes & Cube Security Part3
05:35

Customizing Cubes & Cube Security Part4
01:39

Exam Scenarios
02:40

Module Review
01:21
+
Module 7
13 Lectures 23:48

Introduction to MDX
01:09

Why Use MDX?
01:13

MDX Syntax
00:51

MDX Queries and Filters Part1
00:29

MDX Queries and Filters Part2
01:33


Applying MDX
00:26

Working with MDX Part1
05:34

Working with MDX Part2
05:44

Working with MDX Part3
03:26

Exam Scenarios
01:53

Module Review
00:39
+
Module 8
19 Lectures 42:38
Tabular Data Models
00:12

Introduction to TDM Part1
00:14

Introduction to TDM Part2
01:04


Linked and Non-Linked Tables
00:56

PowerPivot
01:00

Server Based Tabular Data Models
01:12

Creating a Tabular Data Model
01:48

Workspace Database
01:16

Tabular Data Model Part1
02:31

Tabular Data Model Part2
00:48

Working with Tabular Data Modeling Part1
04:27

Working with Tabular Data Modeling Part2
05:34


Working with Tabular Data Modeling Part4
03:51

Working with Tabular Data Modeling Part5
04:43

Working with Tabular Data Modeling Part6
01:48

Exam Scenarios
02:01

Module Review
01:37
+
Module 9
12 Lectures 12:48
Data Analysis eXpressions (DAX)
00:05


Introduction to DAX Part2
00:53

Working with DAX
01:23

DAX Functions
00:35

DAX Queries
00:54

Calculated Columns
00:25

Measures
00:28

Multiple Relationships
00:49

Working with DAX within PowerPivot
04:38

Exam Scenarios
01:39

Module Review
00:48
1 More Section
About the Instructor
iCollege Certifications
4.1 Average rating
1,635 Reviews
11,060 Students
100 Courses
Certification Leader

iCollege is a leading international provider of E-Learning courses, learning technologies and development services.

Utilizing state of the art technologies, highly experienced consultants and innovative methodologies, we provide, cutting-edge education products, services and solutions for individuals, corporate organizations, governmental institutions and education providers.

Our collective knowledge and experience in education and training sets the standard for service delivery in learning solutions.

Stone River eLearning
4.2 Average rating
16,500 Reviews
273,505 Students
201 Courses
270,000+ Happy Udemy Students

At Stone River eLearning, technology is all we teach. If you're interested in programming, development or design - we have it covered. 

Check out our huge catalog of courses and join the over 450,000 students currently taking Stone River eLearning courses. We currently offer 100+ different technology training courses on our Stone River eLearning website and are adding new courses on hot and trending topics every month. A subscription option is available for those with a real passion for learning.