BLOG

On this blog, John Daniel Associates, Inc., writes about Business Analytics solutions and Corporate Performance Management (CPM) technologies. We write about solutions delivered with our partners, Qlik, IBM Cognos, and Vena Solutions.  Not sure where to start? Take a look at our guide to Business Analytics for beginners!

 

IBM Cognos Analytics – Conditional Notifications

Recently I was asked by a client to setup notifications for a daily report output. This is a routine request that can be addressed within the Cognos portal by creating and scheduling a job for the report. The unique challenge presented in my case however was that the client wanted results to be emailed to one set of recipients under a different condition than that

Read More »

Qlik Optimization Techniques

We have previously discussed some ways to optimize our Qlik applications. If you would like to review that post you may find it here.  I would like to expand this post with some new ideas and techniques for whenever you run into a large and complex application. First, let’s set the stage for what we are talking about. What is a large application? When we

Read More »

C# Windows Service Debug Hack

Recently, I worked on project that required me to develop a custom C# Windows Service, and it had been a long time since I’d last created one. I forgot how tedious it is to do simple debugging. The way I’ve learned to debug a service is to build, install, run, and then attach to running process in Visual Studio. Sounds like a lot of work

Read More »

Getting to Know You – Raw Data Exploration in QlikView

When faced with a new dataset, one of the first impulses is to get it into Excel to get a feel for it.  Occasionally the data set is too tall (too many rows) or too wide (too many columns) to effectively pull into Excel for quick and easy manipulation. If you’re lucky enough to have access to QlikView, you can make this task straightforward for

Read More »

Simple SQL Server Version Control

Tracking changes for projects is very important and allows us to revert back to previous versions. There is out-of-the box software to handle source control, but not all environments are equipped or disciplined enough to handle full version control–especially SQL objects, which can be changed with a simple F5 while applications are running. In the past, I’ve only used TFS with a SQL Server Database

Read More »

Budget for the Back to School Season with Qlik Sense

Budgeting for back to school supplies is always a painful process in my house. Sunday mornings are spent reviewing all of the school ads to try to determine which store is offering the best deals. My goal is to improve upon the yearly school supply budget by purchasing products at the best possible prices. Rather than waste time collecting and reviewing this information myself, why

Read More »

IBM Cognos Analytics – Conditional Notifications

Recently I was asked by a client to setup notifications for a daily report output. This is a routine request that can be addressed within the Cognos portal by creating and scheduling a job for the report. The unique challenge presented in my case however was that the client wanted results to be emailed to one set of recipients under a different condition than that

Read More »

Qlik Optimization Techniques

We have previously discussed some ways to optimize our Qlik applications. If you would like to review that post you may find it here.  I would like to expand this post with some new ideas and techniques for whenever you run into a large and complex application. First, let’s set the stage for what we are talking about. What is a large application? When we

Read More »

C# Windows Service Debug Hack

Recently, I worked on project that required me to develop a custom C# Windows Service, and it had been a long time since I’d last created one. I forgot how tedious it is to do simple debugging. The way I’ve learned to debug a service is to build, install, run, and then attach to running process in Visual Studio. Sounds like a lot of work

Read More »

Getting to Know You – Raw Data Exploration in QlikView

When faced with a new dataset, one of the first impulses is to get it into Excel to get a feel for it.  Occasionally the data set is too tall (too many rows) or too wide (too many columns) to effectively pull into Excel for quick and easy manipulation. If you’re lucky enough to have access to QlikView, you can make this task straightforward for

Read More »

Simple SQL Server Version Control

Tracking changes for projects is very important and allows us to revert back to previous versions. There is out-of-the box software to handle source control, but not all environments are equipped or disciplined enough to handle full version control–especially SQL objects, which can be changed with a simple F5 while applications are running. In the past, I’ve only used TFS with a SQL Server Database

Read More »

Budget for the Back to School Season with Qlik Sense

Budgeting for back to school supplies is always a painful process in my house. Sunday mornings are spent reviewing all of the school ads to try to determine which store is offering the best deals. My goal is to improve upon the yearly school supply budget by purchasing products at the best possible prices. Rather than waste time collecting and reviewing this information myself, why

Read More »