Vertica VSQL as your Mac App

Today I installed Vertica VSQL (Verticals CLI - command-line interface, more info below) at my Mac and I build the Mac application to run VSQL from me. Good job to I :).

If I did not build that, I will need the open terminal and fined the location of the VSQL or add the VSQL folder in my PATH ... 

And how I done that, off-course I ask Google and found nice and simple steps from tubedogg - thank you. I just add my command and the application name.

1. Open Automator and double-click on Application.
2. In the "Name" search box, type Apple and you should see "Run AppleScript".
3. Drag "Run AppleScript" into the right-hand window.
4. Where it says (* Your script goes here *), replace that text with the following code:
   
   tell application "Terminal"
     activate
     do script with command "JMeter"
   end tell
   -- My code
   (* My Application - Run The VerticaVSQL at VMWARE *)
   tell application "Terminal"
     activate
     do script with command "/opt/vertica/bin/vsql -U dbadmin -d VMart -h 172.16.212.136"
   end tell
   
5. File > Save and enter a name (my name: VerticaVSQLatVMWARE), and choose where to save the application (I saved the application at the Applications folder were rest of application are)
6. Double-click on the newly created application.
   In my case, 
   

________________________
What is VSQL? Log definition, 

The VSQL is a character-based, interactive, front-end utility that lets you type SQL statements and see the results. It also provides a number of meta-commands and various shell-like features that facilitate writing scripts and automating a variety of tasks.

Very cool installation and quick VSQL overview you could see at this youtube channel Connecting To Vertica - VSQL ...   

If you are new to machine learning?

As per Kaggle (The Home of Data Science) if you are new to machine learning it is recommendation to do these interactive Titanic Dataset tutorials:

• From R people - Provided by DataCamp this tutorial.
• For Python people – Provided by Dataquest this tutorial.

More info related to the Titanic Dataset see the this url. 

I am doing the R tutorial and it is brilliant, easily to follow and fully interactive - You do not need R/R-Studio installed on your machine - you just need browser. I must admit, I used the R/R-Studio for an additional validation. However this is not needed, you could do that all via interactive console.   


Kaggle R Tutorial on Machine Learning by The DataCamp Team - Overview

CHAPTER 1

• Raising anchor550 XP
• How it works
• Set Sail
• Understanding your data
• Rose vs Jack, or Female vs Male
• Does age play a role?
• Making your first predictions 

CHAPTER 2

• From icebergs to trees 
• Intro to decision trees 
• Creating your first decision tree 
• Interpreting your decision tree 
• Predict and submit to Kaggle 
• Overfitting, the iceberg of decision trees 
• Re-engineering our Titanic data set 
• Passenger Title and survival rate 

CHAPTER 3

• Improving your predictions through Random Forests 
• What is a Random Forest 
• Press Enter To Start 
• A Random Forest analysis in R 
• Important variables 
• Reset Course Progress

The fastest way to learn Swift

For some time I was out of Swift programming and Xcode IDE. And to refresh my knowledge, I was google–ing for a nice videos to speed up my recovery process and I was lucky to find the “Code With Chris” channel and play list “How To Make an App with Swift, Xcode 6 and iOS 8” the URL ... URL https://www.youtube.com/playlist?list=PLMRqhzcHGw1Z0S7hpE30r2lwnovSHMntI      

Almost, I finished the play list and I am very impressed how Chris methodically introduces Xcode and Swift (object programming) via his channel.  

I am highly recommending this play list for anybody interested to learn Swift and/or Xcode 6.

PS. I said that I was lucky, to bump on the “Code With Chris” channel, I don’t think that any more – 15 videos were viewed 579,208 times – that is recommendation by it self. 

Swift - intuitive new programming language created by Apple for building iOS and Mac apps.

Xcode IDE - Integrated development environment (IDE) containing a suite of software development tools developed by Apple for developing software for OS X and iOS.

Tableau Public - Now Everybody's Premium!

Now Everybody's Premium!

Tableau used to see a product called Tableau Public Premium. Starting couple days ago, that product is no more, because Tableau giving all of those features to every Tableau Public user for free. 

These are the features now available in Tableau Public:  

• A 10 million row limit per workbook

• 10GB of storage space

• The choice of whether to allow people to download your workbook and its data

• No impression limits

• No domain limits for embedded visualizations

Our Tableau Gallery  

Open data and explore it with Tableau Desktop Public Edition. Drag & Drop. Create stunning visualizations with ease. Download the app. 

Save and store your visualizations on your Tableau Public profile. Personalize your profile and connect with other authors. Create your profile. 

