Categories
- Analysis Services (11)
- Business Intelligence (23)
- Community (6)
- DAX (1)
- friends (1)
- Hardware (1)
- Integration Services (1)
- MDX (7)
- Microsoft (6)
- Modeling/Architecture (8)
- OLAP (6)
- Operating Systems (4)
- Reporting Services (1)
- research (1)
- Software (2)
- SQL Server (12)
- Star Schema (2)
- Uncategorized (10)
- Virtualization (3)
- Web (4)
Category Archives: Business Intelligence
Is BI ready for Cloud Computing? Is Cloud Computing ready for BI?
The discussion today at the ITA BI Roundtable was “Is BI ready for Cloud Computing? Is Cloud Computing ready for BI?” It was a lively discussion, with participants from both BI Backgrounds and Cloud Backgrounds. We used this following materials … Continue reading
MDX Query to show number of child members in a Dimension
I was validating some assumptions about my dimensions’ data distribution and hierarchies and wrote some MDX to confirm the number of members. You could also do this by writing a SQL query against the relational table, but in this case … Continue reading
Posted in Analysis Services, Business Intelligence, MDX, SQL Server
Leave a comment
Business Intelligence Roundtable: Enrich your analytics with Open Data
Tuesdays topic was Business Intelligence Roundtable: Enrich your analytics with Open Data. Slide deck is posted here.
Posted in Business Intelligence, Community, Uncategorized, Web
Leave a comment
Solution to “Very strange results from MDX Query”
The solution to “Very strange results from MDX Query” It turns out that there was both a psychological component and a technical one. The sleuth who help me discover these issues was none other than my friend, former and occasionally … Continue reading
Posted in Analysis Services, Business Intelligence, MDX, OLAP
Leave a comment
Aug 17th, 2010 – ITA BI Roundtable Materials
On Tuesday, August 17, 2010 I had the privilege of presenting at the Business Intelligence Roundtable. The topic was Incorporating Geospatial Data in your Analytics. This session was a general purpose overview on all how to incorporate mapping data into your analytic systems. In … Continue reading
Posted in Business Intelligence
Leave a comment
self-exemplify – Dr. Edward Tufte’s seminar in Chicago July 23
In his book, The Visual Display of Quantitative Information, 2nd edition, Edward Tufte describes how he wanted to make the book, self-exemplifying. In other words, the book should use the techniques about the effective display of information to describe techniques … Continue reading
Posted in Business Intelligence
1 Comment
Devils and Angels of BI Architecture
Devil: You don’t need to set up a separate star schema databaseAngel: Yes you do. We don’t want to interfere with the operational systemsDevil: It’s sooo much workAngel: We want to create a simplified schema to benefit our end usersDevil: … Continue reading
The “Million Dollar” BI Architecture Diagram
Anyone who has worked with me or taken training from me has seen some variant of this diagram. It’s not an original concept, although this version has been refined to include my personal experience with many Business Intelligence implementations, as … Continue reading
Is Business Intelligence your company’s “Tree of Souls” ?
(Minor Avatar spoilers below – in case you’re one of the 3 people who hasn’t seen it yet)I was driving to a clients this past week and just free-associating, listening to an NPR segment about the movie Avatar and also … Continue reading
Posted in Business Intelligence
Leave a comment
Add-ons no MS Business Intelligence Developer should be without
The main two applications that are used for Microsoft-centric development are Business Intelligence Development Studio (BIDS) and SQL Server Management Studio (SSMS). There are a few add-on utilities that increase the power and usefulness of the out of the box applications. … Continue reading