NerdTechGuru

206 subscribers

41 videos

Hello Everyone, First of all, I would like to thank you for viewing my channel and yes Welcome to the most amazing place in the Internet World. This Channel ...

Latest Videos

Video Demo

Excel Quick Tip 01Copy Data from Access to excel and format it

2018 07 31 23 49 27

Excel advanced feature-Power Pivot

Excel Case Study on Logistic Data-(A)

10 M2M Relationship Bridge Table

9.Power Pivot Advanced Feature Perspectives

8.Power Pivot advanced Feature KPI

7.Basic DAX Concept

6.Formatting Capability in Power Pivot

5.Create Pivot Table using joined Tables in Power Pivot

4.Joining or linking Tables in Power Pivot

3.Joins Concepts

2. What is Compress Capability in Power Pivot

1. How to Import Data to Power Pivot data model

10. Excel Power Query Merge Tables

9. Excel Power Query Append Tables

8. Excel Power Query Transform Split Columns

7. Excel Power Query Transform- How to use Pivot and Unpivot feature

6.Excel Power Query Transform- How to use Transpose Feature

5.Excel Power Query Transform- How to Find and Replace Value

4.Excel Power Query Transform- How to use Group By

3.Excel Power Query Transform- How to Remove Rows & Columns

2. How to Load From Folder in Excel Power Query Model

10 Insert Data to the Table

1. How to Load Data to Power Query Model

9 Create Table

8 Default Constraint

7 Check Constraint

6 Foreign Key Constraint