<html><head><meta http-equiv="Content-Type" content="text/html charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><br><div apple-content-edited="true">
<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; border-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span class="Apple-style-span" style="font-size: 12px; "><div style="font-family: Helvetica; "><font class="Apple-style-span" face="Arial">Here are some free non-Python solutions that can talk to your MSSQL database:</font></div><div style="font-family: Helvetica; "><font class="Apple-style-span" face="Arial"><br></font></div><div style="font-family: Helvetica; "><a href="http://community.jaspersoft.com/">http://community.jaspersoft.com/</a></div><div><font class="Apple-style-span"><a href="http://www.pentaho.com/explore/pentaho-business-analytics/">http://www.pentaho.com/explore/pentaho-business-analytics/</a></font></div><div><font class="Apple-style-span"><br></font></div><div><font class="Apple-style-span">Commercial, but probably the best GUI tool:</font></div><div><font class="Apple-style-span"><a href="http://www.tableausoftware.com/products/desktop">http://www.tableausoftware.com/products/desktop</a></font></div><div><font class="Apple-style-span"><br></font></div><div><font class="Apple-style-span">Pandas is an option for a python approach, but you will probably run out of memory if you need analyze anything close to your 200GB of data on a single machine.</font></div><div><font class="Apple-style-span"><br></font></div><div><font class="Apple-style-span">-Don<br class="Apple-interchange-newline"><br class="Apple-interchange-newline"><font face="Helvetica">--</font></font></div><div style="font-family: Helvetica; "><font class="Apple-style-span" face="Arial">Don Drake</font></div><div style="font-family: Helvetica; "><font class="Apple-style-span" face="Arial"><a href="http://www.drakeconsulting.com">www.drakeconsulting.com</a></font></div><div style="font-family: Helvetica; "><font class="Apple-style-span" face="Arial"><a href="http://www.maillaunder.com">www.maillaunder.com</a></font></div><div style="font-family: Helvetica; "><font class="Apple-style-span" face="Arial">312-560-1574</font></div><div style="font-family: Helvetica; "><font class="Apple-style-span" face="Arial">800-733-2143</font></div></span></span>
</div>
<br><div><div>On Aug 27, 2013, at 10:18 PM, Lukasz Szybalski <<a href="mailto:szybalski@gmail.com">szybalski@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div dir="ltr"><div>Hello,<br><br></div><div>Do you know if there are any packages that allow easy data analysis? I'm currently using mssql with 200 GB of data. Writing reports for each little variation is starting to be very annoying, not to motioned time consuming. Very fast I now have too many reports that are no longer valid as sales change. Is there storage that will store the data (updated once a month), and then provide some ui to analyze it?<br>
<br></div><div>For example I would load the data in the most detail view into some table or some other format. Every part of information.<br><br></div><div>Then send user to some UI page where they would say:<br><br></div>
<div>I want all "sales" by zipcode<br>....<br></div><div>actually lets do all sales by zipcode and city, and lets sort by $, and another by counts.<br>...<br></div><div>looks like we are selling in 60641, lets dig in<br>
....<br></div><div>group by male, female, age, show counts, show $ (sort by any of the combinations)<br>....<br></div><div>Then Vlookup (inner join) into product table on product_id and lets sort by $sales/$cost...etc....<br>
</div><div>etc.<br><br></div><div>I'm looking for "group by", sum(), Avg(), sort by hitting a column name. <br></div><div>Is there some python package that does it ? or a combination of different packages? R?, etc....<br>
<br>Thanks<br>Lucas<br><br></div><div><br></div></div>
_______________________________________________<br>Chicago mailing list<br><a href="mailto:Chicago@python.org">Chicago@python.org</a><br>http://mail.python.org/mailman/listinfo/chicago<br></blockquote></div><br></body></html>