Microsoft Dynamics Blog

Welcome to Armanino’s Microsoft Dynamics Blog, where you’ll find information on topics across Microsoft Dynamics 365 ERP and CRM, Dynamics GP, Power BI, PowerApps, Flow and more. Use these tips, tricks and insights to get the most out of your applications! Want these articles delivered straight to your inbox? Subscribe to our newsletter below.

Wednesday, November 21, 2018

Is Power BI Open Source?

Before answering this, let’s look at open source definition. According to whatis.com – “open source refers to any program whose source code is made available for use or modification as users or other developers see fit. Open source software is usually developed as a public collaboration and made freely available.” Based on the definition above, the short and technical …

Tuesday, September 11, 2018

Where’s My SmartList? Migrating from GP to D365 F&O

Many Microsoft Dynamics GP clients have come to rely on SmartList as a way to get data out of GP in order to build Excel-based reports. SmartList allows you to connect different tables, providing a single view with general ledger (GL) account detail alongside descriptions and vendor or customer details. But companies moving from GP …

Wednesday, June 27, 2018

Don’t Miss Microsoft’s Business Applications Summit

There is a new Microsoft conference that we are really looking forward to: the Business Applications Summit, taking place on July 22–24 in Seattle (which by the way, is really nice that time of year). The event blends the best aspects of Microsoft’s former Data and Analytics Summit, its Convergence event and the Dynamics 365 …

Wednesday, May 2, 2018

Focus 2018: D365, AXUG, CRMUG & PUG

This year, the Dynamics User Community’s Focus 2018 conference is May 21- 24 in Indianapolis. Armanino is excited to present two different topics. Our first session, “Cloud-Only Data Warehouse and BI? Yes, You Can!” will cover the Azure components you need to build a D365-based data warehouse and Analysis Services environment in Azure. In this …

Friday, March 23, 2018

What You Need to Know About GDPR and Your Business Analytics

GDPR, or the General Data Protection Regulation, is big. Really big. Are you ready for the May 25 deadline? For companies using business analytics and pulling data from different systems, the new GDPR requirements on documenting data flows can be overwhelming. But they don’t have to be. First, does GDPR affect you? Instituted by the …

Monday, August 1, 2016

AXUG NorCal: Power BI for Dynamics AX and CRM

Interested in learning about Power BI for Dynamics AX and Dynamics CRM? Join us for the upcoming AXUG NorCal chapter meeting with leading high tech manufacturer, Maxlinear and Noah Kluge, Armanino’s BI guru (and five-time UG Summit Speaker) to hear lessons learned, best practices, tips and tricks and results of implementing Power BI for Dynamics …

Wednesday, June 1, 2016

AXUG Focus: BI & Reporting, Finance, & Technical Sessions

AXUG Focus is fast approaching! Focus is just that – focused on three specific learning tracks: Finance, BI & Reporting, and Technical. All sessions are a deep-dive into these essential topics. Armanino’s Business Intelligence (BI) team is excited to be participating in the event. BI expert Noah Kluge will be presenting SSAS Tabular Model – Why Tabular vs …

Tuesday, April 19, 2016

Microsoft Power BI: The Pace of Rapid Change

Is anyone else out there surprised by the rapid progress that has been made recently with Microsoft Power BI? After all, there have been at least a few times where the Microsoft plan for business intelligence seems to have fizzled. Early last year, I was certainly not the biggest fan when it came to Power BI. Honestly, …

Tuesday, March 22, 2016

Gartner Magic Quadrant for Business Intelligence & Analytics Released for 2016

The 2016 Gartner Magic Quadrant for Business Intelligence (BI) and analytics was recently released. This year marks a substantial change in the evaluation criteria with the emphasis focused more on end-user autonomy delivered through self-service tools that allow for rapid ad hoc development. The traditional IT-led software vendors will be assessed in a new market guide focused on …

Tuesday, March 8, 2016

Why Can’t I Get Transactional Detail with My BI Dashboard?

Our business intelligence (BI) team often receives this request around a BI dashboard: we want to see transaction document number details (e.g. sales invoice, purchase order) alongside visually pleasing charts and key performance indicators (KPIs). Unfortunately, the answer with a traditional, multi-dimensional cube is simple: you can’t. You could build into the cube the ability …

Next Page »