Tableau & SQL

Course Focus

Tableau

• Getting Started with Tableau
  Understand Tableau's interface, connect to data sources, and navigate the Tableau workspace.


• Data Preparation and Cleaning
  Learn data shaping, filtering, grouping, and sorting. Use data interpreter and pivoting for preparing raw data.


• Creating Visualizations
  Build bar charts, line graphs, maps, scatter plots, and other visualization types.


• Working with Calculated Fields
  Create custom calculations and use logical, arithmetic, and string functions to derive insights.


• Building Interactive Dashboards
  Design user-friendly dashboards with filters, parameters, and actions for interactivity.


• Advanced Analytics in Tableau
  Use trend lines, forecasts, reference lines, and statistical summaries for deeper insights.


• Publishing and Sharing
  Publish dashboards to Tableau Public or Tableau Server and manage dashboard access.




SQL (MySQL)

• Introduction to Relational Databases
  Understand database structures, relationships, and how data is stored and retrieved.


• SQL Fundamentals
  Learn SELECT statements, filtering with WHERE, sorting, and aliasing.


• Data Aggregation and Grouping
  Use COUNT, SUM, AVG, MIN, MAX, and GROUP BY to analyze data sets.


• Joins and Subqueries
  Perform INNER, LEFT, RIGHT, and FULL JOINs; use subqueries for complex queries.


• Data Manipulation and Filtering
  Insert, update, and delete records. Apply advanced WHERE clauses and pattern matching.


• Database Functions and Views
  Create views, use built-in functions, and write reusable queries.


• SQL for Analytics
  Solve real-world data problems and write optimized queries for reporting and dashboards.

Job Opportunities

Upon completion of the Tableau & SQL (MySQL) course, you will be prepared to explore a range of career opportunities in data visualization, business intelligence, and data analysis. This course equips you with the skills to interpret data, design meaningful visualizations, and manipulate data through SQL queries, all of which are essential skills for modern businesses.