What is Power BI? - Overview of Power BI and its significance - Components of Power BI - Power BI Desktop - Power BI Service (Cloud) - Power BI Mobile - Real-world applications in business intelligence - Power BI Workflow - End-to-end process (Extract, Transform, Visualize, Share)
Excel, CSV, SQL Server, Web APIs, Azure, and more - Import vs. DirectQuery - Differences and best use cases - Data Connection Management - Scheduling refresh and handling credentials
Introduction to Power Query Editor - Basic Transformations - Renaming columns, changing data types, removing duplicates - Advanced Transformations - Merging and appending queries - Pivoting and unpivoting columns - Handling null values and errors
Data Modelling Concepts - Fact Tables vs. Dimension Tables - Star Schema vs. Snowflake Schema - Creating Relationships - Cardinality and cross-filter direction - Calculated Columns and Measures - Differences, creation, and use cases
Basic Functions - Aggregation Functions `SUM`, `AVERAGE`, `COUNT` - Logical Functions `IF`, `AND`, `OR`, `NOT`- Intermediate Functions - Date and Time Functions `TODAY`, `YEAR`, `DATEADD` - Text Functions`CONCATENATE`, `LEFT`, `RIGHT`, `MID`- Statistical Functions `MAX`, `MIN`, `MEDIAN`- Filter Functions `FILTER`, `ALL` - Advanced DAX - Time Intelligence Functions `TOTALYTD`, `SAMEPERIODLASTYEAR`, `PARALLELPERIOD`
Basic Visualizations - Bar Charts, Line Charts, Pie Charts, Tables - Advanced Visualizations - Tree Maps, Funnel Charts, Gauge Charts, Maps - Custom Visuals - Importing and using from AppSource - Visual Interactions Filters, slicers, drillthroughs, and cross-filtering
Building Reports - Creating multi-page reports - Designing Dashboards - Combining visuals into cohesive stories - Formatting and Layout - Themes, color schemes, and best practices - Adding Interactivity - Using tooltips, bookmarks, and buttons
Publishing Reports - Uploading reports to Power BI Service - Datasets, Reports, and Dashboards - Understanding components and their interrelation - Sharing and Collaboration - Workspaces, sharing options, and permissions - Basics of Collaboration - Commenting and annotating
Connect to a Dataset - Prepare and Clean Data - Create Calculations and Visualizations - Build an Interactive Dashboard - Publish and Share on Public or Online
Introduction to Databases - What is a Database? Importance of databases in applications - Introduction to Database Management Systems (DBMS) - Types of DBMS: Relational, NoSQL, Object-Oriented, etc. - Overview of SQL and its role in relational databases (RDBMS
Introduction to SQL Server - What is SQL Server? Overview of RDBMS concepts - Overview of different SQL Server Editions (Express, Standard, Enterprise) - SQL Server Management Studio (SSMS) Introduction and Setup. - Installing and using SQL Server Management Studio (SSMS) for database management
Creating and Modifying Databases – Creating and Modifying Tables - Table Constraints - - Primary Keys (`PRIMARY KEY` constraint) - Foreign Keys (`FOREIGN KEY` constraint) - Unique Constraints (`UNIQUE` constraint) - Default Values (`DEFAULT` constraint) - Check Constraints (`CHECK` constraint). - Operators, Data Types, and Type Conversion - Arithmetic Operators - Comparison Operators - Logical Operators – BETWEEN, IN, LIKE for pattern matching - IS NULL and IS NOT NULL operators. - SQL Server Data Types - Type Conversion
Inserting Data - Updating Data - Deleting Data
Basic Querying with `SELECT - Filtering Data with `WHERE - Sorting Results Using `ORDER BY` to sort records in ascending (`ASC`) and descending (`DESC`) order. - Conditional Logic with `CASE`- Using Aggregate Functions - Group By, Having, - Difference between `WHERE` and `HAVING`- Using `HAVING` with aggregate functions.
Common string functions: `LEN()`, `SUBSTRING()`, `CHARINDEX()`, `UPPER()`, `LOWER()`, `REPLACE()`, `LEFT()`, `RIGHT()` - Concatenating strings with `+` or `CONCAT()`. Date/Time Functions in SQL Server - Getting the current date/time (`GETDATE()`, `SYSDATETIME()`) - Adding/subtracting dates (`DATEADD()`) - Finding the difference between dates (`DATEDIFF()`) - Extracting parts of a date (`YEAR()`, `MONTH()`, `DAY()`)
Introduction to Joins - What are joins? Why do we use them - Types of Joins - INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN, CROSS JOIN, SELF JOIN
Understanding Transactions - `BEGIN TRANSACTION` - `COMMIT TRANSACTION`- Committing the transaction - `ROLLBACK TRANSACTION` - `SAVEPOINT` - SQL Server Privileges and Subqueries - Granting Permissions - Revoking permissions - Role-based permissions in SQL Server.
Using subqueries in `SELECT`, `WHERE`, `FROM`, and `HAVING` clauses - Correlated Subqueries vs Non-Correlated Subqueries - Subqueries in `JOIN` conditions - Indexes - Creating indexes - Removing indexes - Clustered vs Non-Clustered Indexes. - Impact of indexes on performance (index maintenance, over-indexing).
Views – Creating Views - Modifying views – Removing Views - Using views for complex query simplification - Stored Procedures - Creating stored procedures - Executing stored procedures (`EXEC`) - Input/output parameters in stored procedures - Error handling in stored procedures with `TRY...CATCH – Triggers - Creating triggers `INSERT`, `UPDATE`, `DELETE` operations - BEFORE and AFTER triggers.
Installation and Working with Python Understanding Python variables Python basic Operators Understanding python blocks
Declaring and using Numeric data types: int, float, complex Using string data type and string operations Defining list and list slicing Use of Tuple data type
Conditional blocks using if, else and elif Simple for loops in python For loop using ranges, string, list and dictionaries Use of while loops in python Loop manipulation using pass, continue, break and else Programming using Python conditional and loops block
Organizing python codes using functions Organizing python projects into modules Importing own module as well as external modules Understanding Packages Powerful Lamda function in python Programming using functions, modules and external packages
Building blocks of python programs Understanding string in build methods List manipulation using in build methods Dictionary manipulation Programming using string, list and dictionary in build functions
Reading config files in python Writing log files in python Understanding read functions, read(), readline() and readlines() Understanding write functions, write() and writelines() Manipulating file pointer using seek Programming using file operations
Concept of class, object and instances Constructor, class attributes and destructors Real time use of class in live projects Inheritance , overlapping and overloading operators Adding and retrieving dynamic attributes of classes Programming using Oops support
Powerful pattern matching and searching Power of pattern searching using regex in python Real time parsing of networking or system data using regex Password, email, url validation using regular expression Pattern finding programs using regular expression
Avoiding code break using exception handling Safe guarding file operation using exception handling Handling and helping developer with error code Programming using Exception handling
SQL Database connection using python Creating and searching tables Reading and storing config information on database Programming using database connections
Understanding threads Forking threads Synchronizing the threads Programming using multithreading