Share your visualizations with the world via social media. Or embed them on a site or blog. Your published vizzes are always live and interactive. View the gallery.

Source Tableau Public - https://public.tableau.com  

NoSQL Databases – e.g. MongoDB “Have a go!”

Last week, I saw again – after long time - the “Introduction to NoSQL by Martin Fowler" presentation from Feb, 2013 … and that wakeup my interest, again, to see what is going on in the NoSQL database space.

Wow … a lot!

I must admit, I was very impressed with very good resources for NoSQL databases and all supporting tools.  This weekend, I had a go! And first question I had, was: "What NoSQL database I will test/explore first?". With google’s help, very soon I founded that MongoDB is the first in line to have a go; well know and supported across platforms. And that  was right decision.

What I did?

I created new Linux Ubuntu VMware (Fusion), installed MongoDB, Python, Bottle, Sypder and Robomongo – and I had good fun. 
This is fist time (for long time) on the Linux, I did not have any problems with installations and connectivity between database/MongoDB and all tools (Python and Rodomongo). All worked first time – with very little google’s help! Thank you to all people involve with in these projects.

I am old RDBMS dude, and I was very impressed with MongoDB speed – please note this is speed on the VMware machine with 4GB RAM, hosted on iMac late 2009 with 16GB RAM. Next step is to explore fusion between Python and MongoDB .

Below are link I would like to share with you. Have a good day and have a good fun with MongoDB:  

• “Introduction to NoSQL by Martin Fowler" 
• O'Reilly Webcast: MongoDB Schema Design: How to Think Non-RelationalMelbourne, 11-Nov-2014
• BUILDING WEB APPLICATIONS WITH MONGODB: AN INTRODUCTION

Swift

If you are geek like me and you like a programming languages and you do not hate Apple, I think you should explore the new programming language for iOS and OS X. I must admin it is more fun than Objective-C.

For the jung geeks :) I am recommending YouTube tutorial by Rasim Muratovic - Swift Programming Tutorial and for more experienced geeks YouTube tutorial by Skip Wilson - Apple Swift Programming Language Tutorial Series.

Have a good Swift-ing! 

PS. Recently, I discovered additional two YouTube channels Brian Advent and The Code Lady. 

Data Vault - Data warehouse modeling

In last couple of months I am obsess with the Data Vault (DV) modeling technique, to design enterprise data warehouse (EDW). The inventor od DV is Dan Linstedt (www.danlinstedt.com). 

Below are some comments sourced from the Lucrum Business Intelligence (www.lucruminc.com), I think they are very good summary of the DV modelling.   

__________

.... The data vault is not a product.  It is not a magic pill that makes all your IT ills go away. It is a comprehensive approach to addressing real world issues with existing implementations.  It brings real flexibility and adaptability to the implementation and brings reliability and dependability to the business.  And with a team that understands the power of the data vault, you are now able to take your Business Intelligence environment upon which the tools that do the flash and splash can be sourced from. ....

__________        

... Modelling Rules for Each Part of the DV Entity:

FOR HUBS:

• Hubs keys cannot migrate into other hubs (no parent/child like HUBS).
• Hubs must be connected through links.
• More than two hubs can be connected through links.
• Surrogate keys may be used.
• Business keys are 1 to 1 relationship with surrogate keys.
• Hubs primary keys always migrate outward.
• Hub business keys and primary keys never change.
• If a hub has two or more satellites, then a point-in-time table can be built for ease of joins.
• An ‘UNKNOWN’ business key record can be inserted into Hub that can be used to tie other data in links and sats that has no business keys in source. This kind of data is usually a bad/incomplete source data.

FOR LINKS:

• Links can be connected to other links.
• Links must have atleast two hubs associated with them in order to instantiated.
• Surrogate keys may be used.
• The combination of surrogate business keys made a unique key.
• Does not contain descriptive data.
• Does not contain begin and end dates.

FOR SATELLITES:

• Satellites may be connected to hubs or links.
• Have 1 and only 1 parent table.
• Satellites always contain either a load date-time stamp, or a numeric reference to a stand-alone load date-time sequence table.
• Primary key is a combination of ‘surrogate key’ from either hub or link and the load datetime stamp.
• Surrogate keys may not be used.
• Must have a Load End Date to indicate when the CHANGE to the data set has occurred.
• Satellites are always delta driven. Duplicate rows should not appear.
• Data is separated into satellite structures based on 1) type of information 2) rate of change.....

PS. The images was sourced from this web site  http://thefuturevalueofbusiness.com/index.php?s=Data+Vault , however this web site in not any more active.