BI & Data

Business Intelligence & Data Warehousing equips students with the latest tools and technologies on the Business Intelligence and Data Warehousing skills using SAS® Technologies and Analytics tools. This would prepare students for careers in Business Intelligence across a wide domain in the IT Industry.

Available Courses

Introduction

Just like the other GNIIT programs, this one too offers Professional Practice (PP) and guidance by means of PP coordinators, constructive reviews and meaningful mentorship. Also, in terms of specialization, this program offers a unique skillset which will enable you to control and manage organizational data using an array of BI tools. And that's not all. GNIIT brags of its very own Industry Collaboration Cell which assists students in getting their first IT job. Having placed 1,60,000 students over a period of last 5 years, the 200+ strong team is there to place you in the best professional position.

Audience

Program for School Students ,Programs for College Students

Pre-requisites

Students should have appeared for, or cleared Class 12, in 2013; or currently be in 1st year/2nd year of college in any stream.

Exit Profile

BI Solutions Developer

Semester Details

Course Name

Personal Computing and Networking Essentials

Course Description
  • Identify components & working of a PC
  • Identify new age computing devices such as Mobiles, Tabs, Ultra Notebooks etc
  • Identify the requirements for connecting and working on the Internet
  • Search specific content on the Internet
  • Identify various ways of representing numbers in computers
  • Identify network technologies
  • Identify and explain network media and their use
  • Understand and explain topologies
  • Identify standards & protocols
Course Name

Personal Productivity Tools

Course Description
  • Create and manage documents, worksheets & presentations
  • Use templates to automate document creation
  • Analyze Data Using PivotTables, Slicers, and PivotCharts
  • Customize tables and charts
  • Create customized formats with Styles and Themes
  • Adding SmartArt Graphics & special effects to a Presentation
  • Automate tasks using Mail Merge & Macros
Course Name

Logic Building and Effective Problem Solving

Course Description
  • Identify input and output requirements of a computer problem
  • Define programs and programming languages
  • Identify various tools used in problem solving
  • Solve problems using flowcharts & pseudocode
  • Use the dry run table
  • Use variables and constants
  • Define data types & use operators
  • Perform conditional execution & identify repetitive processes
  • Work with arrays
Course Name

Object-Oriented Programming with C#

Course Description
  • Identify features and phases of the object-oriented approach
  • Implement encapsulation and polymorphism in C# by using the various access specifiers
  • Identify and use operators including arithmetic, assignment, unary, comparison, and logical operators
  • Use decision-making constructs and loop constructs
  • Implement structures, enumerations, arrays and collections
  • Describe the various types of relationship such as inheritance, composition, utilization, and instantiation
  • Use various stream classes to implement file handling
  • Develop single and multithreaded applications
  • Explain and use delegates and events
Course Name

Information Search and Analysis Skills

Course Description

course

Course Name

Database Programming with Relational Database Management Systems

Course Description
  • Define DBMS architecture, database design life cycle and methodology
  • Describe types of data models
  • Create an entity-relationship model
  • Define normalization and de-normalization
  • Create logical & physical database design
  • Define Structured Query Language (SQL)
  • Write SELECT queries to retrieve data
  • Group and summarize data by using Transact-SQL
  • Query data using Joins and Subqueries
  • Implement indexes, views, and full-text search
  • Implement stored procedures and functions
  • Implement triggers and transaction
  • Implement managed code and message-based communication
Course Name

Information Analysis and Data Reporting Techniques

Course Description
  • Performing calculations with advanced formula
  • Organizing worksheet and table data
  • Writing VBA code to manipulate excel objects
  • Creating and modify charts
  • Analyzing data using Pivot Tables and Pivot Charts
  • Inserting graphic objects and enhance workbooks
  • Designing and creating a portal site
  • Organizing and manage business data on portal sites
  • Collaborating with others using workbooks and audit worksheets
  • Working with multiple workbooks and import and export data
  • Using Excel with the web and structure workbooks with XML
