INTELLIGENCE
Archive
How to Build a Local Analytics Pipeline with dbt and DuckDB
dbt Core and DuckDB together let you build a complete SQL transformation pipeline that runs entirely on your laptop, with no server, no cloud account, and no infrastructure costs. You install two Python packages, point a profiles.yml file at a local database file, write SQL models, and run dbt run. This guide walks through the full setup from scratch, including a working model that transforms CSV data into a clean analytics table.
How to Build Your First Power BI Dashboard
Power BI Desktop is a free Windows application from Microsoft that connects to Excel files, CSV exports, SQL databases, and more than 100 other data sources, then lets you build interactive charts and dashboards without writing code. Getting a first report built takes about 30 to 60 minutes with data you already have. Sharing those reports with colleagues requires a Power BI Pro license at roughly $10 per user per month. The free tier lets you build and publish only to a private personal workspace.
How to Use Manus AI for Data Analysis
Manus AI is an autonomous agent that accepts CSV and Excel uploads, runs analysis using internal Python execution, and delivers finished outputs including slide decks, interactive dashboards, and PDF reports without the user writing code or SQL. Sign up at manus.im with a Google or email account, upload a file, describe the output you want in plain English, and Manus delivers a complete, exportable result.
How to Set Up Amazon QuickSight Q for Analytics
Amazon QuickSight Q is a natural language interface built into AWS's business intelligence platform that lets you query your data by typing plain English questions rather than writing SQL. To use it, you need a QuickSight Enterprise subscription, at least one SPICE dataset, and a configured Q Topic. Once set up, you can ask questions like "What were sales by region last month?" and receive instant chart or table answers. Setup takes under 30 minutes for most business users.
How to Set Up Metabase for Business Analytics
Metabase is a free, open-source business intelligence tool that lets teams build charts, dashboards, and reports from a connected database without writing code or SQL. You can set it up in under 30 minutes using Metabase Cloud, or self-host it with Docker on any VPS. After connecting a database and configuring an admin account, anyone on your team can query data and build shareable dashboards through a point-and-click visual interface.
How to Build an Internal Dashboard with Retool
Retool is a low-code platform for building internal dashboards by connecting databases, APIs, and spreadsheets to drag-and-drop UI components. You create a data source connection, write a SQL or structured query, and bind the results to tables, charts, or KPI cards. Teams at operations-heavy companies use it to ship functional data apps without custom code. This guide walks through the full setup from data connection to publishing.
How to Get Started with Sigma Computing
Sigma Computing is a cloud analytics platform with a spreadsheet-like interface that connects directly to data warehouses such as Snowflake and BigQuery. It requires no SQL for basic analysis and lets teams query live data at scale. To get started, you need a supported cloud data warehouse, a free 14-day trial account, and about 30 minutes to connect your first dataset and build a workbook with charts and filters.
How to Get Started with Hex for Data Analysis
Hex is a browser-based analytics workspace that lets analysts run SQL, Python, and no-code analysis in one place, with an AI Notebook Agent that generates queries and charts from plain-English prompts. You can connect a data warehouse or upload a CSV, describe the analysis you need, and get an interactive report without writing any code. This guide walks through account setup, data connection, and running your first AI-assisted analysis from scratch.
How to Use Tableau Public for Business Reporting
Tableau Public is a free data visualization tool from Tableau that lets you connect spreadsheets and CSV files, build interactive charts, and publish dashboards to the web. Business users without a coding background can create sales summaries, operational dashboards, and trend reports in under an hour. The main trade-off is that all published dashboards are publicly accessible, which makes it better suited for non-sensitive external reports than for internal company data.