We're bringing high-performance Search to  the new Supertype.ai (and more!)

Financial Analytics in Google Sheets, Looker BI & Microsoft Excel

Automated Financial Reports and Business Intelligence

Workshop Details

A low-code approach to developing an interactive financial dashboard using live financial data.
Brought to you by the analytics engineers and founding team of Sectors, Indonesia's financial data suite.
We've sold out and not accepting new registrations.

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.

Workshop Fee: $9

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.

Workshop + Practicum Bundle: $14

Your Instructors

calvin

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

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).

The latest in AI and Enterprise Analytics

We hate spam as much as you do. We do not resell your data.

Supertype Logo

Email us at human@supertype.ai for enquiries on enterprise analytics consulting, ai development, and consulting services.

Consulting & Services

Supertype | Industry-Leading AI Consultancy

By Industry

Other Supertype-Incubated Products

Information

Supertype Group of Companies