Category: BI

Two Ways To Improve Your Power BI Visuals Right Now

With the March release of Power BI, we saw two new features that I have been waiting for – Report Theming and Cross-highlighting and drillable

March 24, 2017

Supercharge Your Dynamics GP Dashboards & Reports with Power BI

During my last blog post, I walked you through creating a financial dashboard using Power BI with Dynamics GP data. I have created additional measures

March 14, 2017

Wow! A Dynamics GP Multi-Company Financial Dashboard: Part II

Back in September of 2015, I posted a blog about how to modify Jared Hall’s awesome Excel Financial Dashboard that you can download. The problem

February 28, 2017

Power BI – New Features and Need for Big Data Functionality

With January’s Power BI update, two items that I was looking forward to have been released. The first one was the public preview of email

February 8, 2017

Power BI Visuals in SSRS 2016 Web Site

Yesterday, January 17, 2017, Microsoft released the Power BI reports in SQL Server Reporting Services (SSRS) technical preview. I downloaded the technical preview and installed it

January 18, 2017

Dynamic Security – additional thoughts

Introduction Recently I posted a blog titled “How to implement Analysis Services Dynamic Security based on Microsoft CRM User Access Rights.” That post talked about

November 29, 2016

Get Your Self-Service On!

Do you need to make an immediate or occasional one-time backup of your Dynamics GP databases, or maybe run a SQL job that populates your BI360 Data Warehouse? Occasionally, you may be performing some month-end closing procedures, post a large, significant batch, or perhaps you are about to integrate a large amount of your Dynamics GP data into your BI360 Data Warehouse. It’s critical that you make a good set of database backups to use in recovery in case of a failure, in order to refresh your Dynamics GP data into your Data Warehouse without IT involvement. There are several ways you can create a one-time backup or run other SQL jobs, like refreshing your Data Warehouse for month-end reporting. Here are some easiest ways, with some of the tools most people are familiar with:

May 11, 2016

The Two Power Players – Power BI and CRM

At the 11th Annual KTL User Conference, I will be presenting a session on Power BI and Dynamics CRM data. The main goal is to give users an easy way to present information in a timely and simple-to-understand format. In the session, using Power BI, we will cover the process of building and accessing refreshable dashboards with information from Dynamics CRM and Dynamics GP. In the session we will discuss/demo the following:

April 27, 2016

Design Best Practices to Build Killer Dashboards

When buying real estate its all about location, location, location. Like real estate, dashboards or data visualizations are all about one thing – data, data, data. With that in mind, here are some of my data visualization best practice design tips. Make your data visualization:

March 2, 2016

What’s New with Microsoft’s BI Stack

Microsoft has made a large investment in BI in 2015, both on-premises and in the cloud. BI offerings across Datazen, R, Excel, Power BI and coming to SQL Server 2016 are huge. Microsoft released a public BI roadmap on where they are headed with their BI stack. Microsoft’s simple goal is to put the power of data in the hands of every business user. This simple goal is inline with the #1 top ranked IT priority according to Gartner.

January 27, 2016