Business Intelligence Analyst Course

Learn how schemas organize databases into tables with data, and how to create, use, and drop databases and tables in a MySQL workbench, then query data with select statements.

Explore structured query language (sql) fundamentals with mysql, including how tables store structured data, schemas and databases, and core commands across ddl, dml, dql, dcl, and tcl.

Explore sql fundamentals across ddl, dml, dql, dcl, and tcl, including create, alter, drop, insert, update, delete, select, and constraints like primary key, not null, unique, and default.

Create databases and tables, define primary key, not null, unique, default, and check constraints, and explore foreign key relationships and auto increment for ids.

Learn to design a relational database by creating db2, tables with primary and foreign keys, and relationships using a script; practice inserting data and validating with show tables.

Learn how to verify created tables in a DB2 database, query customers with selective fields and aliases, and control results with limit and order by country.

Learn how the where clause filters data in SQL queries to fetch specific records from tables, using examples like country and city filters.

Explore how to use order by, group by, and having clauses with aggregation functions such as sum, max, min, average, and count to summarize data.

Learn how the order by clause sorts data in ascending order by default, and how to switch to descending order by adding dsc after the clause.

Master arithmetic and logical operators in SQL, applying addition, subtraction, multiplication, and division, and use or for inclusive filters and for strict filters such as motorcycles and mean lean diecast.

Master sql operators, including or, and, in, like, and between, with DB2 queries on payments and employees, filtering by job titles such as president, sales representative, and vp sales.

Learn SQL comparison operators: equal, greater than, less than, greater than or equal, less than or equal, and not equal, with select and order by examples.

Learn to select specific columns from the employees table and rename them with aliases, such as employee number to employee ID, last name to ln, and first name to fn.

Learn how to combine tables with union and union all, ensure matching fields, and manage duplicates to control whether results are unique in SQL queries.

Explore how joins combine two or more tables, covering inner, left, right, full outer (not available in MySQL), and cross (Cartesian) joins.

Explore inner join, left join, right join, and full outer join with graphical representations, showing how common elements between tables A and B determine outputs and noting MySQL limitations.

Identify common fields and build inner joins between tables using office code. Learn how foreign keys such as reports to relate customers and employees.

Explore sql joins with the employees one and employees two tables, using the script you can download and apply; the next session will show usage for more than two tables.

Learn to set up a joins database by creating four tables: employee names, country, department, and region, defining primary keys, inserting 30 records, and validating with queries.

Explore inner, left, right, and cross joins in SQL using sample tables, join conditions, and counting joined records for insight into data relationships.

Explore how to simulate a full outer join in MySQL by combining left and right joins and using union and union all, focusing on matching keys, column selection, and subqueries.

Compute city-level sales and revenue totals today and MTD using MySQL queries on two tables, with counts and sums by city and date.

Compute today's sales and month-to-date revenue by city, using sums and group by, while highlighting data linkage challenges and handling missing dates in revenue tables.

Explore using DB2 to divide an office code into three parts, join with city names, and produce a single record through concatenation and string aggregation, with a CTE and grouping.

Master Excel basics for professionals by navigating the grid with the cursor, creating and managing sheets, and applying alignment, auto fit, and formatting to build clear reports.

Explore essential Excel formatting and calculation, including borders, color, and alignment, auto fill and summation, plus formulas that start with = and cell references.

Learn basic spreadsheet operations in Excel, including sum, multiplication, subtraction, division, and the average function, using cell ranges and count functions (count, counta, countblank) with practical examples.

Explore essential spreadsheet techniques for business data: freeze headers, merge cells, apply data bars, and compute percentages with max, min, and total formulas.

Learn how to use pivot tables to create brand wise and city wise sales reports from a data set, summing quantities and calculating totals with fixed prices.

Master year-wise reporting with pivot tables, filtering by brands like Apple, Nokia, and LG, and creating dedicated sheets with copied values and formatted totals.

Learn to build pivot table reports to analyze region wise counts, gender wise distribution, month wise counts, and reason wise sales, using tabular layout, subtotals, and paste special as value.

Create pivot tables from the dataset to analyze sales by region and month, derive day, month, and year fields, and generate year-specific reports for 2019–2022.

Master conditional formatting in spreadsheets by applying color highlights, highlight cell rules, data bars, icon sets, and data validation to visualize data and emphasize key values.

Apply conditional formatting color scales to the data in column e, using color gradients to highlight high and low values and filter by color for visualization.