Resources
Guide

Continuously Optimizing IT in Financial Terms

CHALLENGES: Virtualization and increasingly complex agile computing environments are creating difficulties for IT financial controllers and for IT Financial Management (ITFM).  Virtualization breaks the long-standing direct, one-to-one correlation between cost-allocated physical hardware and the IT services it supports. Increasingly dynamic, multi-layered applications have made it more difficult...
Infrastructure Management
Article

Use Conditional Logic in Sequel Data Access to Convert Data into Meaningful Information

By Mike Stegeman on Thu, 03/30/2017
Let’s face it, the amount of data that we have is only continuing to grow, which will become harder to manage and understand. Per IDC Research, 90 percent of data in the world today was created in the last two years, and in 2016, we entered the zettabyte era. A huge challenge for everyone is finding the best way to convert all their data into meaningful information. But that can be tricky.  If...
IBM i Business Intelligence
Guide

DevOps Development: Keeping the Lights On

Overview: The DevOps methodology embodies two core philosophies: decreasing the lead time of software deployment and the automation of delivery and testing. DevOps emerged as a practical response to the agile development movement, in contrast with traditional, phase-based or “waterfall” development, which is inefficient and labor-intensive. Traditional methods should be phased out, and companies...
Infrastructure Management
Guide

Dashboards Don't Work (Unless You Have a Metrics Management Strategy)

Tech has had a tremendous impact on the way today’s businesses seek continued growth and improvement. No matter what business they are in, executives everywhere are investing in technology that improves their business processes, gets them ahead of the competition and widens their margins. Ultimately, the return on that investment is determined by how well technology supports a business’ ability to...
Infrastructure Management
Article

Enhance Your Reporting with Sequel Date Functions

By Heath Kath on Fri, 01/06/2017
Sequel makes it easy to work with your date fields, from converting the numeric or character field into a true date data type field to performing date calculations. Continue reading to learn how to convert non-date data type fields.
IBM i Business Intelligence
Article

How-To: Analyze Year-End Data Quickly with Flexible Client Tables

By Heath Kath on Thu, 12/01/2016
Year-end reporting is coming… Are you ready? Do you know your options? Are you prepared to collect all of the data you need to see how your company fared for the year? You’re in luck, because Sequel Client Tables make year-end reporting a breeze. Drill down into the level of information you need for your reports. Compare data across multiple years to spot trends and add context. And highlight...
IBM i Business Intelligence
Guide

Managing Data and Healthcare Regulations Efficiently

The right Business Intelligence (BI) tool can address the twin challenges of today's healthcare industry and regulations: efficient, secure information retrieval and effective monitoring of day-to-day operations. In February 2009, President Barack Obama signed the American Recovery and Reinvestment Act (ARRA). Title XIII of ARRA, called the Health Information Technology for Economic and Clinical...
IBM i Business Intelligence
Guide

Health and Risk: A New Paradigm for Capacity Management

Capacity management, considered by top analyst firms to be an essential process in any large IT organization, is often so complex that in today’s accelerated business world it cannot be effectively implemented. Changing priorities, increasing complexity and scalable cloud infrastructure have made traditional models for capacity management less relevant. A new paradigm for capacity management is...
Infrastructure Management
Article

Database 101: Why You Can Rely on IBM i

Fri, 08/19/2016
IBM i is the perfect environment for data access and reporting. Read this article to learn how you can better utilize your Power Systems databases.
IBM i Business Intelligence
Guide

Dispelling the Myths of IBM i Data Access

Ironically, many IBM Power Systems™ users are sitting on top of a “gold mine” of data that they could use to make their lives easier, their jobs more productive, and their companies more profitable—if they only knew how to harvest it. Yet, they don’t have the first idea about how to do that. They might even be considered “power users” on their computer systems and not know how to transform the...
IBM i Business Intelligence
Article

How Banks Leverage Big Data for Big Value

Fri, 08/19/2016
Technology professionals in the banking industry face a wide range of concerns due to the nature of the data stored within their systems. The potential reward in stealing or compromising financial data makes these organizations a prime target for cybercrime, while stringent industry regulations require security to be extremely tight at all times. Is it possible to strike a balance between defensive, regulatory, and data access needs and still provide access to data for analytics without compromising the security of the entire system? The truth is that many organizations in the financial sector have deployed analytics technology while being able to keep their security tight, and are benefiting from it.
IBM i Business Intelligence
Article

Add Power to SEQUEL Scripts with Logic

Mon, 08/01/2016
SEQUEL Scripting is a process that allows users to run multiple SEQUEL and system commands together. Scripts allow for much of the same capability of Command Language Programs (CLP) without the need for programming knowledge or a compiling of the objects.
IBM i Business Intelligence