Developing SQL Data Models (M20768)

COURSE OUTLINE:

Description

In this course, you will learn about business intelligence (BI) solutions that implement multidimensional databases and create tabular semantic data models for analysis using SQL Server Analysis Services (SSAS).ï¿½

This course x incorporates material from the Official Microsoft Learning Product 20768: Developing SQL Data Models and can assist you in preparing for the 70-768: Developing SQL Data Models exam

Audience

Data analysts and power information workers
Database professionals who fulfill a BI developer role and create enterprise BI solutions and whose primary responsibilities include:
- Implementing multidimensional databases by using SSAS
- Creating tabular semantic data models for analysis by using SSAS

Prerequisites

Basic knowledge of the Microsoft Windows operating system and its core functionality
Working knowledge of Transact-SQL
Working knowledge of relational databases

Learning Objectives

Components, architecture, and nature of a BI solution
Create a multidimensional database with analysis services
Implement dimensions in a cube
Implement measures and measure groups in a cube
Use MDX syntax
Customize a cube
Implement a tabular database
Use DAX to query a tabular model
Use data mining for predictive analysis

1. Introduction to Business Intelligence and Data Modeling

Introduction to Business Intelligence
Microsoft Business Intelligence Platform

2. Create Multidimensional Databases

Introduction to Multidimensional Analysis
Create Data Sources and Data Source Views
Create a Cube
Overview of Cube Security
Configure SSAS
Monitoring SSAS

3. Working with Cubes and Dimensions

Configure Dimensions
Define Attribute Hierarchies
Sort and Group Attributes

4.ï¿½Working withï¿½Measures and Measure Groups

5. Introduction to Multidimensional Expressions (MDX)

MDX Fundamentals
Add Calculations to a Cube
Use MDX to Query a Cube

6. Customize Cube Functionality

Implement Key Performance Indicators
Implement Actions, Perspectives, and Translations

7. Implement a Tabular Data Model by Using Analysis Services

Introduction to Tabular Data Models
Create a Tabular Data Model
Use an Analysis Services Tabular Model in an Enterprise BI Solution

8. Introduction to Data Analysis Expression (DAX)

DAX Fundamentals
Create Columns and Measures in a Tabular Data Model Using DAX

9. Perform Predictive Analysis with Data Mining

Overview of Data Mining
Use the Data Mining Add-in for Excel
Create a Custom Data Mining Solution
Validate, Connect, and Consume a Data Mining Model

RELATED COURSES

Uncategorized

Microsoft Azure Big Data Analytics Solutions

55224A-1 is a two-day instructor-led course is intended for data professionals who want to expand their knowledge about creating big data analytic solutions on Microsoft Azure.ï¿½ Students will learn how to design solutions for batch and real-time data processing.ï¿½ Different methods of using Azure will be discussed and practiced in lab exercises, such Azure CLI, Azure PowerShell and Azure Portal.ï¿½ 55224A-1 labs and exercises cover the first two objectives of exam 70-475 (Designing Big Data batch, interactive & real-time solutions).ï¿½ The other two objectives (Designing Machine Learning and cloud analytics solutions) are covered in 55224A-2.

Uncategorized

DCINX9K ï¿½ Introducing Cisco Nexus 9000 Switches in NX-OS Mode v2.0

This course includes Cisco Training Exclusives

EXCLUSIVE TO GLOBAL KNOWLEDGE – Accelerate your Cisco learning experience with complimentary access to the IT Skills Video On-Demand Library, Introduction to Cybersecurity digital learning course, course recordings, IT Resource Library, and digital courseware.

Learn more

The DCINX9K – Introducing Cisco Nexus 9000 Switches in NX-OS Mode v2.0 course shows you how to implement, manage, and troubleshoot Cisco Nexus 9000 Series Switches in Cisco NX-OS mode. Through expert instruction and extensive hands-on learning, you will learn how to deploy capabilities including Virtual Extensible LAN (VXLAN), Multiprotocol Label Switching (MPLS), high availability features, Intelligent Traffic Director, troubleshooting tools and techniques, NX-OS programmability features, and open interface technologies. The course also provides an introduction to Cisco Data Center Network Manager (DCNM) for management.

Uncategorized

Requirements Validation and Testing

Quality is the major business differentiator in IT. Studies such as the Chaos Report show that the most common cause of low quality is having poor, or poorly understood, requirements. Other common causes are poor design, code, and installation. While prevention of defects is the best cure, identifying and fixing defects as early as possible is key, and some of the responsibility for doing that falls on the business analyst (BA). This course, therefore, concentrates on the validation techniques for:

Requirements
The system at the business level (functional and usability testing)
Acceptance
Business purpose (stakeholder satisfaction with the production product)

In this course you will learn the importance of achieving quality and your role in doing so. You will learn which project and product factors affect the two components of risk (likelihood and impact), and you’ll learn to apply those to various real-life validation situations using a case study and practicing testing decision-making. You will learn techniques for:

Validating requirements or any text-based product (such as procedures or plans)
Testing functional and manual requirements
Assessing and testing usability

You will learn to plan functional and usability testing at the business level and the essential elements to document that planning. You’ll examine your role in Acceptance, including Acceptance of an outsourced product, and you’ll determine how to assess stakeholder satisfaction with the product in production.

Since there is never time, even theoretically, to validate all details of a product, an important concept is using risk assessment to determine the appropriate thoroughness of validation at every stage. Exercises in risk assessment and all the major validation techniques are an integral part of this course.

While the involvement of BAs in testing varies widely across companies, this course assumes maximum involvement at the business level (excluding nonfunctional testing except for usability). Each student can tailor the content to suit a specific company’s policies.

Students pursuing a university-recognized and/or accredited certificate in Canada or continuing education units in the US must attend at least 90% of class time, participate in class exercises and section-knowledge checks, and score at least 70% on an end-of-class, multiple-choice assessment.

Uncategorized

F5 Networks Administering BIG-IP v12

This course gives network administrators, network operators, and network engineers a functional understanding of the BIG-IP system as it is commonly deployed in an application delivery network. The course introduces students to the BIG-IP system, its configuration objects, how it processes traffic, and how typical administrative and operational activities are performed. The course includes lecture, hands-on labs, interactive demonstrations, and discussions.