Blog Updates

11 Jan

TIBCO Certification Online Training India

EAI Architecture

  • Point to point Architecture
  • Hub and Spoke Architecture
  • Bus Architecture

What is Point to Point Architecture?

  1. This is the most primitive form of integration method
  2. In this architecture, direct connectivity is established between two systems/application as show in the picture below.
  3. It is extremely difficult to implement and equally difficult to maintain.
  4. When a large number of systems are inter-connected, Integration tends to be impossible.
  5. The number of connections needed to have fully meshed point – to – point connections, with n number of applications. I,e n(n-1)/2.

What is Point – to – Point Architecture?

  1. If there are 5 applications in an enterprise, we need 10 connects to integrate them. I,e n(n-1)/2.
  2. Examples; Postal Services, Telegram…

What is Hub and Spoke Architecture?

  1. In this architecture the central hub publishes and subscribes the messages and also co-ordinates the movement of message traffic.
  2. The central performs necessary content and format transformation.
  3. It also provides better maintenance of transformation and routing rules due to centralized approach.
  4. This architecture is convenient for companies with limited IT Resources and moderate transaction volumes.

What is Bus Architecture?

  1. In this mode of architecture the nodes are linked in a series along a common communication back bone with helps in reducing performance bottlenecks and single point of failure.
  2. It is better suited for large – scale environments involving hundreds of systems with heavy transaction volumes. In such a design integration logic (Transformation and routing information) is not maintained centrally.
  3. It also provides better sclability compared to hub and spoke architecture but more difficult to administer as the environment scales up.

Click here for Tibco video 

 

By Blog Updates 0 Comments
Read more...
09 Jan

TIBCO Certification Online Training India

Definition of EAI

Enterprise application integration (EAI) is the use of software and computer systems” architectural principles to integrate a set of computer applications in an Enterprise. Enterprise application integration (EAI) is an integration framework composed of a collection of technologies and services which form a middle-ware or “middle ware framework” to enable integration of systems and applications across an enterprise. EAI is the unrestricted sharing of data and business process among any connected application or data sources in the enterprise.

What is the Need of Integration in an Enterprise?

Many types of business software such as supply chain management applications, ERP Systems, CRM Applications, business intelligence applications, payroll and human resources systems typically cannot communicate with one another in order to share data or business rules.

Enterprise application integration is the process of linking such applications within a single organization together in order to simplify and automate business processes to the greatest extent possible. At the same time avoiding have to make sweeping changes to the existing applications or data structures.

The various systems that need to be linked together may reside on different operating systems, use different database solutions or computer languages, or different data and time formats, or may be legacy systems that are no longer supported by the vendor who originally created them

By Blog Updates , , , 0 Comments
Read more...
21 Dec

SAS BI Certification Online Training from India

What is SAS BI:

SAS BI – called Business Intelligence is a bundle of applications that helps in allowing and displaying data for the enterprises. An overview of what can be learned in SAS BI

  • Prepare Data
  • Display Data
  • Helpers
  • Administration

Prepare Data – Preparation of data to view it in Bi tool. This is usually done because raw data exists in relational databases like oracle, mysql etc. Then it is placed in OLAP cubes or information maps to view it.

  • SAS OLAP cubes – This helps in summarization of huge data to make it easy for viewing and drilling down information.
  • SAS information Map Studios – The original purpose of these information maps is to join data, rename variable and make it into a business friendly data.

Display Data – Once the data is prepared, there are many tools to display it, such as:

  • SAS Web report studio – Creates reports from OLAP cubes, Info maps, SAS datasets.
  • SAS Add-In for Microsoft Office
  • SAS BI Dashboard
  • SAS information delivery portal

Helpers –  It involves the following:

  • SAS Enterprise guide
  • SAS prompt framework
  • SAS stored Processes

Administration – Thiswill basically allow users to administrate system and control data access. Understand more about this here by signing up for a free demo.

Data Integration Studio in SAS :

SAS Data Integration Studio (SAS DI) is a GUI (Graphical User Interface) for generating and managing SAS codes. SAS Data Integration Studio (SAS DI) is used in building, implementing and managing data integration process as it is a most powerful tool with user friendly visual design, irrespective of the data sources. This also automates and supports integration and running of large enterprise projects in spite of the repeatable processes. Also the changes made across data integration process will change the impact analysis after creation and management of data and meta data. SAS Data integration also helps users to fine tune data integration by editing and changing, this also helps users to capture and manage standardized metadata from any source and also to understand enterprise metadata and data integration process for easy display and visualization. One most advantageous feature with SAS DI is that it enables programmers to write and blend tailor made code into the process for reusable purposes as well.

