(+91) 9976297409 / 9600161303
+

WORKSHOPS

Tecxpera Technologies

Informatica

Informatica Corporation is a software development company founded in 1993. It is headquartered in Redwood City, California. It was founded by Diaz Nesamoney and Gaurav Dhillon. Anil Chakravarthy is the company's CEO. The company was founded in 1993. It went public on NASDAQ Stock Exchange under the stock symbol INFA on April 29, 1999.On April 7, 2015, Permira and Canada Pension Plan Investment Board announced that a company controlled by the Permira funds and CPPIB has signed a definitive agreement to acquire Informatica for approximately US$5.3 billion.On August 6, 2015, Informatica announced completion of acquisition with Microsoft and Salesforce Ventures joined as strategic investors. The company's stock ceased trading on the NASDAQ under the ticker symbol INFA effective on the same date.

Types of transformations
  • Active : One that can change the number of rows being output.
  • Passive : One that cannot change the number of rows being output.
  • Connected : One that has at least one link with other transformations or objects in a mapping
  • Unconnected : One that does not have any link with any transformations or objects in a mapping

Tera Data

Teradata Corporation is a publicly-held international computer company that sells analytic data platforms, marketing applications and related services. Its analytics products are meant to consolidate data from different sources and make the data available for analysis. Teradata marketing applications are meant to support marketing teams that use data analytics to inform and develop programs. In early 2015, the company formed two divisions: Data & Analytics for its data analytics platforms and related services and Marketing Applications for its marketing software and related services.The corporate headquarters are in Miamisburg, Ohio.

Corporate overview
  • Teradata is an enterprise software company that develops and sells a relational database management system (RDBMS) with the same name. Teradata is publicly traded on the New York Stock Exchange (NYSE) under the stock symbol TDC.
  • The Teradata product is referred to as a "data warehouse system" and stores and manages data. The data warehouses use a "shared nothing" architecture, which means that each server node has its own memory and processing power.

HADOOP Big Data

Hadoop

Hadoop runs applications using the MapReduce algorithm, where the data is processed in parallel on different CPU nodes. In short, Hadoop framework is capabale enough to develop applications capable of running on clusters of computers and they could perform complete statistical analysis for a huge amounts of data.

Hadoop Architecture:
  • Hadoop Common
  • Hadoop YARN
  • Hadoop Distributed File System
  • Hadoop MapReduce
Big Data

Big data usually includes data sets with sizes beyond the ability of commonly used software tools to capture, curate, manage, and process data within a tolerable elapsed time. Big data "size" is a constantly moving target, as of 2012 ranging from a few dozen terabytes to many petabytes of data. Big data is a set of techniques and technologies that require new forms of integration to uncover large hidden values from large datasets that are diverse, complex, and of a massive scale.

SAS

SAS (Statistical Analysis System) is a software suite developed by SAS Institute for advanced analytics, multivariate analyses, business intelligence, data management, and predictive analytics. SAS was developed at North Carolina State University from 1966 until 1976, when SAS Institute was incorporated. SAS was further developed in the 1980s and 1990s with the addition of new statistical procedures, additional components and the introduction of JMP. A point-and-click interface was added in version 9 in 2004. A social media analytics product was added in 2010.

The SAS software suite has more than 200 components Some of the SAS components include:
  • Base SAS – Basic procedures and data management
  • SAS/STAT – Statistical analysis
  • SAS/GRAPH – Graphics and presentation
  • SAS/OR – Operations research
  • SAS/ETS – Econometrics and Time Series Analysis
  • SAS/IML – Interactive matrix language
  • SAS/AF – Applications facility
  • SAS/QC – Quality control
  • SAS/INSIGHT – Data mining
  • SAS/PH – Clinical trial analysis
  • Enterprise Miner – data mining

Cognos

Cognos (Cognos Incorporated) was an Ottawa, Ontario-based company making business intelligence (BI) and performance management (PM) software. Founded in 1969, at its peak Cognos employed almost 3,500 people and served more than 23,000 customers in over 135 countries until being acquired by IBM on January 31, 2008. While no longer an independent company, the Cognos name continues to be applied to IBM's line of business intelligence and performance management products.

Cognos grew successful with its business intelligence products for local area networks (LAN), but new Internet technologies had come into the BI industry faster than the company had anticipated. After Cognos issued a notice informing shareholders of a slowdown in growth, many sold their shares, causing prices to fall quickly.

This prompted Cognos to build its web technology through the acquisition of other companies rather than internal research and development.

Obiee

Oracle Business Intelligence Enterprise Edition Plus, also termed OBI EE Plus, is Oracle Corporation's set of business intelligence tools consisting of former Siebel Systems business intelligence and Hyperion Solutions business intelligence offerings.

The industry counterpart and main competitors of OBIEE are Microsoft BI, IBM Cognos, SAP AG Business Objects and SAS Institute Inc. The products currently leverage a common BI Server providing integration among the tools.

International Business Machines Corporation (commonly referred to as IBM) is an American multinational technology and consulting corporation, with headquarters in Armonk, New York. IBM manufactures and markets computer hardware, middleware and software, and offers infrastructure, hosting and consulting services in areas ranging from mainframe computers to nanotechnology.

SAP SE (Systems, Applications & Products in Data Processing) is a German multinational software corporation that makes enterprise software to manage business operations and customer relations.

Web Sphere

WebSphere is an IBM brand of products that implement and extend Sun's JavaTwoEnterpriseEdition (J2EE) platform. The Java-based application and transaction infrastructure delivers high-volume transaction processing for e-business and provides enhanced capabilities for transaction management, as well as security, performance, availability, connectivity, and scalability.

In addition to Java, WebSphere supports open standard interfaces such as the Common Object Request Broker Architecture (CORBA) and Java Database Connectivity (JDBC) and is designed for use across different operating system platforms. One edition of WebSphere is offered for small-to-medium size businesses and another edition for larger businesses with a higher number of transactions.

WebSphere also includes Studio, a developer's environment with additional components that allow a Web site's pages to be created and managed. Both editions support Solaris, Windows NT, OS/2, OS/390, and AIX operating systems.

Tableau with R Language

R is a popular statistical language used to perform sophisticated statistical analysis and predictive analytics, such as linear and nonlinear modeling, statistical tests, time-series analysis, classification, clustering, etc.

The R-console primarily utilizes a command-line interface, but there are many GUI tools available for download to make it easier to write R programs (most of them are free). With R, users can create variables, formulas, functions, and graphs to visualize their analysis and predictions.

R functions and models can now be used in Tableau by creating new calculated fields that dynamically invoke the R engine and pass values to R. The results are then returned back to Tableau for use by the Tableau visualization engine.

This feature is primarily targeted for users who are already proficient at R. It is NOT meant for beginners with R. Anyone who wishes to use the new functions must first learn how to use R in order to leverage its capabilities in Tableau.