Author Archives: Online Education

Today’s companies compete in ever more competitive and evolving markets. Finance companies are facing growing pressure to go beyond pure accounting management. Instead, handle everything like accounting, cash, assets, and programs. Besides, it handles cash, recruitment, programs, and planning.It handles  all to promote global development of the organization.  It can achieve sustainability and provide strategicContinue reading “Workday Financial management”

As a Network Engineer, I hated filling out tickets. Anytime a router would reboot or a power outage took place at a remote site, the resulting ticket generation took up about 50% of my day. If there had been a way to automate ticket creation, I would have saved a lot of time. The onlyContinue reading “Ansible + ServiceNow: Opening and Closing Tickets”

More precisely, the structured query language, or SQL, is a language that has been specifically designed for the domain of relational database management systems. This means it is a tool for handling large amounts of data stored in databases. Furthermore, its efficient coding structure has become a ‘role model’ to many other programming languages. Therefore, I can assert thatContinue reading “How to Connect SQL and Tableau”

Data Visualization Features in Microstrategy relate to the interface results for data. Although it is seen as a relatively complex tool in general, some engineering designs let users get more from data. For example, there is the ability to add reference lines to scattershot graphs, making some visual results more easily understandable. In terms ofContinue reading “MicroStrategy vs Tableau: Which BI Software Is The Winner?”

ETL is a type of data integration that refers to the three steps (extract, transform, load) used to blend data from multiple sources. It’s often used to build a data warehouse. During this process, data is taken (extracted) from a source system, converted (transformed) into a format that can be analyzed, and stored (loaded) into aContinue reading “ETL What it is and why it matters”

What is ServiceNow? ServiceNow is a cloud-based IT Service Management tool. It offers a single system of record for IT services, operations, and business management. 2) What is the full form of CMDB? The full form of CMDB is Configuration Management Database. 3) Name all the products of Services now ServiceNow offers various type ofContinue reading “ServiceNow Interview Questions and Answers”

Modern data lakes depend on extract, transform, and load (ETL) operations to convert bulk information into usable data. This post walks through implementing an ETL orchestration process that is loosely coupled using AWS Step Functions, AWS Lambda, and AWS Batch to target an Amazon Redshift cluster. Because Amazon Redshift uses columnar storage, it is well suited for fast analyticalContinue reading “Orchestrate an ETL process using AWS Step Functions for Amazon Redshift”

ServiceNow integrates with many third party applications and data sources. The most common integrations are with CMDB, Incident Management, Problem Management, Change Management, User Administration, and Single Sign-on. A variety of techniques can be used, most notably Web Services, JDBC, LDAP, Excel, CSV, and Email, as well as any industry standard technologies that use SOAP, REST,Continue reading “Integration with third-party applications and data sources”

When you spend a lot of time building dashboards, you tend to develop an approach or ways that make it easy to create the next one. After a while, you realize there are always ways to improve your design process in general. Today, I will answer share my Tableau dashboard best practices to help you through theContinue reading “Develop Your Design Process with Tableau Dashboard Best Practices”

The most common mistake people make when building an ETL system – or arguably any technology project – is that they jump into buying technology and writing code before thinking through the needs of their organization. Before you start building your ETL architecture, consider some fundamental questions. What sources do you need to extract dataContinue reading “ETL Architecture”