Home   Schulung > EDV > Backoffice > SQL Server

This course aims to help the participants to get on board with the latest Business Intelligence technology quickly, in a compact form. It covers the full SQL Server 2012 BI stack from its initial to the final stage. It starts with creating the data warehouses with Integration Services, leveraging the Data Quality Services for cleansing the data, and ensuring business rules in the data sources using Master Data Services. Then it moves on to state-of-the-art, real-time analyses of big data – first using Analysis Services, and then using PowerPivot. It also covers Power View, the ultimate self-service technology for interactive analysis and reporting. Then it moves on to creating professional reports using Reporting Services, and finishes with options for integration of all these technologies into your corporate applications. - Upon successful completion of this course, students will be able to: - Create data warehouses for BI solutions using Integration Services - Ensure data quality using Data Quality Services and Master Data Services - Analyse big data in real-time using Analysis Services and PowerPivot - Interactively analyse and report from data using the Power View technology - Create impressive reports using Reporting Services - Share reports and analyses using SharePoint 2010 - Integrate the above technologies seamlessly with corporate applications

Microsoft SQL Server 2012 Business Intelligence (engl.)

Ziel
This course aims to help the participants to get on board with the latest Business Intelligence technology quickly, in a compact form. It covers the full SQL Server 2012 BI stack from its initial to the final stage. It starts with creating the data warehouses with Integration Services, leveraging the Data Quality Services for cleansing the data, and ensuring business rules in the data sources using Master Data Services. Then it moves on to state-of-the-art, real-time analyses of big data – first using Analysis Services, and then using PowerPivot. It also covers Power View, the ultimate self-service technology for interactive analysis and reporting. Then it moves on to creating professional reports using Reporting Services, and finishes with options for integration of all these technologies into your corporate applications.- Upon successful completion of this course, students will be able to:- Create data warehouses for BI solutions using Integration Services- Ensure data quality using Data Quality Services and Master Data Services- Analyse big data in real-time using Analysis Services and PowerPivot- Interactively analyse and report from data using the Power View technology- Create impressive reports using Reporting Services- Share reports and analyses using SharePoint 2010- Integrate the above technologies seamlessly with corporate applications
Schulungsinhalte


· Data Warehouses that Support Good Decisions
Data warehouses, data marts and their use in practice . Preparation of data warehouses for decision support processes . Creating data warehouses using Integration Services (SSIS) . Filling of data warehouses and rapid updating using SSIS . Solving common problems and creating reliable SSIS data transfers

· Enforcing Data Quality
Introduction to Data Quality Services . Cleansing data . Matching data . DQS Client and SSIS Data Cleansing Transformation

· Master data management
Introduction to Master Data Services (MDS) . Creating MDS models and loading data into them . Enforcement of business rules in applications . Subscriptions and versions . Master Data Services for Excel Add-in

· Analysis Services - Flexible Real-time Analysis
Analysis capabilities of Analysis Services . Building OLAP cubes as a basis for analyses . Instant, flexible analysis using OLAP cubes - in an intuitive environment, optimized for analysts, managers, and business users . Monitoring business performance through KPI - Key Performance Indicators . Automated correction of problems identified in the enterprise through integrated actions . Adding your own logic into OLAP cubes . Interconnection with Excel for ordinary users . Translations and language versions of OLAP cubes . Bonus: Complex real-time event processing by StreamInsight technology .

· Data Mining - Mining Knowledge from Corporate Data
Automated analysis of the behaviour of customers and employees . Finding product package bestsellers . Customer segmentation and classification using artificial intelligence . Predicting trends of customer behaviour, market development or production errors . Discovery of hidden dependencies in the company data . Data Mining add-in for Excel

· Self-service Analyses - Tabular Models and PowerPivot
Creating a tabular model with SQL Server Data Tools . The use of tabular models for self-service analysis . DirectQuery storage model . Model security and access control .Introduction to PowerPivot for Excel and SharePoint technologies . Creating data models for PowerPivot . Techniques to import data into the PowerPivot environment . Working with massive amounts of data in PowerPivot . What-If Analysis, Slicers, Time Intelligence . Custom calculation using the DAX language (Data Analysis Expressions)

· Interactive Analyses with the Power View for SharePoint 2010
Self-service reporting environment of Power View . Interactive visualization and analysis of data using Power View . Filtering, sorting and highlighting data in the screens . Analysis of historical data in the context of current data . Creating multiple views for the same report . Design mode, Reading mode, Full-screen mode . Exporting analyses into dynamic PowerPoint presentations . Sharing reports and Power View Gallery .

· Reporting Services - Complete Reporting For Everybody
Overview and architecture of Reporting Services . Creating basic and advanced reports . Dynamic report formatting, aggregation of data . Using expressions for complex reports . Exporting reports to PDF, Word, Excel, JPEG, XML, CSV, ... . Adding navigation and contents to the reports . Hiding and displaying data . Adding charts, indicators, data bars, and sparklines into reports . Maps and geographic data in reports, integration with Bing Maps . Easy report creation directly by users through Report Builder 3.0 . Publishing reports and subscribing to automatic reports . Report security in Reporting Services . Integration with SharePoint 2010 . Data Alerts – sending reports automatically by data changes

· Integration with Corporate Applications
Querying the OLAP cubes from applications . Integration of Reporting Services with applications via web services . Integration of data warehouses and analyses with Reporting Services reports . Direct rendering and printing of reports in Visual Basic .NET . Real-time application of data mining knowledge in applications .
Zielgruppe
Developers, analysts and business users that need to quickly analyse large amounts of data, get insight into that data, retrieve hidden knowledge inside it, and report against various data sources professionally and effectively.
Voraussetzungen
Basic overview of relational databases. It is desired to have the fundamentals of reporting and analyses, ideally knowing the management and decision making processes in the companies. Components of Business Intelligence in SQL Server are completely independent from the SQL Server databases, so they can be used over any data sources. Therefore it is not necessary to know the SQL Server itself.
Ausschließlich als Inhouse-Schulung
Dieses Seminar bieten wir ausschließlich als Inhouse-Seminar in Ihren Räumlichkeiten oder bei uns in Münster an.
Seminardaten
Schulung-Nrsqls12bi
Dauer5 Tage
Inhouse-Schulung
Dieses Seminar bieten wir Ihnen als Inhouse-Seminar oder -coaching vor Ort in Ihren Räumlichkeiten an.

Rufen Sie uns bitte an:

+4925198 110 99 0
QRCode zu dieser Schulung