Simple SQL Server Version Control

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 Me

Budget for the Back to School Season with Qlik Sense

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 Me

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

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 Me

ASP.NET MVC 5 Custom Role Providers for Windows Authentication

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 Me

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

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 Me