Tag Archives: mobile development

Business, Technology

Tablet Developers Make Business Intelligence Tools using Google as a Data Warehouse: Completing with Oracle, IBM, and Microsoft SQL Server

Leave a comment

And, he shoots, and scores.  I called it, sort of.  Google came out of the closet today as a data warehouse vendor, at least they need a community of developers to connect the dots to help build an amazing Business Intelligence suite.

Google came out with a Google Docs API today, which using languages from Objective-C (iOS), C#, to Java so you can use Google as your Data Warehouse for any size business. All you need to do is write an ETL program which uploads and downloads tables from your local database to Google Docs, and you create your own Business Intelligence User Interface for the creation and viewing of Charts & Graphs.  It looks like they’ve changed strategies, or this was the plan all along.

Initially I thought that Google Fusion was going to be the table editing tool to manipulate your data that was transferred from your transactional database using the Google Docs API.  Today they released a Google Docs API and developers can create their own ETL drivers and a Business Intelligence User Interface that can run on any platform from an Android Tablet, iPad, or Windows Tablet.

A few days ago, I wrote the article, which looked like they were going to use a tool called Google Fusion, which was in Beta at the time to manipulate tabular data, and eventually extend it to create common BI components, such as graphs, charts, edit tables, etc.

A few gotchas: Google Docs on Apple iPad is version 1.1.1 released 9/28/12, so we are talking very early days, and the Google Docs API was released today.   I would imagine since you can also use C#, someone can make a Windows application on the desktop to manipulate the data tables, create and view graphs, so a Windows Tablet can be used.  The API also has Java compatibility, so from any Unix box, or any platform, Java is write once, run anywhere, wherever your transitional database lives, a developer is able to write a driver to transfer the data to Google Docs dynamically, and then use Google Docs API for Business Intelligence.  You can even write an ETL driver which all it does is rapidly transfer data, like an ODBC, or JDBC driver and use any business intelligence tools you have on your desktop, or a nightly ETL.  However, I can see developers creating business intelligence tools on Android, iPad, or Windows tables to modify tables, create and view charts, etc., using custom BI tool sets and their data warehouse now becomes Google Docs.

Please reference an article I wrote a few days back, “Google is Going to be the Next Public and Private Data Warehouse“.

At that time, Google Fusion was marked as Beta on 10/13/2012.  Google has since stripped off the word Beta, but doesn’t matter.  Its even better with the Google API to Google Docs.  Google Fusion could be your starter User Interface, however, if your Android, iOS (Apple iPad), and Windows developers really embrace this API, all of the big database companies like IBM, Oracle, and Microsoft may have their market share eroded to some extent, if not a great extent.

Update 10/19:

Hey Gs (Guys and Gals), I forgot to mention, you can also make your own video or music streaming applications perhaps, using the basic calls of get and receive file other companies are already doing such as AWS, Box, etc. It’s a simple get / send API, so not sure if it’s applicable to ‘streaming’ at this stage, just another storage location in the ‘cloud’, which would be quite boring.  Although thinking of it now, aren’t all the put / send cloud solutions potential data warehouses using ETL and the APIs discussed and published above?  Also, it’s ironic that Google would also be competing with itself, if it was a file share, ‘stream’ videos, and YouTube?

Business, Technology

Mobile User Interface: Heat Map will Focus Users’ Attention to their Priorities

Leave a comment

The Windows Mobile User Interface (UI) reminds me of a project or program manager heat map report which will draw the attention of the viewer, at a high level, immediately to the most important or high priority areas of the project.  I don’t think a Heat Map is part of the Windows Mobile User Interface, but it’s an interesting concept to immediately draw attention of the smartphone user what they want to focus on, according to their preferences.

A project Heat Map is a common tool to look at complex data, and enable the user of the map to quickly, at a glance, guide their focus toward the important aspects of the data.  A mobile user interface [dashboard], at a glance, that has squares, or spaces, that expand, retract and changes colors, based on specific application user preferences can be a leap in evolution of the smartphone user interface paradigm.

At this point Android has widgets on their dashboard, and both Android and iOS have screens of icons representing applications that I must sift through to get to the specific application I would like to launch.  Widgets were an evolutionary leap allowing the user to display some of the pertinent information, as well as launch specific features of the application right from the mobile OS pages screen.

Allowing the user to designate importance to specific application properties, and then the application squares or spaces that represent the application, grow or shrink, and change colors based on user defined attributes assigned within the application for the user’s level of importance.  For example, I can provide a ‘space’ for Facebook, and if there are certain birthdays of people I am fond of, I can assign a color to the application space to change, and growth indicates amount.  It could be a hue of colors within the space. If there are Facebook user messages, that could indicate another color, and a portion of the space turns that color, and the space grows or shrinks based on the amount of messages.  The application spaces also shrink and grow relative to the total Mobile OS user interface (UI) [dashboard] page (i.e. available screen space). The space overall of the Mobile OS UI screen would have a relative importance between each of the OS applications on the Mobile OS [dashboard] page / screen prioritized by the user, e.g. The user prefers to see their Facebook messages over their importance of their twitter functionality

In addition, automatically, mobile applications should appear and disappear from the heat map dashboard where applications can be launched.  The two ways to execute a mobile application, drill down to the application through the normal hunt and peck for your app, or execute the application from the heat map in the dashboard.  The applications that you use the most will automatically appear in the dashboard, thus you don’t have to manage the applications that appear on your dashboard.

[dfads params=’groups=1177,1178&limit=1&orderby=random’]
Business, Finance, Technology

Mobile Advertisers and Affiliate Network Continued Expansion

Leave a comment

Mobile Adverting, Cost Per Acquisition, will grow and continue to apply to In-App purchases, from appliances from a distributor catalogue to a mobile application, virtual products, relatively open landscape for advertisers and reliable, affiliate networks should bloom. Good brand, easy integration capability affiliates are an exclusive membership, primarily an oligopoly at this point, ripe for expansion and VC.

http://allthingsd.com/20120910/exclusive-google-offers-exec-eric-rosenblum-leaves-for-mobile-ad-start-up/