Let’s face it, large datasets can be overwhelming and intimidating. Just because data begins as an endless shapeless stream of facts and figures, who says it has to stay that way? There are many ways to present raw data in an easy-to-read format.
For many routine business scenarios, Microsft Excel is the tool used to convert flat tables into pivot tables and charts in order to make sense out of the data and help make some business decisions. But by the time it reaches your target audience, it is outdated most of the time.
Getting the data into a readable format is one thing. The more important part is delivering it to your target audience in timely manner and viewable on their choice of platform (PC, tablet or smartphone).
Mobile devices are playing a big role in accomplishing such routine tasks. What’s more, research shows that users are spending more time on their mobile devices, compared to a standard PC, to access information and take quick actions. According to Digital Ad Agency Vertic:
- Enterprise tablet adoption will grow by almost 50% per year.
- By 2015 mobile app development projects will outnumber native PC projects by a ratio of 4-to-1.
The purpose of my blog post is to give the reader an overview on new technologies that can be used to convert line of business (LOB) data into a multi-platform mobile compatible format and build mobile web interfaces. The image below can illustrate the basic idea.
Converting flat data into mobile compatible formats like JSON, Web APIs and OData services can be used to achieve common goals. Before going further into more technical stuff, let’s first understand these terms.
The Open Data Protocol (OData) is a data access protocol built on core protocols like HTTP and commonly accepted methodologies like REST for the web. OData provides a uniform way to query and manipulate data sets through create, read, update and delete (CRUD) operations. You can learn more about OData by visiting OData.org.
I could write a whole separate blog post on different ways you can access this data and apply filters as URL parameters, but let’s keep going. So we have cloud enabled LOB data in JSON format, let’s see how we can add a mobile interface to make sense out of it.
There are three types of mobile apps currently being built: native apps, web apps, and hybrid apps. I’m going to show you an example of a mobile web app. There are tons of third-party free/paid tools available out there to build mobile web apps. But I have used HTML5, JQuery, and JQuery Mobile to build mobile web apps successfully and they are all free.
When we apply the mobile formatting to it, the final result would look like this on an iPhone screen:
If you like to make it bit more interesting for your executive team members, you can use Google Chart API and add some interactive charts to this app.
We also talked about responsive design. So to make it more useful for tablet users, you can use HTML5, CSS3 and jQuery Mobile features to detect screen size and display more content on tablet screens:
Check out the Responsive Web Design blogpost written by Drew Bills to learn more.
This gives you an idea on how you can make flat and boring data accessible on mobile devices. There are many tools available to make this process easy and automate repetitive tasks. For example, Microsoft has done a great job with new version of Visual Studio 2013 which has many in-built features and templates to create Web APIs and OData services.