Part-34: What is Foreach ADO.NET Schema Rowset Enumerator from Foreach Loop Container in SSIS #ssis

Class-32: Difference Between CALCULATE and CALCULATETABLE in Power BI #sqlserver #powerbi #database

Class-31: Difference between SUM and SUMX in DAX in Power BI #sqlserver #powerbi #databaseconcepts

Class-30: What is DAX in Power BI #sqlserver #powerbi #databaseconcepts #programming

Class-29: Difference between Aggregation Tables and Normal Tables in Power BI #sqlserver #powerbi

Class-28: What is a Composite Model in Power BI #sqlserver #powerbi #databaseconcepts

Class-27: How to Create a Calendar Table Using DAX in Power BI #sqlserver #powerbi #databaseconcepts

Class-26: When should you use Calculated Tables in Power BI #sqlserver #powerbi #databaseconcepts

Class-25: Difference Between Calculated Columns and Measures in Power BI #powerbi #sqlserver

Class-24: How do you create hierarchies in Power BI #powerbi #sqlserver #databaseconcepts

Class-23: Explain Surrogate Keys in Power BI Data Modeling #powerbi #sqlserver #databaseconcepts

Class-22: How do you handle circular dependencies in Power BI #sqlserver #powerbi #databaseconcepts

Class-21: What are bi-directional filters and When should you avoid in relationships? #powerbi

Class-20: Difference between active and inactive relationships in Power BI #sqlserver #powerbi

Class-19: How do you handle many-to-many relationships in Power BI #sqlserver #powerbi #database

Class-18: Difference between fact and dimension tables in Power BI

Class-17: What are star and snowflake schemas in Power BI #sqlserver #powerbi #databaseconcepts

Class-16: How to Create a Date Table Using Power Query #sqlserver #powerbi #database

Lesson-21 What are performance tuning & optimization techniques? Which covers DB,ETL,BI performance

Lesson-20: What is reporting and analytics layer like BI fundamentals and SQL for BI in DW?

Lesson-19 What is data quality framework-accuracy,completeness,consistency,validity,timeliness in DW

Lesson-18: What are data governance concepts like Master Data, Metadata, Data lineage Concepts in DW

Lesson-17: Explain OLAP technologies like MOLAP, ROLAP, HOLAP, cubes and aggregations in DW

Lesson-16: what are diff DW storage models? Like normalized versus dim, columnar, MPP storage model

Lesson-15: What are the 1st , 2nd & the 3rd normal form and the 3rd normal form rules

Lesson-14.3: Scheduling ETL in ETL Architecture #datawarehousing #databaseconcepts #sqlserver

Lesson-14.2: ETL Architecture: Reusable ETL Frameworks #databaseconcepts #datawarehousing #sqlserver

Lesson-14.1: ETL architecture detailed explanation #datawarehousing #sqlserver #databaseconcepts

Lesson-13: The difference between facts and measures in data warehousing #datawarehousing #sqlserver

Lesson-12: What are diff types of measures in data warehousing? Like semi-additive, and non-additive

Lesson-11: What are diff types of facts additive, semi-additive, non-additive, factless & degenerate

lesson-10: What are Fact Types in DW like Transaction, Snapshot, Accumulating Snapshot, Factless

lesson-9.2: What are Shrunken, Inferred, Outrigger, Static/Stacked & Hierarchy Dimension in DW

lesson-9.1: What are Conformed, Role-Playing, Junk, Degenerate Dimension & Slowly Changing Dimension

lesson-8: What are Star Schema, Snowflake Schema & Galaxy Schema in Dimensional Modeling

lesson-7: What are Fact Dimensional Tables, Measures & KPIs, Grain & Surrogate Keys in Data Modeling

Lesson-1: What is a Data Warehouse #database #programming #sqlserver #datawarehousing

Lesson-6: The Difference between Data Mart vs Data Warehouse #database #sqlserver #datawarehousing

Lesson-5: What are Differrent Tiers In Datawarehousing #databaseconcepts #sqlserver #datawarehousing

Lesson-4: Basic Architecture of a Data Warehouse #databaseconcepts #sqlserver #datawarehousing

Lesson-3: Benefits of a Data Warehouse #databaseconcepts #sqlserver #datawarehousing #programming

Lesson-2: The Diff Between OLAP and OLTP #database #sqlserver #datawarehousing #programming

Class-15: What is Inceramental Refresh in Power BI #powerbi #sqlserver #database #programming

Class-14: What are Gateways and why they are used in Power BI #powerbi #sqlserver #database

Class-13: What is Inceramental Refresh in Power BI #database #sqlserver #powerbi

Part-70: What is Script Task in SSIS #databaseconcepts #sqlserver #ssis #database #programming

Part-69: What is Script Component in SSIS #databaseconcepts #sqlserver #ssis #database #programming

Part-68: What is Data Profiling Task in SSIS #database #sqlserver #ssis #databaseconcepts

Part-67: What are Environment Variables and how they use in Project Deployments in SSIS #sqlserver

Part-66: How to Schedule SSIS Package using Task Scheduler #database #sqlserver #ssis

Part-65: How to schedule Package in SSIS #database #sqlserver #ssis #databaseconcepts #programming

Part-64: What is Package Deployment in SSIS and the diff among the Project and Package deployments

Part-63: How to Deploy ISPAC file into Integration Services Catelogues in SSIS #ssis #sqlserver

Part-62: How to do Project Deployment into Integration Services Catalogs from Visual Studio #ssis

Part-61: How to Redirect Error Output in DataFlow Task in SSIS #database #sqlserver #ssis

Part-60: What are Precedence Constraints in SSIS #database #sqlserver #ssis #databaseconcepts

Part-59: What are Transactions in SSIS #sqlserver #database #ssis #programming #databaseconcepts

Part-58: What are checkpoints in SSIS #sqlserver #database #ssis #databaseconcepts #programming

Part-57: What are Sql Server Configurations for a Package in SSIS #database #sqlserver #ssis

Part-56: What are XML Configurations in SSIS and other types of Configurations in SSIS #sqlserver