GKey IT

@UCwpWHW0kSXTG1VImZejV31g - 255 subscribers

Home Videos Live Playlists

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

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

14 views - 1 month ago

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

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

34 views - 1 month ago

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

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

20 views - 1 month ago

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

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

22 views - 1 month ago

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

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

38 views - 1 month ago

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

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

54 views - 1 month ago

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

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

14 views - 1 month ago

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

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

41 views - 1 month ago

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

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

42 views - 1 month ago

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

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

27 views - 1 month ago

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

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

25 views - 1 month ago

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

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

12 views - 1 month ago

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

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

13 views - 1 month ago

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

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

25 views - 1 month ago

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

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

33 views - 1 month ago

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

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

37 views - 1 month ago

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

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

31 views - 1 month ago

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

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

21 views - 1 month ago

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

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

23 views - 1 month ago

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

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

26 views - 1 month ago

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

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

14 views - 1 month ago

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

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

11 views - 1 month ago

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

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

10 views - 1 month ago

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

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

8 views - 1 month ago

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

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

16 views - 1 month ago

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

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

17 views - 2 months ago

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

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

21 views - 2 months ago

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

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

6 views - 2 months ago

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

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

16 views - 2 months ago

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

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

10 views - 2 months ago

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

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

18 views - 2 months ago

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

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

10 views - 2 months ago

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

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

2 views - 2 months ago

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

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

10 views - 2 months ago

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

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

3 views - 2 months ago

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

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

3 views - 2 months ago

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

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

13 views - 2 months ago

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

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

12 views - 2 months ago

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

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

15 views - 2 months ago

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

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

3 views - 2 months ago

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

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

5 views - 2 months ago

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

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

14 views - 2 months ago

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

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

53 views - 2 months ago

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

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

27 views - 2 months ago

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

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

26 views - 2 months ago

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

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

49 views - 2 months ago

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

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

14 views - 2 months ago

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

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

33 views - 2 months ago

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

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

76 views - 2 months ago

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

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

31 views - 2 months ago

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

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

21 views - 2 months ago

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

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

20 views - 2 months ago

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

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

45 views - 2 months ago

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

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

86 views - 2 months ago

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

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

25 views - 2 months ago

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

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

19 views - 2 months ago

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

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

9 views - 2 months ago

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

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

18 views - 2 months ago

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

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

30 views - 3 months ago

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

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

13 views - 3 months ago