Author Archives: Online Education

 An incident is an event, which may result in a failure or interruption of the activities, facilities or functions of an organization. Incident management (I.C.M) is a term that describes an organization’s activities. These activities include identifying, analyzing and correcting hazards. This is to prevent a future re occurrence of hazards. You can manage suchContinue reading “Explain ServiceNow incident management”

In this tutorial, you learn how to use SSIS Designer to create a simple Microsoft SQL Server Integration Services package. The package that you create takes data from a flat file, reformats the data, and then inserts the reformatted data into a fact table. In following lessons, the package is expanded to demonstrate looping, packageContinue reading “SSIS How to Create an ETL Package”

ETL stands for Extract, Transform & Load. In todays Data Warehousing world, this term should be extended to E-MPAC-TL or Extract, Monitor, Profile, Analyze, Cleanse, Transform & Load. In other words : ETL with the necessary focus on data quality & metadata. The figure underneath depict each components place in the overall architecture. The main goal of Extracting is to off-load theContinue reading “Best Practice ETL Architecture”

Alteryx and Tableau are powerful tools that can revolutionize data analytics and data consumption in any organization. Alteryx is a user-friendly ETL platform with a powerful suite of tools, including spatial and predictive analytics. Tableau is the best tool for sharing data in a dynamic visualization. The days of static cross-tabs are over. Consumers of reports wantContinue reading “Alteryx and Tableau: Complementary Tools for Every Analyst”

Any enterprise organization looking for a human capital management (HCM) solution should compare Workday vs. SAP SuccessFactors. These vendors are titans of the cloud-based HCM space. And given the mission-critical tasks you’ll need such a system to perform, you shouldn’t skimp when it comes to researching an HCM purchase. We provide this in-depth comparison toContinue reading “Workday vs. SAP SuccessFactors”

ou can use Workday Connector to connect to Workday from Data Integration. You can read data from or write data to Workday.Workday is an on-demand Cloud-based Enterprise Resource Application that includes financial management and human capital management applications. Workday exposes the web service API, which the Secure Agent uses to perform integration tasks through the SOAPContinue reading “Workday Connector overview”

When referring to business intelligence quality assurance, we often discover that the terms data warehouse (DWH) testing and ETL Testing are used interchangeably as though they are one and the same. Data warehouses can be defined as a collection of data that may include all of an  organization’s data. They came into existence due to more focus from senior management onContinue reading “Data Warehouse Testing, ETL Testing, and BI Testing: What’s the Difference”

Data in its “raw” form, in other words, the state in which it exists which it is first created or recorded, is usually not sufficient to achieve a business’s intended goals. The data needs to undergo a set of steps, typically called ETL, before it can be put to use. Those steps include the following:Continue reading “ETL architecture overview”

Workday vs. Oracle for human capital management (HCM) is always going to be a difficult comparison. It wasn’t long ago that Oracle took over PeopleSoft to gain a better position in the HR space, forcing the PeopleSoft CEO to leave and start another people-focused ERP company built on cloud technology. Workday is that company. WorkdayContinue reading “Workday vs. Oracle Cloud HCM: Comparing Two Human Resources Software Giants”

MuleSoft provides the most widely used integration platform to connect any application, data service or an API, across the cloud and on-premise continuum. Microsoft Azure is a cloud-based data-storage infrastructure that is accessible to the user programmatically via a MuleSoft ‘Microsoft Service Bus’ connector. The Microsoft Service Bus Mule connector allows developers to access any amount ofContinue reading “Integration of Mule ESB with Microsoft Azure”