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!

 

Anatomy of a Metric: KPI Assessment for Analysis Application Design & Data Modeling

When designing quality analytics applications that meet the expectations and requirements of various business users, being specific can mean the difference between collaborative success and argumentative failure. Rising to meet the challenge of satisfying these varied roles can be daunting. Executives, Managers, Business Analysts, Application Designers, Data Modelers and Developers may all be involved. While each of these roles has a different perspective regarding the

Read More »

ASP.NET MVC 5 Custom Role Providers for Windows Authentication

With ASP.net MVC, restricting access to actions has never been easier. The AuthorizeAttribute allows you to easily restrict access to controllers or actions based on a user’s role. See the example below. 1 2 3 4 5 6 7 8 9 10 11 12 [Authorize(Roles = “Administrator, PowerUser”)] public class ControlPanelController : Controller { public ActionResult SetTime() { } [Authorize(Roles = “Administrator”)] public ActionResult ShutDown()

Read More »

The Art of Business Intelligence

“If you know the enemy and know yourself, you need not fear the result of a hundred battles. If you know yourself but not the enemy, for every victory gained you will also suffer a defeat. If you know neither the enemy nor yourself, you will succumb in every battle.” ― Sun Tzu, The Art of War OK, so maybe getting a grip on your

Read More »

How Cognos 10 tasks are performed in Cognos Analytics

This blog post covers some common tasks in Cognos 10 and details how they can be performed in Cognos Analytics. Access content Cognos 10 – The Public Folders tab provides access to shared content. The My Folders tab provides access to personal content. Cognos Analytics – The Team content button on the left-hand menu provides access to shared content. The My Content button provides access

Read More »

Comparing SQL Server Tables – Columns & DataTypes

Recently I was working on a project that had many different input tables that needed to be filtered into one. I’ve worked on similar projects before and it’s usually not too bad to compare a few tables. But this time, with so many different tables, using my normal approach would have been too time-consuming. I created a more effective method for comparing a large number

Read More »

IBM Cognos Analytics – the Inside Scoop on the R5 Release!

After attending the World of Watson in Las Vegas at the end of October, here are a few of the highlights that can be anticipated in the IBM Cognos Analytics R5 release at the beginning of December. As you may or may not know, the upgrade from IBM Cognos BI to Cognos Analytics will be fairly simple.  Framework manager packages and data source connections will

Read More »

Anatomy of a Metric: KPI Assessment for Analysis Application Design & Data Modeling

When designing quality analytics applications that meet the expectations and requirements of various business users, being specific can mean the difference between collaborative success and argumentative failure. Rising to meet the challenge of satisfying these varied roles can be daunting. Executives, Managers, Business Analysts, Application Designers, Data Modelers and Developers may all be involved. While each of these roles has a different perspective regarding the

Read More »

ASP.NET MVC 5 Custom Role Providers for Windows Authentication

With ASP.net MVC, restricting access to actions has never been easier. The AuthorizeAttribute allows you to easily restrict access to controllers or actions based on a user’s role. See the example below. 1 2 3 4 5 6 7 8 9 10 11 12 [Authorize(Roles = “Administrator, PowerUser”)] public class ControlPanelController : Controller { public ActionResult SetTime() { } [Authorize(Roles = “Administrator”)] public ActionResult ShutDown()

Read More »

The Art of Business Intelligence

“If you know the enemy and know yourself, you need not fear the result of a hundred battles. If you know yourself but not the enemy, for every victory gained you will also suffer a defeat. If you know neither the enemy nor yourself, you will succumb in every battle.” ― Sun Tzu, The Art of War OK, so maybe getting a grip on your

Read More »

How Cognos 10 tasks are performed in Cognos Analytics

This blog post covers some common tasks in Cognos 10 and details how they can be performed in Cognos Analytics. Access content Cognos 10 – The Public Folders tab provides access to shared content. The My Folders tab provides access to personal content. Cognos Analytics – The Team content button on the left-hand menu provides access to shared content. The My Content button provides access

Read More »

Comparing SQL Server Tables – Columns & DataTypes

Recently I was working on a project that had many different input tables that needed to be filtered into one. I’ve worked on similar projects before and it’s usually not too bad to compare a few tables. But this time, with so many different tables, using my normal approach would have been too time-consuming. I created a more effective method for comparing a large number

Read More »

IBM Cognos Analytics – the Inside Scoop on the R5 Release!

After attending the World of Watson in Las Vegas at the end of October, here are a few of the highlights that can be anticipated in the IBM Cognos Analytics R5 release at the beginning of December. As you may or may not know, the upgrade from IBM Cognos BI to Cognos Analytics will be fairly simple.  Framework manager packages and data source connections will

Read More »