Much of the data analysts need lives in databases, not spreadsheets. This topic teaches you to read a relational database, write SQL queries, summarize with GROUP BY and join tables without losing or duplicating records. Practise with interactive exercises while Barty, your 24/7 AI tutor, explains errors and alternatives.
✓ Start free, no card needed ✓ 19 schools for US$ 29/month ✓ 100% online ✓ 24/7 AI tutor


Who it is for: For analysts and Power BI users who want to query databases directly with SQL.
Advanced level · Data Analysis and Power BI school
Data Analysis and Power BI teaches you to turn raw numbers into clear dashboards and reports. For example, a logistics coordinator linked to a Halifax port or shipping business can track shipment delays and costs in Power BI to spot patterns. A public administration analyst can organize departmental data into visual reports that help managers make better decisions. Work through interactive lessons, simulators and projects with Barty, then earn a certificate of completion.
Many people in Halifax are fitting new skills around busy work shifts, university schedules and life by the harbor. Barter AI Academy lets you learn online with Barty, a 24/7 AI tutor, interactive lessons, challenges, simulators and projects, all from home or on the go. Study at your own pace and earn a certificate of completion for every school you finish.
You are not buying one course: you join the whole super academy. 19 schools that can take your career and your business further: Excel, AI, marketing, sales, design, music production, public speaking and more, with 1,076 lessons, an AI tutor that never gets tired of explaining and a certificate at the end of every level. On the annual plan it is US$ 0.68 a day: less than a coffee.
US$ 29/month
≈ C$ 41/month approx. at today's rate
US$ 249/year
≈ C$ 360/year approx. at today's rate
☕ US$ 0.68 a day (≈ C$ 1): less than a coffee
Pay with a debit or credit card, or with PayPal. You are charged in US dollars; the amount in CAD is a reference at today's exchange rate and your bank makes the final conversion.
See also: Data Analysis and Power BI course in Halifax · SQL for Data Analysis course online
No. SQL reads close to plain English, and the lessons begin with what a database is before moving to queries. Barty can explain any error or concept as you practise.
Yes. You learn that WHERE filters rows before grouping and HAVING filters groups after summarizing, and you practise both with GROUP BY, plus how to avoid duplicated rows in joins.
Yes. Barter AI Academy is 100% online, so you can study from anywhere in Halifax with an internet connection and a phone, tablet or computer. Choose your own schedule, study in short sessions during your commute or in longer blocks at home, and ask Barty questions whenever you need help. Your progress is saved, so you can pick up right where you left off.
Yes. You study at en.academiabarterrubio.com on your phone or computer, at your own pace and with no fixed schedule. All you need is internet. Barty, the AI tutor, is with you 24 hours a day.
The membership costs US$ 29 a month or US$ 249 a year and includes all 19 schools, not just one course: interactive lessons, challenges, simulator, AI tutor and certificates of completion.
Yes. When you complete each level you receive a Barter AI Academy certificate of completion with a verification code that you can share on LinkedIn. It is issued by the academy; it is not an accredited degree.
Your membership also includes the Spanish school: listen to real phrases, practice your pronunciation with the microphone and get instant corrections from Barty, your AI tutor. From your first «hola» to Spanish for travel, work and business.
See the Spanish school →Create your account, choose your plan and start today. Your first lesson takes 7 minutes.