With the New Perspectives' critical-thinking, problem-solving approach, students will gain a comprehensive understanding of Microsoft Office 2010 and will learn how to take advantage of the flexibility it offers. Case-based tutorials challenge students to apply what they are learning to real-life tasks, preparing them to easily transfer skills to new situations. With New Perspectives, students understand why they're learning what they're learning and are better situated to retain skills beyond the classroom.

Want to tap the tremendous amount of valuable social data in Facebook, Twitter, LinkedIn, and Google+? This refreshed edition helps you discover who’s making connections with social media, what they’re talking about, and where they’re located. You’ll learn how to combine social web data, analysis techniques, and visualization to find what you’ve been looking for in the social haystack—as well as useful information you didn’t know existed.Each standalone chapter introduces techniques for mining data in different areas of the social Web, including blogs and email. All you need to get started is a programming background and a willingness to learn basic Python tools.Get a straightforward synopsis of the social web landscape Use adaptable scripts on GitHub to harvest data from social network APIs such as Twitter, Facebook, LinkedIn, and Google+ Learn how to employ easy-to-use Python tools to slice and dice the data you collect Explore social connections in microformats with the XHTML Friends Network Apply advanced mining techniques such as TF-IDF, cosine similarity, collocation analysis, document summarization, and clique detection Build interactive visualizations with web technologies based upon HTML5 and JavaScript toolkits "A rich, compact, useful, practical introduction to a galaxy of tools, techniques, and theories for exploring structured and unstructured data." --Alex Martelli, Senior Staff Engineer, Google

With the New Perspectives' critical-thinking, problem-solving approach, students will gain a comprehensive understanding of MICROSOFT OFFICE ACCESS 2010 and will learn how to take advantage of the flexibility it offers. Case-based tutorials challenge students to apply what they are learning to real-life tasks, preparing them to easily transfer skills to new situations. With New Perspectives, students understand why they're learning what they're learning and are better situated to retain skills beyond the classroom.

A friendly, step-by-step guide to the Microsoft Office database applicationAccess may be the least understood and most challenging application in the Microsoft Office suite. This guide is designed to help anyone who lacks experience in creating and managing a database learn to use Access 2010 quickly and easily.In the classic For Dummies tradition, the book provides an education in Access, the interface, and the architecture of a database. It explains the process of building a database, linking information, sharing data, generating reports, and much more.As the Microsoft Office database application, Access may be the least understood and most challenging part of the Office suiteAccess 2010 For Dummies walks newcomers through building and using their first databaseCovers linking information in a database, setting relationships, modeling data, and building tablesExplores how to extract data from Access and get specific answers, create forms, and export data in reportsA section for more experienced users looks at analyzing errors and creating an interfaceFully updated for the newest version, Access 2010 For Dummies gets new Access users up to speed and helps veterans get the most from the Office database application.