Course Name

Introduction to App Development

Course Description
  • Understand the application development life cycle
  • Explore GUI models of.NET Framework
  • Create a GUI application
  • Build a UI for an application
  • Customize the appearance of a GUI application
  • Understand the .NET event model
  • Bind UI controls to data sources
  • Gather, design and evaluate techniques in interaction design
  • Identify various debugging tools, testing strategies, and deployment techniques
  • Configure and deploy GUI applications
Course Name

Professional Skills-I

Course Description
  • Use awareness of his/her ability and competence in achieving goals set for him/herself
  • Identify the markers of personality and apply them to create a good first impression
  • Master and apply correct social mannerisms
  • Display an appreciation of cultural differences
  • Apply the fundamentals of effectively participating in a Group Discussion
Course Name

Project (on Previous Semester Skills)

Course Description

Semester Project

Course Name

HTML5 Programming

Course Description
  • Create and format Web pages & Web sites
  • Create tables, forms, and other Web page components Using HTML
  • Create a cascading style sheet
  • Write JavaScript programs
  • Transform and animate canvas elements
  • Add visual effects using jQuery
  • Implement geolocation and offline support
  • Identify the need for XML as a standard data interchange format
  • Create an XML schema
  • Create an eXtensible Style Sheet Language Transformation (XSLT) to format data
  • Perform conditional formatting & Use XPath pattern matching in a style sheet
Course Name

Professional Skills-II

Course Description
  • Communicate more confidently and effectively through responses to non-verbal cues and the use of appropriate gestures
  • Use different communication styles based on the situation
  • Demonstrate appropriate listening skills, build rapport and strengthen relationships
  • Apply and reiterate what is learnt through group discussions
  • Solve aptitude questions
Course Name

Project (on Previous Semester Skills)

Course Description

Semester Project

Course Name

Business Process Fundamentals and Information Systems

Course Description
  • Identify functions and processes within a business organization
  • Identify the role of Information Systems in business processes
  • Understand Enterprise Resource Planning
  • Identify the processes involved and role of Information Systems in Sales and Marketing
  • Identify the processes involved and role of Information Systems in Production Planning
  • Identify the processes involved and role of Information Systems in Logistics Planning
  • Identify the processes involved and role of Information Systems in Human Resource
  • Identify the processes involved and role of Information Systems in Financial Accounting
  • Identify the processes involved and role of Information Systems in Supply Chain Management
  • Understand the theory and concepts of contemporary customer relationship management
  • Identify and Implement the sales and marketing process flow
Course Name

Enterprise Reporting Using SAS Business Analytics Tools

Course Description
  • Navigate the SAS windowing environment
  • Read various types of data into SAS data sets
  • Validate, clean & combine SAS data sets
  • Create SAS variables and subset data
  • Create and enhance listing and summary reports
  • Access and manipulate local and remote data of various types
  • Create queries that filter and summarize data, compute new columns, and join multiple tables
  • Create interactive graph, frequency and tabular reports
Course Name

Introduction to Business Intelligence Systems

Course Description
  • Understand the need for information analysis in enterprises
  • Identify information analysis techniques in enterprises
  • Understand how information analysis is done in an enterprise
  • Identify the process of implementing a BI Solution for information analysis
  • Identify the significance of a BI Infrastructure (Datawarehouse and Datamarts)
  • Identify the various schemas and multidimensional objects used in multidimensional data modeling
  • Use a Multi-Dimensional Expressions for analysis
  • Identify OLAP cubes and their storage architecture
  • Deliver information in a BI solution
  • Managing performance using a BI solution
Course Name

Business Analysis Using SAS Business Analytics Plafrom - I

