Automated Financial Reports and Business Intelligence
- 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 automating financial reports and creating dynamic business intelligence dashboards. Explore a low-code approach to integrating live financial data using Google Sheets and Looker Studio, designed for non-coders and professionals looking to streamline financial analysis and reporting.
During the workshop, your instructor will guide you through the process of automating financial reporting and designing a dynamic business intelligence dashboard using Google Sheets and Looker Studio. You will learn how to create a low-code solution that integrates live financial data, enabling you to uncover insights, track key financial metrics, and make data-driven decisions with ease.
- $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.
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
6pm to 9pm (GMT+7 / Jakarta)
7pm to 10pm (GMT+8 / SG, KL)
20 December, 2024
Syllabus
Google Sheets w/ Live Financial Data
Learn how to connect Google Sheets to financial APIs using Apps Script or third-party extensions. This hands-on session will demonstrate how to retrieve live financial data and prepare it for automated reporting and analysis.
Looker Studio w/ Data Ingestion
Discover how to integrate the Sectors API with Looker Studio to visualize financial data in real-time. This section will cover the setup process and best practices for managing live API connections.
Caching API Results in Looker Studio
Improve dashboard performance by implementing caching strategies for API data in Looker Studio. Learn how to optimize data refresh rates and minimize loading times for seamless user experiences.
Data Visualization in Looker Studio
Master the art of creating compelling financial visualizations using Looker Studio. Explore advanced charting techniques to highlight key financial metrics, trends, and performance insights.
Controls and Filtering Data in Looker Studio
Enhance the interactivity of your dashboards by adding filters, controls, and dynamic elements. Learn how to create user-friendly interfaces for exploring financial data across multiple dimensions.
Sharing Looker Reports
Discover how to share your Looker Studio reports with stakeholders securely. This session covers configuring access permissions, embedding reports, and collaborative features to enable data-driven decision-making across teams.
Your Instructors
Gerald Bryan
Partner, Supertype & Lead, Consulting Division
A Partner at Supertype, specializing in Data Science Consulting, Gerald Bryan brings a wealth of expertise and a results-driven approach to his projects. With a B.Sc. in Mathematics and certification as a Microsoft Data Analyst Associate, Gerald has become a sought-after consultant, collaborating with prominent organizations such as the Adaro Group of companies and Astra Toyota Motors. His work encompasses Machine Learning, Data Science, Web App Development, and Analytics Consulting, where he consistently delivers impactful and innovative solutions.
In 2022, Gerald was honored as a scholar at the prestigious Apple Developer Academy @Binus, highlighting his dedication and ingenuity in the tech space. Gerald is also deeply committed to advancing technology adoption and data-driven strategies, positioning himself as a key contributor and leader in his field.
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 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).
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.
