Church Dashboard Measures More Than Attendance

No matter what business niche we measure with our information dashboards, the success of our effort depends on selecting the right metrics and indicators. When attempting to truly understand the health of our business, we are challenged to look beyond the usual and obvious KPIs and incorporate the “you’re right, we have to take that into account” measurements that add up to a fuller comprehension of our progress against goals. The selection of metrics can have subtleties that surface only after several iterations of dashboard design.

Today we look at this topic by examining a case study involving a pastor who tracks his church-related metrics through a dashboard. Dave Ferguson explained his choice of metrics in a Christian Standard post entitled Golf Scores and Dashboards: Keeping Track of How the Church is Doing.

He explains how golf is about keeping score and how the church needs to do the same. I’ve clipped some of his great commentary:

What’s the score at your church?

So, how does your church keep score? Usually churches keep score by counting the attendance and offering, which typically are published in the program or on the Web site. Attendance and offering are often the key indicators discussed at staff meetings.

Occasionally, churches also keep score by tracking how much is given during capital stewardship or faith-promise campaigns. A few churches even keep score of how many Timothys or missionaries they send into ministry.

So, how does your church keep score?

The Bible and Numbers

And don’t try to tell me we shouldn’t keep score. Bible writers obviously didn’t shy away from counting. For example:

6—the number of days it took for creation.

40—the number of days and nights it rained during the flood.

500—the number of years Noah lived before he became the father of Shem, Ham, and Japheth.

3,000—the number who accepted the message and were baptized on the Day of Pentecost.

There are all kinds of statistics in the Bible. There is even a whole book called Numbers. Since the Bible doesn’t shy away from statistics, counting, or numbers, neither should we. But that still leaves us with these questions: What should we count? How should a church keep score?

When it comes to a church dashboard, the “obvious” attendance metrics are, of course, attendance and collection. Pastor Dave explains his thinking behind going beyond these numbers.

Beyond Attendance and Offering

I was preparing an update to present at Leadership Community, our monthly gathering of leaders from all our campuses, and the stats were looking pretty good. That month we had set a new record attendance with an increase of more than 1,000 people over the previous year and we also had set a record for giving. I was feeling pretty good about the score.

But, as I thought about it, I wondered, Is that really a good score? Is increasing the number of butts in the seats and increasing the amount of money in the plate the best way for a church to keep score? What about the spiritual formation of the people at my church? They may be showing up for more church services, but is that really all I want to measure? What about growing their influence and using their giftedness for making a difference? What about starting new church sites and churches to reach a lost world?

The more I thought about it, the more I realized we could do better.

Watching the Guage on the Dashboard

What if, instead of just keeping score, we developed a dashboard that could display several key indicators and measurements?

We can all relate to a dashboard. As I’m driving around town I keep an eye on my odometer because it tells me how many miles I can drive after the yellow fuel light comes on. I lean forward to get a look at the speedometer to make sure I’m not going too fast. Since I drive a 1994 Toyota Paseo, I watch the temperature gauge in the summer to make sure my little car isn’t overheating. I am familiar with the dashboard in my car.

What would the dashboard at a church look like? What would it measure?

Over the last several years at Community and through our NewThing Network, we have developed our own dashboard. This report can be printed on one page and helps me understand—at a glance—how the church is running without needing to dig into every detail.

A dashboard that measures only attendance and offering does not match our vision at Community. Our vision is not to warehouse a large number of Christians at multiple sites till Jesus comes back. Our vision is to mobilize 3C Christ followers who are ready to go out and accomplish the mission of Jesus.

So, in addition to attendance and offering, our dashboard includes the following measurements:

3C Christ followers—We want to know what percentage of people are growing in the spiritual experiences of celebrating (weekly, as part of our celebration service), connecting (doing life together in a small group), and contributing (giving of their giftedness in service and of their finances). If I could have only one indicator on our dashboard, this would be the one! This gauge tells me more about the spiritual health of a person than any other indicator.

