Here's a great method for managing ETL for data marts and small data warehouses with just T-SQL.  Read more...

SQL Server 2012 introduced an unified BI Semantic Model (BISM) which is based on some of the existing as well as some new technologies. This model is intended to serve as one model for all end user experiences for reporting, analytics, scorecards, dashboards, etc. In this tip, I will talk in detail about the new BISM, how it differs from earlier the earlier Unified Dimensional Model (UDM) and how BISM lays down a foundation for future.   Read more...

This white paper provides practical guidance to help BI professionals and decision makers decide whether SQL Server 2012 Analysis Services tabular or multidimensional modeling provides the best fit for your next BI solution.  Read more...

The explosion of social media data has resulted in a lot more marketing data for companies. Some are using it well and some aren't, but in both cases, Steve Jones notes there are more opportunities for data professionals.  Read more...

Data is more important than gut feel, or at least, Steve Jones thinks it should be more important. Today he talks about using data to support decisions.  Read more...

Easy way to setup a comprehensive ETL Performance auditing Solution no matter how complicated your ETL setup.  Read more...

A guide to the SQL Server 2008 Business Intelligence exams.  Read more...

Are you prepared for Big Data? A short piece from Henrico Bekker that talks about what Big Data might mean to many people.  Read more...

The Business Intelligence Semantic Model is one of the most significant enhancements in SQL Server 2012. BISM allows aspects of the traditional multidimensional model to coexist with the relational model in a format called the tabular model and can be used with all client tools in the Microsoft BI stack.   Read more...

Steve Jones notes that our expert systems might not handle every situation well, and the quest to move towards more real time decision making can involve dangers if a human is not in the loop.  Read more...

If you are looking to gain some BI experience or tackle a project that might help your company, Steve Jones suggests you consider doing something for HR.  Read more...

From MVP Jacob Sebastian, creator of the T-SQL Challenges, there is a BI quiz throughout the month of June. Enter and answer questions each day for the chance to win prizes.  Read more...

Learn dimensional modeling, cube design, MDX calculations and more in this 4 day online class from Pragmatic Works featuring BI expert Stacia Misner.   Read more...

The idea of a skunk works is to build a project that works under the radar, by a small and loosely organized group of people. Used to fuel innovation, this is an idea that you might apply to SQL Server BI projects.  Read more...

Is self service BI a good idea? Some people think so, others don't. Steve Jones talks about one of the issues and why it might actually not be a problem.  Read more...

Customer interactions create a wealth of timely data that marketing departments are eager to exploit. The customer status fact table provides a central switchboard for using this fast-moving data.  Read more...

How do you, as a database administrator, display the wealth of knowledge in your Database to the organization in a meaningful way -- Business Intelligence.  Read more...

Learn how to deliver dynamic content by building a meaningful Business Intelligence Application, utilizing only what is available on the client's desktop, when a Data Warehouse BI Application, SQL Server and SSIS/SSRS aren't an option.   Read more...

An introduction to SQL Server StreamInsight and Complex Event Processing with a focus on Business Intelligence.  Read more...

Thiago kicks off a new series of articles, taking us through everything we need to know to use PowerPivot effectively. First off, he walks us through the prerequisites, and getting started with our first basic data set.  Read more...