Product
Use Cases
Resources
Analyst Agent
Smartbooks
Smart Reports
Workflows
Use Cases
Ad Hoc Analysis & EDA
Product Analytics
Reporting
Collaboration
Internal Applications
GTM Analytics
Learning
Customers
Blog
Changelog
Documentation
Templates
Company
Mission
Contact us
YouTube
LinkedIn
Mission
Pricing
Integrations
Login
Start for free
Product
Analyst Agent
Smartbooks
Smart Reports
Workflows
Use Cases
Use cases
Ad Hoc Analysis & EDA
Product Analytics
Reporting
Collaboration
Internal Applications
GTM Analytics
Resources
Learning
Customers
Blog
Changelog
Documentation
Integrations
Templates
Company
Mission
Contact us
YouTube
LinkedIn
Mission
Pricing
Integrations
Start for free
Login
The Fabi.ai blog
Query & Theory
Fresh takes on AI-powered data analysis from the humans who build it
Tangible data tips to make life easier.
Team news – 8 minute read
Introducing Fabi.ai Workflows: Deliver insights where they matter
Fabi Workflows are the easiest and quickest ways to build and automate data insights pipelines. Connect to your favorites data sources and collaborative tools, and build workflows with SQL, Python, AI and low-code.
June 30, 2025
Marc Dupuis
CEO & Co-Founder @ Fabi.ai
Best practices – 15 minute read
What is exploratory data analysis (EDA): Methods, use cases, and best practices in the age of AI
Learn essential EDA methods, tools, and best practices. Discover how AI transforms data analysis with practical examples, code, and expert tips for better insights.
January 23, 2025
Marc Dupuis
CEO & Co-Founder @ Fabi.ai
Best practices – 12 minute read
Plotly vs matplotlib: A quick comparison with visual guides
When considering Python charting libraries, when should you use Matplotlib vs Plotly? In this article we compare the two and discuss the pros and cons of each.
January 22, 2025
Marc Dupuis
CEO & Co-Founder @ Fabi.ai
Tutorials – 8 minute read
Tutorial to get you started with Python pandas and CSV files using pd.read_csv()
In this tutorial, we show you how to quickly convert a CSV file to a pandas DataFrame. We also explore more advanced features and alternative options.
January 17, 2025
Lei Tang
CTO @ Fabi.ai
Product news – 6 minute read
Query & Theory Newsletter: January 2025
2025 AI in data predictions & skills to stand out
January 15, 2025
Marc Dupuis
CEO & Co-Founder @ Fabi.ai
Best practices – 12 minute read
SQL vs Python: which to use for data analysis
Python vs SQL: which do choose when doing data analysis. We explore the merits of both and which to start with.
January 9, 2025
Marc Dupuis
CEO & Co-Founder @ Fabi.ai
Tutorials – 8 minute read
Pandas histogram: creating histogram in Python with examples
In this brief tutorial we walk through the basics to get started with histograms using Python DataFrames. We also cover other alternatives that may be helpful for different use cases.
January 7, 2025
Marc Dupuis
CEO & Co-Founder @ Fabi.ai
Product news – 5 minute read
Fab.ai December 2024 updates: A recap of key features we launched in 2024 and a preview of things to come
A recap of key features we launched in 2024 and a preview of things to come.To start off the new year, we wanted to share our latest features, some fan-favorite features from 2024 and a sneak peak of things to come.
January 6, 2025
Marc Dupuis
CEO & Co-Founder @ Fabi.ai
Tutorials – 9 minute read
Getting started with Python interactive charting libraries
Interactive charts are a great well to engage create rich reports and engage your audience. Python makes it easy to quickly create interactive plots. In this post we talk about the best libraries and how to get started.
January 2, 2025
Marc Dupuis
CEO & Co-Founder @ Fabi.ai
Best practices – 8 minute read
4 online SQL and Python AI code generation tools to get you started today
Code generation can help unlock new levels of productivity and efficiency, and can help data practitioners uncover novel insights to help drive the growth of the business. We explore free, online Python code generation tools to help get you started immediately.
December 20, 2024
Lei Tang
CTO @ Fabi.ai
Best practices – 6 minute read
Top 5 AI-native business intelligence and analytics tools
Leveraging AI for BI requires an entirely new way of thinking of analytics. In this article we explore merits of AI-native BI, how it differs from legacy BI, and the current best AI business intelligence tools.
December 18, 2024
Marc Dupuis
CEO & Co-Founder @ Fabi.ai
Tutorials – 14 minute read
How to connect to a remote SQL server to analyze data in Python using sqlalchemy and Python (step-by-step guide)
In this brief tutorial, we show you how to query a remote SQL database using Python with SQLAlchemy and pandas pd.read_sql. By combining SQL and Python, you can query relational data and conduct advanced data analysis and visualizations more efficiently than you can with either independently.
December 11, 2024
Marc Dupuis
CEO & Co-Founder @ Fabi.ai
Best practices – 8 minute read
Collaborative data analysis: Why it matters and what great looks like
Collaborative data analysis can change the way data is used and trusted in an organization. Collaborative analytics tools brings teams together and meet them where they are. In this post we dive into what collaborative data analysis really means and what tools are required to enabled it.
December 5, 2024
Marc Dupuis
CEO & Co-Founder @ Fabi.ai
Product news – 2 minute read
Fabi.ai November 2024 updates: Flexible reports layouts & AI data analysis agent GA
Our mission is to make it incredibly easy for you to conduct data analysis and share your insights with your coworkers as beautiful, timely reports. With our latest major release of “flexible reports layouts”, we’ve taken yet another major step in that direction.
December 2, 2024
Marc Dupuis
CEO & Co-Founder @ Fabi.ai
See newer posts
See more posts
Subscribe to
Query & Theory
Subscribe to
Query & Theory