Powerpivot – Pardaan.com

PowerPivot in Excel 2013

I started the series in End of September and Starting of October on PowerPivot, Power View, PivotTable & Reports but in-between the release of Navision 2016 all the topics got scattered between other posts and I didn’t ended the topic. Bron : Ashwini Tripathi Lees meer...

26 October 2015

Dynamics NAV & BC Tips & tricks

Create a hierarchy in PowerPivot Data Model

Most Data Models include data that is inherently hierarchical. The Olympics data is also hierarchical. It’s helpful to understand the Olympics hierarchy, in terms of sports, disciplines, and events. Bron : Ashwini Tripathi Lees meer...

16 October 2015

Dynamics NAV & BC Tips & tricks

Add a relationship using Diagram View in Power Pivot

Open the Workbook which we prepared in the last exercise in our previous post. Add Excel Sheet/Table to the PowerPivot Data Model In the Power Pivot window, in the View section, click Diagram View. Use the slide bar to resize the diagram so that you can…

14 October 2015

Dynamics NAV & BC Tips & tricks

Add Excel Sheet/Table to the PowerPivot Data Model

Download the Excel file from the link provided in previous post. Import data using copy and paste from Excel sheet or other source for PowerPivot Data Model. Open the Workbook: Select sheet one by one and Add to Data model of PowerPivot. Make sure all Table/Sheet…

13 October 2015

Dynamics NAV & BC Tips & tricks

Import data using copy and paste from Excel sheet or other source for PowerPivot Data Model.

You can copy & Paste data from an Excel workbook, or import data from a table on a web page, or any other source from which we can copy and paste into Excel. In the following steps, you add the data from a table. Bron :…

12 October 2015

Dynamics NAV & BC Tips & tricks

PowerPivot Creating a Data Model in Excel 2013

Before you can create a PivotTable, you’ll need some data. Let’s get some data from the Navision database. In Excel, open a blank workbook. You have several options for getting data from no of sources. Recall from my earlier post where we accessed data using web…

9 October 2015

Dynamics NAV & BC Tips & tricks

PowerPivot for Excel

Power Pivot: Powerful data analysis and data modelling in Excel Power Pivot is an Excel add-in you can use to perform powerful data analysis and create sophisticated data models. With Power Pivot, you can mash up large volumes of data from various sources, perform information analysis…

8 October 2015