fbpx

Looker Studio for Real-Time Financial Insights

Unlock Deeper Financial Insights with Live Data Dashboards

  • Duration

    15 Hours

  • Schedule

    2 – 4 December 2025
    09.00 – 15.00 WIB

  • Jl. H. R. Rasuna Said No.Kav.20, Karet Kuningan, Kecamatan Setiabudi, Jakarta Selatan 12940

  • Investment

    Rp. 5.550.000

WORKSHOP STARTS IN

0Weeks0Days0Hours0Minutes0Seconds

Overview

This 15-hour training equips participants with practical skills to build rich, interactive dashboards using live financial data. Using datasets retrieved from Sectors App via Google Sheets, the course covers connecting and transforming financial data, visualizing key performance indicators, building trend reports, and designing intuitive dashboard experiences. Participants will learn how to make raw financial data understandable and actionable for a wide range of business users. No prior experience with Looker Studio is required.

Course Syllabus

  • Overview of Looker Studio for financial analysis
  • Key terminology and interface navigation
  • Use cases in finance: market trends, KPI tracking, sector performance
  • Understanding Looker Studio workflow
  • Components: Reports, Data Sources, Explorer
  • Project setup for finance use cases
  • Overview of Sectors API structure
  • Pulling financial data into Google Sheets
  • Scheduling data refresh
  • Cleaning and transforming Sectors data in Sheets
  • Creating time-based tables for trend reporting
  • Structuring data blends
  • Connecting Sheets to Looker Studio
  • Field configuration and custom metrics
  • Creating relationships and joins for multi-source reporting
  • Bar, line, combo charts for index and stock movement
  • Scorecards and tables for KPI monitoring
  • Customizing visual options: color coding by performance
  • Best practices for visualizing trends and outliers
  • Creating time filters and dropdowns for sector, ticker, or exchange
  • Using parameters for dynamic metric switching
  • Drill-down dashboards and navigation strategies
  • Creating financial ratios (Return %, MoM Change)
  • Conditional formatting and alert-based logic
  • Building variance and delta charts
  • Designing finance-focused dashboard layouts
  • Creating thematic sections (Market Overview, Sector Movement)
  • Optimizing performance and report usability
  • Sharing dashboards with stakeholders
  • Managing access control and viewer-level filtering
  • Embedding reports in internal portals or websites

Course Receivables

  • Lecturer’s Notes

    Including Course Books (PDF), HTML files, course transcripts (if any).

  • Highly-accelerated Learning

    Learn under the assistance of mentorship of our lead instructor and a band of qualified teaching assistants throughout each course.

  • Certification of Completion

    Show current employer hat you’ve completed the course with a signed certificate of completion.

  • Quality Learning Environment

    We pay meticulous attention to the logistical details of our workshops: quality audio and visual setups, comfortable sitting arrangements, and small group size.

  • Refreshments & Coffee Break

    In our commitment to delivering a premium experience, we collaborate with leading catering services in Jakarta. Our aim is to ensure that all participants are served delectable lunches and revitalizing coffee breaks.

ABOUT THIS SERIES

Courses in this series cater to a diverse audience: from casual learners and working professionals to those venturing into data science and machine learning without a programming background.

We recognize that many students may not have prior expertise in statistics, mathematics, or algebra. Therefore, our courses are designed with a gentle learning curve, placing a strong emphasis on hands-on experience and individualized instruction. Our dedicated team of instructors and teaching assistants ensure personalized guidance every step of the way.

Teaching Methodology

Students work through tons of real-life examples using sample datasets donated by our mentors and corporate partners. We believe in a learn-by-building approach, and we employ instructors who are uncompromisingly passionate about your growth and education.

YOUR INSTRUCTOR

Muhammad Dzaky Jayalaksono
Business Intelligence Instructor at Algoritma Data Science School

Dzaky has a strong understanding and proficiency in platforms for business analytics, enabling valuable insights for data-driven decision-making. As a detail-oriented professional, He possesses the technical thinking skills to identify innovative solutions for business problems and is deeply committed to the company’s advancement. Orchestrating the end-to-end business intelligence process from defining the business problem to conducting thorough analysis, visualizing insights, and deploying impactful dashboards. Bring a comprehensive skill set to drive the entire lifecycle of business intelligence. He is motivated to continuously learn and grow, keep collaborating, and provide exceptional abilities to drive success.