Baptisms—We also want to know how many people are making commitments to become Christ followers. This was something that was counted in the book of Acts and it counts today, so we track it. This is the best indicator of a church’s evangelistic temperature.

Leaders—We also want to know how many people are apprentice leaders, leaders, and coaches. This may be unique to the culture of Community, but I think it is absolutely critical. This tells the number of small groups and teams (leaders); the number of potential small groups and teams (apprentice leaders), and what the leadership development pipeline looks like.

The strength and depth of a church’s leadership tells how soon the church can reproduce a new site or church. Why? Because the leaders facilitate all the small groups and teams for kids, students, and adults.

Artists—We want to know how many artists we have at Community. When we use the term artist, we are using it in a very broad sense to include worship leaders, vocalists, musicians, actors, dancers, painters, videographers, sound and light technicians, etc. As with leaders, the strength and depth of the artists tells us how soon we can reproduce a new site or church. Why? Because the artists create and lead all large group worship and celebration events.

Services and sites—I want to know we are reproducing at all levels. I want to know how many services we do on a weekly basis. When we started Community, we had only one service at one site. Today we have more than 25 services at nine sites. I want to watch that gauge, too.

So, what’s your score? Hoping to do better on the second hole? Me, too. Whether it is score-keeping or gauge-watching, decide what you need to measure to best accomplish the Jesus mission and count it!

Here’s a peek at some dashboard metrics:

church dashboard

The image above shows the percentage of people that are connecting at each of our nine campuses and as a church overall. We have set an expectation that we want 75% of our people connected in small groups. As you can see in the diagram five of Community’s campuses are beyond the 75% mark. These are the campuses in green and they have between 84% and 120% of people connected. The three in yellow have between 60% and 68% of the people connected in small groups. And the one campus is currently in red is slightly below 60%. We have several pages like this one that are updated on a weekly basis that show how many people are celebrating, connecting, contributing, giving, baptisms and more. It is a terrific tool that helps you really understand numerically how you are doing as a church.

Present Year and Present Month Statistics

Church statistics dashboard

Pastor Dave blogs about his church dashboard metrics at his blog.

Tags: Church dashboard, church attendance metrics, church managment, church dashboards

NCAA Tournament Dashboard

So how is March Madness going for you Dashboard Spies? Did you predict the Sweet 16 successfully? What? Don’t tell me you didn’t apply all that analytical skill and business intelligence savvy you have to your pool picks? You can model sales forecasts in the face of the worst economy since the Great Depression, but you can’t forecast a college basketball tournament? What are you going to do when sports betting comes to Atlantic City? Well, don’t worry, at the end of this post you’ll find a quick Sweet 16 rundown courtesy of the Orlando Sentinel newspaper.

Have you seen this 2009 College Basketball Bracket Dashboard from iDashboards?

It’s an interactive dashboard that you’ll want to check out, but here’s a screenshot as a preview. Click on it to enlarge it so that you can read it more easily.

2009 NCAA Dashboard

If you drill down into the Midwest region, you’ll see some graphs and gauges:

march madness dashboard

Be sure to visit the iDashboards March Madness Dashboard.

And here is the Sweet 16 rundown I promised from the Orlando Sentinel newspaper:

NCAA tournament: 16 things to know about the Sweet 16

Many vaunted programs still alive

By Iliana Limon

Orlando Sentinel

March 26, 2009

Midwest

No. 1 Louisville (30-5)

Cardinals coach Rick Pitino has a 37-12 record in the NCAA tournament, giving him the third-highest winning percentage among active coaches behind Duke’s Mike Krzyzewski and Florida’s Billy Donovan.

No. 12 Arizona (21-13)

The Wildcats won the 1997 title by beating Pitino’s Kentucky team in Indianapolis, where they will face Pitino’s Louisville team.

No. 3 Kansas (27-7)

