Knight's Microsoft Business Intelligence 24-Hour Trainer

Sold by John Wiley & Sons
Free sample

A book-and-video introduction to Microsoft's Business Intelligence tools

If you are just starting to get a handle on Microsoft Business Intelligence (BI) tools, this book and accompanying video provides you with the just the right amount of information to perform basic business analysis and reporting. You'll explore the components and related tools that comprise the Microsoft BI toolset as well as the new BI features of Office 2010. After a basic primer on BI and data modeling, the expert team of authors provides you with step-by-step lessons in the book and videos on the accompanying DVD on how to use SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services, Excel BI (including PowerPivot), and SharePoint.

  • Integrates instructional videos with each of the lessons found in the book to enhance your learning experience
  • Explores the Microsoft Business Intelligence (BI) toolset as well as the new BI features of Office 2010
  • Encourages you to practice what you've learned in "Try It Out" sections
  • Contains video demonstrations that walk you through how to tackle each lesson featured in the book

With Knight's Microsoft Business Intelligence 24-Hour Trainer, veteran authors present you with an ideal introductory book-and-video package so that you can get started working with the BI toolset immediately!/p

Note: As part of the print version of this title, video lessons are included on DVD. For e-book versions, video lessons can be accessed at using a link provided in the interior of the e-book.

Read more

About the author

Brian Knight, SQL Server MVP, is the founder of Pragmatic Works. He is author of more than a dozen books.

Devin Knight is an author, consultant, and trainer with Pragmatic Works.

Adam Jorgensen is an author, trainer, consultant, and President of Pragmatic Works Consulting.

Patrick LeBlanc, SQL Server MVP, is a BI Architect, consultant, and trainer with Pragmatic Works.

Mike Davis is an author, developer, consultant, and trainer with Pragmatic Works.

Read more



Additional Information

John Wiley & Sons
Read more
Published on
Nov 30, 2011
Read more
Read more
Read more
Read more
Computers / Databases / Data Warehousing
Computers / Information Technology
Read more
Content Protection
This content is DRM protected.
Read more
Read Aloud
Available on Android devices
Read more

Reading information

Smartphones and Tablets

Install the Google Play Books app for Android and iPad/iPhone. It syncs automatically with your account and allows you to read online or offline wherever you are.

Laptops and Computers

You can read books purchased on Google Play using your computer's web browser.

eReaders and other devices

To read on e-ink devices like the Sony eReader or Barnes & Noble Nook, you'll need to download a file and transfer it to your device. Please follow the detailed Help center instructions to transfer the files to supported eReaders.
You know the rudiments of the SQL query language, yet you feel you aren't taking full advantage of SQL's expressive power. You'd like to learn how to do more work with SQL inside the database before pushing data across the network to your applications. You'd like to take your SQL skills to the next level.

Let's face it, SQL is a deceptively simple language to learn, and many database developers never go far beyond the simple statement: SELECT columns FROM table WHERE conditions. But there is so much more you can do with the language. In the SQL Cookbook, experienced SQL developer Anthony Molinaro shares his favorite SQL techniques and features. You'll learn about:

Window functions, arguably the most significant enhancement to SQL in the past decade. If you're not using these, you're missing out

Powerful, database-specific features such as SQL Server's PIVOT and UNPIVOT operators, Oracle's MODEL clause, and PostgreSQL's very useful GENERATE_SERIES function

Pivoting rows into columns, reverse-pivoting columns into rows, using pivoting to facilitate inter-row calculations, and double-pivoting a result set

Bucketization, and why you should never use that term in Brooklyn.

How to create histograms, summarize data into buckets, perform aggregations over a moving range of values, generate running-totals and subtotals, and other advanced, data warehousing techniques

The technique of walking a string, which allows you to use SQL to parse through the characters, words, or delimited elements of a string

Written in O'Reilly's popular Problem/Solution/Discussion style, the SQL Cookbook is sure to please. Anthony's credo is: "When it comes down to it, we all go to work, we all have bills to pay, and we all want to go home at a reasonable time and enjoy what's still available of our days." The SQL Cookbook moves quickly from problem to solution, saving you time each step of the way.

