FREE Delivery in the UK.
In stock.
Dispatched from and sold by Amazon. Gift-wrap available.
The Biml Book: Business I... has been added to your Basket
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

The Biml Book: Business Intelligence and Data Warehouse Automation Paperback – 31 Oct 2017

See all 2 formats and editions Hide other formats and editions
Amazon Price
New from Used from
Kindle Edition
£26.99 £55.04
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
click to open popover

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: 524 pages
  • Publisher: Apress; 1st ed. edition (31 Oct. 2017)
  • Language: English
  • ISBN-10: 1484231341
  • ISBN-13: 978-1484231340
  • Product Dimensions: 15.5 x 3 x 23.5 cm
  • Average Customer Review: Be the first to review this item
  • Amazon Bestsellers Rank: 60,540 in Books (See Top 100 in Books)
  • Would you like to tell us about a lower price?
    If you are a seller for this product, would you like to suggest updates through seller support?

  • See Complete Table of Contents

Product description

From the Back Cover

Learn Business Intelligence Markup Language (Biml) for automating much of the repetitive, manual labor involved in data integration. We teach you how to build frameworks and use advanced Biml features to get more out of SQL Server Integration Services (SSIS), Transact-SQL (T-SQL), and SQL Server Analysis Services (SSAS) than you ever thought possible.
The first part of the book starts with the basics--getting your development environment configured, Biml syntax, and scripting essentials.
Whether a beginner or a seasoned Biml expert, the next part of the book guides you through the process of using Biml to build a framework that captures both your design patterns and execution management. Design patterns are reusable code blocks that standardize the approach you use to perform certain types of data integration, logging, and other key data functions. Design patterns solve common problems encountered when developing data integration solutions. Because you do not have to build the code from scratch each time, design patterns improve your efficiency as a Biml developer.
In addition to leveraging design patterns in your framework, you will learn how to build a robust metadata store and how to package your framework into Biml bundles for deployment within your enterprise.
In the last part of the book, we teach you more advanced Biml features and capabilities, such as SSAS development, T-SQL recipes, documentation autogeneration, and Biml troubleshooting.
What You'll Learn:

  • Master the basics of Business Intelligence Markup Language (Biml)
  • Study patterns for automating SSIS package generation
  • Build a Biml Framework
  • Import and transform database schemas
  • Automate generation of scripts and projects

About the Author

Andy Leonard is a Data Philosopher at Enterprise Data & Analytics. He also is an SSIS trainer, consultant, and developer. Andy is a Business Intelligence Markup Language (Biml) developer and BimlHero. He also is a SQL Server database and data warehouse developer, community mentor, engineer, and farmer. Andy is a co-author of SQL Server Integration Services Design Patterns, and author of Managing Geeks - A Journey of Leading by Doing.

Customer reviews

There are no customer reviews yet.
Share your thoughts with other customers

Most helpful customer reviews on Amazon.com

Amazon.com: 4.1 out of 5 stars 6 reviews
Timothy L. Costello
5.0 out of 5 starsThis is easily one of the 3 best tech books I've ever ...
15 November 2017 - Published on Amazon.com
Verified Purchase
3 people found this helpful.
G. melhaff
3.0 out of 5 starsFramework for using biml
14 April 2018 - Published on Amazon.com
Verified Purchase
Amazon Customer
5.0 out of 5 starsThe Great Explainer - explains
12 April 2018 - Published on Amazon.com
Verified Purchase
Ian Wright
3.0 out of 5 starsPromised land for ETL?
7 April 2018 - Published on Amazon.com
Koen Verbeeck
4.0 out of 5 starsThorough reference for Biml. Everyone will definitely learn something from this book.
8 January 2018 - Published on Amazon.com

Where's My Stuff?

Delivery and Returns

Need Help?