The defending national champions have been a two-man show this postseason. Cole Aldrich and Sherron Collins have scored 93 of the Jayhawks’ 144 points in the first two rounds.

No. 2 Michigan State (28-6)

During the last 12 years, every Spartan who has stayed in school for four seasons has appeared in the Final Four.

West

No. 1 Connecticut (29-4)

UConn is 38-12 in Sweet 16 appearances under coach Jim Calhoun but went 4-14 in 13 NCAA tournaments before Calhoun took over.

No. 5 Purdue (27-9)

In the Boilermakers’ last 10 tournament appearances, they have reached the Elite Eight twice.

No. 3 Missouri (30-6)

Tigers coach Mike Anderson was at UAB three years ago and handed Memphis its last loss in Conference USA, in which Memphis is now riding a 61-game winning streak.

No. 2 Memphis (33-3)

Seniors Antonio Anderson, Robert Dozier and Chance McGrady set an NCAA record for most career wins with 137.

East

No. 1 Pittsburgh (30-4)

The Panthers advanced to the Sweet 16 for the fifth time in the last eight seasons, but they are 20-21 all time in 21 NCAA tournament appearances.

No. 4 Xavier (27-7)

The Musketeers are one of nine teams with multiple Elite Eight appearances in the last five years (2004 and ’08), joining North Carolina, UCLA, Kansas, Memphis, Louisville, Texas, Florida and Connecticut.

No. 3 Villanova (28-7)

Seniors Dwayne Anderson, Shane Clark, Dante Cunningham and Frank Tchuisi have recorded 100 career wins, the most by any class in the program’s 89-year history.

No. 2 Duke (30-6)

Krzyzewski became the winningest coach in NCAA tournament history last week with 71 wins, passing Dean Smith’s 69.

South

No. 1 North Carolina (30-4)

The Tar Heels are tied with Kentucky for most NCAA tournament wins with 98 and have won at least 30 games for the third straight season—the first time that’s happened in school history.

No. 4 Gonzaga (28-5)

The Bulldogs appeared in their 12th consecutive West Coast Conference tournament championship this year, the second-longest streak of reaching a conference tournament final to Kentucky’s 14 in the Southeastern Conference.

No. 3 Syracuse (28-9)

The Orange has reached the Sweet 16 for the 14th time in 26 trips to the NCAA tournament under coach Jim Boeheim.

No. 2 Oklahoma (29-5)

This marks Oklahoma’s 27th postseason appearance—22 NCAAs, five NITs—in the last 28 seasons, tied for the most in the nation over that span.

Network Operation Center Nimsoft Dashboards

Service Level Management (SLM) is the process of ensuring that IT services are linked to business processes and providing detailed visibility of service. By monitoring SLAs (service level agreements) and operating level agreements (OLAs), business and technology units can talk in terms that represent a common denominator in departments that used to be world’s apart. SLA dashboards can not only help visualize the data, but bring the management issues out in the open where they belong.

Thanks to long time Dashboard Spy reader and availability dashboard enthusiast Ken Vanderweel of Nimsoft Inc, we have the opportunity to study an extensive series of performance dashboards that monitor the availabilty of services for Amway Online. Powered by Nimsoft and used by Amway’s Germany-based IT organization to monitor a host of service statistics, the Network Operation Center dashboard has been instrumental in improving the organization’s quality of service.

Let’s take a look at a couple of photos of the dashboards in action and then we’ll zoom in on the performance dashboards themselves.

Here’s a peek at the ticker showing the bottom line, an “all clear” signal. I didn’t know what the numbers meant on the top ticker and Ken informed me that it was simply the local time in different European cities.

noc critical alarm ticker

Here are the happy dashboard users:

nimsoft dashboards

Here is the closeup of the dashboard monitors.

noc dashboards

I’ll let Ken explain the series of screenshots he sent me. Please note that because of the number of dashboard screens, I’ve place thumbnails in this post. You can click on each one to enlarge the screenshots. You’ll want to read the various annotations as they are very informative.

