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)
Author Archives: Tom Huguelet
Join me for a Webinar: “Ad-hoc Scenario Analysis Using Existing Infrastructure”
Tom Huguelet Please join me Tuesday for “Ad-hoc Scenario Analysis Using Existing Infrastructure” April 19, 2011 12:00 p.m. ET / 9:00 a.m. PT http://bit.ly/gpyXpr Hosted by SQL Server Magazine, sponsored by Tableau Software. I really had fun creating this webinar. Gave … Continue reading
April 2011 ITA BI Roundtable – So what can I do with this “BI” stuff anyway?
April 2011 ITA BI Roundtable – So what can I do with this “BI” stuff anyway? Here are the slides from today’s session.
Creating Dashboards WITHOUT SharePoint
As a business intelligence consultant, a frequent request I receive is to “create a dashboard”. One of the first things I do is verify that I understand what the client is actually asking for. Many times by “dashboard”, what they … Continue reading
Microsoft SQL Server 2008 R2 Update for Developers Training Course “Dependency Check Exception” “AuthorizationManager check failed”
Like many of us, it’s a constant struggle, er, — opportunity — for me to keep up-to-date on the latest and greatest techniques. One of the things that Microsoft and its partner ecosystem do particularly well is make plenty of … Continue reading
Posted in Business Intelligence, Microsoft
Leave a comment
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
Strange results from MDX Query
I am currently working on adding forecasting capabilities to an existing customer cube. The MDX to do this is based on calculations in an existing spreadsheet model. The spreadsheet works very well in terms of modeling the business accurately, but … Continue reading
Posted in Analysis Services, MDX, OLAP
1 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