Archive

Posts Tagged ‘Excel’

Office 365 Products Visio Stencil & Icons available (updated for 2019) #o365 #visio

Just a quick post to say that I have uploaded a new Visio stencil for Office 365 products that I created to aid my own solution designs and I hope you find them useful too.

Link on Technet Galleries: https://gallery.technet.microsoft.com/Office-365-Products-Visio-ec6512de

Here is an example of the Visio Icon Set

I have also included the original image icons used to create the stencil which is useful for PowerPoint etc. too

Below is an example of the images used in the stencil. I have updated them to be inline with the new Office 365 Icon Re-Design that rolled out recently.

All images are available either in PNG format as part of the download and in some cases, the original SVG files.

Business Intelligence in the cloud, phew thank goodness… #Office365 #BI #SharePoint #PowerBI

So the Worldwide Partner Conference is going on in Houston at the moment and as much as I would love to be there, unfortunately projects here in London have to continue.  Still early starts and watching the world go by in Pret (coffee shop for those outside of the UK) is always interesting before the hub-bub of the day starts.

Anyway, as with every year at WPC, there are always exciting announcements and this year is no different.  We can hail this as official business intelligence in the cloud day!3731.SUMMARY_MobileBI_300x166.jpg-550x0

Now many of the projects I work on consider Office 365 as a platform, however the more enterprise you go, the more the requirements tend to need some level of business intelligence.  I was excited before with the release of SQL Reporting Services Online, however as functional as it is, limitations and costs current pose this solution to be only for the fully cloud invested.

My new hopes for BI in the cloud however seem to be starting to be answered in the form of Power BI for Office 365.

Using the capabilities already available on premise (Data Explorer, GeoFlow, Power Pivot and Power View) with tweaking, some re-branding and a little bit of mobile love (mobile apps to be available also (Windows 8, RT and iPad, HTML5) it looks like we may have an answer.

This to my mind almost completes the Office 365 capabilities to truly propel the cloud for use in the projects I get involved in.  (Project Management, Business Intelligence, Intranets, ECM solutions).

I urge you all to read up on the following and register for the preview coming “later this summer”.  I have a feeling this is going to be major!

Details:

    0027.imge.png-550x0

As I try things out, I will post my findings and any limitations I come across, but hopefully with the new OData / REST capabilities of Excel and SSRS, we should be able to have some fun with SharePoint list data!

Enjoy…

Chart Web Part SharePoint 2010

October 12, 2012 Leave a comment

The SharePoint 2010 Chart Web Part is a very useful tool. It has lots of capablity out-of-the box. You can extract data from and Excel sheet and display that data via graphs on a SharePoint 2010 page. This videos shows you how.

Note: the Excel file must be uploaded to a SharePoint document library.

%d bloggers like this: