How to shrink an Excel when connecting to a DB

Tuesday, November 12, 2013

A colleague in the IT department wanted to send his clients a report in Excel which was actually a pivot table on data from their DWH. He created the file easily enough. He defined on the Data tab in Excel a connection from SQL Server. He chose to connect to a specific table in the relevant DB. He could then edit the connection he created through the Data tab > connections > choosing the relevant connection and then properties and then edit the query on the Definition tab, through the Command Text box.   ...
no comments

The refresh operation failed for PowerPivot on SharePoint 2010

Thursday, April 11, 2013

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 to our head of department :) My colleague Tomer Horev,...

Free Lesson for SQL Server and SharePoint

Tuesday, June 12, 2012

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 are true for earlier versions as well. I highly recommend you check out MSBIAcademy as in short lessons of...

SharePoint 2010 BI Center and Excel Services

Wednesday, May 16, 2012

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 will be the first post in a series of posts that I am making from the material of the course.   My Site in SharePoint We can leverage the user’s personal page to show his photo (a personal touch), his history of reports and his...

OfficeWriter v8 for SSRS

Wednesday, April 4, 2012

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 to try my hand at creating a report on Adventure Works data: I...

Amir Netz and Ariel Netz Talk on PowerPivot, DAX, Report Builder and PivotViewer

Monday, August 16, 2010

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 session, Mr. Netz had talked about adding the ability to...

Donald Farmer on SQL Server 2008 R2, SharePoint and PowerPivot

Monday, June 14, 2010

If you're following this blog, then you know that Sunday, May 30th 2010, I went to the SQL & BI Data Platform convention held in Tel Aviv. Specifically, I went to Mr. Donald Farmer's seminar on Data Integration in Large Organizations. I did live blogging from most of the event, though actually, I didn't manage to blog about the last part of it, because I was preparing for something that was pretty big for me.... I'll start over. When I first heard Mr. Farmer was coming to lecture in Israel, I was like "What? Really? Like, Donald Farmer? Like THE...

BI capabilities in Office 2010 – SharePoint, Excel and Project

Wednesday, May 12, 2010

Office 2010 RTM - ed on the end of April. You probably heard already about PowerPivot and Excel 2010. And of course there's also SharePoint 2010 which has Excel Services, Visio Services, Access Services, PerformancePoint Services and PowerPivot integration. Still, that doesn't make for the entire BI scope in Office 2010. I have just recently learned that there are BI capabilities in Project Server 2010. Going deeper I have learned that there were already such capabilities in Project Server 2007 which integrated with PerformancePoint Services 2007... still, never too late to learn something new :) Project 2010 has multiple...

Panorama now integrates with PowerPivot and SharePoint 2010

Monday, March 15, 2010

A while ago, I saw Panorama was advertising a webcast detailing how Panorama gives a complete solution for the entire Microsoft BI platform, including PowerPivot. I have to admit, just seeing Panorama and PowerPivot in the same sentence seemed odd to me, as PowerPivot seemed like a completely full solution for its purpose. I didn't see what Panorama had to add to the equation. And so I began asking Panorama a few questions... So where does Panorama offer any added value? Well, if your organization is considering using SharePoint 2010 Enterprise Edition along with PowerPivot. If you are going to deploy...

Microsoft Business Intelligence Roadshow: פרספקטיבת צרכן המידע בינה עסקית בשירות עצמי

Tuesday, February 16, 2010

Self Service BI ב Excel 2010 מתבטא במספר אופנים:שילוב SSAS מחוונים ויזואליים חדשיםפילטור מתקדםData miningPowerPivot (כולל שפת התכנות החדשה של DAX) אקסל גם משולב באופן אינטגרלי עם SharePoint 2010. Excel Services מאפשר לנו ניהול של אפליקציות האקסל מבחינת הרשאות, Workflow ארגוני והקצאת משאבים. בהערת אגב, מציין גם מר לוקוויקי כי ה thin client מאפשר למיקרוסופט גם להתחרות ב Google docs. השימוש באקסל דרך Excel Services מאפשר לעשות את מרבית הפעולות שאפשר לעשות על אקסל בדסקטופ המקומי. לעיתים, אנחנו מתחילים את האפליקציות BI שלנו כתוצאה מאקסל ש Power User פיתח לניהול הנתונים. כיום, הכוח שניתן למשתמשים מחזק את הצורך שלנו כמפתחים להכיר...