Browse by Tags
All Tags »
PowerPivot (
RSS)
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...
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...
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 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...
In a short newspaper article a friend stumbled upon, he saw that Mr. Kamal Hathi , Director of Program Management at Microsoft is coming to Israel for the Think Next Convention. It was also detailed that Mr. Hathi was responsible for the SQL Server Business Intelligence technologies. As the time of the convention drew nearer, I felt more and more interested in trying to catch him for an interview about SQL Server 2012. At the end, I had to finish my questions quickly as Mr. Hathi did not stay till...
SoftArtisans have approached me to write a review about OfficeWriter v8 integration with SSRS. Your first question would be: what's OfficeWriter? :) OfficeWriter is an application that works with Reporting Services in two ways: 1. It Allows you to design a report in Word or Excel and render it to an RDL 2. It allows you to take data from an RDL report and use it in a Word or Excel document I believe just those two point hold within them quite a lot, but we'll get to that shortly. I decided...
SQL Server 2012 was released last weekend (and yes, I know this means I’m late to blog about it!). Along with it were released the Data Mining Add-In for Excel 2010 (with a 64 bit version) and PowerPivot v2.0 . Whether your company just bought SQL Server 2012 , you downloaded the Express Edition or the Evaluation, you could probably still use some help. The ” Introducing Microsoft SQL Server 2012 (second DRAFT preview)” EBook was released in January and is free to download – enjoy!
As SQL Server 2012 and PowerPivot v2 release is getting closer and closer, knowing DAX becomes more of a necessity than a just an option. Via Kasper de Jonge ’s blog I had learned of a nice 30 minutes Introduction to DAX basics . You can download an example workbook and try your hand at creating a measure formula and adding up to adding filter context to your formula. The post also had a ling to the TechNet Wiki page for the DAX Resource Center which has loads of articles, downloads and videos, along...
I was in the BI User Group meeting today (and if you're in Israel, why didn't you come too?) and heard something quite exciting. The speaker was Yossi Elkayam from Microsoft Israel and what he mentioned twice was that the release date for SQL Server 2012 Denali is March 2012. He was saying that while stating next month's meeting will preview the new release scheduled for the month after that. He also mentioned that PowerPivot version 2 will be released in proximity to the release of SQL...
TechEd North America 2011 wrapped up last week with big news about PowerPivot and SSAS. Just in case you haven't read it already somewhere else, I'll give you a very short re-cap. In SQL Server 2005, the UDM was supposed to encapsulate the solution for modeling your project. In SQL Server 11, codename Denali, it's going to be replaced by BISM - the Business Intelligence Semantic Model. All the reporting tools in the Microsoft BI Stack will work against this model. In Denali, you will...
Ok, so the unexpected happened - about a month and a half after interviewing Mr. Donald Farmer , I got to interview Mr. Amir Netz and Mr. Ariel Netz ! I know!... You probably remember Mr. Amir Netz from his appearance in the recent keynote session in the BI conference in New Orleans. He spoke about what's going to be new in PowerPivot. When I heard he was coming to Israel for a conference discussing Panorama and PowerPivot , I decided I'd try to get a few more tidbits from him... In the keynote...
Mr. Amir Netz , Distinguished Engineer at Microsoft, came to lecture about Self - Service BI and Panorama, along with Kobi Averbuch , VP of R&D at Panorama . These are a few of the major points in their lecture: PowerPivot IT cannot meet all demands. People will try to find a solution themselves. We need a technology to bridge the gap. How to build a PowerPivot application We start by installing the PowerPivot add - in. PowerPivot runs in - memory using the Vertipaq engine that ensures quick...
More Posts
Next page »