Financial Analytics in Google Sheets, Looker BI, and Microsoft Excel
- Sectors, Indonesia’s API-first financial data platform
- Supertype, enterprise analytics experts and data science consultancy
- Algoritma, a data science education center
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.
- $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.
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.
Cost per Admission
- Workshop Admission: IDR150,000 or $9
- [Optional] Extra $5 for $146 worth of support and services
How
Online Video-Conferencing (Zoom)
When
1pm to 4pm (GMT+7 / Jakarta)
2pm to 5pm (GMT+8 / SG, KL)
21 September, 2024
Syllabus
Using Power Query in Excel
Overview of using Power Query for data extraction and transformation.
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.
Building a Financial Dashboard
Constructing a financial dashboard in Looker without writing any code, using live financial data from the Indonesian stock market.
Post-Workshop Learning Path
Continuing your journey in financial analytics with resources available through the Supertype Fellowship and Sectors API (valued at $137 combined).
Workshop Fee
One-time fee of $9 for workshop admission.
Add $5 for 3 months of Supertype Fellowship+ (retail US$39) and Supertype Sectors API (retail US$98) credits, an incredible value for those seeking for after-workshop coding support, mentorship, and peer-to-peer learning.
Workshop
For $9, get the full workshop experience and all coding materials.
- Full workshop admission
- All workshop materials, datasets, and custom scripts
Workshop + Practicum
For $14, get the full workshop experience, all coding materials, $137 worth of subscriptions and after-workshop support, hi-res video recording and certificate of completion
- Full workshop admission
- All workshop materials, datasets, and custom scripts
-
3 Months of Supertype Fellowship+ ($39) for peer-to-peer learning and mentorship included
https://fellowship.supertype.ai
-
3,000 credits of Sectors API ($98) for personal and commercial project included
https://sectors.app/pricing
- Video Recording (mp4, hi-resolution)
- Earn a certificate of completion by following the last hour of coding
Prefer local payment gateway?
We work with Mayar.id to process local transactions in Indonesia (support QRIS & bank transfer).
Your Instructors
Vincentius C. Calvin
Partner, Supertype & Lead, Sectors API Platform
A Partner at Supertype, where he leads critical projects across the company. His work includes managing key initiatives for Adaro groups, such as AMT's Real-Time Water Level Monitoring & Forecasting and SIS's Predictive Maintenance projects. He has also served as a consultant for major clients like IDX (Bursa Efek Indonesia) and Bank Indonesia.
Calvin specializes in Machine Learning Ops (MLOps), Backend Engineering, and API development. He is a certified TensorFlow Developer and has a strong passion for creating user-centric products, including apps published on the App Store. His expertise and leadership make him a valuable asset to the Supertype team.
Aurellia Christie
Partner, Supertype & Lead, Sectors Public
A Partner at Supertype, leading Platform Development at Supertype Sectors and Supertype Summary. With a B.Sc. in Mathematics, she brings a sharp analytical mind and a versatile skill set to her work. Aurellia has provided consultancy to major organizations such as the Indonesia Stock Exchange (IDX) and Bank Indonesia, where her expertise in Web App Development, Machine Learning, Analytics Engineering, and API Microservices has made a significant impact.
Aurellia is also an active contributor to the tech community, having spoken at R-Ladies and a few other workshops, where she shares her knowledge and experience in Data Science and Web App Development. Her approach combines technical depth with practical application, allowing her to make meaningful contributions in the field.
Workshop Fee
One-time fee of $9 for workshop admission.
Add $5 for 3 months of Supertype Fellowship+ (retail US$39) and Supertype Sectors API (retail US$98) credits, an incredible value for those seeking for after-workshop support, mentorship, and peer-to-peer learning.
Workshop
For $9, get the full workshop experience and all learning materials.
- Full workshop admission
- All workshop materials, datasets, and custom scripts
Workshop + Practicum
For $14, get the full workshop experience, all learning materials, $137 worth of subscriptions and after-workshop support, hi-res video recording and certificate of completion
- Full workshop admission
- All workshop materials, datasets, and custom scripts
-
3 Months of Supertype Fellowship+ ($39) for peer-to-peer learning and mentorship included
https://fellowship.supertype.ai
-
3,000 credits of Sectors API ($98) for personal and commercial project included
https://sectors.app/pricing
- Video Recording (mp4, hi-resolution)
- Earn a certificate of completion by submitting your dashboard.
Prefer local payment gateway?
We work with Mayar.id to process local transactions in Indonesia (support QRIS & bank transfer).
Frequently Asked Questions
Absolutely! This workshop is perfectly suited for beginners in data analytics and dashboard creation. Your trainers will assume little to no prior knowledge of programming and will guide you through the basics of connecting data sources, building dashboards, and financial analytics using Google Sheets and Looker.
Step-by-step instructions, sample datasets, and other resources will be provided to help you follow along, even if you’re new to working with financial data or building dashboards.
The workshop will be conducted in Bahasa Indonesia, with the trainers primarily speaking in Bahasa Indonesia.
However, all trainers are fluent in English and can provide support in English if needed. We aim to make the workshop accessible to a wide audience, and all post-workshop support in the Practicum will be provided in the language of your choice.
After purchasing a ticket, you will receive a confirmation email from the organizers with more details about the workshop, including the schedule, the meeting link, and other relevant information. As we approach the workshop date, you will also receive a link to download the workshop materials, including step-by-step guides and sample datasets, so you can follow along on your own laptop.
