The Indicee Blog

Tourist in Techie Land: Reporting from Cloudcamp Vancouver

by Geoff Devereux on March 17th, 2010

During introductory remarks for Cloudcamp Vancouver this past Saturday one of the organizers asked the group, ‘how many of you are technical people and how many are “from the business side”?’. The split was about 70/30 for the technical side.  The witty rejoinder to this result was something about why having it on a Saturday is a good idea – ‘only the technical guys would think this is a good way to spend a Saturday’. I saw one guy wearing a shirt that said, “I’d rather be surfing”, but the picture was of an open laptop.  Okay, so I’m joking about that last bit.  But, as a non-techie attending on behalf of Indicee, I was definitely in the minority.  Hence the “tourist” designation.

Here’s my thoughts on the day.

For the uninitiated, Cloudcamps are workshop-based events where the participants decide the curriculum at the beginning of the day.  Then, they spend the rest of the day talking about their main areas of interest with respect to “Cloud Computing“.  This can even include spirited, in fact heated, debate about how one defines Cloud Computing.

For our purposes, we can define Cloud Computing as what Indicee does! We deliver our software online through your browser.  And, our back office exists pretty much entirely on Amazon Web Services (EC2).  The Cloud. As a side note, I was delighted to hear that EC2 generously donates computing time to University of British Columbia (UBC) students to help build for the future.

That said, like a cloud, the definition is definitely nebulous and within the tech community it’s a moving target (to say the least). On Saturday, Dave Nielsen (Clouderati), stated a good working definition, I think.  Cloud is 1) managed, 2) self-serve and 3) on demand.  Dave is one of the founders of Cloudcamp.

Cloud is the essence of Software as a service, and we, Indicee, are the quintessential Saas provider.  We get all of our computing power and data storage metered like you get electricity from your local utility.

Destination Cloudcamp

So far over 15,000 people have participated in Cloudcamps worldwide.  The events are organized as an “unconference” which means, in short, Embrace The Chaos.  The organizers basically provide a blank canvas (within the context of Cloud) and with the help of an impromptu panel some topics are generated to fill up the breakout sessions later in the day.

Everyone involved brought their A-game so we were able to have a lot of fun collaborating on what the day would end up looking like.  The list of “official” organizers is here, but the cool thing about an unconference is that we ALL became organizers.

In the end seven sessions were defined:

- Intro to Cloud Computing
- Cloud Management & Interoperability
- Designing for the Cloud & Best Practices
- Cloud Computing for Large Enterprises
- Security, Privacy, and Trust
- Scaleable Data Management (SQL vs noSQL)
- Enterprise Integration

If I can, I’d just like to pick out one thing from each of the sessions I attended to give you the flavour of the day.  Looking at my word count, I’m already pushing the bounds of net-friendly postings.  For more info, you can check out the Flip Notes from the day here.

Session #1: Cloud Management & Interoperability

Troy Angrignon kept a blistering pace through this lively roundtable in order to get through the points in good time.  The question of Vendor Lock-in was the overriding concern by a wide margin.  IT-guys are uber-paranoid of being held hostage and having their data held hostage.  It makes sense.  Once bitten, twice shy.  IT has a ton of baggage from the last generation of computing.  I don’t have the hubris to say “it’s different this time”, but I would say the issue is less difficult in a Cloud world than it was in the client/server world.  I hadn’t realized how intense these concerns were.  Good to know.

Session #2: Designing for the Cloud & Best Practices

Without being too facetious, my main takeaway is probably that I was in the wrong session.  This one was more of a how-to with respect to understanding the technology layers that make up a Cloud App; when to expect bottlenecks, and what to do about them.  Looking at the Flip Notes I think the Large Enterprises session would have held more value for me.  Know for next time.  Trevor O and Dave did a good job, it just wasn’t my bag.

Session #3: Scaleable Data Management – SQL or noSQL

