Renaming a Server with SharePoint 2010

Posted on September 1, 2011 by BIAnalytix Team

From time to time, you will require a server to be renamed where you have an instance of SharePoint 2010 installed. For example, you may want to clone and rename a server for backup purposes and use it on the … Continue reading →

Posted in Data warehouse and Business Intelligence Operations | Tagged , | 1 Comment

HTML Formatted sp_send_dbmail For Smartphones

Posted on August 23, 2011 by BIAnalytix Team

Sometimes, during long running, late night ETL processes, being alerted when things fail is too nerve wracking for comfort. Waiting around for hours for the hammer to fall can be trying. Having to log into the system and continually run … Continue reading →

Posted in Data warehouse and Business Intelligence Operations | Tagged , , | Leave a comment

SSIS Data Sources in Configuration files

Posted on August 11, 2011 by BIAnalytix Team

One of the best ways to make your SSIS packages easily moveable between environments is to use configuration files to store Data Connections. Once you have created your SSIS Package click on the main control flow window and select “SSIS” … Continue reading →

Posted in Actionable Media Intelligence, General Information, Media Business Intelligence Presentation Performance, Media Data Warehouse and Business Intelligence Benefits | Leave a comment

2011 Microsoft Partner of the Year Award Finalist!

Posted on July 26, 2011 by Decentrix Team

Decentrix is honored to announce that it has been selected as one of two (2) finalists for the Microsoft Communications Sector 2011 Partner of the Year Award. Awards were presented in mid July 2011 for multiple categories, with winners and … Continue reading →

Posted in General Information | Tagged , , , , , | Leave a comment

Cube Synchronization through Analysis Services DDL Tasks in SSIS

Posted on July 25, 2011 by BIAnalytix Team

One of the most common things we do in the Business Intelligence (BI) world is to process and synchronize OLAP cubes. There are several methods people use for synchronizing, each with their own benefits, but normally we use the XMLA … Continue reading →

Posted in Data warehouse and Business Intelligence Operations | Tagged , , , , , | Leave a comment

BI on the Windows Phone 7 Platform

Posted on July 15, 2011 by BIAnalytix Team

The intention of this series of blog posts is to show developers the process of setting up, creating, maintaining, and delivering meaningful Business Intelligence content using the Windows Phone 7 mobile platform as the end user client side component. Getting … Continue reading →

Posted in Intelligence Reporting Techniques | Tagged , | Leave a comment

Moving Sharepoint Content to a New Environment

Posted on July 7, 2011 by BIAnalytix Team

The situation often arises when users want to move the content of one SharePoint site to another. The reason could be because content was created in a development environment and needs to be moved to production or the reason could … Continue reading →

Posted in Intelligence Reporting Techniques, Media Portals | Tagged , , , | Leave a comment

Cube Data Ranking by Dimension

Posted on June 23, 2011 by BIAnalytix Team

There are many business requests to rank aspects of their business by the revenue that is generated. Adding new rankings as new dimensions expands the footprint of a cube and can reduce cube build and query performance. Instead of adding ranking dimensions BIAnalytix recommends implementing ranking functionality via MDX (Multidimensional Expressions) or DAX (Data Analysis Expressions). Continue reading →

Posted in Intelligence Reporting Techniques | Tagged , | Leave a comment

Why is a Corporate Portal vital to your BI Initiatives?

Posted on June 19, 2011 by BIAnalytix Team

BIAnalytix Tip Summary: Why is a Corporate Portal vital to your BI Initiatives?

Without an easy way to disseminate analysis that supports business decisions throughout your corporation, the value of your Business Intelligence is severely limited. A Corporate Portal is now acknowledged as the simplest and most effective method for the presentation and dissemination of Media Business Intelligence to all stakeholders in the organization. Portals provide a corporate-wide, customizable and authenticated vehicle for referencing critical information contributed by all authorized staff. It is a valuable empowerment tool for a media corporation. Continue reading →

Posted in Media Portals | Leave a comment

Traditional Projection Reports vs Revenue Forecasting

Posted on June 13, 2011 by BIAnalytix Team

BIAnalytix Tip Summary: Traditional Projection Reports vs Revenue Forecasting

Projection reports showing the future revenue currently on the books is one of the Media Industry’s traditional reporting cornerstones. However, more powerful analysis that transforms these figures into a forecast of the “final” values provides significant advantages for decision making because of the numerous comparison values available such as goals, budgets, expectations, past historical final values, etc. Continue reading →

Posted in Media Revenue Forecasts | Leave a comment