Відео

When considering Python charting libraries, when should you use Plotly vs Matplotlib? In this brief video, we compare the two and discuss the pros and cons of each. Check out our blog for a detailed article comparing the two in depth: www.fabi.ai/blog/plotly-vs-matplotlib-a-quick-comparison-with-visual-guides

In this tutorial, we show you how to use sentiment analysis to categorize product reviews in natural language using MotherDuck's embedded AI function. We also show you how to turn this data into a dynamic report that you can share with your stakeholders with nothing more than a bit of SQL and Python.

In this tutorial, we show you how to quickly convert a CSV file to a pandas DataFrame using pd.read_csv(). We also explore more advanced features of the read_csv function and alternative options. Full notes and code on our blog: www.fabi.ai/blog/how-to-read-a-csv-with-python-pandas-made-easy

We'll show you to to create automated Slack messages that dynamically change based on data pulled from Airtable. All you'll need it an API key for Airtable and Slack, and you can get up and running in minutes.

In this tutorial we show you how to convert your analysis to an interactive dashboard or push your data to your other systems such as Google Sheets.

Fabi.ai tutorial that demonstrates how to get the most out of our AI to quickly do data analysis, boost your productivity and do things with data that were previously out of reach.

Fabi.ai tutorial that demonstrates some of the fundamental concepts to help you get started with you data analysis as quickly as possible.

In this video we talk about SQL vs Python for data analysis, and which to use for various tasks. Detailed notes and examples in our blog: www.fabi.ai/blog/sql-vs-python-which-to-use-for-data-analysis

In this tutorial we show you how to quickly create a histogram from a Python pandas DataFrame along with some tips and tricks.

In this SQLAlchemy tutorial, I walk through a basic Python script that queries BigQuery, stores the results as a pandas DataFrame, does some basic aggregation and plots the data. You'll need: * Credentials to a remote SQL database or data warehouse * Basic SQL knowledge * Command line/terminal basic knowledge (pip install sqlalchemy, pip install pandas, setting environment variables...) * Basic...

In this tutorial we show you how to configure and schedule a Slack app to send regular reports or conditional alerts to your team in Slack. This is the most effective way to ensure that data is leveraged by your team. This tutorial requires basic SQL and Python skills and Slack admin access. The tutorial is shown in Fabi.ai, but can easily be done in a local dev environment as well. Full tutori...

In this video, we show you how you can quickly turn a static report into a dynamic report with filters and inputs. This tutorial is great for anyone who currently uses SQL or Python notebooks and wants to share them with their stakeholders. For more information, check out our documentation: docs.fabi.ai/analysis_and_reporting/filters_and_inputs

Streamlit is a simple and powerful Python data app framework that you can get started with in minutes. However, once you're ready to share your app with your coworkers or the world, you'll need to host your app on a remote machine. In this video I show you how do deploy and host your Streamlit app in AWS using EC2 and Docker. All the code is available here: www.fabi.ai/blog/complete-step-by-ste...

Learn how to write a simple query to visualize how your ongoing user retention is changing over a rolling window. In many cases this may be a better alternative to a more traditional cohort analysis.

Creating dynamic descriptions and summaries in your analytics reports.

Create a Sankey diagram in 30 seconds

Quickly converting JSON to tabular format

Churn prediction using survival analysis

Benchmarking Polars vs Pandas

Pushing Python DataFrames to Google Sheets