BI Solusi a Kitameraki company
// SNOWFLAKE

Snowflake consultants in Indonesia: one cloud data warehouse for every report.

We design and build Snowflake data warehouses: data pipelines from your ERP, CRM and files, data models for reporting, and dashboards in Power BI or Tableau on top. Our team in Jakarta has delivered Snowflake and dbt platforms for two pharmaceutical companies, in Jakarta and Singapore.

ERPCRMExcel filesDatabases & APIsSOURCESLoadSnowflakestorage · compute · SQLAnalyseDashboardsPower BI or Tableau
Snowflake logoSnowflakeData warehouse in the cloud, on AWS, Azure or Google Cloud
// WHAT IS SNOWFLAKE

A data warehouse that runs in the cloud.

Snowflake stores your company’s data in one place and lets every team query it with standard SQL, without servers to manage.

Cloud data warehouse

Stores and queries large data volumes with standard SQL.

Storage and compute apart

Each team can get its own compute, and you pay for the processing you use.

On AWS, Azure or Google Cloud

Your account runs on the cloud and region you choose, including AWS Jakarta.

Data sharing

Share live data with subsidiaries or partners without sending files.

// CLIENT RESULTS

Two pharmaceutical companies report from Snowflake.

Both use Snowflake as their main data store, with dbt to transform the data before it reaches their reports.

Regional plantation and mill dashboard pages
Fasterregional figures
A database kept on one laptop became a central cloud platform for regional management.
Snowflakedbt
“Kitameraki demonstrated professionalism, patience, and a proactive, solution-driven mindset.”
General Manager, pharmaceutical company · Singapore
Power BI finance dashboard example (sample data)
100+staff with automatic reports
Weekly reports for marketing, sales, medical and market access now reach every team without manual work.
Snowflakedbt
“The workflow was smooth, with regular updates and quick feedback.”
Senior Commercial Effectiveness Manager, pharmaceutical company · Jakarta
// WHEN SNOWFLAKE FITS

A good fit if you recognise your company here.

Large data volumes from many sources

Sales, stock, finance and operations data brought together and kept for years.

Several clouds or BI tools

Snowflake works with Power BI, Tableau and most other BI and data tools.

Workloads that change over the month

Compute can grow for month-end closing and pause automatically when idle.

// WHAT WE DO

From assessment to a running platform.

Assessment and design

  • ✓Review of your sources and reports
  • ✓Architecture and warehouse sizing
  • ✓Roadmap and budget

Build

  • ✓Pipelines from ERP, CRM and files
  • ✓Data models for reporting
  • ✓Transformations with dbt

Migration

  • ✓From SQL Server, SSIS or other databases
  • ✓In stages, with reports kept running
  • ✓Checks that the figures match

Run and improve

  • ✓Cost and usage monitoring
  • ✓Access rules by role
  • ✓Dashboards in Power BI or Tableau
// SNOWFLAKE OR MICROSOFT FABRIC?

We recommend the platform that fits your company.

Both are good data platforms. The right choice depends on your current systems, licences, data volume and team.

Microsoft Fabric is often the natural choice

If you already use Power BI and Microsoft 365, Fabric builds on the licences, security and skills you have.

About Microsoft Fabric →

Snowflake is often a good fit

If you use several clouds or BI tools, handle large data volumes or share data with partners, Snowflake keeps your options open.

// FAQ

Questions about Snowflake

Can our data stay in Indonesia?

Yes. Snowflake has run in the AWS Asia Pacific (Jakarta) region since 2023, so your data warehouse can be hosted in Indonesia.

What is dbt, and why use it with Snowflake?

dbt is an open-source tool that transforms data inside the data warehouse with SQL. Each transformation is versioned, tested and documented, so your figures stay consistent and easy to audit. We used it on both of our Snowflake client projects.

Can Power BI and Tableau connect to Snowflake?

Yes. Both have a Snowflake connector, so your dashboards can read data from Snowflake directly.

How is Snowflake priced?

You pay for the data you store and for compute while it runs. Compute can pause automatically when nobody uses it, which keeps costs under control.

How long does a Snowflake project take?

It depends on the scope and the number of sources. A simple project is up and running within a month. Our typical Snowflake and dbt project takes about three months.

Can you migrate our SQL Server data warehouse to Snowflake?

Yes. We move it in stages, check that the figures match, and keep your reports running during the move.

Do we need a data warehouse at all?

Not always. A few sources can feed dashboards directly. When data comes from many systems, or reports must match across the company, a data warehouse such as Snowflake or Microsoft Fabric helps.

Related pages

Data flow from sources to a data warehouse and dashboards

Data platforms

Data warehouses on Fabric, Azure or Snowflake.

Learn more →
Microsoft Fabric and its main components

Microsoft Fabric

One Microsoft platform from raw data to Power BI.

Learn more →
Logos of the technologies we work with

All technologies

The tools we work with, and how we choose.

Learn more →

Thinking about Snowflake?
We will tell you if it fits.

A free first session with a senior consultant, in English or Bahasa Indonesia.

Book a free consultationChat on WhatsApp