A set of stored procedures for Microsoft SQL Server Analysis Services.

A PoC to illustrate how to create a generic end-user transactional report writer for Microsoft Dynamics AX 2012.

The focus of this project, is to provide a utility that will allow someone to understand all Queries within an instance of AX 2012, that can be OData Feeds.

This release is an outcome of an exploratory project done by the P&P group (Microsoft) to understand the BI Landscape, Challenges and Common Solutions. The Architecture and Design Guidelines for BI Applications provides prescriptive guidance on how to overcome architectural challenges and design issues when building Business Intelligence solutions using Microsoft platform. This guide is intended for software architects and developers who are developing Business Intelligence applications using SQL Server 2005 - Integration Services and Analysis Services.

A Visual Studio add-in that enhances development functionality in Business Intelligence Development Studio (BIDS) and SQL Server Data Tools (SSDTBI).

The SQL Server BI Health Dashboard makes it easier to support SQL Server BI solutions by providing high-level and detailed insight into SSIS, SSRS, and SSAS processes. It has a very small footprint with just a few .rdl and .rds files and an optional table.

Business Intelligence LAB is a Microsoft Business Intelligence Framework that is developped based on real life needs. This repository hosts a set of development done upon SQL Server Business Intelligence Stack. This covers : - Data Access - Sample Cube - Sample OLAP Viewer - XMLA - SSIS custom component Those component comes from my experience and my needs. Some were published on French .net community (http://www.techheadbrothers.com/) under : http://www.techheadbrothers.com/Auteurs.aspx/renaud-harduin

BI Monitoring Tool provides an automated way to monitor SSAS, SSIS, SSRS and SQL Service when we're not around and send out an email when we hit the threshold.

The BI Report Automation Publisher is a command line tool + .net library which provides a more automated way to move reports between servers/environments. Useful when using PerformacnePoint (PPS), Proclarity Analytic Server (PAS) or MOSS/Sharepoint

There is a wealth of typically untapped information that describes the health of a BI environment. This multi-environment SSRS dashboard allows metadata-defined environment health metrics to be tracked. A drill-down SSIS log report permits rapid navigation to logged problems.

A charting Web Part for SharePoint Services 3.0 and SharePoint Server 2007. Create instant charts from your Lists!

Microsoft CRM Analytics Foundation is a business intelligence solution accelerator for Microsoft Dynamics CRM 3.0 customers and partners. With Analytics Foundation, executives can better track and manage business performance with dashboards and KPIs. Managers and employees can create reports quickly and make better decisions. Sales, marketing, and service employees can identify and act on new opportunities to grow revenue and improve business efficiency with predictive analytics. Analytics Foundation includes a UDM built on out-of-box MS CRM 3.0 schema, dashboards for sales and service, and predictive analytics such as product recommendation, lead potential rating, marketing list generation, and more. Analytics Foundation leverages data management and analytic technologies from the Microsot Business Intelligence suite of products including Microsoft SQL Server 2005, SharePoint, Business Scorecard Manager, Excel, and PerformancePoint Server 2007 (when available).

Biblioteca .NET que permite executar a validação de números de identificação portugueses

DevScope Microsoft Business Intelligence Samples

A custom Data Flow component for SQL Server Integration Services (SSIS) that replaces the standard SCD Wizard with a superior experience, from the configuration UI to runtime performance. Performs 100x faster than the standard component, and edits are non-destructive.

Load Excel files into SQL Database for further processing, analysis and validation. Without schema changes!

Mining frequent patterns is an essential task in a lot of fields, primarly market basket analysis; you can learn which products are commonly purchased together and how likely a particular product is to be purchased along with another. For example, you might find that 5% of your customers have bought pasta, tomatoes and milk together, and that 75% of those customers that bought pasta and tomatoes also bought milk. There are two steps in an association algorithm, the first step is a calculation intensive process that computes the frequent itemsets (i.e. the sets of distinct products purchased together more frequently). The second one generates the association rules from all the frequent itemsets. This step requires much less time than the first does. We implemented two well known algorithms: Apriori and FPGrowth: both of them include a lot of optimization designed to decrease memory usage and processing time.

IIS Log reader library is reading the IIS log data into intuitive domain model. Useful in ETL/SSIS applications. Intuitive, simple API.

Report Tool for Excel files, databases, Analysis Services and many more datasources InfoReporter a free report tool, any way free for all of you having excel :). MDX SQL OLAP ANALYSIS SERVICES SQLSERVER

JSONSource is a free MS SSIS Source component, aimed to integrate JSON data to Integration Services ETL.