The cube synchronization in SQL 2008 is vastly improved compared to SQL 2005 (much faster). On the target (or production) server you have the option to run the Synchronization Wizard within SQL Server Management Studio (SSMS) to pull data from a source (or staging) server, but what if you want to run the ETL and […]
Posts Tagged ‘BI’
Alternative to the SSIS Slowly Changing Dimension Wizard
Problem Within most BI projects you need to in some way handle slowly changing dimensions in your ETL solution. Be it Type 1, Type 2, they are unavoidable because truncating the dimension and fact tables and reloading from scratch is not an option unless the data warehouse is very small. On most of my projects […]
Leveraging Data Management and Data Quality within SharePoint
Overview One issue that I have run into in every BI project is data quality and data cleansing. Oftentimes data cleansing can be excluded from the scope of a BI project since the client is often afraid to even tackle the problem. On top of that, data cleansing can often be a project all by […]
Business Connectivity Services: Entity Associations across Line of Business Systems
Here’s the scenario: you’ve got two Windows Communication Foundation (WCF) services that return related data. For instance, let one of them be a service that returns People and let the other be a service that returns Documents. Every Document was authored by one or more Person. Since these services are separate Line of Business (LOB) […]
Wine Steward, Ship Steward? DATA STEWARD: The Steward Every Business Needs!
Just as the creation of the internet and the World Wide Web has forced companies to bring on new technologies and consequently create new roles that they did not have 20 years ago, increasing data volumes and analytical power, as it relates to Business Intelligence, has had the same effect on organizations in order for […]
Give Me A Slice
One of the most useful features of Excel 2010 and Pivot Tables is the new Slicer component. The Slicer allows end users to more easily visualize what dimensions and attributes are available to “slice and dice” the data and what has been selected as filter criteria. In past versions of Excel, the Report Filter was […]
Implementation Is The Easy Part
While assisting an organization in deciding if they should obtain a Business Intelligence solution; which vendor is most adequate to suit their needs and actually implementing the system may seem like the hard part, in many cases, it turns out to be the easy part. In my experience, the hardest part lies in the adoption […]
Realizing ROI with Reporting Services subscriptions
While working for a global executive search firm during the height of the US credit and housing crisis, the SVP – US Finance became anxious as the firm was having an unusually difficult time collecting past due invoices from clients. This data was a key component of their financial Business Intelligence system and readily available […]
SharePoint 2010 Business Intelligence
Check out my SharePoint 2010 Business Intelligence Posts: 1. SharePoint 2010 Insights – Reporting Services and Chart Web Parts 2. SharePoint 2010 Insights – Excel Services and Visio Services 3. SharePoint 2010 Insights – PerformancePoint Review Part 1 of 2 4. SharePoint 2010 Insights – PerformancePoint Review Part 2 of 2 Enjoy!!