Looker Studio: Sorting Rows, Columns and Axis in any Order You Want – Without Altering the Main Data Source

This tutorial explores methods for custom sorting rows, columns, and axes in Looker Studio when direct access to the data source is unavailable. Initially, a previous tutorial demonstrated sorting by adding new columns to the data source. However, for users without data source access, this tutorial offers two alternative approaches: blending data with a separate…

Read More

Data Mapping and Enrichment in Looker Studio using Blend or Calculated Fields

This tutorial focuses on data mapping and enrichment in Looker Studio, building upon a previous tutorial that created a student data analysis dashboard. The previous dashboard displayed gender as numerical values (1 and 2) instead of descriptive terms (male and female), and parental support as numbers (1, 2, and 3) instead of “low,” “medium,” and…

Read More

Looker Studio: Creating Responsive Reports in Looker Studio using Responsive Layout

This tutorial introduces how to create a responsive dashboard in Google Looker Studio, a feature that allows dashboards to automatically adjust to various screen sizes like mobiles, tablets, and computers. This eliminates the need to design separate reports for different devices. The process begins by creating a new Looker Report, connecting a CSV file as…

Read More

Looker Studio: Building a Comprehensive Multi-Page Organizational Performance Dashboard

This video tutorial demonstrates how to create a multi-page report in Looker Studio, focusing on organizational performance. It covers data preparation, including unpivoting data in Excel and importing it into Google Sheets. The tutorial then guides viewers through creating a cover page, adding various charts and visuals, utilizing advanced filters and formatting, and applying themes…

Read More

Dashboard with Relational Database in Looker Studio Data Blending and Modeling

This Looker Studio tutorial creates a data model (blend) from a sample Atlas Furniture dataset with multiple tables in Google Drive. It covers how to add data sources (tables), create relationships between them, manage data sources, and edit blends. It also demonstrates how to add calculated fields and handle limitations when working with many tables….

Read More

Setting up Public mySQL Server on your PC, and connecting it to Looker Reports

Welcome to our Looker Studio tutorial! In this tutorial, we’ll guide you through the process of setting up a XAMPP server, connecting MySQL to Workbench, creating tables and entering data, connecting MySQL to Looker Studio, and hosting Looker Studio reports on your XAMPP server’s web page. 🔹 Download Workbench:Get started by downloading Workbench here.Follow the…

Read More