Twitter Analytics
I have recently been taking a closer look at twitter. I know a lot of people use it but what i have come to see is that a lot of companies use it as well. This made me start to wonder how if it would be possible […]
Yearly Archives: 2013
Execute SSIS packages with C#
SQL Server Integration Services packages can be executed programmatic. In this tutorial I will be showing you how to do it with C#. I will also explain how to avoid the Error “The Execute method on the task returned error code 0x80131621″. Reference In your project you will need to […]
SSIS Package Variables
This short tutorial will explain just a few of the ways you can use variables in your SQL Server Integration Services packages. From time to time you may want to create a variable in your package that you can either change easily or can update automatically. Lets say that every […]
Google Analytic’s API v3 with C# 43
Have you been trying to connect your website or application to Google Analytics? Would you like to be able to show your users Google Analytics data for your website? If you are you trying to work with the Google Analytics API in C# .net I might be able to […]
Mobile path to purchase
Google recently commissioned a Nielsen study to understand the role of mobile devices and the customers path to purchase. Nine hundred and fifty people participated in the study, they responded to a servery and there mobile usage was observed for 14 days. I found the results quite interesting […]
Google Drive API C# 113
Have you been trying to connect your website or application to Google Drive? Would you like to see a list of files or a list of Directories stored on Google Drive? Would you like to Upload a file to Google Drive or download a file from Google drive using […]
Google OAuth2 C# 147
Have you been trying to access Google Drive with C#? Do you need to upload files to Google Drive with .net? In this post, we will be looking into accessing Google Drive using OAuth2 with C# using the Google .net client library. You can change the scope easily to […]
SSIS Lesson 2: First Package
In this SSIS tutorial i will be showing you how to work with Data flow Tasks. We will be loading a text file into the database. We will be working with Flat file and Ole DB connection managers both at the package level and the project level. […]
Role playing dimensions with SSAS
Role playing dimensions in SSAS are very useful. Lets say you have a fact table with LandingPagePathId, ExitPagePathId, PagePathId. Now in your database you only need to have one dimension table dPath. All your paths are then stored in the same table. We only need to have one […]
Google Analytic’s Annotations
Google Analytic’s Annotations allow users to leave little notes attached to specific dates. These notes are then display attached to that date in your report graphics in Google Analytic’s. By double double clicking on any of the Circles in a graph you open the Create new Annotation section. […]