Following are different versions of SAS DI:

SAS DI studio was earlier called as SAS ETL studio. Being SAS 9.4 the recent version with compatibility to Versions 4.7 & 4.9, there are versions from 3.3 that compatible with SAS 9.1.

Learn more about SAS DI here.

By Blog Updates 0 Comments
Read more...
16 Dec

SAS BI Online Course | What is SAS Data Integration Studio

What is Data Integration Studio in SAS ?

SAS Data Integration Studio (SAS DI) is a GUI (Graphical User Interface) for generating and managing SAS codes. SAS Data Integration Studio (SAS DI) is used in building, implementing and managing data,integration process as it is a most powerful tool with user friendly visual design, irrespective of the data sources. This also automates and supports integration and running of large enterprise projects in spite of the repeatable processes. Also the changes made across data integration process will change the impact analysis after creation and management of data and meta data. SAS Data
integration also helps users to fine tune data integration by editing and changing, this also helps users to capture and manage standardized metadata from any source and also to understand enterprise metadata and data integration process for easy display and visualization. One most advantageous feature with SAS DI is that it enables programmers to write and blend tailor made code into the process for reusable purposes as well.
Following are different versions of SAS DI: SAS DI studio was earlier called as SAS ETL studio. Being SAS 9.4 the recent version with compatibility
to Versions 4.7 & 4.9, there are versions from 3.3 that compatible with SAS 9.1.

Learn more about SAS DI here.

By Blog Updates 0 Comments
Read more...
16 Dec

SAS BI Certification Online Training India

What is SAS BI:
SAS BI – called Business Intelligence is a bundle of applications that helps in allowing and displaying data for the enterprises. An overview of what can be learned in SAS BI
– Prepare Data
– Display Data
– Helpers
– Administration
Prepare Data – Preparation of data to view it in Bi tool. This is usually done because raw data exists in relational databases like oracle, mysql etc. Then it is placed in OLAP cubes or information maps to view it. SAS OLAP cubes – This helps in summarization of huge data to make it easy for viewing and drilling down information. SAS information Map Studios – The original purpose of these information maps is to join data, rename variable and make it into a business friendly data.
Display Data – Once the data is prepared, there are many tools to display it, such as:
SAS Web report studio – Creates reports from OLAP cubes, Info maps, SAS datasets.
SAS Add-In for Microsoft Office
SAS BI Dashboard
SAS information delivery portal
Helpers – It involves the following:
SAS Enterprise guide
SAS prompt framework
SAS stored Processes
Administration – This will basically allow users to administrate system and control data access.
Understand more about this here by signing up for a free demo.

By Blog Updates 0 Comments
Read more...
15 Dec

SAS Business Intelligence Online Training Course Content

SAS BI Course Content
Introduction to DWH / BI Concepts

  • SAS Web Report Studio 4.2
  • SAS EG 4.2
  • SAS Information Delivery Portal 4.2
  • SAS Data Integration Studio 4.2
  • SAS BI Dashboard 4.2
  • SAS Management Console 9.2
  • SAS Stored Process 4.2
  • SAS OLAP Cube Studio 4.2
  • SAS Stored Process Web Application 4.2
  • SAS Web OLAP Viewer for Java 4.2
  • Course Notes (Case Studies/ Exercises)
  • SAS Add-In for Ms Office 4.2
  • SAS Information Map Studio
  • LFS
  • Platform flow Manager PFM
  • SAS Web OLAP Viewer
  • SAS BI Dashboard 4.2

Chapter 1

  • Introduction
  • Overview
  • Audience

Chapter 2

  • Getting Started: The SAS Information Delivery Portal
  • Overview
  • Open the Portal and Log On
  • Create a Page and Add It to Your Navigation Bar
  • Add a SAS BI Dashboard Portlet to a Page

Chapter 3

  •  Working with Lists
  • Overview
  • Scroll Through a List
  • Delete One or More Items in a List
  • PART 2 Information for Dashboard Users 11

Chapter 4

  • Working in the SAS BI Dashboard Portlet
  • Select a Dashboard
  • Personalize a Dashboard
  • Personalize an Indicator
  • Create or Edit a Personal Indicator Alert
  • PART 3 Information for Dashboard Administrators 19

Chapter 5

  • Getting Started: Create a Dashboard
  • Create a Collection Portlet
  • Starting the SAS BI Dashboard from the SAS Information Delivery Portal
  • Creating a Dashboard
  • Create a Dashboard from Sample Data

Chapter 6

  • Data Models
  • Overview
  • Data Model Rules
  • Manage Data Models
  • Create or Edit a Data Model
  • Defining a Data Source

