Skip to main content

Featured post

Golf Solutions Designed at Barnham Broom Golf Club in Norfolk

 Many sports tend to be biassed towards one sex or another. For example, football is a sport dominated by men and does not become much more masculine than rugby! On the other side of the fence, netball definitely falls into the women's category. However, there are some sports that share gender gracefully, which appeal to both men and women. Reddit live streaming Golf is undoubtedly one of these sports and has no age limits. Spread across courses in the UK you will find some unlikely groups of people bound by their love for this great outdoor sport. Some will play every day, while others will only play on the weekends, perhaps as a way to relieve the stress of a difficult week at the office. No golfer tends to join a club and membership packages vary widely in price. Most golf clubs simply offer standard packages with the assumption that one size fits all and offers a bit of flexibility. However, some offer more realistic membership packages, considering how much you will be playing...

Analyzing Google Analytics data in Tableau

Google Analytics is the  most widely used website statistics service. It provides a great online platform to analyze your web site traffic. Although it provides powerful charts, reports and dashboards to analyze data, if you have needed to use it professionally, you hit its limitations frequently and do the following : Export the Google Analytics data to Excel and try to analyze it there. This manual and tedious process is always needed if you are trying to merge Google Analytics data and some other data in your analysis.

We know that Tableau provides a great data visualization tool and we could leverage its power to analyze Google Analytics data. But to bring the data into Tableau was tedious; you should export it first (to Excel manually or by using Google Analytics API and lots of scripting). Not anymore! With Tableau version 8 onwards, Tableau Software has released Google Analytics connector which makes it quite easy to pull in your Google Analytics data into Tableau. This does not only allow you to create incredibly interactive dashboards to analyze GA data but also allows you to integrate Google Analytics data with some other offline and online data to add great value to your web site analytics effort.

In this short video below, Ellie Fields from Tableau Software, demonstrates how powerful and interactive analytics opportunities Tableau brings to web traffic analysis. In the 3 minutes win Google Analytics challenge, she brings it some data from Google Analytics using the connector and then merges it with some offline data to create an interactive Tableau dashboard.

If you want to try it on your own, you can download Tableau here.

Tableau Google Analytics Connector makes it very easy to create web site traffic analysis dashboard

Tableau can import a Google Analytics extract into the Tableau fast in-memory data engine. This allows you to explore your web data at the speed of thought by easy drag & drop. You can Tableau Server and Tableau Online to build and store multiple small extracts of un-aggregated data. By reusing extracts you don’t have to pull every time from the Google Analytics interface and hit the 500,000 limit per individual per call. Start with a fixed date range and schedule automatic updates.

You can enhance the web-analytics data by Salesforce.com, spreadsheets, databases, cubes, Hadoop, or more. Then you can easily publish securely for your department or entire organization to use. Set permissions for dashboard, workbook, and data-source access by role and group or for individual named users.

Comments

Popular posts from this blog

What is JEDOX?

Jedox is a Self Service Business Intelligence, Analytics and Performance Management platform developed by Jedox AG based in Freiburg im Breisgau/Germany. With a modular structure, JEDOX platform uses Microsoft Excel as its user interface on the one hand and a Jedox-specific spreadsheet on the other, both of which can be used in all common browsers. Jedox is unique in a sense that while most business intelligence solutions try to replace MS Excel based analysis and planning process entirely with their platform (and usually fails to do so because at one point things are exported to Excel), Jedox puts the powerful MS Excel sheet in the heart of their solution. By doing this they provide a familiar interface to users while enhancing business intelligence capabilities far beyond MS Excel. This is actually what JEDOX offers in a nutshell : Excel Plus. The modular architecture of JEDOX has a cell-oriented, multi-dimensional in-memory OLAP server that has been especially designed for...

Data Analytics for Online Shops

Making shopping a smooth and easy experience is the goal of many online shops. But how can easy website navigation be optimized? Unlike the physical shops, you cannot talk to the sales people in the online shops and a customer should find his or her way through the online shop. And unlike pysical shops, online shops can have hundreds of thousands of visitors every day. To optimize the shopping experience, some important questions should be answered : Why do customers put products into their shopping cart and do not buy them at the end? Was it because of the sales process or he/she liked another product simply better? What impact has a customer's drop from a detail page? Where are the differences in customer behavior depending on the different product groups, Customer types or assortments? What are the figures compared to the previous year? Were there any technical errors? Was the accessibility of all pages always guaranteed? Traditionally, answering these questions require a lot of...

Hands on Power BI Workshop in Singapore - Dashboard in a Day

Power BI Dashboard in a day is a hands-on workshop for Business Analysts, covering the breadth of Power BI capabilities. At the end of the workshop you will Understand the value of Power BI Have basic exposure with the product to be able to use it when they return to their office Understand how Power BI differentiates from the competition and become Power BI advocates in their organization Know what the next steps to learn more about Power BI and become part of the community. The workshop is 200 SGD per attendee. See below for the agenda. Date       : 15 February 2019 09:00 AM - 05:00 PM Venue     :  87 Beach Road Chye Sing Building #03-01 Singapore, Singapore 189695 Agenda  : Morning – Introduction to Power BI and Power BI Desktop overview – Power BI Desktop – Lab – Lunch and demos Afternoon – Power BI Service overview – Power BI service – Lab – Bring your own data and build dashboards – Q&A