The smart way to build applications with Microsoft® SharePoint® Designer 2010 -- one step at a time! Experience learning made easy -- and quickly teach yourself how to create SharePoint 2010 applications and workflows with Microsoft® SharePoint® Designer 2010. With Step by Step, you set the pace -- building and practicing the skills you need, just when you need them! Design solutions to meet your business scenario -- without code Customize lists, libraries, and SharePoint site pages Use Web Parts to display, edit, and modify list item data Access data from a variety of external sources Create workflows to automate business processes Use master pages and CSS to control how sites work Your Step by Step digital content includes: All the books practice files -- ready to download and put to work. Fully searchable online edition of this book -- with unlimited access on the Web. The print version of this book includes free digital content online. To download, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com. Tips from Microsoft® SharePoint® Designer 2010 Step by Step Microsoft SharePoint Designer 2010 has seen major improvements over its previous version, Microsoft Office SharePoint Designer 2007. It is now the preferred tool for site owners and what Gartner termed as ‘citizen developers’. Using the browser and other what-you-see-is-what-you-get (WYSIWYG) tools such as, SharePoint Designer 2010, InfoPath 2010 and Visio Premium 2010, citizen developers, that is, those users operating outside the scope of IT can create new business applications for consumptions by others. These non-code solutions are successful because citizen developers know what they want to achieve, they understand their business needs and with a bit of SharePoint knowledge they can wire together the business processes or sets of tasks for their organization. Using the book, SharePoint Designer 2010 Step by Step – site owners and citizen developers can build up their SharePoint 2010 knowledge so that they can build citizen developed solutions, and then reuse those solutions as a basis for future SharePoint sites. The book is a step by step tutorial; explaining what you are doing and why, and gives you a good understanding of why. It contains images of commands in the margin so you can easily find them on the ribbon and contains many screenshots so you can confirm that you are following the steps correctly. You can also use the book as a reference as it has an extensive index and glossary. Don’t be put off by its name; this book is not aimed at just web designers - with SharePoint Designer, you can carry out similar tasks to the browser; however, you can now complete more tasks natively, without the need to jump back and forth between SharePoint Designer and the browser. For example, when you first open a site with SharePoint Designer you are presented within the SharePoint Designer workspace with a site’s summary page. This page provides you with the basic information about the site and allows you to change many site settings, manage permissions and create new subsites. You will also notice from the screenshot below, that SharePoint Designer has a redesigned user interface (UI) that uses Microsoft Office Fluent UI. Tip: Once you open a SharePoint 2010 site in SharePoint Designer, you can open individual files, that are not stored within the site. Another reason why you it is easier to complete similar tasks with SharePoint Designer than using the web browser to is the Navigation pane. This replaces the Folder List task pane in SharePoint Designer 2007 and focuses on SharePoint objects and not where the objects are stored. You can then pin each of these object types to show their contents in a mini-gallery, whilst you complete another task in the workspace. Although SharePoint Designer is a wonderful tool, it is not a tool that everyone should use, for example, if you only have contributor rights on a site you will not be able to use SharePoint Designer. In addition to SharePoint Designer’s in-built usage restrictions, IT and site collection owners can limit its usage at either the Web application or site collection level. Therefore you may see different SharePoint objects in the Navigation pane as compared to another user or depending on the site collection where the site is located. Tip: Using the Log In As icon in the SharePoint Designer status bar, you can log in as another user without closing and restarting the program. When you create the top level site in a site collection based on the team site template, then by default - users who are members of the Site Owners and Designers site groups can use SharePoint Designer. However they cannot customize site definition pages, nor can they see the hidden URL structure of a SharePoint site – the hierarchical tree view displayed when you click All File in the Navigation pane, that shows where files are physical or virtually located in a site. When you create a site collection using the Publishing Portal site template, then site owners and designers have no such limitations. This does make sense. On publishing site collections, you will probably want to delegate the control of content to individuals on a site by site basis. These individuals may need to create their own page layouts and change the branding of their sites. On team sites, you may wish to keep the same look and feel throughout the site collection and prevent all but site collection owners from customizing site definition pages. Tip: Whenever you create a new site collection, check that the SharePoint Designer settings meet your business needs. Microsoft has also addressed the issue that when you saved a site definition page with SharePoint Designer 2007, it would always store a copy of the page in the content database – known as customizing or un-ghosting the page, even when this was not necessary. Now with SharePoint Designer 2010, Microsoft has implemented a "safe by default" approach. When you edit a page you will only be able to amend the code within Web Part zones or within the Wiki page content area. If IT or the site collection owner has allowed you, you can edit the page outside those areas by placing the page in advance edit mode. This will result in customizing or un-ghosting the page – so customizing a page has not gone away, but you don’t always have to do it when editing a page with SharePoint Designer. SharePoint Designer 2010 Step by Step provides you with tips and guidance on how to use SharePoint Designer 2010. It helps you understand the consequences of performing tasks and gives you the skills and understanding for how to best build and modify your solutions to meet your business requirements.

The latest edition of the single most authoritative guide on dimensional modeling for data warehousing!Dimensional modeling has become the most widely accepted approach for data warehouse design. Here is a complete library of dimensional modeling techniques-- the most comprehensive collection ever written. Greatly expanded to cover both basic and advanced techniques for optimizing data warehouse design, this second edition to Ralph Kimball's classic guide is more than sixty percent updated.The authors begin with fundamental design recommendations and gradually progress step-by-step through increasingly complex scenarios. Clear-cut guidelines for designing dimensional models are illustrated using real-world data warehouse case studies drawn from a variety of business application areas and industries, including:* Retail sales and e-commerce* Inventory management* Procurement* Order management* Customer relationship management (CRM)* Human resources management* Accounting* Financial services* Telecommunications and utilities* Education* Transportation* Health care and insuranceBy the end of the book, you will have mastered the full range of powerful techniques for designing dimensional databases that are easy to understand and provide fast query response. You will also learn how to create an architected framework that integrates the distributed data warehouse using standardized dimensions and facts.This book is also available as part of the Kimball's Data Warehouse Toolkit Classics Box Set (ISBN: 9780470479575) with the following 3 books:The Data Warehouse Toolkit, 2nd Edition (9780471200246)The Data Warehouse Lifecycle Toolkit, 2nd Edition (9780470149775)The Data Warehouse ETL Toolkit (9780764567575)

