COUNTRY
EN
FR
EN
NL
+32 (0)2 801 13 68
Contact us
How to register ?
Client account
Contact us
+32 (0)2 801 13 68
Contact us
How to register ?
TRAINING COURSES
OUR SOLUTIONS
CERTIFICATIONS
USEFUL INFORMATION
ABOUT ORSYS
All our training areas
Digital technologies
Management – Personal development
Business skills
How to register ?
inter-company training
In-house training courses
State-of-the-art seminars
Remote classrooms
Essentials 3:30
Customised services
Educational engineering
Publisher certifications
Certification programs
Corporate services
Framework contracts and packages
Our center in Brussels
Our center in Antwerpen
How to register ?
Overview of a training course
Sustainable development and CSR
Who are we?
Teaching method
en
bel
Course - SQL Server 2012 : Business Intelligence (Ref. BUI)
Course - SQL Server 2012 : Business Intelligence (Ref. BUI)
OBJECTIVES
PUBLIC
PROGRAMME
DATES
TRAINING COURSES
>
Digital technologies
Management – Personal development
Business skills
All our training areas
How to register ?
OUR SOLUTIONS
>
inter-company training
In-house training courses
State-of-the-art seminars
Remote classrooms
Essentials 3:30
Customised services
Educational engineering
CERTIFICATIONS
>
Publisher certifications
Certification programs
USEFUL INFORMATION
>
Corporate services
Framework contracts and packages
Our center in Brussels
How to register ?
Overview of a training course
Sustainable development and CSR
ABOUT ORSYS
>
Who are we?
Our training centers
Teaching method
Course : SQL Server 2012 : Business Intelligence
SQL Server 2012 : Business Intelligence
Instructional goals
Inter
In-house
Custom
Practical course
in person or remote class
Ref.
BUI
Price : Contact us
5d
- 35h00
Dates and Registration
Contact us
Training at your location, our location or remotely
Ref. BUI
5d
- 35h
Would you like to transpose this course—without changes—for your company?
Quote request
A la carte training
Do you want a training course tailored to the needs of your company and its teams?
Your training will be built to measure by our experts!
Quote request
Instructional goals
Teaching objectives
At the end of the training, the participant will be able to:
Create a control flow and implementing data transformations with the ETL, SSIS
Create an Analysis Services base and set up analysis dimensions
Cover the concepts of change data capture, data quality, and master data services
Understand the concepts of PowerPivot and Powerview, DAX queries for analysis
Creating and setting up reports with SSRS
Participants
Workshops built around actual business cases.
TRAINING PROGRAM
Intended audience
Prerequisites
Prerequisites
Instructional methods
Course schedule
» Introduction to Business Intelligence
The reasons why BI projects are launched.
What is a data warehouse?
The components of a data warehouse solution
The steps of modeling a DW (Ralph Kimball)
Understanding the principles of modeling (star, snowflake, fact constellation).
SQL Server BI, DataWarehouse platform.
Architecture of SQL Server 2012's BI tools.
Demonstration¤ implementations and uses of SQL Server 2012 Business Intelligence.
» Data Quality and Master Data Management (MDM)
The notion of a data quality standard.
Goals of Master Data management (MDS). Applying management rules in order to ensure the validity of the data.
Master Data Services.
The Master Data Management component DQS Cleansing.
Data deduplication.
Example¤Overview of quality models..
» Integration Services (SSIS), objects worked with
Understanding the principles and model of ETL. Overview.
The notion of Packages, the notion of Workflows.
Defining the control flow and the package.
Different tasks of a control flow: an SQL script, sending emails, updating the cube.
The “Change Data Capture“ task.
Add-in tasks (filewatcher).
Sequence container.
ForEach loop container.
Exercise ¤Creating and editing control flows.
» Integration Services (SSIS), knowing how to add to tables
Sources, destinations, and transformations.
Different transformations: Conditional split, derived column, grouping, etc.)
Slowly changing dimensions.
Deploying and running packages.
Scheduling and configuring packages.
Logging, security.
Exercise ¤Adding to a table. Implementing transformations. Creating and using packages. Using logs.
» Analysis Services (SSAS), building cubes and star schemas
Introduction to multidimensional cubes.
SSAS tab models.
Using dimension tables and fact tables.
Introduction to tabular cubes and to PowerPivot.
Creating cubes in BIDS.
Designing the dimension.
User hierarchies.
Attribute relationships.
Composite keys.
Exercise ¤Creating an Analysis Services database. Setting up dimensions. Creating cubes.
» SSAS: Advanced features
Introduction to the MDX language.
Calculated members and named assemblies.
Extraction and reports.
Partitions and aggregation designs.
DMX graphical prediction queries.
Backing up and restoring cubes.
Incremental updates and cube security.
Hands-on work ¤Working with the MDX language. Writing queries Implementing simple and complex calculations. Backing up a
» Introduction to Data Mining
The analytical business: Issues and approach.
Data mining algorithms: Decision Tree, Clustering, Sequence Clustering, Naive Bayes, Association etc.
The selection process with Data Mining.
The CRISP model.
Analysis tools in SSAS. Integration Services and Data Mining.
Group discussion¤Presentation of a marketing case study.
» Reporting Services (SSRS): Building reports
The report server.
Report Designer vs Report Builder 3.0.
Using Tablix (tables and matrices).
Advanced formatting elements (dates and currency).
Advanced presentation elements (conditional formatting, graphs and charts, sorting).
Analysis elements (expressions, KPIs, grouping and data mining, totals and subtotals).
The Report Model.
Other reports (MDX cube reports, related subreports and reports, extracting data with DMX).
Exercise ¤Getting started with tools. Creating, formatting, and enhancing the presentation and content of reports on the
» SSRS: Deploying and managing reports
Exporting reports in Excel and PDF, Word.
Using PowerPivot in Excel, DAX language.
PerformancePoint.
Configuration manager.
Deploying reports and report management with SharePoint.
Caching, report snapshots
Subscriptions (sending reports by email).
Safety
Exercise ¤Publishing reports in different formats. Working with PowerPivot in Excel.
Dates and locations
No session at the moment, we invite you to consult the schedule of distance classes.
From 13 to 17 May 2024
EN
Remote class
Registration
From 1 to 5 July 2024
EN
Remote class
Registration
From 14 to 18 October 2024
EN
Remote class
Registration
3