How To Visualize Data Instantly With Google Sheets Explore

Excel Spreadsheet Diagram

Working with big datasets is never an easy task. Tons of spreadsheet data divided into rows and columns can be frustrating and stressful so anything to boost our productivity is more than welcome. And this is where companies like Google step in.

From time to time, Google releases a new update, becoming smarter and more practical than before. This happened just recently, when Google released an update for its spreadsheet application, Sheets, making it possible to visualize spreadsheet data even more easily than before.

If you haven’t explored this updated feature yet, here’s a closer look at how and why you should, especially if you work with data.

Continue reading →

6 Online Dashboards To Present Your Google Sheets Data

Excel Spreadsheet Diagram

When it’s more and more common for teams to collaborate around data in Google Sheets, you’ll find yourself needing a way to work with and access that data whenever you need to–not whenever your data analyst gets a chance.

But the problem is that if you aren’t too savvy with MS Excel, putting together your own dashboard for your Google Sheets data is  downright overwhelming.  It can be a steep learning curve you neither have the time nor the patience for.  

As businesses are analyzing data that’s more complex than ever before, vendors specializing in data and business intelligence tools are offering out-of-the-box, online tools to make it easier.

These type of online dashboards can be the perfect solution. They let you get the same professional data visualization and analysis without all the technicalities.

The following 6 dashboard tools, for instance, have simple to use interfaces, features and data connection widgets that can integrate your Google Sheets data. Check them out.

1. Geckoboard

Geckoboard starts our list with its free account option. Powerful enough for Salesforce data and simple enough to use with Google sheets data.  You can set it up as you would upload a file. It’s just a matter of creating a connection to your Google account or linking to the file via URL as a data source. You can find a good run down of Geckoboard’s spreadsheets integration on the site.

2.VizyDrop   

VizyDrop is a data visualization tool that can easily integrate your Google Sheets data. Features with this tool include chart sharing, a dashboard editor, updated data visualizations, the ability to work with custom sources, and built-in app connectors.

This tool is on the simplistic side, but it’s free to use. You can start dropping in your data in their demo space, but you’ll have to sign up to save your data.

3. Slemma

Slemma also makes things super easy for you with its built-in integration with Google Drive available for all types of accounts. This dashboard tool provides you with automatic update and scheduled report delivery features.

Other features include one-click integration, calculations, automated pivot tables, and email dashboards. And if you’re new to working with data and aren’t sure how to best visualize it, you can get some inspiration from the data visualizations and dashboards other Slemma members have done. There’s a free 14-day trial available to check out.

4. BIME Analytics

Connecting Data BIME AnalyticsSource:  BIME Analytics

You can connect a number of any data sources you have with BIME Analytics–including online cloud services like Google Drive.  BIME Analytics allows you to pull data from Google Sheets and cache datasets. There’s no storage; analysis is always live and direct.  You can test it out with a 10 day free trial from the site.

5. Cyfe

In addition to other integrations to third party services like Google Analytics, Cyfe can also integrate your Google Sheets data directly. You have the ability to archive data, export reports, and share your dashboards.  Its widgets will allow you to connect any of your data that’s on the web. You can sign up for free or go with the premium account for $19 /month.

6. Datahero

This tool touts itself as the “fastest and easiest way to understand your data”. DataHero is a data visualization tool that works with the data you already use in cloud storage services, or in files on your computer. 

Import your data from cloud services, create insightful charts and organize them in separate dashboards to get the most out of your data.  Once you sign up you get free trial access to their Premium service, which is a good starting point for exploring your dashboard needs. As a bonus, there is also a free account which will do just fine for visualizing your data on a lower scale.

 

Marrying business intelligence and Google Sheets data doesn’t have to be complicated or something you dread. On the contrary, it can be as simple as uploading your data online. See if any of the above are a good fit for your data needs.

7 Google Drive Tips To Make Online Research Easier

When you need to learn about something, the Internet is the number one resource to scout out.  And given the amount of information you can find online, no matter what area, industry, or topic you’re researching,  a huge chunk of your time will be spent recording the research you find.

As you can imagine, combined with the web pages you have to go through, this can slow you dow big time. That’s why some users like to keep their workflow online with tools like Google Drive.  But if you’re using Google Drive to quickly record data, then your biggest challenge lies in working between your research and how you use Google Drive itself.

If you’re writing for an online publication, are drafting a research paper, or are reporting on industry trends, accessing the information you record is perhaps one of your main priorities. To make things easier, try a few of the Google Drive tips below to keep your research going smoothly.

1.  Perform A Google Drive Search from Chrome

Because you can need a document at any given time, it’s important to be able to pull up the right file in an instant. Google Drive Quick Search makes it easy to start a search through your Drive directly from the Chrome URL address bar. Type “drive” in the address bar, your keywords and query, then hit enter. You’ll be directed to your drive with the related results ready and waiting for you to sift through.

2. Save Your Text to Google Drive

Save Text to Google Drive does exactly what its name implies. This Chrome extension makes it super easy to export heavily dense text webpage research from the web directly to your Google Drive.

Save text to Google Drive

Once installed, simply highlight the text you’re interested in, activate the extension by clicking on it in your toolbar or extension menu, and click on the Save button. The extension will create a document with the text in the Drive you’re logged into.

3. Quickly Access Folders and Create Google Docs From Your Toolbar

To access folders and separate files instantly, simply bookmark the URL of the file or document on your toolbar.  Open the file or folder in Google Drive and bookmark the URL you see in the address bar. Admittedly, this is a simple tip, but extremely handy if you like keeping things at your fingertips.

Creating Google Docs Instantly

 4. Search Your Google Drive Directly From Gmail

Don’t waste time going back and forth between your Google Drive and Gmail.  You can do both at the same time by adding the Apps Search for Gmail extension. This is handy for when you’re either exchanging emails regarding your research project or are working with colleagues.

It will let you extend your search to Google Docs to fish out the files you’re looking for.  You can add the extension by going into Settings>Labs from your Gmail.  Then select to enable it for your account. Don’t forget to hit the “Save Changes” button at the bottom.

5. Edit PDF Text Uploaded To Google Drive

Because a lot of research comes in the PDF format, you may want to pay attention to the “Convert Text from Uploaded PDF and image files” setting. Have you been ignoring it? Well, it’s time to start paying attention to it. This setting allows you to convert PDF to text which you can then  edit within a Google Doc.

Convert text from PDF

Go to the gear icon Google Drive and access the drop down menu. Then go to Upload Settings. From there, put a check mark in the “Convert Text from Uploaded PDF and image files”  option by clicking on it.  Select the Document language. You can have this permanently turned on, but if you want to use it selectively, keep the “Confirm settings before each upload” option checked.

6.  Save Images Directly to Google Drive

Who doesn’t clip web pages when researching online? Good news is you can do it with Google Drive. Save to Google Drive can serve as a simple web clipping tool, allowing you to instantly save content from the web to a Google Drive folder. Once you have it installed,  go to the page you’re interested in and activate it by clicking on its button to the right of the address bar.  It will then save your content in .PNG format.

7. Access Google Drive And Other Google Services From Chrome

Here’s a great Chrome extension for pushing your research productivity to the limits. Black Menu for Google allows you to access files on your Drive and to your other Google services in a side bar right within Chrome.

Perfect for Google addicts with research spread across different services. You can get the Black Menu extension from the Chrome Web Store.

Got any Google Drive tips of your own? We’d love to hear them! Add them in the comments below and let us know how they helped you deal with your web research.