What Will You Learn?

• Introduction to relational databases
• Fundamental concepts of Datawarehouse, OLTP and OLAP
• Logical and relational operators
• Constraints
• Primary key
• Foreign key
• Installation of SSMS (SQL Server Management Studio)
• What is SQL?
• Overview of SQL (Structured Query Language)
• DDL and DML Commands
• Create Database using Management Studio
• Datatypes in SQL Server
• Create, Alter, and Drop Table
• Insert, Update, and Delete Statements
• Truncate Statement
• Basic SQL Syntax
• Queries (SELECT, WHERE)
• Filtering and Sorting Data (ORDER BY, LIMIT)
• Data Selection
• SELECT Statements
• DISTINCT keyword
• Filtering Data
• WHERE Clause
• BETWEEN, IN, and LIKE operators
• Sorting and Limiting
• ORDER BY, LIMIT, OFFSET
• Aggregate Functions
• COUNT(), SUM(), AVG(), MIN(), MAX()
• String Functions
• CONCAT(), SUBSTRING(), REPLACE(), LENGTH()
• Introduction to Joins
• INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN
• Common Table Expression (CTE)
• Subqueries
• Row_Number(), Rank(), Dense Rank()
• Overview of Power BI
• Power BI licensing
• Introduction to Power BI terminology
• Power BI tools and building blocks
• Power BI desktop overview
• Getting data from various sources
• Data connectivity modes
• Power Query editor overview
• Data types in Power BI
• Data transformation in Power Query editor
• Model optimization in Query Editor
• Overview of modelling and schemas
• Modelling data in Power BI
• Data cardinality types
• Cross filtering and connection type (Active/Inactive)
• Introduction to DAX
• Calculated columns, measures, and quick measures
• Aggregation, Date & Time, Filter, Logical, and Information Functions
• Filter context in calculation
• Operators in DAX
• DAX performance
• Introduction to visualization
• Usage of visuals
• AI and custom visuals overview
• Visual formatting and analytical features
• Managing and arranging the visuals
• Grouping, selection pane, bookmarks, buttons
• Tooltip, drill down, and drill through functionality
• Introduction to dashboards
• Dashboards vs reports
• Creating dashboards
• Introduction to workspace
• Introduction to app
• Publishing datasets or reports in Power BI
• Sharing workspace and app
• Refreshing a dataset
• Exporting data from visuals
• Exporting report as PPT or PDF
• Analyzing report in Excel
• Bookmarks in Power BI
• RLS (row level security)
• Gateway
• Manage Parameters