Financial Analytics in Google Sheets, Looker BI & Microsoft Excel

Workshop Details
Brought to you by the analytics engineers and founding team of Sectors, Indonesia's financial data suite.
Language
English
Date
20th December, 2024
Time
1800 to 2100 (GMT+7)
Medium
Zoom Conferencing (Online)
Bundled Learning Experience
Beginner-friendly, hands-on introduction to financial analytics using Google Sheets and Looker. Explore a low-code approach to developing interactive financial dashboards with live financial data, perfect for non-coders and anyone interested in the financial market.
During the workshop, your instructor will guide you through the process of designing an interactive financial dashboard using Google Sheets and Looker. You will then learn how to create a low-code solution that visualizes live financial data, allowing you to generate insights, monitor investment performance, and make informed decisions.
Add $5 for Workshop + Practicum
For an extra $5, you can upgrade your participation to the Workshop + Practicum tier (optional). Here's the offer:
- $9 workshop admission included
- $98 worth of Sectors API subscription included
- $39 worth of Supertype Fellowship+ included (peer to peer learning group, mentorship, post-workshop implementation support)
After the workshop, all Practicum members are invited to join the Supertype Fellowship, where you can continue building your financial analytics dashboard, access live financial data, and collaborate with other community members using the free API credits provided to you. Whether you're new to working with live financial data, looking to enhance your financial analysis skills, or simply curious about creating interactive dashboards with a low-code approach, this workshop is designed for you.
Follow along the last 1 hour of the workshop as a Workshop + Practicum member to earn a certificate of completion. We issue this certificate of completion as proof of demonstrable proficiency, with a difficulty level suited for non-programmers. You will be asked to submit your dashboard, and a mentor will assess it and award a certificate as acknowledgment of your competency.
Your Instructors
Vincentius C. Calvin
Sectors Financial API Lead, Infrastructure Lead at Supertype
Having loved math for as long as I can remember, I have a deep passion for exploring data through AI to solve real-world challenges. I believe in lifelong learning — every experience offers a lesson, and I'm always eager to discover something new.
I'm currently Infrastructure Lead at Supertype, where I drive the implementation of MLOps across various industries, including mining and logistics and in financial services. Additionally, I lead the development of enterprise RAG systems to help organizations leverage AI for intelligent retrieval and knowledge management.
Aurellia Christie
Enterprise Consulting Lead at Supertype, Platform Development Lead at Sectors
I have a Bachelor Degree in Mathematics, and been with Supertype since 2020, building data-driven platforms and automation tools that empower businesses to make better decisions. My work spans software development, financial analytics, and AI applications, with a strong focus on usability and scalability.
I lead Enterprise Consulting at Supertype and also the Platform Development work on Sectors Financial Data Suite.
More about the Workshop
The Organizers
This low-code workshop is created and organized by Supertype, a data science and analytics consultancy based in Jakarta, Indonesia. Supertype is a team of data scientists, engineers, and analytics developers who are passionate about helping businesses make better decisions through data.
Supertype is the developer of Sectors, a financial analytics platform built for the Indonesian stock market.
This workshop is supported by Algoritma, a leader in data science and analytics education in Indonesia. Algoritma offers a wide range of courses in data science, analytics, and programming, and has trained thousands of professionals in the region.
Workshop Topic & Coverage
We dive deep into the essentials of financial analytics with Looker and Google Sheets, guiding you through every step: from connecting to live data sources, organizing and visualizing your data, to building interactive dashboards that highlight key financial metrics and trends. The instructor will walk you through real-world examples, demonstrating how to create these solutions with minimal coding, and you'll have the opportunity to follow along and build your own dashboard on your laptop.
Syllabus
Using Power Query in Excel
Overview of using Power Query for data extraction and transformation.
Scheduling API Runs with Triggers
Setting up triggers to automate API calls for continuous data updates.
Building a Financial Dashboard
Constructing a financial dashboard in Looker without writing any code, using live financial data from the Indonesian stock market.
Connecting Sectors API to Google Sheets
How to connect Sectors API using third-party extensions (no code) and Apps Script. Scheduling API Runs with Triggers Setting up triggers to automate API calls for continuous data updates.
Connecting Financial Data to Looker
Importing and integrating financial data from Sectors API into Looker.
Post-Workshop Learning Path
Continuing your journey in financial analytics with resources available through the Supertype Fellowship and Sectors API (valued at $137 combined).