Author Archive

other datasets

http://www.worldbank.org/ http://www.dtic.upf.edu/~ocelma/MusicRecommendationDataset/lastfm-1K.html http://www.metoffice.gov.uk/public/weather/climate http://scb.se/en_/ http://labrosa.ee.columbia.edu/millionsong/   https://data.police.uk     Open Source BI/DW Projects BI and Analytics BEE – http://bee.insightstrategy.cz/en/index.html BIRT – http://www.eclipse.org/birt JasperSoft – http://www.jaspersoft.com MarvelIT – http://www.marvelit.com/dash.html OpenI – http://openi.sourceforge.net OpenReports – http://oreports.com Orange – http://www.ailab.si/orange Palo – http://www.palo.net Pentaho – http://www.pentaho.com R – http://www.r-project.org SpagoBI – http://spagobi.eng.it Weka – http://www.cs.waikato.ac.nz/~ml/index.html VitalSigns – http://vitalsigns.sourceforge.net/… Read More

Anaconda

Anaconda

Anaconda is a completely free Python distribution (including for commercial use and redistribution). It includes more than 400 of the most popular Python packages for science, math, engineering, and data analysis. See the packages included with Anaconda and the Anaconda changelog.

Microsoft® SQL Server® 2012 Express

MS SQL Server 2012

Microsoft® SQL Server® 2012 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.

Microsoft Power BI

Power BI

Power BI Desktop puts visual analytics at your fingertips with intuitive report authoring. Drag-and-drop to place content exactly where you want it on the flexible and fluid canvas. Quickly discover patterns as you explore a single unified view of linked, interactive visualizations.

How to use average in Excel, =AVERAGE()

Average

In Excel you can calculate the average of a specific range of numbers or individual cells by using the =AVG() formula. For example you would like to know the average salary of the group of people shown in the image.  You can then type =AVERAGE(C2:C6), or select the range by clicking with the left mouse… Read More

Adventure Works Sample Databases

Adventure Works Database

From msftdbprodsamples.codeplex.com you can download one of the bespoke adventure works databases. They are good to use as a training and are one of the most used databases used in examples and courses of learning SQL on the web.

Microsoft® SQL Server® 2008 Management Studio Express

Microsoft® SQL Server® 2008 Management Studio

Microsoft SQL Server 2008 Management Studio Express is a free, integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server, as well as combining a broad group of graphical tools and rich script editors that provide access to SQL Server to developers and administrators of all skill levels.      

Inside airbnb.com

Inside Airbnb

insideairbnb.com is a data-set I just discovered it exists. I’m quite exited to start analyzing  this data-set and make some cool graphs and get some insights of how Airbnb is being used in all the cities around the world. Inside Airbnb is an independent, non-commercial set of tools and data that allows you to explore how Airbnb is really being… Read More

Tableau public

Tableau Public

Tableau Public is the free version of a great application to create and share interactive charts and graphs, stunning maps, live dashboards and fun applications in minutes, and then publish anywhere on the web.