Excel - Power Pivot and Power Query Overview

preview_player
Показать описание
Do you work with, analyze and generate reports from large datasets in Excel? Do you need to create pivot tables from multiple datasets?
Do you spend too much time cleaning up imported data before it can be used?

If the answer to any of these questions is Yes then having a good understanding and working knowledge of Power Query, Power Pivot and the Excel Data Model is a must! If you'd like to know more about these tools, watch this short video

Рекомендации по теме
Комментарии
Автор

Robustly clarified the confusion between two concepts. Very well done! Thanks

ahmedshakebzubairi
Автор

Superb explanation, clear and concise.

mokhan