April, 2012 | Data & Analytics
Data & Analytics Blog

Archive for April, 2012

Dummy Coding with IBM SPSS

Dummy Coding with IBM SPSS To understand what is meant by dummy coding, you need to understand 2 forms of data: Qualitative or Quantitative? “Qualitative data describes items in terms of some quality or categorization while Quantitative data are described in terms of quantity (and in which a range of numerical values are used without […]

Read more

Iterative BI – What’s the Difference?

Recently I was in a conversation where a PM declared “Agile’s just waterfall really fast – we can do that no problem!”  Uh oh. Like (most) everything, delivery methodologies are subject to fashion and trend, and Agile/Scrum/Kanban and the like are en vouge.  Collective, I’ll refer to these highly cyclic methodologies as “iterative” or (little […]

Read more

Cognos TM1 Attributes -What are They and What Can They Do for Me?

To define an element’s type (numeric, consolidation or string), elements can have attributes defined and assigned to them. What is an attribute you ask? Well, if elements identify data in your cube, then you can think of the element attributes as describing the elements themselves, it’s that simple. For example, let’s say that some of […]

Read more

Chi-Squared Challenging using SPSS

  Chi-Squared Challenging using SPSS A Chi-Square Challenge (or Test) procedure organizes your data pond variables into groups and computes a chi-square statistic. Here is the specific definition: “The chi-square (chi, the Greek letter pronounced “kye”) statistic is a statistical technique used to determine if a “distribution of observed frequencies” differs from the “theoretical expected […]

Read more

BI Maturity – Now What?

I spend a lot of time working with BI teams assessing how they’re doing and what they should do next.  We often use a BI maturity model as a framework for these assessments.  They’re great accelerators and help the teams to understand where they fall between “getting started” and “guru”, but they’re not great (by […]

Read more

IBM SPSS Split File

You can use the IBM SPSS Split File feature to split your data pond into separate groups for further analysis –based on the values of one or more grouping variables. If you select multiple grouping variables, cases are grouped by each variable within categories of the preceding variable on the Groups Based On list. For […]

Read more

Simple Inferential Statistics

 Simple Inferential Statistics “Inferential statistics” is a term used to describe the use of information regarding a sample of subjects to make: (1) Assumptions about the population at large and/or (2) Predictions about what might happen in the future   What’s your Batting Average? You can calculate the mean (or average) batting average of a […]

Read more

BI Tools – Scheduling and System Automation

Way back at my first full time job, maintaining the system automation program was one of my primary duties.  It was written in C, could launch one thing at a time, and documented dependencies in a cryptic text format.  And I loved it because the alternates were way worse. Fast forward to today where system […]

Read more

BI Tools – Continuous Integration

Automate everything!  The mantra of the real developer – I’d rather spend 2 hours automating a task than 30 minutes of repetitive typing!  Continuous integration finally legitimizes that innate desire to automate during the development process. Continuous Integration (CI) tools automate the application build process and automated tests on a regular interval (or on demand […]

Read more

Little Data

Here at the Gartner BI Conference in Los Angeles this week, and everywhere else that  I turn for that matter, all I hear about is Big Data this and Big Data that.  Even at breakfast this morning, those now all too familiar two words kept popping up in conversations all around me until I thought […]

Read more

Perficient Data & Analytics

Trends, best practices, and technical perspectives from data and analytics experts. Readers will gain valuable insights and strategies in harnessing the power of data to drive actionable intelligence for a digital transformation journey.