FREE Delivery in the UK.
In stock.
Dispatched from and sold by Amazon. Gift-wrap available.
Reporting with Microsoft ... has been added to your Basket
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

Reporting with Microsoft SQL Server 2012 (Professional Experience Distilled) Paperback – 18 Mar 2014

4.0 out of 5 stars 2 customer reviews

See all formats and editions Hide other formats and editions
Amazon Price
New from Used from
Kindle Edition
"Please retry"
"Please retry"
£20.67 £21.69
Note: This item is eligible for click and collect. Details
Pick up your parcel at a time and place that suits you.
  • Choose from over 13,000 locations across the UK
  • Prime members get unlimited deliveries at no additional cost
How to order to an Amazon Pickup Location?
  1. Find your preferred location and add it to your address book
  2. Dispatch to this address when you check out
Learn more
£21.99 FREE Delivery in the UK. In stock. Dispatched from and sold by Amazon. Gift-wrap available.
click to open popover

Special Offers and Product Promotions

Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone

To get the free app, enter your mobile phone number.

Product details

  • Paperback: 142 pages
  • Publisher: Packt Publishing (18 Mar. 2014)
  • Language: English
  • ISBN-10: 178217172X
  • ISBN-13: 978-1782171720
  • Product Dimensions: 19 x 0.8 x 23.5 cm
  • Average Customer Review: 4.0 out of 5 stars  See all reviews (2 customer reviews)
  • Amazon Bestsellers Rank: 1,829,170 in Books (See Top 100 in Books)

Product Description

About the Author

James Serra

James Serra is an independent consultant with the title Data Warehouse/Business Intelligence Architect. He is a Microsoft SQL Server MVP with over 25 years of IT experience. He started his career as a software developer, then was a DBA for 12 years, and for the last seven years, he has been working extensively with Business Intelligence using the SQL Server BI stack. At different times, he has been a permanent employee, consultant, contractor, and owner of his own business. All these experiences, along with continuous learning, have helped him to develop many successful data warehouse and BI projects. He is a noted blogger and speaker, having presented at the PASS Summit and the PASS Business Analytics conference. His blog is at JamesSerra.com. He has earned the MSCE: SQL Server 2012 Business Intelligence, MSCE: SQL Server 2012 Data Platform, MCITP: SQL Server 2008 Business Intelligence Developer, MCITP: SQL Server 2008 Database Administrator, and MCITP: SQL Server 2008 Database. He has a Bachelor of Science degree in Computer Engineering from UNLV. James resides in Houston, TX, with his wife Mary and three children: Lauren, RaeAnn, and James.

Bill Anton

Bill Anton is an independent consultant whose primary focus is on designing and developing data warehouses and Business Intelligence solutions using the Microsoft BI stack. He has over 10 years of experience in the industry, and enjoys working closely with clients to overcome their datarelated challenges. Bill is also an active member in the SQL Server community and enjoys sharing knowledge and helping others. When he's not working with the clients, he can usually be found answering questions on the MSDN forums, attending SQL PASS meetings, or writing blog posts at http://byoBI.com.

Customer Reviews

4.0 out of 5 stars
5 star
4 star
3 star
2 star
1 star
See both customer reviews
Share your thoughts with other customers

Top Customer Reviews

Format: Paperback
For me this is such a rare find, a book about SQL Reporting that not just gives tells you what is in the box but gives a complete overview of what is possible and how to make the most of it on a day to day basis.

It starts with a great introduction to SSRS Reports and the different options you have available, there are also useful scenarios to help you understand its capabilities together with SharePoint integration.

My favourite chapter has to be "Chapter 4: Power Views", these self-service reports are awesome and they look great!

I can see these having a massive impact and will certainly be one of our best received implementations.
Comment One person found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
As a user already experienced with reporting services I was interested to see how this would explain and demonstrate the ewer BI features available to users. It gives you readable explanations of the BI tools and discusses where the different options may be applicable I the real world. I was able to create and demonstrate PowerView and PowerPivot reports via a SharePoint PowerPivot site after reading the relevant chapters. I also extended an existing Integrated Reporting Services site using the new features available in the standard reporting services scenario.
The book has some very good examples and these can easily be followed to help create your own reports. The discussion on what to use in different scenarios is very helpful when trying to apply these examples to real world reporting problems.
If you have never used reporting services before some of the detail about data connections may throw you and if you don’t have a competent SharePoint administrator to hand there may not be enough detail to help you set up your SharePoint integrations correctly.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Helpful Customer Reviews on Amazon.com (beta)

Amazon.com: 4.1 out of 5 stars 7 reviews
2 of 2 people found the following review helpful
2.0 out of 5 stars Barney is the ghostwriter for this book, I mean pamphlet (Ya, the purple dinosaur thing) 23 Nov. 2014
By Another Mike - Published on Amazon.com
Format: Paperback Verified Purchase
The people above have to be ringers, friends of the author. I don't know, maybe there is some kind of union for supporting the material of other authors but this book ... lol, pamphlet ... is weak. There should be an expletive preceding "weak" but the book could seriously end up in the children's section.

I am on page 30 and they are covering the report parameters window. For space filler they actually cover what each field in the window is and I quote "The area numbered 1 is Name." Are you f***ing kidding me!!!! The label next to the textfield tells me that. I know, you're saying "You're only on page 30, Mike, give the book a chance." Well, it isn't a book, it's a pamphlet. And the pamphlet is only 117 pages. I did look ahead though. Halfway through the pamphlet you get to create a datasource. If you have wrestled with creating a datasource in a Microsoft application you should consider another line of work. I don't mean knowing or getting the right values/parameters/properties set, I mean if you know the settings and still can't do it. That's what this craptastic pamphlet covers.

