By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData Collective
  • Analytics
    AnalyticsShow More
    data science anayst
    Growing Demand for Data Science & Data Analyst Roles
    6 Min Read
    predictive analytics in dropshipping
    Predictive Analytics Helps New Dropshipping Businesses Thrive
    12 Min Read
    data-driven approach in healthcare
    The Importance of Data-Driven Approaches to Improving Healthcare in Rural Areas
    6 Min Read
    analytics for tax compliance
    Analytics Changes the Calculus of Business Tax Compliance
    8 Min Read
    big data analytics in gaming
    The Role of Big Data Analytics in Gaming
    10 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-23 SmartData Collective. All Rights Reserved.
Reading: SAS BI Dashboard: Google Analytics Dashboard Kicked Up a Notch
Share
Notification Show More
Latest News
SMEs Use AI-Driven Financial Software for Greater Efficiency
Artificial Intelligence
data security in big data age
6 Reasons to Boost Data Security Plan in the Age of Big Data
Big Data
data science anayst
Growing Demand for Data Science & Data Analyst Roles
Data Science
ai software development
Key Strategies to Develop AI Software Cost-Effectively
Artificial Intelligence
ai in omnichannel marketing
AI is Driving Huge Changes in Omnichannel Marketing
Artificial Intelligence
Aa
SmartData Collective
Aa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Big Data > Data Visualization > SAS BI Dashboard: Google Analytics Dashboard Kicked Up a Notch
AnalyticsBusiness IntelligenceData VisualizationWeb Analytics

SAS BI Dashboard: Google Analytics Dashboard Kicked Up a Notch

Tricia Aanderud
Last updated: 2012/01/23 at 12:56 PM
Tricia Aanderud
10 Min Read
SHARE

Google Analytics uses data from your Website to prepare a neat looking application where you can explore your data and answer what I consider your first-level questions. First-level questions are the most basic things you might want to know, such as How many? What Time Period? It is the second- and third-level questions where the analysis and action plans come into play. After all, it’s not enough to know how many people visited the site – you need to know what segment attracted them and how do you keep them coming back for more.

Contents
Reviewing the Google Analytics DashboardBring Value to the MeasurementsBuilding a SAS BI Dashboard Spark Table IndicatorPreparing the DataBuilding a RangeBuilding the Spark Table IndicatorCompleting the Dashboard

Google Analytics uses data from your Website to prepare a neat looking application where you can explore your data and answer what I consider your first-level questions. First-level questions are the most basic things you might want to know, such as How many? What Time Period? It is the second- and third-level questions where the analysis and action plans come into play. After all, it’s not enough to know how many people visited the site – you need to know what segment attracted them and how do you keep them coming back for more.  [More articles about Google Analytics here]

Reviewing the Google Analytics Dashboard

In the Google Analytics site on the Home tab, you can design a dashboard to review key measurements for your site. This dashboard is easy to use and works great for checking daily traffic. However, these measurements answer your basic questions, such as the counts and percentages. It’s more difficult to use the information for in-depth discovery. For instance, in the following figure I am comparing month over month traffic for the site using my dashboard.

  1. These numbers indicate the total visits for each month. So, what can I learn from these metrics? Traffic to the site increased so that is positive, but wonder what caused it. Also, I’m having to calculate the percentage in my head (very dangerous).
  2. These spark line charts depict the visits each day. Since the site primarily deals with a business related topic, most of the traffic occurs during the week. So, there are peaks and valleys for the weekends. No shocker – I knew that before I looked at this chart.

More Read

double,exposure,of,abstract,virtual,statistics,data,hologram,on,modern

The Surprising Benefits of Data Analytics for Furniture Stores

The Growing Role of Analytics in Product Development
5 Useful SEO Insights You Can Learn from Google Analytics
Understanding Google Analytics: Making the Most Out of GA for Best Results
Hackers Steal Credit Cards Using Google Analytics: How to Protect Your Business From Cyber Threats

My point from this exercise is that the dashboard was able to answer my first-level questions: How Many for each Month?  What is more or less? This dashboard does not judge performance, which is what I really need.

Bring Value to the Measurements

Consider the following Spark Table indicator from the SAS BI Dashboard. It uses essentially the same data, but with more valuable detail. From this month-over-month data, I learned more with a single glance. For instance, the largest segment (Top Social Sites) had the most traffic but the traffic from those sites is down 11% from the previous month. However, it is okay because the Organic Search has increased by 41%. (Did all my search engine optimization (SEO) implementation tips work?)  This must account for the 7.8% increase in overall visits.  (I know my total visits do not match the above figure-I applied some additional filtering during the ETL process.)

While the spark lines for this table are not as pretty as the ones for Google Analytics by smoothing the data into weeks, I can actually get a better feel for the site traffic. For instance, the drop in the social sites occurred near the end of the month, as did the Christmas holidays.  The Organic Searches rose during that same time – if I recall it was the week before I started working on the site’s SEO optimization.

