GITSACADEMY 551cdaf84ec0a40f10260302 False 430 31

GITS Academy


GITS provides organizations and individuals with a complete and comprehensive suite of training offerings and modalities including instructor led, e-learning and blended learning solutions.

Latest update

#Clinical #Research #datamanagement #GITS #Academy #training #Bangalore
#Clinical #Research #datamanagement #GITS #Academy #training #Bangalore
view all updates 1482925221


MSBI (SSAS, SSIS, SSRS) INR 15000 INR 13000 MSBI (MICROSOFT BUSINESS INTELLIGENCE) - SQL SERVER 2008 (SSIS, SSAS, SSRS) SSIS Course Objectives: 16Hrs Module 1: Architecture and Introduction to SQL Server Integration Services Need for SSIS SSIS and DTS Comparison SSIS Architecture Control Flow Architecture Data Flow Architecture Data Pipeline Usage Precedence Constraints SSIS Event Handler SSIS Components SSIS Development Studio - BIDS SSIS Runtime Services SSIS Package Deployment SSIS Folders and File Structure Module 2: Designing and Implementation of SSIS packages SSIS Data Types, SSIS Variables, Connection Managers Data Flow Tasks usage SSIS Expressions Module 3: Designing and Implementation of Control Flow & Data Flow. Control Flow For Loop Container For each Loop Container Sequence Container Bulk Insert Task Data Flow Task Execute Package Task Execute SQL Task File System Task FTP Task Script Task Send Mail Task Transfer Database Task WMI Data Reader Task WMI Event Watcher Task XML Task Maintenance Plan Task Backup Database Task Shrink Database Task. Row Transformation: Character Map Transformation Copy Column Transformation Data Conversion Transformation Derived Column Transformation Script Component Transformation OLEDB Command transformation Rowset Transformation: Aggregate Transformation, Sort Transformation, Percentage Sampling Transformation, Row Sampling Transformation, Pivot Transformation, Unpivot Transformation Other Transformation Export Column, Import Column, Audit, Row Count, Slowly Changing Dimension Data Flow Task Split and Join Transformation Understanding of Extraction, Transformation, Loading Conditional Split, Multicast, Merge, Merge Join, Union All, Lookup Data Flow Sources Data Quality Transformation ADO NET Source, Excel Source Flat File Source, OLE DB Source, XML Source Fuzzy Lookup, Fuzzy Grouping Data Mining Transformation Data Mining Query, Term Extraction, Term Lookup Synchronous and Asynchronous Transformation SSIS Expression Data Sources Module 4: Debugging and Managing Package Execution Debugging Control Flow Debugging Data Flow Debugging Script Task Packaging Configuring XML File Configuring Multiple Configuring File, Package Logging Module 5: Detecting and Handling Processing Errors GITS ACADEMY #16, 3rd floor, 10th cross,Sampige Road Above Vijaya Bank, Malleswaram,Bangalore. Mail: Web: Call: 9632240775, 080-23467842 Error Handling Basic Error Detection and Handling Understanding of Event Handler Maintaining Data Consistency with Transactions Checkpoint, Checkpoint Restarts and Transaction Module 6: Securing and Deploying SSIS Packages Creating Deployment Utility, Securing Package Role – Based Security, Deployment Option Monitoring Package Execution and Event Logs Optimizing SSIS Packages Best Practices in SSIS, Real Time Scenario Discussion, Mock Project - 1 – Automation Legend: Students/Trainees should know/Aware before attending this course Basic SQL Server knowledge, SQL Server Run Time Services, SQL Server Agent After completion of this tool, Students will able to Handel the ETL Process, Design SSIS Package etc SSAS Course Objectives 16hrs Module 1: Understanding BI and Data warehousing Data warehouse concepts, Data warehouse Architecture Difference between Ralph Kimball and Bill Inmon’s What is Business Intelligence? Difference between OLTP vs. OLAP Module 2: Architecture and Understanding Analysis Services Understanding of OLAP, MOLAP, ROLAP What is SSAS? Need for SSAS SSAS Architecture Understanding of CUBE Structure Understanding of Schemas (Star, Snowflake) Data Source usage, Data Source View Computed and Named Queries Module 3: Designing and Creating Dimensions Understanding of Dimension Table Creating Dimension Table Understanding of Parent – Child Dimension Building Levels, Understanding of Fact Table Creating Fact Table Module 4: Designing Measures, Measure Group and Aggregations Measures and Additives, Semiadditive Measures Understanding of Aggregation Designing User Hierarchies Optimizing Aggregation, Query Log Usage Based Optimization Cube Operations – Dimension usage and Flexible cubes Building Fact-Dimension, Creating Calculation, MDX Scripting for Calculation Defining KPI’s and usage Partitioning, Perspective and usage What is MDX? Need of MDX MDX Basics, Complex MDX Queries, MDX Functions What is Data mining? Need for Data Mining Data mining structures and Algorithm Data mining levels, operating predictions Prediction Functions and Analysis Module 5: Implementing Security and Managing Deployment Using Role based security, Object level access Drill through Security, Windows Level Authentication, Security Audits. Deployment phases: OLAP Database Backups, Compression and Encryptions Restore Option, Write – Backs in Cube Automating Database Processing using SSIS Verification Techniques Managing Deploy Process Best Practices in SSAS, Real Time Scenario Discussion, Mock Project - 1 After completing of this course students will able to do: Design CUBE -OLAP DB SSRS Course Objectives 8hrs Module 1: Architecture and Introduction to SQL Server Reporting Services. Understanding of Reports, Introduction to SSRS, Need for SSRS Reporting Services SSRS three phase Lifecycle . SSRS Architecture Reporting components, Tools, Web Service Requirements and usage SSRS and IIS, and SQL Server Web Services Requirement for Virtual Directories Module 2: Designing and Implementation of Reporting Services Projects Report planning, Data Sources, Enterprise and Adhoc-reports Optimizing Data Sources Configuring connection and Data providers Report Designer: Wizard based reports, custom reportsUsing Table and Matrix Chart based report and images SSRS Expression, Parameter and Multi valued Parameter Filters in Data source Sub Reports, Reporting Option, Tabular Reports Exporting Reporting data Module 3: Use report models to implement reporting for business users Understanding of Report models Designing Report models Identifying Entities Identifying different Attributes Numerical Aggregation, Time Aggregation Module 4: Configure report publishing and execution settings Deployment Option Build and Deploy, publishing reports Configuration Option Managing Configuration Files Module 5: Implementing subscription for reports Creating Standard Subscription Data Driven Subscription Subscription Logging options Benefits of SSRS Logging Server Level Logging Options Report level logging Audit reports execution Best Practices in SSRS, Real Time Scenario Discussion, Mock Project – 1 After completing of this course students will able to do: Design Reports, publish reports subscription of the reports. After completing of MSBI course students will able to give solution to Business and handle the MSBI Projects, True 1432894339
MS SQL Server 2012 INR 7000 INR 5000 Introduction to Microsoft SQL Server 2012  Introducing Microsoft SQL Server 2012  Getting Started with SQL Server Management Studio Introduction to T-SQL Querying  Introducing T-SQL  Understanding Sets  Understanding Predicate Logic  Understanding the Logical Order of Operations in SELECT statements Writing SELECT Queries  Writing Simple SELECT Statements  Eliminating Duplicates with DISTINCT  Using Column and Table Aliases  Writing Simple CASE Expressions  Writing Basic SELECT Statement Querying Multiple Tables  Understanding Joins  Querying with Inner Joins  Querying with Outer Joins  Querying with Cross Joins and Self Joins Sorting and Filtering Data  Sorting Data  Filtering Data with a WHERE Clause  Filtering with the TOP and OFFSET-FETCH Options  Working with Unknown and Missing Values Working with SQL Server 2012 Data Types  Introducing SQL Server 2012 Data Types  Working with Character Data  Working with Date and Time Data Using Built-In Functions  Writing Queries with Built-In Functions  Using Conversion Functions  Using Logical Functions  Using Functions to Work with NULL Grouping and Aggregating Data  Using Aggregate Functions  Using the GROUP BY Clause  Filtering Groups with HAVING Using Subqueries  Writing Self-Contained Subqueries  Writing Correlated Subqueries  Using the EXISTS Predicate with Subqueries Using Table Expressions  Using Derived Tables  Using Common Table Expressions  Using Views  Using Inline Table-Valued Functions Using Set Operators  Writing Queries with the UNION Operator  Using EXCEPT and INTERSECT  Using APPLY Categories of SQL Statements  DML (Data Manipulation Language)  DDL ( Data Defination Language)  DCL (Data Control Language)  TCL (Transaction Control Language) Using Window Ranking, Offset and Aggregate Functions  Creating Windows with OVER  Exploring Window Functions Pivoting and Grouping Sets  Writing Queries with PIVOT and UNPIVOT  Working with Grouping Sets Querying SQL Server Metadata  Querying System Catalog Views and Functions  Executing System Stored Procedures  Querying Dynamic Management Objects Executing Stored Procedures  Querying Data with Stored Procedures  Passing Parameters to Stored Procedures  Creating Simple Stored Procedures  Working with Dynamic SQL Programming with T-SQL  T-SQL Programming Elements  Controlling Program Flow Improving Query Performance  Factors in Query Performance  Displaying Query Performance Data True 1432894160
Qlikview Training
Qlikview Training INR 15000 INR 13000 Introduction to QlikView • Overview of QlikView, QlikView data engine (associative query logic), in memory analytics. • QlikView Desktop • Installing QlikView • QlikView file components (.qvw, .qvd, .qvs file) • Basic Layout and Navigation Loading Data in QlikView • Connecting to data sources (heterogeneous) • Generating QVD • Fetching data from QVD • Building data model QlikView Layout (Developing the User Interface) • Introduction to QlikView Objects • QlikView object – List Box • QlikView object – Table Box • QlikView object – Multi Box • QlikView object – Charts (including pivot table) • Drill-down and cyclic groups • Other QlikView objects: o Text object o Current selection box o Slider/Calendar object o Containers o Search object • Variables • Buttons and actions • Bookmarks • Best Practice in Layout & Design QlikView Advance Scripting (Developing the Data Integration) • QlikView data structures • Building the script • Mapping tables, inline tables • Creating a calendar • Advanced scripting • Security – Section access True 1432892101
3DS MAX DESIGN INR 15000 INR 13000 The Engineering and Entertainment Design Tool 3ds Max from Autodesk focuses primarily on the Designing and Entertainment Media with a comprehensive 3D modeling, animation, rendering, and compositing solution for professionals in Product designing, Video Games, Film, and motion graphics industry. The training program takes you through the essentials of imaging, modeling and animation, through a variety of powerful tools and functions. The Course provides you with the versatility and agility to move through the interface and tools to deliver the required results. True 1428495107
Revit Architecture Training
Revit Architecture Training INR 15000 INR 12000 Autodesk’s Revit Architecture has been designed to equip construction and architectural professionals to convert the blueprint concepts to 3D based construction models. Leveraging on the BIM (Building Information Modeling) format, the program enables you to design & document a project, complete with geometrical and non-geometrical construction information. Students will be introduced to the concepts of BIM and trained in the complete design process from basic design conceptualization to construction documentation through 3D modeling using various Design Development tools. True 1428495682
Advanced Excel Training
Advanced Excel Training INR 4500 INR 3500 About The Course : Analyzing Business Data with Excel shows you how to solve real-world business problems by taking Excel's data analysis features to the max. Rather than focusing on individual Excel functions and features. This hands-on training targets specific business situations, and then demonstrates how to create spreadsheets for these problem areas. Learning Objective: At the end of the training the participants would learn/use/acquire the following techniques/knowledge: Data Management Organize the data from various sources Connect the data from different sources (eg: MS-Access, Text File, CSV File, SQL Server, ODBC etc) Data Analysis Data Validation Summarize the Reports Dashboard Report MIS Report Charts reports Scope of learning : User able to manage data independently User able to do reports (eg: Financial, Banking, Insurance, Pharmaceutical, Retail, Educational, small shops etc) User will become data analyst User will able to do MIS reports Maximum organization will use the excel It requires day to day activities to manage & analyse the data. For complete training Road map Please drop a Mail at : Make your payment on line True 1428492336
SAS Essentials for Analytics
SAS Essentials for Analytics INR 15000 INR 12000 SAS software is best described as an information delivery system suitable for an entire organization. SAS system is a software recommended for statistical analysis, business planning, data warehousing, insurance, banking and, finance . True 1428493388
Data Analytics Using R Studio
Data Analytics Using R Studio INR 13000 INR 10000 Analytics is the new age career option and there are immense opportunities in this space. There are various tools available to carry out Analytics activities. Two tools which stand out are SAS and R. SAS is a proprietary software with a huge cost attached to it, while R is an open source tool which can be downloaded and used freely for unlimited use. True 1428493684
View All

Our timings

[IS_BIZ_OPEN] Mon: 9:00AM  -  7:30PM
[IS_BIZ_OPEN] Tue: 9:00AM  -  7:30PM
[IS_BIZ_OPEN] Wed: 9:00AM  -  7:30PM
[IS_BIZ_OPEN] Thu: 9:00AM  -  7:30PM
[IS_BIZ_OPEN] Fri: 9:00AM  -  7:30PM
[IS_BIZ_OPEN] Sat: 9:00AM  -  7:30PM
[IS_BIZ_OPEN] Sun: 9:00AM  -  7:30PM


#719/A, J K Towers, 4th Floor, Above MORE Supermarket, 46th cross, Sangam circle, 8th block, Jaya nagar, – 560082
+91 8792590942  or   or   
Please keep or 0 before the
number when you dial.
Share Tweet



0 77.50515 GITS Academy #719/A, J K Towers, 4th Floor, Above MORE Supermarket, 46th cross, Sangam circle, 8th block, Jaya nagar, – 560082