BLOG   |  CONTACT   |  1.866.526.9955

The Lasso Blog

Getting insight from your data is not always easy—there is either too much, too little, or displayed in a format that doesn’t give you the information you need. 

Last year, we introduced the Lasso Data Export Service. This service provides you with a way to feed your Lasso data into a reporting tool of your choice, allowing you to turn that data into customized reporting that helps you make data-driven business decisions.

There are a variety of excellent reporting tools to choose from, but some may require comprehensive technical knowledge to achieve the results you want and/or are costly. Enter Google Data Studio – a free application that allows you to create informative, easy to read, easy to share, and fully customizable dashboards and reports.

Google Data Studio gives you all kinds of options to tell your data story with features that allow you to:

  • Display your data in various ways, including line, bar, pie, and area charts as well as lists, pivot tables, and scorecards. You can even create heat maps!
  • Aggregate your data across projects and/or filter by specific projects, users, source types, ratings, history, questions, etc.
  • Apply styles and color themes, and include links, text, and images.
  • Select date ranges such as weekly, monthly, quarterly, or yearly.
  • Compare date ranges, e.g. this year to last year.
  • Transform your data further by creating your own metrics with custom calculations.
  • Share your report with others via link, send it as a PDF, schedule it to be emailed, or download it to CSV or Excel.

The steps to begin using Google Data Studio to create your own Lasso reports are as follows:

1) Create a Google account, if you don’t have one already, and add a billing account.

2) Provide Lasso with your Gmail address

3) Lasso will implement the data export service via BigQuery (a SaaS data warehouse) and provide you with a data export ID (dataset).

4) Start with a blank report.

5) Select BigQuery to connect your data.

6) Select the project, dataset, and table containing the data you need for your report, and then click CONNECT

7) Start creating your report!

There’s an easy-to-use tool bar at the top of the page.

The sidebar to the right is where you choose your chart, fields, and styles.

Want to start using Google Data Studio for your reports? Contact us to get started!

Resources:
https://support.google.com/datastudio/answer/6283323?hl=en&ref_topic=6267740

https://support.lassocrm.com/hc/en-us/articles/360035209292-Create-Reports-in-Google-Data-Studio-Using-Lasso-Data-Export-Service

Share This