What is Social Analytics? (Social Business Intelligence)

Social Media Analytics: Monitor, Measure and Manage Your Reputation on the Wild Wild Web of Social Media.

Social Media Analytics is a must-have for campaigns and organizations eager to track, understand and measure word of mouth in the ether of blogs, social networks and micro-blogging applications.

(Wikipedia is terrible btw)

A couple of populair terms about Social (Media) Analytics:

How does it work?

What will be the result of this kind of analysis?

Want to read more?
Actionable Social Analytics

What is Big Data?

Big Data – Definition

There is no universal definition of what constitutes โ€œBig Dataโ€ and Wikipedia offers only a very weak and incomplete one: โ€œBig data is a term applied to data sets whose size is beyond the ability of commonly used software tools to capture, manage, and process the data within a tolerable elapsed timeโ€.

IBM offers a good, simple overview:

Big data spans three dimensions: Volume, Velocity and Variety.

Volume โ€“ Big data comes in one size: large. Enterprises are awash with data, easily amassing terabytes and even petabytes of information.
Velocity โ€“ Often time-sensitive, big data must be used as it is streaming in to the enterprise in order to maximize its value to the business.
Variety โ€“ Big data extends beyond structured data, including unstructured data of all varieties: text, audio, video, click streams, log files and more.

Bryan Smith of MSDN adds a fourth V:

Variability โ€“ Defined as the differing ways in which the data may be interpreted. Differing questions require differing interpretations.

Google Trends on Big Data:
Below is a figure from Google Trends showing the growth of search interest for “big data” as compared to “web analytics” and “business intelligence”:

Big Data Terms / Tags:

Source article

Want to read more about Big Data?
Marc Smith from Social Media Research Foundation Speaks on Big Data

Gartner’s 2012 Hype Cycle for Emerging Technologies

Gartner published it’s annual ‘Hype Cycle for Emerging Technologies‘ last week and (like it always does) it inspires!
Read the full article here.

Here it is, this year’s Hype Cycle!


And like you would have guessed, the hot topics this year are:

Big Data

3D Printing (Lara Croft example)

Sculpture and Wire Frames by Spike_Wolf.
Want to see more? Click here (Dutch technology website)

Social Analytics

The newcomers!:

Holographic Displays


3D Bioprinting

Gartner’s 2011 Hype Cycle for Emerging Technologies

SSRS Default Date Parameter values (cookbook special)

Today I caught myself re-typing these so very common pieces of code…but there won’t be a next time!
CTRL+A…CTRL+C…TAB…CTRL+V…CTRL+S ๐Ÿ˜€

Current date:

=CDate(
CSTR(YEAR(NOW()))+"-"+
CSTR(MONTH(NOW()))+"-"+
CSTR(DAY(NOW()))
)

Previous week (-7 days):

=DateAdd(DateInterval.Day,-7,
CDate(
CSTR(YEAR(NOW()))+"-"+
CSTR(MONTH(NOW()))+"-"+
CSTR(DAY(NOW()))
)
)

First day of the current month:
=CDate(
CSTR(YEAR(NOW()))+"-"+
CSTR(MONTH(NOW()))+"-01"
)

First day of the previous month:
=DateAdd(DateInterval.Month,-1,
CDate(
CSTR(YEAR(NOW()))+"-"+
CSTR(MONTH(NOW()))+"-01"
)
)

Last day of the previous month:
=DateAdd(DateInterval.Day,-1,
CDate(
CSTR(YEAR(NOW()))+"-"+
CSTR(MONTH(NOW()))+"-01"
)
)

BumbleBI launched service provider: SQL Hotel – Shared and dedicated hosting of SQL Server databases and solutions

BumbleBI launched a new service provider called:
SQL Hotel – Shared and dedicated hosting of SQL Server databases and solutions.
 

 
Our servers are hosted in EasyNet’s datacenter at Schiphol-Rijk (Amsterdam, The Netherlands) which is directly connected to one of the world’s fastest internet hubs: Amsterdam Internet Exchange (AMS-IX).
 
Ideal for smaller databases without paying the expensive licensing costs.
Or for the large corporations for world-wide database access for free usage of Excel, PowerPivot, Power View and/or tablet apps.
 
Our Microsoft Business Intelligence (BI) consultants can support deploying your data to this cloud-environment (near realtime of by a daily import job).
 
The databases of these software suites can be made available in our SQL Hotel environment for analysis, reporting, data mining and more:
 

 
Interested? Check one of our websites:
SQLHotel.nl
SQLServerDatabaseHosting.com
 
Spread the word!