Analytic for Small and Medium Enterprises
In this article , we look at the tools , methods and opportunities for Small and Medium Enterprises to take advantage of the existing information as well as acquiring new information to compete with the bigger players who could well afford entire teams of DBAs and Analysts.
We look at the foundation tools of the analytic , from database to the programming languages and methods that allow anyone to freely dissect and analyze the data without opening the wallet.
MySQL Database (Alternatives – PostgreSQL )
Probably the most famous and popular database in the world. The free version costs nothing and yet powers millions of websites on the net. It is also a tale of why there is always a bigger fish in the ocean. With it , there is no excuse for any companies , whether big or small , not to have a database. All you need would be a DBA.
MySQL < Acquired by Sun Microsystems < Acquired by Oracle It is free to download at Here
2) One programming language to rule them all
R Programming Language (Alternatives – Python )
R has exploded in usage in recent years as the de-facto tool to extract , transform and analyze the data. Although the language itself has its own quirky syntax , the ease of setting up and analyzing data without learning most of the language itself has made it the darling of the Data Analysts / Data Scientists everywhere.
The fact that R has probably then best graphics output for any programming language right out of the box made it doubly so as one need not have to purchase or install external libraries or packages for displaying the information in graphics mode.
R could be downloaded for free here.
3) Visual Analytic Programs
Rattle (an R package) / RapidMiner (Free Edition) / Tableau (Free Edition) / Orange (Open Source)
These are the programs that allow non programmers to Extract , Transform and Analyze the data from GUI. Doing a regression analysis could be as easy as loading the csv file and clicking a few buttons with these programs. The downside of it is of course , you can only do as much as the program allows. But for most analytic projects , these programs offers more than sufficient options.
Billy Aung Myint