Hello @sivareddy3745, You are most welcome. We try to provide dynamic solutions to any Excel-related problem. Thanks for watching our videos. Keep learning Excel with ExcelDemy! Regards ExcelDemy
@BoxCarWillieC2CBUTTERFIE-nw8pj
2 ай бұрын
Finally Got PP to work. I have been working with "append" tables. This is so much easier. TY. I need the calculation option.
@exceldemy2006
2 ай бұрын
Dear, Thanks for your questions! We are glad to hear that you finally got Power Pivot working. This video focuses on creating data models using relationships between tables. However, depending on your goal, you can use DAX formulas within Power Pivot to create calculated columns or measures after appending your data.
@Kiyansh_Shaha
2 ай бұрын
Very well explained…but curious to know why different methods are available? Is there any extensive use of data models created through power query i.e # 2 you explained?
@exceldemy2006
2 ай бұрын
Dear, Thanks for your compliment! Your appreciation means a lot to us. Using Power Query to create a data model is particularly beneficial when preparing and cleaning your data extensively before analysis. It helps by automatically sorting out your data and ensuring it is clean and organized. This saves you a ton of time, especially if you're dealing with big piles of data that need a lot of work. Basically, the method you choose depends on your needs. If you want something simple, go for the primary process. Try the Power Query method if you need to clean up your data before using it.
@justinhare905
5 ай бұрын
That's great.
@exceldemy2006
4 ай бұрын
Hello @justinhare905, Thanks for your appreciation. Please stay connected with us. Regards ExcelDemy
@DequanHarrison
2 ай бұрын
I understand the use case for using power query for automation. But, what are the advantages and disadvantages of using Relationship tool vs PowerPivot.
@exceldemy2006
2 ай бұрын
Hello @DequanHarrison, In the video, we skipped the theory part, sorry for that. Here are the advantages and disadvantages of using the Relationship tool vs. PowerPivot in Excel: Relationship Tool: Advantages: 1. Simple for linking tables. 2. Suitable for simple data models without complex calculations. Disadvantages: 1. Lacks advanced features for complex data analysis. 2. May not efficiently handle large datasets or complex queries. PowerPivot: Advantages: 1. Supports complex calculations, measures, and KPIs. 2. Optimized for large datasets and complex models. Disadvantages: 1. Requires more advanced knowledge to use effectively. 2. Needs the PowerPivot add-on, which might not be available in all Excel versions. Regards ExcelDemy
@BoxCarWillieC2CBUTTERFIE-nw8pj
2 ай бұрын
Is PP closer to PowerBI ? @@exceldemy2006
@BoxCarWillieC2CBUTTERFIE-nw8pj
2 ай бұрын
Can you create simple video on working with calculations on tables with PP?@@exceldemy2006
@exceldemy2006
2 ай бұрын
Dear, Thanks for your queries! Yes, Power Pivot is similar to Power BI. Both use the same core technology. However, Power BI is more advanced for making interactive reports and dashboards. If you know Power Pivot, Power BI will feel familiar and more powerful.
@satishreddy1497
5 ай бұрын
So we can get pivot table fields by three ways
@exceldemy2006
4 ай бұрын
Hello @satishreddy1497, There are more than 3 ways to get pivot table fields these are: 1. Drag and Drop 2. Field List Checkbox Selection 3. Pivot Table Field List Pane 4. Right-Click Menu 5. Using Field Buttons 6. Keyboard Shortcuts 7. Excel VBA Regards ExcelDemy
@edmel144
2 ай бұрын
What is a peckeo?
@exceldemy2006
2 ай бұрын
Hello @edmel144, Here, "SalesPQ" and Executives PQ" are table names. You can use any name of your convenience. These tables are used in further calculations. Regards ExcelDemy
Пікірлер: 20