Using PowerPivot to analyze MS Dynamics NAV

  •        0

Project show how to prepare MS Dynamics NAV data for analyzing in PowerPivot for Excel. Project include Data Warehouse demo database, sql procedure to transfer data from Navision to DW and Excel example. Happy BI for NAV.



Related Projects

PowerPivot Sample Data and Resources

You can use PowerPivot sample data to learn how to use PowerPivot for Excel by completing the tutorial, exploring Data Analysis Expressions (DAX), and trying out the features. You can use the scripts and other tools to help you use and manage the PowerPivot solutions you create.

Excel Services PowerPivot Sample Data

SQL Server 2012 sample data for Excel Services PowerPivot Tutorial.

SharePoint 2013 Business Intelligence Demo Builds with SQL Server 2012 SP1

This project through the use of Content Packs for SelfService BI, ECM, and BigData, will bring you demos based on Contoso Telco, Great White Gears, and more.


Date table feed designed for import into an Excel PowerPivot model. The table contains columns particularly suitable for time business intelligence applications. Delivered through the Azure Data Market, it is effortlessly available through the PowerPivot window in Excel. Th...

Monitor Reporting Services with PowerPivot

PowerPivot workbook with a connection to Reporting Service log. Several built in reports are already created in the workbook. You will need to connect to the execution log 2 view in your report server database. Typically the report server Database is named ReportServer. The...

Excel and PowerPivot Refresh Suite

A command line utility for refreshing Excel data, as well as a Windows service which monitors and periodically refreshes a folder of Excel files.

Dynamics NAV UniWPF Addin

This project is Addin control for Microsoft Dynamics NAV 2009, allowing developers to put WPF controls directly to NAV page.

DAX Studio

Excel Add-In for PowerPivot and Analysis Services Tabular projects that will include an Object Browser, query editing and execution, formula and measure editing ,syntax highlighting, integrated tracing and query execution breakdowns.

Dynamics AX - Cloud RIA BI SOA Silverlight WCF

Dynamics AX - Cloud RIA BI SOA Silverlight WCF

Microsoft Dynamics CRM Analytics Foundation

Microsoft CRM Analytics Foundation is a business intelligence solution accelerator for Microsoft Dynamics CRM 3.0 customers and partners. With Analytics Foundation, executives can better track and manage business performance with dashboards and KPIs. Managers and employees c...

Microsoft Dynamics AX 2012 – Generic End User Transactional Report Writer

A PoC to illustrate how to create a generic end-user transactional report writer for Microsoft Dynamics AX 2012.

MS Dynamics CRM 2011 - Import - Data Exception Report

Report allows you to export information about data exceptions during loading data. Report is using FetchXML supporting Dynamics CRM 2011 OnPremise and Online


Magento scripts for inventory sync, order export, and shipment imports. IO files formatted for Microsoft Dynamics Navision (ERP).

Power-BI-Solution-Template - This project contains accelerators for partners and customers to quickly get set up with enterprise ready dashboards and solutions

The Power BI Sales Management Solution Template reduces the time to implement a Power BI solution on Dynamics CRM or Salesforce.Two deployment options are available depending on customer requirements. Both approaches benefit from fast ETL loads with incremental updates. Where they differ is where the model and data reside.

BI Architecture and Design Guide

This release is an outcome of an exploratory project done by the P&P group (Microsoft) to understand the BI Landscape, Challenges and Common Solutions. The Architecture and Design Guidelines for BI Applications provides prescriptive guidance on how to overcome architectural ...

Developer Toolkit for Dynamics AX 2012

A Developer Toolkit for Microsoft Dynamics AX 2012 with the following main features: - An extension to the TFS integration, providing the Developer more guidance while working on issues/tasks within Dynamics AX; - Support of Release management within Dynamics AX.

Dynamics XRM Tools

Dynamics XRM Tools offers a range of tools that provide a useful set of features to enhance your experience while using and developing against Dynamics CRM.

Microsoft Dynamics CRM Query - T4 Template

In short, this project provides a LINQ style data access solution for Microsoft CRM 4.0. It provides a T4 Template that generates code leveraging LINQ to SQL and the MS-CRM 4.0 API to give a MS-CRM CRUD data access solution. Special Support for WCF RIA Services is also provided

ASynK - Flexible Bi-directional sync for Emacs BBDB, Google Contacts, and MS Outlook

Flexible Bi-directional sync for Emacs BBDB, Google Contacts, and MS Outlook


XrmSvcToolkit is a small JavaScript library that helps you access Microsoft Dynamics CRM 2011 web service interfaces (SOAP and REST).