Tags » EDW

Use Power BI and R to Quickly Identify Business Insights

In statistics, the correlation coefficient or Pearson’s correlation is a measure the strength and direction of association that exists between two continuous variables. The value of correlation, r, is always between +1 and –1. 369 more words

BI

Data Lake and Data Warehouse

This is an old topic but I learned more and come up more perspectives over time.

  • Raw Data vs Clean Data
  • Metadata
  • What kind of services are required?
  • 443 more words
Business Intelligence

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 analysis and measures now. 236 more words

BI

WOW! A Dynamics GP multi-company Financial Dashboard - Part Deux

Back in October of 2015, I posted a blog about how to modify Jared Hall’s awesome Excel Financial Dashboard that you can download here. The problem with his solutions is that most Dynamics GP environments are multi-company setups making these dashboards not very functional without navigating and opening multiple Excel spreadsheets to view each company’s dashboard. 334 more words

BI

Winnipeg is Officially a Winter City

It’s official, Winnipeg is now an official winter city! Winnipeg can now own “Winterpeg.”

In a ceremony held at the Assiniboine River on January 30, 2017, the City of Winnipeg and Economic Development Winnipeg Inc. 359 more words

Winnipeg News

Schema-less or Schema On Demand

I am trying to define what are the criteria for a schema-less, or a schema on demand data storage.

In relational database, we use DDL, data definition language, to define schema. 739 more words

Business Intelligence

QlikSense + WFE Troubleshooting

If you are publishing the QlikSense EDW against the public internet, you may run into some strange problems. Here is a short list of configurations to check on the Internet server utilizing QlikSense for Web Ticketing, fetching Hypercubes etc. 178 more words