715 search results for "SQL"

AlienVault Longitudinal Study Part 4

AlienVault Longitudinal Study Part 4

In Part 1 we looked at acquiring raw data, and wrangling it into a time series dataset. In Part 2 we looked at types of threats in the time series. In Part 3 we looked at countries. Now we will examine countries and types in combination in the AlienVault reputation database. Just as we shaped our dataset for better understanding in previous...

Read more »

Can You Track Me Now? (Visualizing Xfinity Wi-Fi Hotspot Coverage) [Part 1]

June 6, 2014
By
Can You Track Me Now? (Visualizing Xfinity Wi-Fi Hotspot Coverage) [Part 1]

This is the first of a two-part series. Part 1 sets up the story and goes into how to discover, digest & reformat the necessary data. Part 2 will show how to perform some basic visualizations and then how to build beautiful & informative density maps from the data and offer some suggestions as to how to prevent potential tracking. Xfinity...

Read more »

Stuff I’ve gotten horribly wrong

June 5, 2014
By
Stuff I’ve gotten horribly wrong

I'm the first (I hope) to admit when I've gotten something wrong. I like to think I'm humble enough to realize that there are limits to my knowledge. Actually, humility doesn't enter into it. Every day I'm confronted with things that I don't know or understand. Those same limits can often blind me to being

Read more »

Introducing R for Big Data with PivotalR

June 4, 2014
By
Introducing R for Big Data with PivotalR

Wouldn't it be great if there was a way to harness the familiarity and usability of a tool like R, and at the same time take advantage of the performance and scalability benefits of in-database/in-Hadoop computation? We're happy to announce PivotalR, a package that translates R code into SQL for processing, is available to download from GitHub today.

Read more »

How does Practical Data Science with R stand out?

June 2, 2014
By
How does Practical Data Science with R stand out?

There are a lot of good books on statistics, machine learning, analytics, and R. So it is valid to ask: how does Practical Data Science with R stand out? Why should a data scientist or an aspiring data scientist buy it? We admit, it isn’t the only book we own. Some relevant books from the Related posts:

Read more »

The Purchase Funnel Survives the Consumer Decision Journey

May 19, 2014
By
The Purchase Funnel Survives the Consumer Decision Journey

The journey metaphor is almost irresistible. All one needs is a starting point and a finish line, plus some notion of progression. Thus, life is a journey, and so is love. Why not apply the metaphor to your next purchase? McKinsey & Company takes s...

Read more »

R is short for SSIS

May 18, 2014
By

R is Short for SSIS Data scientists often identify a need to join data from different, unlinked servers. One standard tool for accomplishing this is an SSIS package to consolidate the data onto one of the servers. For the analyst who wants to...

Read more »

Dining in San Francisco – Let R Guide You

May 6, 2014
By
Dining in San Francisco – Let R Guide You

I’m frequently asked by newcomers to R to provide an easy to follow generic set of instructions on how to download data, transform it, aggregate it, make graphs, and write it all up for publication in a high impact journal – all by the end of the day ! While such a request is somewhat

Read more »

Dining in San Francisco – Let R Guide You

May 6, 2014
By
Dining in San Francisco – Let R Guide You

I’m frequently asked by newcomers to R to provide an easy to follow generic set of instructions on how to download data, transform it, aggregate it, make graphs, and write it all up for publication in a high impact journal – all by the end of the day ! While such a request is somewhat

Read more »

analyze the censo demografico no brasil (censo) with r and monetdb

May 6, 2014
By

almost a century older than its own capital city, the decennial censo demografico no brasil (censo) forms the basis of every major survey product in the country.  the pesquisa nacional por amostra de domicilios (pnad), the pesquisa de orcamentos f...

Read more »