Amway’s Germany-based IT organization successfully achieved their goal of “IT to Business alignment” through the implementation of service level dashboards powered by Nimsoft. With these dashboards Amway’s IT organization is able to demonstrate to their business counterparts the services and service quality being provided. Dashboards made it possible for Amway’s IT organization to communicate in a language the business understands; not technology-centric but services-centric via business-centric dashboards that include quality of service statistics for Amway Online customers.

The dashboard sequence that follows gave Amway the increased visibility they needed to lift quality of service for business customers interfacing with their online web services from 96.5% to 99.5% in less than one month. Dashboards provided heightened ‘business visibility’ to improve end-user quality of service and overall business performance. Heightened visibility was accomplished through a combination of Nimsoft end-user and end-to-end IT infrastructure monitoring software plus Amway’s creative use of the Nimsoft service level dashboards and dashboard design toolkit.

At the front of the dashboard sequence is a clear view of Amway’s Eastern European business region and the quality of service their customers are experiencing as they interface with Amway Online services. Amway’s IT organization can click to drill down to underlying dashboards that reveal more granular health status perspectives which accelerate problem isolation and resolution.

At the back of the stack of dashboards is an interesting business metrics dashboard that shows the health status of all sales orders channels. This particular dashboard was made possible through integration into Amway’s business process integration software. The dashboards display the number of online sales orders; dashboard alarms would indicate breaks/bottlenecks in the sales order/fulfillment process, for example, a failure in the backend processing such as a lost connection to the credit card bank.

Click to enlarge these dashboard screenshots:

Amway NOC Dashboard

Nimsoft NOC Availability Dashboard

Nimsoft Dashboard

SLA Dashboard

SLM Dashboard

Server Availability Dashboard

Network Monitoring Dashboard

Order Status Dashboard

ebusiness Dashboard

These last 2 SLA dashboards are my favorite, so be sure to check them out!

Thank you very much Ken of Nimsoft.com for sharing these dashboards with us!

PS. Help Desk and Service Desk Dashboards can come in many forms. Check out the range of approaches – from mobile dashboards to desktop dashboards.

Reputation Management Dashboard Built with iGoogle

Dashboard Spy readers from the marketing side of the house will find fascinating the post by Marty Weintraub titled “How to Build a Reputation Management Dashboard“. Marty offers comprehensive, step-by-step instructions in his post on assembling a robust dashboard that allows a company to track your business keywords such as brand, products, company executives intent phrases and competitors. Oh, and, here’s the kicker that will excite all dashboarders whether or not they’re interested in marketing or reputation management – the dashboard is free and built with iGoogle, Google Alerts, and the Google search engine.

Here’s a screenshot of part of Marty’s reputation management dashboard:

igoogle dashboard for reputation management

The key to this dashboard lies in the fact that Google’s SERPs (search engine results pages) are now available via RSS notification. In other words, your feed readers can now monitor Google key words. Is the light bulb going on over your head yet?

As Marty explains in his well-illustrated post, the steps to building out the free reputation management dashboard are:

  • Create a Google Account
  • Setup an Excel spreadsheet with the following tabs: Brand, Product, Personnel, Competition, Industry Phrases and Intent Words.
  • Populate Excel with keywords and variants. Definitely see his post for his tips in this step.
  • Create iGoogle dashboard.
  • Go to Google Alerts and create new alerts for each keyword (yes, manually for each keyword in your Excel file!).
  • Create Google Gadgets (portlets) for your iGoogle dashboard. Copy RSS feeds for the alerts to your iGoogle page.

Visit the post to see the screenshots for each step. All will become clear. Also, Marty shows you how to use Twitter and other sources to create additional reputation monitoring channels.

Be sure to send in screenshots of your iGoogle dashboards!

Regards The Dashboard Spy

