Getting to Know You – Raw Data Exploration in QlikView

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 Me

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