Chapter 7

  • Ranges
  • Manage Ranges
  • Create or Edit a Range

Chapter 8

  • Indicators
  • Overview
  • Manage Indicators
  • Create or Edit an Indicator
  • Indicator Displays
  • Indicator Alerts
  • Manage Dashboards
  • Create or Edit a Dashboard
  • Controlling the Appearance of a Dashboard
  • LSF
  • PFM

Data Warehousing Concepts (1week)

  • What is Data Warehousing
  • Why Use a Data Warehouse ?
  • Available Tools in the Market
  • Key Terms
  •  Architectural Concepts
  • Primary Components
  • What is ETL ?
  • Data Cleansing
  • Data Merging
  • Data Aggregation
  • Data Scrubbing
  • Historic Data
  • Current Data & Historical
  • Complete History
  • Limited/Unlimited Number of Histories
  • Load Types
  • First Time Load ( Initial Extraction )
  • Delta Load
  • Full Load
  • Incremental Loads
  • Schema Types
  • Star Schema
  • Snowflake Schema
  • Integrated Star Schema
  • Advantages of Each Schema
  • Dimensional Modeling Techniques
  • Conceptual Modeling
  • Logical Modeling
  • Physical Modeling
  • Named Input
  • Formatted Input
  • Data marts
  • Concept
  • Dependent vs Independent Data Mart
  • Enterprise Warehouse Schema
  • Implementation Methodology
  • Kimball Methodology
  • Inmon Methodology
  • Facts
  • Additive Facts
  • Semi Additive Facts
  • Non Additive Facts
  • Measures
  • Dimension Table Types
  • Slowly changing Dimensions
  • Type 1/2/3 Dimensions
  • Junk Dimensions
  • Confirmed Dimensions
  • Need of Time Dimension Comparison
  • Why is BI (Business Intelligence ) Required ?
  • OLTP
  • DSS
  • OLAP
  • Types of OLAP
  • ROLAP
  • MOLAP
  • HOLAP
  • DOLAP
  • DDE Triplet
  • Reporting Architecture
  • Database Layer
  • Interface Layer
  • Server Layer
  • Presentation layer
  • BI Server Systems
  • BI Client Systems and Functionalities
  • Hieracheis
  • Need of Hierarchies in Reporting
  • Need for ODS in Data Warehousing

SAS Enterprise Guide

  • Introduction on SAS EG Application.
  • Customizing SAS Enterprise Guide options
  • Setting up and managing profiles
  • Importing files from sources other than SAS
  • Accessing data via SAS libraries
  • Grouping and summarizing data
  • Gntroduction to querying data
  • Filtering and sorting data
  • Creating new columns with an expression
  • Joining tables
  • Grouping and summarizing data in a query (self-study)
  • Creating new columns by recoding values (self-study)
  • Creating a frequency report
  • Generating HTML, PDF, and RTF output
  • Creating a listing report
  • Creating a graph
  • Creating Stored Process from SAS EG.
  • Creating OLAP cubes from SAS EG.
  • Working on different STATASTICAL Procedures

SAS/DI STUDIO 4.2 (Data Integration Studio)

  • Exploring SAS Data Integration Studio
  • Working on Change Management
  • Explaining how to define source, target data structures and designing jobs.
  • Introduction to jobs and the job editor
  • Working with propagation and mappings
  • Working with intermediate files
  • Working with the extract transformation
  • Working with summary statistics transformation
  • Explore status handling for transformations and jobs
  • Working with the data validation transformation
  • Working with the sort transformation
  • Working with the append transformation
  • Working with the transpose transformation
  • Working with the apply lookup standardization transformation
  • Iterating a job with Loop transformations
  • Basics of the Table Loader transformation
  • Load styles of the Table Loader transformation
  • Table properties and load techniques of the Table Loader transformation
  • Introduction to change management and establishing a change management environment.
  • Defining slowly changing dimensions
  • Using the SCD type 2 Loader and Change Data capture transformations (Pre & Post Process).
  • Analyzing metadata using impact analysis
  • Deploying jobs for scheduling.
  • Deploying jobs as Stored Process.
  • Exporting and importing metadata
  • Building an OLAP cube
  • Building an information map
  • Building the dimensions
  • Building the fact tables.
  • Creating and Exploiting OLAP Using the SAS System