Simple Grey Metrics Dashboard HTML Template

Dashboard Spy readers: Here’s another HTML dashboard template for your mockup and project implementation purposes. It was created in response to some feedback from the previous Dashboard Spy HTML Dashboard template. For those readers catching up, I recently sent an HTML dashboard template out to people signing up for the Dashboard Spy email list. It was a 4 column layout with portlets of varying size. Some portlets have graphics while others had data tables with scroll bars and alternating colors. Here’s a thumbnail screenshot of the dashboard I called “4 Columns of Joy”.

4 columns of joy dashboard template

Dashboard Spy email list members wrote me asking if I could provide a simpler HTML dashboard template. These dashboarders didn’t have the need for all those portlets.

In response, I created the following dashboard template. I call this one “Simple Grey Metrics Dashboard”. Again, take a look at this dashboard screenshot, and if you would like the html for it, please fill out the form below to join the Dashboard Spy email list and we’ll make sure you get the template.

If you’ve signed up for the mailing list already, you’ll automatically get this new dashboard template.

simple metrics dashboard html template









Name:
Email:

After submitting the contact information above and confirming the signup by checking your email, you’ll get the link to the zip file containing this dashboard html template.

Be sure to let me know what you think!

Regards The Dashboard Spy

Dashboard HTML Template

Announcing a New Dashboard Template from The Dashboard Spy!

HTML coding for digital dashboard projects is not rocket science but does require an incredible attention to detail. When you are dealing with a complicated layout with multiple portlets and nested scroll bars, the HTML details can be tricky to say the least.

The latest Dashboard Template from The Dashboard Spy offers a real jumpstart to your dashboarding project because it’s offered in an HTML verison. Having the HTML, red/green/yellow icons, and associated CSS will save your programming team days if not weeks of effort.

You can get it this HTML dashboard template at no cost by subscribing to the Dashboard Spy email list. In addition to this html dashboard template, you’ll receive occasional issues of the Dashboard Spy newsletter with links to additional dashboard templates, business intelligence resources and, of course, lots of dashboard examples.

Take a look at the screenshot of the HTML Dashboard Template and provide your contact details in the form below to download the dashboard.

dashboard html template

Name:
Email:
Fill out the name and email boxes above and click the submit button. Then watch for a confirmation message in your email box.

Happy dashboarding!

Regards The Dashboard Spy

Mobile Dashboard

As you browse the archive of dashboard screenshots on the Dashboards by Example blog, you’ll find information dashboard projects spanning an incredibly diverse range of needs and interests. Dashboards fit the business intelligence presentation needs of every industry I can think of and we’ve seen examples from bottle filling lines to the situation awareness dashboard from the U.S. Defense Intelligence Agency. Regardless of the business sector or niche, the one thing you can count on is the unique ingenuity of the dashboard designer.

In the course of interacting with Dashboard Spy readers who submit their dashboard examples for discussion on the blog, I’ve come to realize that there is an amazing amount of skill and versatility among business intelligence dashboarders. The design solutions that arise can be surprisingly clever.

And every once in a while you stumble across a dashboarding project that has that extra spark of passion that comes from real personal interest and involvement. Today’s dashboard example is a combination of passion and cleverness that resulted in a very cool mobile dashboarding environment.

The phrase “Mobile Dashboard” probably makes you think of cell phones or PDAs, but no, the mobile dashboard device we’ll look at today is a couple of thousand pounds heavier than your iPhone.

So what weighs 5,000 lbs, cost $30,000, produces 300 or so horsepower and can display the KPIs and metrics of your business in a dashboard display?

The answer is Ed Pardo’s Nissan Titan pickup truck. I kid you not! Ed Pardo of Buffalo, NY is a Dashboard Spy reader and talented I.T. pro who has literally taken the idea of mobile dashboards to the streets.

When Ed told me his dashboarding philosophy and showed me a couple of pictures of his mobile dashboard project, I knew I was in for a treat. Here is Ed on what business dashboarding should be:

