Business applications Books
McGraw-Hill Education Computing Essentials 2025 2024 Release ISE
Book SynopsisComputing Essentials adds a focus on the growing impact of AI tools on industries andcareers, ethical considerations of AI, AI presence in social media, andinnovative uses of AI. These concepts have been incorporated into the maintext, as well as the Privacy, Ethics, Community, Making IT Work for You, and ALook to the Future features.
£53.99
Pearson Education (US) Microsoft Office Step by Step Office 2021 and
Book Synopsis Covers Word, Excel, PowerPoint, and Outlook Format Word documents for maximum visual impact Build powerful, reliable Excel workbooks for analysis and reporting Prepare highly effective PowerPoint presentations Use Outlook to organize your email, calendar, and contacts Includes downloadable practice files Table of ContentsPart 1: Microsoft Office (Microsoft 365 Apps) 1: Explore Office 2: Create and manage files Part 2: Microsoft Word 3: Modify the structure and appearance of text 4: Collaborate on documents 5: Merge data with documents and labels Part 3: Excel 6: Perform calculations on data 7: Manage worksheet data 8: Reorder and summarize data 9: Analyze alternative data sets Part 4: PowerPoint 10: Create and manage slides 11: Insert and manage simple graphics 12: Add sound and movement to slides Part 5: Microsoft Outlook 13: Send and receive email messages 14: Organize your Inbox 15: Manage scheduling Appendix: Keyboard shortcuts
£27.19
John Wiley & Sons Inc VMware vSphere For Dummies
Book SynopsisA plain-English guide to the market-leading virtualization and cloud computing technology With virtualization, a single server can host dozens or hundreds of virtual machines running a variety of operating systems, and even hook them together in a virtual network or cloud infrastructure.Table of ContentsIntroduction 1 Part I: Deciding on vSphere 7 Chapter 1: Getting the Most Out of VMware vSphere 9 Chapter 2: Introducing Virtualization 15 Chapter 3: Exploring the Capabilities of VMware vSphere 29 Chapter 4: Comparing Virtual Infrastructure 3.5 with vSphere 4 x 39 Part II: Getting Ready for vSphere 51 Chapter 5: Planning for a vSphere Rollout 53 Chapter 6: Preparing Network and Storage for vSphere 65 Part III: Installing vSphere 73 Chapter 7: Installing VMware ESX 4 for the First Time 75 Chapter 8: Building the vCenter Server 89 Chapter 9: Getting Started with the vSphere Client 103 Part IV: Configuring and Connecting vSphere 111 Chapter 10: Configuring a New vCenter Server 113 Chapter 11: Wiring Up vSphere to the Network, Virtually 129 Chapter 12: Connecting vSphere to Shared Storage 149 Chapter 13: Assembling an ESX Cluster 171 Part V: Administering and Maintaining vSphere 181 Chapter 14: Creating, Cloning, and Converting VMs 183 Chapter 15: Organizing vSphere Resources 205 Chapter 16: Events, Alarms, and Monitoring 219 Chapter 17: A Quick Tour of Your Virtual Infrastructure 231 Chapter 18: One of These Hosts Is Not Like the Other — Host Profiles 241 Part VI: Tuning and Troubleshooting vSphere 259 Chapter 19: Making VMs Play Fair with Resource Pools 261 Chapter 20: Using vSphere Availability Features 271 Chapter 21: Troubleshooting vSphere 287 Part VII: The Part of Tens 301 Chapter 22: Ten Tools to Make vSphere Management Easier 303 Chapter 23: Ten Places to Improve Your vSphere Know-How 313 Chapter 24: Ten Pro Tips for a Successful vSphere Deployment 317 Index 323
£23.99
Pearson Education (US) Microsoft Excel Step by Step Office 2021 and
Book SynopsisJoan Lambert has worked closely with Microsoft technologies since 1986, and in the training and certification industry since 1997, guiding the translation of technical information and requirements into useful, relevant, and measurable resources for people seeking certification of their computer skills or who simply want to get things done efficiently. She has written more than 50 books about Windows, Office, and SharePoint technologies, including dozens of Step by Step books and five generations of Microsoft Office Specialist certification study guides. Students who use the GO! with Microsoft Office textbook products may overhear her cheerfully demonstrating Office features in the videos that accompany the series. Table of ContentsIntroduction Part 1: Create and format workbooks 1 Set up a workbook 2 Work with data and Excel tables 3 Perform calculations on data 4 Change workbook appearance Part 2: Analyze and present data 5 Manage worksheet data 6 Reorder and summarize data 7 Combine data from multiple sources 8 Analyze alternative data sets 9 Create charts and graphics. 207 10 Create PivotTables and PivotCharts Part 3: Collaborate and share in Excel 11 Print worksheets and charts 12 Automate tasks and input 13 Work with other Microsoft 365 apps 14 Collaborate with colleagues Part 4: Perform advanced analysis 15 Perform business intelligence analysis 16 Create forecasts and visualizations
£26.39
John Wiley & Sons Inc Excel 2019 Power Programming with VBA
Book SynopsisMaximize your Excel experience with VBA Excel 2019 Power Programming with VBAis fully updated to cover all the latest tools and tricks of Excel 2019. Encompassing an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA), this comprehensive book presents all of the techniques you need to develop both large and small Excel applications. Over 800 pages of tips, tricks, and best practices shed light on key topics, such as the Excel interface, file formats, enhanced interactivity with other Office applications, and improved collaboration features. Understanding how to leverage VBA to improve your Excel programming skills can enhance the quality of deliverables that you produceand can help you take your career to the next level. Explore fully updated content that offers comprehensive coverage through over 900 pages of tips, tricks, and techniquesLeverage templates and worksheets that put your new knowledge in action, and reinforce theTable of ContentsIntroduction xxxiii Part I: Introduction to Excel VBA 1 Chapter 1: Essentials of Spreadsheet Application Development 3 What Is a Spreadsheet Application? 3 Steps for Application Development 4 Determining User Needs 5 Planning an Application That Meets User Needs 6 Determining the Most Appropriate User Interface 7 Concerning Yourself with the End User 12 Other Development Issues 17 Chapter 2: Introducing Visual Basic for Applications 19 Getting a Head Start with the Macro Recorder 19 Working with the Visual Basic Editor 32 VBA Fundamentals 43 Deep Dive: Working with Range Objects 48 Essential Concepts to Remember 52 Don’t Panic–You Are Not Alone 54 Chapter 3: VBA Programming Fundamentals 61 VBA Language Elements: An Overview 61 Comments 63 Variables, Data Types, and Constants 65 Assignment Statements 76 Arrays 78 Declaring Arrays 78 Object Variables 80 User-Defined Data Types 81 Built-in Functions 82 Manipulating Objects and Collections 85 Controlling Code Execution 88 Chapter 4: Working with VBA Sub Procedures 105 About Procedures 105 Executing Sub Procedures 108 Passing Arguments to Procedures 119 Error-Handling Techniques 123 A Realistic Example That Uses Sub Procedures 127 Utility Availability 140 Evaluating the Project 141 Chapter 5: Creating Function Procedures 143 Sub Procedures vs. Function Procedures 143 Why Create Custom Functions? 144 An Introductory Function Example 144 Function Procedures 148 Function Arguments 153 Function Examples 153 Emulating Excel’s SUM Function 167 Extended Date Functions 170 Debugging Functions 172 Dealing with the Insert Function Dialog Box 173 Using Add-Ins to Store Custom Functions 178 Using the Windows API 178 Chapter 6: Understanding Excel’s Events 183 What You Should Know About Events 183 Getting Acquainted with Workbook-Level Events 189 Examining Worksheet Events 197 Monitoring with Application Events 206 Chapter 7: VBA Programming Examples and Techniques 217 Learning by Example 217 Working with Ranges 218 Working with Workbooks and Sheets 246 VBA Techniques 251 Some Useful Functions for Use in Your Code 258 Some Useful Worksheet Functions 263 Windows API Calls 278 Part II: Advanced VBA Techniques 287 Chapter 8: Working with Pivot Tables 289 An Introductory Pivot Table Example 289 Creating a More Complex Pivot Table 295 Creating Multiple Pivot Tables 299 Creating a Reverse Pivot Table 302 Chapter 9: Working with Charts 305 Getting the Inside Scoop on Charts 305 Creating an Embedded Chart 308 Creating a Chart on a Chart Sheet 309 Modifying Charts 309 Using VBA to Activate a Chart 310 Moving a Chart 311 Using VBA to Deactivate a Chart 312 Determining Whether a Chart Is Activated 313 Deleting from the ChartObjects or Charts Collection 313 Looping Through All Charts 314 Sizing and Aligning ChartObjects 317 Creating Lots of Charts 318 Exporting a Chart 321 Changing the Data Used in a Chart 322 Using VBA to Display Custom Data Labels on a Chart 328 Displaying a Chart in a UserForm 331 Understanding Chart Events 334 Discovering VBA Charting Tricks 340 Working with Sparkline Charts 347 Chapter 10: Interacting with Other Applications 351 Understanding Microsoft Office Automation 351 Automating Access from Excel 354 Automating Word from Excel 356 Automating PowerPoint from Excel 360 Automating Outlook from Excel 365 Starting Other Applications from Excel 369 Chapter 11: Working with External Data and Files 377 Working with External Data Connections 377 Power Query Basics 377 Using ADO and VBA to Pull External Data 390 Working with Text Files 397 Text File Manipulation Examples 401 Performing Common File Operations 405 Zipping and Unzipping Files 413 Part III: Working with UserForms 417 Chapter 12: Leveraging Custom Dialog Boxes 419 Alternatives to UserForms 419 Using an Input Box 419 Using the VBA MsgBox Function 426 Using the Excel GetOpenFilename Method 431 Using the Excel GetSaveAsFilename Method 434 Prompting for a Folder 435 Displaying Excel’s Built-in Dialog Boxes 435 Displaying a Data Form 438 Chapter 13: Introducing UserForms 441 How Excel Handles Custom Dialog Boxes 441 Inserting a New UserForm 442 Adding Controls to a UserForm 443 Toolbox Controls 443 Adjusting UserForm Controls 448 Adjusting a Control’s Properties 450 Displaying a UserForm 456 Closing a UserForm 458 Creating a UserForm: An Example 460 Referencing UserForm Controls 473 Customizing the Toolbox 474 Creating UserForm Templates 477 A UserForm Checklist 478 Chapter 14: Looking at UserForm Examples 479 Creating a UserForm “Menu” 479 Selecting Ranges from a UserForm 481 Creating a Splash Screen 483 Disabling a UserForm’s Close Button 486 Changing a UserForm’s Size 487 Zooming and Scrolling a Sheet from a UserForm 488 Exploring ListBox Techniques 490 Using the MultiPage Control in a UserForm 512 Using an External Control 513 Animating a Label 516 Chapter 15: Implementing Advanced UserForm Techniques 519 A Modeless Dialog Box 519 Displaying a Progress Indicator 523 Creating Wizards 534 Emulating the MsgBox Function 541 A UserForm with Movable Controls 545 A UserForm with No Title Bar 546 Simulating a Toolbar with a UserForm 548 Emulating a Task Pane with a UserForm 550 A Resizable UserForm 551 Handling Multiple UserForm Controls with One Event Handler 556 Selecting a Color in a UserForm 559 Displaying a Chart in a UserForm 561 Making a UserForm Semitransparent 562 A Puzzle on a UserForm 563 Video Poker on a UserForm 565 Part IV: Developing Excel Applications 567 Chapter 16: Creating and Using Add-Ins 569 What Is an Add-In? 569 Understanding Excel’s Add-in Manager 572 Creating an Add-In 574 An Add-In Example 575 Comparing XLAM and XLSM Files 581 Manipulating Add-Ins with VBA 587 Optimizing the Performance of Add-Ins 593 Special Problems with Add-Ins 594 Chapter 17: Working with the Ribbon 599 Ribbon Basics 599 Customizing the Ribbon 601 Creating a Custom Ribbon 606 Using VBA with the Ribbon 628 Creating an Old-Style Toolbar 632 Chapter 18: Working with Shortcut Menus 637 CommandBar Overview 637 Referring to Controls in a CommandBar 640 Properties of CommandBar Controls 641 Displaying All Shortcut Menu Items 642 Using VBA to Customize Shortcut Menus 644 Resetting a shortcut menu 646 Shortcut Menus and Events 654 Chapter 19: Providing Help for Your Applications 659 Help for Your Excel Applications 659 Help Systems That Use Excel Components 661 Displaying Help in a Web Browser 670 Using the HTML Help System 672 Chapter 20: Leveraging Class Modules 679 What Is a Class Module? 679 Creating a NumLock Class 681 Coding Properties, Methods, and Events 685 Exposing a QueryTable Event 688 Creating a Class to Hold Classes 692 Chapter 21: Understanding Compatibility Issues 699 What Is Compatibility? 699 Types of Compatibility Problems 699 Avoid Using New Features 701 But Will It Work on a Mac? 703 Dealing with 64-Bit Excel 704 Creating an International Application 705 Multilanguage Applications 707 VBA Language Considerations 708 Using Local Properties 708 Identifying System Settings 709 Date and Time Settings 711 Part V: Appendix 713 Appendix: VBA Statements and Functions Reference 715 Index 725
£36.00
Manning Publications Architecture Modernization: Socio-Technical
Book SynopsisAbout the Author: Adam Freeman is an experienced IT professional who started his career as a programmer. He has held senior positions in a range of companies, most recently serving as Chief Technology Officer and Chief Operating Officer of a global bank. He has written 49 programming books, focusing mostly on web application development. This industry-leading guide to ASP.NET Core teaches you everything they need to know to create easy, extensible, and cloud-native web applications. For .NET web developers looking to learn about ASP.NET s key tools and techniques.
£35.09
John Wiley & Sons Inc GarageBand For Dummies
Book SynopsisTable of ContentsIntroduction 1 Part 1: Starting on a Good Note 5 Chapter 1: Introducing GarageBand for Macs and iDevices 7 Chapter 2: Equipping and Setting Up Your Recording Space 25 Chapter 3: Introducing Multitrack Recording with GarageBand 49 Part 2: Making Music on a Mac 77 Chapter 4: Getting Started 79 Chapter 5: Using Loops to Make Music 93 Chapter 6: Recording with MIDI and Software Instruments 113 Chapter 7: Recording Vocals and Acoustic Instruments with a Mic 139 Chapter 8: Recording Electric Guitars and Other Electronic Instruments 159 Part 3: Postproduction: Finishing Songs on a Mac 175 Chapter 9: Editing and Polishing Tracks 177 Chapter 10: Mixing Tracks into Songs 203 Chapter 11: Mastering Mastering 217 Part 4: Making Music with Your iDevice 229 Chapter 12: Getting Started 231 Chapter 13: Making Music with Live Loops 247 Chapter 14: Laying Down Software Instrument Tracks 263 Chapter 15: Recording Vocals and Acoustic Instruments with a Mic 279 Chapter 16: Recording Guitars and Basses 297 Part 5: Postproduction: Finishing Songs on an iDevice 313 Chapter 17: Editing and Polishing Tracks 315 Chapter 18: Mixing Tracks into Songs 333 Chapter 19: Mastering Mastering 347 Chapter 20: File Compression and Your Music 353 Part 6: The Part of Tens 365 Chapter 21: Ten Ways to Improve GarageBand’s Performance 367 Chapter 22: Ten Ways to Take Your Recordings to the Next Level 377 Chapter 23: Ten Useful Websites 385 Index 391
£18.39
John Wiley & Sons Inc Presentation Secrets
Book SynopsisPlan, create, and deliver amazing presentations! Alexei Kapterev's online presentation on presentations has seen more than one million views, all with no advertising or promotion.Trade ReviewA very likable book. It s lavishly illustrated with colour images explaining the art of giving speeches and presentations. (The Speech Writers Guild, January 2012)Table of ContentsRead This First xiii Chapter 1 3 What Is Presentation? 1 What Are Presentations? 2 Story 4 Slides 7 Delivery 13 The Three Principles of Presenting 14 Summary 22 Part I 3 Story 23 Chapter 2 3 The Story’s Focus 25 Not All Stories Are Created Equal 26 Focusing on One Idea 26 Setting the Goal 27 The Customer Isn’t Always Right 35 Gathering the Material 39 Inventing the Truth 47 Can You Sell Without Lying? 47 Summary 48 Chapter 3 3 The Story’s Contrast 51 Problems and Solutions 52 Hero and Villain 63 Summary 73 Chapter 4 3 The Story’s Unity 75 Making Your Story Unified 76 Case Study: The Story of Tomato Sauce 80 The Problem of Balance 82 Case Study: A Company Introduction 99 Summary 101 Part I I 3 Slides 103 Chapter 5 3 The Slides’ Focus 105 Producing Your Slides 106 Zen and Vajrayana 107 Designing Zen Slides 113 Summary 131 Chapter 6 3 The Slides’ Contrast 133 Energizing Lifeless Diagrams 134 Using Comparisons 136 Data Visualization 144 Lies, Damned Lies, and Statistics 155 A Word on Animation 159 Where to Go Next?—Visualization Resources 161 Summary 162 Chapter 7 3 The Slides’ Unity 163 Avoiding Ugly Slides 164 Slide Design for Non-Designers 165 Working with Pictures 188 United World in a Slide Deck 191 Summary 195 Part I I I 3 Delivery 197 Chapter 8 3 Focus in Delivery 199 What Should You Focus on During Delivery? 200 Clarity 202 Pace 205 Voice 207 Engaging with Your Audience 208 Making Eye Contact 212 Addressing Any Questions 218 Using Humor (or Not?) 218 Summary 220 Chapter 9 3 Contrast in Delivery 221 The Opposite of Monotony 222 Being Perfect Versus Being Passionate 223 Don’t Avoid Confrontation 226 Learning from Other People 232 Summary 241 Chapter 10 3 Unity in Delivery 243 Going with the Flow 244 The Pros and Cons of Improvisation 247 Relaxing Control 251 Summary 263 Chapter 11 3 Where to Go Next 265 Presentation Checklist 266 Taking Further Steps 269 General Presentation Resources 269 Storytelling Resources 270 Slide Resources 273 Delivery Resources 275 Presentations Transform 277 Index 279
£21.59
John Wiley & Sons Inc Infographics for Dummies
Book SynopsisCreate stunning infographics with this hands-on guide Infographics For Dummies is a comprehensive guide to creating data visualization with viral appeal.Table of ContentsIntroduction 1 Part I: Getting Started with Infographics 5 Chapter 1: Unlocking the Power of Infographics 7 Chapter 2: Exploring Infographics 19 Chapter 3: Designing Your Approach to Infographics 35 Part II: Starting with Data 57 Chapter 4: Informing Yourself 59 Chapter 5: Gathering Your Data 77 Chapter 6: Discovering the Story 93 Part III: Depicting with Delightful Design 115 Chapter 7: Creating Wireframes and Managing Mood Boards 117 Chapter 8: Designing Around a Theme 135 Chapter 9: Designing Infographics in Adobe Illustrator 153 Chapter 10: Designing Infographics in Photoshop 193 Chapter 11: Expanding Your Tools and Techniques 225 Part IV: Ready to Distribute 241 Chapter 12: Launching Your Infographic 243 Chapter 13: Promoting Your Infographic 255 Part V: The Part of Tens 273 Chapter 14: Ten Infographics Trends to Follow 275 Chapter 15: Ten Future Infographic Uses to Try Today 283 Index 291
£19.79
John Wiley & Sons Inc OneNote 2013 For Dummies
Book SynopsisA quick guide to using Microsoft OneNote on tablets, online, or on your desktop OneNote is the note-taking-and-sharing application that's part of Microsoft Office. It lets you create notes by hand, as audio, or by clipping items from other electronic formats to create a file that can be indexed and searched.Table of ContentsIntroduction 1 Part I: Getting Started with OneNote 2013 5 Chapter 1: OneNote Basics 7 Chapter 2: Managing Notes and Configuring OneNote 23 Chapter 3: Formatting Notes 41 Chapter 4: Inserting External Data and Taking Quick Notes 59 Chapter 5: Securing and Managing Notes with SkyDrive 77 Part II: Taking Notes via Other OneNote Versions 89 Chapter 6: Taking Notes with OneNote for Windows 8 91 Chapter 7: Taking Notes on Android Devices 107 Chapter 8: Taking Notes on iOS Devices 121 Chapter 9: Managing and Taking Notes with OneNote Web App 131 Part III: Putting OneNote Through Its Paces 141 Chapter 10: Sharing and Collaborating with OneNote 143 Chapter 11: Taking Notes in the Real World 155 Part IV: The Part of Tens 171 Chapter 12: Ten (or So) Resources and Add-Ins for OneNote 173 Chapter 13: Ten Killer Tips for OneNote 179 Index 185
£15.29
John Wiley & Sons Inc NetSuite For Dummies
Book SynopsisNetSuite is an easy-to-use, customizable enterprise software for running your business. Part I explains NetSuite basics everyone should know. Part II focuses on tracking money (accounting, AR, AP, and managing inventory). Parts III, IV, and V explain how to sell and market your products, take care of customers, and sell goods online with NetSuite.Table of ContentsIntroduction. Part I: NetSuite Basics. Chapter 1: Peeking Under the NetSuite Hood. Chapter 2: Tailoring NetSuite to Your Company. Chapter 3: Personalizing Your Suite. Chapter 4: Grabbing Hold of the Dashboard. Part II: Tracking Money and Resources. Chapter 5: Bookkeeping Basics. Chapter 6: Invoicing Customers and Paying the Bills. Chapter 7: Managing Inventory. Part III: Marketing and Driving Sales. Chapter 8: Building a Campaign: Marketing Automation. Chapter 9 : Setting Up Sales Force Automation. Chapter 10: Turning Leads into Customers. Part IV: Taking Care of Your Partners and Customers. Chapter 11: Delivering the Goods: Fulfi llment and Shipping. Chapter 12: Managing Projects. Chapter 13: Providing Excellent Customer Service. Part V: Selling Online. Chapter 14: Planning Your Web Site. Chapter 15: Adding Content to Your Site. Chapter 16: Making Your Site Look Great. Chapter 17: Let the Shopping Begin. Chapter 18: Fine-Tuning Your Site. Part VI: Dashboards, Searches, and Analytics. Chapter 19: Realizing the Power of Saved Searches. Chapter 20: Exposing Metrics on Your Dashboard. Chapter 21: Reporting and Analytics. Part VII: The Part of Tens. Chapter 22: Ten-Plus Key Differentiators. Chapter 23: Ten Tips for a Successful Implementation. Chapter 24: Ten Frequently Asked Questions. Bonus Chapters on the Companion Web Site.... On the Web. Bonus Chapter 1: Managing Partner Relationships. Bonus Chapter 2: Hosting Your Site. Bonus Chapter 3: Integrating an External Site. Bonus Chapter 4: Creating Custom Fields, Tabs, and Tables. Bonus Chapter 5: Writing Your Own Ticket with SuiteScript. Bonus Chapter 6: Securing Your NetSuite Account. Bonus Chapter 7: Exploring Advanced Topics. http://www.dummies.com/go/netsuitefd Index.
£17.59
John Wiley & Sons Inc Statistical Data Cleaning with Applications in R
Book SynopsisTable of ContentsForeword xi About the Companion Website xiii 1 Data Cleaning 1 1.1 The Statistical Value Chain 1 1.1.1 Raw Data 2 1.1.2 Input Data 2 1.1.3 Valid Data 3 1.1.4 Statistics 3 1.1.5 Output 3 1.2 Notation and Conventions Used in this Book 3 2 A Brief Introduction to R 5 2.1 R on the Command Line 5 2.1.1 Getting Help and Learning R 6 2.2 Vectors 7 2.2.1 Computing with Vectors 9 2.2.2 Arrays and Matrices 10 2.3 Data Frames 11 2.3.1 The Formula-Data Interface 12 2.3.2 Selecting Rows and Columns; Boolean Operators 12 2.3.3 Selection with Indices 13 2.3.4 Data Frame Manipulation:The dplyr Package 14 2.4 Special Values 15 2.4.1 Missing Values 17 2.5 Getting Data into and out of R 18 2.5.1 File Paths in R 19 2.5.2 Formats Provided by Packages 20 2.5.3 Reading Data from a Database 20 2.5.4 Working with Data External to R 21 2.6 Functions 21 2.6.1 Using Functions 22 2.6.2 Writing Functions 22 2.7 Packages Used in this Book 23 3 Technical Representation of Data 27 3.1 Numeric Data 28 3.1.1 Integers 28 3.1.2 Integers in R 30 3.1.3 Real Numbers 31 3.1.4 Double Precision Numbers 31 3.1.5 The Concept of Machine Precision 33 3.1.6 Consequences ofWorking with Floating Point Numbers 34 3.1.7 Dealing with the Consequences 35 3.1.8 Numeric Data in R 37 3.2 Text Data 38 3.2.1 Terminology and Encodings 38 3.2.2 Unicode 39 3.2.3 Some Popular Encodings 40 3.2.4 Textual Data in R: Objects of Class Character 43 3.2.5 Encoding in R 44 3.2.6 Reading andWriting of Data with Non-Local Encoding 46 3.2.7 Detecting Encoding 48 3.2.8 Collation and Sorting 49 3.3 Times and Dates 50 3.3.1 AIT, UTC, and POSIX Seconds Since the Epcoch 50 3.3.2 Time and Date Notation 52 3.3.3 Time and Date Storage in R 54 3.3.4 Time and Date Conversion in R 55 3.3.5 Leap Days, Time Zones, and Daylight Saving Times 57 3.4 Notes on Locale Settings 58 4 Data Structure 61 4.1 Introduction 61 4.2 Tabular Data 61 4.2.1 data.frame 61 4.2.2 Databases 62 4.2.3 dplyr 64 4.3 Matrix Data 65 4.4 Time Series 66 4.5 Graph Data 68 4.6 Web Data 69 4.6.1 Web Scraping 69 4.6.2 Web API 70 4.7 Other Data 72 4.8 Tidying Tabular Data 72 4.8.1 Variable Per Column 74 4.8.2 Single Observation Stored in Multiple Tables 75 5 Cleaning Text Data 77 5.1 Character Normalization 78 5.1.1 Encoding Conversion and Unicode Normalization 78 5.1.2 Character Conversion and Transliteration 80 5.2 Pattern Matching with Regular Expressions 81 5.2.1 Basic Regular Expressions 82 5.2.2 Practical Regular Expressions 85 5.2.3 Generating Regular Expressions in R 92 5.3 Common String Processing Tasks in R 93 5.4 Approximate Text Matching 98 5.4.1 String Metrics 100 5.4.2 String Metrics and Approximate Text Matching in R 109 6 Data Validation 119 6.1 Introduction 119 6.2 A First Look at the validate Package 120 6.2.1 Quick Checks with check_that 120 6.2.2 The BasicWorkflow: validator and confront 122 6.2.3 A Little Background on validate and DSLs 124 6.3 Defining Data Validation 125 6.3.1 Formal Definition of Data Validation 126 6.3.2 Operations on Validation Functions 128 6.3.3 Validation and Missing Values 130 6.3.4 Structure of Validation Functions 131 6.3.5 Demarcating Validation Rules in validate 132 6.4 A Formal Typology of Data Validation Functions 134 6.4.1 A Closer Look at Measurement 134 6.4.2 Classification of Validation Rules 135 6.5 Validating Data with the validate Package 137 6.5.1 Validation Rules in the Console and the validator Object 137 6.5.2 Validating in the Pipeline 139 6.5.3 Raising Errors orWarnings 140 6.5.4 Tolerance for Testing Linear Equalities 140 6.5.5 Setting and Resetting Options 141 6.5.6 Importing and Exporting Validation Rules from and to File 142 6.5.7 Checking Variable Types and Metadata 145 6.5.8 Checking Value Ranges and Code Lists 146 6.5.9 Checking In-Record Consistency Rules 146 6.5.10 Checking Cross-Record Validation Rules 148 6.5.11 Checking Functional Dependencies 149 6.5.12 Cross-Dataset Validation 150 6.5.13 Macros, Variable Groups, Keys 152 6.5.14 Analyzing Output: validation Objects 152 6.5.15 Output Dimensionality and Output Selection 155 7 Localizing Errors in Data Records 157 7.1 Error Localization 157 7.2 Error Localization with R 160 7.2.1 The Errorlocate Package 160 7.3 Error Localization as MIP-Problem 163 7.3.1 Error Localization and Mixed-Integer Programming 163 7.3.2 Linear Restrictions 164 7.3.3 Categorical Restrictions 165 7.3.4 Mixed-Type Restrictions 167 7.4 Numerical Stability Issues 170 7.4.1 A Short Overview of MIP Solving 170 7.4.2 Scaling Numerical Records 172 7.4.3 Setting NumericalThreshold Values 173 7.5 Practical Issues 174 7.5.1 Setting ReliabilityWeights 174 7.5.2 Simplifying Conditional Validation Rules 176 7.6 Conclusion 180 8 Rule Set Maintenance and Simplification 183 8.1 Quality of Validation Rules 183 8.1.1 Completeness 183 8.1.2 Superfluous Rules and Infeasibility 184 8.2 Rules in the Language of Logic 184 8.2.1 Using Logic to Rewrite Rules 185 8.3 Rule Set Issues 186 8.3.1 Infeasible Rule Set 186 8.3.2 Fixed Value 187 8.3.3 Redundant Rule 188 8.3.4 Nonrelaxing Clause 189 8.3.5 Nonconstraining Clause 189 8.4 Detection and Simplification Procedure 190 8.4.1 Mixed-Integer Programming 190 8.4.2 Detecting Feasibility 191 8.4.3 Finding Rules Causing Infeasibility 191 8.4.4 Detecting Conflicting Rules 191 8.4.5 Detect Partial Infeasibility 192 8.4.6 Detect Fixed Values 192 8.4.7 Detect Nonrelaxing Clauses 192 8.4.8 Detecting Nonconstraining Clauses 193 8.4.9 Detecting Redundant Rules 193 8.5 Conclusion 194 9 Methods Based on Models for Domain Knowledge 195 9.1 Correction with Data Modifying Rules 195 9.1.1 Modifying Functions 196 9.1.2 A Class of Modifying Functions on Numerical Data 201 9.2 Rule-Based Correction with dcmodify 205 9.2.1 Reading Rules from File 206 9.2.2 Modifying Rule Syntax 207 9.2.3 Missing Values 208 9.2.4 Sequential and Sequence-Independent Execution 208 9.2.5 Options Settings Management 209 9.3 Deductive Correction 209 9.3.1 Correcting Typing Errors in Numeric Data 209 9.3.2 Deductive Imputation Using Linear Restrictions 213 10 Imputation and Adjustment 219 10.1 Missing Data 219 10.1.1 Missing Data Mechanisms 219 10.1.2 Visualizing and Testing for Patterns in Missing Data Using R 220 10.2 Model-Based Imputation 224 10.3 Model-Based Imputation in R 226 10.3.1 Specifying ImputationMethods with simputation 226 10.3.2 Linear Regression-Based Imputation 227 10.3.3 M-Estimation 230 10.3.4 Lasso, Ridge, and Elasticnet Regression 231 10.3.5 Classification and Regression Trees 232 10.3.6 Random Forest 235 10.4 Donor Imputation with R 236 10.4.1 Random and Sequential Hot Deck Imputation 237 10.4.2 k Nearest Neighbors and Predictive Mean Matching 238 10.5 Other Methods in the simputation Package 239 10.6 Imputation Based on the EM Algorithm 240 10.6.1 The EM Algorithm 241 10.6.2 EM Imputation Assuming the Multivariate Normal Distribution 243 10.7 Sampling Variance under Imputation 244 10.8 Multiple Imputations 246 10.8.1 Multiple Imputation Based on the EM Algorithm 248 10.8.2 The Amelia Package 249 10.8.3 Multivariate Imputation with Chained Equations (Mice) 252 10.8.4 Imputation with the mice Package 254 10.9 Analytic Approaches to Estimate Variance of Imputation 256 10.9.1 Imputation as Part of the Estimator 256 10.10 Choosing an ImputationMethod 257 10.11 Constraint Value Adjustment 259 10.11.1 Formal Description 259 10.11.2 Application to Imputed Data 262 10.11.3 Adjusting Imputed Values with the rspa Package 263 11 Example: A Small Data-Cleaning System 265 11.1 Setup 266 11.1.1 DeterministicMethods 266 11.1.2 Error Localization 269 11.1.3 Imputation 269 11.1.4 Adjusting Imputed Data 271 11.2 Monitoring Changes in Data 273 11.2.1 Data Diff (Daff) 274 11.2.2 Summarizing Cell Changes 275 11.2.3 Summarizing Changes in Conformance to Validation Rules 277 11.2.4 Track Changes in Data Automatically with lumberjack 278 11.3 Integration and Automation 282 11.3.1 Using RScript 283 11.3.2 The docopt Package 283 11.3.3 Automated Data Cleaning 285 References 287 Index 297
£59.36
John Wiley & Sons Inc Adobe Premiere Pro For Dummies
Book SynopsisAn essential resource for anyone who wants to get up and running with this popular video-editing application, from amateur and hobbyist filmmakers to professionals who want to explore the possibilities of editing on a PC.Table of ContentsIntroduction. Part I: Introducing Adobe Premiere Pro. Chapter 1: Getting to Know Premiere Pro. Chapter 2: Setting Up Your Production Studio. Chapter 3: Getting Premiere Pro Ready to Work. Part II: Gathering Footage. Chapter 4: A Crash Course in Video Production. Chapter 5: Starting and Managing Your Movie Projects. Chapter 6: Capturing, Importing, and Managing Media. Part III: Editing in Premiere Pro. Chapter 7: Editing Clips. Chapter 8: Working with the Timeline. Chapter 9: Transitioning Between Clips. Chapter 10: Improving Your Video Images. Chapter 11: Compositing and Animating Clips. Chapter 12: Affecting Effects in Your Movies. Chapter 13: Working with Audio. Chapter 14: Giving Credit with Titles. Part IV: Wrapping Up Your Project. Chapter 15: Finalizing the Project. Chapter 16: Sending Your Project to the World Wide Web. Chapter 17: Exporting Your Movie to Tape. Chapter 18: Recording DVDs. Part V: The Part of Tens. Chapter 19: Ten Movie-Making Tips and Tricks. Chapter 20: Ten Essential Software Add-Ons for Adobe Premiere. Chapter 21: Ten Tools (and Toys) for Your Production Studio. Part VI: Appendix. Appendix. Index.
£20.79
John Wiley & Sons Inc Cloud Computing Bible
Book SynopsisThe complete reference guide to the hot technology of cloud computing Its potential for lowering IT costs makes cloud computing a major force for both IT vendors and users; it is expected to gain momentum rapidly with the launch of Office Web Apps later this year.Table of ContentsPreface xi Acknowledgments xiii Part I: Examining the Value Proposition 1 Chapter 1: Defining Cloud Computing 3 Chapter 2: Assessing the Value Proposition 23 Chapter 3: Understanding Cloud Architecture 45 Chapter 4: Understanding Services and Applications by Type 65 Part II: Using Platforms 91 Chapter 5: Understanding Abstraction and Virtualization 93 Chapter 6: Capacity Planning 113 Chapter 7: Exploring Platform as a Service 133 Chapter 8: Using Google Web Services 151 Chapter 9: Using Amazon Web Services 179 Chapter 10: Using Microsoft Cloud Services 205 Part III: Exploring Cloud Infrastructures. 229 Chapter 11: Managing the Cloud 231 Chapter 12: Understanding Cloud Security 249 Part IV: Understanding Services and Applications 269 Chapter 13: Understanding Service Oriented Architecture 271 Chapter 14: Moving Applications to the Cloud 297 Chapter 15: Working with Cloud-Based Storage 311 Chapter 16: Working with Productivity Software 339 Chapter 17: Using Webmail Services 361 Chapter 18: Communicating with the Cloud 383 Chapter 19: Using Media and Streaming 403 Part V: Using the Mobile Cloud 423 Chapter 20: Working with Mobile Devices 425 Chapter 21: Working with Mobile Web Services 445
£27.00
John Wiley & Sons Inc Blender For Dummies
Book SynopsisMake your 3D world a reality Some of the dramatic visual effects you''ve seen in top-grossing movies and heralded television series got their start in Blender. This book helps you get your own start in creating three-dimensional characters, scenes, and animations in the popular free and open-source tool. Author Jason van Gumster shares his insight as an independent animator and digital artist to help Blender newcomers turn their ideas into three-dimensional drawings. From exporting and sharing scenes to becoming a part of the Blender community, this accessible book covers it all! Create 3D charactersno experience required Build scenes with texture and real lighting features Animate your creations and share them with the world Avoid common rookie mistakes This book is the ideal starting place for newcomers to the world of 3D modeling and animation. Table of ContentsIntroduction 1 About This Book 2 Foolish Assumptions 2 Icons Used in This Book 4 Beyond the Book 4 Where to Go from Here 5 Part 1: Wrapping Your Brain Around Blender 7 Chapter 1: Discovering Blender 9 Getting to Know Blender 10 Discovering Blender’s origins and the strength of the Blender community 11 Making open movies and games 12 Getting to Know the Interface 15 Working with an interface that stays out of your way 17 Resizing areas 19 Maximizing an area 20 The menu that is a pie 22 Chapter 2: Understanding How Blender Thinks 25 Looking at Editor Types 25 General editors 26 Animation editors 28 Scripting editors 29 Data editors 29 Understanding the Properties editor 30 Navigating in Three Dimensions 32 Orbiting, panning, and zooming the 3D Viewport 32 Changing views 35 Selecting objects 40 Taking advantage of the 3D cursor 40 Extra Features in the 3D Viewport 44 Quad View 44 Regions 45 Collaborating (with others and yourself) with annotations 48 Don’t know how to do something? Hooray for fully Integrated search! 49 Customizing Blender to Fit You 50 Using preset workspaces 51 Blender workflows 55 Setting user preferences 57 Using custom event maps 58 Speeding up your workflow with Quick Favorites 61 Chapter 3: Getting Your Hands Dirty Working in Blender 63 Grabbing, Scaling, and Rotating 64 Differentiating Between Coordinate Systems 64 Transforming an Object by Using Object Gizmos 67 Activating object gizmos 68 Using object gizmos 69 Saving Time by Using Hotkeys 72 Transforming with hotkeys 73 Hotkeys and coordinate systems 73 Numerical input 76 The Sidebar 76 Chapter 4: Working in Edit Mode and Object Mode 77 Making Changes by Using Edit Mode 77 Switching between Object mode and Edit mode 78 Selecting vertices, edges, and faces 79 Working with linked vertices 84 Still Blender’s No 1 modeling tool: Extrude 85 Adding to a Scene 90 Adding objects 90 Meet Suzanne, the Blender monke 92 Joining and separating objects 93 Creating duplicates and links 95 Discovering parents, children, and collections 101 Saving, opening, and appending 108 Part 2: Creating Detailed 3D Scenes 111 Chapter 5: Creating Anything You Can Imagine with Meshes 113 Pushing Vertices 114 Getting familiar with Edit mode tools 116 Adding geometry by insetting 117 Cutting edges with the Knife 122 Rounding your corners by beveling 126 Spiraling new geometry into existence with the Spin tool 130 Working with Loops and Rings 131 Understanding edge loops and face loops 132 Selecting edge rings 134 Creating new loops 135 Simplifying Your Life as a Modeler with Modifiers 137 Understanding modifier types 140 Doing half the work (and still looking good!) with the Mirror modifier 147 Smoothing things out with the Subdivision Surface modifier 149 Using the power of Arrays 153 Chapter 6: Sculpting in Virtual Space 157 Adding Background Images in the 3D Viewport 158 Mastering the types of image objects 159 Changing image object properties 160 Adjusting your image objects 162 Setting Up Your Sculpting Workspace 163 Sculpting a Mesh Object 166 Understanding sculpt tool types 166 Tweaking brush properties 173 Refining control of your tools 174 Creating custom brushes 176 Using Blender’s texture system to tweak brushes 176 Sculpting with the Multiresolution modifier 177 Freeform Sculpting with Dynamic Topology (Dyntopo) 180 Understanding the Basics of Retopology 184 Chapter 7: Using Blender’s Non-Mesh Primitives 189 Using Curves and Surfaces 190 Understanding the different types of curves 192 Working with curves 193 Understanding the strengths and limitations of Blender’s Surfaces 212 Using Metaball Objects 213 Meta-wha? 214 What metaball objects are useful for 217 Adding Text 217 Adding and editing text 218 Controlling text appearance 219 Deforming text with a curve 227 Converting to curves and meshes 228 Chapter 8: Changing That Boring Gray Default Material 229 Understanding Materials and Render Engines 230 Quick ’n’ Dirty Coloring 233 Setting diffuse colors 233 Assigning multiple materials to different parts of a mesh 235 Using vertex colors 240 Setting Up Node Materials 247 Adjusting your workspace to work with materials 248 Working with nodes 249 Understanding shaders 250 Playing with Materials in Blender 251 Demystifying the Principled BSDF 252 Combining shaders with the Mix Shader node 258 Playing with the Shader to RGB node 263 Chapter 9: Giving Models Texture 267 Adding Textures 267 Using Procedural Textures 268 Understanding Texture Mapping 272 Making simple adjustments with the Texture Mapping panel 272 Using texture coordinates 273 Understanding Object coordinates and the UV Project modifier 278 Unwrapping a Mesh 281 Marking seams on a mesh 282 Adding a test grid 283 Generating and editing UV coordinates 284 Painting Textures Directly on a Mesh 287 Preparing to paint 288 Working in Texture Paint mode 290 Using textures on your Draw tool 292 Saving Painted Textures and Exporting UV Layouts 295 Chapter 10: Lighting and Environment 297 Lighting a Scene 297 Understanding a basic three-point lighting setup 298 Knowing when to use which type of light 301 Lighting for Speedy Renders 317 Working with three-point lighting in Blender 318 Using Look Dev to set up lighting 318 Setting Up the World 320 Changing the sky to something other than dull gray 320 Understanding ambient occlusion 325 Working with Light Probes in Eevee 328 Baking from your light probes 330 Understanding the limitations of light probes 332 Part 3: Get Animated! 333 Chapter 11: Animating Objects 335 Working with Animation Curves 336 Customizing your screen layout for Animation 338 Inserting keys 340 Working with keying sets 345 Working in the Graph Editor 351 Editing motion curves 352 Using Constraints Effectively 356 The all-powerful Empty! 357 Adjusting the influence of a constraint 360 Using vertex groups in constraints 361 Copying the movement of another object 361 Putting limits on an object 363 Tracking the motion of another object 365 Chapter 12: Rigging: The Art of Building an Animatable Puppet 367 Creating Shape Keys 368 Creating new shapes 368 Mixing shapes 370 Knowing where shape keys are helpful 372 Adding Hooks 373 Creating new hooks 373 Knowing where hooks are helpful 375 Using Armatures: Skeletons in the Mesh 375 Editing armatures 376 Putting skin on your skeleton 390 Bringing It All Together to Rig a Character 396 Building Stickman’s centerline 396 Adding Stickman’s appendages 397 Taking advantage of parenting and constraints 400 Comparing inverse kinematics and forward kinematics 403 Making the rig more user friendly 407 Chapter 13: Animating Object Deformations 411 Working with the Dope Sheet 411 Selecting keys in the Dope Sheet 412 Working with markers 415 Recognizing different kinds of keyframe indicators 416 Animating with Armatures 418 Principles of animation worth remembering 420 Making sense of quaternions (or, “Why are there four rotation curves?!”) 423 Copying mirrored poses 424 Doing Nonlinear Animation 425 Working with actions 426 Mixing actions to create complex animation 429 Taking advantage of looped animation 430 Chapter 14: Letting Blender Do the Work for You 433 Using Particles in Blender 435 Knowing what particle systems are good for 436 Using force fields and collisions 440 Using particles for hair and fur 442 Giving Objects Some Jiggle and Bounce 446 Dropping Objects in a Scene with Rigid Body Dynamics 449 Simulating Cloth 450 Splashing Fluids in Your Scene 452 Smoking without Hurting Your Lungs: Smoke Simulation in Blender 457 Creating a smoke simulation 457 Rendering smoke 458 Chapter 15: Making 2D and 2.5D Animation with Grease Pencil 461 Getting Started with the 2D Animation Workspace 462 Working with Grease Pencil tools 464 Drawing with Grease Pencil 465 Sculpting Grease Pencil objects 470 Editing Grease Pencil objects 472 Understanding Grease Pencil Materials 473 Mastering Grease Pencil Layers 478 Automating Your Drawings with Grease Pencil Modifiers 482 Animating with Grease Pencil 488 Using a hand-drawn animation workflow with Grease Pencil objects 488 Rigging Grease Pencil objects for animation 492 Integrating Grease Pencil with a 3D Scene 495 Part 4: Sharing Your Work with the World 497 Chapter 16: Exporting and Rendering Scenes 499 Exporting to External Formats 499 Rendering a Scene 502 Creating a still image 502 Creating a sequence of still images for editing or compositing 509 Chapter 17: Editing Video and Animation 513 Comparing Editing to Compositing 514 Working with the Video Sequencer 514 Adding and editing strips 518 Adding effects and transitions 525 Rendering from the Video Sequencer 527 Chapter 18: Compositing Images and Video 531 Understanding Nodes 531 Getting Started with the Compositor 534 Rendering in Passes and Layers 535 Discovering Passes Available in Eevee and Cycles 536 Understanding Cycles-only Light Passes 540 Meet Cryptomatte 542 Working with Nodes 544 Configuring the backdrop 545 Identifying Parts of a Node 547 Navigating the Compositor 548 Adding nodes to your compositing network 549 Grouping nodes together 550 Discovering the Nodes Available to You 550 Rendering from the Compositor 552 Chapter 19: Mixing Video and 3D with Motion Tracking 553 Making Your Life Easier by Starting with Good Video 554 Knowing your camera 554 Keeping your lighting consistent 556 Having images in good focus 557 Understanding the scene 558 Getting Familiar with the Motion Tracking Workspace 559 Tracking Movement in Blender 561 Adding markers and tracking 563 Solving camera motion from tracker data 569 Setting up your scene for integrating with your video footage 573 Where to Go from Here 575 Part 5: the Part of Tens 577 Chapter 20: Ten Tips for Working More Effectively in Blender 579 Use Tooltips and Integrated Search 579 Take Advantage of the Quick Favorites Menu 580 Look at Models from Different Views 580 Don’t Forget about Add-ons 582 Lock a Camera to an Animated Character 582 Name Everything 583 Do Low-Resolution Test Renders 583 Use Annotations to Plan 586 Ask for Help 586 Have Fun, but Take Breaks 587 Chapter 21: Ten Excellent Community Resources 589 Blender org 589 Blender ID 590 Blender manual 590 Developer blog 590 Bug reporting and developer discussions 590 builder blender org 591 Blender Cloud 592 BlenderArtists org 592 BlenderNation 592 BlenderBasics com 593 Blender Stackexchange com 593 CGCookie com 593 Blend Swap (blendswap com) 593 Blender community 594 Blender Today 594 Right-Click Select 594 Blender NPR 595 Social Media 595 Blender chat 596 Index 597
£26.39
John Wiley & Sons Inc Excel Power Pivot Power Query For Dummies
Book SynopsisTable of ContentsIntroduction 1 About This Book 2 Foolish Assumptions 3 Icons Used in This Book 3 Beyond the Book 4 Where to Go from Here 4 Part 1: Supercharged Reporting with Power Pivot 5 Chapter 1: Thinking Like a Database 7 Exploring the Limits of Excel and How Databases Help 7 Scalability 8 Transparency of analytical processes 9 Separation of data and presentation 10 Getting to Know Database Terminology 11 Databases 11 Tables 11 Records, fields, and values 12 Queries 13 Understanding Relationships 13 Chapter 2: Introducing Power Pivot 17 Understanding the Power Pivot Internal Data Model 18 Linking Excel Tables to Power Pivot 20 Preparing Excel tables 21 Adding Excel Tables to the data model 22 Creating relationships between Power Pivot tables 24 Managing existing relationships 26 Using the Power Pivot data model in reporting 27 Chapter 3: The Pivotal Pivot Table 29 Introducing the Pivot Table 30 Defining the Four Areas of a Pivot Table 30 Values area 30 Row area 31 Column area 31 Filter area 32 Creating Your First Pivot Table 33 Changing and rearranging a pivot table 36 Adding a report filter 37 Keeping the pivot table fresh 38 Customizing Pivot Table Reports 40 Changing the pivot table layout 40 Customizing field names 41 Applying numeric formats to data fields 42 Changing summary calculations 43 Suppressing subtotals 44 Showing and hiding data items 47 Hiding or showing items without data 49 Sorting the pivot table 51 Understanding Slicers 52 Creating a Standard Slicer 54 Getting Fancy with Slicer Customizations 56 Size and placement 56 Data item columns 57 Miscellaneous slicer settings 58 Controlling Multiple Pivot Tables with One Slicer 58 Creating a Timeline Slicer 59 Chapter 4: Using External Data with Power Pivot 63 Loading Data from Relational Databases 64 Loading data from SQL Server 64 Loading data from Microsoft Access databases 70 Loading data from other relational database systems 72 Loading Data from Flat Files 75 Loading data from external Excel files 76 Loading data from text files 78 Loading data from the Clipboard 81 Loading Data from Other Data Sources 82 Refreshing and Managing External Data Connections 83 Manually refreshing Power Pivot data 83 Setting up automatic refreshing 84 Preventing Refresh All 85 Editing the data connection 86 Chapter 5: Working Directly with the Internal Data Model 89 Directly Feeding the Internal Data Model 89 Managing Relationships in the Internal Data Model 95 Managing Queries and Connections 96 Creating a New Pivot Table Using the Internal Data Model 97 Filling the Internal Data Model with Multiple External Data Tables 98 Chapter 6: Adding Formulas to Power Pivot 103 Enhancing Power Pivot Data with Calculated Columns 103 Creating your first calculated column 104 Formatting calculated columns 105 Referencing calculated columns in other calculations 106 Hiding calculated columns from end users 107 Utilizing DAX to Create Calculated Columns 108 Identifying DAX functions that are safe for calculated columns 108 Building DAX-driven calculated columns 110 Month sorting in Power Pivot–driven pivot tables 112 Referencing fields from other tables 113 Nesting functions 115 Understanding Calculated Measures 116 Creating a calculated measure 116 Editing and deleting calculated measures 118 Free Your Data with Cube Functions 119 Chapter 7: Diving into DAX 121 DAX Language Fundamentals 121 Using DAX operators 125 Applying conditional logic in DAX 126 Working with DAX aggregate functions 128 Exploring iterator functions and row context 129 Understanding Filter Context 133 Getting context transitions with the CALCULATE function 135 Adding flexibility with the FILTER function 137 Part 2: Wrangling Data with Power Query 141 Chapter 8: Introducing Power Query 143 Power Query Basics 144 Starting the query 144 Understanding query steps 150 Refreshing Power Query data 152 Managing existing queries 153 Understanding Column-Level Actions 155 Understanding Table Actions 157 Chapter 9: Power Query Connection Types 159 Importing Data from Files 160 Getting data from Excel workbooks 160 Getting data from CSV and text files 161 Getting data from PDF files 163 Getting data from folders 164 Importing Data from Database Systems 165 A connection for every database type 165 Getting data from other data systems 167 Walk-through: Getting data from a database 168 Managing Data Source Settings 170 Data Profiling with Power Query 171 Data Profiling options 172 Data Profiling quick actions 173 Chapter 10: Transforming Your Way to Better Data 175 Completing Common Transformation Tasks 176 Removing duplicate records 176 Filling in blank fields 178 Concatenating columns 179 Changing case 181 Finding and replacing specific text 181 Trimming and cleaning text 183 Extracting the left, right, and middle values 184 Splitting columns using character markers 187 Pivoting and unpivoting fields 189 Creating Custom Columns 193 Concatenating with a custom column 195 Understanding data type conversions 196 Spicing up custom columns with functions 197 Adding conditional logic to custom columns 199 Grouping and Aggregating Data 201 Working with Custom Data Types 203 Chapter 11: Making Queries Work Together 207 Reusing Query Steps 208 Understanding the Append Feature 211 Creating the needed base queries 212 Appending the data 213 Understanding the Merge Feature 216 Understanding Power Query joins 216 Merging queries 217 Understanding Fuzzy Match 221 Chapter 12: Extending Power Query with Custom Functions 225 Creating and Using a Basic Custom Function 225 Creating a Function to Merge Data from Multiple Excel Files 229 Creating Parameter Queries 236 Preparing for a parameter query 236 Creating the base query 238 Creating the parameter query 239 Part 3: The Part of Tens 243 Chapter 13: Ten Ways to Improve Power Pivot Performance 245 Limit the Number of Rows and Columns in Your Data Model Tables 246 Use Views Instead of Tables 246 Avoid Multi-Level Relationships 246 Let the Back-End Database Servers Do the Crunching 247 Beware of Columns with Many Unique Values 248 Limit the Number of Slicers in a Report 248 Create Slicers Only on Dimension Fields 249 Disable the Cross-Filter Behavior for Certain Slicers 250 Use Calculated Measures Instead of Calculated Columns 250 Upgrade to 64-Bit Excel 251 Chapter 14: Ten Tips for Working with Power Query 253 Getting Quick Information from the Queries & Connections Pane 253 Organizing Queries in Groups 254 Selecting Columns in Queries Faster 255 Renaming Query Steps 256 Quickly Creating Reference Tables 257 Viewing Query Dependencies 258 Setting a Default Load Behavior 259 Preventing Automatic Data Type Changes 259 Disabling Privacy Settings to Improve Performance 261 Disabling Relationship Detection 261 Index 263
£25.59
John Wiley & Sons Inc Beginning Flutter
Book SynopsisBuild your first app in Flutterno experience necessary! Beginning Flutter: A Hands-On Guide to App Development is the essential resource for both experienced and novice developers interested in getting started with Flutterthe powerful new mobile software development kit. With Flutter, you can quickly and easily develop beautiful, powerful apps for both Android and iOS, without the need to learn multiple programming languages or juggle more than one code base. This book walks you through the process step by step. In Flutter, you'll be working with Dart, the programming language of choice for top app developers. Even if you're just starting out in your development career, you can learn Dart quickly, eliminating the barrier to entry for building apps. This is a more efficient way to develop and maintain cross-platform mobile apps, and this book makes the process even easier with a teach-by-example approach. Focus on providing quality content by Table of ContentsIntroduction xxi Part I: The Foundations of Flutter Programming Chapter 1: Introducing Flutter and Getting Started 3 Introducing Flutter 4 Defining Widgets and Elements 5 Understanding Widget Lifecycle Events 5 The StatelessWidget Lifecycle 6 The StatefulWidget Lifecycle 6 Understanding the Widget Tree and the Element Tree 8 Stateless Widget and Element Trees 9 Stateful Widget and Element Trees 10 Installing the Flutter SDK 13 Installing on macOS 13 System Requirements 13 Get the Flutter SDK 13 Check for Dependencies 14 iOS Setup: Install Xcode 14 Android Setup: Install Android Studio 14 Set Up the Android Emulator 15 Installing on Windows 15 System Requirements 15 Get the Flutter SDK 16 Check for Dependencies 16 Install Android Studio 16 Set Up the Android Emulator 17 Installing on Linux 17 System Requirements 17 Get the Flutter SDK 18 Check for Dependencies 19 Install Android Studio 19 Set Up the Android Emulator 19 Configuring the Android Studio Editor 20 Summary 20 Chapter 2: Creating a Hello World App 25 Setting Up the Project 25 Using Hot Reload 30 Using Themes to Style Your App 33 Using a Global App Theme 33 Using a Theme for Part of an App 35 Understanding Stateless and Stateful Widgets 37 Using External Packages 38 Searching for Packages 39 Using Packages 40 Summary 41 Chapter 3: Learning Dart Basics 43 Why Use Dart? 43 Commenting Code 44 Running the main() Entry Point 45 Referencing Variables 45 Declaring Variables 46 Numbers 47 Strings 47 Booleans 47 Lists 47 Maps 48 Runes 48 Using Operators 49 Using Flow Statements 51 if and else 51 ternary operator 52 for Loops 52 while and do-while 53 while and break 54 continue 54 switch and case 55 Using Functions 55 Import Packages 57 Using Classes 57 Class Inheritance 60 Class Mixins 60 Implementing Asynchronous Programming 61 Summary 62 Chapter 4: Creating a Starter Project Template 65 Creating and Organizing Folders and Files 65 Structuring Widgets 69 Summary 74 Chapter 5: Understanding the Widget Tree 77 Introduction to Widgets 77 Building the Full Widget Tree 79 Building a Shallow Widget Tree 85 Refactoring with a Constant 86 Refactoring with a Method 86 Refactoring with a Widget Class 91 Summary 99 Part II: Intermediate Flutter: Fleshing Out an App Chapter 6: Using Common Widgets 103 Using Basic Widgets 103 SafeArea 107 Container 108 Text 112 RichText 112 Column 114 Row 115 Column and Row Nesting 115 Buttons 119 FloatingActionButton 119 FlatButton 121 RaisedButton 121 IconButton 122 PopupMenuButton 123 ButtonBar 126 Using Images and Icons 130 AssetBundle 130 Image 131 Icon 132 Using Decorators 135 Using the Form Widget to Validate Text Fields 139 Checking Orientation 143 Summary 149 Chapter 7: Adding Animation to an App 151 Using AnimatedContainer 152 Using AnimatedCrossFade 155 Using AnimatedOpacity 160 Using AnimationController 164 Using Staggered Animations 170 Summary 175 Chapter 8: Creating an App’s Navigation 177 Using the Navigator 178 Using the Named Navigator Route 188 Using Hero Animation 188 Using the BottomNavigationBar 193 Using the BottomAppBar 199 Using the TabBar and TabBarView 203 Using the Drawer and ListView 207 Summary 217 Chapter 9: Creating Scrolling Lists and Effects 221 Using the Card 222 Using the ListView and ListTile 223 Using the GridView 230 Using the GridView.count 230 Using the GridView.extent 232 Using the GridView.builder 233 Using the Stack 237 Customizing the CustomScrollView with Slivers 243 Summary 250 Chapter 10: Building Layouts 253 A High-Level View of the Layout 253 Weather Section Layout 256 Tags Layout 256 Footer Images Layout 257 Final Layout 257 Creating the Layout 257 Summary 265 Chapter 11: Applying Interactivity 267 Setting Up GestureDetector: The Basics 267 Implementing the Draggable and Dragtarget Widgets 275 Using the GestureDetector for Moving and Scaling 278 Using the InkWell and InkResponse Gestures 289 Using the Dismissible Widget 296 Summary 303 Chapter 12: Writing Platform-Native Code 307 Understanding Platform Channels 307 Implementing the Client Platform Channel App 309 Implementing the iOS Host Platform Channel 313 Implementing the Android Host Platform Channel 318 Summary 322 Part III: Creating Production-Ready Apps Chapter 13: Saving Data with Local Persistence 327 Understanding the JSON Format 328 Using Database Classes to Write, Read, and Serialize JSON 330 Formatting Dates 331 Sorting a List of Dates 332 Retrieving Data with the FutureBuilder 333 Building the Journal App 335 Adding the Journal Database Classes 339 Adding the Journal Entry Page 344 Finishing the Journal Home Page 359 Summary 371 Chapter 14: Adding The Firebase and Firestore Backend 375 What are Firebase and Cloud Firestore? 376 Structuring and Data Modeling Cloud Firestore 377 Viewing Firebase Authentication Capabilities 380 Viewing Cloud Firestore Security Rules 381 Configuring the Firebase Project 383 Adding a Cloud Firestore Database and Implementing Security 391 Building the Client Journal App 395 Adding Authentication and Cloud Firestore Packages to the Client App 395 Adding Basic Layout to the Client App 403 Adding Classes to the Client App 406 Summary 409 Chapter 15: Adding State Management to the Firestore Client App 411 Implementing State Management 412 Implementing an Abstract Class 414 Implementing the InheritedWidget 415 Implementing the Model Class 416 Implementing the Service Class 417 Implementing the BLoC Pattern 417 Implementing StreamController, Streams, Sinks, and StreamBuilder 419 Building State Management 421 Adding the Journal Model Class 422 Adding the Service Classes 424 Adding the Validators Class 430 Adding the BLoC Pattern 432 Adding the AuthenticationBloc 432 Adding the AuthenticationBlocProvider 435 Adding the LoginBloc 436 Adding the HomeBloc 441 Adding the HomeBlocProvider 443 Adding the JournalEditBloc 444 Adding the JournalEditBlocProvider 447 Summary 449 Chapter 16: Adding Blocs to Firestore Client App Pages 453 Adding the Login Page 454 Modifying the Main Page 460 Modifying the Home Page 465 Adding the Edit Journal Page 472 Summary 484 Index 489
£26.34
Manning Publications Privacy Engineering
Book SynopsisPrivacyEngineering is a hands-on guide to building a modern and flexible privacy program for your organization. It helps map essential legal requirements into practical engineering techniques that you can implement right away. The book develops your strategic understanding of data governance and helps you navigate the tricky trade-offs between privacy and business needs. You'll learn to spot risks in your own data management systems and prepare to satisfy both internal and external privacy audits. There's no bureaucratic new processes or expensive new software necessary. You'll learn how to repurpose the data and security tools you already use to achieve your privacy goals. Preserving the privacy of your users is essential for any successful business. Well-designed processes and data governance ensure that privacy is built into your systems from the ground up, keeping your users safe and helping your organization maintain compliance with the law. Trade Review“A great high-level resource on privacy as it relates to the data collected by business software systems.” Joe Ivans “Provides a clear and thorough explanation of the how and the why of data privacy pitched at a level which isn't too technical, yet has a sufficient level of detail to allow for interpretation of implementation.” Matthew Todd “Really interesting subject matter. The author provides relevant examples and obviously has a lot of direct experience.” John Tyler “A great resource on approaching data privacy.” Doniyor Ulmasov “The best parts are the personal elements added to the narrative. I also enjoyed the case studies that help to illustrate the examples provided throughout.” Ayana Miller
£36.09
John Wiley & Sons Inc Mastering AutoCAD 2021 and AutoCAD LT 2021
Book SynopsisTable of ContentsIntroduction xxvii Part 1 The Basics 1 Chapter 1 Exploring the Interface 3 Taking a Guided Tour 3 Launching AutoCAD 4 The AutoCAD Window 5 Using the Application Menu 8 Using the Ribbon 10 Picking Points in the Drawing Area 15 Using the UCS Icon 16 Working in the Command Window 16 Working with AutoCAD 17 Opening an Existing File 17 Getting a Closer Look 18 Saving a File as You Work 22 Making Changes 23 Working with Multiple Files 24 Adding a Predrawn Symbol with the Tool Palettes 28 The Bottom Line 31 Chapter 2 Creating Your First Drawing 33 Getting to Know the Home Tab’s Draw and Modify Panels 33 Starting Your First Drawing 36 Specifying Exact Distances with Coordinates 41 Specifying Polar Coordinates 42 Specifying Relative Cartesian Coordinates 44 Interpreting the Cursor Modes and Understanding Prompts 45 Understanding Cursor Modes 46 Choosing Command Options 47 Selecting Objects 52 Selecting Objects in AutoCAD 53 Providing Base Points 55 Using Noun/Verb Selection 59 Editing with Grips 64 Stretching Lines by Using Grips 64 Moving and Rotating with Grips 66 Understanding Dynamic Input 69 Displaying Data in a Text Window 74 Displaying the Properties of an Object 75 Getting Help 78 Using the InfoCenter 78 Finding Additional Sources of Help 79 The Bottom Line 79 Chapter 3 Setting Up and Using the Drafting Tools 81 Setting Up a Work Area 81 Specifying Units 82 Fine-Tuning the Measurement System 84 Setting Up the Drawing Limits 85 Looking at an Alternative to Limits 87 Understanding Scale Factors 87 Using Polar Tracking 88 Setting the Polar Tracking Angle 90 Exploring the Drawing Process 91 Locating an Object in Reference to Others 92 Modifying an Object 93 Planning and Laying Out a Drawing 96 Making a Preliminary Sketch 98 Using the Layout 100 Erasing the Layout Lines 106 Putting on the Finishing Touches 108 Aligning Objects by Using Object Snap Tracking 109 Using the AutoCAD Modes as Drafting Tools 114 Using Grid Mode as a Background Grid 115 Using Snap Modes 117 The Bottom Line 118 Chapter 4 Organizing Objects with Blocks and Groups 121 Creating and Using a Symbol 121 Understanding the Block Definition Dialog Box 124 Inserting a Symbol 126 Scaling and Rotating Blocks 129 Using an Existing Drawing as a Symbol 131 Modifying a Block 133 Unblocking and Redefining a Block 134 Saving a Block as a Drawing File 136 Replacing Existing Files with Blocks 137 Understanding the Write Block Dialog Box Options 138 Other Uses for Blocks 138 Understanding the Annotation Scale 139 Grouping Objects 142 Modifying Members of a Group 144 Ungrouping, Adding, and Subtracting from a Group 147 Working with the Object Grouping Dialog Box 148 Working with the AutoCAD LT Group Manager 150 The Bottom Line 152 Chapter 5 Keeping Track of Layers and Blocks 153 Organizing Information with Layers 153 Creating and Assigning Layers 154 Working on Layers 162 Controlling Layer Visibility 166 Finding the Layers You Want 168 Taming an Unwieldy List of Layers 169 Assigning Linetypes to Layers 176 Adding a Linetype to a Drawing 177 Controlling Lineweights 182 Keeping Track of Blocks and Layers 182 Getting a Text File List of Layers or Blocks 183 The Bottom Line 185 Part 2 Mastering Intermediate Skills 187 Chapter 6 Editing and Reusing Data toWork Efficiently y 189 Creating and Using Templates 190 Creating a Template 190 Using a Template 191 Copying an Object Multiple Times 192 Making Circular Copies 193 Making Row and Column Copies 195 Fine-Tuning Your View 197 Finishing the Kitchenette 199 Array Along a Path 200 Making Changes to an Associative Array 201 Developing Your Drawing 205 Importing Settings 206 Using Osnap Tracking to Place Objects 209 Finding an Exact Distance Along a Curve 226 Changing the Length of Objects 228 Creating a New Drawing by Using Parts from Another Drawing 229 Eliminating Unused Blocks, Layers, Linetypes, Shapes, Styles, and More 230 The Bottom Line 232 Chapter 7 Mastering Viewing Tools, Hatches, and External References 235 Assembling the Parts 235 Taking Control of the AutoCAD Display 238 Understanding Regeneration and Redrawing 239 Saving Views 240 Understanding the Frozen Layer Option 244 Using Hatch Patterns in Your Drawings 246 Placing a Hatch Pattern in a Specific Area 246 Adding Predefined Hatch Patterns 248 Positioning Hatch Patterns Accurately 250 Updating a Block from an External File 251 Changing the Hatch Area 253 Modifying a Hatch Pattern 254 Understanding the Boundary Hatch Options 255 Controlling Boundaries with the Boundaries Panel 257 Fine-Tuning the Boundary Behavior 257 Controlling Hatch Behavior with the Options Panel 258 Controlling Hatch Default Layer, Layout Scale, and ISO Line Weight 259 Using Additional Hatch Features 259 Using Gradient Shading 260 Tips for Using Hatch 262 Space Planning and Hatch Patterns 262 Using External References 266 Attaching a Drawing as an External Reference 266 Other Differences Between External References and Blocks 270 Other External Reference Options 272 Clipping Xref Views and Improving Performance 274 Editing Xrefs in Place 277 Using the External Reference Tab 280 Adding and Removing Objects from Blocks and Xrefs 280 Understanding the Reference Edit Dialog Box Options 283 The Bottom Line 284 Chapter 8 Introducing Printing, Plotting, and Layouts 285 Plotting the Plan 285 Understanding the Plotter Settings 290 Paper Size 290 Drawing Orientation 291 Plot Area 291 Plot Scale 292 Shaded Viewport Options 295 Plot Offset 296 Plot Options 297 Exit Options 298 Plotting Using Layout Views 299 Setting Plot Scale in the Layout Viewports 302 Adding an Output Device 303 Editing a Plotter Configuration 306 Storing a Page Setup 308 Using Electronic Plots 312 Exporting to PDF Through the Plot Dialog Box 312 Exporting to PDF Through the Export To DWF/PDF Ribbon Panel 314 Exporting Autodesk DWF and DWFx Files 315 The Bottom Line 316 Chapter 9 Adding Text to Drawings 317 Preparing a Drawing for Text 317 Organizing Text by Styles 319 Getting Familiar with the Text and Annotation Scale Control Panels 320 Setting the Annotation Scale and Adding Text 321 Inserting Text 321 Exploring Text and Scale 323 Understanding the Text Style Dialog Box Options 326 Styles 326 Set Current/New/Delete 326 Font 326 Size 326 Effects 327 Exploring Text Formatting in AutoCAD 327 Adjusting the Text Height and Font 328 Understanding the Text Editor Tab 330 Adding Symbols and Special Characters 331 Setting Indents and Tabs 334 What Do the Fonts Look Like? 338 Adding Simple Single-Line Text Objects 340 Justifying Single-Line Text Objects 342 Using Special Characters with Single-Line Text Objects 343 Using the Check Spelling Feature 345 How Check Spelling Works 345 Choosing a Dictionary 346 Substituting Fonts 347 Finding and Replacing Text 349 The Bottom Line 353 Chapter 10 Using Fields and Tables 355 Using Fields to Associate Text with Drawing Properties 355 Adding Tables to Your Drawing 359 Creating a Table 360 Adding Cell Text 361 Adjusting Table Text Orientation and Location 363 Editing the Table Line Work 365 Adding Formulas to Cells 368 Using Formulas Directly in Cells 369 Using Other Math Operations 370 Importing and Exporting Tables 370 Importing a Table 371 Exporting Tables 373 Creating Table Styles 373 Adding or Modifying a Table Style 373 Exploring the Table Style Options 375 The Bottom Line 376 Chapter 11 Using Dimensions 377 Understanding the Components of a Dimension 377 Creating a Dimension Style 378 Setting Up the Primary Unit Style 380 Setting the Height for Dimension Text 382 Setting the Location and Orientation of Dimension Text 383 Choosing an Arrow Style and Setting the Dimension Scale 384 Setting Up Alternate Units 388 Setting the Current Dimension Style 389 Modifying a Dimension Style 390 Drawing Linear Dimensions 390 Understanding the Dimensions Panel 391 Placing Horizontal and Vertical Dimensions 392 Continuing a Dimension 393 Drawing Dimensions from a Common Base Extension Line 394 Adjusting the Distance Between Dimensions 396 Editing Dimensions 397 Appending Data to Dimension Text 397 Using Grips to Make Minor Adjustments to Dimensions 399 Changing Style Settings of Individual Dimensions 401 Associating Dimensions with Objects 405 Adding a String of Dimensions with a Single Operation 407 Adding or Removing the Alternate Dimensions 408 Dimensioning Nonorthogonal Objects 409 Dimensioning Nonorthogonal Linear Distances 409 Dimensioning Radii, Diameters, and Arcs 411 Skewing Dimension Lines 415 Using the Dimension Tool 416 Adding a Note with a Leader Arrow 419 Creating Multileader Styles 421 Editing Multileader Notes 424 Breaking a Dimension Line for a Leader 424 Applying Ordinate Dimensions 425 Adding Tolerance Notation 426 Inserting Tolerance and Datum Values 426 Adding Inspection Dimensions 427 The Bottom Line 429 Part 3 Mastering Advanced Skills 431 Chapter 12 Using Attributes 433 Creating Attributes 434 Adding Attributes to Blocks 434 Copying and Editing Attribute Definitions 437 Turning the Attribute Definitions into a Block 440 Inserting Blocks Containing Attributes 441 Editing Attributes 445 Editing Attribute Values One at a Time 445 Editing Attribute Text Formats and Properties 446 Making Global Changes to Attribute Values 447 Making Invisible Attributes Visible 449 Making Global Format and Property Changes to Attributes 450 Other Block Attribute Manager Options 452 Redefining Blocks Containing Attributes 453 Extracting and Exporting Attribute Information 454 Performing the Extraction 454 Extracting Attribute Data to an AutoCAD Table 459 The Bottom Line 461 Chapter 13 Copying Existing Drawings from Other Sources 463 Methods for Converting Paper Drawings to AutoCAD Files 463 Importing a Raster Image 464 Working with a Raster Image 466 Scaling a Raster Image 468 Controlling Object Visibility and Overlap with Raster Images 468 Adjusting Brightness, Contrast, and Fade 471 Clipping a Raster Image 472 Turning Off the Frame, Adjusting Overall Quality, and Controlling Transparency 473 Working with PDF Files 477 Importing a PDF 477 Scaling and Osnaps with PDFs 478 Controlling the PDF Display 481 Importing a PDF as an AutoCAD Drawing 483 Reconstructing Imported AutoCAD SHX Fonts 485 Coordinating Geographic Locations 486 Making Adjustments to the Map 489 Finding Measurements and Distances 491 The Bottom Line 492 Chapter 14 Advanced Editing and Organizing 493 Using External References 493 Preparing Existing Drawings for External Referencing 494 Assembling Xrefs to Build a Drawing 496 Updating Blocks in Xrefs 500 Importing Named Elements from Xrefs 502 Controlling the Xref Search Path 505 Managing Layers 507 Saving and Recalling Layer Settings 507 Other Tools for Managing Layers 510 Using Advanced Tools: Filter and Quick Select 513 Filtering Selections 513 Using Quick Select 518 Using the QuickCalc Calculator 520 Adding Foot and Inch Lengths and Finding the Sum of Angles 522 Converting Units with QuickCalc 525 Using QuickCalc to Find Points 526 Finding Fractional Distances Between Two Points 529 Using QuickCalc While in the Middle of a Command 532 Storing Expressions and Values 533 Guidelines for Working with QuickCalc 535 The Bottom Line 538 Chapter 15 Laying Out Your Printer Output 541 Understanding Model Space and Paper Space 541 Switching from Model Space to Paper Space 542 Setting the Size of a Paper Space Layout 544 Creating New Paper Space Viewports 546 Creating a Viewport from a Saved View 547 Reaching Inside Viewports 548 Working with Paper Space Viewports 551 Scaling Views in Paper Space 552 Setting Layers in Individual Viewports 554 Creating and Using Multiple Paper Space Layouts 558 Creating Odd-Shaped Viewports 560 Understanding Lineweights, Linetypes, and Dimensions in Paper Space 562 Controlling and Viewing Lineweights in Paper Space 562 Using the Lineweight Settings Dialog Box 565 Controlling Linetype Scales and Paper Space 565 Dimensioning in Paper Space Layouts 566 Other Uses for Paper Space 569 The Bottom Line 570 Chapter 16 Making “Smart” Drawings with Parametric Tools 571 Why Use Parametric Drawing Tools? 571 Connecting Objects with Geometric Constraints 573 Using AutoConstrain to Add Constraints Automatically 573 Editing a Drawing Containing Constraints 574 Using Other Geometric Constraints 578 Using Constraints in the Drawing Process 579 Controlling Sizes with Dimensional Constraints 579 Adding a Dimensional Constraint 580 Editing a Dimensional Constraint 581 Using Formulas to Control and Link Dimensions 583 Adding a Formula Parameter 584 Testing the Formula 586 Using Other Formulas 587 Editing the Constraint Options 588 Putting Constraints to Use 590 The Bottom Line 591 Chapter 17 Using Dynamic Blocks 593 Exploring the Block Editor 593 Opening the Block Editor 594 Editing a Block and Creating New Blocks 595 Creating a Dynamic Block 596 Adding a Parameter 597 Adding an Action 598 Adding an Increment Value 600 Editing Parameters and Actions 602 Keeping an Object Centered 602 Using Constraints in Dynamic Blocks 604 Adding a List of Predefined Options 608 Creating Multiple Shapes in One Block 612 Rotating Objects in Unison 617 Filling in a Space Automatically with Objects 621 Including Block Information with Data Extraction 623 The Bottom Line 625 Chapter 18 Drawing Curves 627 Introducing Polylines 627 Drawing a Polyline 627 Setting Polyline Options 629 Editing Polylines 630 Setting Pedit Options 634 Smoothing Polylines 635 Editing Vertices 636 Creating a Polyline Spline Curve 646 Using True Spline Curves 648 Drawing a True Spline 648 Understanding the Spline Options 650 Fine-Tuning Spline Curves 651 Marking Divisions on Curves 654 Dividing Objects into Segments of Equal Length 654 Dividing Objects into Specified Lengths 657 The Bottom Line 658 Chapter 19 Getting and Exchanging Data from Drawings 661 Finding the Area of Closed Boundaries 661 Finding the Area of an Object 662 Using Hatch Patterns to Find Areas 663 Adding and Subtracting Areas with the Area Command 665 Getting General Information 669 Determining the Drawing’s Status 669 Keeping Track of Time 671 Getting Information from System Variables 672 Keeping a Log of Your Activity 672 Capturing and Saving Text Data from the AutoCAD Text Window 673 Understanding the Command Window Context Menu 674 Storing Searchable Information in AutoCAD Files 675 Searching for AutoCAD Files 676 Recovering Corrupted Files 677 Using the DXF File Format to Exchange CAD Data with Other Programs 677 Exporting DXF Files 678 Opening or Importing DXF Files 679 Using AutoCAD Drawings in Page Layout Programs 681 Exporting Raster Files 681 Exporting Vector Files 685 Using OLE to Import Data 687 Editing OLE Links 690 Importing Worksheets as AutoCAD Tables 690 Understanding Options for Embedding Data 693 Using the Clipboard to Export AutoCAD Drawings 694 The Bottom Line 694 Part 4 3D Modeling and Imaging 697 Chapter 20 Creating 3D Drawings 699 Getting to Know the 3D Modeling Workspace 699 Drawing in 3D Using Solids 701 Adjusting Appearances 702 Creating a 3D Box 702 Editing 3D Solids with Grips 704 Constraining Motion with the Gizmo 705 Rotating Objects in 3D Using Dynamic UCS 706 Drawing on a 3D Object’s Surface 709 Pushing and Pulling Shapes from a Solid 710 Making Changes to Your Solid 712 Creating 3D Forms from 2D Shapes 715 Isolating Coordinates with Point Filters 720 Moving Around Your Model 723 Finding Isometric and Orthogonal Views 723 Rotating Freely Around Your Model 724 Changing Your View Direction 725 Using SteeringWheels 727 Changing Where You Are Looking 729 Flying Through Your View 730 Changing from Perspective to Parallel Projection 731 Getting a Visual Effect 732 Using Visual Styles 732 Creating a Sketched Look with Visual Styles 733 In-Canvas Viewport Controls 736 Turning a 3D View into a 2D AutoCAD Drawing 736 Using the Point Cloud Feature 738 The Bottom Line 739 Chapter 21 Using Advanced 3D Features 741 Setting Up AutoCAD for This Chapter 741 Mastering the User Coordinate System 742 Defining a UCS 743 Saving a UCS 746 Working in a UCS 746 Building 3D Parts in Separate Files 748 Understanding the UCS Options 750 UCS Based on Object Orientation 750 UCS Based on Offset Orientation 753 UCS Rotated Around an Axis 754 Orienting a UCS in the View Plane 756 Manipulating the UCS Icon 756 Saving a UCS with a View 757 Using Viewports to Aid in 3D Drawing 758 Using the Array Tools 762 Making Changes to an Associative Array 763 Creating Complex 3D Surfaces 764 Laying Out a 3D Form 764 Spherical and Cylindrical Coordinate Formats 765 Using a 3D Polyline 766 Creating a Curved 3D Surface 767 Converting the Surface into a Solid 772 Shaping the Solid 772 Finding the Interference Between Two Solids 774 Creating Tubes with the Sweep Tool 777 Using Sweep to Create Complex Forms 779 Creating Spiral Forms 781 Creating Surface Models 784 Slicing a Solid with a Surface 786 Finding the Volume of a Cut 787 Understanding the Loft Command 790 Moving Objects in 3D Space 793 Aligning Objects in 3D Space 793 Moving an Object in 3D 795 Rotating an Object in 3D 796 The Bottom Line 797 Chapter 22 Editing and Visualizing 3D Solids 799 Understanding Solid Modeling 799 Creating Solid Forms 802 Joining Primitives 802 Cutting Portions Out of a Solid 804 Creating Complex Solids 806 Tapering an Extrusion 807 Sweeping a Shape on a Curved Path 808 Revolving a Polyline 809 Editing Solids 812 Splitting a Solid into Two Pieces 812 Rounding Corners with the Fillet Tool 814 Chamfering Corners with the Chamfer Tool 815 Using the Solid-Editing Tools 816 Streamlining the 2D Drawing Process 826 Drawing Standard Top, Front, and Right-Side Views 827 Creating 2D Drawings with the Base View Command 830 Adding Dimensions and Notes in a Layout 836 Using Visual Styles with a Viewport 837 Visualizing Solids 839 The Bottom Line 849 Chapter 23 Exploring 3D Mesh and Surface Modeling 851 Creating a Simple 3D Mesh 851 Creating a Mesh Primitive 852 Understanding the Parts of a Mesh 853 Smoothing a Mesh 853 Editing Faces and Edges 855 Stretching Faces 857 Moving an Edge 860 Adding More Faces 862 Rotating an Edge 865 Adding a Crease 866 Splitting and Extruding a Mesh Face 868 Creating Mesh Surfaces 871 Revolved Surface 871 Edge Surface 873 Ruled Surface 874 Tabulated Surface 875 Converting Meshes to Solids 876 Understanding 3D Surfaces 877 Editing Surfaces 879 Using Extrude, Surface Trim, and Surface Fillet 881 Using Surface Blend, Patch, and Offset 883 Understanding Associativity 888 Editing with Control Vertices 891 Editing with the CV Edit Bar 895 Making Holes in a Surface with the Project Geometry Panel 897 Visualizing Curvature: Understanding the Analysis Panel 898 The Bottom Line 901 Part 5 Customization and Integration 903 Chapter 24 Customizing the Workspace Environment, Linetypes, and Hatch Patterns 905 Using Workspaces 905 Customizing the User Interface 907 Taking a Quick Customization Tour 907 Understanding the Customizations In All Files Panel 912 Getting the Overall View 915 Finding Commands in the Command List 916 Opening Preview, Button Image, and Shortcuts 916 Getting to the Core of Customization in the Properties Group 917 Creating Your Own Ribbon Panels and Menus 918 Customizing Ribbon Panel Tools 920 Creating Macros in Tools and Menus 923 Pausing for User Input 925 Opening an Expanded Text Box for the Macro Option 925 Editing Keyboard Shortcuts 926 Saving, Loading, and Unloading Your Customizations 929 Understanding the DIESEL Macro Language 932 Using DIESEL at the Command Line 932 Using DIESEL in a Custom Menu Macro 934 Using DIESEL as a Menu Bar Option Label 935 Using DIESEL and Fields to Generate Text 936 Creating Custom Linetypes 938 Viewing Available Linetypes 939 Creating a New Linetype 940 Understanding the Linetype Code 941 Creating Complex Linetypes 942 Creating Hatch Patterns 944 The Bottom Line 947 Chapter 25 Managing and Sharing Your Drawings 949 Sharing Drawings Online 949 Sharing Project Files with eTransmit 950 Creating Additional Transmittal Setup Options 952 Publishing Your Drawings 954 Exchanging Drawing Sets 954 Exploring Other Publish Options 957 Creating a PDF or DWF File by Using the Plot Dialog Box 959 Sharing Views for Commenting 961 Using the Shared Views Tool 961 Using the Autodesk Viewer Web Page 964 Adding Hyperlinks to Drawings 965 Creating Hyperlinks 965 Editing and Deleting Hyperlinks 968 Taking a Closer Look at the Hyperlink Options 968 Managing Your Drawings with DesignCenter and the Tool Palettes 969 Getting Familiar with DesignCenter 970 Opening and Inserting Files with DesignCenter 973 Finding and Extracting the Contents of a Drawing 974 Exchanging Data between Open Files 978 Loading Specific Files into DesignCenter 979 Customizing the Tool Palettes with DesignCenter 980 Comparing Drawing Versions to Discover Changes 985 Using the Drawing Compare Tool 985 Looking at the Compare Tab Tools 987 Establishing Office Standards 987 Establishing Layering and Text Conventions 987 Checking Office Standards 988 Converting Multiple Layer Settings 993 Exploring Other Layer Translator Options 995 The Bottom Line 996 Part 6 Appendices 999 Appendix A The Bottom Line 1001 Chapter 1: Exploring the Interface 1001 Chapter 2: Creating Your First Drawing 1001 Chapter 3: Setting Up and Using the Drafting Tools 1002 Chapter 4: Organizing Objects with Blocks and Groups 1003 Chapter 5: Keeping Track of Layers and Blocks 1003 Chapter 6: Editing and Reusing Data to Work Efficiently 1004 Chapter 7: Mastering Viewing Tools, Hatches, and External References 1005 Chapter 8: Introducing Printing, Plotting, and Layouts 1005 Chapter 9: Adding Text to Drawings 1006 Chapter 10: Using Fields and Tables 1007 Chapter 11: Using Dimensions 1007 Chapter 12: Using Attributes 1008 Chapter 13: Copying Existing Drawings from Other Sources 1009 Chapter 14: Advanced Editing and Organizing 1010 Chapter 15: Laying Out Your Printer Output 1010 Chapter 16: Making “Smart” Drawings with Parametric Tools 1011 Chapter 17: Using Dynamic Blocks 1012 Chapter 18: Drawing Curves 1012 Chapter 19: Getting and Exchanging Data from Drawings 1014 Chapter 20: Creating 3D Drawings 1015 Chapter 21: Using Advanced 3D Features 1016 Chapter 22: Editing and Visualizing 3D Solids 1017 Chapter 23: Exploring 3D Mesh and Surface Modeling 1018 Chapter 24: Customizing the Workspace Environment, Linetypes, and Hatch Patterns 1019 Chapter 25: Managing and Sharing Your Drawings 1020 Appendix B Installing and Setting Up AutoCAD 1021 Before Installing AutoCAD 1021 Proceeding with the Installation 1021 Configuring AutoCAD 1022 The Files Tab 1023 The Display Tab 1025 The Open And Save Tab 1027 The Plot and Publish Tab 1030 The System Tab 1030 The User Preferences Tab 1032 The Drafting Tab 1034 The 3D Modeling Tab 1035 The Selection Tab 1037 The Profiles Tab 1039 Turning On the Noun/Verb Selection Method 1040 Turning on the Grips Feature 1040 Setting Up the Tracking Vector Feature 1041 Adjusting the AutoCAD 3D Graphics System 1041 Finding Folders That Contain AutoCAD Files 1041 Setting Up AutoCAD with a White Background 1042 Appendix C The Autodesk AutoCAD 2021 Certification 1043 Index 1047
£43.50
John Wiley & Sons Inc Applied Soil Mechanics
Book SynopsisA simplified approach to applying the Finite Element Method to geotechnical problems Predicting soil behavior by constitutive equations that are based on experimental findings and embodied in numerical methods, such as the finite element method, is a significant aspect of soil mechanics.Trade Review"The book can be useful for civil engineering students and practitioners." (Zentralblatt MATH, 2008)Table of ContentsChapter 1. Properties of Soil. Chapter 2. Elasticity and Plasticity. Chapter 3. Stresses in Soil. Chapter 4. Consolidation. Chapter 5. Shear Strength of Soil. Chapter 6. Shallow Foundations. Chapter 7. Lateral Earth Pressure and Retaining Walls. Chapter 8. Piles and Pile Groups.
£128.66
SCHOOL OF LIFE NON-BOOK The School of Life School of Thought Notebooks
Book Synopsis
£16.20
McGraw-Hill Education - Europe Introduction to Information Systems Loose Leaf
Book SynopsisO'Brien's Introduction to Information Systems 16e reflects the contemporary use of enterprise-wide business systems. New real-world case studies continue to correspond with this industry reality. The text's focus is on teaching the future manager the potential effect on business of the most current IT technologies such as the Internet, Intranets, and Extranets for enterprise collaboration, and how IT contributes to competitive advantage, reengineering business processes, problem solving, and decision-making. The benchmark text for the syllabus organized by technology (a week on databases, a week on networks, a week on systems development, etc.) taught from a managerial perspective. O'Brien defines technology and then explains how companies use the technology to improve performance. Real world cases finalize the explanation.Table of ContentsMODULE I Foundation Concepts1. Foundations of Information Systems in Business 2. Competing with Information Technology MODULE II Information Technologies3. Computer Hardware4. Computer Software 5. Data Resource Management 6. Telecommunications and Networks Module III e-Business Applications7. e-Business Systems 8. Business Across the Enterprise 9. e-Commerce Systems 10. Supporting Decision Making MODULE IV Development Processes11. Business/IT Strategies for Development 12. Implementing Business/IT SolutionsMODULE V Management Challenges13. Security and Ethical Challenges14. Enterprise and Global Management of Information Technology Review Quiz Answers Selected References Glossary for Business Professionals Name Index Company Index Subject Index
£51.29
McGraw-Hill Education - Europe Financial Freedom Through Electronic Day Trading
Book SynopsisOffers a step-by-step short course on electronic day trading which takes you through the technical and strategic basics you need. This book then tackles the psychological aspects of trading. It also gives you the trading tools to control your emotions and master different trading environments.Table of ContentsPart One: How to Develop a "Laser-Guided Rocket" to Trading Success. Chapter 1: The Journey to Trading Mastery. Chapter 2: Prepare YOurself for Trading Heights. Chapter 3: Design a Plan Even Goldman Sachs Might Envy. Part Two: Putting the "Laser-Guided Rocket" Together. Chapter 4: The Trader's Toolkit: Essential Secrets for Getting the Most from Your Hardware and Software. Chapter 5: Understanding the Golden Rule of Trading - R Multiples and Expectancy. Chapter 6: Position Sizing: The Key That Makes It All Work for You. Chapter 7: Prelaunch Preparation - Your Daily Routine. Part Three: Launching Your Trading Rocket. Chapter 8: The Trading Day Liftoff: Navigating Trade by Trade. Chapter 9: Market-Making Strategies. Chapter 10: Momentum Strategies. Part Four: Feedback and Maintenance. Chapter 11: Common Mistakes Everyone Makes - And How You Can Avoid Them. Chapter 12: Getting Feedback and Refining the Process. Chapter 13: Peak Performance Trading - The Keys to Gaining Control of Your Trading.
£47.69
McGraw-Hill Education - Europe Microsoft Office 2016 A Skills Approach
Book SynopsisMicrosoft Office Skills on Demand!Microsoft Office 2016: A Skills Approach provides a unique approach to learning Office skills by isolating skills for customized learning. Created from the learning side from SIMnet, McGraw-Hill's online training and assessment program, this textbook has 1:1 content with SIMnet. As a result, students have access to specific, isolated skills which creates the customized learning and makes Microsoft Office 2016: A Skills Approach the most flexible book on the market. Additionally, the approach uses consolidated instruction with fewer steps to explain each skill, resulting in easier learning for today's students!Microsoft Office 2016: A Skills Approach also offers projects to allow students to practice their skills and receive immediate feedback via autograding in the SIMgrader component. This integration with SIMnet helps meet the diverse needs of students and accommodate individual learning styles.Table of ContentsOffice 1 Essential Skills for Office 2016Word 1 Getting Started with Word 2016Word 2 Formatting Text and ParagraphsWord 3 Formatting DocumentsWord 4 Working with Pictures, Tables, and ChartsWord 5 Working with Reports, References, and MailingsExcel 1 Getting Started with Excel 2016Excel 2 Formatting CellsExcel 3 Using Formulas and FunctionsExcel 4 Formatting Worksheets and Managing the WorkbookExcel 5 Adding Charts and Analyzing DataAccess 1 Getting Started with Access 2016Access 2 Working with TablesAccess 3 Working with Forms and ReportsAccess 4 Using Queries and Organizing InformationPowerPoint 1 Getting Started with PowerPoint 2016PowerPoint 2 Adding Content to SlidesPowerPoint 3 Formatting PresentationsPowerPoint 4 Managing and Delivering Presentations
£197.45
McGraw-Hill Education - Europe Microsoft Office 2016 In Practice
Book SynopsisRandy Nordell Microsoft Office 2016: In PracticeTopic, Instruction, Practice! Microsoft Office 2016: In Practice offers a fresh approach to teaching today's students Microsoft Office skills by clearly introducing skills in a logical sequence: 1) Topic 2) Instruction and 3) Practice. Nordell's T.I.P.s approach builds a foundation for success by helping students practice what they learn, and provides transferable skills that allow students to grasp critical thinking beyond the textbook assignment.In Practice seamlessly integrates with SIMnet Online, McGraw-Hill's learning and assessment solution, which has 1:1 content to help students practice and master computing concepts and Microsoft Office skills. In Practice projects in SIMgrader allow students to practice their skills in a live Office application. Students receive immediate feedback upon completion of these auto-graded projects. The integrTable of ContentsIntro Chapter: Windows 10, Office 2016, and File ManagementWord—Chapter 1: Creating and Editing DocumentsWord—Chapter 2: Formatting and Customizing DocumentsWord—Chapter 3: Collaborating with Others and Working with ReportsWord—Chapter 4: Using Tables, Columns, and GraphicsExcel—Chapter 1: Creating and Editing WorkbooksExcel—Chapter 2: Working with Formulas and FunctionsExcel—Chapter 3: Creating and Editing ChartsExcel—Chapter 4: Formatting, Organizing, and Getting Data Access—Chapter 1: Creating a Database and TablesAccess —Chapter 2: Using Design View, Data Validation, and RelationshipsAccess —Chapter 3: Creating and Using QueriesAccess —Chapter 4: Creating and Using Forms and ReportsPowerPoint—Chapter 1: Creating and Editing PresentationsPowerPoint—Chapter 2: Illustrating Slides with Pictures and Information GraphicsPowerPoint—Chapter 3: Preparing for Delivery and Using a Slide Presentation
£226.70
McGraw-Hill Education - Europe Microsoft Office 2016 ProjectLearn
Book SynopsisProjects Today; Skills for Life!Microsoft Office 2016: ProjectLearn takes a project-based approach to engage students learning Microsoft Office 2016 focusing on the end result, skills for life. Students are presented with a scenario and then asked to produce a relevant work-related task (i.e. newsletter, expense budget, etc). Students get to develop a portfolio to impress future employers. Each lesson provides a structured, consistent step-by-step framework for student learning including a lesson overview, skills preview, and project practice. The structured series has two projects per chapter. At the end of each chapter are two "on your own" projects that each have three "work it out" exercises. By working directly within the project experience, students develop a deeper understanding of skills essential to their future careers.ProjectLearn is integrated with SIMnet, McGraw-Hillâs online learning and assesTable of ContentsWINDOWS 10CHAPTER 1 Introduction to Microsoft Windows 10OFFICE 2016CHAPTER 1 Introduction to Microsoft Office WORDCHAPTER 1 Introduction to Microsoft Word CHAPTER 2 Writing a Research Paper CHAPTER 3 Enhancing Your Documents EXCELCHAPTER 1 Introduction to Microsoft Excel CHAPTER 2 Summarizing DataCHAPTER 3 Advanced Formatting and Presenting DataACCESSCHAPTER 1 Introduction to Microsoft AccessCHAPTER 2 Organizing and Retrieving DataCHAPTER 3 Presenting and Managing DataPOWERPOINTCHAPTER 1 Introduction to Microsoft PowerPointCHAPTER 2 Placeholders and Slide DesignCHAPTER 3 Multimedia and Slide EnhancementINTEGRATION AND COLLABORATIONCHAPTER 1 Introduction to Integration and CollaborationWant more information? Contact your Learning Technology Representative.
£196.02
Pearson Education ECommerce 2019 Business Technology and Society
Book Synopsis
£210.92
Pearson Education (US) Microsoft Excel Pivot Table Data Crunching Office
Book SynopsisBill Jelen, Excel MVP and the host of MrExcel.com, has been using spreadsheets since 1985, and he launched the MrExcel.com website in 1998. Bill was a regular guest on Call for Help with Leo Laporte and has produced more than 2,200 episodes of his daily video podcast, Learn Excel from MrExcel. He is the author of 57 books about Microsoft Excel and writes the monthly Excel column for Strategic Finance magazine. Before founding MrExcel.com, Bill Jelen spent 12 years in the trenchesworking as a financial analyst for finance, marketing, accounting, and operations departments of a $500 million public company. He lives in Merritt Island, Florida, with his wife, Mary Ellen.Table of ContentsIntroduction CHAPTER 1 Pivot table fundamentals CHAPTER 2 Creating a basic pivot table CHAPTER 3 Customizing a pivot table CHAPTER 4 Grouping, sorting, and filtering pivot data CHAPTER 5 Performing calculations in pivot tables CHAPTER 6 Using pivot charts and other visualizations CHAPTER 7 Analyzing disparate data sources with pivot tables CHAPTER 8 Sharing dashboards with Power BI CHAPTER 9 Using cube formulas with the Data Model or OLAP data CHAPTER 10 Unlocking features with the Data Model and Power Pivot CHAPTER 11 Analyzing geographic data with 3D Map CHAPTER 12 Enhancing pivot table reports with macros CHAPTER 13 Using VBA or TypeScript to create pivot tables CHAPTER 14 Advanced pivot table tips and techniques CHAPTER 15 Dr. Jekyll and Mr. GetPivotData CHAPTER 16 Creating pivot tables in Excel Online
£30.59
Pearson Education (US) Adobe Acrobat Classroom in a Book
Book SynopsisTable of ContentsGetting Started 1. Introducing Adobe Acrobat 2. Creating Adobe PDF Files 3. Reading and Working with PDF Files 4. Enhancing PDF Documents 5. Editing Content in PDF Files 6. Using Acrobat on Mobile Devices 7. Using Acrobat with Microsoft Office Files 8. Combining Files 9. Adding Signatures and Security 10. Using Acrobat in a Review Cycle 11. Working with Forms in Acrobat 12. Using Actions (Acrobat Pro) 13. Using Acrobat in Professional Printing
£46.54
Columbia University Press Winning with Data Science
Book SynopsisThis book is a compelling and comprehensive guide to data science, emphasizing its real-world business applications and focusing on how to collaborate productively with data science teams.Trade ReviewEngaging in data science requires diplomacy for maximal impact. Namely, understanding the norms and priorities of data professionals helps you to spot risks and opportunities. As experienced, trusted data science advisors, and by providing valuable examples, Friedman and Swaminathan open a new data-driven world that spans every single industry vertical. -- Armen Kherlopian, CEO and Partner, Covenant Venture CapitalWinning with Data Science is refreshingly practical and clear. It’s also fun and empowering. After reading it, you’ll be more savvy about working with data teams and more valuable to your company. You may even become the envy of your colleagues (and competitors), who will wonder how you got so smart. -- Steven Strogatz, Susan and Barton Winokur Distinguished Professor for the Public Understanding of Science and Mathematics, Cornell University, and author of Infinite PowersFriedman and Swaminathan have taken the complex topic of data science and made it accessible to everyone. Their creative use of characters, situations, and meaningful examples serve to demystify how to think about the field, how to use data science to solve everyday problems, and how to interact with data scientists to ensure successful projects. An excellent read, even for people who (think they) know a little about the field of data science! -- Melvin (Skip) Olson, global head, Integrated Evidence Strategy and Innovation, Novartis Pharma AGWinning with Data Science addresses a critical but often ignored obstacle in data science: the knowledge gap between business stakeholders and technical teams. This book cuts through data science buzzwords and empowers readers with the knowledge to cultivate thriving data cultures. Distinguishing itself from others, this book prioritizes effective communication and collaboration within the data science sphere, facilitating deeper discussions on intricate technical subjects. -- Jeff Chen, former chief data scientist of the U.S. Department of Commerce and coauthor of Data Science for Public PolicyA terrific work. Winning with Data Science expertly takes readers through daily 'data lives,' struggles with business problems, and the data science concepts that can help address them. -- Paul W. Thurman, Columbia University Mailman School of Public Health, and author of MBA Fundamentals: StatisticsFriedman and Swaminathan provide a deep understanding of data science methodologies to managers, striking exactly the right balance of complexity and accessibility. -- Kim Sweeny, Principal Projects Officer, Institute for Sustainable Industries & Liveable Cities, Victoria UniversityIn today's digital age, data is king. And for business leaders, extracting insights and using them to drive informed decisions is more crucial than ever. . . . If [you] want to speak the language of data and harness its potential, Winning with Data Science is a must-read. -- Ken Kuang, entrepreneur, and Founder, Torrey Hills TechnologiesBy the end of the book, you'll feel like a pro in talking about data, even if you're not a tech expert. -- Nirali Mehta, Founder and CEO, PHARMA-STATSWinning with Data Science tackles the complex topic of data science and simplifies it to make it accessible to anyone, enabling a more data-driven culture at your organization. -- David Mathison, CEO, Chief AI Officer Summit, CDO Club, and CDO SummitTable of ContentsAcknowledgmentsIntroduction1. Tools of the Trade2. The Data Science Project3. Data Science Foundations4. Making Decisions with Data5. Clustering, Segmenting, and Cutting Through the Noise6. Building Your First Model7. Tools for Machine Learning8. Pulling It Together9. EthicsConclusionNotesIndex
£19.80
Pearson Education (US) Agile Transformation
Book SynopsisMichael K. Spayd's career in Agile began in 2001 as one of the leaders of a very large-scale adoption of Agile XP. Subsequently, Michael led and coached Agile transformations in a wide variety of contexts; as part of his practice, speaking, and teaching, he has endeavored to bring in key disciplines from fields external to Agile, such as professional coaching, systemic management, organization development (OD), organization culture and change, and approaches to develop more effective sensemaking in leaders. In 2010, Michael cofounded the Agile Coaching Institute, where he trained several thousand Agile coaches. In 2016, he cofounded Trans4mation, and in 2020 he and colleagues launched the Collective Edge ( www.the-collective-edge.com), to help expand consciousness at the critical edge of our collective needs. Michele Madore is the principal and cofounder of Trans4mation ( www.trTrade Review“ Agile Transformation is a wonderful, very readable, and very important book. What makes virtually all other books on transformation, leadership, and business so inadequate is their partial, incomplete, and non-inclusive character. This is exactly the inadequacy handled by Agile Transformation through the use of Integral metatheory, a systemic framework built to be as comprehensive as possible. Thus, Agile Transformation is as inclusive as can be, and that is what makes this book so incredibly important. So if you are engaged in a transformation, I strongly recommend that you not continue to be fractured and broken in your own approach, but step up to the wholeness and completeness of Agile Transformation.” —Ken Wilber, The Integral Vision “This book does not pull its punches. From the first page to the last, the Agile Transformation operating system works the simple and core truth about transforming an organization—it depends on you being transformed. There will be no Agile organizational transformation otherwise. There is much in this book that will help you learn about how to implement a successful Agile Transformation, but it is all for naught if you don't embody and lead the change. You are the vessel. It won't change unless you do. If you're serious about having your Agile Transformation succeed, read this book.” —Bob Anderson, chairman, The Leadership Circle “It's difficult to keep your focus sharp while broadening your perspective, but that is what Michele and Michael have pulled off in their new book on leading Agile Transformation. Impressively succinct, they provide straightforward tools and essential advice that will be useful for all leaders of transformation initiatives. So how did they do it? Well, for one thing, rather than positioning traditional and Agile-inspired management viewpoints as locked in combat, as many of their predecessors have done, they show how they are equally important, complementary features of a single unifying framework. Just as important, they know what is imperative, what to simplify, and what to ignore, the kind of knowledge that can only be distilled from decades of experience.” —Charlie Rudd, chairman and CEO, SolutionsIQ, an Accenture company “This is a must-read for any leader embarking on or in the midst of an Agile Transformation. Michele Madore and Michael Spayd's integral approach provides organizations with tremendous insights into how to overcome the pitfalls of process-centric transformations that are all too common. They have done a brilliant job of making clear, relatable, and actionable what many see as the most nebulous aspects of leading transformation.” —Shannon Ewan, managing director, ICAgile “Michele and Michael have written a beautiful book about change, intertwining their in-depth knowledge and vast experience with Agile Transformations. It gave me a vocabulary and understanding of the change territory, so now I have a way to navigate, too, and at the same time, it has nudged me gently to start exploring the same and go for my own development journey.” —Zvonimir Durcevic, enterprise Agile coachTable of ContentsPreface xiiiAcknowledgments xvAbout the Authors xvii Introduction: Why an Integral Perspective? 1 The Integral Operating System 2 How This Book Is Organized 4 Questions Addressed by This Book 6 Our Perspective (and Biases) 7 Part I: Agile Transformation: An Integral Approach 9Chapter 1: The Holon: Fundamental Building Block of the Integral Framework 11 Organizational Complexity 11 Holons 13 Holons and Agile Transformations 20 Summary 23 From Insight to Action 23 Chapter Notes 24 Chapter 2: The Quadrants: The Four Fundamental Perspectives 25 Deconstructing the Four Perspectives 25 Quadrants in Agile Transformations 36 Summary 37 From Insight to Action 37 Chapter Notes 38 Chapter 3: Integral Altitudes: The Evolution of Complexity 39 Why Altitude Matters 40 The Integral Concept of Altitude 41 How Altitudes Show Up in Organizations 41 Corroborating Research on Altitude 52 Evolution Across Quadrants 56 Summary 62 From Insight to Action 63 Chapter Notes 63 Chapter 4: Lines of Development 65 Developmental Lines 65 From Insight to Action 68 Summary of Part I 68 Part II: Transformational Leadership: Upgrading the Leader's Operating System 71Chapter 5: Transformational Leadership 75 The Context for Transformational Leadership 76 The Business Case for Transformational Leadership 82 The Essence of Transformational Leadership 84 Summary 89 From Insight to Action 89 Chapter 6: The Developmental Landscape 91 The Core of Development: “Our Story” 91 Deconstructing the Levels 95 Collective Leadership Development 102 Summary 103 From Insight to Action 103 Chapter 7: The Developmental Path 105 How Development Actually Happens 106 The Shift from Reactive to Creative 117 The Shift from Creative to Integral 119 Using the Integral Disciplines to Foster Development 120 Increasing Collective Effectiveness 122 Summary 123 From Insight to Action 123 Part III: Organizational Transformation: Putting the Integral Compass to Work 125Chapter 8: The Integral Agile Transformation Framework: An Overview 127 How Do We Use the Map? 128 The IATF Quadrants 129 Integrating the Quadrant Perspectives 138 How Quadrants Look from Different Holons 142 Summary 149 From Insight to Action 149 Chapter 9: The Integral Disciplines: Focusing the Transformation 151 Integral Disciplines and Developmental Lines 151 IATF Integral Disciplines 153 Integral Disciplines Mapped to Developmental Lines 154 Summary 177 From Insight to Action 177 Chapter Notes 178 Chapter 10: Leading an Agile Transformation 179 How to Get Started 179 Transformational Leader Role and Competencies 180 Activating the Integral Disciplines 204 Summary 209 In Conclusion 209 References and Relevant Readings 211Index 215
£20.79
Taylor & Francis Ltd Configuration Management Second Edition
Book SynopsisThe book provides a comprehensive approach to configuration management from a variety of product development perspectives, including embedded and IT. It provides authoritative advice on how to extend products for a variety of markets due to configuration options. The book also describes the importance of configuration management to other parts of the organization. It supplies an overview of configuration management and its process elements to provide readers with a contextual understanding of the theory, practice, and application of CM. The book illustrates the interplay of configuration and data management with all enterprise resources during each phase of a product lifecycle.Table of Contents1. Overview of the Product Life Cycle.2. Overview of the Supporting Enterprise Infrastructure.3. Configuration Management and Product Management. 4. A Configuration Item and What It Implies. 5. Data Definition, Data Types, and Control Requirements. 6. Configuration Management. 7. Configuration Management Support of Functional Resources. 8. Functional Interfaces.9. Configuration Management Baselines. 10. Configuration Control. 11. When Things Go Wrong.12. Test, Inspection, and Evaluation Master Plan Organized. 13. Assessing and Mitigating Risk.
£63.64
John Wiley & Sons Inc Hdbk of Virtual Humans
Book SynopsisVirtual humans are becoming more and more popular and used in many applications such as the entertainment industry (in both film and games) and medical applications.Table of ContentsPreface. List of Contributors. List of Figures. List of Tables. 1. An Overview of Virtual Humans (Nadia Magnenat Thalmann and Daniel Thalmann). 2. Face Cloning and Face Motion Capture (Wonsook Lee, Taro Goto, Sumedha Kshirsagar, Tom Molet). 3. Body Cloning and Body Motion Capture (Pascal Fua, Ralf Plaenkers, WonSook Lee, Tom Molet). 4. Anthropometric Body Modeling (Hyewon Seo). 5. Body Motion Control (Ronan Boulic, Paolo Baerlocher). 6. Facial Deformation Models (Prem Kalra, Stephane Garchery, Sumedha Kshirsagar). 7. Body Deformations (Amaury Aubel). 8. Hair Simulation (Sunil Hadap). 9. Cloth Simulation (Pascal Volino, Frédéric Cordier). 10. Expressive Speech Animation and Facial Communication (Sumedha Kshirsagar, Arjan Egges, Stéphane Garchery). 11. Behavioral Animation (Jean-Sébastien Monzani, Anthony Guye-Vuilleme, Etienne de Sevin). 12. Body Gesture Recognition and Action Response (Luc Emering, Bruno Herbelin). 13. Interaction with 3-D Objects (Marcello Kallmann). 14. Groups and Crowd Simulation (Soraia Raupp Musse, Branislav Ulicny, Amaury Aubel). 15. Rendering of Skin and Clothes (Neeharika Adabala). 16. Standards for Virtual Humans (Stéphane Garchery, Ronan Boulic, Tolga Capin, Prem Kalra). Appendix A: Damped Least Square Pseudo-Inverse J+A. Appendix B: H-Anim Joint and Segment Topology. Appendix C: Facial Animation Parameter Set . References. Index.
£133.16
John Wiley & Sons Inc Excel 2007 Advanced Report Development
Book SynopsisCreate powerful, innovative reporting solutions with Excel 2007! With this new book, which is significantly updated from the bestselling Excel 2003 version, author Timothy Zapawa provides you with in-depth coverage of Excel 2007's enhanced reporting capabilities.Table of ContentsAbout the Author. Acknowledgements. Introduction. Part I Report Basics. Chapter 1 Taking a First Look at Excel's Reporting Tools. Chapter 2 Getting Started with PivotTable Reports. Chapter 3 PivotTable Essentials and Components. Part II External Data. Chapter 4 Working with External Data Sources. Chapter 5 Looking at the Get External Data Tab. Chapter 6 Retrieving External Data Using Microsoft Query. Chapter 7 Using the Query Wizard. Chapter 8 Getting Started with Microsoft Query. Chapter 9 Working with SQL in Microsoft Query. Part III PivotTable Reporting. Chapter 10 Designing PivotTable Reports. Chapter 11 PivotTable Report Formatting. Chapter 12 Managing PivotTable Data. Chapter 13 Analyzing Data in a PivotChart. Part IV Spreadsheet Reporting. Chapter 14 Creating and Using Spreadsheet Reports. Chapter 15 Building Report Solutions. Chapter 16 Spreadsheet ReportFormatting. Part V Appendices. Appendix A SQL Reference. Appendix B Pop-Up Menus, Clicking Actions, and Toolbar Functions. Index.
£28.49
John Wiley & Sons Inc Microsoft Office Excel 2007 for Project Managers
Book SynopsisCombine the power of Excel 2007, Microsoft Office SharePoint Server, and sound project management tools to boost your skill set and maximize your productivity. You'll walk through a project and learn how to use these powerful tools to schedule jobs, create budgets, manage processes, and share project information. Whether new to project management or a veteran, you'll discover techniques, hints, and examples you can use immediately.Table of ContentsIntroduction. Chapter 1. Establishing Project Management Fundamentals. Chapter 2. Establishing Excel and Office 2007 Share Point Server Fundamentals. Chapter 3. Initiating the Project. Chapter 4. Determining Project Requirements. Chapter 5. Planning and Acquiring Resources. Chapter 6. Assessing and Tracking Risk. Chapter 7. Quality Management. Chapter 8. Constructing the Project Schedule and Budget. Chapter 9. Establishing Change Control Processes. Chapter 10. Controlling Project Outcomes and Archiving Documents. Appendix A. Excel Function Junction. Index.
£24.79
John Wiley & Sons Inc Visio 2007 For Dummies
Book SynopsisReveal your inner business artist with Visio Turn your ideas into diagrams and drawings with Visio's stencils and templates If you have an idea you want to get down on electronic paper, Visio 2007 is for you, and so is this book! They're both flexible and user-friendly.Table of ContentsIntroduction 1 Part I: Starting with Visio 2007 Basics 7 Chapter 1: Visio 101 9 Chapter 2: Creating and Saving a Simple Visio Drawing 29 Chapter 3: Printing Visio Drawings 69 Part II: Creating Visio Drawings 89 Chapter 4: Discovering What Visio Shapes Are All About 91 Chapter 5: Adding Text to Your Drawings 119 Chapter 6: Connecting Shapes 145 Part III: Taking Your Drawings to the Next Level 167 Chapter 7: Perfecting Your Drawings 169 Chapter 8: Creating and Customizing Shapes 191 Chapter 9: Working with Pages 227 Chapter 10: Layering Your Drawings 249 Part IV: Advancing Your Knowledge of Visio 265 Chapter 11: Creating Stencils, Master Shapes, and Templates 267 Chapter 12: Managing Shape Information, Behavior, and Protection 281 Chapter 13: Marking Up Drawings for Review 313 Chapter 14: Using Visio with Other Programs 329 Part V: The Part of Tens 357 Chapter 15: Ten Common Tasks in Visio 359 Chapter 16: Ten Web Sites Devoted to Visio 365 Index 371
£17.59
John Wiley & Sons Inc Symbolic Data Analysis
Book SynopsisThe first book to present a unified account of symbolic data analysis methods in a consistent statistical framework, Symbolic Data Analysis features a substantial number of examples from a range of application areas, including health, the social sciences, economics, and computer science.Trade Review“Primarily aimed at statisticians and Data analysts, SDA is also ideal for scientists…” (Zentralblatt MATH, 2007)Table of Contents1. Introduction. References. 2. Symbolic Data. 2.1 Symbolic and Classical Data. 2.2 Categories, Concepts and Symbolic Objects. 2.3 Comparison of Symbolic and Classical Analysis. 3. Basic Descriptive Statistics: One Variate. 3.1 Some Preliminaries. 3.2 Multi-valued Variables. 3.3 Interval-valued Variables. 3.4 Multi-valued Modal variables. 3.5 Interval-valued Modal Variables. 4. Descriptive Statistics: Two or More Variates. 4.1 Multi-valued Variables. 4.2 Interval-valued Variables. 4.3 Modal Multi-valued Variables. 4.4 Modal Interval-valued Variables. 4.5 Baseball Interval-valued Dataset. 4.6 Measures of Dependence. 5. Principal Component Analysis. 5.1 Vertices Method. 5.2 Centers Method. 5.3 Comparison of the Methods. 6. Regression Analysis. 6.1 Classical Multiple Regression Model. 6.2 Multi-valued Variables. 6.3 Interval-valued Variables. 6.4 Histogram-valued Variables. 6.5 Taxonomy Variables. 6.6 Hierarchical Variables. 7. Cluster Analysis. 7.1 Dissimilarity and Distance Measures. 7.2 Clustering Structures. 7.3 Partitions. 7.4 Hierarchy-Divisive Clustering. 7.5 Hierarchy-Pyramid Clusters. Data Index. Author Index. Subject Index.
£80.06
John Wiley & Sons Inc Wiley Pathways Introduction to Database
Book SynopsisYou can get there Introduction to Databases Project Manual offers a wealth of easy-to-read, practical, up-to-date activities that reinforce fundamental database design and management concepts. You''ll also learn to develop the core competencies and skills you''ll need in the real world, such as how to: * Install SQL Server 2005 * Read and create an ERD * Design and implement a database * Use DDL and DML commands * Use and monitor transactions * Manage security principles, permissions, and backups * Design data environments * Use replication With five to seven projects per chapter ranging from easy to more advanced, Introduction to Databases Project Manual is ideal for both traditional and online courses that are oriented toward strengthening database management skills. Introduction to Databases Project Manual is an excellent companion to Gillenson''s Introduction to Databases (ISBN: 978-0-470-10186-5Table of Contents1 Introduction to Data and Data Management 1.1 Identifying Business Data 2 1.2 Identifying Human Data Sources 4 1.3 Installing SQL Server 2005 Evaluation Edition 5 1.4 Learning about SQL Server Management Studio 12 1.5 Identifying Key Management Areas 19 2 Introducing Databases and Database Management Systems 2.1 Comparing Database Models 21 2.2 Identifying DBMS Architecture and Components 23 2.3 Reviewing Server Hardware Resources 24 2.4 Investigating SQL Server Databases 32 2.5 Identifying Application Requirements 35 3 Data Modeling 3.1 Understanding Data Modeling Concepts 39 3.2 Recognizing Entities, Attributes, and Identifiers 40 3.3 Recognizing Relationships and Business Rules 42 3.4 Reading an ERD 45 3.5 Creating an ERD 47 3.6 Viewing Basic Database Objects 50 4 Designing a Database 4.1 Understanding Key Concepts 59 4.2 Converting Relationships 60 4.3 Reviewing a Normalized Database 65 4.4 Recognizing Normalization Errors 69 4.5 Normalizing Data 73 5 Implementing a Database 5.1 Understanding Terms and Concepts 78 5.2 Identifying Solution Requirements 79 5.3 Creating a Database 84 5.4 Creating Tables, Part 1 88 5.5 Setting Table Constraints 91 5.6 Creating Tables, Part 2 96 6 Understanding the SQL Language 6.1 Understanding Terms and Concepts 102 6.2 Identifying Help Resources 104 6.3 Comparing Command Environments 111 6.4 Using the SELECT Command 116 6.5 Using DDL Commands 121 6.6 Using DML Commands 126 7 Data Access and Manipulation 7.1 Understanding Data Access 132 7.2 Retrieving Data 133 7.3 Using Advanced Data Retrieval 138 7.4 Using Batches and Scripts 141 7.5 Recognizing and Correcting Syntax Errors 144 8 Improving Data Access 8.1 Understanding Database Monitoring and Optimization 149 8.2 Investigating Resources and Configuration Settings 151 8.3 Monitoring Performance 163 8.4 Recognizing Bottlenecks 172 8.5 Using Indexes and Views 175 8.6 Using Procedures and Functions 179 9 Database Administration 9.1 Understanding Administration 184 9.2 Understanding Roles and Responsibilities 186 9.3 Matching Life Cycle Requirements 188 9.4 Resolving Administration Issues 190 9.5 Managing "As-Needed" and Periodic Tasks 196 10 Transactions and Locking 10.1 Understanding Transactions and Locking 210 10.2 Understanding Transaction Types 212 10.3 Understanding Transaction Isolation and Locking 219 10.4 Using Transactions 226 10.5 Monitoring Transactions and Clearing Blocked Transactions 231 11 Data Access and Security 11.1 Understanding Data Access and Security 236 11.2 Designing for Access and Security 238 11.3 Understanding Your Security Environment 242 11.4 Managing Security Principals 249 11.5 Managing Permissions 255 11.6 Managing Backups 263 12 Supporting Database Applications 12.1 Understanding Data Configurations 267 12.2 Designing Data Environments 269 12.3 Working in a Distributed Environment 277 12.4 Using Distributed Queries 284 12.5 Using Replication 291 12.6 Understanding Data Issues 299
£37.35
John Wiley & Sons Inc Dreamweaver CS3 For Dummies
Book SynopsisDo you want to create a sophisticated Web site that's easy to develop and maintain? Whether you're a beginner or an experienced Web developer, this guide shows you how to utilize Dreamweaver's enhancements to build and manage state-of-the-art, professional Web sites quickly and easily.Table of ContentsIntroduction. Part I: Creating Great Web Sites. Chapter 1: The Many Ways to Design a Web Page. Chapter 2: Opening and Creating Sites in Dreamweaver. Chapter 3: Adding Graphics. Chapter 4: Managing, Testing, and Publishing a Site. Part II: Appreciating Web Design Options. Chapter 5: Cascading Style Sheets. Chapter 6: Creating CSS Layouts. Chapter 7: Coming to the HTML Table. Chapter 8: Framing Your Pages. Chapter 9: Coordinating Your Design Work. Part III: Making It Cool with Multimedia and JavaScript. Chapter 10: Adding Interactivity with Behaviors. Chapter 11: Showing Off with Multimedia. Chapter 12: Forms Follow Function. Part IV: Working with Dynamic Content. Chapter 13: Building a Dynamic Web Site: Getting Started. Chapter 14: Bringing Data into the Mix. Chapter 15: Using Forms to Manage Your Dynamic Web Site. Part V: The Part of Tens. Chapter 16: Ten Resources You May Need. Chapter 17: Ten Timesaving Tips. Chapter 18: Ten Great Web Sites Designed in Dreamweaver. Index.
£13.59
John Wiley & Sons Inc The Data Warehouse Lifecycle Toolkit
Book SynopsisA thorough update to the industry standard for designing, developing, and deploying data warehouse and business intelligence systems The world of data warehousing has changed remarkably since the first edition of The Data Warehouse Lifecycle Toolkit was published in 1998.Table of ContentsChapter 1 Introducing the Kimball Lifecycle 1 Chapter 2 Launching and Managing the Project/Program 15 Chapter 3 Collecting the Requirements 63 Chapter 4 Introducing the Technical Architecture 109 Chapter 5 Creating the Architecture Plan and Selecting Products 179 Chapter 6 Introducing Dimensional Modeling 233 Chapter 7 Designing the Dimensional Model 287 Chapter 8 Designing the Physical Database and Planning for Performance 327 Chapter 9 Introducing Extract, Transformation, and Load 369 Chapter 10 Designing and Developing the ETL System 425 Chapter 11 Introducing Business Intelligence Applications 473 Chapter 12 Designing and Developing Business Intelligence Applications 505 Chapter 13 Deploying and Supporting the DW/BI System 541 Chapter 14 Expanding the DW/BI System 579
£35.10
John Wiley & Sons Inc SAS 9 Study Guide
Book SynopsisA thorough and self-contained treatment for SAS users preparing for the Base Programming Certification Exam for SAS 9complete with explanations, tips, and practice exam questions SAS 9 Study Guide is designed to help users of SAS 9 become familiar with the fine points of the software as well as develop solid study strategies that will shorten preparation time and ensure successful exam results. The following five study topics are addressed with a focused chapter devoted to each: accessing data; creating data structures; managing data; generating reports; and handling errors. SAS 9 Study Guide provides both a conceptual and practical approach to each of these areas with detailed explanations followed by examples. Each chapter presents concepts, processes, and applications in a clear, step-by-step format along with detailed explanations and examples. Individual chapters also contain: A Two-Minute Drill that provides a checklist of key points for review Table of ContentsContents. Preface. Introduction. I. Accessing Data. 2. Creating Data Structures. 3. Managing Data. 4. Generating Reports. 5. Handling Errors. Index.
£73.76
John Wiley & Sons Inc The Data Model Resource Book
Book SynopsisThis third volume of the best-selling Data Model Resource Book series revolutionizes the data modeling discipline by answering the question How can you save significant time while improving the quality of any type of data modeling effort? In contrast to the first two volumes, this new volume focuses on the fundamental, underlying patterns that affect over 50 percent of most data modeling efforts. These patterns can be used to considerably reduce modeling time and cost, to jump-start data modeling efforts, as standards and guidelines to increase data model consistency and quality, and as an objective source against which an enterprise can evaluate data models. Table of ContentsForeword xxv Chapter 1 Introduction 1 Why Is There a Need for This Book? 1 Extending the Discipline of Data Modeling 4 What Is a Pattern and What Is a Universal Pattern? 5 What Is the Significance of Patterns? 6 Approach of This Book 6 The Different Pattern Levels 7 Who Is the Intended Audience for This Book? 14 What Is in This Book 15 Other Patterns for Data Modeling 17 Conventions and Standards Used in This Book 18 Entities 18 Subtypes and Supertypes 19 Attributes 20 Relationships 22 Relationship Optionality 23 Relationship Cardinality 25 Foreign Key Relationships 26 Associative Entities to Handle Many-to-Many Relationships 26 Exclusive Arcs 27 Example Data in Illustration Tables 28 Data Modeling Notation 29 Summary 33 References 33 Chapter 2 Setting Up Roles: What Parties Do 35 What Is the Significance of This Type of Pattern? 36 What Is in This Chapter? 36 What Is a Declarative Role? 37 Level 1 Declarative Role Pattern 38 Why Do We Need This Pattern? 40 How Does This Pattern Work? 41 When Should This Pattern Be Used? 44 What Are the Weaknesses of the Pattern? 45 Synopsis 46 Level 2 Declarative Role Pattern 47 Why Do We Need This Pattern? 48 How Does This Pattern Work? 48 When Should This Pattern Be Used? 53 What Are the Weaknesses of the Pattern? 54 Synopsis 55 Level 3 Declarative Role Pattern 56 Why Do We Need This Pattern? 56 How Does This Pattern Work? 57 When Should This Pattern Be Used? 63 What Are the Weaknesses of the Pattern? 64 Synopsis 65 Summary of Patterns 65 References 69 Chapter 3 Using Roles: How Parties Are Involved 71 What Is the Significance of This Type of Pattern? 72 What Is in This Chapter? 72 What Is a Contextual Role? 73 Level 1 Contextual Role Pattern, Attributes 74 Why Do We Need This Pattern? 74 How Does This Pattern Work? 76 When Should This Pattern Be Used? 78 What Are the Weaknesses of the Pattern? 79 Synopsis 80 Level 1 Contextual Role Pattern, Relationships 80 Why Do We Need This Pattern? 81 How Does This Pattern Work? 81 When Should This Pattern Be Used? 87 What Are the Weaknesses of the Pattern? 87 Synopsis 88 Level 2 Contextual Role Pattern 88 Why Do We Need This Pattern? 89 How Does This Pattern Work? 89 When Should This Pattern Be Used? 97 What Are the Weaknesses of the Pattern? 98 Synopsis 99 Level 2 Contextual Role Pattern, PARTY Only Alternative 99 Why Do We Need This Pattern? 100 How Does This Pattern Work? 100 When Should This Pattern Be Used? 106 What Are the Weaknesses of the Pattern? 106 Synopsis 107 Level 3 Contextual Role Pattern 107 Why Do We Need This Pattern? 108 How Does This Pattern Work? 108 When Should This Pattern Be Used? 114 What Are the Weaknesses of the Pattern? 115 Synopsis 116 Hybrid Contextual Role Pattern 117 Why Do We Need This Pattern? 117 How Does This Pattern Work? 118 When Should This Pattern Be Used? 123 What Are the Weaknesses of the Pattern? 123 Synopsis 124 Summary of Patterns 124 References 131 Chapter 4 Hierarchies, Aggregations, and Peer-to-Peer Relationships: The Organization of Similar Data 133 What Is the Significance of This Type of Pattern? 133 What Is in This Chapter? 134 What Is a Recursive Relationship and How Is Data Organized by Recursive Relationships? 134 Level 1 Recursive Pattern 138 Why Do We Need This Pattern? 138 How Does This Pattern Work? 139 When Should This Pattern Be Used? 144 What Are the Weaknesses of the Pattern? 145 Synopsis 145 Level 2 Recursive Pattern 146 Why Do We Need This Pattern? 146 How Does This Pattern Work? 147 When Should This Pattern Be Used? 152 What Are the Weaknesses of the Pattern? 153 Synopsis 154 Level 2 Expanded Recursive Pattern 155 Why Do We Need This Pattern? 155 How Does This Pattern Work? 156 When Should This Pattern Be Used? 162 What Are the Weaknesses of the Pattern? 162 Synopsis 163 Level 3 Recursive Pattern 164 Why Do We Need This Pattern? 165 How Does This Pattern Work? 165 When Should This Pattern Be Used? 170 What Are the Weaknesses of the Pattern? 171 Synopsis 172 Level 3 Recursive Pattern with Rules 173 Why Do We Need This Pattern? 173 How Does This Pattern Work? 174 When Should This Pattern Be Used? 179 What Are the Weaknesses of the Pattern? 180 Synopsis 180 Summary of Patterns 180 References 186 Chapter 5 Types and Categories: the Classification of Data 187 What Is the Significance of This Type of Pattern? 187 What Is in This Chapter? 188 What Are Types, Categorizations, and Taxonomies? 189 Level 1 Classification Pattern 190 Why Do We Need This Pattern? 190 How Does This Pattern Work? 190 When Should This Pattern Be Used? 195 What Are the Weaknesses of the Pattern? 196 Synopsis 197 Level 2 Classification Pattern 197 Why Do We Need This Pattern? 197 How Does This Pattern Work? 198 When Should This Pattern Be Used? 205 What Are the Weaknesses of the Pattern? 206 Synopsis 207 Level 3 Classification Pattern 208 Why Do We Need This Pattern? 208 How Does This Pattern Work? 208 When Should This Pattern Be Used? 219 What Are the Weaknesses of the Pattern? 220 Synopsis 221 Level 3 Classification Pattern with Rollups and Schemes 222 Why Do We Need This Pattern? 222 How Does This Pattern Work? 223 When Should This Pattern Be Used? 229 What Are the Weaknesses of the Pattern? 230 Synopsis 230 Summary of Patterns 230 References 235 Chapter 6 Status: The States of Data 237 What Is the Significance of This Type of Pattern? 238 What Is in This Chapter? 239 What Is a Status? 240 Level 1 Status Pattern 244 Why Do We Need This Pattern? 245 How Does This Pattern Work? 246 When Should This Pattern Be Used? 251 What Are the Weaknesses of the Pattern? 253 Synopsis 253 Level 2 Status Pattern, Current Status 254 Why Do We Need This Pattern? 255 How Does This Pattern Work? 255 When Should This Pattern Be Used? 260 What Are the Weaknesses of the Pattern? 260 Synopsis 261 Level 3 Status Pattern 261 Why Do We Need This Pattern? 261 How Does This Pattern Work? 262 When Should This Pattern Be Used? 267 What Are the Weaknesses of the Pattern? 267 Synopsis 268 Level 4 Status Pattern 269 Why Do We Need This Pattern? 269 How Does This Pattern Work? 269 When Should This Pattern Be Used? 277 What Are the Weaknesses of the Pattern? 278 Synopsis 279 Status Category Pattern 280 Why Do We Need This Pattern? 280 How Does This Pattern Work? 280 When Should This Pattern Be Used? 282 What Are the Weaknesses of the Pattern? 285 Synopsis 285 Status Type with Multi Rollup and Rules Pattern 286 Why Do We Need This Pattern? 286 How Does This Pattern Work? 287 When Should This Pattern Be Used? 293 What Are the Weaknesses of the Pattern? 294 Synopsis 294 Summary of Patterns 294 References 301 Chapter 7 Contact Mechanisms: How to Get in Touch 303 What Is the Significance of This Type of Pattern? 303 What Is in This Chapter? 304 What Is a Contact Mechanism? 305 Level 1 Contact Mechanism Pattern 308 Why Do We Need This Pattern? 309 How Does This Pattern Work? 310 When Should This Pattern Be Used? 321 What Are the Weaknesses of the Pattern? 322 Synopsis 323 Level 2 Contact Mechanism Pattern 324 Why Do We Need This Pattern? 325 How Does This Pattern Work? 325 When Should This Pattern Be Used? 342 What Are the Weaknesses of the Pattern? 343 Synopsis 344 Level 3 Contact Mechanism Pattern 345 Why Do We Need This Pattern? 346 How Does This Pattern Work? 346 When Should This Pattern Be Used? 361 What Are the Weaknesses of the Pattern? 361 Synopsis 362 Level 4 Contact Mechanism Pattern 364 Why Do We Need This Pattern? 364 How Does This Pattern Work? 364 When Should This Pattern Be Used? 378 What Are the Weaknesses of the Pattern? 378 Synopsis 379 Contact Mechanism Pattern with Geographic Boundary 380 Why Do We Need This Pattern? 381 How Does This Pattern Work? 384 When Should This Pattern Be Used? 389 What Are the Weaknesses of the Pattern? 390 Synopsis 390 Contact Mechanism with Flexible Address Parts Pattern 391 Why Do We Need This Pattern? 393 How Does This Pattern Work? 394 When Should This Pattern Be Used? 398 What Are the Weaknesses of the Pattern? 398 Synopsis 399 Other Common Contact Mechanism Data 399 Non-Solicitation 400 Instructions 401 Directions 402 Telephone Extensions 402 Synopsis 403 Summary of Patterns 403 References 410 Chapter 8 Business Rules: How Things Should Work 411 What Is the Significance of This Type of Pattern? 411 What Is in This Chapter? 414 What Is a Business Rule? 415 Level 2 Business Rules Pattern 417 Why Do We Need This Pattern? 417 How Does This Pattern Work? 419 When Should This Pattern Be Used? 442 What Are the Weaknesses of the Pattern? 444 Synopsis 444 Level 3 Business Rules Pattern 446 Why Do We Need This Pattern? 446 How Does This Pattern Work? 447 When Should This Pattern Be Used? 460 What Are the Weaknesses of the Pattern? 461 Synopsis 461 Business Rules with Party Roles 462 Why Do We Need This Pattern? 462 How Do These Patterns Work? 463 When Should This Pattern Be Used? 465 What Are the Weaknesses of the Pattern? 465 Synopsis 465 Summary of Patterns 465 References 468 Chapter 9 Using the Patterns 469 What Is in This Chapter? 470 The Scenario 471 Prototype Models, Scope Statements 472 The Scenario for These Models 472 How Do These Models Work? 473 Why Do We Do It This Way? 478 What Are the Strengths of Using Patterns for the Solution? 481 What Are the Weaknesses of Using Patterns for the Solution? 482 Synopsis 483 Application Data Models 483 The Scenario for This Model 484 How Do These Models Work? 484 Why Do We Do It This Way? 488 What Are the Strengths of Using Patterns for the Solution? 490 What Are the Weaknesses of Using Patterns for the Solution? 491 Synopsis 492 Enterprise Data Models 492 The Scenario for This Model 495 How Do These Models Work? 498 Why Do We Do It This Way? 501 What Are the Strengths of Using Patterns for the Solution? 501 What Are the Weaknesses of Using Patterns for the Solution? 502 Synopsis 502 Data Warehouse Models 503 The Scenario for This Model 504 Data Warehouse Data Models — Relational Approach 506 How Do These Models Work? 507 Why Do We Do It This Way? 513 What Are the Strengths of Using Patterns for the Solution? 514 What Are the Weaknesses of Using Patterns for the Solution? 515 Synopsis 515 Data Warehouse/Data Mart Data Models — Star Schemas 516 How Do These Models Work? 516 Why Do We Do It This Way? 527 What Are the Strengths of Using Patterns for the Solution? 528 What Are the Weaknesses of Using Patterns for the Solution? 529 Synopsis 530 Master Data Management 530 The Scenario for This Model 530 How Does This Model Work? 534 Why Do We Do It This Way? 543 What Are the Strengths of Using Patterns for the Solution? 544 What Are the Weaknesses of Using Patterns for the Solution? 545 Synopsis 545 Other Thoughts Regarding Using the Patterns 546 Physical Database Design 546 Other Applications for Patterns 547 Other Considerations When Using Generalized Patterns 547 Summary of Using the Patterns 548 References 552 Chapter 10 Socializing the Patterns 553 What Is the Significance of Socializing the Patterns? 554 What Is in This Chapter? 554 Experiences Using and Socializing These Patterns 555 What Makes the Difference In Socializing the Patterns? 558 Understanding Motivations — Why Would Someone Use or Not Use the Patterns? 559 Creating a Clear, Common, Compelling Purpose and Vision for Using the Patterns 566 Developing Trust so People Can Rely on the Patterns 569 Managing Resistance and/or Conflict Regarding Patterns 573 Other Comments about Socializing the Patterns 580 Patterns May Need to Be Socialized in Many Types of Circumstances 581 What about Upper-Level Management Commitment? 581 What Is the Return on Investment Regarding Using These Patterns? 582 Summary 584 References 585 Index 587
£54.00
John Wiley & Sons Inc Peachtree For Dummies
Book SynopsisNot feeling too peachy about computerizing your accounting system? Relax! Peachtree For Dummies, 3rd Edition will show you how to set up your company in Peachtree and then use it to pay bills, invoice customers, pay employees, produce financial reports, and more. You'll quickly discover how Peachtree can save you time, effort, and money so that you no longer have to do your accounting by hand or pay someone else to do it for you. Publishing to coincide with the latest release of Peachtree, this third edition is revised to cover the newest updates and enhancements made to the most recent version of Peachtree. Veteran authors Elaine Marmel and Diane Koers break down the capabilities of Peachtree Premium Accounting, from building an effective chart of accounts, to customizing forms and modifying reports, to setting up default information that will save you time down the line. You'll also discover how to: Work with purchase orders Sell Table of ContentsIntroduction. Part I: Getting Started. Chapter 1. Mastering Peachtree Basics. Chapter 2. Setting Up Your Company. Chapter 3. Designing the Cart of Accounts. Chapter 4. Setting Up Background Information. Part II: the Daily Drudge. Chapter 5. Buying Goods. Chapter 6. Payment Bills. Chapter 7. Selling Products and Services. Chapter 8. Collecting the Money. Chapter 9. Paid Employees Are Happy Employees. Chapter 10. Billing for Your Time. Chapter 11. Counting Your Stuff. Chapter 12. Tracking Project Costs. Part III: The Fancy Stuff. Chapter 13. Working with Forms. Chapter 14. Making Reports Work for You. Chapter 15. Reviewing the Financial Picture. Chapter 16. When the Bank Statement Arrives. Chapter 17. When Accounting Cycles End and Other Miscellaneous Stuff. Chapter 18. Keeping Your House Safe. Chapter 19. Real-Life Ways to Use Peachtree. Part IV: The Part of Tens. Chapter 20. Ten or So Common Peachtree Messages (And What You Can Do About Them). Chapter 21. ten or So Things You Can Get From the Web. Index.
£17.84
John Wiley & Sons Inc Crystal Reports 2008 For Dummies
Book SynopsisA report is only useful if those who receive it understand what it means. Knowing how to use Crystal Reports gives you the edge in producing reports from your database that really are crystal clear. Crystal Reports 2008 For Dummies is a quick and easy guide to get you going with the latest version of this bestselling report-writing software.Table of ContentsIntroduction 1 About This Book 1 Conventions Used in This Book 1 What You’re Not to Read 2 Foolish Assumptions 2 How This Book Is Organized 3 Part I: Reporting Basics 3 Part II: Moving Up to Professional-Quality Reports 3 Part III: Advanced Report Types and Features 3 Part IV: Crystal Reports in the Enterprise 3 Part V: Publishing Your Reports 4 Part VI: The Part of Tens 4 Icons Used in This Book 4 Where to Go from Here 5 Part I: Reporting Basics 7 Chapter 1: Transforming Raw Data into Meaningful Information 9 Major Features of Crystal Reports 2008 9 Formatting a report 10 Generating barcodes 11 Enhancing a report with formulas and custom functions 11 Getting visual with charts and maps 11 Xcelsius integration 12 Adobe Flash integration 12 Displaying a report 12 Distributing a report 12 Supplying Crystal Reports with data 13 The Lone Edition of Crystal Reports 2008 13 Viewing a Report 13 Reading a printed report 13 Viewing a report with Crystal Reports 14 Viewing a report on a LAN or on the Web 16 Chapter 2: Create a Simple Report Right Now! 17 First Things First: Finding the Sample Database 18 Starting Crystal Reports 2008 18 Creating a Report with the Blank Report Option 20 Allocating more space to the layout 24 Introducing your report 25 Choosing the fields that appear in your report 27 Improving the readability of page headers 29 Previewing the report 30 Page footers carry useful information 32 Wrapping things up with a report footer 34 Recording helpful information about your report 34 Printing a Report 36 Where to Go from Here 36 Chapter 3: Report Design Guidelines 37 Defining an Effective Report Design 37 Defining Your Audience 37 Defining the Report’s Purpose 38 Choosing Content for Your Report 39 Choosing the Report Appearance 39 Making a good first impression 40 Deciding how best to present the information 40 Choosing graphic elements for your report 41 Style communicates meaning, too 41 Making sure your report conveys your message 42 Chapter 4: Starting Your Report 43 Using the Report Creation Wizard 43 Creating a report with the Standard Report Creation Wizard 44 Using other report-creation wizards 49 Starting with a Blank Report 49 Connecting Your Report to Its Data Source 50 Accessing database files directly 51 Connecting to ODBC data sources 51 Retrieving data with SQL 52 Reporting on data in OLE DB data sources 53 Which interface should you use? 53 Part II: Moving Up to Professional-Quality Reports 55 Chapter 5: Pulling Specific Data from a Database 57 Get Data Quickly with Select Expert 57 Using Formulas to Retrieve Data 64 Using Parameter Fields to Retrieve Data at Runtime 66 Step 1: Creating a report that shows everything 67 Step 2: Giving the user the power to decide what to show 70 Speed retrievals with indexes 72 Changing parameter values to change the report 72 Troubleshooting Tips When Retrieving Data 73 Chapter 6: Sorting, Grouping, and Totaling Report Data 75 Sorting Report Data 75 Sorting based on multiple fields 77 Sorting and performance 81 Adding Sort Controls to a Report 82 Grouping Related Items 85 Calculating Percentages 89 Drilling Down for Detail 90 Keeping Track of Things with Running Totals 94 Troubleshooting Sorting, Grouping, and Totaling Problems 97 Sorting problems and how to solve them 98 Unusual grouping options 98 Getting the right totals 99 Chapter 7: Mastering Report Sections 101 Changing the Size of a Section 101 Formatting with the Section Formatting Menu 103 Using Section Expert for Easy Section Formatting 104 Common tab, Section Expert 105 Paging tab, Section Expert 106 Color tab, Section Expert 107 Placing Groups Where You Want Them 110 Starting each group at the top of its own page 110 Printing totals at the bottom of a page 112 Restarting page numbering at the beginning of each group 113 Hiding Details with Summary and Drill-Down Reports 113 Generating Barcodes 114 Creating Mailing Labels 117 Saving Money on Postage with a ZIP Sort 120 Chapter 8: Enhancing Your Report’s Appearance 123 Absolute Formatting 124 Setting the fonts and their formatting for emphasis 124 Adding graphical elements for emphasis 128 Conditional Formatting Using the Format Editor 130 Creating Emphasis with Highlighting Expert 132 Adding Pictures to Your Report 134 Aligning Preprinted Forms 136 Adding Text from a File 136 Formatting Options 137 Special Fields Contain Report Metadata 139 Raising a Red Flag with Report Alerts 139 Using Report Templates to Save Time and Effort 142 Applying a template to a report 143 Applying a template to an existing report 143 Applying a template to a report you’re creating 145 Part III: Advanced Report Types and Features 147 Chapter 9: Displaying Your Top Ten (Or Top N) with Group Sort 149 Sorting Groups Based on Performance 149 Starting a Top N Report 150 Displaying a group total 154 Hiding the details 155 Removing page breaks 157 Going with the Percentages 160 What if you want the top 17 instead of the top 5? 161 A Choice of Group Sorts 164 Troubleshooting Group Sort Problems 165 Chapter 10: Adding Formulas to Reports 167 Formula Overview and Syntax 167 Lessening the Workload with Functions 168 Creating a Custom Function in Formula Workshop 169 Formula Editor 173 Formula Expert 175 SQL Expression Editor 177 Selection formulas 177 Formatting formulas 181 Changing and Deleting Formulas 182 Data Types 182 Simple data types 182 Range data types 184 Array data types 184 Variables in Formulas 185 Declaring a variable 185 Assigning a value to a variable 186 Control Structures 186 If-Then-Else 186 Select Case 187 For loop 187 While Do loop 188 Do While loop 189 Chapter 11: Creating Reports within a Report 191 Combining Unrelated Reports 191 Underlay formatting for side-by-side location of subreport 195 Drilling down in a subreport 196 Linking a Subreport to a Primary Report 197 On-Demand Subreports Boost Efficiency 203 Passing Data between Reports 204 Troubleshooting Subreport Problems 205 Chapter 12: Combining Report Elements with OLE 207 Overview of OLE 207 Static OLE Objects 208 Inserting a static OLE object into a report 208 Making a static OLE object editable 210 Embedded OLE Objects 212 Embedding an OLE object into a report 212 Linked OLE Objects 214 Embedding or Linking an Object Taken from a File 217 Integrating Shockwave Flash Objects into Your Reports 217 Chapter 13: Creating and Updating OLAP Reports 219 What’s OLAP, and Why Might You Need It? 219 Who uses OLAP? 220 Creating multidimensional views 220 Connecting to an OLAP data source 221 OLAP Reporting with Crystal Reports 221 Operating on OLAP grid objects 222 Creating a three-dimensional report 222 Updating an OLAP Report 232 Formatting Data in an OLAP Report 233 Changing a dimension’s background color 234 Creating an alias for a dimension 235 Formatting grid lines 236 Labeling dimensions 237 Changing Data Appearance in an OLAP Report 238 Showing and hiding dimensions 239 Adding totals to an OLAP grid 240 Pivoting an OLAP grid 240 Reordering fields 241 Sorting data 242 Filtering data 243 Making calculations 243 Chapter 14: Using Cross-Tab Reports to Mine Your Data 245 Creating a Cross-Tab Object to Summarize All Report Data 245 Summarizing the Contents of a Group with a Cross-Tab 249 Making Calculations within a Cross-Tab Row or Column 255 Enhancing the Appearance and Readability of a Cross-Tab Object 256 Changing the width and height of cross-tab cells 256 Formatting entire rows and columns 257 Formatting individual fields 257 Suppressing selected cross-tab data 258 Printing cross-tabs that span multiple pages 258 Chapter 15: Enhancing Reports with Charts 259 Using Chart Expert 259 Type tab 260 Data tab 260 Axes tab 261 Options tab 262 Color Highlight tab 263 Text tab 263 Creating a Chart 263 Drilling down from a chart 266 Changing a chart 267 Choosing the Best Chart Type for Your Data 267 Side-by-side bar chart 267 Percent bar chart 268 Line chart 268 Area chart 269 Pie chart 270 Doughnut chart 270 3-D riser chart 271 3-D surface chart 272 XY scatter chart 272 Radar chart 273 Bubble chart 273 Stock chart 274 Numeric axis chart 275 Gauge chart 276 Gantt chart 276 Funnel chart 277 Histogram 278 Different Chart Layouts for Different Data Types 278 Seeing How Chart Placement Affects the Data It Represents 280 Troubleshooting Chart Problems 281 Selecting data to make a chart readable and meaningful 281 The placement of chart elements matters 282 Chapter 16: Adding Geographic Detail with Maps 283 Choosing the Right Crystal Reports Map 283 Map layouts 284 Map types 284 Map placement 286 Creating a Map Step by Step 286 Creating an advanced layout map 286 Creating a Group layout map 288 Creating a Cross-Tab layout map 289 Creating an OLAP layout map 290 Including maps in subreports 291 Changing maps 291 Troubleshooting Map Problems 291 Chapter 17: Interactivity Features 293 Crystal Xcelsius Overview 293 Adding Xcelsius Capability to a Report 294 Creating an SWF file with Crystal Xcelsius 295 Embedding your Crystal Xcelsius model in a Crystal report 298 Enhancing a Report with the Tasteful Use of Flash 300 Viewing Flash visualizations 300 Dynamic interaction with a report using a Parameter panel 300 Part IV: Crystal Reports in the Enterprise 303 Chapter 18: Crystal Reports Server 305 Connecting to Data Sources 306 Connecting directly or indirectly 306 Using Business Views to simplify connectivity 306 Formatting Reports with Crystal Reports Developer 307 Providing Platform Services 307 Publishing and distributing reports 307 Providing security 308 Managing the system 308 Useful Management Tools 309 Application Services 309 Web Services 309 Viewing and Interacting with Reports 310 Chapter 19: BusinessObjects Enterprise Repository 311 Adding Folders to Your Repository 312 Storing Your Valuables in BusinessObjects Enterprise Repository 312 Adding text and bitmapped objects to the Repository 313 Adding custom functions to the Repository 313 Adding SQL commands to the Repository 314 Using Repository Objects in a Report 314 Adding text objects and images 314 Adding custom functions 315 Adding SQL commands 315 Modifying a Repository Object 315 Deciding Whether to Update Reports Automatically 317 Deleting Objects from the Repository 318 Chapter 20: Navigating with Report Parts 319 Understanding Report Parts Navigation 319 Using Report Parts to Navigate a Report 320 Using the Report Parts Drill-down method 321 Using the Another Report Object method 325 Part V: Publishing Your Reports 327 Chapter 21: Sending Your Reports Out into the World 329 Printing Your Report 329 Faxing a Report 330 Exporting a Report 331 Export format types 331 Export destinations 334 Troubleshooting Output Problems 342 Chapter 22: Displaying Reports Online 343 Exporting to a Static HTML Page 344 Adding a Hyperlink to a Report 346 Distributing Reports via crystalreports.com 349 Integrating with salesforce.com 350 Publishing to crystalreports.com with Crystal Reports Desktop Publisher 351 Interactive Report Viewing with Crystal Reports Viewer 354 Opening a report in Crystal Reports Viewer 355 Navigating a report 355 Printing a report 359 E-mailing reports to your friends and co-workers 360 Sharing reports in a variety of formats 360 Searching a haystack for that elusive needle 361 Accessing reports on crystalreports.com 361 Chapter 23: SQL Expression Fields 363 Creating an SQL Statement 363 Modifying an SQL Statement 366 Part VI: The Part of Tens 369 Chapter 24: Ten Things to Do Before You Create a Report 371 Chapter 25: Ten Ways to Give Your Reports More Pizzazz 375 Index 379
£16.99
John Wiley & Sons Inc Microsoft Office 2008 for Mac Bible
Book SynopsisOffers readers instructions on using the Microsoft Office suite: Word, Excel, PowerPoint, and Entourage. This title also reviews creating, editing, formatting, and sharing digital documents with Word; gathering and analyzing information with Excel; creating dynamic presentations with PowerPoint; and using the e-mail and calendar of Entourage.Table of ContentsAbout the Authors. Preface. Acknowledgments. Part I: Getting to Know Office 2008. Chapter 1: Introducing the New Office. Chapter 2: Installing Office 2008. Chapter 3: Office 2008 Program Basics. Chapter 4: Finding Help with Office 2008. Part II: Working with Word. Chapter 5: Word Basics. Chapter 6: Building Word Documents. Chapter 7: Formatting Word Text. Chapter 8: Adding Tables. Chapter 9: Editing Lengthy Documents. Chapter 10: Collaborating on Documents. Chapter 11: Proofing and Printing Documents. Part III: Using Excel. Chapter 12: Excel Basics. Chapter 13: Entering and Editing Data. Chapter 14: Formatting Data and Worksheets. Chapter 15: Using Formulas and Functions. Chapter 16: Creating Charts. Chapter 17: Using the Excel Database Tools. Chapter 18: Proofing, Printing, and Collaborating in Excel. Part IV: Presenting with PowerPoint. Chapter 19: PowerPoint Basics. Chapter 20: Building Presentations. Chapter 21: Formatting Slides. Chapter 22: Fine-tuning a Presentation. Chapter 23: Preparing and Presenting a Slide Show. Part V: Working with Entourage. Chapter 24: Entourage Basics. Chapter 25: E-mailing with Entourage. Chapter 26: Organizing Your Calendar. Chapter 27: Tracking Tasks, Notes, and Projects. Part VI: Organizing Digital Media with Expression Media. Chapter 28: Introducing Expression Media. Chapter 29: Working with Catalogs. Part VII: Working with Office Graphics and Web Features. Chapter 30: Adding Graphics. Chapter 31: Creating Web Content. Chapter 32: Using Microsoft Messenger. Part VIII: Coordinating and Customizing Your Office. Chapter 33: Coordinating Projects. Chapter 34: Customizing Office. Chapter 35: Working with AppleScript. Index.
£34.00
John Wiley & Sons Inc SugarCRM For Dummies
Book SynopsisSugarCRM is an innovative customer relationship management software solution that enhances your company's marketing effectiveness, drives sales performance, improves customer satisfaction, and provides executive insight into business performance.Table of ContentsIntroduction. Part I: Adding Sugar to Your Life. Chapter 1: Adding Sugar to Your Life. Chapter 2: Acquiring a Sweet Tooth. Chapter 3: Finding Your Way Around Sugar. Chapter 4: Working with Accounts, Contacts, and Leads. Part II: Cooking with Sugar. Chapter 5: Keeping Track of the Sweet Things in Life. Chapter 6: Creating a Project Isn’t a Major Project. Chapter 7: Working with Opportunities. Chapter 8: Working with Documents. Chapter 9: Watching Your Sugar Content. Part III: A Spoonful of Sugar Keeps Your Customers Happy. Chapter 10: Adding a Bit of Case Management. Chapter 11: Keeping Bugs Out of the Sugar Bowl. Part IV: Sharing the Sugar Bowl. Chapter 12: Adding Sugar to Your E-mail. Chapter 13: Campaigning Doesn’t Just Occur in an Election Year. Part V: Working with Extra-Strength Sugar. Chapter 14: Sweetening the Deal. Chapter 15: Adding an Extra Lump of Sugar. Chapter 16: The Administrator’s Recipe Book. Part VI: The Part of Tens. Chapter 17: Ten Reasons to Upgrade to the Professional or Enterprise Version. Chapter 18: Ten Ways to Make Your Life Even Sweeter. Chapter 19: Ten Ways to Become a Master Sugar Chef. Index.
£21.59
John Wiley & Sons Inc The IT Value Network
Book SynopsisLearn to measure and manage the real value of IT investment and spending IT investments are becoming more than just business enablers or assets on the books; they provide capability that can drive the business. Thought leadership should migrate towards information investment, getting a bigger bang for the buck from the ''I'' in IT and from the ''I'' in CIO. The IT Value Network: From IT Investment to Stakeholder Economic Value incorporates new emerging decision support methods, such as real options, which are considered to complement traditional financial measures. Organizational and informational economic based techniques are also incorporated to manage and assess IT investments, including the balanced scorecard (BSC), and investment and portfolio management; in addition to coverage of IT key performance indicators and competitive benchmarking. Selected as a top 10 best IT-Business book for 2009 by CIO Insight - Praises for The IT Value Network: From IT InvTable of ContentsForeword. Preface. Acknowledgments. PART I STATUS QUO—WHERE’S THE VALUE? CHAPTER 1 IT Investment. Sticker Shock. Six Decades of IT Investment. IT Investment Trends. IT Investment Classification: The Four "S" Category Model. Future IT Investment. CHAPTER 2 Conventional IT Valuation. Bottom Line. Maximizing Shareholder Value. Conventional Asset Valuation. Challenging Conventional Norms. Lost Value. CHAPTER 3 Banking Value. Financial Services Industry Global IT Investment. North American Banking Industry. North American Banking Market Challenges. Banking Industry IT Value Observations. NA Bank Case: IT Investment Observations. PART II TRIANGULATING THE VALUE—SOMEWHERE HERE. CHAPTER 4 IT Value Network Measurement. Identifying Investment. Justifying Investment. Prioritizing Investment. Selecting Investment. Performance of Investment. Realizing Value from Investment. CHAPTER 5 IT Value Network Measures: Financial-Based Methods. Traditional Financial and Accounting Techniques. Emerging Financial Techniques. Emerging Decision-Support Techniques. Value-Creation Business Case. CHAPTER 6 IT Value Network Measures: Organization-Based Methods. Conventional Planning Techniques. Emerging Organizational Management Techniques. Emerging Information Economics Techniques. CHAPTER 7 Triangulating IT Investment Value. Value Index and Value Lenses. IT Value Portfolio. PART III SIX DEGREES OF IT VALUE—THERE IT IS. CHAPTER 8 IT Value Network Management. Value Capture. Value Enabling. Value Optimization. Value Realization. CHAPTER 9 First Degree of IT Value. Value System. Process and System Improvement. CHAPTER 10 Second Degree of IT Value. Strategic Planning. Portfolio Governance. CHAPTER 11 Third Degree of IT Value. IT Systems and Infrastructure Capability and Capacity. Organization and People Capability and Capacity. CHAPTER 12 Fourth Degree of IT Value. Program and Project Management. System Management. CHAPTER 13 Fifth Degree of IT Value. Service Management. Information Management. CHAPTER 14 Sixth Degree of IT Value. Networked Value Management. PART IV IT VALUE NETWORK CLIENTS—DID IT, GOT IT. CHAPTER 15 NA Bank. Challenge: Strategic IT Investment Alignment. Solution: The IT Value Network. Impact: IT Investment Redirection for Higher Value Capture. CHAPTER 16 Nortel Networks. Challenge: Speed of Market Change. Solution: The IT Value Network. Impact: IT Reorganization and Improved Capability for Value Enabling. CHAPTER 17 Indigo Books & Music. Challenge: Project Management. Solution: The IT Value Network. Impact: Project Management Office for Value Optimization. CHAPTER 18 NA Credit Union. Challenge: Credit Union Merger. Solution: The IT Value Network. Impact: Successful Bank Integration for Value Realization. PART V EMERGING REALITY—DO IT, VALUE IT. CHAPTER 19 Forward Thinking. Value Networks. Value Systems. Value Options. Maximizing Stakeholder Economic Value. CHAPTER 20 Connecting the Dots. IT Value Network Maturity Model. IT Value Network Checklist. Collaboration for Network Advantage. Value IT. Glossary. Notes. About the Author. Index.
£26.24
Wiley Excel 2010 Formulas
Book Synopsis
£34.19
