+91 95534 06450
Info@akirait.com
Whatsapp Instagram Icon-facebook Icon-linkedin Youtube
Contact Us

Tableau, Power BI and SQL Training Course

60 Hours

Instructor Led

Hands-on Labs

Become a job ready data analytics professional with hands-on labs, real world datasets in Sales, HR, Retail and Finance, a capstone project combining SQL with Tableau or Power BI, and an industry aligned data analytics training course.
Download Brochure

About the Tableau, Power BI and SQL Training Full Course

AKIRA Global Technologies Tableau, Power BI and SQL Training course takes learners from database fundamentals to building end to end analytics dashboards in just 60 hours. This data analytics full course covers SQL fundamentals, intermediate and advanced SQL, SQL for analytics, Power BI foundations, DAX and advanced Power BI, Tableau foundations, and advanced Tableau and dashboards.

Whether you are an IT professional, a fresher or student building a data analytics foundation, a career switcher moving into business intelligence, or an existing SQL user looking to upskill into Tableau and Power BI, this data analytics certification training course is hands-on, with 60% of the program spent on practice using real world datasets from Sales, HR, Retail and Finance.

This is not just a data analytics course on paper, it is a practical, instructor led program covering SQL joins, subqueries, window functions and CTEs, Power Query with M language, data modeling, DAX and row level security in Power BI, and calculated fields, LOD expressions, table calculations and dashboard actions in Tableau. The program closes with a capstone project combining SQL with Tableau or Power BI, so you finish ready to apply your skills to real business dashboards.

Delivered instructor-led and hands-on lab based on SQL Server or MySQL, Tableau Desktop, and Power BI Desktop and Service, the course requires only basic computer literacy to get started, with 40% of the program spent on concept and 60% spent on hands-on practice.

Course Details Information
Duration 60 Hours
Mode Instructor Led
Format Instructor-led, hands-on lab based on SQL Server or MySQL, Tableau Desktop, and Power BI Desktop and Service
Level [Beginner to Advanced]
Delivery Split 40% Concept + 60% Hands-on Practice
Certification Certificate of Completion
Tools Covered SQL Server or MySQL, Tableau Desktop, Power BI Desktop and Power BI Service
Who Should Enroll?

IT Professionals

Professionals looking to move into a dedicated data analytics or business intelligence role

Freshers & Students

Learners who want a structured, hands-on foundation in SQL, Tableau and Power BI from day one

Career Switchers

Anyone with basic computer literacy wanting a practical route into data analytics

What You'll Get

When you join Akira Global Technology’s Tableau, Power BI and SQL Training course, you get complete support at every step, from SQL foundations to a portfolio ready capstone dashboard.

Training

  • SQL Training including Fundamentals, Intermediate/Advanced SQL and SQL for Analytics (25 Hrs)
  • Power BI Training including Foundations and DAX/Advanced Power BI (17 Hrs)
  • Tableau Training including Foundations and Advanced Tableau/Dashboards (15 Hrs)

Hands-on Experience

  • 60% Hands-on Practice Using Real World Datasets (Sales, HR, Retail, Finance)
  • Industry Aligned Tools (SQL Server/MySQL, Tableau Desktop, Power BI Desktop and Service)
  • 1 Capstone Project Combining SQL Plus Tableau or Power BI

Get Certified

  • Practice Labs and Assignments Across SQL, Power BI and Tableau
  • Assessment/Quiz on SQL for Analytics
  • Certificate of Completion

End to End Analytics Skills

  • SQL Covering Joins, Subqueries, Window Functions and CTEs
  • Power BI Covering Power Query with M Language, Data Modeling, DAX and RLS
  • Tableau Covering Calculated Fields, LOD Expressions, Table Calculations and Dashboard Actions

Dashboard Design Guidance

  • Dashboard Design Principles and Data Storytelling
  • Power BI Service Dashboards, Sharing and Scheduled Refresh
  • Tableau Dashboard Actions and Story Points

Practice Environment

  • Hands-on Lab Based on SQL Server or MySQL
  • Tableau Desktop and Power BI Desktop and Service Access
  • Real World Datasets Across Sales, HR, Retail and Finance

Enroll Now - Get All These Benefits

Tableau, Power BI and SQL Training Course Syllabus

Our Tableau, Power BI and SQL training syllabus runs across 10 modules, moving from SQL fundamentals through intermediate and advanced SQL and SQL for analytics, into Power BI foundations and DAX plus advanced Power BI, then Tableau foundations and advanced Tableau plus dashboards, before wrapping up with dashboard design, a capstone project, and career readiness.