Course Description
  • Control SAS data set input and output
  • Summarize, read, and write different types of data
  • Perform DO loop and SAS array processing
  • Transform character, numeric, and date variables
  • Use tasks to transpose, stack, rank, and create a random sample of your data
  • Use several of the business user applications in the platform for SAS Business Analytics
  • Build SAS Information Maps, SAS Stored Processes, and SAS BI Dashboards
  • Consolidate information into a business reporting application
  • Examine the types of metadata created in the platform for SAS Business Analytics
Course Name

Business Analysis Using SAS Business Analytics - II

Course Description
  • Administer and create data sources
  • Create and exploit dynamic value selection
  • Build advanced information maps using SAS Information Map Studio
  • Build, schedule, and distribute advanced reports
  • Produce advanced stored processes to create dynamic data sources
  • Build advanced SAS BI Dashboard applications
  • Access requirements and examine options for building efficient OLAP cubes
  • Create and set security on SAS OLAP cubes
  • Extend the functionality of the cube using both wizards and the Multidimensional Expressions(MDX)language
  • Tune a SAS OLAP cube and perform cube maintenance
  • Use an OLAP cube in reporting applications
Course Name

Professional Skills - III

Course Description
  • Write an attractive resume
  • Handle interviews effectively and with ease
  • Solve aptitude questions and participate in group discussions in a mock professional scenario
Course Name

Project (on Previous Semester Skills)

Course Description

Semester Project

Course Name

Professional Practice-1

Course Description
Course Name

Professional Practice-2

Course Description
Introduction

The PGPBI program is cut out to provide a foundation as well as functional specialization, depending on the student's aptitude and interest. The program assumes the 24/7 availability of the student and equips them with a vast array of resources and services, both online and offline, for maximum productivity. Business Intelligence is a field built around discipline and this post graduate program has been specifically designed to turn you into a job ready and ordered professional.

Audience

Program for Graduates

Semester Details

Course Name

IT Fundamentals and Computing

Course Description
  • Identify components, working of a PC, and new age computing devices
  • Identify the requirements for connecting and working on the Internet
  • Search specific content on the Internet
  • Identify various ways of representing numbers in computers
  • Identify network technologies and explain network media and their use
  • Identify topologies, standards, & protocols
  • Identify input and output requirements of a computer problem
  • Define programs and programming languages
  • Identify various tools used in problem solving
  • Solve problems using flowcharts & pseudocode
  • Use the dry run table, variables, and constants
  • Define data types & use operators
  • Perform conditional execution & identify repetitive processes
  • Work with arrays
Course Name

Professional Skills

Course Description

Use awareness of his/her ability and competence in achieving goals set for him/herself.

  • Identify the markers of personality and apply them to create a good first impression
  • Master and apply correct social mannerisms
  • Display an appreciation of cultural differences
  • Effectively participate in a Group Discussion

Explain the communication process and identify various types of communication

  • Identify various communication styles
  • Overcome the barriers to effective communication
  • Identify effective listening skills
  • Identify techniques to build rapport, confidence, and self-esteem
Course Name

Object-Oriented Programming with C#

Course Description
  • Identify features and phases of the object-oriented approach
  • Implement encapsulation and polymorphism in C# by using the various access specifiers
  • Identify and use operators including arithmetic, assignment, unary, comparison, and logical operators
  • Use decision-making constructs and loop constructs
  • Implement structures, enumerations, arrays and collections
  • Describe the various types of relationship such as inheritance, composition, utilization, and instantiation
  • Use various stream classes to implement file handling
  • Develop single and multithreaded applications
  • Explain and use delegates and events
Course Name

Database Programming with Relational Database Management Systems

Course Description
  • Define DBMS architecture, database design life cycle and methodology
  • Describe types of data models
  • Create an entity-relationship model
  • Define normalization and de-normalization
  • Create logical & physical database design
  • Define Structured Query Language (SQL)
  • Write SELECT queries to retrieve data
  • Group and summarize data by using Transact-SQL
  • Query data using Joins and Subqueries
  • Implement indexes, views, and full-text search
  • Implement stored procedures and functions
  • Implement triggers and transaction
  • Implement managed code and message-based communication