Dashboarding is nothing more than getting the right information to the right viewers in the shortest time with minimal interaction. The best way to do this is by leveraging technology to provide the presentation. If you can “think outside the box” and don’t let the vendors dictate what is possible, you can benefit from technology in ways not imagined.

Let’s take a look inside Ed’s Nissan Titan:

titan mobile dashboard

“Looks just like a normal car” you might be saying. Well, take a closer look at the bottom of the picture and you’ll see a shiny red mouse. Ed is an exceedingly neat as well as clever hacker and it’s to his testament that things look so normal in this picture. I suggested to him that he should be featured in the pages of Make Magazinefor his attention to detail!

So how this this unique mobile dashboard platform come about and what can it do? Let’s hear it straight from Ed:

Hubert,

I started this about six years ago while I was in the middle of working on a security management platform at work. I was interested in creating a virtual Secure Operations Center (SOC) and was attempting to use a laptop. I had heard about some guys that had built custom computers to put in their cars as media servers. Just think, the worlds largest iPod!

I got into this to see what the engine control system (OBD II) was doing in my vehicle, just curious I guess. I have since saved family and friends hundreds of dollars by reseting the check engine light!

The setup is basically an XP Pro computer except for some custom pc parts to make it work in a 12V environment. Add in some specialized software and you now can have a information dashboard in your vehicle.

The biggest challenge was how convert the voltage to work with a device that was used to a steady 120V. In a car, the voltage fluctuates depending on the speed of the motor or what else is drawing from the battery. There are now many sites that offer parts or even ready to run computers for your vehicle.

After I have figured out all the logistics and wiring, then the fun started. The software interface(s) (Centrafuse or StreetDeck are two) have evolved to be very user friendly while driving; large buttons, automated application switching, etc.

As a proof of concept, I connected to the internet (not while driving!), accessed the corporate network via remote access and launched my enterprise dashboard. I then sent a picture to the vendor to show how I was using their software in a way they had never imagined. I then created a slide deck titled “The worlds first mobile SOC in a Nissan Titan pickup”!

I have the following functionality enabled in my vehicle:

  • In-dash 7″ VGA touchscreen
  • GPS mapping
  • Infrared backup camera
  • Bluetooth phone integration
  • OBD II connection to monitor engine stats (created custom screen using PalmerPerformance DashCommand)
  • 10k song shuffle

Additional Functionality NOT used

  • XM Radio
  • DVD player
  • Voice Command
  • WiFi Internet (can be used for real time traffic alerts or Google Earth maps)

I have made the computer portable so that I can use it in my house or on my boat if I want!

I put in extra effort to make this as invisible as possible. The stock truck didn’t come with Navigation so I purchased the dash hood from the factory system so it would look unmodified. I then used a Xenarc 7″ VGA touchscreen monitor with dual inputs; one for the pc and one for the backup camera.

The CPU lives under the driver seat (this is my second case) and all the wiring has been hidden. This case is actually a desktop case that I modified the power supply to work in both environments. I replaced the mouse with a Touchpad and use a mini USB keyboard.

Here are the day and night dashboards that I run in my Nissan Titan to show what’s going on. Throttle, Timing, Intake, MAF, MAP, Short, Long, and Engine readings are shown.

Nissan Titan Computer Statistics

Nissan Titan OBD Dashboard

What’s Ed up to next?

After finishing my truck, I have turned my attention to my home wood shop (WoodFORGE) but don’t have a website yet. I may move the computer in there as I am already working on a dashboard for the shop (motor temp, room humidity, air filter pressure, etc.).

We can’t wait Ed! Thanks for letting us have a glimpse into this great dashboarding project!

If any fellow Dashboard Spy readers want to contact Ed Pardo, please send him an email at woodforge at roadrunner dot com.

Hubert Lee, The Dashboard Spy