Prerequisites:

  • Basic computer literacy
  • No prior SQL, Tableau or Power BI experience required
  • A laptop with internet access to join the instructor led sessions and lab environment
Module Duration Topics Covered Tools/Project
Module 1: SQL Fundamentals 12 Hours
  • Introduction to databases and RDBMS concepts (1 hr)
  • DDL – CREATE, ALTER, DROP, TRUNCATE (1 hr)
  • DML – INSERT, UPDATE, DELETE (1 hr)
  • DQL – SELECT, WHERE, ORDER BY, DISTINCT, TOP/LIMIT (1.5 hrs)
  • Operators and filtering – BETWEEN, IN, LIKE, IS NULL (1.5 hrs)
  • Aggregate functions – SUM, AVG, COUNT, GROUP BY, HAVING (2 hrs)
  • String, date and numeric functions (1 hr)
  • Practice lab and assignment (2 hrs)
 SQL Server / MySQL
Practice Lab + Assignment
Module 2: Intermediate and Advanced SQL 10 Hours
  • Joins – inner, left, right, full outer, self and cross (2 hrs)
  • Subqueries and correlated subqueries (1.5 hrs)
  • Set operations – UNION, UNION ALL, INTERSECT, EXCEPT (1 hr)
  • Window functions – ROW_NUMBER, RANK, LAG/LEAD, partitions (2 hrs)
  • Common table expressions and recursive CTEs (1 hr)
  • Views, indexes and query optimization basics (1 hr)
  • Stored procedures and functions, intro (0.5 hr)
  • Practice lab on business case queries (1 hr)
 SQL Server / MySQL
Practice Lab:
Business Case Queries
Module 3: SQL for Analytics 3 Hours
  • Analytical queries for reporting, trends and comparisons (1.5 hrs)
  • Data cleaning using SQL for duplicates, nulls and standardization (1 hr)
  • Assessment / quiz (0.5 hr)
 SQL Server / MySQL
Assessment / Quiz
Module 4: Power BI Foundations 8 Hours
  • Power BI ecosystem – Desktop, Service, Mobile, Gateway (1 hr)
  • Connecting to data sources – Excel, SQL, Web, Folder (1 hr)
  • Power Query Editor for data cleaning and shaping with M basics (2 hrs)
  • Data modeling – relationships, cardinality and star schema (2 hrs)
  • Basic visuals – bar, line, pie, cards, slicers and tables (2 hrs)
  • Power BI Service – dashboards, sharing and scheduled refresh (1 hr)
 Power BI Desktop
Module 5: DAX and Advanced Power BI 9 Hours
  • DAX basics – calculated columns versus measures (1 hr)
  • DAX functions – CALCULATE, FILTER, ALL and related functions (2 hrs)
  • Time intelligence – YTD, MTD, QTD, SAMEPERIODLASTYEAR (2 hrs)
  • Advanced visuals – maps, matrix, drill through and bookmarks (2 hrs)
  • Row level security and publishing to Service (1 hr)
  • Power BI Service – dashboards, sharing and scheduled refresh (1 hr)
 Power BI Desktop and Service
Module 6: Tableau Foundations 8 Hours
  • Tableau ecosystem – Desktop, Public, Server/Online and Prep (1 hr)
  • Connecting to data sources and data interpreter (1 hr)
  • Tableau interface – dimensions, measures, shelves and marks card (1 hr)
  • Basic charts – bar, line, pie, scatter, treemap and heat map (2 hrs)
  • Filters, sorting, grouping, sets and hierarchies (2 hrs)
  • Joins, blends and union in Tableau (1 hr)
 Tableau Desktop
Module 7: Advanced Tableau and Dashboards 7 Hours
  • Calculated fields – logical, string and date functions (1.5 hrs)
  • Table calculations – running total, percent of total and rank (1.5 hrs)
  • LOD expressions – FIXED, INCLUDE and EXCLUDE (2 hrs)
  • Parameters and dynamic dashboards (1 hr)
  • Dashboard actions and story points (1 hr)
 Tableau Desktop
Module 8: Dashboard Design and Data Storytelling Integrated within Modules 5 & 7 hours above
  • Dashboard design principles and data storytelling
  • Power BI Service dashboards, sharing and scheduled refresh (from Module 5)
  • Tableau dashboard actions and story points (from Module 7)
 Power BI Service