I was really looking forward to this session because it had the potential to turn into an epic nerdfight.  All it would have taken is the presence of one militant, dogmatic ideologue on either side of the debate.  Unfortunately, our group was exceedingly rational and brought nuanced and balanced views.  My friend and colleague, Ryan Prociuk, really showed his chops on the subject bringing a ton of knowledge and experience to the group.

I won’t burden you with the gory details of this one.  Suffice to say, database are not one size fits all.

For now, just know the complexities of SQL (Structured Query Language) could be compared to writing macros in Excel. Tricky.  Here at Indicee, we prefer to let users ask questions using plain English.  It cuts down on the angst.

The highlight of the session, and indeed the DAY, was clearly Dave’s anecdote about running 50 million users on only 1 Oracle database.  It takes a fair bit of “wizardry” to pull something like that off.

Like the saying goes: “Plan for failure”

Aloha

It was a great day.  To everyone who came out, good on ya.  To everyone I was able to connect with, good times.  And to the sponsors, thanks. Leave a comment!

Meeting of the minds

Great local art in the Venue forey

Enjoy!

  • Share/Bookmark

Changing the B.I. World Whether They Like it or Not!

by Geoff Devereux on March 12th, 2010

For anyone who already knows who Gary Vaynerchuk is, the title of this post will be a not-so-subtle homage to his mission of changing the wine world whether they like it or not.

Here at the office, we’re big fans of his show, Wine Library TV.

Gary’s intro sets the tone from the word go.  He warns Gretzky before the start of Episode #660, “careful, I’m about to get real loud“.  One might respond, no lie, no lie.

Gary’s got a fantastic take on wine tasting.  Whether it’s describing a wine as “fresh catcher’s mitt” or “dark, no moon, in a cave, I’m scared, kinda dark”, his illustrations get the experience of wine across to people in a way that’s easy to understand.  But, not dumbed down.  There’s play in there as well, always good.  He takes the burden off of understanding wine in a more meaningful way.

Here at Indicee, we’re all about increasing understanding so we thought we would have some fun with Gary’s Ratings Spreadsheet.  “Vayniac” Chris Stanisci (SS Chris) created and maintains the spreadsheet that details all of the wine tasted on the show with rating.  (Based on my understanding of the numbers, you’ll generally want something high 80’s or above.)

I uploaded the spreadsheet into Indicee and managed to generate the following reports on a lark.

Then, with the help of Scott Pledger, our new VP of Marketing, we came up with a value calculation.

Gary’s Score / Price = Value Score

And lastly, here’s a report showing the PRICIEST wines that have been on the show.

Gary’s at the big South by Southwest (#SXSW) Conference this weekend in Austin.  We’re sorry to be missing the party down there, but maybe these reports can be our contribution.  I’m sure the information contained could make for a good conversation!

And a big shout out to SS Chris for being the Spreadsheet Jockey on this!  Good on ya!  But, we do gotta talk about Data Quality at some point.  Ping me.  There’s a ton of potential to generate more reports, but we need to clean up the Data.  Don’t make me unleash the DataFlux crew on you.  Maybe we can farm out some of the grunt work for you.

Want to see the Data live? Join our free public group here!

Enjoy!

  • Share/Bookmark

Accounting for I.T. in the Finance Department

by Geoff Devereux on March 10th, 2010

An Interview with Wendy Van Donkelaar; CFO at MAKE Technologies

Last week, we were talking with Cheni Yerushalmi, co-counder of Sunshine Suites, about Measuring What Matters.  I think the main takeaway, from an Indicee point of view, is that the company’s Financial Reports were deemed much less important to the running of the business than were Operational Measures.

Today, we’ll move away from some of the broad philosophical implications of the question, “How do you measure success?” that we tackled with Cheni and move into the practical side of what measurement tools are being employed in mid-sized businesses and what measures are considered important in a conversation with MAKE Technologies CFO, Wendy Van Donkelaar.

MAKE Technologies Inc. is a Vancouver based software solution provider that analyzes and modernizes all three aspects of legacy enterprise applications: business processes, source code and data. MAKE’s modernization platform, TLM, helps their global customer base to reduce the cost & risk required to maintain and modernize their mission critical systems.

Wendy Van Donkelaar is a Financial Executive and Chartered Accountant with over 20 years experience in the technology sector.

I was interested in getting her take on the role of I.T. Systems for keeping tabs on the health of the business through the use of reports and KPIs.  What I found was, 1) she is strapped for time just like every other Finance Manager I’ve met over the past 10 years, and 2) she employs a number of tools to get the answers she needs to effectively manage the company’s finances.

