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.
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!
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 wrox.com using a link provided in the interior of the e-book.
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.
If you need a practical, hands-on introduction, especially toSQL Server Integration Services (SSIS), this book-and-video packagefrom authority Brian Knight is the perfect solution. Each lessonincludes three major components: a description of how each SSISfeature or process works, a tutorial that walks you through theprocess or technique, and an accompanying video lesson. It's acomplete learning package that will give you the confidence youneed to start your first SSIS project.Guides novice database administrators and developers who arelearning Microsoft SQL Server 2012 and SQL Server IntegrationServices (SSIS)Provides expert instruction from leading SQL Server authorityand author, Brian KnightIncludes a book and a video, complete instruction that includeslessons, hands-on tutorials, and video demonstrations by theauthorCovers the very latest changes and updates in the SQL Server2012 release
Microsoft SQL Server 2012 Integration Services 24-HourTrainer makes SQL Server 2012 and SSIS much lessintimidating.
Note: CD-ROM/DVD and other supplementary materials arenot included as part of the e-book file, but are available fordownload after purchase.
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:
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.
The first edition of Ralph Kimball's The Data WarehouseToolkit introduced the industry to dimensional modeling,and now his books are considered the most authoritative guides inthis space. This new third edition is a complete library of updateddimensional modeling techniques, the most comprehensive collectionever. It covers new and enhanced star schema dimensional modelingpatterns, adds two new chapters on ETL techniques, includes new andexpanded business matrices for 12 case studies, and more.Authored by Ralph Kimball and Margy Ross, known worldwide aseducators, consultants, and influential thought leaders in datawarehousing and business intelligenceBegins with fundamental design recommendations and progressesthrough increasingly complex scenariosPresents unique modeling techniques for business applicationssuch as inventory management, procurement, invoicing, accounting,customer relationship management, big data analytics, and moreDraws real-world case studies from a variety of industries,including retail sales, financial services, telecommunications,education, health care, insurance, e-commerce, and more
Design dimensional databases that are easy to understand andprovide fast query response with The Data WarehouseToolkit: The Definitive Guide to Dimensional Modeling, 3rdEdition.
The 2014 release of Microsoft's SQL Server Integration Servicesprovides enhancements for managing extraction, transformation, andload operations, plus expanded in-memory capabilities, improveddisaster recovery, increased scalability, and much more. Theincreased functionality will streamline your ETL processes andsmooth out your workflow, but the catch is that your workflow mustchange. New tools come with new best practices, and ProfessionalMicrosoft SQL Server 2014 Integration Services will keep youahead of the curve. SQL Server MVP Brian Knight is the mostrespected name in the business, and your ultimate guide tonavigating the changes to use Microsoft SQL Server IntegrationServices 2014 to your utmost advantage.Implement new best practices for effective use of SSISWork through tutorials for hands-on learning of complextechniquesRead case studies that illustrate the more advancedconceptsLearn directly from the foremost authority on SSIS
SQL Server Integration Services is a complex tool, but it's thelifeblood of your work. You need to know it inside out, and youmust understand the full potential of its capabilities in order touse it effectively. You need to make sure the right architecture isin place. Professional Microsoft SQL Server 2014 IntegrationServices is your roadmap to understanding SSIS on a fundamentallevel, and setting yourself up for success.
Google BigQuery Analytics is the perfect guide for business and data analysts who want the latest tips on running complex queries and writing code to communicate with the BigQuery API. The book uses real-world examples to demonstrate current best practices and techniques, and also explains and demonstrates streaming ingestion, transformation via Hadoop in Google Compute engine, AppEngine datastore integration, and using GViz with Tableau to generate charts of query results. In addition to the mechanics of BigQuery, the book also covers the architecture of the underlying Dremel query engine, providing a thorough understanding that leads to better query results.Features a companion website that includes all code and data sets from the bookUses real-world examples to explain everything analysts need to know to effectively use BigQueryIncludes web application examples coded in Python