In small-to-midsized businesses, using OLAP cubes for business intelligence (BI) analyses is often not a viable approach. A better solution is to design and implement a self-service BI solution on the client side.
I know all the Microsoft buzz is about Power BI and Excel these days, but customers need real-world, professional business intelligence solutions that meet their complex real world requirements today....More
In small-to-midsized businesses, using OLAP cubes for business intelligence (BI) analyses is often not a viable approach. A better solution is to design and implement a self-service BI solution on the client side....More
With an understanding of the key concepts in time series forecasting and exposure to some of the underlying details, you'll be in a better position to start using the forecasting capabilities in SQL Server Analysis Services (SSAS)....More
This is a follow-up from my blog post last month here on SQL Server Pro about utilizing common traditional reporting tools like Excel and Report Builder with the new SQL Server 2012 Tabular models....More
Using the Business Intelligence Wizard in SQL Server Analysis Services (SSAS), you can perform currency conversions but you can’t enter multiple dates or multiple exchange rates. Despite the limitations, performing many-to-many currency conversions in SSAS is possible. Here’s how....More
As far as I'm concerned we'll likely always have SQL Injection around to haunt us. Even though this attack vector has been well-publicized and well-documented for well over a decade (and then some), failure to account for it continues to pop all the time—even in catastrophic places....More