Actionable Dashboards with Looker Studio + Connector Creation
Kirwyn B
Contact for pricing
About this service
Summary
Are you tired of dashboards that are an overwhelming wall of numbers that either make it difficult to get the information you need or don't have the information at all? No Looker Studio Connector in the Connector Gallery for Data Source you need for your dashboard?
This project is specifically to create Actionable Looker Studio Dashboards for a service that does not yet have a connector available in the Connector Gallery.
I focus understanding the most important questions you need answered and creating dashboards that answers the questions, giving the insights you need to take action.
Process
🧭 Planning
Clarity on the Business Results you want to achieve
Clarity on how the results will be achieved. Generally, user behaviour
Define what information (user behaviour) needs to be measured to determine if on track
Define what action must be taken for values or range of values of what is measured. This is how actionable insights are achieved!
🤠 Data Wrangling
Looker Studio Connector creation
BigQuery
Google Sheets
📈 Looker Studio Dashboard
Actionable Dashboards creation based on your needs.
Enable data driven decision making.
Data Blending.
Standard Dashboards for situations where the layout remains the same but each user must see their own data, such as in a portal.
Looker Studio Connector creation, see examples at the bottom.
🧐 Knowledge Transfer
Knowledge transfer is a major element of my approach, and I use video recordings extensively to achieve this with video chat and documentation as needed.
How to use the interactive elements of Looker Studio to investigate.
What to pay attention to first and what to pay attention to next.
🔌 Looker Studio Connectors Created:
BeeHiiv
CCV Shop
Chargebee
Cin7 Omni
Cin7 Core
Constant Contact
Harvest
HubSpot
Mailchimp
Niceboard
Pipedrive
Podio
Salesforce
SQR
Thinkific
Timetastic
Toggl
WooCommerce
Xandr
Xero
... many more
What's included
🔌 Looker Studio Connector
Looker Studio Connector created for a Data Set that is not yet available in the Connector Gallery. The Data Set must have an API (REST or GraphQL).
🧭 Measurement Plan
I collaborate with you to get clarity on your business goals and what is needed to achieve them. Those outcomes are then used define what data is needed, Key Performance Indicators (KPIs) and what actions to take given certain values of KPIs and metrics.
🤠 Data Wrangling & Looker Studio Connectors
Determine which available connectors are most suitable. If connectors are not available, then depending on what is best for you situation, connectors can be created are the data automated into BigQuery, Google Sheets, etc.
📈 Actionable Looker Studio Dashboard
Looker studio dashboard created focused on answering the questions defined in planning and structured so in terms of what to look at first, then what to look at next.
🧐 Training
Custom videos created on how to use the dashboard with live training as needed.
Skills and tools
Work with me