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 spreadsheets and sales records into clear dashboards. For example, a retail store manager in New Plymouth can track weekly stock and sales to see which products move fastest and plan orders. A construction project coordinator can build a dashboard showing job costs and delivery dates, so decisions rely on up-to-date information. The course is online and self-paced, with interactive lessons, challenges and a project you can add to your portfolio.
Many people in New Plymouth work in energy, dairy farming, engineering, tourism, retail and construction, and their hours can be long or unpredictable. Learning online with Barty, a 24/7 AI tutor, lets you study in the evening, at the weekend or during a quiet moment, at your own pace. Each school includes interactive lessons, challenges, simulators and projects, and ends with a certificate of completion.
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
≈ NZ$ 53/month approx. at today's rate
US$ 249/year
≈ NZ$ 450/year approx. at today's rate
☕ US$ 0.68 a day (≈ NZ$ 1): less than a coffee
Pay with a debit or credit card, or with PayPal. You are charged in US dollars; the amount in NZD is a reference at today's exchange rate and your bank makes the final conversion.
See also: Data Analysis and Power BI course in New Plymouth · 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. Everything is 100% online, so you can study from home, a office or a café with a stable internet connection, using a laptop, tablet or phone. You choose your own schedule and study at your own pace. Barty, the AI tutor, is available 24/7 to answer questions and explain difficult topics. There are no in-person classes or live teachers, and you receive a certificate of completion when you finish.
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, practise 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.