Bandy Works Blogs

Manager with overloaded intelligence based on manual system Is it time to replace your spreadsheet for a database

Six Signs That You Have Confused Your Spreadsheets With a Database

Green industry executives know full well that using the right tool the right job is key to a successful job. It would be pretty hard to cut most yards if you only had a string trimmer. Every company needs technology to maintain their information and work flow. Most small companies create spreadsheets as a flexible […] more...

By  on April 28, 2015
15291873_s 7 Success Factors Retail

7 Success Factors for Retail Analytics

BandyWorks work with dozens of retail chains and growing businesses. We have found the following 7 critical success factors for driving continuous improvement through retail analytics. 1. Key Performance Indicators – executives and managers should focus intently on their very most important performance metrics. For example, an Executive Dashboard should provide a quick view of […] more...

By  on October 13, 2014
Image of mouse-over on a dashboard to see the convenience store breakfast sales and gallons sold for the week. Mouse is hovering over details for breakfast sales

Dashboards – Mouse-over summary with drill-down different insightful piecharts and data exports

Speed to Insight A good dashboard will quickly present results that matter to your success. A great dashboard will then allow a simple mouse-over and drill-down to provide insights or the data you need to do additional analytics to get to the reasons for the results. The best of both worlds Drill-downs are intended to […] more...

By  on August 11, 2014
Image of Convenience Store Performance Dashboards with Big Data Analytics Filters - Filters have English statements that are easy to understand to collect just the data for which analysis is desired

Convenience Store Performance Dashboards – Data Analytics Using Filters

One of the ironies of Big Data is that insights often look like just a few points of data. The ability to extract the right data from large quantities of data is one way to move toward the insights. Filtering data into groups is a technique that allows related information to highlight a big trend […] more...

By  on June 12, 2014
Accountability Data – Automated Complete Simple

Accountability Data – Balancing – Simple, Complete and Automated

Accountability works well when Key Performance Indicators (KPI’s) used are simple, automated and complete. Good results happen when two of the three are in place and used consistently. Great results happen when all three occur. Some argue that it is impossible to accomplish all three in a large organization as it is not simple to […] more...

By  on June 1, 2014
Image of Convenience Store Performance Dashboard with drilldown on sales categories show specific food sales by date range for region, district or store

Convenience Store Performance Dashboards – KPI’s with Drilldowns

A good graph is worth hours of analysis and a focused drill-down saves hours more. Graphs and drilldowns are favorite tools of analysts. Quickly assessing key performance trends and then being able to see the data that makes the trend is a great tool for maintaining accountability towards a goal. The ability to see a […] more...

By  on May 18, 2014
Sources include terror - monsters and Yoda from Star Wars

How Big is Big in Big Data?

As Big Data becomes more popular, the question often asked is ‘What is Big Data?’ While there are lots of ways to answer, one part of the answer inevitably includes quantity. While there is no precise definition of how much is necessary to be considered Big, most accept that amount of data keeps getting bigger. […] more...

By  on May 4, 2014
image of 27% publish KPI's company-wide, 25% publish only to management, 29% do not publish, 19% do not have KPI's in place - Tracking and accountability KPI publishing poll results - BandyWorks Accountability research May, 2014

KPI Sharing- How does your company compare?

As part of our tracking and accountability work, we study best practices. We want to see how companies are using KPI’s in their drive for higher sales and better operational results. The May Poll is complete and the results are in.  Please check our Survey page for a more detailed survey regarding how companies are publishing […] more...

By  on May 2, 2014
Start small with Big Data and focus on actionable insights that drive results

7 Tips for Big Data Success

Experienced Big Data users understand the paradox – Big data starts small. Rather than rush to implement new techniques and technology a small win can help to drive big results. Patience is often hard when there are big problems to solve, but creating a solid foundation for success can make things go faster when you […] more...

By  on April 25, 2014
Healthcare Big Data

Healthcare Big Data Trends

Examining our health system to see how Big Data can improve results What a great summary of how Big Data analytics, ETL and Dashboards can improve outcomes: Active decision making, statistical support for treatments, performance accountability, collaboration, regulatory compliance, remote service, planning, logistical support of operations. Read more on this article with our friends at […] more...

By  on April 10, 2014
Data migration Jump on in

Data Migration – Plan the Plan

Implementing new systems with old data – basic elements to include in your data migration plan Implementing new systems is part of any IT life cycle. Business must continue to increase productivity and IT systems are a key part of many improvement efforts. It is typical that the new system must accommodate the old data […] more...

By  on March 28, 2014
Big Data project management

Agile Dashboards with Pentaho CTools

Dashboards are very powerful tools to implement tracking and accountability. They provide a quick and simple means to share data to assess performance objectively – identify strengths and weaknesses one of the key data points to help with accountability. Their use is easily justified in large organizations with important goals and often warrants extensive investments […] more...

By  on March 14, 2014
Technology Concept with data grid Fast ETL

ETL Performance troubleshooting with Pentaho Data interchange

System monitoring, memory, partitioning, CPU balancing and disk arrays are all part of making the ETL performance of your Pentaho Data Interchange fast and efficient. System monitoring is a critical first step and catch all for performance issues. As the amount of your data grows, processing the data becomes more of a challenge and can […] more...

By  on February 17, 2014
Business Intelligence

Three reasons measuring improves our results

Three reasons measuring improves results      1. Clarify what is important      2. Understand how we compare      3. Justify financial rewards     So you want to know how you measure up. The old saying that you don’t know where you are going until you understand where you have been is a reality when […] more...

By  on February 15, 2014
Big image

Defining the ‘Big’ in Big Data

Redefining ‘Big’ in Big Data – Action, Ideas and Results. Matthew Shoup of LinkedIn provides a wonderful set of ways to interpret the ‘Big’ in Big Data. It is not so much the quantity of data that is important for many companies but rather what is done with it. While having lots of data is […] more...

By  on January 25, 2014
Image of Pentaho Data Integration Process -

Never use SQL again for ETL – Pentaho Data Integration reusable flows instead

Since Pentaho is free and PDI is so easy, our team no longer will use any stand-alone SQL as part of our extract transform and load (ETL) process. Many times we have determined that we only need to extract the data ‘one time’. Inevitably, we need to run it again or something very similar. It […] more...

By  on October 7, 2013
Sheetz Award

Vinodh and Tom receive the Sheetz VIP Vendor 2013

Vinodh and Tom received the Sheetz VIP Vendor 2013 award at the distribution center in Altoona, Pa. Each year the IT team shares their goals for the next year and recognizes vendors who helped them in the current year. Steve Winegardner, Programming Services Manager at Sheetz stated that he appreciated the flexible work and willingness […] more...

By  on August 7, 2013