Anyone can be a DataGenius…
In my first blog for the DataGeniusIV challenge, I wrote about my thoughts on the evolution of data intelligence over the past 7 years. It was a bit of curiosity that had me look back at a simple example of data from an old project and trace its evolution from spreadsheets, to dashboards, to exploration and visualization to the idea of mobile applications. To help people get started with their DataGenius projects this year, I put together an SAP HANA Academy video series that walks through my example using the US Environmental Protection Agency data (power plant emissions data publicly available from eGRID). For this project, I used a free Developer edition of HANA Cloud Platform account and SAP HANA, then connected that to a trial Standard edition of SAP Lumira for phase 1. For the next phase, I plan to use some of the capabilities of HCP to build out a more dynamic analytics application example.
My goal was simple: provide more people with the power of insight. I love the idea of crowd sourcing the tough issues of our day. With access to information I think the conversations get broader and the understanding of the issues gets deeper – isn’t that better for us all? No more soundbites or slanted news stories on social media. What if we were all able to be our own data geniuses and find our own conclusions? Who says where the next great solution will come from? I’d say make this a middle school project and teach students technology AND science together so they are armed for the future. Give University students in science, technology and analytics usable access to the data sets of places like the EPA, ESA, UN and other agencies and NGOs so they can become more technically and socially active in effecting change. If two heads are better than one, then wouldn’t 200, 2000 or 2 million be even better?
I’m not sure how much of this I will have time to build out as my spare-time project, but here is how I started in case you want to try it yourself. Maybe you can take it from here and make it amazing! Or maybe you will use these ideas to build your own analysis of other publicly available data sets in support of your cause. Learn some new technology and save the world. Not bad for a Sunday afternoon…
SAP HANA Academy video series: DataGeniusIV_Sample HCP Project
Introduction to the Sample Project
https://www.youtube.com/watch?v=e1RQkNpDxfE
Create FREE Developer Edition of HANA Cloud Platform and Create SAP HANA Instance
https://www.youtube.com/watch?v=***5Ncs_85M
Setup Development Tools
https://www.youtube.com/watch?v=U_6wwRkxm8g
SAP HANA Cloud Platform connections
https://www.youtube.com/watch?v=cqTcozMK7zQ
Load sample CSV to SAP HANA instance in HCP
https://www.youtube.com/watch?v=oYPeby8ONkU
Create Models and Views in SAP HANA using Eclipse
https://www.youtube.com/watch?v=GerheD5P1rg
Grants users rights to objects
https://www.youtube.com/watch?v=qmQeF2iJ9K0
Open DB Tunnel into HCP account for SAP Lumira connection
https://www.youtube.com/watch?v=azhlxtVNAXw
Create visualizations in SAP Lumira
https://www.youtube.com/watch?v=K2M1rW2JNEk
Next steps: to be completed
- Setup Web IDE components
- Create web service to provide output of data to other tools
- Create Sample UI for mobile user
- Take it even further with layered 3rd party contextual data, mapping, …
Examples and samples to help you:
- Core How To videos (configuration, development, UI, JAVAScript, Modeling, etc)
- Step-by-step project to build mobile app
- Using Predictive Analysis
- Using GeoSpatial analysis
- Using Hadoop Data lake for climate values by zipcode in US
- Creating Lumira Views
- Loading Data from various formats (CSV, XML, etc)
openSAP courses in HCP Development
HCP Tutorials featuring Hello World, working with Maven, and other tutorials
SAP Lumira tutorials
Sample data sets: