Biju Patnaik Institute of Information Technology & Management Studies

Course Overview
This course provides an in-depth exploration of Looker Studio, a powerful data visualization tool used in
business intelligence and analytics. Through a combination of theoretical insights and hands-on activities,
students will learn to effectively connect data sources, create dynamic reports and dashboards, and apply
advanced visualization techniques. The course emphasizes collaboration and storytelling, equipping students
with the skills needed to present data-driven insights compellingly.

I look forward to a successful semester with you!

Biju Patnaik Institute of Information Technology & Management Studies

Lesson Plan (Data Visualization with Looker Studio)

COURSE INSTRUCTOR : Mr. Amiya Ranjan Das
COURSE NAME : MBA and MBA (Business Administration)
SUBJECT : Data Visualization with Looker Studio

Course Objectives
By the end of this course, participants will be able to:
1. Understand the fundamental features and applications of Looker Studio.
2. Connect various data sources to Looker Studio for effective data integration.
3. Create and customize reports and dashboards to visualize key business metrics.
4. Utilize collaboration features to share reports and gather feedback.
5. Apply advanced visualization techniques to enhance data representation.
6. Present data insights clearly and effectively, utilizing best practices for storytelling with data.
Course Outcomes
Upon successful completion of this course, students will:
• Demonstrate proficiency in using Looker Studio for data visualization.
• Effectively integrate and manipulate data from multiple sources.
 • Create insightful and visually appealing reports and dashboards.
• Collaborate with peers to refine data presentations and share insights.
• Implement advanced visualization techniques to provide deeper analysis.
• Communicate data findings effectively, tailoring presentations for diverse audiences.

Overview of Each Class

Lesson Plan for Looker Studio
Class Topics Activities Assignment Course
Outcome
Class 1: Introduction to Looker Discuss how businesses Research the importance
Overview of Studio, its features, and use data visualization of data visualization tools
Looker Studio real-world applications. tools to make informed in business.
decisions.
Class 2: How to connect various Hands-on practice Create a simple report
Connecting Data data sources to Looker connecting Google Sheets using the connected data
Sources Studio. and other data sources. source.
Class 3: Creating Building and Practical session on Submit a dashboard that
Reports and customizing reports and creating visualizations showcases key business
Dashboards dashboards. using different chart metrics.
types.
Class 4: Sharing reports and Hands-on session on Share your report with
Collaboration collaboration features setting permissions and classmates for feedback.
and sharing sharing reports with
others.
Class 5: Exploring advanced Apply advanced Improve your dashboard
Advanced techniques such as visualization techniques to with advanced
Visualization calculated fields and enhance existing reports. visualizations.
Techniques custom charts.
Class 6: Best practices for Prepare and practice Present your report,
Presentation presenting data insights. presenting your report to explaining key insights
and Storytelling the class. and findings.
with Data
Class 1: Overview of Looker Studio
Introduction to Looker Studio
Looker Studio (formerly known as Google Data Studio) is a powerful data visualization and business
intelligence tool that enables users to create interactive and shareable reports. It allows you to
connect to various data sources, transform raw data into meaningful insights, and present them
visually through customizable dashboards and reports.

Key Features of Looker Studio

1. Data Connectivity: Integrates seamlessly with a variety of data sources, including Google
Sheets, Google Analytics, BigQuery, and third-party applications.
2. Customizable Reports: Users can create tailored dashboards that reflect their specific data
needs.
3. Collaboration Tools: Easily share reports and collaborate in real-time with team members.
4. Interactive Elements: Incorporate filters, date ranges, and clickable charts to enhance user
engagement.
5. Templates and Community Resources: Access to a library of templates and community-
contributed resources to kickstart report creation.
Real-World Applications
• Marketing Analytics: Track campaign performance through visualized data, enabling
marketers to make quick adjustments based on real-time feedback.
• Sales Performance: Visualize sales data to identify trends, forecast future performance, and
inform strategic decisions.
• Financial Reporting: Create financial dashboards to monitor expenses, revenues, and cash
flow in a visually compelling manner.
• Customer Insights: Analyze customer behavior and feedback through data visualization to
improve service and product offerings.

Importance of Data Visualization Tools in Business

1. Enhanced Understanding: Visualizations simplify complex data, making it easier for
stakeholders to grasp insights quickly.
2. Informed Decision-Making: Businesses can leverage visual data to identify trends, patterns,
and anomalies, leading to better strategic decisions.
3. Time Efficiency: Visual reports allow for faster analysis, saving time for decision-makers.
4. Communication of Insights: Well-designed visuals help convey important information clearly
to various audiences, from executives to operational teams.
5. Increased Engagement: Interactive dashboards encourage users to explore data on their
own, fostering a data-driven culture within the organization.

Conclusion
In this class, we explored the fundamental aspects of Looker Studio, its features, and how it can be
applied in real-world business scenarios. Understanding the importance of data visualization tools is
essential for businesses aiming to leverage data for competitive advantage. As we proceed, we will
explore deeper into creating effective visualizations and reports using Looker Studio.

Class 2: Connecting Data Sources in Looker Studio

Overview: In this class, we will focus on how to connect various data sources to Looker Studio, with a
particular emphasis on Google Sheets and other commonly used data sources. We will also engage in
hands-on practice to create a simple report using the connected data.

Connecting Data Sources

1. Understanding Data Sources: Looker Studio can connect to numerous data sources, including:
Google Sheets, Google Analytics, Google Ads, BigQuery, SQL databases, CSV files, Other third-party
connectors
2. Connecting Google Sheets:
• Open Looker Studio and click on “Create” in the top left corner.
• Select “Data Source” from the dropdown menu.
• In the connector list, choose “Google Sheets.”
• Authorize Looker Studio to access your Google account if prompted.
• Select the desired Google Sheet from your Drive.
 • Choose the specific worksheet you want to connect.
• Click “Connect” to establish the link.
3. Connecting Other Data Sources: Similar steps apply for connecting other sources like Google
Analytics:
• Choose “Google Analytics” from the connector list.
• Authorize access and select the desired account and view.
• Click “Connect” to establish the link.

Hands-On Practice
1. Connect Google Sheets:
• Use a sample Google Sheet with sales data (or create your own).
• Follow the connection steps outlined above to link the sheet to Looker Studio.
2. Connect Another Data Source:
• Choose another data source (e.g., Google Analytics or Google Ads).
• Follow the same connection process to establish a link.

Creating a Simple Report

1. Building a Report:
• After connecting your data sources, click on “Create Report.”
• Select your connected data sources to include in the report.
• Click “Add to Report” to start designing your dashboard.
2. Adding Visual Elements:
• Charts: Add a time series chart to visualize sales trends over time.
o Drag and drop a time series chart onto your report.
o Set the date range and metrics (e.g., sales amount).
• Tables: Include a table to show detailed sales data by category.
o Drag and drop a table and configure dimensions (e.g., product name) and metrics
(e.g., sales).
3. Customizing Your Report:
• Change colors, fonts, and layout to match your branding or preferences.
• Add filters for interactivity (e.g., filter by product category or date).
4. Sharing Your Report:
• Click on the “Share” button in the top right corner to generate a shareable link.
• Set permissions as needed (view or edit access).

Sample Google Sheets Data: Sales Data

Date Product Name Category Quantity Sold Revenue

2024-01-01 Widget A Widgets 100 1000
2024-01-01 Widget B Widgets 150 1500
2024-01-02 Gadget A Gadgets 200 3000
2024-01-02 Gadget B Gadgets 120 2400
2024-01-03 Widget A Widgets 80 800
2024-01-03 Gadget A Gadgets 300 4500
2024-01-04 Widget C Widgets 50 500
2024-01-04 Gadget B Gadgets 100 2000
2024-01-05 Widget B Widgets 130 1300
2024-01-05 Gadget A Gadgets 90 1350

Visualizations to Create
• Time Series Chart: Visualize "Revenue" over "Date".
• Bar Chart: Show "Quantity Sold" by "Product Name".
• Pie Chart: Display the share of "Revenue" by "Category".

Class 3: Creating Reports and Dashboards in Looker Studio

Overview: In this class, we will focus on building and customizing reports and dashboards in Looker
Studio. You will learn how to create various visualizations using different chart types and ultimately
submit a dashboard that showcases key business metrics.

Building and Customizing Reports

1. Creating a New Report:
• Open Looker Studio and click on “Create” > “Report.”
• Select the connected data source (e.g., your "Sales Data" sheet).
• Click “Add to Report” to start your dashboard.
2. Report Layout:
• Decide on a layout for your dashboard (grid, single-column, etc.).
• Use the "Page" settings to adjust the size and orientation (e.g., landscape).
3. Adding Visualizations:
• Use the “Add a Chart” option to include various chart types:
o Time Series Chart: To show revenue trends over time.
o Bar Chart: To compare quantities sold by product.
o Pie Chart: To illustrate revenue distribution by category.
4. Customizing Charts:
• Click on the chart to open the properties panel.
• Adjust the following:
o Data: Choose dimensions and metrics.
o Style: Change colors, fonts, and labels to match your branding.
o Filters: Add filters for interactivity (e.g., by date range or product category).
5. Adding Text and Images:
• Use the “Text” tool to add titles, descriptions, or insights.
• Insert images (like your company logo) for branding.

Practical Session: Creating Visualizations

1. Create a Time Series Chart:
• Drag a time series chart onto your report.
• Set the “Dimension” to "Date" and the “Metric” to "Revenue".
• Customize the date range and appearance.
2. Create a Bar Chart:
• Drag a bar chart onto your report.
• Set “Dimension” to "Product Name" and “Metric” to "Quantity Sold".
• Style the chart with appropriate colors.
3. Create a Pie Chart:
• Drag a pie chart onto your report.
• Set the “Dimension” to "Category" and the “Metric” to "Revenue".
• Adjust the colors for each category.
4. Add Filters:
• Include a date filter to allow users to view data for specific time periods.
• Add a category filter to enable filtering by product category.

Submission: Key Business Metrics Dashboard

1. Finalizing Your Dashboard:
• Review your dashboard for clarity and design.
• Ensure all visualizations effectively communicate insights.
• Save your report.

2. Sharing Your Dashboard:

• Click on the “Share” button to generate a shareable link.
• Set permissions as needed (view or edit access).

3. Submission Guidelines:
• Submit the link to your dashboard along with a brief description of the key metrics
showcased.
• Highlight any insights you’ve derived from the visualizations.
Introduction to Google Apps Script- Google for Developers
Class Topics Activities Assignment
1 Overview of • Introduction to Google Apps
Google Apps Script Script and its uses.
• Discuss use cases (Gmail
automation, Google Sheets
functions, etc.).
2 Setting Up Google • Guide students to access Apps Set up Google Apps Script
Apps Script Script via Google Workspace. environment.
• Create a simple script from a
Google Sheet.
3 Basic Scripting • Introduce JavaScript basics Write a basic script that logs
Concepts (variables, functions, etc.). "Hello, World!".
• Explain Apps Script syntax and
structure.
4 Interacting with • Demonstrate how to interact Create a script that reads
Google Services with Google Sheets, Docs, and data from a Google Sheet.
Gmail.
5 Triggers and • Explain simple and installable Create a time-based trigger
 Automation triggers. for a logging script.
• Set up a time-based trigger for a
script.
6 Building a Simple • Introduction to HTML and Apps Build a web app that collects
Web App Script Web Apps. user input and stores it in a
• Create a simple web form and Sheet.
handle submissions.
7 Debugging and • Discuss debugging techniques Refactor previous scripts for
Best Practices and tools. readability and efficiency.
• Share best practices for writing
clean code.
8 Q&A and Wrap-Up • Open floor for questions.
• Summarize key takeaways.

Introduction to BigQuery Sandbox

Class Topics Activities Assignment
1 Introduction to • Overview of BigQuery and its use
BigQuery cases.
• Discuss BigQuery Sandbox
limitations and benefits.
2 Setting Up • Step-by-step setup of Google
BigQuery Sandbox Cloud Console.
• Create a project and navigate
BigQuery UI.
3 Understanding • Explain datasets and tables in Explore datasets in
Datasets and BigQuery. BigQuery and summarize
Tables • Introduce sample datasets. findings.
4 Introduction to • Teach basic SQL commands Write and execute queries
SQL in BigQuery (SELECT, FROM, WHERE, etc.). on sample datasets.
• Write and execute simple queries
5 Advanced • Explain JOINs and subqueries. Create a query using JOINs
Querying • Perform JOIN operations on and share results.
Techniques related datasets.
6 Visualization and • Overview of Google Data Studio Visualize query results in
Exporting Data for visualization. Google Data Studio.
• Demonstrate exporting query
results as CSV.
7 Q&A and Wrap-Up • Open floor for questions.
• Summarize key takeaways.