List books in category Computers & Technology / Desktop Applications

  • Scrivener Absolute Beginner s Guide

    Scrivener Absolute Beginner’s Guide
    Jennifer Ackerman Kettell

    Far more than a word processor, Scrivener helps you organize and brainstorm even the most complex writing project, bring together your research, and write more efficiently and successfully than ever before. Long available for Mac, there’s now a Windows version, too. Thousands of writers and aspiring writers are discovering this powerful, low-cost tool. Now, there’s an up-to-the-minute, easy guide to the latest versions of Scrivener for both Mac and Windows: Scrivener Absolute Beginner’s Guide . Written by working novelist and experienced computer book author Jennifer Kettell, this guide doesn’t just present features and menus: it presents Scrivener in the context of your creative workflow, so you can make the most of this amazing software. Kettell draws on years of Scrivener experience and private tutoring to help you use Scrivener in both fiction and non-fiction projects, including screenwriting and academic writing. This book is as authoritative as it gets. Kettell not only wrote it in Scrivener: screen captures show her work in progress, and identify powerful ways to use Scrivener to improve productivity. Her book has been tech edited by the Literature & Latte software team member who serves as main liaison for the Scrivener Windows product to ensure that the Windows version is covered as thoroughly as the Mac version. You’ll learn how to: · Integrate Scrivener into your own personal workflow · Get to know Scrivener’s interface and customize it to your workstyle · Write, organize, storyboard, plot, and edit your document · Create custom templates to manage manuscripts, brainstorming, and research · Use keywords and metadata to keep track of complex projects · Track your progress and backing up your work · Generate a completed manuscript · Create an e-book from your manuscript · Discover new uses for Scrivener Throughout, Kettell clearly identifies differences between the Mac and Windows versions of Scrivener, so you’re never frustrated by searching for a feature that isn’t there. Scrivener Absolute Beginner’s Guide is simple, clear, non-technical, and written from the viewpoint of a professional writer for other writers. It’s the Scrivener guide thousands of writers have been waiting for.

  • Excel 2010 For Dummies

    Excel 2010 For Dummies
    Greg Harvey

    Dig into formulas, functions, and more to build your Excel skills Whether you're a beginner or an Excel veteran, this friendly guide provides the fundamental techniques to help you create, edit, format, and print your own spreadsheets. You'll start from scratch and quickly progress to manipulating data with formulas and using Excel's extensive formatting options to present your information in the most powerful way. Open the book and find: Ways to navigate Excel's Ribbon interface Data entry tips to start your spreadsheet How to build formulas and edit workbooks Formatting steps to follow Printing basics to present your data

  • Integrating Excel and Access: Combining Applications to Solve Business Problems

    Integrating Excel and Access: Combining Applications to Solve Business Problems
    Michael Schmalz

    In a corporate setting, the Microsoft Office Suite is an invaluable set of applications. One of Offices' biggest advantages is that its applications can work together to share information, produce reports, and so on. The problem is, there isn't much documentation on their cross-usage. Until now. Introducing Integrating Excel and Access, the unique reference that shows you how to combine the strengths of Microsoft Excel with those of Microsoft Access. In particular, the book explains how the powerful analysis tools of Excel can work in concert with the structured storage and more powerful querying of Access. The results that these two applications can produce together are virtually impossible to achieve with one program separately. But the book isn't just limited to Excel and Access. There's also a chapter on SQL Server, as well as one dedicated to integrating with other Microsoft Office applications. In no time, you'll discover how to:Utilize the built in features of Access and Excel to access dataUse VBA within Access or Excel to access dataBuild connection strings using ADO and DAOAutomate Excel reports including formatting, functions, and page setupWrite complex functions and queries with VBAWrite simple and advanced queries with the Access GUIProduce pivot tables and charts with your data With Integrating Excel and Access, you can crunch and visualize data like never before. It's the ideal guide for anyone who uses Microsoft Office to handle data.

  • macOS Mojave: The Missing Manual: The book that should have been in the box

    macOS Mojave: The Missing Manual: The book that should have been in the box
    David Pogue

    Answers found here!Apple’s latest Mac software, macOS Mojave, is a glorious boxcar full of new features and refinements. What’s still not included, though, is a single page of printed instructions. Fortunately, David Pogue is back, delivering the expertise and humor that have made this the #1 bestselling Mac book for 18 years straight.The important stuff you need to knowBig-ticket changes. The stunning new Dark Mode. Self-tidying desktop stacks. FaceTime video calls with up to 32 people. New screen-recording tools. If Apple has it, this book covers it.Apps. This book also demystifies the 50 programs that come with the Mac, including the four new ones in Mojave: News, Stocks, Home, and Voice Memos.Shortcuts. This must be the tippiest, trickiest Mac book ever written. Undocumented surprises await on every page.Power users. Security, networking, remote access, file sharing with Windows—this one witty, expert guide makes it all crystal clear.MacOS Mojave gives the Mac more polish, power, and pep— and in your hands, you hold the ultimate guide to unlocking its potential.

  • Photoshop CC Digital Classroom 2018 Edition

    Photoshop CC Digital Classroom 2018 Edition
    Jennifer Smith

    Quickly learn Adobe Photoshop CC with this book and downloadable lesson files – fully updated for Photoshop CC 2018Adobe Photoshop is the industry leading image-editing program for designers, web developers, and photographers. The newest version of Photoshop CC (Creative Cloud) includes more great tools to manage and edit images. This book delivers full-color, step-by-step instructions that make learning Photoshop easy to understand. You'll explore how to work with layers, use filters, and create images for web, print, and video. Learn Photoshop at your own pace led by Jennifer Smith, an expert instructor from American Graphics Institute. Fully updated for Photoshop CC 2018.• Discover essential skills for working quickly and efficiently with Photoshop CC (Creative Cloud)• Includes step-by-step instructions for each lesson, along with lesson files that complement the topics• Learn Photoshop retouching, layers, selections, painting, and more.• Find out how to create fantastic effects and merge multiple images together.Photoshop CC Digital Classroom takes you from the basics through intermediate-level topics. Learn the information you need about how to use Photoshop, presented in a clear, approachable way.

  • Mastering R for Quantitative Finance

    Mastering R for Quantitative Finance
    Edina Berlinger

    This book is intended for those who want to learn how to use R's capabilities to build models in quantitative finance at a more advanced level. If you wish to perfectly take up the rhythm of the chapters, you need to be at an intermediate level in quantitative finance and you also need to have a reasonable knowledge of R.

  • Construction Management JumpStart: The Best First Step Toward a Career in Construction Management, Edition 2

    Construction Management JumpStart: The Best First Step Toward a Career in Construction Management, Edition 2
    Barbara J. Jackson

    Launch your career in construction management with this one-of-a-kind book The construction management industry is expected to increase employment by 16 percent over the next decade. This second edition of a bestselling introduction to construction management walks you through each stage of the construction management process. Written from the constructor's perspective, this book will familiarize you with all the construction management fundamentals and how Building Information Modeling (BIM) is impacting the construction management profession. Covers interoperability of technology advances in the construction industry Explains how BIM is challenging the traditional approach to project delivery and how this affects the constructor's role Elaborates each stage of the design and construction process and the tasks associated with each of them Shows step-by-step how to estimate project costs, administer contracts, manage job site and construction operations, plan and schedule a project, monitor project performance, manage project quality and safety, and assess project risks Provides review questions at the end of each chapter to help enforce understanding The tried-and-true project management principles presented in this book will help ensure you a successful start to your career.

  • Beginner s Photoshop: CS6 Edition

    Beginner’s Photoshop: CS6 Edition
    Kevin Wilson

    Learn the power of photoshop the easy way, no jargon. Clear, concise and to the point…Photoshop Essentials is the essential reference guide to getting around and using Photoshop providing a complete resource for both the beginner and the enthusiast. This book exploresPhotoshop interface – not as scary as it looks, the tools at your disposal for all the tasks you would do in your every day needs magic wands, layers, clone tools, quick masks, filters, special effects, lighting effects, text, fonts and effects image adjustment, burn tools, vectors, brush, crop and select a look at the new 3D features. and more… Techniques are illustrated in full colour step-by-step using photography and screen prints throughout, together with concise, easy to follow text from an established expert in the field, provides a comprehensive reference guide to Photoshop. Whether you are a new Photoshop user, learning to use Photoshop, a digital photographer, or use it in your work, this book will provide you with a reference guide, a firm grasp of the underpinning foundations and equip you with the skills needed to use Photoshop like a expert.

  • Project Management the Agile Way: Making it Work in the Enterprise

    Project Management the Agile Way: Making it Work in the Enterprise
    John C. Goodpasture

    Project Management the Agile Way was written for experienced project managers, architects and systems analysts who are comfortable in traditional methods of project management but now need to learn about agile methods for software projects and understand how to make agile work effectively in the enterprise. The methodologies included under the agile umbrella go by many names such as Scrum, XP, Crystal and EVO, to name a few. Project managers will gain practical day-to-day tips and advice on how to apply these practices to mainstream projects and how to integrate these methods with other methodologies used in the enterprise. Key Features: • Offers a review of most of the popular agile and iterative methodologies for project management • Presents practical tips and application advice for how to harmonize agile and iterative methods with mainstream project processes • Describes how earned value can work with non-traditional methods • Explains how to scale agile and iterative methods for enterprise projects • Shows the means to contract and outsource with agile and iterative methods • Provides guidance to build a business case and track post-project benefits

  • Rapid Development: Rapid Devment _p1

    Rapid Development: Rapid Devment _p1
    Steve McConnell

    Corporate and commercial software-development teams all want solutions for one important problem—how to get their high-pressure development schedules under control. In RAPID DEVELOPMENT, author Steve McConnell addresses that concern head-on with overall strategies, specific best practices, and valuable tips that help shrink and control development schedules and keep projects moving. Inside, you’ll find: A rapid-development strategy that can be applied to any project and the best practices to make that strategy work Candid discussions of great and not-so-great rapid-development practices—estimation, prototyping, forced overtime, motivation, teamwork, rapid-development languages, risk management, and many others A list of classic mistakes to avoid for rapid-development projects, including creeping requirements, shortchanged quality, and silver-bullet syndrome Case studies that vividly illustrate what can go wrong, what can go right, and how to tell which direction your project is going RAPID DEVELOPMENT is the real-world guide to more efficient applications development.

  • Mastering GUI Programming with Python: Develop impressive cross-platform GUI applications with PyQt

    Mastering GUI Programming with Python: Develop impressive cross-platform GUI applications with PyQt
    Alan D. Moore

    An advanced guide to creating powerful high-performance GUIs for modern, media-rich applications in various domains such as business and game developmentKey FeaturesGain comprehensive knowledge of Python GUI development using PyQt 5.12Explore advanced topics including multithreaded programming, 3D animation, and SQL databasesBuild cross-platform GUIs for Windows, macOS, Linux, and Raspberry PiBook DescriptionPyQt5 has long been the most powerful and comprehensive GUI framework available for Python, yet there is a lack of cohesive resources available to teach Python programmers how to use it. This book aims to remedy the problem by providing comprehensive coverage of GUI development with PyQt5. You will get started with an introduction to PyQt5, before going on to develop stunning GUIs with modern features. You will then learn how to build forms using QWidgets and learn about important aspects of GUI development such as layouts, size policies, and event-driven programming. Moving ahead, you’ll discover PyQt5’s most powerful features through chapters on audio-visual programming with QtMultimedia, database-driven software with QtSQL, and web browsing with QtWebEngine. Next, in-depth coverage of multithreading and asynchronous programming will help you run tasks asynchronously and build high-concurrency processes with ease. In later chapters, you’ll gain insights into QOpenGLWidget, along with mastering techniques for creating 2D graphics with QPainter. You’ll also explore PyQt on a Raspberry Pi and interface it with remote systems using QtNetwork. Finally, you will learn how to distribute your applications using setuptools and PyInstaller.By the end of this book, you will have the skills you need to develop robust GUI applications using PyQt.What you will learnGet to grips with the inner workings of PyQt5Learn how elements in a GUI application communicate with signals and slotsLearn techniques for styling an applicationExplore database-driven applications with the QtSQL moduleCreate 2D graphics with QPainterDelve into 3D graphics with QOpenGLWidgetBuild network and web-aware applications with QtNetwork and QtWebEngineWho this book is forThis book is for programmers who want to create attractive, functional, and powerful GUIs using the Python language. You’ll also find this book useful if you are a student, professional, or anyone who wants to start exploring GUIs or take your skills to the next level. Although prior knowledge of the Python language is assumed, experience with PyQt, Qt, or GUI programming is not required.

  • tmux 2: Productive Mouse-Free Development

    tmux 2: Productive Mouse-Free Development
    Brian P. Hogan

    Your mouse is slowing you down. The time you spend context switching between your editor and your consoles eats away at your productivity. Take control of your environment with tmux, a terminal multiplexer that you can tailor to your workflow. With this updated second edition for tmux 2.3, you'll customize, script, and leverage tmux's unique abilities to craft a productive terminal environment that lets you keep your fingers on your keyboard's home row. You have a database console, web server, test runner, and text editor running at the same time, but switching between them and trying to find what you need takes up valuable time and breaks your concentration. By using tmux 2.3, you can improve your productivity and regain your focus. This book will show you how. This second edition includes many features requested by readers, including how to integrate plugins into your workflow, how to integrate tmux with Vim for seamless navigation – oh, and how to use tmux on Windows 10. Use tmux to manage multiple terminal sessions in a single window using only your keyboard. Manage and run programs side by side in panes, and create the perfect development environment with custom scripts so that when you're ready to work, your programs are waiting for you. Manipulate text with tmux's copy and paste buffers, so you can move text around freely between applications. Discover how easy it is to use tmux to collaborate remotely with others, and explore more advanced usage as you manage multiple tmux sessions, add custom scripts into the tmux status line, and integrate tmux with your system. Whether you're an application developer or a system administrator, you'll find many useful tricks and techniques to help you take control of your terminal.

  • Analyzing Data with Power BI and Power Pivot for Excel

    Analyzing Data with Power BI and Power Pivot for Excel
    Alberto Ferrari

    Renowned DAX experts Alberto Ferrari and Marco Russo teach you how to design data models for maximum efficiency and effectiveness. How can you use Excel and Power BI to gain real insights into your information? As you examine your data, how do you write a formula that provides the numbers you need? The answers to both of these questions lie with the data model. This book introduces the basic techniques for shaping data models in Excel and Power BI. It’s meant for readers who are new to data modeling as well as for experienced data modelers looking for tips from the experts. If you want to use Power BI or Excel to analyze data, the many real-world examples in this book will help you look at your reports in a different way–like experienced data modelers do. As you’ll soon see, with the right data model, the correct answer is always a simple one! By reading this book, you will: • Gain an understanding of the basics of data modeling, including tables, relationships, and keys • Familiarize yourself with star schemas, snowflakes, and common modeling techniques • Learn the importance of granularity • Discover how to use multiple fact tables, like sales and purchases, in a complex data model • Manage calendar-related calculations by using date tables • Track historical attributes, like previous addresses of customers or manager assignments • Use snapshots to compute quantity on hand • Work with multiple currencies in the most efficient way • Analyze events that have durations, including overlapping durations • Learn what data model you need to answer your specific business questions About This Book • For Excel and Power BI users who want to exploit the full power of their favorite tools • For BI professionals seeking new ideas for modeling data

  • Logo Design Love: A guide to creating iconic brand identities, Edition 2

    Logo Design Love: A guide to creating iconic brand identities, Edition 2
    David Airey

    Completely updated and expanded, the second edition of David Airey’s Logo Design Love contains more of just about everything that made the first edition so great: more case studies, more sketches, more logos, more tips for working with clients, more insider stories, and more practical information for getting the job and getting it done right. In Logo Design Love, David shows you how to develop an iconic brand identity from start to finish, using client case studies from renowned designers. In the process, he reveals how designers create effective briefs, generate ideas, charge for their work, and collaborate with clients. David not only shares his personal experiences working on identity projects–including sketches and final results of his own successful designs–he also uses the work of many well-known designers such as Paula Scher, who designed the logos for Citi and Microsoft Windows, and Lindon Leader, creator of the current FedEx identity, as well as work from leading design studios, including Moving Brands, Pentagram, MetaDesign, Sagmeister & Walsh, and many more. In Logo Design Love, you’ll learn: Best practices for extending a logo into a complete brand identity system Why one logo is more effective than another How to create your own iconic designs What sets some designers above the rest 31 practical design tips for creating logos that last

  • Excel 2019 Bible

    Excel 2019 Bible
    Michael Alexander

    The complete guide to Excel 2019 Whether you are just starting out or an Excel novice, the Excel 2019 Bible is your comprehensive, go-to guide for all your Excel 2019 needs. Whether you use Excel at work or at home, you will be guided through the powerful new features and capabilities to take full advantage of what the updated version offers. Learn to incorporate templates, implement formulas, create pivot tables, analyze data, and much more. Navigate this powerful tool for business, home management, technical work, and much more with the only resource you need, Excel 2019 Bible. Create functional spreadsheets that work Master formulas, formatting, pivot tables, and more Get acquainted with Excel 2019's new features and tools Whether you need a walkthrough tutorial or an easy-to-navigate desk reference, the Excel 2019 Bible has you covered with complete coverage and clear expert guidance.

  • Microsoft Excel Data Analysis and Business Modeling: Edition 5

    Microsoft Excel Data Analysis and Business Modeling: Edition 5
    Wayne Winston

    This is the eBook of the printed book and may not include any media, website access codes, or print supplements that may come packaged with the bound book. Master business modeling and analysis techniques with Microsoft Excel 2016, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands on, scenario-focused guide helps you use Excel’s newest tools to ask the right questions and get accurate, actionable answers. This edition adds 150+ new problems with solutions, plus a chapter of basic spreadsheet models to make sure you’re fully up to speed. Solve real business problems with Excel–and build your competitive advantage Quickly transition from Excel basics to sophisticated analytics Summarize data by using PivotTables and Descriptive Statistics Use Excel trend curves, multiple regression, and exponential smoothing Master advanced functions such as OFFSET and INDIRECT Delve into key financial, statistical, and time functions Leverage the new charts in Excel 2016 (including box and whisker and waterfall charts) Make charts more effective by using Power View Tame complex optimizations by using Excel Solver Run Monte Carlo simulations on stock prices and bidding models Work with the AGGREGATE function and table slicers Create PivotTables from data in different worksheets or workbooks Learn about basic probability and Bayes’ Theorem Automate repetitive tasks by using macros

  • Programming ArcGIS with Python Cookbook: Edition 2

    Programming ArcGIS with Python Cookbook: Edition 2
    Eric Pimpler

    The book kicks off with the fundamentals of starting to use Python with ArcGIS, followed by recipes on managing map documents and layers, including how to find and fix broken data links in these files.In the second part of the book, you will learn to create custom geoprocessing tools and how to use the Attribute and Location tools to select specific features.The third part of the book covers topics for advanced users including the REST API, and also teaches you how to use Python with ArcGIS Pro. The book finishes with appendices covering how to automate Python scripts, and the five things that should be at the back of every GIS programmer's mind.

  • Adobe InDesign CC Classroom in a Book (2019 Release)

    Adobe InDesign CC Classroom in a Book (2019 Release)
    Kelly Kordes Anton

    Creative professionals seeking the fastest, easiest, most comprehensive way to learn Adobe InDesign choose Adobe InDesign CC Classroom in a Book (2019 release) from Adobe Press. The 15 project-based step-by-step lessons show users the key techniques for working in InDesign. Designers will build a strong foundation of typographic, color, page layout, and document-construction skills that will enable them to produce a broad range of print and digital publications—from a simple postcard to an interactive Adobe PDF with form fields. The real-world tasks in this comprehensive book are presented in an easy-to-follow, step-by-step format and are designed to train beginning Adobe InDesign users in the program—from fundamental features to powerful layout and output skills. This book also enables experienced InDesign users to elevate their skills, understand best practices, and learn about new features. Enhancements in this version target usability and productivity, including the ability to browse fonts visually, using Content Aware Fit for intelligent image placement, use Layout Adjust to automatically adjust layout when changing page sizes, and quickly access common controls in the Properties panel. The online companion files include all the necessary assets for readers to complete the projects featured in each lesson. All buyers of the book get full access to the Web Edition: A Web-based version of the complete ebook enhanced with video and multiple-choice quizzes.

  • Excel 2016 All-in-One For Dummies

    Excel 2016 All-in-One For Dummies
    Greg Harvey

    Your one-stop guide to all things Excel 2016 Excel 2016 All-in-One For Dummies, the most comprehensive Excel reference on the market, is completely updated to reflect Microsoft's changes in the popular spreadsheet tool. It offers you everything you need to grasp basic Excel functions, such as creating and editing worksheets, setting up formulas, importing data, performing statistical functions, editing macros with Visual Basic—and beyond. In no time, your Excel skills will go from 'meh' to excellent. Written by expert Greg Harvey, who has sold more than 4.5 million copies of his previous books combined and has taught and trained extensively in Microsoft Excel, this all-encompassing guide offers everything you need to get started with Excel. From generating pivot tables and performing financial functions to performing error trapping and building and running macros—and everything in between—this hands-on, friendly guide makes working with Excel easier than ever before. Serves as the ideal reference for solving common questions and Excel pain points quickly and easily Helps to increase productivity and efficiency when working in Excel Fully updated for the new version of Excel Covers basic and more advanced Excel topics If working in Excel occasionally makes you want to scream, this will be the dog-eared, dust-free reference you'll turn to again and again.

  • Getting Started with 3D Printing: A Hands-on Guide to the Hardware, Software, and Services Behind the New Manufacturing Revolution

    Getting Started with 3D Printing: A Hands-on Guide to the Hardware, Software, and Services Behind the New Manufacturing Revolution
    Liza Wallach Kloski

    Make: Getting Started with 3D Printing is a practical, informative, and inspiring book that guides readers step-by-step through understanding how this new technology will empower them to take full advantage of all it has to offer. The book includes fundamental topics such as a short history of 3D printing, the best hardware and software choices for consumers, hands-on tutorial exercises the reader can practice for free at home, and how to apply 3D printing in the readers' life and profession. For every maker or would-be maker who is interested, or is confused, or who wants to get started in 3D printing today, this book offers methodical information that can be read, digested, and put into practice immediately!

  • Learn SQL in 6 days

    Learn SQL in 6 days
    John Anthony

    This book covers the basics of database concepts and data maintenance statements like adding, modifying and deleting data, and table relationships.Apart from the above mentioned concepts this book mainly focuses on data retrievals. This books talks about all the types of data retrieval concepts in detail as the object of this book is to make the individual who is reading this book to be an expert in writing data retrieval statements.SQL taught in this book will be applicable to the MySQL environment. However with minor modifications, SQL queries can be written for other database environments like IBM DB2, Microsoft Access, Microsoft SQL Server, Oracle, Sybase or any other database environment. WHO SHOULD READ THIS BOOKThis book can be read by any and every technology professional as well as the individuals who are doing their graduation or post-graduation in information technology field. This book can be read by individuals with no SQL experience as well as those who have prior SQL knowledge.WHAT WILL YOU BE AFTER READING THE BOOKOnce you complete the book, you should be able to write SQL queries to retrieve data from database systems with a little brush up on the database implementation.Irrespective of your prior knowledge, after completing this book, you should be able to understand database and its components to a reasonable extent to write queries as well as to maintain data within the database.

  • Mastering XPages: A Step-by-Step Guide to XPages Application Development and the XSP Language, Edition 2

    Mastering XPages: A Step-by-Step Guide to XPages Application Development and the XSP Language, Edition 2
    Martin Donnelly

    IBM's Best-Selling Guide to XPages Development–Now Updated and Expanded for Lotus Notes/Domino 9.0.1 XPages instantly revolutionized Notes/Domino application development, and the newest versions deliver unprecedented performance and flexibility. Now, the popular insider's guide to XPages development has been updated and expanded to reflect all these improvements, through IBM Notes/Domino 9.0.1 and beyond. Three key members of the IBM XPages team have brought together comprehensive knowledge for delivering outstanding solutions. They have added several hundred pages of new content, including four new chapters. Drawing on their unsurpassed experience, they present new tips, samples, and best practices reflecting the platform's growing maturity. Writing for both XPages newcomers and experts, they cover the entire project lifecycle, including problem debugging, performance optimization, and application scalability. This second edition of Mastering XPages fully addresses enhancements to the XPages data sources for Domino views and documents; the latest XPages mobile library; the new Domino Designer Server-Side JavaScript debugger; and improvements to integrated technologies such as Dojo and CKEditor. Nearly every chapter contains at least one downloadable sample application, offering extensive hands-on practice. This guide concludes with complete references to XSP tags, relevant Java/JavaScript classes, and XSP style classes. Coverage includes * Understanding XPages' development paradigm, tooling, runtime framework, and application architecture* Configuring Domino Designer and integrating XPages Extension Library* Constructing application logic and using data binding controls* Reading/writing Notes documents: from use cases to design properties* Using Views, including examples of accessing calendars via REST* Making the most of Notes/Domino 9.0's new DataView control* Coding: from the basics to fully customized behavior* Advanced scripting: AJAX, Dojo, @Functions, managed beans, and more* Extending the Rich Text Editor's functionality* Building and consuming new controls with Extensibility APIs* Taking web applications offline in the Notes client* Building mobile apps: controls, design patterns, and best practices* Debugging Server-Side JavaScript with Domino Designer 9.0* Creating apps that look and work great–for local and global audiences* Systematically optimizing performance and scalability* Protecting data and users: leveraging Domino and Notes security models

  • Foundations of Digital Art and Design with Adobe Creative Cloud: Edition 2

    Foundations of Digital Art and Design with Adobe Creative Cloud: Edition 2
    xtine burrough

    Foundations of Digital Art and Design, Second Edition Fuses design fundamentals and software training into one cohesive approach! All students of digital design and production–whether learning in a classroom or on their own–need to understand the basic principles of design. These principles are often excluded from books that teach software. Foundations of Digital Art and Design reinvigorates software training by integrating design exercises into tutorials that fuse design fundamentals and core Adobe Creative Cloud skills. The result is a comprehensive design learning experience organized into five sections that focus on vector art, photography, image manipulation, typography, and effective work habits for digital artists. Design topics and principles include: Bits, Dots, Lines, Shapes, Unity, Rule of Thirds, Zone System, Color Models, Collage, Appropriation, Gestalt, The Bauhaus Basic Course Approach, Continuity, Automation, and Revision. This book: Teaches art and design principles with references to contemporary digital art alongside digital tools and processes in Adobe Creative Cloud Addresses the growing trend of compressing design fundamentals and design software into the same course in universities and design colleges Times each lesson to be used in 50 to 90-minute class sessions with additional practice materials available online Includes free video screencasts that demonstrate key concepts in every chapter Download work files and bonus chapters, view screencasts, connect with the author online and more; see the Introduction to the book for details. "This ambitious book teaches visual thinking and software skills together. The text leads readers step-by-step through the process of creating dynamic images using a range of powerful applications. The engaging, experimental exercises take this project well beyond the typical software guide." ELLEN LUPTON, co-author of Graphic Design: The New Basics

  • NX 12 Tutorial

    NX 12 Tutorial
    Online Instructor

    NX 12 Tutorial is written to help new users to learn the basics of NX and some advanced solid modeling techniques. The Author guides readers through NX 12 with clear and step-by-step tutorials that help you to design solid models from day one. The first four chapters of this book cover the user interface, part modeling, assemblies, and drawings. After learning the basics, you can learn additional sketching tools, feature modeling tools, expressions, sheet metal modeling, some advanced assembly techniques, drawing annotations, simulation basics, product manufacturing information, and rendering.

  • Balanced Scorecards and Operational Dashboards with Microsoft Excel: Edition 2

    Balanced Scorecards and Operational Dashboards with Microsoft Excel: Edition 2
    Ron Person

    Learn to maintain and update scorecards and dashboards with Excel Balanced Scorecards and operational dashboards measure organizational performance and Microsoft Excel is the tool used worldwide to create these scorecards and dashboards. This book covers time-proven step-by-step processes on how to guide executive teams and managers in creating scorecards and dashboards. It then shows Excel developers how to create those scorecards and dashboards. This is the only book that converts theory into practice. The author addresses the people and processes you need to identify strategy and operational metrics and then implement them in dashboards in three versions of Excel. You'll learn how balanced scorecards help organizations translate strategy into action and the ways that performance dashboards enable managers monitor operations. Covers Excel 2010 back to Excel 2003 Shows how to develop consensus on strategy and operational plans with the executive teams Details steps in creating tactical action plans Gives step-by-step guidance in creating the most powerful management dashboards Puts over ten years of experience in one book Balanced Scorecards & Operational Dashboards with Microsoft Excel, Second Edition is the ultimate resource for enhancing your strategic and operational performance.

  • SQL Short Course (Database Programming)

    SQL Short Course (Database Programming)
    Chris Fehily

    Get up to speed fast with SQL, the language of databases. Bestselling author Chris Fehily teaches you just the parts of SQL that you need to know. Quick, learn-by-example lessons start with simple data retrieval and sorting, move on to filtering and grouping, and then build to more-advanced topics, including joins, subqueries, views, and transactions. Whether you're an analyst, developer, data scientist, or Microsoft Office user, you'll find straightforward, practical answers. You can download the sample database to follow along with the examples.- Covers Oracle, Microsoft SQL Server, IBM DB2, MySQL, PostgreSQL, and Microsoft Access.- Learn the core language for standard SQL, and variations for the most widely used database systems.- Organize your database in terms of the relational model.- Master tables, columns, rows, and keys.- Retrieve, sort, and format data.- Filter the data that you don't want to see.- Convert and manipulate data with SQL's built-in functions and operators.- Use aggregate functions to summarize data.- Create complex SQL statements by using joins, subqueries, constraints, conditional logic, and metadata.- Create, alter, and drop tables, indexes, and views.- Insert, update, delete, and merge data.- Execute transactions to maintain the integrity of your data.- Avoid common pitfalls involving nulls.- Troubleshoot and optimize queries.- Plenty of tips, tricks, and timesavers.- Fully cross-referenced, linked, and searchable.Contents1. Introduction2. Database Basics3. SQL Basics4. Retrieving Data from a Table5. Sorting Rows6. Filtering Rows7. Combining and Negating Conditions8. Pattern Matching9. More Ways to Filter Rows10. Operators and Functions11. Working with Functions12. Evaluating Conditional Values13. Summarizing Data14. Grouping Data15. Joining Tables16. Working with Joins17. Subqueries18. Combining Queries19. Inserting Rows20. Updating and Deleting Rows21. Creating and Changing Tables22. Indexes23. Views24. TransactionsA. The Sample DatabaseB. Running SQL ProgramsC. Data Types

  • Biologically-Inspired Computing for the Arts: Scientific Data through Graphics: Scientific Data through Graphics

    Biologically-Inspired Computing for the Arts: Scientific Data through Graphics: Scientific Data through Graphics
    Ursyn, Anna

    Images support connections between biology, engineering, and material sciences resulting in a growing partnership among academia, laboratories, and industry. Scientists focus on biology-inspired research to understand how biological systems work, and then create systems and materials that would have efficiency and precision of living structures. The Art–Science connection has become one of prominent trends exemplified by themes presented in journals, conferences, and books.Biologically-Inspired Computing for the Arts: Scientific Data through Graphics comprises a collection of authors’ individual approaches to the relationship between nature, science, and art created with the use of computers. Themes discussed in the book relate to the use of visual language in communication about biologically-inspired scientific data, visual literacy in science, and application of practitioner’s approach. This comprehensive reference will assist programmers, scientists, engineers, computer science and science-oriented students in creating and effectively communicating their projects using science-related knowledge.

  • Self-Publishing Road Map: Seven Steps to Make Your Journey a Success

    Self-Publishing Road Map: Seven Steps to Make Your Journey a Success
    RJ Crayton

    Everything you need to know about self-publishing in one handy volume. More than a million books are self-published each year, and most disappear into the ether, seen by only a few. So, how do you self-publish your book and have it make a ripple in this giant self-publishing pond? Designed for use by both the beginner and moderately experienced person, The Self-Publishing Road Map offers practical guidance to make your self-publishing journey a success. The book discusses how to ready your book for publication, where and how to publish online, how to get reviews, and how to market your title. This book gives you all the steps you need to successfully complete your self-publishing goals. This isn't a get-rich-quick book, or a promise of untold riches. This is practical advice that pays off what you put into it. If you're ready to start your self-publishing journey, or already started and want somebody to ride shotgun and navigate, this is the book for you. Buckle up. It's time to go!

  • Going Beyond the Waterfall: Managing Scope Effectively Across the Project Life Cycle

    Going Beyond the Waterfall: Managing Scope Effectively Across the Project Life Cycle
    Barbara Davis

    “…the authors provide very sound and realistic advice for the types of projects envisaged, not necessarily only IT projects. For readers in senior positions, the book provides a good read and actionable advice and templates for advancing the cause of the enterprise at its upper levels. After all, as the authors observe, ‘The next decade of digital business will see continued pressure for organizations to react quickly to changing conditions in the economy, market, and competition’.”—R. Max Wideman, Fellow, PMIEvery year technology projects face hard decisions about how to mitigate risk and address challenges as teams work on creating useful solutions to deliver promised business value. Those decisions impact scope at every step and help to evolve it until the final product is delivered and implemented. Scope can longer be set in stone! This book will help project teams understand how and when scope changes and evolves as a part of a living-development process by answering the ultimate question: “Are we doing the right things the right way?” Going Beyond the Waterfall explains how to define scope at the outset of a project. It provides a solid model for predicting and managing solution scope across a project life cycle where the decisions and actions of every team member contribute to that evolutionary process. In addition, it identifies the impacts that key tasks and activities will have on scope and how each can be managed effectively to prevent unnecessary scope creep and reduce run-away projects.

  • Microsoft Office 365 Administration Inside Out (Includes Current Book Service): Edition 2

    Microsoft Office 365 Administration Inside Out (Includes Current Book Service): Edition 2
    Darryl Kegg

    Conquer Microsoft Office 365 Administration–from the inside out! Dive into Microsoft Office 365 Administration–and really put your Office 365 expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds–all you need to plan, implement, and operate Microsoft Office 365 in any environment. In this completely revamped Second Edition, a new author team thoroughly reviews the administration tools and capabilities available in the latest versions of Microsoft Office 365, and also adds extensive new coverage of Azure cloud services and SharePoint. Discover how experts tackle today’s essential tasks–and challenge yourself to new levels of mastery. • Install, customize, and use Office 365’s portal, dashboard, and admin centers • Make optimal decisions about tenancy, licensing, infrastructure, and hybrid options • Prepare your environment for the cloud • Manage Office 365 identity and access via federation services, password and directory synchronization, authentication, and AAD Connect • Implement alerts and threat management in the Security & Compliance Center • Establish Office 365 data classifications, loss prevention plans, and governance • Prepare your on-premises environment to connect with Exchange Online • Manage resource types, billing and licensing, service health reporting, and support • Move mailboxes to Exchange Online via cutover, staged, and express migrations • Establish hybrid environments with the Office 365 Hybrid Configuration Wizard • Administer Exchange Online, from recipients and transport to malware filtering • Understand, plan, and deploy Skype for Business Online Current Book Service In addition, this book is part of the Current Book Service from Microsoft Press. Books in this program receive periodic updates to address significant software changes for 12 to 18 months following the original publication date via a free Web Edition. Learn more at https://www.microsoftpressstore.com/cbs.

  • Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems

    Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems
    Martin Kleppmann

    Data is at the center of many challenges in system design today. Difficult issues need to be figured out, such as scalability, consistency, reliability, efficiency, and maintainability. In addition, we have an overwhelming variety of tools, including relational databases, NoSQL datastores, stream or batch processors, and message brokers. What are the right choices for your application? How do you make sense of all these buzzwords?In this practical and comprehensive guide, author Martin Kleppmann helps you navigate this diverse landscape by examining the pros and cons of various technologies for processing and storing data. Software keeps changing, but the fundamental principles remain the same. With this book, software engineers and architects will learn how to apply those ideas in practice, and how to make full use of data in modern applications.Peer under the hood of the systems you already use, and learn how to use and operate them more effectivelyMake informed decisions by identifying the strengths and weaknesses of different toolsNavigate the trade-offs around consistency, scalability, fault tolerance, and complexityUnderstand the distributed systems research upon which modern databases are builtPeek behind the scenes of major online services, and learn from their architectures

  • Design for How People Learn: Edition 2

    Design for How People Learn: Edition 2
    Julie Dirksen

    Products, technologies, and workplaces change so quickly today that everyone is continually learning. Many of us are also teaching, even when it's not in our job descriptions. Whether it's giving a presentation, writing documentation, or creating a website or blog, we need and want to share our knowledge with other people. But if you've ever fallen asleep over a boring textbook, or fast-forwarded through a tedious e-learning exercise, you know that creating a great learning experience is harder than it seems. In Design For How People Learn, Second Edition, you'll discover how to use the key principles behind learning, memory, and attention to create materials that enable your audience to both gain and retain the knowledge and skills you're sharing. Updated to cover new insights and research into how we learn and remember, this new edition includes new techniques for using social media for learning as well as two brand new chapters on designing for habit and best practices for evaluating learning, such as how and when to use tests. Using accessible visual metaphors and concrete methods and examples, Design For How People Learn, Second Edition will teach you how to leverage the fundamental concepts of instructional design both to improve your own learning and to engage your audience.

  • Learn WPF MVVM - XAML, C# and the MVVM pattern

    Learn WPF MVVM – XAML, C# and the MVVM pattern
    Arnaud Weil

    You're a developer who knows nothing to WPF. Which is fine, except that you need to start coding your next application using WPF and the MVVM pattern.Don't worry: I have you covered. I've been training hundreds of developers like you during 15 years, and converted my experience into this book. I know from experience teaching what takes more time to learn in WPF, and will spend time only where appropriate.Plus this book is packed with exercises which build up into a full project: you develop a small e-commerce sample application. You'll allow users to browse for products, and you'll also create a back-end where users will be able to list and edit products.Read this book, and you can code your WPF application within a week.

  • Excel VBA Programming For Dummies: Edition 5

    Excel VBA Programming For Dummies: Edition 5
    Michael Alexander

    Take your Excel programming skills to the next level To take Excel to the next level, you need to understand and implement the power of Visual Basic for Applications (VBA). Excel VBA Programming For Dummies introduces you to a wide array of new Excel options, beginning with the most important tools and operations for the Visual Basic Editor. Inside, you’ll find an overview of the essential elements and concepts for programming with Excel. In no time, you’ll discover techniques for handling errors and exterminating bugs, working with range objects and controlling program flow, and much more. With friendly advice on the easiest ways to develop custom dialog boxes, toolbars, and menus, readers will be creating Excel applications custom fit to their unique needs! Fully updated for the new Excel 2019 Step-by-step instructions for creating VBA macros to maximize productivity Guidance on customizing your applications so they work the way you want All sample programs, VBA code, and worksheets are available at dummies.com Beginning VBA programmers rejoice! This easy-to-follow book makes it easier than ever to excel at Excel VBA!

  • Programming Excel with VBA and .NET: Solve Real-World Problems with Excel

    Programming Excel with VBA and .NET: Solve Real-World Problems with Excel
    Jeff Webb

    Why program Excel? For solving complex calculations and presenting results, Excel is amazingly complete with every imaginable feature already in place. But programming Excel isn't about adding new features as much as it's about combining existing features to solve particular problems. With a few modifications, you can transform Excel into a task-specific piece of software that will quickly and precisely serve your needs. In other words, Excel is an ideal platform for probably millions of small spreadsheet-based software solutions. The best part is, you can program Excel with no additional tools. A variant of the Visual Basic programming language, VB for Applications (VBA) is built into Excel to facilitate its use as a platform. With VBA, you can create macros and templates, manipulate user interface features such as menus and toolbars, and work with custom user forms or dialog boxes. VBA is relatively easy to use, but if you've never programmed before, Programming Excel with VBA and .NET is a great way to learn a lot very quickly. If you're an experienced Excel user or a Visual Basic programmer, you'll pick up a lot of valuable new tricks. Developers looking forward to .NET development will also find discussion of how the Excel object model works with .NET tools, including Visual Studio Tools for Office (VSTO). This book teaches you how to use Excel VBA by explaining concepts clearly and concisely in plain English, and provides plenty of downloadable samples so you can learn by doing. You'll be exposed to a wide range of tasks most commonly performed with Excel, arranged into chapters according to subject, with those subjects corresponding to one or more Excel objects. With both the samples and important reference information for each object included right in the chapters, instead of tucked away in separate sections, Programming Excel with VBA and .NET covers the entire Excel object library. For those just starting out, it also lays down the basic rules common to all programming languages. With this single-source reference and how-to guide, you'll learn to use the complete range of Excel programming tasks to solve problems, no matter what you're experience level.

  • How to Run Android™ Apps In Chrome™ Browser: An Easy-to-Follow Comprehensive Step-by-Step Book

    How to Run Android™ Apps In Chrome™ Browser: An Easy-to-Follow Comprehensive Step-by-Step Book
    Sam D. Johnson

    How to Run Android™ Apps in Chrome™ Browser is a detailed and straightforward account about how Sam D. Johnson is successfully able to play Android apps on PC without BlueStacks™ and other Android emulators hogging up unnecessary desktop and laptop resources. The only playground Android needs to play in is the Chrome browser! And, this step-by-step how-to book explains just what the author does and in real time. Listing price will change. So if you see a low price, get it because it will not be available again after the promotional discount period. (Just letting you know that you aren't going crazy if you return only to see a different and higher price tag.)

  • Collect, Combine, and Transform Data Using Power Query in Excel and Power BI

    Collect, Combine, and Transform Data Using Power Query in Excel and Power BI
    Gil Raviv

    Using Power Query, you can import, reshape, and cleanse any data from a simple interface, so you can mine that data for all of its hidden insights. Power Query is embedded in Excel, Power BI, and other Microsoft products, and leading Power Query expert Gil Raviv will help you make the most of it. Discover how to eliminate time-consuming manual data preparation, solve common problems, avoid pitfalls, and more. Then, walk through several complete analytics challenges, and integrate all your skills in a realistic chapter-length final project. By the time you’re finished, you’ll be ready to wrangle any data–and transform it into actionable knowledge. Prepare and analyze your data the easy way, with Power Query · Quickly prepare data for analysis with Power Query in Excel (also known as Get & Transform) and in Power BI · Solve common data preparation problems with a few mouse clicks and simple formula edits · Combine data from multiple sources, multiple queries, and mismatched tables · Master basic and advanced techniques for unpivoting tables · Customize transformations and build flexible data mashups with the M formula language · Address collaboration challenges with Power Query · Gain crucial insights into text feeds · Streamline complex social network analytics so you can do it yourself For all information workers, analysts, and any Excel user who wants to solve their own business intelligence problems.

  • Easy Smashwords Formatting In Microsoft Office

    Easy Smashwords Formatting In Microsoft Office
    Jay Johnson

    Welcome to Easy Smashwords Formatting In Microsoft Office. In this guide you'll learn the ten steps it takes to get your book into the Smashwords Premium Distribution Program every time. This book is specifically designed for those of you who prefer to use Microsoft Word 2007 and above however it will work reasonably well with other versions of Word.My book, however, is just for those who want an exact step by step guide to the Nuclear Method. In it you'll discover how to get your book into the Premium Catalog and save time doing it in Microsoft Word.

  • Excel VBA: A Beginners Guide

    Excel VBA: A Beginners’ Guide
    Rajan

    Excel VBA is very helpful for you to do your routine task, create your own function, reduce the manual effort and increase your productivity. With the help of VBA you can customize and manipulate data present in the excel sheet as you want. This book will be very helpful and comes in handy for the beginners who don’t have any programming knowledge. The ultimate aim of this book is to turns the reader to think like an Experienced VBA programmer. All the topics in this book are elaborated in simple manner for easy understanding. Each and every topic in this book is covered with detailed illustrations followed by output. What you will learn in this book 1) Introduction to Excel VBA- 2) Declaring Variables 3) Working with Ranges 4) If…Else Statements 5) Select Case Statements 6) For Next Statements 7) Do Loops 8) Operators in VBA 9) Understanding the VB Editor 10) Function Procedures 11) MsgBox and InputBox Functions 12) String Functions 13) Information Functions 14) Working with Internet Explorer

  • SAS for Finance: Forecasting and data analysis techniques with real-world examples to build powerful financial models

    SAS for Finance: Forecasting and data analysis techniques with real-world examples to build powerful financial models
    Harish Gulati

    Leverage the analytical power of SAS to perform financial analysis efficientlyKey FeaturesLeverage the power of SAS to analyze financial data with easeFind hidden patterns in your data, predict future trends, and optimize risk managementLearn why leading banks and financial institutions rely on SAS for financial analysisBook DescriptionSAS is a groundbreaking tool for advanced predictive and statistical analytics used by top banks and financial corporations to establish insights from their financial data.SAS for Finance offers you the opportunity to leverage the power of SAS analytics in redefining your data. Packed with real-world examples from leading financial institutions, the author discusses statistical models using time series data to resolve business issues.This book shows you how to exploit the capabilities of this high-powered package to create clean, accurate financial models. You can easily assess the pros and cons of models to suit your unique business needs.By the end of this book, you will be able to leverage the true power of SAS to design and develop accurate analytical models to gain deeper insights into your financial data.What you will learnUnderstand time series data and its relevance in the financial industryBuild a time series forecasting model in SAS using advanced modeling theoriesDevelop models in SAS and infer using regression and Markov chainsForecast inflation by building an econometric model in SAS for your financial planningManage customer loyalty by creating a survival model in SAS using various groupingsUnderstand similarity analysis and clustering in SAS using time series dataWho this book is forFinancial data analysts and data scientists who want to use SAS to process and analyze financial data and find hidden patterns and trends from it will find this book useful. Prior exposure to SAS will be helpful but is not mandatory. Some basic understanding of the financial concepts is required.

  • Take Control of Getting Started with DEVONthink 2: Edition 3

    Take Control of Getting Started with DEVONthink 2: Edition 3
    Joe Kissell

    Take control of all your information with DEVONthink and Joe Kissell's advice!With the information-management program DEVONthink 2, you no longer have to swim in a sea of Web bookmarks, email receipts, RSS feeds, scanned memos, and downloaded bank statements. DEVONthink stores your digital documents and clippings, helps you scan and store paper documents, and serves as home base for organizing and viewing all your information. But mastering all that power can take effort, and this book–created in partnership with DEVONtechnologies–has the real-world advice you need to understand how DEVONthink can bring order to your information.You'll also learn how to extend your DEVONthink experience beyond your main Mac with Joe's detailed explanation of the many ways you can sync DEVONthink databases to your other Apple devices and his lucid look at the DEVONthink To Go iOS app."This book got me around some suboptimal usage patterns that were holding up my profitable use of this excellent software. I'd recommend this book to any level of DEVONthink user." –Scott McGrathAfter covering essential DEVONthink vocabulary and concepts, Joe helps you start using DEVONthink effectively. You'll learn how to:Get around in the interfaceDecide how many databases you need and set them upDetermine whether to input or index dataConfigure where incoming data will goImport data from many different appsImport data from a scanner, including OCR optionsUse grouping and tagging to organize dataUse simple (and sophisticated) techniques for searchingCreate smart groups that automatically gather newly imported dataCreate documents in plain text, HTML, Markdown, and moreEdit documents in DEVONthink (or externally)Find the best way to sync DEVONthink data with other devicesGet tips for working effectively in the DEVONthink To Go iOS appShare DEVONthink documents with other peopleExport documents from DEVONthinkBack up and maintain healthy databasesQuestions answered in the book include:What is DEVONthink good for, and what should be left to other programs?What kinds of data can I import? (Short answer: Nearly everything!)Which of DEVONthink's many views should I use?When I import documents from different sources, where do they end up, and why?Is it better to sort imported documents right away, or leave them for later?Should I group my data, tag it, or both?What are duplicates and replicants, and how can I tell them apart?Which types of data can be created or edited within DEVONthink?How do I make my DEVONthink database accessible via the Web?How do I move documents out of DEVONthink using the Share feature?How do I use DEVONthink To Go on my iOS device?Are there Automator or AppleScript options for DEVONthink? (Hint: Yes!)

  • Microsoft Word 2013: Illustrated Introductory

    Microsoft Word 2013: Illustrated Introductory
    Jennifer Duffy

    Praised by instructors for its concise, focused approach and user-friendly format, the Illustrated Series engages both computer rookies and hot shots in mastering MICROSOFT WORD 2013 quickly and efficiently. Skills are accessible and easy-to-follow thanks to the Illustrated Series’ hallmark 2-page layout, which allows students to see an entire task in one view. New Learning Outcomes outline the skills covered in each lesson, and larger full-color screens represent exactly what students should see on their own computers. Each unit begins with a brief overview of the principles of the lesson, and introduces a case study for further application.Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.

  • The Definitive Guide to DAX: Business intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel, Edition 2

    The Definitive Guide to DAX: Business intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel, Edition 2
    Marco Russo

    Now expanded and updated with modern best practices, this is the most complete guide to Microsoft’s DAX language for business intelligence, data modeling, and analytics. Expert Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization. You’ll learn exactly what happens under the hood when you run a DAX expression, and use this knowledge to write fast, robust code. This edition focuses on examples you can build and run with the free Power BI Desktop, and helps you make the most of the powerful syntax of variables (VAR) in Power BI, Excel, or Analysis Services. Want to leverage all of DAX’s remarkable capabilities? This no-compromise “deep dive” is exactly what you need. Perform powerful data analysis with DAX for Power BI, SQL Server, and Excel · Master core DAX concepts, including calculated columns, measures, and calculation groups · Work efficiently with basic and advanced table functions · Understand evaluation contexts and the CALCULATE and CALCULATETABLE functions · Perform time-based calculations · Use calculation groups and calculation items · Use syntax of variables (VAR) to write more readable, maintainable code · Express diverse and unusual relationships with DAX, including many-to-many relationships and bidirectional filters · Master advanced optimization techniques, and improve performance in aggregations · Optimize data models to achieve better compression · Measure DAX query performance with DAX Studio and learn how to optimize your DAX

  • Adobe Acrobat DC Classroom in a Book

    Adobe Acrobat DC Classroom in a Book
    Lisa Fridsma

    Adobe Acrobat DC Classroom in a Book is the most thorough and comprehensive way for students to learn how to reliably create, edit, and sign PDF documents and forms with Adobe Acrobat DC. Each of the 13 lessons in this step-by-step, project-based guide contains a project that builds on their growing knowledge of the program, while end-of-chapter review questions reinforce each lesson. This cross-platform (Mac and Windows) book shows students how to collaborate effectively through electronic reviews, easily share their work across multiple platforms and devices (including via the new Adobe Document Cloud service), and speed up their production and business task workflow with Acrobat DC. All of the book’s screenshots have been updated for the new edition, showing users how to navigate the completely overhauled user interface–a selling point for existing users of the software. Readers will also learn how to use the new Tool pane so they can easily convert files (Microsoft Office documents and graphics) to PDF and then learn how to directly edit text and images in their PDFs. They'll also learn how to use the newly refreshed tools to build PDF or web forms, speed up business workflow by gathering feedback and approval via online document reviews. And they'll learn how to create interactive forms and track responses within Acrobat, how to add signatures and security to their PDF files, and much more. All of the project files used in the book’s lessons are available for readers to download at peachpit.com.

  • SQL for Microsoft Access: Edition 2

    SQL for Microsoft Access: Edition 2
    Cecelia L. Allison

    SQL for Microsoft Access (2nd Edition) provides a guide to getting the most out of Microsoft Access through the use of Structured Query Language. Step-by-step examples demonstrate how to use SQL script to create tables, add records to tables, and retrieve and manage records. Readers will also learn about calculated fields, Access projects, and the integration of SQL script in VBA and ASP code.Explore the relational database structure and the basics of SQL. Understand how table joins, unions, and subqueries are used to retrieve records from multiple tables simultaneously. Learn how to filter records and group data. Discover how to create parameter queries that prompt users for data. Test your knowledge and comprehension with the end-of-chapter quizzes and projects.

  • Exam Ref 70-778 Analyzing and Visualizing Data by Using Microsoft Power BI

    Exam Ref 70-778 Analyzing and Visualizing Data by Using Microsoft Power BI
    Daniil Maslyuk

    Prepare for Microsoft Exam 70-778–and help demonstrate your real-world mastery of Power BI data analysis and visualization. Designed for experienced BI professionals and data analysts ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: Consume and transform data by using Power BI Desktop Model and visualize data Configure dashboards, reports, and apps in the Power BI Service This Microsoft Exam Ref: Organizes its coverage by exam objectives Features strategic, what-if scenarios to challenge you Assumes you have experience consuming and transforming data, modeling and visualizing data, and configuring dashboards using Excel and Power BI

  • Hands-On Design Patterns with Delphi: Build applications using idiomatic, extensible, and concurrent design patterns in Delphi

    Hands-On Design Patterns with Delphi: Build applications using idiomatic, extensible, and concurrent design patterns in Delphi
    Primož Gabrijelčič

    Get up to speed with creational, structural, behavioral and concurrent patterns in Delphi to write clear, concise and effective codeKey FeaturesDelve into the core patterns and components of Delphi in order to master your application's designBrush up on tricks, techniques, and best practices to solve common design and architectural challengesChoose the right patterns to improve your program’s efficiency and productivityBook DescriptionDesign patterns have proven to be the go-to solution for many common programming scenarios. This book focuses on design patterns applied to the Delphi language. The book will provide you with insights into the language and its capabilities of a runtime library.You'll start by exploring a variety of design patterns and understanding them through real-world examples. This will entail a short explanation of the concept of design patterns and the original set of the 'Gang of Four' patterns, which will help you in structuring your designs efficiently. Next, you'll cover the most important 'anti-patterns' (essentially bad software development practices) to aid you in steering clear of problems during programming. You'll then learn about the eight most important patterns for each creational, structural, and behavioral type. After this, you'll be introduced to the concept of 'concurrency' patterns, which are design patterns specifically related to multithreading and parallel computation. These will enable you to develop and improve an interface between items and harmonize shared memories within threads. Toward the concluding chapters, you'll explore design patterns specific to program design and other categories of patterns that do not fall under the 'design' umbrella.By the end of this book, you'll be able to address common design problems encountered while developing applications and feel confident while building scalable projects.What you will learnGain insights into the concept of design patternsStudy modern programming techniques with DelphiKeep up to date with the latest additions and program design techniques in DelphiGet to grips with various modern multithreading approachesDiscover creational, structural, behavioral, and concurrent patternsDetermine how to break a design problem down into its component partsWho this book is forHands-On Design Patterns with Delphi is aimed at beginner-level Delphi developers who want to build scalable and robust applications. Basic knowledge of Delphi is a must.

  • Microsoft Excel 2019 Inside Out

    Microsoft Excel 2019 Inside Out
    Bill Jelen

    Conquer Microsoft Excel 2019–from the inside out! Dive into Microsoft Excel 2019–and really put your spreadsheet expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds–all you need to make the most of Excel’s most powerful tools for analyzing data and making better decisions. Renowned Excel expert Bill Jelen offers a complete tour of Excel 2019 and Excel in Office 365, from efficient interface customizations to advanced analysis, visualizations, and dashboards. Discover how experts tackle today’s key tasks–and challenge yourself to new levels of mastery. Enter formulas more efficiently, and fully control operators and dates Master the most widely-used functions in Excel Integrate external data from the web and other sources Easily transform complex datasets with Power Query Quickly summarize millions of records with Pivot Tables Perform ad hoc analyses with slicers and other filters Create advanced data mashups with Power Pivot Solve complex problems with What-If, Scenario Manager, Goal Seek, and Solver Automate repetitive tasks by editing recorded VBA code Demystify data with conditional formatting and other visualization techniques Use the newest maps, charts, and data types in Excel Show geographical changes over time with animated 3D maps Use dynamic array functions: SORT, FILTER, UNIQUE, SORTBY and SEQUENCE Find insights using Excel’s new artificial intelligence Collaborate via Excel 2019’s breakthrough CoAuthoring tools Publish Power BI Desktop dashboards based on Excel data

  • SketchUp to LayOut: The essential guide to creating construction documents with SketchUp Pro & LayOut.

    SketchUp to LayOut: The essential guide to creating construction documents with SketchUp Pro & LayOut.
    Matt Donley

    The SketchUp to LayOut book is the essential guide for woodworkers, carpenters, architects, contractors, builders, and designers who already know the basics on how to use SketchUp, but are looking to create stunning presentations to visualize their ideas with their clients using LayOut.Learn the workflow for creating models specifically for LayOutBefore you even begin modeling that first rectangle, you'll need to fully understand which type of model you should be building for LayOut. Don't make the mistake of creating twice the amount of work for yourself because you didn't properly organize your model ahead of time.I'll teach you how to save time and frustration by organizing your model so YOU are in control of how your model viewports look.The entire first half of the book is dedicated to preparing your model for LayOut. From organizational workflow, to scenes and styles. I share with you my 5 point method I use to visualize and prepare every scene I create for LayOut.Not only will you understand exactly what those five points are, you'll learn multiple ways to control them. Using these methods, you will gain complete control over the look of your viewports in LayOut. You will master every aspect of a SketchUp scene and style, to enable you to create impressive presentations and drawings in the least amount of time possible.Is this too advanced for me?This book is designed for construction professionals who don't have any prior experience in LayOut at all. But it's also structured in a way that lets you look up specific tasks or methods without having to read the book cover to cover. I’ll save you all the time and frustration that I went through when I first learned LayOut by quickly orienting you with the workspace, then jumping right in to creating your own titleblock, inserting SketchUp models, and adding dimensions.You should have some basic knowledge on how to use SketchUp. But if you're just starting out, you'll have complete access to my entire library of tutorials and videos for free on my website to bring you up to speed quickly.Every important aspect of LayOut is explained in the book, with step by step instructions for you to follow along. Learn exactly what you need to know and skip over all the little details you don’t need to worry about. The book has been updated for 2014 so you'll even learn about the new Auto-Text tag feature, saving you a ton of time on those redundant text edits.You’ll see REAL examplesThe sample projects in the book are real projects, not hypothetical meaningless shapes and boxes, so you can see exactly how to apply the concepts you learn in context with the real world. Plus, the SketchUp and LayOut files are included with each book download so you’ll be able to follow along and discover for yourself how to organize a similar project of your own. The sample projects include a woodworking table project, akitchen project, and a three story house project.At the same time, each step by step instruction can be read and followed independently from the project. So if you need to go back and reference a certain part of the book to learn how to do something specific, you'll be able to do that too.Advanced TechniquesI’ve consulted with many of the best SketchUp gurus in the world! I’ve hung out with Nick Sonder at the SketchUp basecamp conference. I’ve interviewed Aidan Chopra, SketchUp evangelist and author of “Google SketchUp for Dummies”, Eric Schimelpfenig from SketchThis.net, and Alexander Schreyer, author of “Architectural Design with SketchUp”. I’ve also consulted with Mike Brightman, author of “The SketchUp Workflow for Architecture”, Daniel Tal, author of “Rendering In SketchUp”, and many other great SketchUp experts.

  • Excel 2016 Formulas and Functions (includes Content Update Program)

    Excel 2016 Formulas and Functions (includes Content Update Program)
    Paul McFedries

    Book + Content Update Program Master core Excel 2016 tools for building powerful, reliable spreadsheets with Excel 2016 Formulas and Functions. Excel expert Paul McFedries shows how to use Excel 2016’s core features to solve problems and get the answers you need. Using real-world examples, McFedries helps you get the absolute most out of features and improvements ranging from AutoFill to Excel’s newest functions. Along the way, you discover the fastest, best ways to handle essential day-to-day tasks ranging from generating account numbers to projecting the impact of inflation. Becoming an Excel expert has never been easier! You’ll find crystal-clear instructions; insider insights; even complete step-by-step projects for building timesheets, projecting cash flow, aging receivables, analyzing defects, and more. • Quickly create powerful spreadsheets with range names and array formulas• Use conditional formatting to instantly reveal anomalies, problems, or opportunities• Analyze your data with standard tables and PivotTables• Use complex criteria to filter data in lists• Understand correlations between data• Perform sophisticated what-if analyses• Use regression to track trends and make forecasts• Build loan, investment, and discount formulas• Validate data, troubleshoot problems, and build more accurate, trustworthy spreadsheets In addition, this book is part of Que’s exciting Content Update Program. As Microsoft updates features of Excel 2016, sections of this book will be updated or new sections will be added to match the updates to the software. The updates will be delivered to you via a FREE Web Edition of this book, which can be accessed with any Internet connection. To learn more, visit www.quepublishing.com/CUP. About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will• Dramatically increase your productivity–saving you 50 hours a year or more• Present proven, creative strategies for solving real-world problems• Show you how to get great results, no matter how much data you have• Help you avoid critical mistakes that even experienced users make

  • Microsoft Excel 2019 VBA and Macros

    Microsoft Excel 2019 VBA and Macros
    Bill Jelen

    Renowned Excel experts Bill Jelen (MrExcel) and Tracy Syrstad explain how to build more powerful, reliable, and efficient Excel spreadsheets. Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won’t find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help you instantly visualize information to make it actionable; capture data from anywhere, and use it anywhere; and automate the best new features in Excel 2019 and Excel in Office 365. You’ll find simple, step-by-step instructions, real-world case studies, and 50 workbooks packed with examples and complete, easy-to-adapt solutions. By reading this book, you will: Quickly master Excel macro development Work more efficiently with ranges, cells, and formulas Generate automated reports and quickly adapt them for new requirements Learn to automate pivot tables to summarize, analyze, explore, and present data Use custom dialog boxes to collect data from others using Excel Improve the reliability and resiliency of your macros Integrate data from the internet, Access databases, and other sources Automatically generate charts, visualizations, sparklines, and Word documents Create powerful solutions with classes, collections, and custom functions Solve sophisticated business analysis problems more rapidly About This Book For everyone who wants to get more done with Microsoft Excel in less time For business and financial professionals, entrepreneurs, students, and others who need to efficiently manage and analyze data

  • Microsoft Business Intelligence Tools for Excel Analysts

    Microsoft Business Intelligence Tools for Excel Analysts
    Michael Alexander

    Bridge the big data gap with Microsoft Business Intelligence Tools for Excel Analysts The distinction between departmental reporting done by business analysts with Excel and the enterprise reporting done by IT departments with SQL Server and SharePoint tools is more blurry now than ever before. With the introduction of robust new features like PowerPivot and Power View, it is essential for business analysts to get up to speed with big data tools that in the past have been reserved for IT professionals. Written by a team of Business Intelligence experts, Microsoft Business Intelligence Tools for Excel Analysts introduces business analysts to the rich toolset and reporting capabilities that can be leveraged to more effectively source and incorporate large datasets in their analytics while saving them time and simplifying the reporting process. Walks you step-by-step through important BI tools like PowerPivot, SQL Server, and SharePoint and shows you how to move data back and forth between these tools and Excel Shows you how to leverage relational databases, slice data into various views to gain different visibility perspectives, create eye-catching visualizations and dashboards, automate SQL Server data retrieval and integration, and publish dashboards and reports to the web Details how you can use SQL Server’s built-in functions to analyze large amounts of data, Excel pivot tables to access and report OLAP data, and PowerPivot to create powerful reporting mechanisms You’ll get on top of the Microsoft BI stack and all it can do to enhance Excel data analysis with this one-of-a-kind guide written for Excel analysts just like you.

  • MOS 2016 Study Guide for Microsoft Excel Expert: MOS Stud Guid Micr Exce Expe

    MOS 2016 Study Guide for Microsoft Excel Expert: MOS Stud Guid Micr Exce Expe
    Paul McFedries

    This is the eBook of the printed book and may not include any media, website access codes, or print supplements that may come packaged with the bound book. Hone your advanced Excel 2016 skills. And earn the credential that proves it! Demonstrate your expertise with Microsoft Excel! Designed to help you practice and prepare for Microsoft Office Specialist (MOS): Excel Expert 2016 certification, this official Study Guide delivers: In-depth preparation for each MOS objective Detailed procedures to help build the skills measured by the exam Hands-on tasks to practice what you’ve learned Ready-made practice files Sharpen the skills measured by these objectives: Create and Manage Workbooks Apply Custom Formatting and Layouts Create Advanced Formulas Perform Data Analysis Create Advanced Charts and PivotTables

  • QuickBooks 2010 For Dummies: Edition 17

    QuickBooks 2010 For Dummies: Edition 17
    Stephen L. Nelson

    The annual update of a perennial bestseller, fully revised for the newest QuickBooks release QuickBooks is the leading software package for small business accounting, updated each year so it remains cutting-edge. QuickBooks 2010 For Dummies provides all the information you need to start using the newest version in your business. You'll learn to set up your business accounting functions on QuickBooks and use all the newest features. You'll be able to create budgets, process payroll, manage inventory and invoices, track job costs, balance accounts, and make things easier at tax preparation time. Shows you, in plain English, how to set up QuickBooks and manage your small business accounting on your own Explains how to set up your business on QuickBooks, create invoices and credit memos, record sales receipts, set up inventory items, and track business credit cards Covers recording and paying bills, printing checks, processing payroll, and preparing payroll taxes Discusses building a budget, going online with QuickBooks, balancing accounts, generating financial reports, simplifying tax return preparation, and backing up data Also explores job estimating, billing, and tracking jobs and invoices Written by Stephen L. Nelson, author of all previous editions and an experienced CPA, QuickBooks 2010 For Dummies will help you become your own accountant and keep your business in the black.

  • SQL Tricks (Advanced Database Programming)

    SQL Tricks (Advanced Database Programming)
    Chris Fehily

    This cookbook of advanced techniques is for anyone who knows the basics of SQL and wants to move beyond simple SELECT-FROM-WHERE queries. You'll find solutions to problems that analysts, app developers, and database programmers often face, from simple tasks, like picking random rows, to complex operations, like traversing hierarchies. Each recipe includes a discussion of the underlying logic, important concepts, and best practices. Take full advantage of standard (ANSI/ISO) SQL, or use DBMS-specific features that dramatically extend the power of standard SQL. Use the scores of code examples directly in real-world DBMS applications, or as a source of insight for related problems.- Covers Oracle, Microsoft SQL Server, IBM DB2, MySQL, PostgreSQL, and Microsoft Access.- Implement cross-platform solutions in standard SQL, or DBMS-specific solutions for your particular system.- Full-color SQL code listings help you see the elements and structure of the language.- Download the sample database and code listings to follow along with the author's examples.- Plenty of tips, tricks, and timesavers.- Fully cross-referenced, linked, and searchable.ContentsIntroduction1. Running SQL Programs2. Calculating Running Statistics3. Generating Sequences4. Finding Sequences, Runs, and Regions5. Limiting the Number of Rows Returned6. Assigning Ranks7. Calculating a Trimmed Mean8. Picking Random Rows9. Handling Duplicates10. Creating a Telephone List11. Retrieving Metadata12. Working with Dates13. Calculating a Median14. Finding Extreme Values15. Changing Running Statistics Midstream16. Pivoting Results17. Working with Hierarchies

  • Head First Data Analysis: A learner s guide to big numbers, statistics, and good decisions

    Head First Data Analysis: A learner’s guide to big numbers, statistics, and good decisions
    Michael Milton

    Today, interpreting data is a critical decision-making factor for businesses and organizations. If your job requires you to manage and analyze all kinds of data, turn to Head First Data Analysis, where you'll quickly learn how to collect and organize data, sort the distractions from the truth, find meaningful patterns, draw conclusions, predict the future, and present your findings to others.Whether you're a product developer researching the market viability of a new product or service, a marketing manager gauging or predicting the effectiveness of a campaign, a salesperson who needs data to support product presentations, or a lone entrepreneur responsible for all of these data-intensive functions and more, the unique approach in Head First Data Analysis is by far the most efficient way to learn what you need to know to convert raw data into a vital business tool.You'll learn how to:Determine which data sources to use for collecting informationAssess data quality and distinguish signal from noiseBuild basic data models to illuminate patterns, and assimilate new information into the modelsCope with ambiguous informationDesign experiments to test hypotheses and draw conclusionsUse segmentation to organize your data within discrete market groupsVisualize data distributions to reveal new relationships and persuade othersPredict the future with sampling and probability modelsClean your data to make it usefulCommunicate the results of your analysis to your audienceUsing the latest research in cognitive science and learning theory to craft a multi-sensory learning experience, Head First Data Analysis uses a visually rich format designed for the way your brain works, not a text-heavy approach that puts you to sleep.

  • Microsoft Excel 2010 Data Analysis and Business Modeling: Data Analysis and Business Modeling

    Microsoft Excel 2010 Data Analysis and Business Modeling: Data Analysis and Business Modeling
    Wayne Winston

    Master the business modeling and analysis techniques that help you transform data into bottom-line results. For more than a decade, Wayne Winston has been teaching corporate clients and MBA students the most effective ways to use Excel to solve business problems and make better decisions. Now this award-winning educator shares the best of his expertise in this hands-on, scenario-focused guide—fully updated for Excel 2010! Use Excel to solve real business problems—and sharpen your edge! Model investment risks and returns Analyze your sales team’s effectiveness Create best, worst, and most-likely case scenarios Compare lease vs. buy, and calculate loan terms See how price, advertising, and seasonality affect sales Manage inventory with precision Quantify the value of customer loyalty Calculate your break-even number and ROI Maximize scheduling efficiency Express “home-field advantage” in real numbers Project company growth, predict election results, and more! Plus—introduce yourself to PowerPivot for Excel Your companion web content includes: Downloadable eBook Hundreds of scenario-based practice problems All the book’s sample files—plus customizable templates

  • Quicken All-in-One Desk Reference For Dummies

    Quicken All-in-One Desk Reference For Dummies
    Gail A. Perry

    Quicken is the #1 personal finance software on the market, with greater than 70 percent retail market share and 16 million active users This book features eight minibooks comprising nearly 750 pages-all the information people need to get the most out of the latest Quicken release, get their finances under control, start building a nest egg, and pay less to the IRS The only book on the market to include coverage on Quicken Premier Home & Business Minibook topics include personal finance basics, an introduction to Quicken, household finances, planning ahead and saving, tracking investments, retirement planning, taxes, and managing small business finances Quicken books are consistent top sellers, with more than 900,000 copies of Quicken For Dummies sold in all in all editions

  • Agile Data Science 2.0: Building Full-Stack Data Analytics Applications with Spark

    Agile Data Science 2.0: Building Full-Stack Data Analytics Applications with Spark
    Russell Jurney

    Data science teams looking to turn research into useful analytics applications require not only the right tools, but also the right approach if they’re to succeed. With the revised second edition of this hands-on guide, up-and-coming data scientists will learn how to use the Agile Data Science development methodology to build data applications with Python, Apache Spark, Kafka, and other tools.Author Russell Jurney demonstrates how to compose a data platform for building, deploying, and refining analytics applications with Apache Kafka, MongoDB, ElasticSearch, d3.js, scikit-learn, and Apache Airflow. You’ll learn an iterative approach that lets you quickly change the kind of analysis you’re doing, depending on what the data is telling you. Publish data science work as a web application, and affect meaningful change in your organization.Build value from your data in a series of agile sprints, using the data-value pyramidExtract features for statistical models from a single datasetVisualize data with charts, and expose different aspects through interactive reportsUse historical data to predict the future via classification and regressionTranslate predictions into actionsGet feedback from users after each sprint to keep your project on track