List of values in Business Objects

List of values in Business Objects A list of values contains the data values associated with an object. These data values can originate from a corporate database, or a flat file such as a text file or Excel file. List of Values is a powerful feature that allows users to select from a pick list… Read More »

Few Facts in Business Objects

1. What are the differences between Personal, Shared and Secured connections? A Personal connection is created by one user and cannot be used by other users. The connection details are stored in PDAC.LSI file. A shared connection can be used by other users through a shared server. The connection details are stored in SDAC.LSI file… Read More »

Conditional Column Hiding in BO 4.0

Conditional Column Hiding in BO 4.0 BO 4.0 offers a flexible means of column hiding. This is actually a component hiding feature that works for table/chart etc. Let us take the example, where we have Store Name, Lines, Quantity Sold and Sales Revenue with a prompt for Product We want to display Sales Revenue only… Read More »

Normalization Vs. Denormalization in Database

Normalized vs. Denormalized Normalization: Normalization is the process of efficiently organizing data in a database. There are two goals of the normalization process: eliminating redundant data (for example, storing the same data in more than one table) and ensuring data dependencies make sense (only storing related data in a table). Both of these are worthy… Read More »

Business Intelligence Training

Business Intelligence is a combination of knowledge in Business Process and Data Visualization Techniques. To create Reports, Dashboards you also need to know the underline data structure, hence Structured Query Language is essential as well! We will teach you well rounded BI solution from real world experience! OVERVIEW: 1. SQL for BI  — SQL techniques,… Read More »

New Positions

Tableau Developer in Pittsburg,PA JOB SUMMARY Interact with business users, other members of IT and possibly external clients at various levels of the organization. Provide meaningful display of operational data that would help business to arrive at decisions easily. ESSENTIAL DUTIES AND RESPONSIBILITIES · Analyze data related business problems and provide solutions with BI tools… Read More »

GreenPlum Vs SAP HANA

GreenPlum DBMS •highly scalable •fault-tolerant •high-performance •Based on Postgres •Shared-nothing architecture •Commodity hardware •Currently supported on Solaris, Linux HANA should be 100X faster than Greenplum or more for a typical query. This is due to the performance boost from avoiding disk I/O. Because memory is more expensive than disk, the cost of a HANA system… Read More »

Big Data Architect, MO

**US CITIZENS OR GREEN CARD HOLDERS ONLY** Client is in need of a Big Data Architect to implement analytic and sampling jobs in MapReduce and build new products by building large scale ETL processes and high performance service and message oriented architectures. The ideal candidate will have experience working with SQL, ETL Processes and Tools,… Read More »

PeopleSoft Tester:Harrisburg,PA

PeopleSoft Tester Position:              PS4 – PeopleSoft TesterLocation :             Harrisburg PADuration:               8 months Short Description: This position is for an experienced Test/QC Lead with PeopleSoft Financial projects and  excellent testing skills. Complete Description : Submitted candidates should have exp. as a QC / Test lead on PeopleSoft Financial projects.The on-going project will convert many core legacy… Read More »

How to Pass PMP at the first try WITHOUT going to Boot Camp

Exam Guideline: To pass the Project Management Professional (PMP) exam administered by Project Management Institute (www.PMI.ORG) you have to answer 200 questions in 4 hours (240 minutes) – so, its 1 Minute 12 Seconds per question; sounds easy right? But, most of the questions are lengthy and some questions might take 2-3 minutes to answer.… Read More »