I think most everyone who has the SLIGHTEST bit of experience would find this book nearly useless. I wouldn't be surprised if I searched on some of the text and it showed up on Microsoft's website. To this point there is no useful information, scanning ahead looks pretty bleak too. I have given it 2-stars because I'm not done with it yet and there are some trivial exercises. A 2-star rating is about as optimistic as I can be. I'll be back to finish my review. It should only be a couple of more hours if I don't get bored.
1 of 1 people found the following review helpful
5.0 out of 5 stars Very informative 16 May 2014
By Tamta Meladze - Published on Amazon.com
Format: Paperback
This book is very easy to read and understand. I liked that it's straight to the point, not too much detail but just exactly what you need to know, and it also gives references to Microsoft technet site for more in depth detailed information on each topic. Very good comparisons between SSRS and PowerView with great examples and step by step tutorials. I will definitely recommend this book especially for beginners in reporting like me.
1 of 1 people found the following review helpful
5.0 out of 5 stars Up and running fast with the correct amount of detail! 28 April 2014
By Robert F. Sonders - Published on Amazon.com
Format: Kindle Edition
I have recently completed reading this book. I was looking for a good dive into the new SQL 2012 SSRS reporting functionality. As a seasoned IT professional, I continually want to jump in to new technology. This book will have you ramped up with the new functionality in no time. With SQL 2012, there are many choices. The book jumps right in with many different scenarios that report writers and business savvy power users will face. Optional solutions are then provided that are very much applicable to real world considerations. The various opportunities and pitfalls of the MSSQL reporting stack are explained. Which to choose and when. All the BI Semantic Model data sources are touched upon. Server side, SharePoint, and connectivity considerations are also explained in detail. The book provides considerable development examples around Power View. The relationship between PowerPivot and Power View is explained in great detail. As a report writer, you will be off and running with Data visualizations with Power View in no time, either within SharePoint or Excel. This will greatly reduce development time. Good read!
2.0 out of 5 stars You get what you pay for 11 Jan. 2015
By Dimitri Shvorob - Published on Amazon.com
Format: Kindle Edition
Once again - last time it was with another Packt book, "MDX for SSAS 2012" by Li and Piasevoli - I marvel at the low quality of most reviews. Another Mike's is the sole exception, and I share his disappointment with the book's level and quality - this is a thin quickie for beginners, which, if I recall correctly, offers just two walk-throughs and neglects to tell the reader how to set up the environment he/she needs to follow along - but at $12, it's an "ah, why not", rather than a "definitely not". I would recommend SSRS beginners to start with Brian Larson's "Delivering business intelligence".
2 of 4 people found the following review helpful
5.0 out of 5 stars Excellent book: Covers everything you are likely to need 2 Jun. 2014
By Glyn Radcliffe-Brine - Published on Amazon.com
Format: Paperback
I am a SQL Server Consultant, Mentor and Trainer. I have been writing and running Reporting Services (SSRCS) training courses since 2004 when SSRS was launched as an add-in to SQL Server 2000. I immediately saw the huge benefits of SSRS over Crystal Reports and from 2005 onwards I have focused on SQL Server and SharePoint with my reporting tool of choice being SSRS.

Since 2004 many SSRS books have been written, most of them either too simplistic to be of any use to anyone other a raw beginner or too abstruse for anyone who isn't already an expert to understand. Microsoft's Technet often falls into the latter category.
Because of my experience (and because I have written much training material myself) my approach to any new SQL Server related book tends to be a bit jaundiced. Here is what I found when I read Reporting with Microsoft SQL Server 2012:

I like the style. It's easy to read and it assumes that the reader is intelligent but not yet expert in the subject matter. The language is plain English (I'll have to forgive the fact that it's American English rather than British English) with clear explanations of both theory and practice.

Accuracy is good. I haven't yet spotted any howlers, and although I disagree with the author on one or two points, it's mainly a matter of opinion rather than fact.

Some specific points:
The Reporting Scenarios starting on page 10 are excellent! Unfortunately they do rather emphasise the mess that Microsoft has made of SSRS's placement in the market. Users are confused by the decisions they need to make as to which elements product (some of which are only available to Enterprise SQL Server and/or Enterprise SharePoint). Confusion is a really good way to drive customers away to competing (generally inferior) products.

Somewhere around page 20 I would have commented that the Query Designer is quite aggressive (it eats your code if you errors rather than helping you to rectify the errors) and I would have explicitly stated that most people who code SSRS queries use Management Studio if they have the appropriate permissions.

The warning on page 36 regarding the issues around scheduling and credentials cries out for a worked example. This is a topic that many of my students struggle with until they see a practical example.

The paragraphs on Report Snapshots are particularly clear, and I like the note hinting that you might like to leave this to the IT department.

Although data security is only covered at a high level, the description contains enough detail without being deadly dull. I do worry slightly about the references to TechNet articles, as per my previous comment.

Regarding PowerView and Reporting Services Integrated Mode with SharePoint 2013, I haven't seen any note warning users that these can't be used with SharePoint 2013 Online.

Notwithstanding my previous comment, the PowerView section is excellent. The book is worth buying just for this. I heartily recommend this book! Here is a link to the publishers site: [...]
Were these reviews helpful? Let us know