SAS OLAP Cube Studio 4.2

  • Introduction to Online Analytical Processing
  • Overview of SAS OLAP Cube Studio
  • Registering metadata
  • Working with SAS OLAP Cubes Derived from Detail Tables
  • Creating a SAS OLAP Cube from a detail table
  • Generating aggregations using cross- dimensional tuning
  • Setting permissions using SAS Management Console
  • Viewing a SAS OLAP cube with SAS Enterprise Guide
  • Working with SAS OLAP Cubes Derived from Star Sachems
  • Creating a SAS OLAP cube from a star schema
  • Viewing a SAS OLAP cube with SAS Web OLAP Viewer for JAVA
  • Monitoring and Tuning a SAS OLAP Cube

SAS Web Report Studio 4.2

  • Introduction on SAS Web Report Studio
  • Calling Information Maps into WRS.
  • Creating filters at WRS
  • Creating Layouts for Reports.
  • Creating Prompts.
  • Customizable roles to authorize capabilities(From SMC)
  • Working on Report Creation and Templates.

SAS Information Delivery Portal

  • Introduction to SAS IDP
  • Adding a Portal page
  • Adding Contents to Portlet.
  • Adding portlets to page.
  • Utilize SAS EG to create content and publish packages to the framework
  • Viewing and managing portal content.
  • Portal Customization
  • Call Reports from WRS to IDP.
  • User level Authentication.
  • Designing Portal
  • Creating Dashboards.
  • Calling STP into IDP.
  • Cubes in PORTAL/
  • Sharing portal content.

SAS Information Map Studio ;

  • Introduction to SAS information Map Studio.
  • updating an information map with filters, folders, and data items
  • Adding additional data sources to an information map
  • Overview of information map pre-filters
  • Building a general pre-filter
  • Building an authorization-based pre-filter
  • Information Maps and Stored Process.
  • Overview of stored processes
  • Associating stored processes with an information map
  • Using information maps in SAS Web Report Studio
  • Overview of surfacing data with information maps
  • Using information maps in the SAS Information Delivery Portal
  • Using information maps in SAS Enterprise Guide
  • Using information maps in the SAS Add-In For Microsoft Office
  • Overview of OLAP cubes
  • Building an information map for an OLAP cube

SAS Management Console 9.2

  • User Creation and Permissions
  • Creating Libraries
  • Creating connections with Data Bases and SAS Applications
  • Creating Repository and creating Folders levels at Repository
  • Checking (TEST) connections for Different SAS Servers.
  • Creating Flows For Scheduling ,Creating Jobs with dependencies and without Dependencies.
  • Migration from Test Servers to Production servers.
  • What is Metadata Tree and its Uses.
  • Configuring Different Servers @SAS Management Console.
  • Explain The Structure at SERVER LEVEL and SMC LEVEL(like Where the log files, Config Files,

Batch Files, executable files are stored For running different servers successfully.)

  • Brief Explanation about LSF and Process Managers
  • Brief Explanation about WEB Servers like the purpose of XYTHOS ,TOMCAT,Websphere.
  • START and STOP Servers, Take Backups….

Register today to attend Free Instructor Led Online Demo 

By Blog Updates 0 Comments
Read more...
15 Dec

SAS BI Certification Question and Answers

1 Question What are the new features included in the new version of SAS i.e., SAS9.1.3?
Answer The main advantage of version 9 is faster execution of applications and centralized access of data and support.
2 Question What versions of SAS have you used (on which platforms)?
Answer SAS 9.1.3,9.0, 8.2 in Windows and UNIX, SAS 7 and 6.12
3 Question Approximately what date is represented by the SAS date value of 730?
Answer 31st December 1961
4 Question How do you debug and test your SAS programs?
Answer Using Obs=0 and systems options to trace the program execution in log.
5 Question How could you generate test data with no input data?
Answer Using Data Null and put statement
6 Question What is the purpose of error?
Answer It has only to values, which are 1 for error and 0 for no error.
7 Question What are some good SAS programming practices for processing very large data sets?
Answer Sort them once, can use firstobs = and obs = ,
8 Question How do you control the number of observations and/or variables read or written?
Answer FIRSTOBS and OBS option
9 Question How do you test for missing values?
Answer Using Subset functions like IF then Else, Where and Select.
10 Question How can you put a “trace” in your program?
Answer ODS Trace ON, ODS Trace OFF the trace records.
11 Question How to limit decimal places for variable using PROC MEANS?
Answer By using MAXDEC= option
12 Question Describe 5 ways to do a “table lookup” in SAS.
Answer Match Merging, Direct Access, Format Tables, Arrays, PROC SQL
13 Question What is a method for assigning first.VAR and last.VAR to the BY groupvariable on unsorted data?
Answer In unsorted data you can’t use First or Last.
14 Question Identify statements whose placement in the DATA step is critical.
Answer INPUT, DATA and RUN…
15 Question What are _numeric_ and _character_ and what do they do?
Answer Will either read or writes all numeric and character variables in dataset.
16 Question What are the validation tools in SAS?
Answer For dataset: Data set name/debugData set: name/stmtchk
For macros: Options:mprint mlogic symbolgen.
17 Question What are the default statistics for means procedure?
Answer n-count, mean, standard deviation, minimum, and maximum
18 Question Where do you use PROC MEANS over PROC FREQ?
Answer We will use PROC MEANS for numeric variables whereas we use PROC FREQ for categorical variables.
19 Question Describe CROSSLIST option in TABLES statement?
Answer Adding the CROSSLIST option to TABLES statement displays crosstabulation tables in ODS column format.
20 Question How to specify variables to be processed by the FREQ procedure?
Answer By using TABLES Statement.
21 Question What is the one statement to set the criteria of data that can be coded in any step?
Answer OPTIONS Statement, Label statement, Keep / Drop statements.
22 Question What are the scrubbing procedures in SAS?
Answer Proc Sort with nodupkey option, because it will eliminate the duplicate values.
23 Question How do you debug and test your SAS programs?
Answer First thing is look into Log for errors or warning or NOTE in some cases or use the debugger in SAS data step.
24 Question What are some good SAS programming practices for processing very large data sets?
Answer Sampling method using OBS option or subsetting, commenting the Lines, Use Data Null
25 Question What areas of SAS are you most interested in?
Answer BASE, STAT, GRAPH, ETS.

