Here at Adatis we’re big fans of Reporting Services. Yep, it has it’s quirks and frustrations (don’t talk to me about excel export!) but doesn’t deserve all the criticism it gets in our opinion. You can create some great looking reports with not a lot of extra effort over the defaults (though how many times have you seen a “slate” style report called “Report1” go into production!)
We’re also fans of what some might call the more “trendy” visualisation techniques such as sparklines and bullet charts and with Microsoft acquiring Dundas technology for use in SQL 2008, SSRS has some much improved functionality in this area. I’ll be taking a look at some of these new features in a future post.
Whilst SSRS 2005 does have it’s limitations, with a little effort you can still create some very effective information visualisations. The dashboard below is built using completely standard functionality
Adding sparklines and in-table bar charts is very simple (and pretty clever IMO). This MSDN Article covers how to do it in detail but in essence you simply add a line or bar chart into a cell in your data table.
Whilst the bullet chart (in the Sales Channel Performance region of the dashboard) may be simplistic compared to those available in SSRS 2008 or MicroCharts from XLCubed (from whom I nicked the styling for our dashboard) it still provides a very clear visualisation of the data. This required a little more trickery in the underlying query but is also just a chart in a table cell – this time a 100% stacked bar. I’ve explained how this works here
Meet the Team – Jason Bonello, Senior Consultant
Meet Jason Bonello! Jason has been with us for just over two years and works
Apr
Meet the Team – Matt How, Principal Consultant
Next up in our series of meet the team blogs is Matt How. Matt has
Apr
MLFlow: Introduction to MLFlow Tracking
MLFlow is an open-source MLOps platform designed by Databricks to enable organisations to easily manage
Apr
Adatis are pleased to announce expansion plans into India
Adatis has offices in London, Surrey and Bulgaria – and has some big expansion plans
Mar
Querying and Importing Data from Excel to SSMS
Introduction There are couple of ways to import data from Excel to SSMS – via
Mar
Data Engineering for Graduates and New Starters
This blog aims to give potential graduates and other new starters in the industry some
Mar
Passing DP-900 Azure Data Fundamentals
Back in December, I took the DP-900 Azure Data Fundamentals exam which is one of
Feb
Real-time Dashboards Provide Transparency to Everyone
Real-time dashboards enable data analytics firm Adatis to be agile and transparent with its team
Feb