Ace your preparation for the skills measured by MCTS Exam 70-433—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time.Maximize your performance on the exam by learning to: Create and manage database objects Query and modify data; implement subqueries and CTEs * Optimize table structures and data integrity Create stored procedures, functions, and triggers Manage transactions, error handling, and change tracking Tune query performance Implement database mail, full-text search, Service Broker, scripts Work with XML and SQLCLR Assess your skills with the practice tests on CD. You can work through hundreds of questions using multiple testing modes to meet your specific learning needs. You get detailed explanations for right and wrong answers—including a customized learning path that describes how and where to focus your studies. Your kit includes: 15% exam discount from Microsoft. Offer expires 12/31/13. Details inside. Official self-paced study guide. Practice tests with multiple, customizable testing options and a learning plan based on your results. 200 practice and review questions. 180-day trial of SQL Server 2008 Enterprise Edition. Case scenarios, exercises, and best practices. Fully searchable eBook of this guide, plus sample chapters from related books. A Note Regarding the CD or DVDThe print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via OReilly Medias Digital Distribution services. To download this content, please visit OReillys web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.

This hands-on, friendly guide shows you how to harness FileMaker's power to make your information work for you. With a few mouse clicks, the FileMaker Pro 11 database helps you create and print corporate reports, manage a mailing list, or run your entire business. FileMaker Pro 11: The Missing Manual helps you get started, build your database, and produce results, whether you're running a business, pursuing a hobby, or planning your retirement. It's a thorough, accessible guide for new, non-technical users, as well as those with more experience.Start up: Get your first database up and running in minutes Catalog your data: Organize contacts, to-do items, and product information with speedy data-entry and sorting tools Create professional documents: Publish reports, invoices, and more, with ease Add visual power and clarity: Create colorful charts to illustrate and summarize your data Harness processing power: Crunch numbers and search text with dozens of built-in formulas Learn advanced topics: Explore the high-level features of FileMaker Pro Advanced and FileMaker Server

The Definitive Guide to Microsoft SQL Server 2008 Reporting ServicesCreate and deliver data-rich reports across the enterprise using this complete server-based reporting solution. Written by a member of the original Reporting Services development team, Microsoft SQL Server 2008 Reporting Services covers the entire report-building and distribution process, including data extraction, integration with desktop and Web applications, and end-user access. The book explains how to maximize all of the powerful features, including the new Tablix data format, as well as enhanced performance, scalability, and visualization capabilities. Install, configure, and customize SQL Server 2008 Reporting ServicesCreate SELECT queries to extract dataGenerate reports from the Report Wizard and from scratchAdd charts, images, and gaugesBuild reusable report templatesUse the new Tablix data format to create reports with any structureExport reports to Word, Excel, PDF, HTML, XML, and other formatsEnable end-user access to reports via the Report Server and its Report Manager web interface

Updated for the latest database management systems -- including MySQL 6.0, Oracle 11g, and Microsoft's SQL Server 2008 -- this introductory guide will get you up and running with SQL quickly. Whether you need to write database applications, perform administrative tasks, or generate reports, Learning SQL, Second Edition, will help you easily master all the SQL fundamentals. Each chapter presents a self-contained lesson on a key SQL concept or technique, with numerous illustrations and annotated examples. Exercises at the end of each chapter let you practice the skills you learn. With this book, you will:Move quickly through SQL basics and learn several advanced features Use SQL data statements to generate, manipulate, and retrieve data Create database objects, such as tables, indexes, and constraints, using SQL schema statements Learn how data sets interact with queries, and understand the importance of subqueries Convert and manipulate data with SQL's built-in functions, and use conditional logic in data statements Knowledge of SQL is a must for interacting with data. With Learning SQL, you'll quickly learn how to put the power and flexibility of this language to work.