This analysis actually helps me understand what I need to do next, which is determine the reason for the drop in the Top Social Sites (I suspect Christmas holidays) and to investigate the Google Keyword search to find out what the users were seeking. There’s obviously more information here to explore – but the point is that the SAS BI Dashboard can bring richer analysis to the data than Google Analytics. In addition, I was able to understand instantly the next steps.

Building a SAS BI Dashboard Spark Table Indicator

In SAS 9.3, SAS introduced the Spark Table indicators for the SAS BI Dashboard. There are essentially three steps to creating a this indicator: prepare the data, build the range (colored arrows), and build the spark table. Here’s a quick overview of the process. 

Preparing the Data

A Spark Table indicator groups your data. To provide the data as detail (for the aggregations) and partially summarized, I used PROC SQL. To create the Prev Month column (see above figure), I summarized the month and previous month counts to create a PCT_DIFF column. Then I joined the main table with the temp table so I could add the PCT_DIFF column. The following figure shows the data table in SAS Enterprise Guide and then as the data source in the SAS BI Dashboard. There are other methods available to access the data, such as SAS Stored Process or using a SAS Information Map.

Note: This table (ga_data.ga_data_sparkline) is not registered in the metadata because it is only used for this purpose and to help keep the metadata slim.

Building a Range

Not all of the SAS BI Dashboard indicators use a range. A range allows you to control the red and green arrows and the values that cause the changes. For these arrows, the PCT_DIFF value is used to judge the colors. Since my blog site traffic is small there are usually huge fluctuations in the percentage difference, I consider any change over 5% to be positive. Otherwise it’s yellow (basically unchanged). This method may not work for your organization, so obviously use measurements that make sense for your data.

This figure shows how I set up the range. There are three intervals: Below target (< 0), On target (0 – .05), and Above target (>.05).  This is how the range knows how to apply the colors.

Building the Spark Table Indicator

You can have as many columns in your Spark Table as you have data. Here’s a quick reference showing how to build the Spark Table columns.

  1. These three columns (Min Visit, Avg Visit, and Total Mth) all use the same data. The only difference is the Aggregate function chosen.  You’ll see in the figure that I have other choices available.
  2. This Prev Month column uses the minimum, which prevents the aggregation by using only one value.  This causes the range to work properly. Also note this is where I called in the Range create in the previous step. This is the only time it is used.
  3. The Trend by Week requires two settings. 
  1. Ensure the Display Settings show Week as the Spark X axis so the line is plotted correctly. 
  2. Set the Aggregate function to Spark line.

Completing the Dashboard

Add the Spark Table indicator to the dashboard. In this dashboard, there were two other indicators: Visits and Difference, which were created with Dynamic Text indicators. As you can see, these indicators simply list independent values.  The Difference indicator does have the same range I created above applied to it.  [The SAS Support site has complete documentation on building the Spark Table.]

It’s helpful to know the counts, but it’s even better to analyze the measurements in one little minute.  This article is part of my SAS Global Forum 2012 series that covers the paper Angela Hall and I will be presenting about our Building Business Intelligence with SAS book, which answers your second-level questions about using SAS BI.  We hope to see you there!

Related content:

  1. SAS BI: Looking at Google Analytics for Popular Blog Topics
  2. SAS Web Report Studio: Chart Makeover – Before and After Shots!
  3. Popular Posts, Stats, and Other Musings from 2011
  4. SAS Enterprise Guide: Quick Tip for Selecting Text in Columns
  5. SAS® Global Forum: Is Google Analytics and SAS BI a good subject?

TAGGED: dashboards, google analytics
Tricia Aanderud January 23, 2012
Share this Article
Facebook Twitter Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

SMEs Use AI-Driven Financial Software for Greater Efficiency
Artificial Intelligence
data security in big data age
6 Reasons to Boost Data Security Plan in the Age of Big Data
Big Data
data science anayst
Growing Demand for Data Science & Data Analyst Roles
Data Science
ai software development
Key Strategies to Develop AI Software Cost-Effectively
Artificial Intelligence

Stay Connected

1.2k Followers Like
33.7k Followers Follow
222 Followers Pin

You Might also Like

double,exposure,of,abstract,virtual,statistics,data,hologram,on,modern
Analytics

The Surprising Benefits of Data Analytics for Furniture Stores

8 Min Read
using analytics in product development
Analytics

The Growing Role of Analytics in Product Development

12 Min Read
google analytics tools and features
Web Analytics

5 Useful SEO Insights You Can Learn from Google Analytics

7 Min Read
web analytics with Google analytics
Web Analytics

Understanding Google Analytics: Making the Most Out of GA for Best Results

12 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

AI and chatbots
Chatbots and SEO: How Can Chatbots Improve Your SEO Ranking?
Artificial Intelligence Chatbots Exclusive
AI chatbots
AI Chatbots Can Help Retailers Convert Live Broadcast Viewers into Sales!
Chatbots

Quick Link

  • About
  • Contact
  • Privacy
Follow US

© 2008-23 SmartData Collective. All Rights Reserved.

Removed from reading list

Undo
Go to mobile version
Welcome Back!

Sign in to your account

Lost your password?