2 posts tagged with "sheets bi"

Most people in operations use spreadsheets for smoothly run their processes, such as budget planning at the year end. They also deal with multiple teams or organizations and hence in order to maintain they need to have a separate spreadsheet for each organization. While this solves the security problem, it makes it difficult to get a consolidated view of the data across the teams.

Google sheets users with advanced skills tend to use the IMPORTRANGE feature which allows importing data from one spreadsheet into another. However, this can pose certain performance challenges.

We recently announced a preview of Sheets BI a BI tool that works realtime with your Google Sheets, Excel and CSV files on Google Drive, public datasets and local files.

In this post I am going to talk about some of the technical journey of the process.