California and the Western States are rich in abundant and diverse species of mushrooms. Amateur mushroom collectors and mycologists alike will find over 300 species of the region’s most common, distinctive, and ecologically important mushrooms profiled in this comprehensive field guide. It provides the most up-to-date science on the role of fungi in the natural world, methods to identify species, and locations of mushroom habitats. With excellent color illustrations showing top and side views of mushrooms of the Western States and a user-friendly text, it is informative but still light enough to be carried into the woods. When used to identify mushrooms, keys bring the reader to individual species, with a descriptive text providing cues for identifying additional species. Mushrooms common in urban landscapes are included, which is especially useful for the casual encounter with backyard fungi. The guide also provides a table of both old and new species names, and information on edibility and look-alikes, both dangerous and benign.

A section on mushroom arts and crafts features mushroom photography, painting, philately, spore prints, dyes, and cultivation. The guide also offers a comprehensive list of resources including national field guides, general mushroom books and periodicals, club and society contact information, and web sites.

· Primary descriptions and illustrations of 300 species of mushrooms plus text descriptions of many more.

· Latest word in mushroom taxonomy and nomenclature. Clear discussion of DNA sequencing and new classifications.

· Especially good coverage of southern California and Southwestern mushrooms often neglected in other field guides.

Los Angeles has become a magnet for the American apocalyptic imagination. Riot, fire, flood, earthquake...only locusts are missing from the almost biblical list of disasters that have struck the city in the 1990s.
From Ventura to Laguna, more than one million Southern Californians have been directly touched by disaster-related death, injury, or damage to their homes and businesses. Middle-class apprehensions about angry underclasses are exceeded only by anxieties about blind thrust faults underlying downtown L.A. or about the firestorms that periodically incinerate Malibu. And the force of real catastrophe has been redoubled by the obsessive fictional destruction of Los Angeles--by aliens, comets, and twisters--in scores of novels and films. The former "Land of Sunshine" is now seen by much of the world, including many of L.A.'s increasingly nervous residents, as a veritable Book of the Apocalypse theme park.
In this extraordinary book, Mike Davis, the author of City of Quartz and our most fascinating interpreter of the American metropolis, unravels the secret political history of disaster, real and imaginary, in Southern California. As he surveys the earthquakes of Santa Monica, the burning of Koreatown, the invasion of "man-eating" mountain lions, the movie Volcano, and even Los Angeles's underrated tornado problem, he exposes the deep complicity between social injustice and perceptions of natural disorder. Arguing that paranoia about nature obscures the fact that Los Angeles has deliberately put itself in harm's way, Davis reveals how market-driven urbanization has for generations transgressed against environmental common sense. And he shows that the floods, fires, and earthquakes reaped by the city were tragedies as avoidable--and unnatural--as the beating of Rodney King and the ensuing explosion in the streets.
Rich with detail, bold and original, Ecology of Fear is a gripping reconnaissance into the urban future, an essential portrait of America at the millennium.
Learn to take advantage of the opportunities offered by SQL Server 2014

Microsoft's SQL Server 2014 update means big changes for database administrators, and you need to get up to speed quickly because your methods, workflow, and favorite techniques will be different from here on out. The update's enhanced support of large-scale enterprise databases and significant price advantage mean that SQL Server 2014 will become even more widely adopted across the industry. The update includes new backup and recovery tools, new AlwaysOn features, and enhanced cloud capabilities. In-memory OLTP, Buffer Pool Extensions for SSDs, and a new Cardinality Estimator can improve functionality and smooth out the workflow, but only if you understand their full capabilities. Professional Microsoft SQL Server 2014 is your comprehensive guide to working with the new environment. Authors Adam Jorgensen, Bradley Ball, Ross LoForte, Steven Wort, and Brian Knight are the dream team of the SQL Server community, and they put their expertise to work guiding you through the changes.

Improve oversight with better management and monitoring Protect your work with enhanced security features Upgrade performance tuning, scaling, replication, and clustering Learn new options for backup and recovery

Professional Microsoft SQL Server 2014 includes a companion website with sample code and efficient automation utilities, plus a host of tips, tricks, and workarounds that will make your job as a DBA or database architect much easier. Stop getting frustrated with administrative issues and start taking control. Professional Microsoft SQL Server 2014 is your roadmap to mastering the update and creating solutions that work.

©2018 GoogleSite Terms of ServicePrivacyDevelopersArtistsAbout Google
By purchasing this item, you are transacting with Google Payments and agreeing to the Google Payments Terms of Service and Privacy Notice.