Audience
This course is for developers, analysts and business users that need to rapidly analyse large amounts of data, get insight into that data, retrieve hidden knowledge inside it, and report against various data sources professionally and effectively.
Prerequisites
Delegates are expected to have a basic overview of relational databases as well as an understanding of the fundamentals of reporting and analyses, ideally knowing the management and decision making processes in the companies.
It is not necessary to know the SQL Server. Components of Business Intelligence SQL Server are completely independent from the SQL Server databases, so they can be used over any data sources.
This course can be delivered at previous versions if required (ie 2008, 2008 R2 etc).
Duration
3 days. Hands on.
This course is available on site only. Please call for details.
Course Objectives
In this course you will learn how to give managers and other business users the ability to quickly and easily analyse large amounts of data, without waiting and without affecting production systems performance. You'll also learn how non-technical users can easily create reports, analyses, and charts on top of them - without the knowledge of SQL Server operations. And, you'll enable management to keep track of what's happening in the company in real time.
A special section will focus on building high-speed data warehouses, which serve to support such analyses. A highlight of the course will be the mining of valuable knowledge about the behaviour of customers or employees from the corporate data using built-in artificial intelligence, and its application to increase profits and customer satisfaction. The course concludes with options for integration of all these technologies into your corporate applications.
Course Content
Data Warehouses That Support Good Decisions
Data warehouses, data marts and their use in practice.
Preparation of data warehouses for decision support processes.
Filling of data warehouses and rapid updating.
Solving common problems and creating reliable data transfers.
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.
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 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.
Bonus: Enforcement of business rules in applications using Master Data Services.