How to Set Up Looker

How to Set Up Looker: A Step-by-Step Guide

Looker is a powerful BI tool that requires careful configuration to connect with your data sources, model data effectively, and provide analytics to your team. Follow this step-by-step guide to set up Looker successfully.

Step 1: Sign Up for Looker and Access the Admin Panel

1. Go to Looker’s website and sign up for an account.
2. Log in and navigate to the Looker Admin Panel by clicking your profile icon in the top right and selecting Admin.
3. In the Admin panel, you’ll see sections for database connections, user roles, authentication settings, and system activity logs.

Step 2: Connect Looker to Your Database

Looker does not store data; it queries your database directly. You’ll need to set up a database connection.

Supported Databases:

• Cloud-Based: Google BigQuery, Snowflake, Amazon Redshift
• On-Premise: MySQL, PostgreSQL, Microsoft SQL Server

How to Connect Your Database:

1. Navigate to Admin > Database Connections
2. Click "Add Connection"
3. Enter the following credentials:
   • Connection Name: A recognizable name for your database
   • Database Type: Select from the list (e.g., BigQuery, Snowflake, PostgreSQL)
   • Host and Port: The address and port of your database
   • Username & Password: Your database credentials
   • Schema: The schema(s) containing the tables you want to use
4. Click Test These Settings to ensure the connection is successful.
5. Click Add Connection to finalize the setup.

Step 3: Configure User Access and Permissions

To ensure proper data governance, configure user roles and permissions in Looker.

How to Set Up User Roles:

1. Navigate to Admin > Users
2. Click “Add User” and enter the email addresses of your team members.
3. Assign Roles & Permissions based on their needs:
   • Admin: Full access to manage users, connections, and LookML
   • Developer: Can edit LookML models but cannot manage user access
   • Viewer: Can view dashboards but cannot edit reports
4. Click Save Changes to apply permissions.

Step 4: Define Data Models in LookML

LookML is Looker’s modeling language that defines how data should be structured for users to query.

How to Create a LookML Model:

1. Navigate to Develop > Manage Projects
2. Click New LookML Project
3. Choose Generate Model from Database Schema (this automatically detects tables)
4. Open the .model file to define relationships and joins
5. Open the .view file to define dimensions and measures

💡 Example LookML Snippet:

view: orders {
 dimension: order_id {
   type: number
   primary_key: yes
 }
 
 dimension: order_date {
   type: date
 }

 measure: total_revenue {
   type: sum
   sql: ${order_amount} ;;
 }
}


6. Click Validate LookML to check for errors.
7. Click Deploy Changes to push updates.

Step 5: Create Dashboards and Visualizations

Now that your data is connected and modeled, you can create dashboards.

How to Build a Dashboard:

1. Navigate to Explore and select a dataset.
2. Choose Dimensions & Measures to analyze.
3. Click Run to generate a query.
4. Click Visualization and select a chart type (bar, line, pie, etc.).
5. Click Save > Save to Dashboard to store the visualization.
6. Create multiple tiles to build a complete dashboard.
7. Click Share to send the dashboard to your team.

Step 6: Schedule Reports and Set Up Alerts

Looker allows you to automate reports and receive alerts when data meets specific conditions.

How to Schedule a Report:

1. Open a dashboard or Look.
2. Click Schedule (clock icon).
3. Select Frequency (hourly, daily, weekly).
4. Choose the delivery method (email, Slack, webhook).
5. Click Save.

How to Set Up Alerts:

1. Click the bell icon on any visualization.
2. Set a condition (e.g., revenue falls below $10K).
3. Choose notification recipients.
4. Click Save Alert.

Step 7: Embed Looker in Your Applications (Optional)

If you want to integrate Looker’s analytics into an external website or application, you can use Looker Embed.

How to Embed a Looker Dashboard:

1. Open a dashboard.
2. Click Share > Embed Dashboard.
3. Copy the iFrame or API link.
4. Paste it into your web application.

Final Checks Before Deployment

✅ Ensure your database connection is secure
✅ Test LookML models to avoid query errors
✅ Assign user roles and permissions properly
✅ Validate dashboards and reports for accuracy
✅ Automate scheduled reports and alerts

🎯 Your Looker environment is now set up and ready to deliver actionable insights! 🚀

‍