Business Intelligence training Hyderabad : SQL School

[sqlschool]

SQL School offers Real-time Quality Training on SQL Server 2005 & 2008. We trust in providing quality and interactive trainings that is making us one of the pioneers in the software training market with trusted relationship with our trainees. We are launching new MSBI Online training sessions next week. Time : 9 AM India Time. Duration is 80 hours with 100% complete PRACTICAL TRAINING. NO PPTs nor Screenshots.

Please get an overview of the concepts we discuss:

SSIS Course Details

1. Introduction to SSIS
o What is SSIS?
o Why we need to use SSIS?
o Understanding basics of SSIS
o Understanding BIDS

2. Introduction to Control Flow
o Control Flow in SSIS
o Control Flow Tasks
o Workflow Tasks
o Precedence Constraints
o Data Processing Tasks
o Other SQL Operations Tasks

3. Introduction to Data Flows
o Data Flow in SIS
o Data Flow Pipeline
o Data Flow Sources
o Data Flow Destinations
o Data Viewers
o Data Flow Transformations

4. Variables and Configurations
o Understanding Variables
o Using Variables in Control Flow
o Using Variables in Data Flow
o Understanding Property Expressions
o Understanding Configurations
o User Configurations
o Using Variables and Configurations between Packages

5. Advanced Control Flow
o Advanced Control Flow Overview
o Using Containers
o Transactions Support in SSIS
o Additional Control Flow Tasks

6. Package Deployment
o Overview of Deploying Packages
o Deployment Challenges
o Create a Package Deployment Utility
o The Package Installation Wizard
o Deploy a Package to the File System
o Deploy a Package to SQL Server
o Redeploying Updated Packages

7. Package Management
o Overview of Package Management
o Managing packages with DTUtil
o Managing packages with SQL Server Management Studio
o Executing Packages
o Scheduling packages with SQL Server Agent
o SSIS Security

8. Introduction to Scripting and Custom Components
o Extending SSIS Capabilities Through Code
o The SSIS scripting
o Scripting in Control Flows
o Scripting in Data Flows
o Custom SSIS Components

9. Beyond ETL: Other Scenarios for SSIS
o Using SSIS Beyond ETL
o Migrating SQL Servers with SSIS
o SQL Server Maintenance Plans
o Working with Analysis Services
o Folder and File Management
o Working with Windows Event Log
10. Conclusion


SSAS Course Details

Introduction to Data Warehousing Concepts
i. What is Data Warehousing?
ii. Need for Data warehousing
iii. OLTP Databases Vs DW
iv. Multi-dimensionality
v. Star Schema

Introduction to Analysis Services
i. Need for SSAS
ii. Fundamentals of Analysis Services 2005 and 2008
iii. Architecture of SSAS
iv. FASMI Rules
v. Configuration of SSAS
vi. SSAS and SQL Server Browser Service
vii. Integration with SQL Server Components
viii. Analysis Services Components Overview

Designing Analysis Services Projects
i. Data Preparation
ii. Starting an Analysis Services Project
iii. Hierarchies and Attributes
iv. Dimension Design
v. Cube Design
vi. Basic Browsing

Advanced SSAS Design
i. MDX Queries
ii. Creation of Sub Cubes
iii. Partitions
iv. Aggregations
v. Analysis Actions
vi. Slowly Changing Dimensions (SCD)
vii. Perspectives
viii. Permissions and Roles
ix. Security over Cubes and Dimensions

MDX and Cube Analysis
Basic MDX
• Multi-dimensional expressions
• MDX queries
• Creating calculations
Advanced MDX
• Defining named sets
• Basic scripting
• Defining actions

Key Performance Indicators
i. What are KPIs
ii. Use and Variants of KPIs
iii. Browsing KPIs using UI and MDX
iv. KPIs and XMLA

Managing Analysis Services
i. Analysis Services Configuration
ii. Deployment Options
iii. Processing Types
iv. Browsing Cubes
v. Security Management
vi. Usage Based Optimizations (UBO)
vii. Importing SSAS Project

Performance Counters
i. SQL Server Profiler
ii. Performance Counters

Comparison with Analysis Services of SQL Server 2000
Migrating SSAS 2005 Projects to 2008
i. New features in SQL Server 2008
ii. Performance benefits over MSAS 2005
iii. Dimension and Cube Extensions
iv. Mining Extensions in SSAS 2008
v. Attribute Relationships and Properties
vi. Type I and Type II SCDs

Generation of Reports from SSAS Cubes
Best Practices and Conclusion

SSRS Course Details

1. Introduction to Reporting Services 2005 and 2008

Why Reporting Services?
Specialty of SSRS 2005 and SSRS 2008
Reporting Services Fundamentals
Reporting Services Architecture
Reporting Services Components Overview
Reporting Life Cycle

2. Authoring Reports

Developing Basic Reports
Enterprise Reports
Ad Hoc Reports
Report designing tools
Structuring and Formatting
Grouping and Sorting
Expressions and Reports
Aggregations usage in SSRS
Static and Dynamic Report Parameters
Matrix Reports and Charts
Organizing data in Reports
Char Based Reports
Sub Reports and Applications

