"Web Analytics mit Microsodt BI"
Google Analytics is the most popular web analytics system. Almost every webpage, whether it’s a private blog or large e-commerce site, uses Google Analytics. This session will cover essential information about Google Analytics and its API guidelines, competitors, and most importantly, how you can use the data from such offerings together with your ERP, CRM, and other OLTP Systems.
You will see how to load Google Analytics data using SQL Server Integration Services, for example, and merge that data with your local data. In addition, we will walk through a demonstration of important web analytics KPIs and how you can analyze them using Microsoft Business Intelligence Tools.
Oliver Engels is CEO of oh22data AG, a Microsoft Gold Partner in Germany specializing in CRM and business intelligence. His special interests are data quality, Integration Services, Reporting Services, PowerPivot, and SharePoint. He has worked with SQL Server since version 6.5 and is a founding and Board member of PASS Germany, a PASS Regional Mentor, and runs the Frankfurt PASS Chapter. He is a Microsoft SQL Server MVP and a Microsoft PTSP.
Tillmann Eitelberg is CEO and Co-Founder of oh22information services GmbH, which specializes in data integration, data quality, and master data. Tillmann is an active blogger on www.ssis-components.net, writing regularly about data quality topics and his passion: spatial data. In addition, he has published several SQL Server Integration Services components on Codeplex. Tillmann is a board member of PASS Germany e.V., a PASS CL for the Cologne/Bonn/Düsseldorf region, and a PASS Regional Mentor.