Article :: Database Blog ::: OneDB Technology

The R Project for Statistical Computing

05/07/2015 11:58

R is a language and environment for statistical computing and graphics. It is a GNU project which is similar to the S language and environment which was developed at Bell Laboratories (formerly AT&T, now Lucent Technologies) by John Chambers and colleagues. R can be considered as a different...

Create a Cell Drop-Down List in Excel with Data Validation

24/05/2015 13:17

Create a Cell Drop-Down List in Excel with Data ValidationAdding a drop-down list to a cell or range using Data Validation is a simple matter. Data Validation is used to define restrictions on what data can or should be entered into a cell. Here we'll use a List to restrict what values can be...

Send email by SSRS - Report Services data driven subscriptions

24/05/2015 13:15

There are a lot of information, seek by data driven subscriptions:Article:https://www.databasejournal.com/features/mssql/data-driven-subscription-in-ssrs-2008-r2.htmlConfigure the Email https://www.lumension.com/kb/Home/L-E-M-S-S-/How-To-Configure-Reporting-Services-for-Subscripti.aspxOBS: You must...

Common Table Expressions(CTE) in SQL SERVER 2008

24/05/2015 13:13

Introduction It's a headache for developers to write or read a complex SQL query using a number of Joins. Complex SQL statements can be made easier to understand and maintainable in the form of CTE or Common Table expressions. In this post, I will try to cover some of the benefits that we get when...

A duplicate attribute key has been found when processing…

03/05/2015 10:14

This post is about a common error message during dimension processing I've been asked about quite a few times so I thought it would be worth posting about it. The error message says that a duplicate attribute key has been found when processing as shown in the following screenshot for a test cube (I...

Designing Reports with SQL Server Reporting Services 2005

03/05/2015 10:10

Many applications require some degree of integration with a reporting tool. A good solution, SQL Server™ Reporting Services 2005, provides Web-based reports and can be integrated into both Windows® Forms and Web-based applications. Plus, it introduces several enhancements over its predecessor,...

What is Power BI?

03/05/2015 10:07

The Power BI cloud service works together with Excel to provide a complete self-service analytics solution. With Excel for authoring reports and Power BI for Office 365 for sharing them, everyone in your organization has a powerful new way to work with data.For more...

O que é Churn Rate?

02/05/2015 10:26

As métricas no segmento de marketing digital, até em razão de softwares e plataformas utilizadas, muitas vezes são apresentadas em inglês. Uma dessas métricas que vem crescendo em importância e, ao mesmo tempo, criando uma série de dúvidas, é o chamado "churn rate".Primeiramente, vamos...

O que é Landing Page e como otimizar

02/05/2015 10:22

"Landing" literalmente significa chegar ou aterrissar em inglês, ou seja, é o ponto de chegada do usuário assim que clica em um link ou anúncio de um website ou empresa. As landing pages são um dos tópicos mais discutidos hoje em dia na otimização de websites e buscas. Vale distinguir as landing...

Predictive marketing without data is like a Ferrari without fuel. Here's how to gas up

02/05/2015 10:19

Marketing software is becoming increasingly intelligent, with vendors building predictive algorithms to improve every aspect of demand generation and sales.But it's only as good as the data fueling those algorithms.Predictive marketing tools: An overviewLattice, Infer.com, and Fliptop provide...

Articles