Min Maxing

Qlikview is a great tool for building dashboards for your data warehouse. However, by default, you have to create a date selector for every date field your charts use on your dashboard. By using variables, however, you can get around this limitation.

Many companies have a data warehouse that contains information gathered from sources such as game server logs and support ticketing software. By using an ETL tool such as Pentaho, it's easy to import your Google Analytics data so you can integrate it with the rest of your data warehouse.

Google Analytics recently added the ability to see how different marketing channels are contributing to conversions. This report is a great tool for quantifying the value of your traffic sources. If you customize it based on your marketing efforts, it becomes an even more powerful tool.

Wondering what data is important in your web analytics reports? Don't worry: it's easy to move beyond top-level stats and discover data that will have a real impact on your web efforts.