As more business intelligence pros begin using Power Pivot, they find that they do not have the Excel skills to clean the data in Excel; Power Query solves this problem. This book shows how to use the Power Query tool to get difficult data sets into both Excel and Power Pivot, and is solely devoted to Power Query dashboarding and reporting.

    This book covers a range of genres, including action, adventure, and puzzle games complete with professional quality sound effects and visuals. It discusses game design theory and features practical examples of how this can be applied to making games that are more fun to play. Game Maker allows games to be created using a simple drag-and-drop interface, so you don't need to have any prior coding experience. It includes an optional programming language for adding advanced features to your games, when you feel ready to do so. You can obtain more information by visiting book.gamemaker.nl. The authors include the creator of the Game Maker tool and a former professional game programmer, so you'll glean understanding from their expertise. The book also includes a DVD containing Game Maker software and all of the game projects that are created in the book—plus a host of professional-quality graphics and sound effects that you can use in your own games.

    Offering a comprehensive review of a wide array of technical and analytical concepts, Excel Reports and Dashboards helps Excel users go from reporting data with simple tables full of dull numbers, to presenting key information through the use of high-impact, meaningful reports and dashboards that will wow management both visually and substantively.Details how to analyze large amounts of data and report the results in a meaningful, eye-catching visualization Describes how to use different perspectives to achieve better visibility into data, as well as how to slice data into various views on the fly Shows how to automate redundant reporting and analyses Part technical manual, part analytical guidebook, Excel Dashboards and Reports is the latest addition to the Mr. Spreadsheet's Bookshelf series and is the leading resource for learning to create dashboard reports in an easy-to-use format that's both visually attractive and effective.

    Ready to master AngularJS? What if you could master the entire framework – with solid foundations – in less time without beating your head against a wall? Imagine how quickly you could work if you knew the best practices and the best tools? Stop wasting your time searching and have everything you need to be productive in one, well-organized place, with complete examples to get your project up without needing to resort to endless hours of research.

    With its simple commands, flags, and parameters, a well-formed command-line application is the quickest way to automate a backup, a build, or a deployment and simplify your life. As Ruby pro David Copeland explains, writing a command-line application that is self-documenting, robust, adaptable and forever useful is easier than you might think. Ruby is particularly suited to this task, since it combines high-level abstractions with "close to the metal" system interaction wrapped up in a concise, readable syntax. Moreover, Ruby has the support of a rich ecosystem of open-source tools and libraries. Ten insightful chapters each explain and demonstrate a command-line best practice. You'll see how to use these tools to elevate the lowliest automation script to a maintainable, polished application. You'll learn how to use free, open source parsers to create user-friendly command-line interfaces as well as command suites. You'll see how to use defaults to keep options simple for everyday users, while giving advanced users options for more complex tasks. There's no reason a command-line application should lack documentation, whether it's part of a help command or a man page; you'll find out when and how to use both. Your journey from command-line novice to pro ends with a look at valuable approaches to testing your apps, and includes some fun techniques for outside-the-box, colorful interfaces that will delight your users. With Ruby, the command line is not dead. Long live the command line.What You Need: All you'll need is Ruby, and the ability to install a few gems along the way. Examples written for Ruby 1.9.2, but 1.8.7 should work just as well.

    Whether you are... -A student struggling with reams of lecture notes, references, and recordings of talks -A journalist who needs to compile ideas, log interviews, and communicate on the move -A busy individual who wants to keep and share photos, store business cards and notes “Evernote is your new, virtual filing cabinet.” Mastering Evernote will show you how to navigate and enhance your experience of this wonderful tool in just two hours. Start slicing through the multi-layered functions and various possibilities within Evernote. Discover the tool that will change the way you remember things forever. Whether you are an advanced user wanting to push Evernote to its limits or a beginner ready to explore the impact of this free app on your life, Mastering Evernote will evolve your proficiency by stacking up tip after trick till you reach the top. We are committed to providing an up-to-date experience. Buy the book once and get access to unlimited updates as they are released. Keep reading to see how the book has already been improved and expanded since the original release in October 2012. Let us know what you think should be added in future editions! What's included in Mastering Evernote? -Amazing and creative ways to use Evernote to its fullest -Charts, and illustrations for understanding the inner workings of Evernote -How to use both the web, Desktop, and Mobile version of the Evernote application -Evernote vs. OneNote, Google Docs and other systems of organization and why it crushes the competition -How to use Evernote along with other social media including Facebook, Twitter, and blogs -How to use Evernote as file storage facilitator - never use file trees again! -How to dominate the Evernote search feature to find everything in your digital library including office documents or personal pictures -How to set up an "Evernote scanner" to get rid of all the paper in your life -How to set up the perfect Evernote user interface -Tagging best practices -The "Temporary Notebook System" that organizes any project -BONUS: The Evernote Cheat Sheet! A quick look guide for advanced searches Each section of the book takes you deeper into the functionality and inner workings of Evernote, making this book an excellent reference guide. If you’re an advanced Evernote user skip the beginner sections and jump straight to the advanced. If you’re new to Evernote just read the book front to back as each new strategy, technique, and Evernote tip builds on the one before it.

    Max explains to you why programmers suck, and how to suck less as a programmer. There's just too much complex stuff in the world. Complex stuff can't be used, and it breaks too easily. Complexity is stupid. Simplicity is smart.Understanding Software covers many areas of programming, from how to write simple code to profound insights into programming, and then how to suck less at what you do! You'll discover the problems with software complexity, the root of its causes, and how to use simplicity to create great software. You'll examine debugging like you've never done before, and how to get a handle on being happy while working in teams.Max brings a selection of carefully crafted essays, thoughts, and advice about working and succeeding in the software industry, from his legendary blog Code Simplicity. Max has crafted forty-three essays which have the power to help you avoid complexity and embrace simplicity, so you can be a happier and more successful developer.Max's technical knowledge, insight, and kindness, has earned him code guru status, and his ideas will inspire you and help refresh your approach to the challenges of being a developer. What you will learn See how to bring simplicity and success to your programming world Clues to complexity - and how to build excellent software Simplicity and software design Principles for programmers The secrets of rockstar programmers Max's views and interpretation of the Software industry Why Programmers suck and how to suck less as a programmer Software design in two sentences What is a bug? Go deep into debugging About the Author Max Kanat-Alexander is the Technical Lead for Code Health at Google, where he does various work that helps other software engineers be more productive, including writing developer tools, creating educational programs, guiding refactoring efforts, and more.His roles at Google have included Tech Lead for YouTube on the Xbox, work on the Java JDK, JVM, and other aspects of Java for Google, and Technical Lead for Engineering Practices for YouTube, where he's supported developers across all of YouTube in best practices and engineering productivity. Max is a former Chief Architect of the Bugzilla Project, where he was one of the two main developers of the well-known Bugzilla Bug-Tracking System, used by thousands of organizations worldwide. Max also writes the legendary programming industry blog, Code Simplicity, where he challenges Complexity and embraces Simplicity for the programming industry.Max has been involved for several years at Google with enabling developers to work more effectively and helping shape engineering practice, and in this highly readable collection of essays you can share the best of his experience. Table of Contents Part One: Principles for Programmers Part Two: Software Complexity and its Causes Part Three: Simplicity and Software Design Part Four: Debugging Part Five:

    Focusing on the business implications of Internet of Things (IoT), this book describes the sheer impact, spread, and opportunities arising every day, and how business leaders can implement IoT today to realize tangible business advantages. The discussion delves into IoT from a business, strategy and organizational standpoint, and includes use-cases that illustrate the ripple effect that this latest disruption brings; you'll learn how to fashion a viable IoT plan that works with your organization's strategy and direction, and how to implement that strategy successfully by integrating IoT into your organization tomorrow. For business managers, the biggest question surrounding the Internet of Things is what to do with it. This book examines the way IoT is being used today—and will be used in the future—to help you craft a robust plan for your organization. Grasp the depth and breadth of the Internet of Things Create a secure IoT recipe that aligns with your company's strategy Capitalize on advances while avoiding disruption from others Leverage the technical, organizational, and social impact of IoT In the past five years, the Internet of Things has become the new frontier of technology that has everyone talking. It seems that almost every week a major vendor announces a new IoT strategy or division; is your company missing the boat? Learn where IoT fits into your organization, and how to turn disruption into profit with the expert guidance in Building the Internet of Things.

    Nowhere is that magic more apparent than in its LAB color processing capabilities, which can make even the subtle canyon colors of rock, sand, and dirt come to vivid life. However, you may be wary of taming the complex beast. Here s your guide! In these pages, Dan shows that you can derive enormous benefits from just a few simple tools and techniques. He also demonstrates that you can take these techniques as far as you wish, employing the power-user features he describes in later chapters. Starting with canyons and progressing to faces, you will see just how quickly you can begin improving your images by following the recipes included here. Each chapter includes a sidebar with review questions and exercises as well as a Closer Look section that examines some of the principles behind the techniques. A CD includes exercise files."

    Here, New York Times bestselling author Neil Smith, with more than 20 years of experience leading large-scale performance improvements, reveals the hidden barriers that cause excellent companies to do dumb things and cause smart people within companies to act in dumb ways. Drawing on his years of experience working with CEOs and helping transform top global businesses, and insights to CEOs around the world, Smith has identified eight barriers that prevent organizations from both achieving and maintaining sustainable success. Rich with anecdotes and case studies, Smith outlines a fast and proven process in which 12 principles of business transformation can break down the barriers holding companies back.

    Written for both experienced and new programmers alike, Learning Ruby is a just-get-in-and-drive book -- a hands-on tutorial that offers lots of Ruby programs and lets you know how and why they work, just enough to get you rolling down the road. Interest in Ruby stems from the popularity of Rails, the web development framework that's attracting new devotees and refugees from Java and PHP. But there are plenty of other uses for this versatile language. The best way to learn is to just try the code! You'll find examples on nearly every page of this book that you can imitate and hack. Briefly, this book:Outlines many of the most important features of Ruby Demonstrates how to use conditionals, and how to manipulate strings in Ruby. Includes a section on regular expressions Describes how to use operators, basic math, functions from the Math module, rational numbers, etc. Talks you through Ruby arrays, and demonstrates hashes in detail Explains how to process files with Ruby Discusses Ruby classes and modules (mixins) in detail, including a brief introduction to object-oriented programming (OOP) Introduces processing XML, the Tk toolkit, RubyGems, reflection, RDoc, embedded Ruby, metaprogramming, exception handling, and other topics Acquaints you with some of the essentials of Rails, and includes a short Rails tutorial. Each chapter concludes with a set of review questions, and appendices provide you with a glossary of terms related to Ruby programming, plus reference material from the book in one convenient location. If you want to take Ruby out for a drive, Learning Ruby holds the keys.

    That's the theme running through Handcrafted CSS: More Bulletproof Web Design, by bestselling author Dan Cederholm, with a chapter contributed by renowned Web designer and developer Ethan Marcotte. This book explores CSS3 that works in today's browsers, and you'll be convinced that now's the time to start experimenting with it.Whether you're a Web designer, project manager, or a graphic designer wanting to learn more about the fluidity that's required when designing for the Web, you'll discover the tools to create the most flexible, reliable, and bulletproof Web designs. And you'll finally be able to persuade your clients to adopt innovative and effective techniques that make everyone's life easier while improving the end user's experience. This book's seven chapters deconstruct various aspects of a case-study Web site for the Tugboat Coffee Company, focusing on aspects that make it bulletproof and demonstrate progressive enrichment techniques over more traditional labor-intensive methods.Subjects covered in this book include: building for unanticipated future use progressively enriching designs using CSS3 properties using RGBA color for transparency with an alpha channel modular float management crafting flexible frameworks fluid layouts using grid-based design principles craftsmanship details on typography, jQuery, and shifting backgrounds

    Known as "Mr. Spreadsheet," Walkenbach shows you how to maximize the power of all the new features of Excel 2010.An authoritative reference, this perennial bestseller proves itself indispensable no matter your level of skill, from Excel beginners and intermediate users to power users and potential power users everywhere. Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques you won't find anywhere else.Excel guru and bestselling author John Walkenbach ("Mr. Spreadsheet") guides you through every aspect of ExcelDelivers essential coverage of all the newest features of Excel 2010Presents material in a clear, concise, logical format that is ideal for all levels of Excel experienceIncludes a CD that contains all the templates and worksheets used in the book plus John Walkenbach's award-winning Power Utility Pak"Excel 2010 Bible" serves as an excellent resource on all things ExcelNote: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

    In fact, EJB 3.0 is being hailed as the new standard of server-side business logic programming. And O'Reilly's award-winning book on EJB has been refreshed just in time to capitalize on the technology's latest rise in popularity.This fifth edition, written by Bill Burke and Richard Monson-Haefel, has been updated to capture the very latest need-to-know Java technologies in the same award-winning fashion that drove the success of the previous four strong-selling editions. Bill Burke, Chief Architect at JBoss, Inc., represents the company on the EJB 3.0 and Java EE 5 specification committees. Richard Monson-Haefel is one of the world's leading experts on Enterprise Java."Enterprise JavaBeans 3.0," 5th Edition is organized into two parts: the technical manuscript followed by the JBoss workbook. The technical manuscript explains what EJB is, how it works, and when to use it. The JBoss workbook provides step-by-step instructions for installing, configuring, and running the examples from the manuscript on the JBoss 4.0 Application Server.Although EJB makes application development much simpler, it's still a complex and ambitious technology that requires a great deal of time to study and master. But now, thanks to "Enterprise JavaBeans 3.0," 5th Edition, you can overcome the complexities of EJBs and learn from hundreds of practical examples that are largeenough to test key concepts but small enough to be taken apart and explained in the detail that you need. Now you can harness the complexity of EJB with just a single resource by your side.

    That means you can't tap into the full power of Rails unless you master the Ruby language. ""Ruby for Rails,"" written by Ruby expert David Black (with a forward by David Heinemeier Hansson), helps Rails developers achieve Ruby mastery. Each chapter deepens your Ruby knowledge and shows you how it connects to Rails. You'll gain confidence working with objects and classes and learn how to leverage Ruby's elegant, expressive syntax for Rails application power. And you'll become a better Rails developer through a deep understanding of the design of Rails itself and how to take advantage of it.Newcomers to Ruby will find a Rails-oriented Ruby introduction that's easy to read and that includes dynamic programming techniques, an exploration of Ruby objects, classes, and data structures, and many neat examples of Ruby and Rails code in action. ""Ruby for Rails"": the Ruby guide for Rails developers!What's Inside Classes, modules, and objects Collection handling and filtering String and regular expression manipulation Exploration of the Rails source code Ruby dynamics Many more programming concepts and techniques!