So, here’s the Q & A:

1. How do you analyze operational performance? We use SFA [Salesforce Automation], SA [Simply Accounting] and excel spreadsheets to analyze performance.
2. What are the critical operations KPIs? Net new license and services revenues, Sales Funnel growth, Professional services utilization and G/M [Gross Margin], # of partner deals, # of presales presentations per quarter.
3. Do you analyze results on a project-by-project basis? Yes using an excel spreadsheet we are currently evaluating project management systems.
4. How is the Finance function changing/evolving with the onset of new technologies? The function has changed from one of historic information gathering to one of predictive analysis.
5. How do you view the role of spreadsheets in your line of work? Used for summarizing weekly Dashboard metrics and Board reporting.
6. Has your view of spreadsheets changed over time? How so? In my past, spreadsheets where often used for gathering and collating data so that analysis could then be performed.  It now seems like that step has been taken care of by SFA, SA or ERP [Enterprise Resource Planning] tools and I focus on smaller sets of data for analysis.

What does it all mean, man?

I’d like to highlight a few things in Wendy’s responses that, in my view, have a profound impact on all of us.  Call them sweeping generalizations if you must, but I see these responses as indicative of the typical situation for those of us working in mid-sized companies doing the accounting.

First, we’re living in a multiple-systems world.  By and large, when we are producing reports we are doing so by gathering data from various systems and collating that data into a cohesive picture of the enterprise.  The systems tend to operate independently of each other.  And inevitably, excel becomes the default aggregator.  Is this your experience? Make a comment!  What systems are you running and how do the systems integrate?

Second, inside the business, operations reports trump financial reporting any day of the week!  Check out the answer to question #2.  Of seven measures given, only one is truly a GAAP number.  Compliance dictates spending a great deal of time on Financial Reports, but these don’t provide actionable data in the same way that things like capacity utilization, or net new business, or sales pipeline does.  Share some of your operational measures in the comments!  What’s the focus in your workplace?

Third, predictive analysis has become mainstream.  There was a time that this topic was reserved for B.I. technicians, I.T. analysts, and academics.  More and more it’s becoming a practical requirement from management.  So, how do you management your predictions?  What oracle are you consulting? How many tea leaves must be read?  How can we know the future?

Let’s get some comments going!

  • Share/Bookmark

Automate your data uploads

by Graham Ross on March 4th, 2010

New feature lets Indicee do the uploading

We have received lots of feedback about how easy (and cost effective) it is to get up and running with Indicee compared to traditional BI tools.  Why is it so much easier?  Because Indicee does not require a direct connection to your data base.  Instead, with Indicee you simply upload the reports or data export files from your applications.

Manual uploads work really well for small deployments and make a huge difference in how fast our customers can get up and running. However, once users see the benefit of easy access to information they inevitably want more data and want it updated more frequently. Up until now, the only way to get data into Indicee was to save a report or data file to your computer and then upload the file to Indicee.  Uploading a single file once a week is easy, uploading 10 files every day starts to take a lot of time.

Uploading reports – hands free

