Making it easier to discover datasets

Clique na imagem para seguir o link

Clique na imagem para seguir o link

Novo recurso da google para identificar conjuntos de dados.

In today’s world, scientists in many disciplines and a growing number of journalists live and breathe data. There are many thousands of data repositories on the web, providing access to millions of datasets; and local and national governments around the world publish their data as well. To enable easy access to this data, we launched Dataset Search, so that scientists, data journalists, data geeks, or anyone else can find the data required for their work and their stories, or simply to satisfy their intellectual curiosity.

Tags:

SQL Server Data Mining News

clique na imagem para seguir o link

clique na imagem para seguir o link

Um site com visão da microsoft para o data mining

Welcome to SQLServerDataMining.com

This site has been designed by the SQL Server Data Mining team to provide the SQL Server community with access to and information about our in-database data mining and analytics features.  SQL Server 2000 was the first major database release to put analytics in the database.  Catch up with the latest SQL Server Data Mining news in our newsletter.

SQL Server 2012 SP1 Data Mining Add-ins for Office (with 32-bit or 64-bit Support)

The Data Mining Add-ins allow you to harness the power of SQL Server 2012 predictive analytics in Excel and Visio and they have been updated to include 32-bit or 64-bit support for Office 2010 or Office 2013. Use Table Analysis Tools to get insight with a couple of clicks. Use the Data Mining tab for full-lifecycle data mining, and build models which can be exported to a production server.  Visualize your models in Visio.

SQL Server 2012 Data Mining

Microsoft expert Rafal Lukawiecki provides free and paid videos on data mining for SQL Server 2012 at Project Botticelli. The website has other Microsoft BI topics too from leading Microsoft experts.

SQL Server DM with Excel 2010 and PowerPivot

Microsoft MVP Mark Tabladillo shows you how to unleash SQL Server 2008 Data Mining with Excel 2010 and SQL Server PowerPivot for Excel, Microsoft’s new self-service BI offering.

Tags: , ,

Top Excel Tips For Data Analysts

clicar na imagem apra seguir o link

clicar na imagem apra seguir o link

Excelentes concelhos para utilização das últimas ferramentas implementadas no Excel.

TIPS FOR DATA CLEANING
1) Change format of numbers from text to numeric
2) Unpivot columns in a data set (Multiple consolidation ranges and Power Query)
3) Merge data from several csv files into a single folder (RDBMerge Add-in and Power Query)
4) Fill empty spaces from content above (Ctrl + Enter trick and Power Query)
DATA ANALYSIS
5) Create auto expandable ranges with Excel Tables (Source for pivots, dropdown lists and formulas)
6) How to do two way lookup with INDEX and MATCH
7) Creating OR criteria within SUMIF/COUNTIF (Combination of SUMPRODUCT and SUMIF/COUNTIF)
8) Counting unique items within PivotTables (Using the Excel Data Model)
DATA VISUALIZATION
9) Quickly visualize trends with Sparklines
10) Create dynamic titles in charts (Use of cell references within chart objects)
11) Dealing with empty cells in charts and sparklines [use NA()]
12) Save time with Quick Analysis

Tags: ,