Tableau Desktop
Module 9: Capstone Project 3 Hours
  • Business requirement walkthrough (0.5 hr)
  • End to end build: SQL extraction to Power BI/Tableau modeling to final dashboard (2 hrs)
  • Project review and feedback (0.5 hr)
 Capstone:
SQL + Tableau/Power BI End to End Dashboard
Module 10: Career Readiness and Interview Prep Integrated within Module 9 hours above
  • Course feedback and project review discussion
  • Portfolio readiness using the capstone dashboard
  • Interview preparation guidance following the capstone project
 –
1 / 10

Capstone Project (Included)

Participants build an end to end analytics project that includes:
✓ Walking through a business requirement for the capstone dashboard
✓ Extracting and preparing data using SQL
✓ Modeling and building a dashboard in Power BI or Tableau
✓ Applying dashboard design principles and data storytelling to the final output
✓ Presenting the project during the project review and feedback session

Tableau, Power BI and SQL Training Admission Process

1

Fill Inquiry Form

Share your details and course interest

2

Counselling Call

Speak with our admissions team about your goals and fit

3

Get Course Access

Receive login credentials and join the orientation session

Requirements

Eligibility Criteria: this is not required

  • Basic computer literacy is required; no prior SQL, Tableau or Power BI experience is necessary
  • Open to IT professionals, freshers, students, career switchers, and existing SQL/reporting staff from any technical background
Success

Thank you! Form submitted successfully.

This field is required
This field is required
This field is required
  • DevOps Engineer Course
  • Data Engineering Course
  • Business Analyst Course
  • AI & Machine Learning Course
  • Salesforce Training Course
  • Generative AI Training Program
  • Cloud Computing Training Program
  • Cybersecurity Training Course
  • ServiceNow Training Course
  • Data Analytics Training Program
  • Tableau, Power BI & SQL Training Course
  • Other Akira IT Courses
This field is required

Learn From Data Analytics Industry Experts

DAT

Data Analytics Trainer

years of experience in SQL, Power BI and Tableau. Expert in SQL Server/MySQL, Power Query, DAX, and LOD expressions. Focuses on hands-on, dataset driven training to make students dashboard ready.

SQL

Power BI

Tableau

Power Query

Tools & Technologies You'll Master

Tableau

Learning Outcomes

By the end of this Tableau, Power BI and SQL Training course, participants will be able to:
✓ Write SQL queries using joins, subqueries, window functions and CTEs
✓ Clean, shape and model data using Power Query and Power BI data modeling
✓ Build DAX measures and apply row level security in Power BI
✓ Build calculated fields, LOD expressions and table calculations in Tableau
✓ Design dashboards and apply data storytelling principles across Power BI and Tableau
✓ Build an end to end analytics project from SQL extraction to a final dashboard

Assessment & Certification

Practice labs and assignments across SQL, Power BI and Tableau
Assessment / quiz on SQL for analytics
Final capstone project combining SQL with Tableau or Power BI
Project review and feedback session
Certificate of Completion issued upon finishing the program
Testimonials

What Our ServiceNow Learners Say

"The SQL modules gave me a strong base before we even touched Power BI or Tableau. Building the capstone dashboard end to end, from SQL extraction to a final Power BI report, was the moment it all came together."

Rohan Mehta

Data Analyst at an IT services company

"I liked how the course moved from joins and window functions in SQL straight into Power Query and DAX. Practicing on the Sales and Finance datasets made everything feel relevant to my actual job."

Ananya Sharma

Business Analyst transitioning into BI

"Strong hands-on focus throughout, especially the LOD expressions and table calculations in Tableau. I would have liked a bit more time on advanced DAX, but the capstone project helped a lot in interviews."

Vikram Nair

Fresher, now BI Developer

"The dashboard design and data storytelling guidance changed how I present numbers to stakeholders. Row level security in Power BI was also explained clearly with hands-on practice examples."

Priya Nambiar

Reporting Analyst at a retail company

"Good structured program covering SQL, Power BI and Tableau in one track. The instructor kept every lab tied back to the Sales, HR, Retail and Finance datasets, which made it easy to follow."

Sahil Kapoor

Data Analytics Intern
FAQ'S

Frequently Asked Questions

The Tableau, Power BI and SQL Training course duration is 60 hours, combining SQL, Power BI and Tableau training with hands-on labs, real world datasets, and a capstone project.