Good MSBI Course Training @ Marathahalli - Bangalore

MICROSOFT BUSINESS INTELLIGENCE

SQL SERVER INTEGRATION SERVICES (SSIS):
1.Need of Business Intelligence
2.Above MSBI and Available technologies and tools
3.Introduction to SSIS
4.Leveraging ETL capabilities of SSIS and ETL procedures
5.Running wizard for basic migration
6.About SQL Server Business Intelligence Development Studio
7.Elements of a SSIS project
8.Elements of a Package
9.Creating a SSIS Project using Business Intelligence Development Studio
10.Creating a new Package
11.Executing a package
12.Adding an existing package to the Project
13.Understanding the tasks
14.About control flow and Dataflow operations
15.In detail about Each transformation in Dataflow Task
16.Handling errors Handling Events
17.Log ETL operations
18.Choosing Log providers
19.Best practices for error handling and Logging
20.Deployment process and types
21.SSIS package configuration
22.Type of configurations and Advantages
23.Best practices for configuration and Deployment
24.Running and monitoring
25.Optimizing and Scaling of SSIS packages
26.Tips for how to scale performance of an SSIS package
27.Automation through Jobs creation
28.Scheduling

SQL SERVER REPORTING SERVICES (SSRS)
1.Importance of Reporting Servers & Services
2.Stopping and starting SSRS services
3.Using reporting services tools
4.Creating & Elements of SSRS projects
a.Data sources: Shared and Private
b.Data Set
c.Report designer
5.Report planning/modeling
6.About Static, Dynamic/Parameterized reports
7.Adding/Removing data sets
8.Data Filtering: parameters, Parameter lists
9.Cascading Parameters
10.Adding calculated values to the reports
11.Formatting reports
12.Grouping Data: Row groups, Columns Groups
13.Dill down
14.Drill trough reports: Implementing Interactive Navigation in reports
15.Matrix reports
16.Sub Reports
17.Graphs and Charts
18.Publishing/Deploying/uploading reports onto a SSRS Server
19.Managing reports through report manager
20.Creating cached instances
21.Creating Snapshots and history
22.Browsing and configuring of published reports
23.About Report Subscriptions
24.Creating Report Subscriptions
25.Managing Report Subscriptions
26.Roles & Security


SQL SERVER ANALYSIS SERVICES (SSAS)
1.Leverage SQL Server Analysis Services to produce Business Intelligence solutions
2.Create OLAP cubes and automate maintenance with XMLA scripts and SSIS packages
3.hierarchies and dimension relationships
4.Build custom solutions with MDX and implement Key Performance Indicators (KPIs)
5.Creating and deploying a cube
6.Star Schema, Snow Flake Schema
7.Surrogate Keys
8.Automating cube processing with an XMLA script
9.Configuring many-to-many dimension relationships
10.Implementing an action to open a Reporting Services report
11.Retrieving data using MDX
12.Developing Reports using Cube
13.Developing Reports in excel using Cube
Interview Questions discussion


Contact us for more details
ELEGANT IT SERVICES
9 8 8 6 5 4 1264
Email: elegantitservice@gmail.com
Website: www.elegantitservices.com