April 2016 - Posts

I always am amazed at what can be done on websites and in reports and in general with technology today to make things look visually amazing. You only have to look at the animated movies nowadays to look at the extremes, or the videos of people using photo shop to morph a cat into a dog. Amazing.

 

What also never fails to surprise me is how easy it looks and then when I go and try it looks maybe not so slick. If you want examples of the my awesome design skills one only has to look at the SQLBits.com website.

image

 

Visual data representation whether it be a dashboard or a report is one of these areas. Doing it well takes experience.

 

With the custom visuals in Power BI you can really do some amazing things. (You can do some amazing things in Reporting Services as well if you had enough time)

 

If you are interested in designing awesome PowerBI then you must attend this webinar

https://info.microsoft.com/CO-PowerBI-WBNR-FY16-04Apr-19-Design-Reports-in-PowerBI-Registration.html?ls=social?yammer

 

“Reporting is more than just charts, numbers, and percentages...designing a report is an art form. In this presentation, Miguel Myers will teach you the difference between reports, indicators/gauges, presentations, dashboards, and infographics; including how you can take advantage of each one and how you can design them using Power BI. Miguel will teach you his secrets, such as how using other external tools to understand color, texture, space, balance and saturation can help you to create unique and clean designs.

Using colors, shapes, fonts, and images are just 30% of the labor when you create a report. There are other secrets behind the shiny charts and shapes that make your report complete; secrets that even experts don't want to share at all.

Are you ready to design your reports as never before? Please join us to learn more about data graphic design. Invite your employees, coworkers, bosses, and friends. “

Posted by simonsabin | with no comments

The SQL Server Reporting Services Manager web portal has been re-written for 2016.  and this has provided a number improvements that have made it very quick.

 

In doing that they’ve made some changes to the UI. The first thing that got me was, “where are my data sources”. I had written a littel powershell script to upload reports, data sets and data sources but when I went into the portal they weren’t there.

 

At this point my question were is it an issue with my powershell, my install of SQL Reporting Services 2016 or somethign else.

 

I finally convinced myself that the first two weren’t the issue by looking at what was returned from the webservices I dig some digging. and hey presto.

 

There is a new “View” button in the menu that allows you to display different object types and data sources are off by default. I’m not sure I like the behaviour, if you don’t want them displayed hide them.

image

What I would like to see is that when you have a view that is filtered that there is some indication that there are other objects that have been filtered from the view. I’m not the only one that will wonder where there objects are.

 

To download and try SQL Server 2016 go to http://www.microsoft.com/en-gb/server-cloud/products/sql-server-2016/

For more on the changes in Reporting services go to https://msdn.microsoft.com/en-GB/library/ms170438.aspx

and  read the ssrs blog https://blogs.msdn.microsoft.com/sqlrsteamblog/

Posted by simonsabin | with no comments

I recently installed SQL Server 2016 on my surface to get all our SQLBits reports sorted. What I couldn’t figure out was why it was so quick. I thought it might be because it was a local install and running on an SSD based surface but that couldn’t account for the blazing difference with previous versions.

 

Well the answer is much better.

 

The report manager interface has been re-written from the ground up to make it

1. More performant

2. More functionality

3. Support more browsers

4. Support HTML 5

5. Enable branding.

 

Whilst you can say about last, it shows that SSRS isn’t dead and but has risen from the ashses into a much better product. Whats more the paginate report is front and centre.

 

I also find that Report Builder performs better, which I assume is in part down to the re-writes elsewhere in the stack, and the click once deploy has gone. You now get the consistent download experience for all the MS reporting tooling, from Report Builder to Power BI desktop

 

To download and try SQL Server 2016 go to http://www.microsoft.com/en-gb/server-cloud/products/sql-server-2016/

For more on the changes in Reporting services go to https://msdn.microsoft.com/en-GB/library/ms170438.aspx

and  read the ssrs blog https://blogs.msdn.microsoft.com/sqlrsteamblog/

Posted by simonsabin | 1 comment(s)
Filed under: , ,