Microsoft SQL Server Data Models & Reports
Microsoft SQL Server Data Models & Reports Course Rwanda
2KO Rwanda offers online SQL Data Models and Reports courses in Rwanda. We also offer full time SQL Data Models and Reports courses in Kigali for groups of four or more delegates. 2KO Rwanda's Data Models course is offered to our international and local students. 2KO International delivers consulting services, in the IT and Business space, as well as being a training provider for IT certification and user level courses. Training can be any blend of bespoke, classroom and online learning, to ensure students have access to the best Data Models training in Rwanda.
Register for an Online Microsoft Technical Course Here
2KO Rwanda's SQL course in Kigali 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. 2KO Rwanda also offers online courses to our international and local students. 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 is 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 2KO Africa training course on implementing data models and reports with Microsoft SQL Server 2012 prepares participants for the Microsoft Exam 70-466
This course will deliver 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
Microsoft 70-466 Implementing Data Models and Reports with Microsoft SQL Server 2012
Module 1
Course Introduction
Course Modules
SQL Server 2012 Business Intelligence
Introduction to Business Intelligence
Data Warehouse
Extract, Transform and Load (ETL)
SQL Server Integration Services
SQL Server 2012 BI Tools
Developer Tools
Exam Scenarios
Module 2
SQL Server Reporting Services
Introduction to SSRS
Creation and Delivery
SSRS Reports
Report Grouping
Expressions
Drilldown Report
Parameters
Visual Components
Creating SQL Server
Exam Scenarios
Module Review
Module 3
SSRS Management
Deploying Reports
Report Security
Executing Reports
Report Caching
Report Snapshot
Subscriptions
Data Alerts
Managing Reporting Services
Exam Scenarios
Module Review
Module 4
Multidimensional Cubes
Introduction to Cubes
Cube Components
Creating and Configuring Analysis Services Cube
Exam Scenarios
Module Review
Module 5
Advanced Cube Concepts
Measures
Formatting Measures
Measure Groups
Measure Group Storage
Aggregations
Dimensions
Dimension Storage
Hierarchies
Grouping and Sorting
Working with Measures
Exam Scenarios
Module Review
Module 6
Customizing Cubes and Security
Actions
Perspectives
Key Performance Indicators
Translations
SSAS Security
Cell Permissions
Dimension Permissions
Customizing Cubes and Cube Security
Exam Scenarios
Module Review
Module 7
MultiDimensional eXpressions (MDX)
Introduction to MDX
Why Use MDX?
MDX Syntax
MDX Queries and Filters
Sets
Applying MDX
Working with MDX
Exam Scenarios
Module Review
Module 8
Tabular Data Models
Introduction to TDM
PowerPivot
Linked and Non-Linked Tables
PowerPivot
Server Based Tabular Data Models
Creating a Tabular Data Model
Workspace Database
Tabular Data Model
Working with Tabular Data Modeling
Exam Scenarios
Module Review
Module 9
Data Analysis eXpressions (DAX)
Introduction to DAX
Working with DAX
DAX Functions
DAX Queries
Calculated Columns
Measures
Multiple Relationships
Working with DAX within PowerPivot
Exam Scenarios
Module Review
Module 10
Data Mining
Introduction to Data Mining
Data Mining Algorithms
Data Mining Components
Validating Mining Models
Presenting Mining Data
Creating a Mining Structure
Exam Scenarios
Module Review
Course Review