Looker Studio helps you rework knowledge into a picture. As a free, browser-based instrument, all it’s essential to use Looker Studio is a Google account, a knowledge supply and the need to create a knowledge visualization.
Bounce to:
What’s Looker Studio?
Looker Studio is a robust free knowledge visualization instrument that simplifies the method of making interactive charts and dashboards with knowledge from lots of of related sources. Prospects who want further enterprise administration and collaboration options would possibly improve to Looker Studio Professional, which is offered as a paid service.
Looker Studio and Looker Studio Professional are Google’s entries within the knowledge visualization market that features rivals corresponding to Tableau from Salesforce and Energy BI from Microsoft.
What occurred to Google Information Studio?
Looker Studio is the brand new title for what was referred to as Google Information Studio. In October 2022, Google rebranded its numerous enterprise intelligence choices with the Looker title. Google acquired Information Studio in 2020.
Looker Studio has almost all the capabilities as Google Information Studio. The product stays free to make use of and represents a rebranding by Google.
What are you able to do with Looker Studio?
Looker Studio can deal with large portions of information and produce compelling charts, however a well-crafted chart requires each correct knowledge and an acceptable chart sort. Inaccurate knowledge received’t produce a chart that reveals the reality regardless of the way you show it. And good knowledge put right into a poorly chosen chart sort can confuse individuals.
SEE: Benefit from this huge knowledge coverage from TechRepublic Premium.
For most individuals, an image conveys which means in a approach that uncooked knowledge doesn’t. In a enterprise, for instance, you would possibly use it to research gross sales, prices or survey knowledge. An internet site supervisor would possibly use Looker Studio to assist perceive web site customer habits, buy patterns or advert efficiency. A social media supervisor may use Looker Studio to indicate attain, engagement or conversions.
With dependable knowledge displayed in a significant chart, Looker Studio takes issues additional and presents interactive controls in addition to a number of distinct share strategies. Controls let individuals change numerous chart content material, so a viewer would possibly filter out sure fields or slim the chart to show knowledge in a specific date vary. Not solely are you able to collaborate on Looker Studio experiences, a lot as you would possibly collaborate in a Google Sheet, however you can too schedule experiences to be repeatedly emailed to individuals.
The right way to get began with Looker Studio
To get began with Looker Studio, open https://lookerstudio.google.com in your browser. Then, observe the method beneath to attach a knowledge supply, create a chart, refine the show, optionally add interactive management after which share your report.
1. Connect with knowledge
First, you want knowledge. In Looker Studio, when you choose Create | Report, the system prompts you to pick out a knowledge supply (Determine A). Chances are you’ll select so as to add knowledge with any of the greater than 20 Google-provided Connectors, which embrace sources corresponding to Google Analytics, Google Sheets, BigQuery, YouTube Analytics, Tables by Space 120, Microsoft SQL Server, MySQL and a .csv file you add.
Determine A
You may also choose any of the greater than 630 Accomplice Connectors so as to add knowledge sources that vary from app, promoting, social media and web site analytics to accounting, buyer relationship administration, actual property and time monitoring. After you select a connector, you might must register to the supply then choose the particular dataset you want.
Whichever knowledge supply you select, ensure that the underlying knowledge is as dependable as potential. For instance, if you join a Google Sheet that incorporates knowledge, you would possibly assessment not less than a number of screens of information fields to grasp the vary of information in numerous fields. For numeric knowledge, you would possibly type a column to assessment the high and low numbers to establish knowledge that is likely to be out-of-range and should have to be reviewed after which adjusted or discarded. Dependable knowledge is required as a way to create an correct chart.
2. Select a chart sort
Subsequent, choose a chart sort to show the information. The greater than 35 sorts embrace tables, time collection, bar, column, line, space, pie, donut, scatter, bubble, pivot tables, scorecard, treemap, gauge and maps (Determine B). After you choose a chart sort, you might drag and drop knowledge fields from the appropriate aspect of the display screen to the realm beneath the chart title, then customise and configure choices and sliders as desired.
Determine B
Take into account the information and the message you want to convey when you choose a chart sort. Does the chart sort emphasize your intent with out rationalization? If an individual unfamiliar along with your intent views the chart, will they perceive your intent? Don’t attempt to make a chart accomplish a number of messages. As an alternative, attempt to convey a single idea with a chart — and convey it with the best chart potential.
3. Refine the show
Whereas Looker Studio presents a extremely usable set of themes and default design selections, in lots of instances a number of refinements would possibly assist reinforce each the content material and intent of your chart. Along with labels and chart grid strains, you might add a picture, textual content, strains or shapes and alter the chart fonts, textual content colours, background and borders.
As you alter gadgets, you would possibly make modifications that reinforce understanding of the information. For instance, within the chart that shows each most and minimal temperatures, I modified the road colours to pink and blue respectively (Determine C). These seek advice from the frequent cultural affiliation within the U.S. of the colour pink with sizzling and the colour blue with chilly.
Determine C
4. Add controls
Looker Studio permits you to place controls, which permit individuals who entry your web page to regulate settings. This provides an interactive component that helps individuals filter and experiment with numerous settings, which, one would possibly hope will result in higher understanding of the information and chart content material.
Out there controls embrace a dropdown checklist, slider, checkbox and date vary (Determine D). Every of those could also be positioned wherever on the web page, however ensure that your placement of a management doesn’t obscure your chart. Keep in mind, when picks change, numerous chart parts will change.
Determine D
5. Share with others
Simply as you might collaborate with individuals on a Google Docs doc, you might add individuals to collaborate on Looker Studio charts (Determine E). Choose File | Share, then add e mail addresses and select whether or not to present individuals Viewer or Editor entry.
Determine E
The File menu additionally presents choices to obtain a report or acquire an embed code, which helps you to embed Looker Studio charts elsewhere on the internet, corresponding to on a Google Website.
What’s your expertise with Looker Studio?
For those who use Looker Studio, what chart sorts do you employ most frequently? What knowledge do your Looker Studio experiences depict? For those who embrace controls, what varieties of filters or changes do individuals who work together along with your charts discover most useful? Have you ever tried utilizing Looker Studio to ship scheduled experiences to individuals by way of e mail? Point out or message me on Twitter (@awolber) to let me understand how you employ Looker Studio.