SAS BI Business Intelligence Online Training Course 

By Blog Updates 0 Comments
Read more...
14 Dec

SAS Business Intelligence Online Training | SAS BI Online Course

What is SAS BI?
What is Data Integration Studio in SAS BI?

What is SAS DI?
Visual design tool that enables you to consolidate and manage enterprise data from a variety of source systems, applications and technologies.Create process flows and perform – extract, transform, and load (ETL) data for use in data warehouses -cleanse, migrate, synchronize, replicate, and promote data for applications.

What does SAS DI Do?

Give business users at all levels the ability to explore data from the warehouse in a web browser, to perform simple query and reporting functions, and to view up-to-data results of complex analyses Centrally control the accuracy and consistency of enterprise data.

Successful candidates need to be skillful in Online SAS BI Course with topics like:

By Blog Updates , , , 0 Comments
Read more...
08 Dec

Microsoft Azure and Machine Learning Online Training

Azure machine learning:

Azure machine learning was launched in 2015, Feb and has immediately changed the technology game of the industry to help solve the problems of big data processing. As this provides an independent work space, ML workspace (Machine Learning) workspace is a place where all the objective work is done like taking it live apart from general Azure dashboard. Workspace can be accessed at azure studio with UI being more clear and coherent even though the dependency of items is not always the same. Following are the items that are more used in this workspace:

  1. Datasets – Usually these are data containers
  2. Experiments – Used to create, test and train the models
  3. Tested models – these are trained and tested models which can be reused
  4. Web services – Used to gain new predictions.

In routine training terms, Machine Learning is used for predicting the day to day complex issues such as weather forecasts, traffic jam analysis and more, Azure ML helps create, deploy and maintain solutions to these kind of predictive problems.

Online training on Azure Machine Learning from Adithya e-learning involves real time training to make candidates understand different scenarios. Advantage with Azure machine learning is it involves very less or no coding and the entire process is a drag and drop model. To learn and understand more, click here.

By Blog Updates 0 Comments
Read more...
08 Dec

Microsoft Azure 8.1 Certification Online Training

Azure Cloud:

Cloud computing has become a mainstream technology in most of the companies and that has become a well-known fact all over but the new word of the day is all about harnessing the power of cloud computing and streamlining the performance of cloud to make its infrastructure more powerful which produces higher returns to the enterprises. In this scenario, more and more cloud computing technologies are evolving, out of which Azure cloud is a growing technology and the certification of Azure have immense implications in the real world job industry.

What is Azure Cloud:

It is an integrated technology blending with different dimensions such as computing, analytics, storage, database, networking & mobile for achieving better ROI’s within an optimised investment and implementation. Certification on Azure will help in gaining the professional recognition for expertise over entire architecting, developing and administering azure solutions, making them Azure specialist. Adithya e-learning offers the high standard industry level training program on Azure cloud which will help in clearing the certification as well. Online training involves work on scripting applications for azure, virtualization, deploying azure infrastructure solutions, managing IT solutions and a real time project.

Know more about Azure cloud here.

By Blog Updates 0 Comments
Read more...