Browse by Tags
All Tags »
ITPro (
RSS)
Just in case you haven't heard yet, SQL Server 2014 is already in the works. Release cycle for SQL Server has become one of 2 years lately and not 3 (SQL Server 2008, 2008 R2 and 2012) and this is no exception. SQL Server 2014 was first discussed in the last TechEd with a few sessions taking an overview of its main features: Hekaton - in memory built into the SQL Server engine for OLTP and data warehousing. Hekaton was already previewed in a few sessions in TechEd, mostly talking about the advantages...
We installed Panorama Nova View Flash 6.2.5 and wanted to use it to connect to PowerPivot. While beginning the work, we couldn't connect to the PowerPivot files and would get an error message. My colleague Tomer Horev was in charge of SharePoint installation and also found the following solution. We understood what the problem was through the help of Panorama support. We tried to connect to the cube that's created for our PowerPivot file through the Management Studio. That meant connecting...
Yes I know. I can hardly believe it myself. I'm here again. And I'm glad to be back. So… to business! We wanted to create reports on an excel file our user was updating. We loaded the data into PowerPivot, published the Excel 2010 file into a SharePoint 2010 library and then created Panorama Flash views on top of that (and that's me making a very long story short!). The daily Excel data update worked fine until… one day it didn't. Obviously it's just a few days before a presentation...
Microsoft recently released a CTP of Power View on SSAS Multidimensional , (and yes, I know I'm a bit late writing about this, but I still wanted to give my two cents on it). So we're edging closer towards the point where Power View and Excel will be able to cover all of your viewer needs (or at least most of them :)). Years ago when I wrote about Report Builder on a cube and all the problems that that relationship created, I wondered when that would be fixed. Now that we have Power View...
I have recently been to the last BI User group which hosted a lecture from Mr. Dany Hoter , Senior Program Manager at Microsoft. Last time I saw Mr. Hoter speak was about Excel 2007. Yes, it's been a while. But I dare say that the fact I remember his lecture, speaks volumes on how much I enjoyed hearing him. This time around, Mr. Hoter spoke to us about Excel 2013 (how time flies...) The lecture itself was filled with demos Mr. Hoter did and showed on an Excel 2013 workbook he put at an Office...
I've decided to make a post to round up all the learning days of MOC 50429 SharePoint 2010 Business Intelligence. Hope this somehow helps you reach all the data: SharePoint 2010 BI Center and Excel Services SharePoint 2010 PerformancePoint Dashboard SharePoint 2010 Designer SharePoint 2010 and BI: PowerPivot and Entity Profile Page Access and Visio Services and Spatial Data in SharePoint 2010 Reporting Services and JavaScript in SharePoint 2010 I would also like include for all us beginners videoes...
So the price is still right - and yes, it's free! Marina my colleague from work sent me a really great link so obviously I had to share it with all of you. In his blog about Microsoft SMS&P Partner Community Blog , Mr. Eric Ligman has published a very extensive list of free Microsoft eBooks on SharePoint, Visual Studio, Windows Phone, Windows 8, Office 365, Office 2010, SQL Server 2012, Azure, and more. The list is very comprehensive and I recommend you go over it and also look at the additional...
I have recently posted an article in Silicon India comparing SQL Server 2012 BI tools and means of development. I addressed there the tools in SQL Server 2012: SSRS, Report Builder 3.0, Power View, Tabular and Multidimensional Analysis Services. Though I tried to cover much ground in the article, I would still recommend some additional reading: A short comparison between Tabular mode vs. PowerPivot A more detailed comparison between Tabular mode vs. PowerPivot vs. Multidimensional SSAS
I have recently finished MOC 50429 SharePoint 2010 Business Intelligence with Lior Cohen Amikam which I found very enlightening. I thought I’d share with you some of the excerpts from my summaries throughout the course. It’s a mix of ideas of what to do with SharePoint BI abilities and a short description of what they are. This is the sixth post in a series of posts that I am making from the material of the course: Reporting Services 2008 R2 In Report Builder 3.0 we can use report parts that exist...
This is a summary of a lecture given in the last BI User Group meeting in Israel by Mr. Itay Braun : SSAS will give you better performance on top of a DWH of a few Terras (2+) rather than Tabular mode. That's because of the data summary and compression SSAS does to the data. Tabular is not necessarily faster than MOLAP. Tabular mode is a new DB engine with 2 possible modes of interaction: 1. Tabular Mode - Column store - In memory - Compression (~1:3) - All the data copied 2. Direct SQL - Queries...
I have recently finished MOC 50429 SharePoint 2010 Business Intelligence with Lior Cohen Amikam which I found very enlightening. I thought I’d share with you some of the excerpts from my summaries throughout the course. It’s a mix of ideas of what to do with SharePoint BI abilities and a short description of what they are. This is the fifth post in a series of posts that I am making from the material of the course: Access Services Making the data in access available to everybody – just like with...
I have recently finished MOC 50429 SharePoint 2010 Business Intelligence with Lior Cohen Amikam which I found very enlightening. I thought I’d share with you some of the excerpts from my summaries throughout the course. It’s a mix of ideas of what to do with SharePoint BI abilities and a short description of what they are. This is the fourth post in a series of posts that I am making from the material of the course: Entity Profile Page If the entity I’m using is for instance a customer, and the table...
Via BI/BPM - The SeeQueL , I have recently learned of a great new site I would like to share with you: MSBIAcademy . MSBIAcademy is a site created by Rob Kerr , SQL Server MVP and CTO at BlueGranite. The site currently offers lessons on: Excel, Integration Services, Data Warehouse Design, SQL Server, Mobile, SharePoint, Analysis Services (both Tabular and Multidimensional) and PowerView! Quite the impressive list. Most lessons are on the latest version of SQL Server, but guide lines given in them...
I have recently finished MOC 50429 SharePoint 2010 Business Intelligence with Lior Cohen Amikam which I found very enlightening. I thought I’d share with you some of the excerpts from my summaries throughout the course. It’s a mix of ideas of what to do with SharePoint BI abilities and a short description of what they are. This is the third post in a series of posts that I am making from the material of the course. Business Connectivity Services (BCS) Business Connectivity enables me to connect to...
I have recently finished MOC 50429 SharePoint 2010 Business Intelligence with Lior Cohen Amikam which I found very enlightening. I thought I’d share with you some of the excerpts from my summaries throughout the course. It’s a mix of ideas of what to do with SharePoint BI abilities and a short description of what they are. This is the second post in a series of posts that I am making from the material of the course. PerformancePoint PerformancePoint Dashboard Designer is the place where we connect...
More Posts
Next page »