Handling Historical Data with FileMaker and AWS Athena, S3 & Serverless

In this blog post, we will explore a solution for optimising a FileMaker app that handles large amounts of data. We will address the challenges of data storage, file corruption, and performance degradation when dealing with historical data.

By leveraging cloud storage and serverless computing, we can offload and query this data efficiently, ensuring better performance and scalability.

Continue reading “Handling Historical Data with FileMaker and AWS Athena, S3 & Serverless”

Tableau Conference 2023 – Highlights

Greetings from Tableau Conference 2023 (TC23) in Las Vegas, and beyond. Beezwax’s Data Analytics & Tableau Developer team is attending, both in-person and virtual.

TC23 is designed to reveal and inspire, with new product information, plus Tableau (and Salesforce) company roadmaps. More importantly, there’s plenty of insight from TC23 sessions including technical topics, case studies, thought leadership, cool demos, community inspiration, and hands-on learning.

Continue reading “Tableau Conference 2023 – Highlights”

Data Visualization in FileMaker Web Viewer

Alec Gregory from Beezwax presents at the Claris FileMaker for Research User Group.

Let’s talk about Claris® FileMaker® and data visualization with FileMaker 19 web viewer, and developing with open source tools!

Continue reading “Data Visualization in FileMaker Web Viewer”

Datathon for Social Good 2022 @ UC Berkeley

Datathon for Social Good 2022 is the 4th-annual event for UC Berkeley students to show off their data science skills through real-world project applications. With a focus on technology applied toward social good, this Datathon allows participants the opportunity to explore and tackle current social issues by employing data science to leave a real-world impact.

An Exploration into Environmental Justice & Urban Sciences

This year’s Datathon has several competition tracks that focus on different societal issues ranging from urban sciences to environmental sustainability. Datasets and tools will be provided by CalData, Earth Hacks and Deepnote. Teams create visualizations, analyses, or machine learning models addressing any aspect of the given datasets, which are then presented to partnering organizations and judges.

Continue reading “Datathon for Social Good 2022 @ UC Berkeley”

Tableau Conference 2022 – Day 3

We finished three days of Tableau Conference 2022 (TC22) in sunny Las Vegas! The in-person and virtual attendees from Beezwax’s Data Analytics & Tableau development teams shared a few more highlights of TC22 sessions, with information, insights and a few key takeaways.
Continue reading “Tableau Conference 2022 – Day 3”

Tableau Conference 2022 – Day 2

Hello again from the end of Day 2 at Tableau Conference 2022 (TC22) in sunny Las Vegas! The in-person and virtual attendees from Beezwax’s Data Analytics & Tableau development teams shared more highlights of TC22 sessions, with information, insights and a few key takeaways.
Continue reading “Tableau Conference 2022 – Day 2”

Tableau Conference 2022 – Highlights

Hello from Tableau Conference 2022 (TC22) in sunny Las Vegas! Attending in-person from Beezwax were Rob, Sarah, Vince and Jay from our Tableau/Analytics team, with several more Beez joining virtually.
Continue reading “Tableau Conference 2022 – Highlights”

A fast, flexible Tableau Connector for FileMaker

Building a custom Tableau® Connector for Claris® FileMaker® enables faster, more reliable and more flexible connections between Tableau and FileMaker datasources, compared with the legacy Web Data Connector.

For a number of Beezwax client projects, we’ve installed and deployed a Tableau Connector (aka “TACO”) for FileMaker. The TACO was built using the Tableau Connector SDK (provided by Tableau) to connect to datasources on FileMaker Server. The TACO method uses JDBC rather than the FileMaker Data API for the connection between FileMaker and Tableau, and in our testing the performance of data extracts was up to 10 times faster.

Continue reading “A fast, flexible Tableau Connector for FileMaker”

Day 3 Sessions | Tableau Conference 2019

And we feel welcomed!
Greeting us from the Mandalay Bay Convention Center

Hello again from Tableau Conference 2019 in sunny Las Vegas! Here at Beezwax, we had 5 attendees this year with a diverse set of sessions between us. I wanted to give a rundown of what I went through and some of my takeaways.

Continue reading “Day 3 Sessions | Tableau Conference 2019”

Day 2 Sessions | Tableau Conference 2019

And we feel welcomed!
Greeting us from the Mandalay Bay Convention Center

