I had a client ask me about some of the techniques we are currently using, “Tom, Can you send me authors, book titles and/or links outlining agile development (Story conferences, sprints, scrums, etc…).” This was my response: Here is the site that “started it all”: http://agilemanifesto.org/ I used this book: http://www.amazon.com/Agile-Data-Warehousing-World-Class-Intelligence/dp/0595471676 to acquire some of […]
Read More Agile and Business Intelligence
A lot of this has been floating around various blogs and press releases, but here’s a very succinct synopsis of where MS is planning to go with Microsoft BI and the BI Semantic Model.
Read More Microsoft on SSAS and BI Vision Roadmap
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 me an opportunity to organize and clarify a lot of previous experience from Business Intelligence […]
Read More Join me for a Webinar: “Ad-hoc Scenario Analysis Using Existing Infrastructure”
April 2011 ITA BI Roundtable – So what can I do with this “BI” stuff anyway? Here are the slides from today’s session.
Read More April 2011 ITA BI Roundtable – So what can I do with this “BI” stuff anyway?
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 mean is “lots of stuff all at once”. That’s when I pull out the tried […]
Read More Creating Dashboards WITHOUT SharePoint
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 materials available for self-directed study and skills renewal. If you haven’t already, check out the […]
Read More Microsoft SQL Server 2008 R2 Update for Developers Training Course “Dependency Check Exception” “AuthorizationManager check failed”
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 to support the discussions: PowerPoint (with links to references throughout) Gartner’s Key Initiatives: Cloud Computing […]
Read More Is BI ready for Cloud Computing? Is Cloud Computing ready for BI?
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 I definitely wanted to see exactly what was coming from the OLAP dimensions. Here’s the […]
Read More MDX Query to show number of child members in a Dimension
Tuesdays topic was Business Intelligence Roundtable: Enrich your analytics with Open Data. Slide deck is posted here.
Read More Business Intelligence Roundtable: Enrich your analytics with Open Data
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 current colleague, Scot Reagin. The technical issue: I was using FORMAT_STRING to format the numbers […]
Read More Solution to “Very strange results from MDX Query”