tag:blogger.com,1999:blog-32051091419809763452024-03-14T07:50:24.120+11:00randoM thoughtS on BI spaceIman Eftekhari's blog about Microsoft Business Intelligence, and other geeky stuff...Anonymoushttp://www.blogger.com/profile/03799141057142938532noreply@blogger.comBlogger44125tag:blogger.com,1999:blog-3205109141980976345.post-44188720922266334532013-05-15T14:45:00.000+10:002013-05-15T14:46:06.335+10:00SYBIS Demo: Implementing BI solutions using Agile/SCRUM methodology<br />
<a href="http://2.bp.blogspot.com/-O6FqZRq0Skw/UZMSjN8VGTI/AAAAAAAAAbM/BCS4j3fqY1Y/s1600/SYBIS+_Demo_Slide.jpg" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="150" src="http://2.bp.blogspot.com/-O6FqZRq0Skw/UZMSjN8VGTI/AAAAAAAAAbM/BCS4j3fqY1Y/s200/SYBIS+_Demo_Slide.jpg" width="200" /></a>I’ll be presenting at the next Sydney BI Social (SYBIS) group about how to implement a BI system using Agile methodology. <br />
<br />
This demo will include some tips and techniques for using Agile in BI implementation and a case study of using TFS 2012 for ALM on a BI project.<br />
<br />
You can find out more about this session on the following links:<br />
<br />
<a href="http://www.meetup.com/SYBISGROUP/">http://www.meetup.com/SYBISGROUP/</a><br />
<br />
<a href="https://www.linkedin.com/groups?gid=4900023">https://www.linkedin.com/groups?gid=4900023</a> <br />
<br />Anonymoushttp://www.blogger.com/profile/03799141057142938532noreply@blogger.com2tag:blogger.com,1999:blog-3205109141980976345.post-24457991629618102482013-04-02T16:06:00.002+11:002013-04-02T16:07:32.991+11:00Sydney BI Social Group (SYBIS)<a href="http://4.bp.blogspot.com/-1ybZuXjbor4/UVpms_tf5dI/AAAAAAAAAZI/677Wnqh61x0/s1600/SYBIS.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="75" src="http://4.bp.blogspot.com/-1ybZuXjbor4/UVpms_tf5dI/AAAAAAAAAZI/677Wnqh61x0/s200/SYBIS.jpg" width="200" /></a>Sydney BI Social (SYBIS) group is a new event for the Sydney business intelligence community. Organised by myself and James Beresford (<a href="http://www.bimonkey.com/">www.bimonkey.com</a>), this event will be held on the first Wednesday of each month.<br />
<br />
The aim of this group is to provide an opportunity for Sydney BI professionals to get update on the market trends, share ideas and experiences, have a beer or two, and network with other practitioners and experts.<br />
<br />
The format will be simple: topics will be suggested prior to the event and will be used to initiate discussions. We will try to have a panel of experts for each session that are experienced in that specific area. They will be sharing their knowledge and experience with the group. You are also welcome to talk about problems that you are facing in your real-life projects or certainly any solutions that you may have and want to share.<br />
<br />
We may also have a challenge of some sort, it will be optional, so don't worry!<br />
<br />
<br />
More details can be found in our LinkedIn group: <br />
<a href="https://www.linkedin.com/groups?home=&gid=4900023">https://www.linkedin.com/groups?home=&gid=4900023</a> <br />
<br />
Please RSVP using our Meetup group: <br />
<a href="http://www.meetup.com/SYBISGROUP">http://www.meetup.com/SYBISGROUP</a> Anonymoushttp://www.blogger.com/profile/03799141057142938532noreply@blogger.com0tag:blogger.com,1999:blog-3205109141980976345.post-5504661351931452972013-02-12T14:19:00.002+11:002013-02-12T14:23:20.190+11:00Magic Quadrant for Business Intelligence and Analytics Platforms 2013<br />
The emphasis from most of the market leaders is on Mobile BI, big data, and data discovery tools that are business-user-friendly. Next trend seems to be data-as-a-service which could significantly grow the market for BI and analytics platforms.<br />
<br />
Read the full report here:<br />
<br />
<a href="http://www.gartner.com/technology/reprints.do?id=1-1DYKLUU&ct=130206&st=sb">http://www.gartner.com/technology/reprints.do?id=1-1DYKLUU&ct=130206&st=sb</a><br />
<br />
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: left; margin-right: 1em; text-align: left;"><tbody>
<tr><td style="text-align: center;"><a href="http://2.bp.blogspot.com/-jvdee6A6s9w/URm0hgEVQTI/AAAAAAAAAY4/36sRjO4tlq4/s1600/MQ_BI_2013.png" imageanchor="1" style="clear: left; margin-bottom: 1em; margin-left: auto; margin-right: auto;"><img border="0" height="320" src="http://2.bp.blogspot.com/-jvdee6A6s9w/URm0hgEVQTI/AAAAAAAAAY4/36sRjO4tlq4/s320/MQ_BI_2013.png" width="312" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Source: Gartner (February 2013) </td></tr>
</tbody></table>Anonymoushttp://www.blogger.com/profile/03799141057142938532noreply@blogger.com0tag:blogger.com,1999:blog-3205109141980976345.post-15560307285138824932012-07-19T17:20:00.000+10:002012-07-20T14:22:30.537+10:00SQL Server 2012 BI: The Good, The Bad, and The UglyRecently I implemented a BI solution for a client using SQL Server 2012 and wanted to share some thoughts on that.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-TJp3-rcwkSw/UAe0spzdHuI/AAAAAAAAAUU/6DZ02rGrq40/s1600/sqlserver2012.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="132" src="http://3.bp.blogspot.com/-TJp3-rcwkSw/UAe0spzdHuI/AAAAAAAAAUU/6DZ02rGrq40/s320/sqlserver2012.png" width="320" /></a></div>
<br />
<h4>
Reporting Layer</h4>
The Microsoft BI presentation layer includes several reporting and analysis tools including: Reporting Services, Report Builder, Power View, Excel, PowerPivot (for Excel and SharePoint), Excel Services, PerformancePoint Services and Visio Services. <br />
<br />
Many of these tools have <b>overlapping capabilities</b> that can easily confuse developers and designers at first glance. For instance for ad-hoc functionalities you can use Report Builder, Excel, PowerPivot or Power View. <br />
<br />
Number of this tools are only available on <strong>SharePoint Enterprise Edition</strong>. So if you don’t already have it and don’t want to spend on this costly licence you will miss many of them such as: Power View, PowerPivot for SharePoint, Excel Services, PerformancePoint Services and Visio Services.<br />
<a href="http://4.bp.blogspot.com/-ACASesgxKAI/UAiz7vOHBDI/AAAAAAAAAUk/lvSdDeMDZIY/s1600/blog_PowerView.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="241" src="http://4.bp.blogspot.com/-ACASesgxKAI/UAiz7vOHBDI/AAAAAAAAAUk/lvSdDeMDZIY/s320/blog_PowerView.png" width="320" /></a><br />
By introducing the <b>Power View</b>, it seems like Microsoft was trying to add more self-service functionality to the stack, but to me this good looking and flashy tool won’t be able to compete with the beloved Excel to get adopted by business users, and it’s certainly not envisioned to be used by IT people either. The other big limitation is that only Tabular databases can be used as the source for Power View reports.<br />
<br />
<br />
<br />
<h4>
BI Layer</h4>
With the new Business Intelligence Semantic Model (BISM), the objective was to have <b>one model for all user experiences</b>: reporting, analytics, and custom applications, in other words “BI for all” based on the same model. Though a big difference is that in SQL Server 2012, Analysis Services is available in <b>two types</b>: Tabular and Multidimensional. <br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-E1yX1FQtNik/UAi0KvXlEgI/AAAAAAAAAUs/3okhRq0_01w/s1600/Blog_BISM.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="239" src="http://2.bp.blogspot.com/-E1yX1FQtNik/UAi0KvXlEgI/AAAAAAAAAUs/3okhRq0_01w/s320/Blog_BISM.png" width="320" /></a></div>
The <strong>Tabular</strong> model provides the advantage of the table-based approach, DAX queries, and the VertiPaq (xVelocity) which is an<b> in-memory </b>engine. In other words, a server version of PowerPivot without the need of SharePoint or Excel. <br />
<br />
The <strong>Multidimensional</strong> model (cubes, dimensions & hierarchies) is what we had before with UDM, storing aggregated data on disk and using MDX language to query OLAP storage. It doesn’t have major changes since SQL 2008 except for a few fixes and optimizations and improvements.<br />
<br />
The problem with that is unlike what Microsoft claimed, there is no such a thing as a unified BI model: <b>BISM models cannot live together</b> on the same SSAS instance and they speak in <b>2 different languages</b>! Tabular database can be queried with old MDX too, but the point is developers spent so much time to understand and learn MDX (with not much luck!) and now they have to learn a new language and still keep learning the old one too!<br />
<br />
Also there are not many tools that can use DAX to query database, currently Reporting Services and Excel 2010 can query the BISM tabular using MDX and PowerPivot and Power View can use DAX, so there is inconsistency in terms of the way you can talk to BISM, however Microsoft claims that this limitation would soon be removed and the developers could use either of the query languages to query data from both multidimensional or tabular types.<br />
<br />
As Marco Russo stated in his <a href="http://sqlblog.com/blogs/marco_russo/archive/2012/03/01/why-to-use-tabular-in-analysis-services-2012-ssas.aspx" target="_blank">blog</a> "...there are opportunities in Tabular thanks to the flexibility, but these are very early days and we lack of new client tools able to take advantage of the new model. Power View is just one, but there is space for more."<br />
<br />
<b>Do I recommend using Tabular mode?</b> Well, as it’s always the case: it depends. If you are implementing an enterprise BI solution, given the limitations of the Tabular mode I don’t recommend it at all, but if you don’t have a huge data size and you want to build a <b>flexible </b>system fairly <b>quickly</b>, then Tabular is the answer, otherwise use the traditional Mmltidimensional mode.<br />
<br />
<h4>
ETL and data Layer</h4>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-Ct69q7KnYOM/UAi2tm9PGVI/AAAAAAAAAU4/PzaRWw3fWQU/s1600/blog_SSIS+CDC.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="192" src="http://4.bp.blogspot.com/-Ct69q7KnYOM/UAi2tm9PGVI/AAAAAAAAAU4/PzaRWw3fWQU/s320/blog_SSIS+CDC.png" width="320" /></a></div>
SSIS had some improvements. Not only it looks nicer and tidier than previous versions, but also there are number of new controls and features in SSIS, such as Change Data Capture (CDC) tasks, scripting improvements and new expressions like LEFT, TOKEN and REPLACENULL, easier troubleshooting & logging, data taps, PowerShell support, etc. I was also very impressed with the data quality components in SSIS and DQS in general. <br />
<br />
<h4>
Conclusion:</h4>
So in overall there are many new BI features and improvements in SQL Server 2012, but what seems to be <b>lacked </b>is a clear and well-defined <b>vision </b>on the BI <b>roadmap</b>. As mentioned, many of their tools are based on Enterprise Edition of SharePoint which is not affordable for small-mid size companies, and some of their tools are also not designed to satisfy enterprise clients. So to me it’s not very clear on where Microsoft is heading to and what type of market they are targeting with these products.<br />
<br />
<br />
<br />
<b><u>Update</u>:</b> <a href="http://lukehayler.com/" target="_blank">Luke </a>mentioned that Power View is now included as part of <a href="http://www.microsoft.com/office/preview/en/excel-2013-preview" rel="nofollow" target="_blank">Excel 2013</a>, I haven’t got chance to check it yet but am happy that Microsoft is coming to realize that not every company is interested in using SharePoint 2010 Enterprise, so perhaps they need to consider <b>Office clients </b>as the main delivery tool for BI and enrich the functionality of the good old friend Excel in order to have a better market share in BI space.Anonymoushttp://www.blogger.com/profile/03799141057142938532noreply@blogger.com0tag:blogger.com,1999:blog-3205109141980976345.post-50001807132854069492012-02-15T17:32:00.000+11:002012-02-15T17:32:46.348+11:00Magic Quadrant for Business Intelligence Platforms 2012As always, very informative report from Gartner analysing the BI vendors, tools and market. Highly recommended for anyone in BI world.<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-nWXtuOGb1R8/TztRFd7igiI/AAAAAAAAAUA/Vk5ok5uilbs/s1600/Magic_Quadrant_BI_2012.png" imageanchor="1" style="clear: right; cssfloat: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="320" src="http://4.bp.blogspot.com/-nWXtuOGb1R8/TztRFd7igiI/AAAAAAAAAUA/Vk5ok5uilbs/s320/Magic_Quadrant_BI_2012.png" width="312" yda="true" /></a></div>
<br />
For me the highlights are: <br />
<br />
Business vs. IT Driven BI. The conflict remains the same as before: business users demand easy to use, flexible products that put analytic power into their own hands, against IT's desire to maintain standards and create a supportable BI environment with predictable performance and quality data. <br />
<br />
There are also other important features in this report, mostly around data discovery tools, Mobile BI, collaborative decision-making, new use cases and content types (real-time, big data, etc.), removing complexity, cloud services, predictive analytics, etc. <br />
<br />
For more info: <br />
<br />
<a href="http://www.gartner.com/DisplayDocument?doc_cd=225500&ref=g_sitelink">http://www.gartner.com/DisplayDocument?doc_cd=225500&ref=g_sitelink</a> <br />
<br />
<a href="http://www.qlikview.com/mq2012">http://www.qlikview.com/mq2012</a>Anonymoushttp://www.blogger.com/profile/03799141057142938532noreply@blogger.com0tag:blogger.com,1999:blog-3205109141980976345.post-47757037757953912022011-06-01T10:06:00.002+10:002011-06-01T10:16:45.146+10:00Top tends in BI arenaI thought I’d share a few of my thoughts on the trends and technologies that are part of my daily life these days. From what I see in the market, the expectation from BI has changed significantly over the past few years. Now all size of companies are looking at investing in BI. They expect to spend less, get more ROI, more data accessibility, more insight into different levels of the business, more flexibility, and quicker response to the ever-changing business requirements. <br />
<br />
<strong><u>Agile BI</u></strong><br />
<br />
Traditional waterfall design and development methodologies are too slow and too inflexible for BI. Many companies are now considering Agile for their BI implementations. <br />
But don’t misinterpret what I am calling “Agile BI”, it’s not just about the Agile software development methodology, which is nothing new. IMHO Agile development by itself is not enough for BI, I think a different approach, technologies, and mindset are required to make BI more flexible<br />
An agile software development process doesn't necessarily lead to agile BI, though it will speed up some steps in the process. The technology and processes (e.g. change management process) has to be made more flexible to really achieve agility.<br />
Forrester defines Agile business intelligence as: An approach that combines processes, methodologies, organizational structure, tools, and technologies that enable strategic, tactical, and operational decision-makers to be more flexible and more responsive to the fast pace of changes to business and regulatory requirements.<br />
<br />
<strong><u>Collaborative/social BI </u></strong><br />
<br />
Intelligence = Information + People<br />
<br />
Collaboration and business intelligence have never been separated, but companies are just recently beginning to realize the benefits of the connection. <br />
<br />
By introducing collaborative technologies to their business intelligence platform, companies are better positioned to utilize and take advantage of their employee data.<br />
<br />
Collaboration is now becoming an essential part of the business intelligence. It enables crowdsourcing and in general the wisdom of the crowds tend to produce better decisions as organizations become increasingly complex.<br />
<br />
<strong><u>Self-service BI</u></strong><br />
<br />
Let the business do it by themselves! <br />
IT is always under one step behind from ever-changing business needs. The concept of self-service BI is to provide capabilities to enable business users exploring data and build their own reports. it may also enable analysts to publish and distribute their work to others. <br />
Used in this way, the visual discovery tools become a nice tool for super users to create web-based reports and dashboards for colleagues. These reports are not static; they are “live” and interactive so casual users can analyse data just as business analysts would without the hassle of starting from scratch.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-AEULNEVmUrs/TeWEkRfzvRI/AAAAAAAAATE/1DTkSsNcqJs/s1600/Forecast+tool.png" imageanchor="1" style="clear: right; cssfloat: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="244" src="http://3.bp.blogspot.com/-AEULNEVmUrs/TeWEkRfzvRI/AAAAAAAAATE/1DTkSsNcqJs/s320/Forecast+tool.png" t8="true" width="320" /></a></div>
<strong><u>Predictive Analytics</u></strong><br />
<br />
"Predictive Analytics" is to analyse current and historical facts to make predictions about future events.<br />
<br />
More and more vendors are attempting to make it more accessible to information workers and others without advanced degrees in statistics. <br />
Data mining used to be mostly used by large enterprises (e.g. Banks) but these days I see companies in different sizes are started getting benefit from that. <br />
There is also a trend in using social network data in data mining. It can be used to determine the trend, behaviour analysis and reduce customer churn. <br />
<br />Anonymoushttp://www.blogger.com/profile/03799141057142938532noreply@blogger.com1tag:blogger.com,1999:blog-3205109141980976345.post-55915081924413674712010-10-18T12:19:00.001+11:002010-10-18T12:20:10.281+11:00Project Phoenix - ANZProject Phoenix, started by SQL Server MVP Arnie Rowland, is a program which awards software, tools and training materials to under/unemployed developers who propose a software project for a non-profit agency, school or church. <br />
<br />
More info: <a href="http://www.rodcolledge.com/rod_colledge/project-phoenix.html">http://www.rodcolledge.com/rod_colledge/project-phoenix.html</a><br />
<br />Anonymoushttp://www.blogger.com/profile/03799141057142938532noreply@blogger.com0tag:blogger.com,1999:blog-3205109141980976345.post-19669199850224505552010-09-28T17:47:00.001+10:002010-09-28T17:49:39.074+10:00To PowerPivot, or not to PowerPivot?We’ve all seen many presentations about PowerPivot and its great features like in-memory processing which enables Excel to handle millions of records. But the question is when to use PowerPivot as opposed to using a SSAS cube? <br />
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
</div>
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
Here are some points you need to consider when choosing the tool: </div>
<div>
</div>
<div>
</div>
<strong><u>Pros</u></strong>: <br />
<div>
<a href="http://3.bp.blogspot.com/_ekahfMOWmec/TKGdW5APF2I/AAAAAAAAARk/nvJb0j8-bjI/s1600/powerpivotLogo.jpg" imageanchor="1" style="clear: right; cssfloat: right; cssfloat: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" px="true" src="http://3.bp.blogspot.com/_ekahfMOWmec/TKGdW5APF2I/AAAAAAAAARk/nvJb0j8-bjI/s1600/powerpivotLogo.jpg" /></a></div>
<ul>
<li style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">PowerPivot is a powerful tool to gather data from different data sources. It can be used to create POCs or demos in a quick (and possibly dirty) way. </li>
<li>It can be used to answer some ad-hoc questions or to play with data (data analysis).</li>
</ul>
<br />
<strong><u>Cons</u></strong>:<br />
<ul>
<li>PowerPivot doesn't support data level security. Whoever gets access to the file can see all data inside it. With SSAS you can implement security at data level.</li>
<li>Complicated dimension types (like parent-child) are not supported in PowerPivot </li>
<li>Using PowerPivot workbooks as data source for reports may cause version management issues.</li>
<li>PowerPivot runs in memory, when you use PowerPivot for all your enterprise data you would need a huge RAM</li>
<li>Saving PowerPivot files in SharePoint may cause some issues when the size is too large. </li>
<li>SSAS allows you to fine tune your cube but with PowerPivot you can’t. </li>
<li>Data can easily be out of control as soon as it is saved on workstation. There also might be huge security risks involved. Even with the SharePoint implementation users have to download data to workstation first, and then publish it to SharePoint.</li>
<li>PowerPivot for SharePoint requires Enterprise license and SQL Server 2008R2 EE license. The cost (which is very high) may affect the SharePoint implementations of PowerPivot. By using PowerPivot without SharePoint (Excel add-in which is free) we may end up having even bigger Excel hell!</li>
<li>Source data is not always in high quality. We may need to validate and do data cleansing and also more often we need to apply some business rules which can be handled better in SSAS or at ETL level.</li>
<li>Working with data from different data sources may require high technical knowledge. Some data isn't that easy to join. A key isn't always available that lets you join data from different sources. It will make it hard for a non-technical person to work with the tool without any IT support.</li>
</ul>
<br />
<div>
</div>
<br />
From what I've seen so far, PowerPivot is not a replacement for Analysis Services, but it certainly has a role for tactical solutions. It also can be used by power users to quickly analyse data, or perhaps to build prototypes of larger scale SSAS implementations. <br />
<div>
</div>
<br />
<div>
</div>
So I think PowerPivot is great for certain scenarios, but for Enterprise level data warehouse implementation SSAS is the way to go.<br />
<br />
<div>
</div>Anonymoushttp://www.blogger.com/profile/03799141057142938532noreply@blogger.com0tag:blogger.com,1999:blog-3205109141980976345.post-16387235923542509582010-08-23T19:00:00.002+10:002010-08-23T19:00:00.329+10:00New joy of my life...<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/_ekahfMOWmec/THIbs63WAWI/AAAAAAAAARU/BPdEvATAF9k/s1600/Aiden.jpg" imageanchor="1" style="clear: left; cssfloat: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="153" ox="true" src="http://2.bp.blogspot.com/_ekahfMOWmec/THIbs63WAWI/AAAAAAAAARU/BPdEvATAF9k/s200/Aiden.jpg" width="200" /></a></div>
This little man has delayed this blog for 4 months! Hopefully I’ll get more time to update this blog more often.<br />
<br />
I started using SharePoint 2010 & SQL Server 2008 R2 in my new project and will share some thoughts on them very soon.<br />
<br />Anonymoushttp://www.blogger.com/profile/03799141057142938532noreply@blogger.com0tag:blogger.com,1999:blog-3205109141980976345.post-34670762908958338012010-04-19T16:41:00.002+10:002010-04-20T14:59:27.672+10:00SQL Server 2008 R2 - free ebook<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<a href="http://3.bp.blogspot.com/_ekahfMOWmec/S8v67CDRm3I/AAAAAAAAARM/N_51xoobG8I/s1600/SQL+Server+2008+R2+free+Ebook.jpg" imageanchor="1" style="clear: left; cssfloat: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="200" src="http://3.bp.blogspot.com/_ekahfMOWmec/S8v67CDRm3I/AAAAAAAAARM/N_51xoobG8I/s200/SQL+Server+2008+R2+free+Ebook.jpg" width="162" wt="true" /></a></div>
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
You can <a href="http://blogs.msdn.com/microsoft_press/archive/2010/04/14/free-ebook-introducing-microsoft-sql-server-2008-r2.aspx">download</a> this free ebook from Microsoft Press to learn about new features of SQL Server 2008 R2. </div>
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<br /></div>
<div style="text-align: left;">
<span style="color: #444444;">Introducing Microsoft SQL Server 2008 R2, by Ross Mistry and Stacia Misner</span></div>
<br />
Enjoy it!Anonymoushttp://www.blogger.com/profile/03799141057142938532noreply@blogger.com0tag:blogger.com,1999:blog-3205109141980976345.post-11196389504171805612010-02-08T12:41:00.003+11:002010-02-08T12:46:35.559+11:00Gartner Magic Quadrant for BI Platforms 2010Once again, Microsoft has been positioned in the <b>Leaders Quadrant</b> of the Gartner Magic Quadrant for BI Platforms (Gartner RAS Core Research Note G00173700 - 29 January 2010)<br />
<br />
The full report can be accessed on Gartner’s web site here:<br />
<a href="http://www.gartner.com/technology/media-products/reprints/oracle/article121/article121.html" target="_blank">http://www.gartner.com/technology/media-products/reprints/oracle/article121/article121.html</a><br />
<br />
<div class="separator" style="clear: both; text-align: left;">
<a href="http://2.bp.blogspot.com/_ekahfMOWmec/S29q-HXENQI/AAAAAAAAARA/en1XOHVV66Q/s1600-h/Gartner+Magic+Quad+BI+2010.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" kt="true" src="http://2.bp.blogspot.com/_ekahfMOWmec/S29q-HXENQI/AAAAAAAAARA/en1XOHVV66Q/s320/Gartner+Magic+Quad+BI+2010.png" /></a></div>
<br />
Figure: Magic Quadrant for Business Intelligence Platforms<br />
<br />Anonymoushttp://www.blogger.com/profile/03799141057142938532noreply@blogger.com0tag:blogger.com,1999:blog-3205109141980976345.post-56434190402957082362010-01-05T16:55:00.002+11:002010-01-06T09:45:56.491+11:00Microsoft BI in 2010 – and my New Year’s resolution!<div>
<br />
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/_ekahfMOWmec/S0LQHTcSZII/AAAAAAAAAQ4/1aYOzcBc2xM/s1600-h/MS_BI_2010.jpg" imageanchor="1" style="clear: right; cssfloat: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" ps="true" src="http://4.bp.blogspot.com/_ekahfMOWmec/S0LQHTcSZII/AAAAAAAAAQ4/1aYOzcBc2xM/s320/MS_BI_2010.jpg" /></a> <br /></div>
<div>
It’s the first week of 2010 and people have got great intensions to stick to their resolutions (I’ve been to the gym once since 1st Jan which is a good start!) <br />
</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
But what about the “Learning” resolutions?<br />
<br />
I have been learning about SQL Server 2008 R2 these days and found that there are lots of new things happening in MB BI space. Whether you are a techie who loves learning new stuff, passionate about MS BI, or just want to add weight to your CV, it would be worthwhile watching out these MS technologies in 2010.<br />
<br />
1) Master Data Services<br />
<ul>
<li><a href="http://msdn.microsoft.com/en-us/library/ee633763(SQL.105).aspx">Master Data Services</a></li>
<li><a href="http://nickbarclay.blogspot.com/2009/11/beginning-master-data-services-part-1.html">Nick Barclay's posts about MDS</a> </li>
</ul>
2) PowerPivot <br />
<ul>
<li><a href="http://www.powerpivot.com/">PowerPivot website</a></li>
</ul>
<br />
3) PerformancePoint Services for SharePoint Server 2010<br />
<ul>
<li><a href="http://msdn.microsoft.com/en-us/library/ee557869(office.14).aspx">What's New: PerformancePoint Services</a></li>
</ul>
<br />
4) SQL Azure and Cloud Computing<br />
<ul>
<li><a href="http://www.microsoft.com/windowsazure/sqlazure/">SQL Azure website</a></li>
</ul>
<br />
5) Excel Services, VISIO Services and other BI related components and APIs in MOSS 2010<br />
<ul>
<li><a href="http://msdn.microsoft.com/en-us/library/ee558289(office.14).aspx">What's New: Excel Services</a></li>
</ul>
<br />
And in terms of "Methodology" and delivery approach, I believe we will hear more about "<strong>Agile</strong> BI /Data Warehousing" due to the reduced IT budgets in this economy. I'll talk about it in another post.<br />Anonymoushttp://www.blogger.com/profile/03799141057142938532noreply@blogger.com1tag:blogger.com,1999:blog-3205109141980976345.post-87954523460210118492009-10-21T23:19:00.002+11:002009-10-21T23:35:09.558+11:00PowerPivot & Visio Services for SharePoint 2010<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/_ekahfMOWmec/St766DWqPlI/AAAAAAAAAPc/k1475Gzp06A/s1600-h/PowerPivotBox.jpg" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" src="http://3.bp.blogspot.com/_ekahfMOWmec/St766DWqPlI/AAAAAAAAAPc/k1475Gzp06A/s200/PowerPivotBox.jpg" /></a><br /></div>
<br />
<span style="border-collapse: collapse; font-family: arial, sans-serif; font-size: 13px;"></span><br />
Gemini has got a new name: <b>PowerPivot</b><br />
<br />
Microsoft revealed that it officially branded Gemini as Microsoft PowerPivot for Excel 2010.<br />
<br />
“With PowerPivot, users and IT departments can: Integrate massive amounts of data on the desktop from virtually any source; Perform lightning-fast calculations and analysis on large data volumes; Share and collaborate on user generated analysis through integration with SharePoint; Monitor user generated applications,” the SQL Server team representative noted.<br />
<br />
Couple of points to consider:<br />
<br />
<ul>
<li>PowerPivot for Excel only works with Excel 2010.</li>
<li>PowerPivot for SharePoint will require<b> SQL Server 2008 R2</b> and <b>SharePoint 2010</b>.</li>
</ul>
<br />
<div>
For more information about "Managed Self Service BI" and PowerPivot see:<br />
</div>
<div>
<a href="http://www.powerpivot.com/">http://www.powerpivot.com</a><br />
</div>
<div>
<a href="http://www.microsoft.com/sqlserver/2008/en/us/powerpivot.aspx">http://www.microsoft.com/sqlserver/2008/en/us/powerpivot.aspx</a><br />
</div>
<div>
<a href="http://www.microsoft.com/sqlserver/2008/en/us/powerpivot.aspx"></a><br />
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/_ekahfMOWmec/St78AaC-rrI/AAAAAAAAAPk/Q6LBYuBEu-s/s1600-h/VisioServices.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" src="http://4.bp.blogspot.com/_ekahfMOWmec/St78AaC-rrI/AAAAAAAAAPk/Q6LBYuBEu-s/s200/VisioServices.png" /></a><br /></div>
<div>
<br />
<b>Visio Services:</b> a great visualization tool which allows real time data to be shared on a SharePoint site for those without the Visio client.<br />
<br />
Diagrams can connect to an OBDC source such as a SharePoint list, Excel spreadsheet, or SQL Server database. However it <b>can not</b> be used with <b>SSAS </b>or <b>PowerPivot </b>(which is a bit disappointing for BI developers). That's a great feature and I think we may be able to build fancy looking BI dashboards using Visio in near future.<br />
</div>Anonymoushttp://www.blogger.com/profile/03799141057142938532noreply@blogger.com2tag:blogger.com,1999:blog-3205109141980976345.post-44863851538852976442009-10-20T22:44:00.010+11:002009-10-21T22:56:13.818+11:00Self-Service BI?!We keep hearing about "SELF-SERVE" functionalities in new versions of BI tools specifically with Microsoft plan to delivering BI to the masses.<br />
<br />
<div class="separator" style="clear: left; text-align: center;">
<a href="http://1.bp.blogspot.com/_ekahfMOWmec/St2gZqj34LI/AAAAAAAAAPE/fyi__hTok7g/s1600-h/Gemini.jpg" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" src="http://1.bp.blogspot.com/_ekahfMOWmec/St2gZqj34LI/AAAAAAAAAPE/fyi__hTok7g/s200/Gemini.jpg" /></a><br /></div>
<b>SQL Server 2008 R2</b> introduced some self-service options to allow business units and users to create and share BI solutions. Here is what MS says about them:<br />
<br />
<ul>
<li><span style="color: #0c343d;">SQL Server Project "Gemini” Add-in for Excel</span></li>
</ul>
<blockquote>
Enables Excel power users to create BI solutions by streamlining the integration of data from multiple sources enabling interactive modeling and analysis of massive amount of data and by supporting the seamless sharing of data models and reports through Microsoft Office SharePoint 2010<br />
</blockquote>
<ul>
<li><span style="color: #0c343d;">SharePoint 2010 based Operations Dashboard</span></li>
</ul>
<blockquote>
This SharePoint managed service enables front-line operators and administrators to monitor access and utilization of analyses and reports as well as track patterns of hardware usage to help ensure the right security privileges are applied and user generated solutions are available, up-to-date, and managed in a consistent way.<br />
</blockquote>
<ul>
<li><span style="color: #0c343d;">SQL Server Reporting Services Report Builder 3.0</span></li>
</ul>
<blockquote>
This updated ad-hoc reporting client accelerates report creation, collaboration and consistency by allowing users to create and share report components that can be accessed via the shared component library and by enabling the rapid assembly of comprehensive business reports using these shared components.<br />
</blockquote>
<ul>
<li><span style="color: #0c343d;">Rich visualization of geospatial data</span></li>
</ul>
<blockquote>
New support for geospatial visualization including mapping, routing, and custom shapes can help your end users create customized reports that leverage existing content objects, such as queries, data regions, and charts and graphs. You can also enhance location-based data reports with Bing Maps in Report Builder 3.0.<br />
</blockquote>
<br />
<a href="http://1.bp.blogspot.com/_ekahfMOWmec/St2gsWp4GxI/AAAAAAAAAPM/RbIiZeYxczE/s1600-h/GeminiDashboard.jpg" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" src="http://1.bp.blogspot.com/_ekahfMOWmec/St2gsWp4GxI/AAAAAAAAAPM/RbIiZeYxczE/s200/GeminiDashboard.jpg" /></a>
<br />
I know many people are excited about them and especially about project Gemini, here are some quotes I found on the net:<br />
<br />
<ul>
<li>Gemini enables end users to work with business data</li>
<li>100 million rows on a laptop with Office 2010 Excel</li>
<li>Slicers and spark lines in Excel 2010 are bringing BI to everyone</li>
<li>Excel 2010 provides BI for the masses by making it easy to build your own charts/graphs on and offline</li>
</ul>
<br />
I agree with all of them, BUT, the question is: are we missing the main goal of BI: “<b>single version of the truth</b>”. Is Gemini leading us to the next generation of “<b>Spreadmarts</b>”? Does having Excel and access to source data make a BI solution?<br />
<br />
From my experience, if you ask business-users to do something which requires more than 1 minute of technical training, most probably they get confused, and in most cases, anything more than 5 clicks away is considered as “too technical” and won’t be adobted by business users. So how do we expect them to get this toy and build a BI solution?!<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/_ekahfMOWmec/St2g7WRo6bI/AAAAAAAAAPU/pn2KkOnG_-4/s1600-h/Self_Service_BI.JPG" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" src="http://1.bp.blogspot.com/_ekahfMOWmec/St2g7WRo6bI/AAAAAAAAAPU/pn2KkOnG_-4/s200/Self_Service_BI.JPG" /></a><br /></div>
I believe the idea of "<b>Self Service BI</b>" is like a <b>double edged sword</b>, though it can be useful in the same way as we do self-service check out in supermarkets: do it yourself when you don’t have many items, so you can save time, but you will be responsible for that and if you get confused about something, that’s OK, you may ask a staff to help you out with that, but it may take more time than standing in line in the first place.<br />
<br />
However, it’s a quick way to discover the underlying data, and can be handy in some cases such as the following scenarios:<br />
<br />
<ul>
<li>If a business analyst needs to see what data is available in data sources</li>
<li>To analyse source data and create simple reports when underlying data is clean and in simple structure</li>
<li>To create a prototype for a reporting solution</li>
<li>BUT, when you are dealing with complicated logics to bring data in, or when there are too many data sources and you are not a BI specialist: forget about it!</li>
</ul>
<br />
I don’t want to be negative; I like Microsoft and their BI toolset, but is it the right way to go? Does it lead us to the “<b>BI for masses</b>” idea or towards “<b>messy BI</b>”?!<br />
<br />
I’d like to hear your thoughts.<br />Anonymoushttp://www.blogger.com/profile/03799141057142938532noreply@blogger.com2tag:blogger.com,1999:blog-3205109141980976345.post-72095687285071564292009-09-23T21:09:00.021+10:002009-09-23T23:12:26.515+10:00Handling Ragged/Unbalanced hierarchies in SSAS<div>
<b>What is it?</b>
<br />
</div>
<div>
</div>
<div>
<b>Balanced hierarchy:</b> In balanced (standard) hierarchies, branches of the hierarchy all have the same level (depth), with each member's parent being at the level immediately above the member.<br />
</div>
<div>
Example: time dimension, where the depth of each level (year, quarter, month, etc.) is consistent.
<br />
<div>
<a href="http://2.bp.blogspot.com/_ekahfMOWmec/SroCs_w69iI/AAAAAAAAAN8/CahPeTaNOSY/s1600-h/1_balanced_hierarchy.jpg" onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5384619276528973346" src="http://2.bp.blogspot.com/_ekahfMOWmec/SroCs_w69iI/AAAAAAAAAN8/CahPeTaNOSY/s320/1_balanced_hierarchy.jpg" style="cursor: hand; cursor: pointer; height: 125px; width: 320px;" /></a>
<br />
</div>
<div>
<b>
</b><br />
</div>
<div>
<b><br /></b><br />
<b>Unbalanced hierarchy:</b> the hierarchy branches can have inconsistent depths.<br />
</div>
<div>
Example of an unbalanced hierarchy is an organization chart. The levels within the organizational structure are unbalanced, with some branches in the hierarchy having more levels than others.
<br />
</div>
<div>
</div>
<div>
The following charts illustrate the unbalanced hierarchies:<br />
</div>
<div>
<a href="http://2.bp.blogspot.com/_ekahfMOWmec/SroDiI7ZbhI/AAAAAAAAAOE/BMGjFcaybZk/s1600-h/2_unbalanced_hierarchy.jpg" onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5384620189521899026" src="http://2.bp.blogspot.com/_ekahfMOWmec/SroDiI7ZbhI/AAAAAAAAAOE/BMGjFcaybZk/s320/2_unbalanced_hierarchy.jpg" style="cursor: hand; cursor: pointer; height: 134px; width: 320px;" /></a>
<br />
</div>
<div>
</div>
<div>
<a href="http://3.bp.blogspot.com/_ekahfMOWmec/SroEM9HDFgI/AAAAAAAAAOM/497K0zh9bTs/s1600-h/3_unbalanced_hierarchy.jpg" onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5384620925083915778" src="http://3.bp.blogspot.com/_ekahfMOWmec/SroEM9HDFgI/AAAAAAAAAOM/497K0zh9bTs/s320/3_unbalanced_hierarchy.jpg" style="cursor: hand; cursor: pointer; height: 214px; width: 320px;" /></a> <br />
</div>
<div>
</div>
<div>
<br />
</div>
<div>
<b>How to handle it on SSAS?</b>
<br />
</div>
<div>
There are 2 methods to handle ragged hierarchies on SSAS:<br />
</div>
<div>
</div>
<div>
<span style="font-size: large;"><span style="font-size: 18px;"><b><br /></b></span></span><br />
<b><span style="font-size: medium;">Using Parent/child dimension</span></b><br />
</div>
<div>
<b>
</b>In this method we need to create parent-child dimension. Parent-child dimension can be created on top of a parent-child table/view where each record has a reference to its parent record (e.g. ParentID column). An example of this type of tables can be found on Adventure Works sample database. <br />
</div>
<div>
</div>
<div>
</div>
<div>
<span style="font-size: large;"><span style="font-size: 18px;"><b><br /></b></span></span><br />
<b><span style="font-size: medium;">Using ragged hierarchy with "Hide Member If" property</span></b><br />
Another approach is to design a regular dimension on top of a ragged or unbalanced table/view.
Ragged hierarchy: In a ragged hierarchy, the logical parent member of at least one member is not in the level immediately above the member.<br />
</div>
<div>
Example: geography dimension which number of levels can be different on different countries. The levels provide a meaningful context to its members, thus, while Washington DC is a child of USA, it is included at the City level with Los Angeles. Therefore there will be nulls on some levels.
<br />
</div>
<div>
<a href="http://4.bp.blogspot.com/_ekahfMOWmec/SroGBKRTY1I/AAAAAAAAAOU/19Nzew0r7us/s1600-h/4_Table_Ragged_Hierarchy.jpg" onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5384622921481413458" src="http://4.bp.blogspot.com/_ekahfMOWmec/SroGBKRTY1I/AAAAAAAAAOU/19Nzew0r7us/s320/4_Table_Ragged_Hierarchy.jpg" style="cursor: hand; cursor: pointer; height: 192px; width: 320px;" /></a>
<br />
</div>
<div>
</div>
<div>
<a href="http://2.bp.blogspot.com/_ekahfMOWmec/SroHWPWddZI/AAAAAAAAAOk/vu0j_IfQHrk/s1600-h/5_Table_Unbalanced.jpg" onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5384624383134102930" src="http://2.bp.blogspot.com/_ekahfMOWmec/SroHWPWddZI/AAAAAAAAAOk/vu0j_IfQHrk/s320/5_Table_Unbalanced.jpg" style="cursor: hand; cursor: pointer; height: 213px; width: 320px;" /></a>
<br />
</div>
<div>
Note-1: We can also repeat the parent name instead of null as a placeholder.<br />
</div>
<div>
Note-2: In the example above, 1st and 2nd record will be required when we need to assign facts to non-leaf members. In this example we may need to assign a fact to CA which is a non-leaf member. <br />
</div>
<div>
<br />
Once we create the normal hierarchy, we can use <b>HideMemberIf</b> property to hide Nulls or repeated members.<br />
</div>
<div>
</div>
<div>
<table border="1" cellpadding="0" class="MsoNormalTable" style="border: solid #DDDDDD 1.0pt; margin-left: 3.95pt; mso-border-alt: solid #DDDDDD .75pt; mso-cellspacing: 1.5pt; mso-yfti-tbllook: 1184; width: 93.82%;"> <tbody>
<tr style="mso-yfti-firstrow: yes; mso-yfti-irow: 0;"> <td style="background: #CCCCCC; border-bottom: solid #C8CDDE 1.0pt; border: solid #CCCCCC 1.0pt; mso-border-alt: solid #CCCCCC .25pt; mso-border-bottom-alt: solid #C8CDDE .75pt; padding: 3.95pt 3.95pt 3.95pt 3.95pt;" valign="bottom"><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.95pt; margin-left: 0cm; margin-right: 0cm; margin-top: 3.95pt;">
<b><span style="color: #000066; font-family: Verdana, sans-serif; font-size: 8.5pt;">HideMemberIf Setting <o:p></o:p></span></b><br />
</div>
</td> <td style="background: #CCCCCC; border-bottom: solid #C8CDDE 1.0pt; border: solid #CCCCCC 1.0pt; mso-border-alt: solid #CCCCCC .25pt; mso-border-bottom-alt: solid #C8CDDE .75pt; padding: 3.95pt 3.95pt 3.95pt 3.95pt; width: 67.1%;" valign="bottom" width="67%"><div class="MsoNormal" style="line-height: normal; margin-bottom: 3.95pt; margin-left: 0cm; margin-right: 0cm; margin-top: 3.95pt;">
<b><span style="color: #000066; font-family: Verdana, sans-serif; font-size: 8.5pt;">Description <o:p></o:p></span></b><br />
</div>
</td> </tr>
<tr style="mso-yfti-irow: 1;"> <td style="background: white; border-right: solid #D5D5D3 1.0pt; border: solid #CCCCCC 1.0pt; mso-border-alt: solid #CCCCCC .75pt; mso-border-right-alt: solid #D5D5D3 .75pt; padding: 3.95pt 3.95pt 3.95pt 3.95pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: .8pt; margin-right: .8pt; margin-top: 0cm;">
<b><span style="font-size: small;">Never</span></b><span style="color: black; font-family: Verdana, sans-serif; font-size: 8.5pt;"> <o:p></o:p></span><br />
</div>
</td> <td style="background: white; border-right: solid #D5D5D3 1.0pt; border: solid #CCCCCC 1.0pt; mso-border-alt: solid #CCCCCC .75pt; mso-border-right-alt: solid #D5D5D3 .75pt; padding: 3.95pt 3.95pt 3.95pt 3.95pt; width: 67.1%;" valign="top" width="67%"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: .8pt; margin-right: .8pt; margin-top: 0cm;">
<span style="color: black; font-family: Verdana, sans-serif; font-size: 8.5pt;">Level members are never hidden.<o:p></o:p></span><br />
</div>
</td> </tr>
<tr style="mso-yfti-irow: 2;"> <td style="background: white; border-right: solid #D5D5D3 1.0pt; border: solid #CCCCCC 1.0pt; mso-border-alt: solid #CCCCCC .75pt; mso-border-right-alt: solid #D5D5D3 .75pt; padding: 3.95pt 3.95pt 3.95pt 3.95pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: .8pt; margin-right: .8pt; margin-top: 0cm;">
<b><span style="font-size: small;">OnlyChildWithNoName</span> </b><span style="color: black; font-family: Verdana, sans-serif; font-size: 8.5pt;"><o:p></o:p></span><br />
</div>
</td> <td style="background: white; border-right: solid #D5D5D3 1.0pt; border: solid #CCCCCC 1.0pt; mso-border-alt: solid #CCCCCC .75pt; mso-border-right-alt: solid #D5D5D3 .75pt; padding: 3.95pt 3.95pt 3.95pt 3.95pt; width: 67.1%;" valign="top" width="67%"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: .8pt; margin-right: .8pt; margin-top: 0cm;">
<span style="color: black; font-family: Verdana, sans-serif; font-size: 8.5pt;">A level member is hidden when it is the only child of its parent and its name is null or an empty string.<o:p></o:p></span><br />
</div>
</td> </tr>
<tr style="mso-yfti-irow: 3;"> <td style="background: white; border-right: solid #D5D5D3 1.0pt; border: solid #CCCCCC 1.0pt; mso-border-alt: solid #CCCCCC .75pt; mso-border-right-alt: solid #D5D5D3 .75pt; padding: 3.95pt 3.95pt 3.95pt 3.95pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: .8pt; margin-right: .8pt; margin-top: 0cm;">
<b><span style="font-size: small;">OnlyChildWithParentName</span></b><span style="color: black; font-family: Verdana, sans-serif; font-size: 8.5pt;"> <o:p></o:p></span><br />
</div>
</td> <td style="background: white; border-right: solid #D5D5D3 1.0pt; border: solid #CCCCCC 1.0pt; mso-border-alt: solid #CCCCCC .75pt; mso-border-right-alt: solid #D5D5D3 .75pt; padding: 3.95pt 3.95pt 3.95pt 3.95pt; width: 67.1%;" valign="top" width="67%"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: .8pt; margin-right: .8pt; margin-top: 0cm;">
<span style="color: black; font-family: Verdana, sans-serif; font-size: 8.5pt;">A level member is hidden when it is the only child of its parent and its name is the same as the name of its parent.<o:p></o:p></span><br />
</div>
</td> </tr>
<tr style="mso-yfti-irow: 4;"> <td style="background: white; border-right: solid #D5D5D3 1.0pt; border: solid #CCCCCC 1.0pt; mso-border-alt: solid #CCCCCC .75pt; mso-border-right-alt: solid #D5D5D3 .75pt; padding: 3.95pt 3.95pt 3.95pt 3.95pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: .8pt; margin-right: .8pt; margin-top: 0cm;">
<b><span style="font-size: small;">NoName</span> </b><span style="color: black; font-family: Verdana, sans-serif; font-size: 8.5pt;"><o:p></o:p></span><br />
</div>
</td> <td style="background: white; border-right: solid #D5D5D3 1.0pt; border: solid #CCCCCC 1.0pt; mso-border-alt: solid #CCCCCC .75pt; mso-border-right-alt: solid #D5D5D3 .75pt; padding: 3.95pt 3.95pt 3.95pt 3.95pt; width: 67.1%;" valign="top" width="67%"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: .8pt; margin-right: .8pt; margin-top: 0cm;">
<span style="color: black; font-family: Verdana, sans-serif; font-size: 8.5pt;">A level member is hidden when its name is empty.<o:p></o:p></span><br />
</div>
</td> </tr>
<tr style="mso-yfti-irow: 5; mso-yfti-lastrow: yes;"> <td style="background: white; border-right: solid #D5D5D3 1.0pt; border: solid #CCCCCC 1.0pt; mso-border-alt: solid #CCCCCC .75pt; mso-border-right-alt: solid #D5D5D3 .75pt; padding: 3.95pt 3.95pt 3.95pt 3.95pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: .8pt; margin-right: .8pt; margin-top: 0cm;">
<b><span style="font-size: small;">ParentName</span> </b><span style="color: black; font-family: Verdana, sans-serif; font-size: 8.5pt;"><o:p></o:p></span><br />
</div>
</td> <td style="background: white; border-right: solid #D5D5D3 1.0pt; border: solid #CCCCCC 1.0pt; mso-border-alt: solid #CCCCCC .75pt; mso-border-right-alt: solid #D5D5D3 .75pt; padding: 3.95pt 3.95pt 3.95pt 3.95pt; width: 67.1%;" valign="top" width="67%"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: .8pt; margin-right: .8pt; margin-top: 0cm;">
<span style="color: black; font-family: Verdana, sans-serif; font-size: 8.5pt;">A level member is hidden when its name is identical to that of its parent.<o:p></o:p></span><br />
</div>
</td> </tr>
</tbody></table>
<br />
</div>
<div>
</div>
<div>
</div>
<div>
</div>
<div>
</div>
<div>
<a href="http://3.bp.blogspot.com/_ekahfMOWmec/SroIMcKpegI/AAAAAAAAAOs/6aFhxJQt4xA/s1600-h/6_Dimension_Properties.JPG" onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5384625314287155714" src="http://3.bp.blogspot.com/_ekahfMOWmec/SroIMcKpegI/AAAAAAAAAOs/6aFhxJQt4xA/s320/6_Dimension_Properties.JPG" style="cursor: hand; cursor: pointer; height: 204px; width: 279px;" /></a>
<br />
<br />
</div>
<div>
Example of an Account hierachy:<br />
<br />
<a href="http://2.bp.blogspot.com/_ekahfMOWmec/SroIMusfAeI/AAAAAAAAAO0/qEWfk0hR4tM/s1600-h/7_Account+Hierarchy.JPG" onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5384625319260914146" src="http://2.bp.blogspot.com/_ekahfMOWmec/SroIMusfAeI/AAAAAAAAAO0/qEWfk0hR4tM/s320/7_Account+Hierarchy.JPG" style="cursor: hand; cursor: pointer; height: 275px; width: 248px;" /></a><br />
<br />
</div>
<div>
</div>
<div>
<b>
</b><br />
</div>
<div>
<b>Important notes:</b>
<br />
<ul>
<li>For large parent-child dimensions, aggregations are created only for the key attribute and the top attribute, therefore queries returning cells at intermediate levels are calculated at query time and can be slow. If you have a large parent-child hierarchy (more than 250,000 members), you may want to consider using a hierarchy with a fixed number of levels.</li>
<li>Microsoft recommends using P-C whenever you need to set unary operators.</li>
<li><b>DataMember </b>property only works in parent-child dimensions </li>
<li>You can’t cross-join levels on a parent-child hierarchy. It might cause some complications in report development</li>
</ul>
<b>References and more info:</b><br />
</div>
<div>
<b><span style="font-family: arial;"><span style="font-size: small;">
</span></span></b><span style="font-family: arial;"><a href="http://msdn.microsoft.com/en-us/library/ms365406.aspx"><span style="font-size: small;">http://msdn.microsoft.com/en-us/library/ms365406.aspx</span></a></span><br />
</div>
<div>
<span style="font-family: arial;"><a href="http://gerardnico.com/wiki/dw/hierarchie"><span style="font-size: small;">http://gerardnico.com/wiki/dw/hierarchie</span></a></span><br />
</div>
<div>
</div>
<div>
</div>
</div>Anonymoushttp://www.blogger.com/profile/03799141057142938532noreply@blogger.com10tag:blogger.com,1999:blog-3205109141980976345.post-64207558569237024292009-05-12T22:06:00.010+10:002009-05-25T11:11:09.305+10:00BI Seminar<p><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://3.bp.blogspot.com/_ekahfMOWmec/SglmpklJSvI/AAAAAAAAAN0/o22BK0Ei9S0/s1600-h/BI+Seminar+Iran+Tehran+2009.JPG"><img style="float:none; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 320px; height: 181px;" src="http://3.bp.blogspot.com/_ekahfMOWmec/SglmpklJSvI/AAAAAAAAAN0/o22BK0Ei9S0/s320/BI+Seminar+Iran+Tehran+2009.JPG" border="0" alt="" id="BLOGGER_PHOTO_ID_5334908097977207538" /></a></p>
<p>"BI for managers" seminar was successfully held by <a href="http://www.bisolutions.ir/">BI Solutions</a> in Simorgh hotel, Tehran on 22 April 2009.</p>
<p>The aim of this seminar was to introduce Business Intelligence to Iranian managers and show how BI (and Microsoft BI in particular) can deliver critical information to support timely and informed decisions.</p>
<p>More than 60 people from over 20 different companies attended, including representatives from National Oil Company, National Gas Company, National Statistics Org, Iran Khodro and SAIPA which are the largest automotive companies in Iran, and other large organisatons.</p>
<p>The program started with an introductory presentation from me, then Dr Abdollah Zadeh from Amir Kabir University (I can call him "the father of BI in Iran") expanded the subject with his presentation about "BI, Why, How?", then Danial Moazen discussed about problems and challenges that may arise in BI projects.</p>
<p>
The event continued with a presentation by Neo Farvashan (MVP) about MOSS and BI, after that I introduced Microsoft BI followed by a demo on MS BI capabilities (PPS Scorecards and dashboards) to provide performance management.
At the end I spoke about "implementation of BI solutions" and finished it with Q&A.</p>
<p> I believe it was a very successful event and I would like to thank my friends at <a href="http://www.bisolutions.ir/">BI Solutions</a> and Fanafzar, especially <a href="http://amiross.blogspot.com/">Amir Fassihi</a> who supported me on organising this event.
</p>Anonymoushttp://www.blogger.com/profile/03799141057142938532noreply@blogger.com2tag:blogger.com,1999:blog-3205109141980976345.post-68764696131988487432009-03-11T16:07:00.008+11:002009-03-11T16:29:59.184+11:00New MS BI Burger - Delivering BI to everyone in the organization<a href="http://1.bp.blogspot.com/_ekahfMOWmec/SbdKyEwzebI/AAAAAAAAANk/sAbM74MLED4/s1600-h/MS+end-to-end+BI+Solution+2008.JPG"><img style="MARGIN: 0px 10px 10px 0px; WIDTH: 320px; HEIGHT: 276px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5311796509639145906" border="0" alt="" src="http://1.bp.blogspot.com/_ekahfMOWmec/SbdKyEwzebI/AAAAAAAAANk/sAbM74MLED4/s320/MS+end-to-end+BI+Solution+2008.JPG" /></a>
<div>After Microsoft announced that Office PPS 2007 would be folded into Microsoft Office SharePoint Server Enterprise 14 - which was officially death of PerfomancePoint Server - there's been slight changes on the famous "Microsoft BI Burger". </div>
<div>
The new burger was designed to deliver Business Intelligence to the masses via SharePoint based under idea of "Delivering BI to everyone in the organization". </div>
<div></div>Anonymoushttp://www.blogger.com/profile/03799141057142938532noreply@blogger.com2tag:blogger.com,1999:blog-3205109141980976345.post-25799013875944908572009-01-27T12:08:00.003+11:002009-01-27T12:35:36.030+11:00Farewell PPS!<p><strong>"There will be no future version of PerformancePoint Server."</strong>
</p>
<p>
Microsoft will consolidate PerformancePoint Server (PPS) with its scorecards, dashboards, and analytic capabilities into SharePoint as "PerformancePoint Services" with the release of SharePoint 14 in late 2009.
</p>
<p>
<a href="http://blogs.msdn.com/bi/archive/2009/01/23/microsoft-bi-strategy-update.aspx">http://blogs.msdn.com/bi/archive/2009/01/23/microsoft-bi-strategy-update.aspx</a>
</p>
<p>
Not a good news at all for MS BI world! I'm not surprised about "Planning" module as I believe it was NOT successful, but embedding "Monitoring & Analytics" into SharePoint, mmmmmmm?!
</p>
<p>
Other links:
</p>
<p>
<a href="http://performancepointinsider.com/blogs/bsm/archive/2009/01/22/just-call-me-performancepoint-services.aspx">http://performancepointinsider.com/blogs/bsm/archive/2009/01/22/just-call-me-performancepoint-services.aspx</a>
</p>
<p>
<a href="http://nickbarclay.blogspot.com/2009/01/rip-performancepoint-server.html">http://nickbarclay.blogspot.com/2009/01/rip-performancepoint-server.html</a>
</p>Anonymoushttp://www.blogger.com/profile/03799141057142938532noreply@blogger.com0tag:blogger.com,1999:blog-3205109141980976345.post-45602955486764811182009-01-23T11:34:00.004+11:002009-01-23T12:08:33.961+11:00Magic Quadrant for Business Intelligence Platforms, 2009<p>Gartner is an information technology research and advisory firm which provides research analysis and advice for IT professionals, technology companies and the investment community.</p>
<p>The "Magic Quadrant for BI" by Gartner, presents a global view of Gartner's opinion of the main software vendors that should be considered by organizations seeking to develop business intelligence (BI) applications.</p>
<p>
<a href="http://1.bp.blogspot.com/_ekahfMOWmec/SXkVzkqXaCI/AAAAAAAAAMw/ZpU_5manCVM/s1600-h/Gartner+2009.png"><img id="BLOGGER_PHOTO_ID_5294286812709611554" style="WIDTH: 312px; CURSOR: hand; HEIGHT: 320px" alt="" src="http://1.bp.blogspot.com/_ekahfMOWmec/SXkVzkqXaCI/AAAAAAAAAMw/ZpU_5manCVM/s320/Gartner+2009.png" border="0" /></a>
</p>
<p>See the full article here: <a href="http://mediaproducts.gartner.com/reprints/sas/vol5/article8/article8.html">http://mediaproducts.gartner.com/reprints/sas/vol5/article8/article8.html</a></p>Anonymoushttp://www.blogger.com/profile/03799141057142938532noreply@blogger.com0tag:blogger.com,1999:blog-3205109141980976345.post-87891021323456373592009-01-03T22:07:00.011+11:002009-01-03T23:16:45.827+11:00Tips for gathering "Business Requirements" in a BI project.<p>In my opinion the most important and challenging aspect of a BI project is to understand the business requirements. Majority of BI projects failures are due to lack of understanding the business. This lack is primarily due to BI being thought as an IT project, instead of being a business project with IT as one of the enablers.
</p>
<p>It's very important to find out "what they need" and not just focus on "what they want". The most effective way of doing that is by "face to face" meetings with managers, business users and IT people. The goal of a requirements interview is to ask questions in order to discover unknown frontiers. Think of it as a one-hour immersion to better understand what business people do and why. How do they make decisions today, and how do they want to be making decisions in the future? First ask interviewees about their roles and responsibilities to get them engaged and from there, cover the following areas: </p>
<ul>
<li>What are the key business objectives? </li>
<li>For each objective, ask about measures for success to learn more about key metrics and business dimensions. </li>
<li>What roles do data and analysis play in achieving goals? Alternatively, how would better access and analysis benefit them? </li>
<li>What are the current analysis challenges? </li></ul>
<p>
A good question to get the interview started is "How can people tell when you're doing a great job?" </p>
<p><strong>Be conversational:</strong> For the DW/BI practitioner, being conversational means putting yourself into a business frame of mind. <strong>Learn the language of the business</strong>. Don't intimidate end users by asking "What do you want in a data warehouse?" End users aren't systems designers. Acronyms and IT vernacular don't belong in a business requirements interview. </p>
<p>Several techniques can help you establish a more conversational tone:</p>
<ul>
<li>Learn a bit about the business beforehand by reviewing the Web site or annual report to understand company-specific vocabulary and hot-button issues. </li>
<li>Meet with interviewees on their own turf. Go to their offices or conference rooms, rather than IT meeting spaces. </li>
<li>Prior to the interview, send out an announcement describing the high-level discussion topics and confirming the interview time and place. Don't attach a detailed questionnaire to this meeting notice. You can't achieve a conversational flow if you're reviewing questionnaire results-presuming anyone bothers to complete the survey. </li>
<li>Interview questions prepared in advance are fallback devices, used only if uncomfortable lulls occur in conversations or to ensure key points are covered before ending sessions. </li>
<li>Most good conversations tend to wander, so remember your session goals and steer conversations back on track if you stray too far from core issues. </li>
<li>Stay at a relatively high level in the interview's early stages. Don't follow an early comment to a very low level of detail, only to run out of time and discover that you haven't discussed three other major areas of responsibility with important requirements for the DW/BI effort.</li></ul>
<p><strong>Listen, and expect to be changed:</strong> Good interviewers should be seen but not heard — well, at least not heard too much. Strong active listening skills are required.</p>
<p>As you're gathering requirements from the business users, intersperse some data reality into the process by interviewing key IT personnel, especially the master database administrators responsible for operational systems. Consider what the business needs are in tandem with the availability of data to support these requirements. IT meetings tend to be informal discussions, beginning with knowledgeable project team members. Once you start to hear consistent themes from users, it's time to sit down with the data gurus and get into the extreme detail of their source systems. During these data audit interviews, try to understand whether complete, reliable data is there to support what users are asking for. </p>
<p><span style="font-family:times new roman;font-size:85%;">There are several methods and resources for BIR, one of the best is "The Data Warehouse Lifecycle Toolkit by R. Kimball, ...".</span></p><p><span style="font-family:Times New Roman;font-size:85%;"></span></p><a href="http://4.bp.blogspot.com/_ekahfMOWmec/SV9VHt80tsI/AAAAAAAAAMo/s826C-yRzA8/s1600-h/BIR.gif"><img id="BLOGGER_PHOTO_ID_5287038078638405314" style="WIDTH: 320px; CURSOR: hand; HEIGHT: 213px" alt="" src="http://4.bp.blogspot.com/_ekahfMOWmec/SV9VHt80tsI/AAAAAAAAAMo/s826C-yRzA8/s320/BIR.gif" border="0" /></a>
<p>
</p>Anonymoushttp://www.blogger.com/profile/03799141057142938532noreply@blogger.com26tag:blogger.com,1999:blog-3205109141980976345.post-67428344101681992472008-10-26T17:28:00.010+11:002008-10-26T21:16:17.826+11:00MCTS & MCITP Certifications for SQL Server 2008 BI<p>Last week I got the results of those beta exams (<a href="http://iman77.blogspot.com/2008/07/feedback-on-beta-exam-71-448.html">71-448</a>, <a href="http://iman77.blogspot.com/2008/09/feedback-on-71-452-70-452-exam.html">71-452</a>) and surprisingly, I passed both!
</p>
<p>
The surprise was because I passed them though I hadn't had a chance to work with SQL Server 2008 in a real project before, and that means there is something wrong with the exams that you can pass them based on your SQL Server 2005 experience and just reading about new features of the 2008 version.
</p>
<p>But the good thing is that I've passed them and there is nothing to worry about till the next version! The next version of SQL Server code-named "Killimanjaro", will be released in the first half of 2010, according to Microsoft officials. The first tech preview test builds of Kilimanjaro are due in the first half of 2009. It will provide the foundation for Microsoft's first data warehouse appliance, code-named Madison, and a BI tool called Gemini that's being designed to bring a broader range of employees into the BI fold.
</p>
<p>
<img style="cursor:pointer; cursor:hand;width: 400px; height: 63px;" src="http://3.bp.blogspot.com/_ekahfMOWmec/SQQqGrDWULI/AAAAAAAAAI8/8EU91RLxgiU/s400/MCTS(rgb)_1271.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5261376558799933618" />
</p>
<p>
<img style="cursor:pointer; cursor:hand;width: 324px; height: 60px;" src="http://2.bp.blogspot.com/_ekahfMOWmec/SQQnlqz1oEI/AAAAAAAAAI0/rZNAkab1wAk/s400/MCITP(rgb)_1257.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5261373792775938114" />
</p>Anonymoushttp://www.blogger.com/profile/03799141057142938532noreply@blogger.com0tag:blogger.com,1999:blog-3205109141980976345.post-8241180827530071792008-09-11T12:43:00.003+10:002008-09-11T14:09:16.464+10:00A feedback on 71-452 (70-452) exam: Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008I sat on that beta exam yesterday and here are some points:
<ul><li>There are 75 questions and the time is 3 hours which is a bit tight</li><li>Unlike 70-446, there is no case scenario and all questions are standalone (not related to each other) </li><li>Many data mining questions. Mostly about choosing the best algorithm.</li><li>A few around upgrading and migration strategy </li><li>Many questions about new features in SQL 2008, like CDC, MERGE, … </li><li>From the name of exam, I expected to see more “Design” related questions, but there were many development questions which I think they could be moved to the TS exam (70-448)
</li></ul><p>
As usual I recommend you to have a look at the topics <a href="http://www.microsoft.com/learning/en/us/exams/70-452.mspx">here</a> and work on those that you are not familiar with.
</p><p>
I must wait for few weeks to get the result. Fingers crossed! </p>Anonymoushttp://www.blogger.com/profile/03799141057142938532noreply@blogger.com2tag:blogger.com,1999:blog-3205109141980976345.post-13346037153555720702008-08-29T13:16:00.006+10:002008-08-29T13:47:25.472+10:00An excellent quote"The world is governed more by appearances than realities, so that it is fully as necessary to seem to know something as to know it. "
<br />
- Daniel Webster"Anonymoushttp://www.blogger.com/profile/03799141057142938532noreply@blogger.com3tag:blogger.com,1999:blog-3205109141980976345.post-58721108086919750612008-08-27T13:29:00.003+10:002008-08-29T13:43:48.219+10:002008 CIO Technology PrioritiesAccording to a survey by Gartner "Business Intelligence Applications" is the highest priority for CIOs. Here is the top 10 result:
<p>
<a href="http://2.bp.blogspot.com/_ekahfMOWmec/SLduaxHNw1I/AAAAAAAAAIk/E3yhz-YB850/s1600-h/Gartner+-+2008.JPG"><img id="BLOGGER_PHOTO_ID_5239778097608115026" style="CURSOR: hand" alt="" src="http://2.bp.blogspot.com/_ekahfMOWmec/SLduaxHNw1I/AAAAAAAAAIk/E3yhz-YB850/s400/Gartner+-+2008.JPG" border="0" /></a>
</p>Anonymoushttp://www.blogger.com/profile/03799141057142938532noreply@blogger.com0tag:blogger.com,1999:blog-3205109141980976345.post-75983974310438525932008-08-13T22:21:00.005+10:002008-08-20T10:58:49.723+10:00SQL Server 2008 RTM<p>Download SQL Server 2008 Enterprise 180-day evaluation from here:
<ul>
<li><a href="http://www.microsoft.com/downloads/details.aspx?familyid=6B10C7C1-4F97-42C4-9362-58D4D088CD38&displaylang=en">Trial Experience for Developers</a>
</li>
<li><a href="http://www.microsoft.com/downloads/details.aspx?FamilyId=265F08BC-1874-4C81-83D8-0D48DBCE6297&displaylang=en&hash=7Lk3teT86ugOD08Gb2ijshYPI2O8JNd6FVECBGwJYL8bgnVK1JJvK%2bthGKPJf2jqegvVwytNXcrBkfm7UbgSLg%3d%3d">Trial Experience for IT Professionals</a></li></ul>
</p>
<p>SQL Server 2008 Feature Pack (August 2008). It contains 17 new redistributable and backward compatibility components and add-on providers. Download it from here:</p>
<ul>
<li><a href="http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en">SQL Server 2008 Feature Pack - Aug 2008</a>
</li></ul>
<p>
Have you ever wondered what the last meeting before a product ships is like? Have a look at <a href="http://edge.technet.com/Media/Inside-the-SQL-2008-Ship-room/">inside the SQL 2008 ship room!</a>.
</p>
<p>
<img id="BLOGGER_PHOTO_ID_5236395509883632178" style="CURSOR: hand" alt="" src="http://2.bp.blogspot.com/_ekahfMOWmec/SKtp-P4QejI/AAAAAAAAAIc/gtbTjR2RoHk/s400/SQL+2008+RTM+banner.jpg" border="0" />
</p>Anonymoushttp://www.blogger.com/profile/03799141057142938532noreply@blogger.com0