Excel’s Power Pivot is a standard Excel desktop feature. Power Pivot along with Power Query with Pivot table and Pivot Chart is the wonderful combination in the Excel for data analysis of huge data sets. To enable Power Pivot menu, simply right click on the toolbar and then select customize this ribbon. Over to the right here make sureContinue reading “All about Power Pivot”
Tag Archives: Power Query
Excel Automation using Power Query
Microsoft Excel includes a powerful feature called Power Query—also known as Get & Transform or Get Data—which provides fast and powerful data gathering and cleansing capabilities. A biggest advantage of Power Query & Power Pivot is, you can have large amounts of data compressed and stored in memory to transform and analyze anytime for creatingContinue reading “Excel Automation using Power Query”
A-Z of Power Query
Create Low Code Automated Dashboard Are you finding difficult to learn VBA – Macros like me? Are you taking more time to clean & transform your data like me? Are you looking for “Low code options to perform ETL process like me? Bored of doing repetitive tasks in Excel? Power Query & Power Pivot isContinue reading “A-Z of Power Query”
LR Virtual Classroom 