Articles by Asanka Perera (Article: 1, Tip/Trick: 1)

Article: 1, Tip/Trick: 1

Articles
Technical Blogs
Tips and Tricks
Reference Articles
Projects

Average article rating: 0.00

Database Development

SQL Server

Automated dynamic report reconciliation process for SSRS using C#.NET and Nunit(.NET)

29 May 2015 Updated: 29 May 2015 Rating: 0.00/5 Votes: 0 Popularity: 0.00

Licence: CPOL Views: 14,540 Bookmarked: 1 Downloaded: 0

This process can be set up to run on a daily basis to make sure that reports which are interrelated does reconcile with each other, in order to make sure the consistency in report quality.

Average blogs rating:

No blogs have been submitted.

Average tips rating: 4.67

Integrate Google Analytic Data to Local Database using SSIS [Tip/Trick]

31 May 2015 Updated: 31 May 2015 Rating: 4.67/5 Votes: 4 Popularity: 2.81

Licence: CPOL Views: 22,271 Bookmarked: 8 Downloaded: 0

This process shows how you can integrate Google analytic data into your reporting server database in order to have daily reports and analysis to include data of your Google analytic account using a free available plugin for SQL Server Integration service called SSIS GoogleAnalyticsSource.

Average reference rating:

No reference articles have been posted.

Average project rating:

No projects have been posted.

Asanka Perera

Software Developer

Sri Lanka

Software engineer with 3+ years of experience in the IT industry working for reputed local and international companies. Currently pursing a career in Data Warehouse and Business Intelligence field while having special interests in the areas of Pattern Recognition, Bioinformatics and Statistical Data Analysis. Reading for Msc in Data Science, Engineering and Analytic at University of Moratuwa - Sri Lanka.