Best ETL Tools Vendors 2014 Gartner Report

Gartner release the report of top data archive (ETL) market share leaders .Yes informatica is still on top position in leaders and IBM very close to informatica both these provide excellent etl solutions to markeet .See microsoft stand in challengers microsoft improve our etl solutions SSIS and add many functionality and flexiblity i am personally very big fan SSIS because it is so simple and easy to learn especially for students who start our career as a BI developer. After see this report i plan to learn informatica power center plus ibm info sphere datastage .

So what you plan which tool you learn to start career as a BI data integrater developer.tell in comment box.

1 comment

Posted at 2:21 AM |  by Unknown

Top Free Big Data Plateforms For Learning At Home.

Nowadays you see every where on many website about big data yes big data what is big data how work big data and many questions come in brain after first time you listen or see this Big Data.Nowadays every single teen use approximately 3 to 5 smart gagets who work with online and produce data think about how much data produce millins off teens and other offece works business users companies industries etc produce alots off data waves and the handling of this data wavrs very difficult with traditional relational databases like oracle,ms sql,db2,sybase,my sql and many more.In 2004-2005 google publish whitepaper on map reduce then after some time yahoo develoer work on this technology and remove weeknesses and implement more advancement on this technology.One by one other companies like face book work on this and envent hive language use for big data set processing look like sql .But some companies totally work on this big data technology and make more effient and relieable for large amount of data processing  names are.
goolge
yahoo
facebook
IBM
Cloudera
Hotonwork
MapR
Microsoft
Twitter etc

Best Free Platforms/Tools For Learnong BigData Technology.

1.Cloudera

cloudera offer free single node vm run on any plateform and many free video tutorials and white papers you can download and practice own personal environment.
Download Cloudera Vm Click here.

2.Hotonworks

 Hotonworks also offer free single node vm run on any plateform and many free video tutorials and white papers you can download and practice own personal environment.
Download Cloudera Vm Click here.

3.MapR

MapR also offer free single node vm run on any plateform and many free video tutorials and white papers you can download and practice own personal environment.
Download Cloudera Vm Click here.

4.HDInsight

Microsoft  also offer free single node vm run on any plateform and many free video tutorials and white papers you can download and practice own personal environment.
Download Cloudera Vm Click here.

Microsoft All so offer hdinsight service on cloud with alots of more features and many nodes .singup on azure free trial and and work with hdinsight fully cloud integrated plateform.

If you have any query related this post plz write in comment box.stay connected with hnhsol.com.
  

No comments

Posted at 2:47 AM |  by Unknown

Free Download SaS Analytics For Students & Teachers.

So SaS finaly release free Analutics U edition for global acadamic students and teachers. Who want to  learn SaS studio with lots of analytics features lets check out and explore SaS Analytics U.

SaS Analytics U features.

 

SaS Base  for sas stodio programing laguage look like sql and very easy to learn.
SaS Stat   is a statistical tool use in sas.use for statistics.
SaS IML  is for  billion of  rows data analysis and exploration in depth.
SaS Access  is use for accessing data from different sources an different formates of data.

Download & Configure SaS Analytics U.

Step 1.Download  SaS Analytics U.
(Note: this edition is and image and run on vitualbox and vmware i suggest that you download vmware version beacuse in virtualbox some compatiblity issues.)

step 2: after you download both SaS Analytics U and vmware .Click on OPen new virtual machine and locate the file where you save it then clik on ok.Your machine is appear and you see in bottom click on virtual machine setting where allocate hardrivw and ram to this macine and click on green button your machine start loading SaS analytics U.

step 2:  After some process this window open copy paste this url in browser and press enter.

step 4: Then finaly click on stat studio button .

After the whole process is done you sas analytics u studio is open and you work on this with some builtin libraries sample data.

No comments

Posted at 2:57 PM |  by Unknown

Free Data Mining Add-in for Ms Excel 2010 & 2013.

Microsoft release new data mining add-in for ms excel 2010 and 2013 both.These data mining add-ins work with SSAS (sql server nalysis services) and create predictive models.These add ins work well with big data all so and visualize data in ms visio.

Click on link for download Data Mining Add-in.

After you download these add in now open ms excel you can see the data mining tab click on this data mining tab,now you see the connection button click on this button beacuse these add in work with SSAS Ms SQL Server .

 Connect to SSAS new window open write the server name and select catalog name is the default database where you data sets and data models deploy and process.

No comments

Posted at 3:03 PM |  by Unknown

Gartner 2014 Analytics & BI Top Platforms.

Gartner announced 2014 analytics and business Intelligence top platform venders .In this report top leaders are Tableau, Microsoft, Sap, SaS, IBM, Microstrategy or Oracle and hold around 70% market share only these big leaders. 

Try these plateforms tools.

1. .Tableau

Tableau is the big leader in analytics and bi according to gartner report 2014 tableau provide rich executive clean rich dash-bords reports and multiple access of data sources  files forrmates like csv,txt,excel etc as well as with multiple data sources like ms access, sql server, oracle, db2, sybase etc and all so provide connection with Big Data hadoop clusters connect to cluster and access big large amount of data for data analysis and create etl and much more done with Tableau plateform.

2. Microsoft

Microsoft the second big vendor provide best analtics and business intelligence solution microsoft Bi plateform divide into 3 parts SSIS, SSAS, SSRS these three services provide by ms sql server BIDS tools defult buitin in enterprice or BI Editions.Microsoft sharepoint server all so collaborate with this whole microsoft bi solution .Microsoft Excel all so done good job in predictive analytics and bi reporting and data analysis with power view,power query,power map, data mining ,master data services and many more more ms excel add ins.

Preview of ms excel self BI features.

Power View use for create reports and dashbords.

Power Map for data 2 and 3d visulization.

Data Mining add ins for Predictive analytics.

search other vedors tools if you feel any confusion then ask i try to solve your problem.so lets start your career as a business analyst or BI develper.

3 comments

Posted at 1:29 PM |  by Unknown