Indicee users have asked for an auto uploader.  We have added it, and more. Indicee (with your permission), can now be set up to grab data files from your computer.  Here are some examples of how it works:

  • Schedule your reports to a folder. Lots of applications allow you to schedule reports to a folder on your computer.  You schedule the reports to run every hour or day and schedule Indicee to grab the reports from that folder and upload them to your data mart
  • Schedule your queries.  Some customers have set up queries to grab data. You can use a program like Windows scheduler to automatically run the queries and have Indicee grab the data files and upload them to your data mart
  • Direct database connection. For more complex BI requirements, it is not always possible to find reports that contain all the data needed to answer your questions.  Indicee now has the option of connecting directly to common business applications or running custom SQL queries and then uploading the resulting data

Want to try it?

We are looking for early adopters.  For existing customers,  contact support@indicee.com and we can add the auto uploader to your Indicee solution.  New customers can take advantage our our Free48 team who will get your up and running within 48 hours. Contact our Free48 team to get started.

  • Share/Bookmark

Measuring What Matters: Interview with Cheni Yerushalmi

by Geoff Devereux on March 3rd, 2010

Using Interviews to distill meaning

Last time, we were talking about how to “Think Like a Reporter“.  My goal was to convey the importance of asking good questions in order to figure out how things actually get done and what the critical elements are in your business.

Today, I’d like to take it one step further and showcase an interview I was fortunate enough to secure with Cheni Yerushalmi, the managing partner and co-founder of Sunshine Suites in New York City.  In the interview, I’ve tried to apply the principles of good questions in order to create an environment that’s conducive to storytelling.  Then, getting out of the way and letting Cheni tell his story.

The other key point I would like to offer up as a takeaway from this experience for all of you is to stay alert for opportunities to expand your networks and your knowledge base.  This interview would not have happened had it not been for: 1) Cheni’s willingness and his courage to put himself out there, 2) the enterprising, public invitation from Gary Vaynerchuk, founder of Wine Library TV and author of Crush It, and 3) my recognition of the opportunity and taking action.  These are all voluntary actions.  How can you ever bottle up this mix of bravery, curiosity, inquisitiveness, openness, and indeed playfulness that’s required to create something out of nothing into a “formula” or a “job description”?  This stuff doesn’t show up on your desk with a neat little bow on it, conveniently labeled and packaged for consumption.  You have to create it and I think that’s a useful lesson.

Instead of existing in a constant state of “beware”, move into a state of “BE AWARE”.

Back to the point, we are talking with Cheni Yerushalmi from Sunshine Suites in NYC about business, entrepreneurship, recognizing opportunity, and the critical measures that determine success within the business.

I’ll summarize and paraphrase some stuff here to keep the wordcount net-friendly, but feel free to look for some of Cheni’s other recent appearances here, here, here, and here for more great content.

Sunshine Suites NYC with Cheni Yerushalmi

What is Sunshine Suites?

Sunshine Suites is an office community in New York City specifically designed for entrepreneurs to get out of the house and network with other entrepreneurs in a cool environment.  Sunshine has 2 locations and houses roughly 600 businesses and 1400 entrepreneurs at any one time.  Far from being just another co-working site, Sunshine is serious about creating community!  In addition to a place to work they offer mentorship, events, gym memberships, affordable healthcare, and even access to a timeshare in Vermont’s ski country!

The types of businesses incubating within Sunshine runs the gamut, “every company under the sun”, as Cheni and his partner Joe will sometimes say.

What motivated you and your partner, Joseph Raby, to start the Sunshine Suites?

Sunshine Suites was the result of the frustrations experienced, as an entrepreneur, with the lack of both affordable office space and community support available in the city.  It was the realization that “there must be a better way”.

Leveraging each other’s strengths, as all good founding partners do, Cheni and Joe took the initiative to create the tool that they wished they had when starting out.

So, what would you say to people unfamiliar with the NYC start-up scene?

Historically, the NYC start-up environment has been difficult but it’s improving.  During the heady days of the Dot-Com’s there was interest from investors and lots of money flying around, but not much of an infrastructure to support the companies.  Since the bust, it has been a slow process of building that infrastructure and creating an environment better suited for start-ups.

