Facebook Twitter LinkedIn YouTube E-mail RSS
Home Posts tagged "BI" (Page 3)
formats

Create a Dynamic Median MDX Calculation on a PerformancePoint KPI Scorecard

Share

Have you ever been asked to add a new KPI to a scorecard, only to find that there is not a corresponding calculation or measure in the cube?  With PerformancePoint 2010 KPIs for SharePoint 2010 scorecards, custom MDX expressions can be created as actual and target values without requiring modifications to be made to the

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

Free On-Demand Webinar: GNet Group’s Approach to Agile BI Using SQL Server 2012

Share

There is always pressure from business users to deliver flexible, fast, self-service and cost effective BI/Data Warehouse solutions. Going into a BI project, we expect that business requirements will evolve and change; one business question will lead to another, which will create challenges in managing scope, iterations, timelines and costs. With a traditional waterfall BI

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

PowerPivot as a Documentation Browsing Tool Using CMS EHR Data

Share

PowerPivot is a versatile tool that can be used for many purposes.  Mash-up data from different sources, rapidly create BI dashboards, or use PowerPivot as a data modeling tool for development of an Enterprise Data Warehouse.  This post will focus on another use that can be useful for PowerPivot, a tool for optimizing the browsing

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

Farmers Market Data on a BI Map in Excel 2013

Share

In the Upper Midwest, August is the best time of year for the greatest variety and the most abundant supply of produce at local Farmers Markets.  Different vegetables, fruits, and other locally sourced products are available in numerous hierarchies of variety.  What better time than now to create a Business Intelligence map using Excel 2013

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

Create a BI Pareto Chart with a PowerPivot Data Model in Excel

Share

A couple of years ago I posted a video demonstrating the process by which to create a Pareto Chart in Excel using an SSAS cube data connection.  As a follow-up to that video, this post will walk through the process by which to create a Pareto Chart in Excel 2010 using a PowerPivot data model

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments