BLOG

On this blog, John Daniel Associates, Inc., writes about business intelligence solutions and technologies. Not sure where to start? Take a look at our guide to business analytics for beginners!

Getting to Know You – Raw Data Exploration in QlikView

Bryan Scheck Business Analytics Specialist, Project Management, Reporting  John Daniel Associates, Inc. Bryan’s Profile   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

Read More »

Simple SQL Server Version Control

Ben Daland Business Analytics Specialist John Daniel Associates, Inc. Ben’s Profile 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

Read More »

Budget for the Back to School Season with Qlik Sense

Susie Bann Business Analytics Specialist John Daniel Associates, Inc. Susie’s Profile 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.

Read More »

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

Bryan Scheck Business Analytics Specialist, Project Management, Reporting  John Daniel Associates, Inc. Bryan’s Profile 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

Read More »

ASP.NET MVC 5 Custom Role Providers for Windows Authentication

Ben Daland Business Analytics Specialist John Daniel Associates, Inc. Ben’s Profile 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 {

Read More »

Using Qlik End-User Audit Log Files to Increase Application Efficiency

Mark Viecelli Business Analytics Specialist John Daniel Associates, Inc. Mark’s Profile The Qlik End-User Audit Log Files contain a wealth of information such as applications accessed by users, selections made, objects used, bookmarks applied, timestamps for all user actions, and much more. The most difficult part of using these logs is making sense of all that information. Most people think of Qlik log files as

Read More »

Getting to Know You – Raw Data Exploration in QlikView

Bryan Scheck Business Analytics Specialist, Project Management, Reporting  John Daniel Associates, Inc. Bryan’s Profile   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

Read More »

Simple SQL Server Version Control

Ben Daland Business Analytics Specialist John Daniel Associates, Inc. Ben’s Profile 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

Read More »

Budget for the Back to School Season with Qlik Sense

Susie Bann Business Analytics Specialist John Daniel Associates, Inc. Susie’s Profile 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.

Read More »

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

Bryan Scheck Business Analytics Specialist, Project Management, Reporting  John Daniel Associates, Inc. Bryan’s Profile 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

Read More »

ASP.NET MVC 5 Custom Role Providers for Windows Authentication

Ben Daland Business Analytics Specialist John Daniel Associates, Inc. Ben’s Profile 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 {

Read More »

Using Qlik End-User Audit Log Files to Increase Application Efficiency

Mark Viecelli Business Analytics Specialist John Daniel Associates, Inc. Mark’s Profile The Qlik End-User Audit Log Files contain a wealth of information such as applications accessed by users, selections made, objects used, bookmarks applied, timestamps for all user actions, and much more. The most difficult part of using these logs is making sense of all that information. Most people think of Qlik log files as

Read More »