A couple great examples of groups supporting this infrastructure are the New York City Economic Development Corp and the Coalition of Office Space Providers.

The message coming out of New York right now is innovate and build partnerships because right now nothing is being taken for granted.

How do you measure success at Sunshine?

Feedback from the community is most important.  Of course, we keep track of revenue and occupancy rates, but these numbers don’t provide any context that we can act on.  Obtaining real feedback from members through regular surveys provides a more accurate gauge of whether or not Sunshine is living up to customer expectations and provides direction that’s actionable.  Fortunately, entrepreneurs don’t tend to be shy about sharing their opinions so we know exactly where we stand.  It’s particularly important for the ongoing success of the business since 70% of new memberships are created through referrals.

How do you balance the qualitative elements relating to feedback with the quantitative numbers side?

The business model itself isn’t very complicated.  We know the model works and, being a “for profit” business, we need to keep track of the numbers.  But, revenue is not the overriding consideration and the numbers can be misleading.  Our success is more accurately measured by the happiness of our community.  We like to think of this as a place where we help each other to succeed.  For us, it’s better to look at something like, how many companies have we been able to graduate from Sunshine? We also work with entrepreneurs who want to be more active in the management of the programming.  We call these guys “Shiners” and it’s this level of engagement that tells us we’re doing something right.

You mentioned companies “graduating” from Sunshine Suites; is that a formal process?  Is there a ceremony or what?

It’s funny you mention that.  We’re working now to create a more formal process and you should see something in Entrepreneur Magazine about it in the near future.  Entrepreneurs who have “graduated”, our “alumni”, tend to stay active at Sunshine, providing mentoring to other entrepreneurs.  As well, we provide workshops, panel discussions, and bootcamps.

What do you see for Sunshine Suites in the future?

We are looking at expansion.  We would like to expand into other cities, but we want to be careful.  Every city is different.  They each have their own ecosystem and it’s important to know the environment and the people in order to provide something of value.

Distilling the meaning in relation to Indicee

So, how do we relate what Cheni told me to what we are trying to achieve at Indicee?  Simple.  The most important performance indicators for the business DO NOT come from the financial reports.

We all know the requirements for financial reporting.  A full set of financial statements are crucial for dealing with banks, tax authorities, and investors; but it’s like Cheni said, these numbers lack the context that’s needed to guide meaningful actions on the part of managers.

Using Indicee increases the contextual meaning of your numbers and guides action in that way, beyond the financial statements.

Your customer’s happiness is not an Income Statement line item.  The path to knowing your customer comes from looking at operational measures; things like behaviour, feedback, distribution, and consumption.  This requires building the additional dimensions into your reporting structure to capture these things.

Final thoughts and random words to live by

Working within a start-up environment and having worked for start-ups in the past, I fully appreciate and applaud what the Sunshine Suites community is doing.  I would also point to other great examples out there such as TechStars, YCombinator, and our own local BootupLabs and Network Hub doing great work incubating companies and providing mentoring in order to tilt the playing field a bit in favour of innovators and disruptors who will create the next generation of market leaders.  You could even look to mainstream media and programs like Shark Tank in the US and Dragon’s Den in Canada and the UK as a means of educating and illuminating what goes into building companies. You have to look past the TV-silliness, but it’s there.

I encourage anyone who is interested in this stuff to get involved.  Check out a networking event, look for people to follow on twitter, talk to your local politicians and get talking to each other.

During our conversation, Cheni told me about when he and Joe were last in Vancouver.  The two of them flew into YVR with 2 bicycles in boxes, they assembled the bikes in the airport, then rode from Vancouver all the way to Tijuana, Mexico.  He went on to tell me that he never buys a round trip ticket when he’s on vacation.  He buys a one-way ticket in order to stay open to the opportunities that present themselves. I think there’s a great lesson in that philosophy and it exemplifies what being an entrepreneur is all about.

Enjoy.

  • Share/Bookmark
Older Posts »
RSS Twitter