Hello again from Tableau Conference 2019 in sunny Las Vegas! Here at Beezwax, we had 5 attendees this year with a diverse set of sessions between us. I wanted to give a rundown of what I went through and some of my takeaways.
Continue reading “Day 2 Sessions | Tableau Conference 2019”

The Impact of Data Viz | Tableau Conference 2019 Day 1

And we feel welcomed!

Greetings from the Mandalay Bay Convention Center!

It’s Day 1 of the Tableau Conference 2019, and there is so much to see and do here! Prior to tonight’s kickoff, one of the exhibits that I was keen to visit is a Viz Gallery set up on the second floor. Studying each piece, I found myself struck with inspiration with regards to how I feel about data.
Continue reading “The Impact of Data Viz | Tableau Conference 2019 Day 1”

Tableau to FileMaker | Scheduled Extracts

Once you have crafted a Tableau dashboard, pulling data from your FileMaker solution, then your next goal might be to make sure the dashboard data gets refreshed at regular intervals, and in an efficient manner. And that is what we’ll do in this blog post.

Continue reading “Tableau to FileMaker | Scheduled Extracts”

FileMaker to Tableau | The Learning Journey

Now that the FileMaker Data API has been officially released (with FileMaker 17), it is time to share an update on Tableau-to-FileMaker integration. I originally wrote about integrating Tableau and FileMaker to create a match made in data heaven. I’ll also be speaking on “FileMaker + Tableau” at FileMaker DevCon 2018.

Continue reading “FileMaker to Tableau | The Learning Journey”

Large d3.js Application Development

“Code that belongs”. This is the mantra, the quest, of Beezwax Senior Developer Ryan Simms; which he discusses in this ten-part article on building a large-scale web application using d3.js. How to write code that fits the context intrinsically. The article focuses on specific techniques with the data visualization library, d3.js. But the lessons are broad. How do you make something fit — in ways that make it feel like it belongs?

Continue reading “Large d3.js Application Development”

FileMaker Konferenz, Salzburg 2017

The 8th FileMaker Konferenz is happening October 12 – 14, 2017 at the Crowne Plaza Pitter Event Center in Salzburg, Austria.

At the konferenz Vincenzo Menanno, director of FileMaker Development for Beezwax presents two sessions on advanced FileMaker development:

Continue reading “FileMaker Konferenz, Salzburg 2017”

FileMaker & Tableau | A Match Made in Data Heaven!

Last year when I wrote this blog post we were talking about FileMaker 16 and the Data API being in beta. Now that FileMaker 17 has officially been released and along with it the Data API is out of beta and is a version 1.0.

Continue reading “FileMaker & Tableau | A Match Made in Data Heaven!”

FileMaker & Tableau | Building Dashboards with Interactivity

If you’ve been working with FileMaker, then I don’t have to sell you on the fact that it’s a great solution to help you manage your data. Whether you’re an in-house developer, a consultant, or just starting to explore what is possible with this powerful platform, you will at some point come across the need to build in some kind of dashboard. Maybe your group needs to see sales trends for the last year or perhaps you have a system that tracks projects and want to see the daily average of tasks completed. In either case, dashboards are a great way to synthesize large amounts of information and provide you with insight in a simple and informative visual design.

Continue reading “FileMaker & Tableau | Building Dashboards with Interactivity”

Excel formatting and charts from FileMaker using XlsxWriter

If you’ve developed solutions with FileMaker for any length of time, you’ve almost certainly created files using FileMaker’s native Excel exports. Although quite useful, this feature gives almost no control over the formatting, and definitely no way to set formulas, charts, or even text formatting.

Continue reading “Excel formatting and charts from FileMaker using XlsxWriter”

InspectorPro 5.5 Feature List!

InspectorPro 5.5 is here! With it come some great enhancements and complete support for FileMaker 14:

• Now supports new features, themes, and styles found in FileMaker 14
• New visualization gives you a quick view of referenced and unreferenced items and problems
• New streamlined database view to help you get a bird’s-eye view of your database
• Automatic detection of malformed XML or invalid characters

hello San Antonio. hello FileMaker DevCon.

It’s FileMaker Developer Conference time, with 8 Beez in San Antonio for DevCon. We’re studying new development techniques from FileMaker Inc. and our industry peers, sharing a few methods of our own and even riding a few mechanical bulls at a real live cattle ranch!

Continue reading “hello San Antonio. hello FileMaker DevCon.”

1 2