Course Name

HTML5 Programming

Course Description
  • Create and format Web pages & Web sites
  • Create tables, forms, and other Web page components Using HTML
  • Create a cascading style sheet
  • Write JavaScript programs
  • Transform and animate canvas elements
  • Add visual effects using jQuery
  • Implement geolocation and offline support
  • Identify the need for XML as a standard data interchange format
  • Create an XML schema
  • Create an eXtensible Style Sheet Language Transformation (XSLT) to format data
  • Perform conditional formatting & Use XPath pattern matching in a style sheet
Course Name

Business Process Fundamentals and Information Systems

Course Description
  • Identify functions and processes within a business organization
  • Identify the role of Information Systems in business processes
  • Understand Enterprise Resource Planning
  • Identify the processes involved and role of Information Systems in Sales and Marketing
  • Identify the processes involved and role of Information Systems in Production Planning
  • Identify the processes involved and role of Information Systems in Logistics Planning
  • Identify the processes involved and role of Information Systems in Human Resource
  • Identify the processes involved and role of Information Systems in Financial Accounting
  • Identify the processes involved and role of Information Systems in Supply Chain Management
  • Understand the theory and concepts of contemporary customer relationship management
  • Identify and Implement the sales and marketing process flow
Course Name

Enterprise Reporting Using SAS Business Analytics Tools

Course Description
  • Navigate the SAS windowing environment
  • Read various types of data into SAS data sets
  • Validate, clean & combine SAS data sets
  • Create SAS variables and subset data
  • Create and enhance listing and summary reports
  • Access and manipulate local and remote data of various types
  • Create queries that filter and summarize data, compute new columns, and join multiple tables
  • Create interactive graph, frequency and tabular reports
Course Name

Analyzing and Presenting Business Data

Course Description
  • Organize, analyze and present business data for operations and reporting purposes
  • Perform "what-if" & goal-seek analysis for developing financial plans
  • Use tools & techniques to process and enhance the usefulness of business data
  • Employ new approaches for tabulating and managing business data
  • Translate business analysis into meaningful charts and graphs for better visual appeal
  • Analyzing, interpreting, refining, summarizing & presenting large amounts of data using PivotTables and PivotCharts
  • Automate repetitive tasks to minimize manual labor in data analysis
Course Name

Business Intelligence Fundamentals

Course Description
  • Introducing Business Intelligence System
  • Understanding Enterprise Framework and Information Analysis
  • Introducing Data Warehouse and Online Analytical Processing
  • Introducing Data Modeling Introducing Online Analytical Processing Services
  • Using Multi-Dimensional Expressions for Analysis
  • Information Delivery in Business Intelligence Solution
  • Aligning Business Goals using Performance Management Solutions
Course Name

SAS Programming 2

Course Description
  • Controlling Input and Output
  • Creating an Accumulating Total Variable and Accumulating Totals for a Group of Data
  • Reading Raw Data Files with Formatted Input and Controlling When a Record Loads
  • Do Data transformations by manipulating and converting character and numeric variables and type
  • Understand Debugging techniques
  • Process Data Iteratively
  • Restructure a data set by rotating and using Transpose procedure
  • Using Data manipulation techniques with Match merging
  • Using the SQL Procedure and Macro Language
Course Name

Macro Language Essentials

Course Description
  • Understand Macro Variables & Definitions
  • Understand Data Step & SQL Interfaces
  • Understand Macro Programs
Course Name

Creating Business Intelligence for your Organisation

Course Description
  • Overview of the Business User Reporting Applications
  • Creating Information Maps
  • Creating Stored Processes
  • Creating Dashboards
  • Overview of Data Management
  • Advanced Topics for Creating Information Maps
  • Advanced Topics for Creating Stored Processes
  • Advanced Topics for Creating Dashboards
  • Building a Business User Reporting Application Overview of SAS® Visual BI