3. Dynamic Reports

Conditional Formatting
Conditional Representation
Visibility and Toggles
Customizing Report Definitions

4. Managing Reporting Services

Report Server Configuration
Publishing Reports
Organizing and Managing Content
Managing Report Execution
Virtual Directory Configuration Management
Security Management
Performance Management

5. Delivery of Reports

Accessing Reports
Rendering Reports
Managing Subscriptions
Creating Reports with Report Builder
Report Models
Report Builder over IIS Manager
SSRS and Excel Sources

6. Automatic Delivery of Reports

Windows File Share
Email Delivery

7. SQL Server 2008 Reporting Services

New Features
Differences w.r.t SSRS 2005
Deployment Changes
IIS Administration and Share point Compatibility
Performance Considerations
Scalability and Optimization Tips

8. [/b]Security Parameters and Roles[/b]

Server Level Security
Report Level Security
Data Source level Security

9. Working with Analysis Services and Reporting Services

Use of OLAP Databases in Reports
MDX Implementation in SSRS
WriteBacks in SSRS
Security Mechanism over OLAP

10. Best Practices and Project

New MSBI session from DEC 2nd. Time: 9:30 PM India Time.

Course Fee is Rs 10000 [ USD 230], payable in two installments.


SQL DBA Trainings and Projects are also provided.

For Free DEMOs and more details, you can reach us anytime:

SAI PHANINDRA T
INDIA: 09666440801
US: 214-628-5666
contact@sqldbatraining.com
www.sqldbatraining.com

SQL School
Panncomm Center
near RS Brothers
Ameerpet, Hyderabad
Office : 040 - 6636 6635

[Guest-IJT]

Name : Gouri Ghewari
Email : gourighewari AT yahoo.in
Designation / Skillset : pune/graduate trainee engineer/chemical engineer
Gouri Ghewari
B.E(Chemical Engineering)
Fresher

Resume :

Career Objective :
To be part of an organization, which uses my skills and expertise in its process of growth, challenges and changes, while giving me ample opportunity to learn and enrich my competencies, so as to make meaningful and substantial contribution.
Academic Details :
Course
Institution
Board
Year of passing
Percentage
B.E
Chemical Engineering
K.L.E Society’s College of Engineering and Technology, Belgaum.
Visvesvaraya Technological University, Belgaum.
2011
73%
P.U.C G.I.Bagewadi
PU College
Nipani-591237
P.U C Board, Belgaum.
2007
67%
S.S.L.C V.S.M’s Girls
High School,
Nipani-591 237
K.S.E.E Board, Belgaum.
2004
86.08%
Computer Knowledge :
- Operating System : Windows XP
- Programming Language : C programming
- Chem-CAD
Industrial Training :
ratiopharm, Goa – Have Knowledge of different types of tablets and the processes involved in the manufacturing of tablets etc.
Katwa paints, Belgaum, Karnataka – Have Knowledge of different types of paints like Decorative Paints ant Protective Paints and the processes involved in the manufacturing of paints, enamels, primers etc.
Industrial visit :
DUDHGANGA (Sugar Industry, Chikkodi) Belgaum.
Final year project (KSCST Sponsored) : “Arsenic Removal By Phytoremediation”
Extra Curriculum & Co-curricular Activities :
Co-curricular activities.
- Secured 1st prize in poster presentation on “Pump and treat Technology for Ground Water Pumping” a National level poster presentation held at RV College of Engineering Bangalore.
- Secured 2nd prize in paper presentation on “Removal of Arsenic by phytoremediation”
a National level Symposium held at M.S.R.I.T College of Engineering Bangalore.
- Presented poster on “Herbal medicine extraction of sennoside from senna leaves” held at Bapuji Institute of Engineering and Technology, Davangere.
- Presented poster on “Utilisation of Mango peels as a source of pectin” a National level Symposium held at M.S.R.I.T College of Engineering Bangalore.
- Presented paper on “Renewable Energy Sources” a National level Tech Fest held at K.L.E.SCET Belgaum.
Extra-curricular activities :
- Conducted “BLOOD DONATION CAMP” in KLE College, was a volunteer.
- Active Participation in “VERMI COMPOST” conducted by NSS (National Seva Samith), in KLE College Belgaum, Karnataka.
- Participated in various events like mehandi, rangoli, karaoke, singing.
- Part of National Credit Corps and attended two camps.
Soft skills :
- Good team player
- Punctuality
- Communication skill
- Self Confidence
- Flexible

Reference
Prof. Prasad Hegde, Dept. of Chemical Engineering, K.L.E Society’s College of Engineering and Technology, Belgaum.
The information Furnished above are true to the best of my knowledge.
Date :29/6/2011
Place :Belgaum Miss. Gouri Basavaraj Ghewari
-------------------------------------------------------
More Information about this submission and submitter :-
___________________________________________________
Submission ID : 4346888
Date & Time : 8th Jul 2011 11:28 AM (UTC)
IP Address : 59.92.247.186
Browser Info : Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; chromeframe/12.0.742.112; GTB7.1; AskTB5.5)
Predicted Country : India