Data Analysis with SQL, Power BI, Advanced Excel and Tableau

This 100hrs (Lectures + hands-on Lab) Data Analysis training covers the four tools that appear together in almost every data analyst job description: SQL, Microsoft Power BI, Advanced Excel and Tableau. It is built as one continuous path rather than four separate courses. You start by querying a relational database directly in SQL - joins, window functions, CTEs, stored procedures and the indexing that keeps a query fast - because every reliable report begins with getting the right rows out. From there the same data is taken into Power Query and Power BI, modeled as a star schema, measured in DAX and published as an interactive report with row-level security. Advanced Excel then covers the ground analysts actually spend their days on: Tables, data validation, cleaning imported data, PivotTables and the Data Model, lookups and dynamic arrays, and enough VBA to automate the work that repeats. The course closes in Tableau, where the same modeling and calculation ideas are applied again - relationships and blends, level of detail expressions, table calculations - and finish in a published dashboard built from a brief.

Every session pairs the concept with time at the keyboard, so each topic is worked on a real dataset before the next one begins. It suits graduates moving into analytics, working professionals in finance, operations, marketing or IT who already live in spreadsheets, and developers and support engineers who want to move towards data roles. No prior SQL or BI experience is assumed; comfort with a computer and basic arithmetic is enough to start.