Business applications Books
Pearson Education Artificial Intelligence for Business
Book SynopsisDoug Rose has been transforming organizations through technology, training, and process optimization for more than 25 years. He is the author of the Project Management Institute (PMI) first major publication on the agile framework, Leading Agile Teams. He is also the author of Data Science: Create Teams That Ask the Right Questions and Deliver Real Value and Enterprise Agility for Dummies. Doug has a master degree (MS) in information management, a law degree (JD) from Syracuse University, and a BA from the University of Wisconsin-Madison. He is also a Scaled Agile Framework Program Consultant (SPC), Certified Technical Trainer (CTT+), Certified Scrum Professional (CSP-SM), Certified Scrum Master (CSM), PMI Agile Certified Professional (PMI-ACP), Project Management Professional (PMP), and Certified Developer for Apache Hadoop (CCDH). You can attend his lively and engaging business and project management courses at the University of Chicago or oTable of ContentsForeword xv Preface xix PART I: Thinking Machines: An Overview of Artificial Intelligence 1 Chapter 1: What Is Artificial Intelligence? 3 What Is Intelligence? 4 Testing Machine Intelligence 6 The General Problem Solver 8 Strong and Weak Artificial Intelligence 11 Artificial Intelligence Planning 14 Learning over Memorizing 15 Chapter Takeaways 18 Chapter 2: The Rise of Machine Learning 19 Practical Applications of Machine Learning 22 Artificial Neural Networks 24 The Fall and Rise of the Perceptron 27 Big Data Arrives 30 Chapter Takeaways 33 Chapter 3: Zeroing in on the Best Approach 35 Expert System Versus Machine Learning 35 Supervised Versus Unsupervised Learning 37 Backpropagation of Errors 38 Regression Analysis 41 Chapter Takeaways 43 Chapter 4: Common AI Applications 45 Intelligent Robots 45 Natural Language Processing 48 The Internet of Things 50 Chapter Takeaways 51 Chapter 5: Putting AI to Work on Big Data 53 Understanding the Concept of Big Data 54 Teaming Up with a Data Scientist 54 Machine Learning and Data Mining: What’s the Difference? 55 Making the Leap from Data Mining to Machine Learning 56 Taking the Right Approach 57 Chapter Takeaways 59 Chapter 6: Weighing Your Options 61 Chapter Takeaways 64 PART II: Machine Learning 65 Chapter 7: What Is Machine Learning? 67 How a Machine Learns 71 Working with Data 74 Applying Machine Learning 77 Different Types of Learning 79 Chapter Takeaways 81 Chapter 8: Different Ways a Machine Learns 83 Supervised Machine Learning 83 Unsupervised Machine Learning 86 Semi-Supervised Machine Learning 89 Reinforcement Learning 91 Chapter Takeaways 93 Chapter 9: Popular Machine Learning Algorithms 95 Decision Trees 99 k-Nearest Neighbor 101 k-Means Clustering 104 Regression Analysis 108 Naive Bayes 110 Chapter Takeaways 113 Chapter 10: Applying Machine Learning Algorithms 115 Fitting the Model to Your Data 119 Choosing Algorithms 120 Ensemble Modeling 121 Deciding on a Machine Learning Approach 123 Chapter Takeaways 124 Chapter 11: Words of Advice 125 Start Asking Questions 125 Don’t Mix Training Data with Test Data 127 Don’t Overstate a Model’s Accuracy 127 Know Your Algorithms 128 Chapter Takeaways 128 PART III: Artificial Neural Networks 129 Chapter 12: What Are Artificial Neural Networks? 131 Why the Brain Analogy? 133 Just Another Amazing Algorithm 133 Getting to Know the Perceptron 135 Squeezing Down a Sigmoid Neuron 138 Adding Bias 141 Chapter Takeaways 142 Chapter 13: Artificial Neural Networks in Action 143 Feeding Data into the Network 143 What Goes on in the Hidden Layers 145 Understanding Activation Functions 149 Adding Weights 151 Adding Bias 152 Chapter Takeaways 153 Chapter 14: Letting Your Network Learn 155 Starting with Random Weights and Biases 156 Making Your Network Pay for Its Mistakes: The Cost Function 157 Combining the Cost Function with Gradient Descent 158 Using Backpropagation to Correct for Errors 160 Tuning Your Network 163 Employing the Chain Rule 164 Batching the Data Set with Stochastic Gradient Descent 166 Chapter Takeaways 167 Chapter 15: Using Neural Networks to Classify or Cluster 169 Solving Classification Problems 170 Solving Clustering Problems 172 Chapter Takeaways 174 Chapter 16: Key Challenges 175 Obtaining Enough Quality Data 175 Keeping Training and Test Data Separate 176 Carefully Choosing Your Training Data 177 Taking an Exploratory Approach 177 Choosing the Right Tool for the Job 178 Chapter Takeaways 178 PART IV: Putting Artificial Intelligence to Work 179 Chapter 17: Harnessing the Power of Natural Language Processing 181 Extracting Meaning from Text and Speech with NLU 183 Delivering Sensible Responses with NLG 184 Automating Customer Service 186 Reviewing the Top NLP Tools and Resources 187 NLU Tools 189 NLG Tools 190 Chapter Takeaways 191 Chapter 18: Automating Customer Interactions 193 Choosing Natural Language Technologies 195 Review the Top Tools for Creating Chatbots and Virtual Agents 196 Chapter Takeaways 198 Chapter 19: Improving Data-Based Decision-Making 199 Choosing Between Automated and Intuitive Decision-Making 201 Gathering Data in Real Time from IoT Devices 202 Reviewing Automated Decision-Making Tools 204 Chapter Takeaways 205 Chapter 20: Using Machine Learning to Predict Events and Outcomes 207 Machine Learning Is Really about Labeling Data 208 Looking at What Machine Learning Can Do 210 Predict What Customers Will Buy 210 Answer Questions Before They’re Asked 210 Make Better Decisions Faster 212 Replicate Expertise in Your Business 213 Use Your Power for Good, Not Evil: Machine Learning Ethics 214 Review the Top Machine Learning Tools 216 Chapter Takeaways 218 Chapter 21: Building Artificial Minds 219 Separating Intelligence from Automation 221 Adding Layers for Deep Learning 222 Considering Applications for Artificial Neural Networks 223 Classifying Your Best Customers 224 Recommending Store Layouts 225 Analyzing and Tracking Biometrics 226 Reviewing the Top Deep Learning Tools 228 Chapter Takeaways 229 Index 231
£20.69
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
Microsoft Press,U.S. Code Complete
Book SynopsisSteve McConnell is recognized as one of the premier authors and voices in the development community. He is Chief Software Engineer of Construx Software and was the lead developer of Construx Estimate and of SPC Estimate Professional, winner of Software Development magazine's Productivity Award. He is the author of several books, including Code Complete and Rapid Development, both honored with Software Development magazine's Jolt Award.Table of ContentsWelcome to software construction Metaphors for a richer understanding of software development Measure twice, cut once: Upstream prerequisites Key construction decisions Design in construction Working classes High-Quality routines Defensive programming The Pseudocode programming process General issues in using variables The power of variable names Fundamental data types Unusual data types Organizing straight-line code Using conditionals Controlling loops Unusual control structures Table driven methods General control issues The software-quality landscape Collaborative construction Developer testing Debugging refactoring Code tuning strategies How program size affects construction Integration Programming tools Layout & style Self documenting code Personal character Themes in software craftsmanship
£36.44
Pearson Education Limited Business Intelligence A Managerial Approach
Book SynopsisFor courses on Business Intelligence or Decision Support Systems.A managerial approach to understanding business intelligence systems.To help future managers use and understand analytics, Business Intelligence provides students with a solid foundation of BI that is reinforced with hands-on practice.Table of ContentsChapter 1 An Overview of Business Intelligence, Analytics, and Data Science Chapter 2 Descriptive Analytics I: Nature of Data, Statistical Modeling, and Visualization Chapter 3 Descriptive Analytics II: Business Intelligence and Data Warehousing Chapter 4 Predictive Analytics I: Data Mining Process, Methods, and Algorithms Chapter 5 Predictive Analytics II: Text, Web, and Social Media Chapter 6 Prescriptive Analytics: Optimization and Simulation Chapter 7 Big Data Concepts and Tools Chapter 8 Future Trends, Privacy and Managerial Considerations in Analytics
£62.69
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 SharePoint For Dummies
Book SynopsisUnlock the potential of Microsoft's powerfulweb-based collaborative platformthat comes standard withMicrosoft365 Microsoft SharePointunlocks millions ofcollaborative and remote workingcapabilities and possibilities. And using it doesn't require a degree in computer science! WithSharePoint For Dummies, you'll be creating sites, working with lists, and integrating withMicrosoftTeams in no time at all. This bookoffers fully illustrated, step-by-step instructions to adapt and customize SharePoint for your own organization.Perfect for complete SharePoint novices as well as veterans of previous versions, you'll learn to manage and work with enterprise contentand use the SharePoint mobile app. This handy guide alsowalks you through: Creating integrated, online portals from scratch for everyone in your organization to use How to navigate the SharePoint interface like a pro, without any prior knowledge Using SharePoint alongsiTable 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: Getting Started with SharePoint 5 Chapter 1: Getting to Know SharePoint 7 Up and Running with SharePoint in Three Minutes Flat 8 Wrapping Your Head around SharePoint 13 No, really, what is SharePoint? 13 A Microsoft product 15 Many different SharePoint definitions 15 More than a website 18 Taking a Peek at a SharePoint Site 19 Getting Familiar with SharePoint Terminology 21 Branding 21 Business intelligence (BI) 21 eDiscovery 22 Identity management 22 Mobile 23 Records management and compliance 23 Search 24 Social 24 Web content management 24 Workflow 25 Chapter 2: Introducing SharePoint in Microsoft 365 27 Accessing and Using SharePoint 28 Getting Familiar with SharePoint Online 28 Determining What Version of SharePoint You Are Using 30 Understanding Why SharePoint Online Has Become So Popular 30 Differences between SharePoint Online and SharePoint On-Premises 31 Exploring the Benefits of SharePoint Online 33 Data center and hardware 33 Software platform 34 Backup, redundancy, and security 35 Chapter 3: Wrangling SharePoint Functionality 37 Coming to Terms with Website Templates 38 Show Me the Apps 39 Working with Web Pages 40 Site page 42 Wiki page 42 Web Part page 42 Publishing page 43 Understanding Web Parts 43 Digging into SharePoint Features 44 Integrating with Office 45 Part 2: Diving Headfirst into SharePoint 47 Chapter 4: Discovering SharePoint in Your Pocket 49 Installing the SharePoint Mobile App 49 Installing on iOS 50 Installing on Android 50 Signing into the SharePoint Mobile App 51 Finding Your SharePoint Stuff with the Find Tab 53 Exploring a SharePoint site 54 Opening navigation 55 Getting the Latest News with the News Tab 56 All About You with the Me Tab 57 Chapter 5: Understanding SharePoint Sites 61 Accessing SharePoint Sites in Microsoft 365 61 Exploring the SharePoint Team Site 64 Finding your way around 64 Uploading documents 65 Sharing your Team site 66 Creating a SharePoint Site 70 Create a subsite from your web browser 70 Create a site from the SharePoint Mobile App 72 Requesting a SharePoint Site 74 Grouping Sites with Hub Sites 75 Chapter 6: Working with Web Pages and Web Parts 77 Understanding SharePoint Web Pages 78 Creating a Site page 78 Creating a Web Part page 80 Creating a Wiki page 82 Introducing the Ribbon 83 Deciding What Type of Page to Create 84 Digging into Web Parts 85 Adding a Web Part to Your Page 85 Choosing the Right Web Part 89 Changing Web Part Properties 92 Reviewing Web Part properties 92 Editing Web Part properties 93 Minimizing or deleting Web Parts 94 Connecting Web Parts 95 Managing Pages 97 Categorizing Your Wiki Pages 98 Taking a Peek into Custom Page Designs 99 Chapter 7: Adding Content to SharePoint 101 SharePoint as a Content Management System 101 Wrangling the Overwhelming Mountain of Digital Content 102 Getting Your Documents into SharePoint 103 Uploading a single document 104 Uploading multiple documents 106 Updating document properties using Edit in Grid view 106 Creating New Content in SharePoint 108 Using the SharePoint Mobile App to Peek at Content on the Go 109 Chapter 8: Discovering SharePoint in Microsoft Teams 113 Using Teams in Microsoft 365 114 Understanding the Marriage of SharePoint and Teams 116 Accessing SharePoint files in Teams 116 Using the Teams wiki and finding it in SharePoint 118 Adding SharePoint Pages and Lists to Teams 119 Chapter 9: Working with SharePoint from Microsoft Office 123 Getting Familiar with Office Versioning 124 Working with Office on Your Desktop or Laptop 124 Installing Microsoft Office 125 Saving a new document to SharePoint 127 Opening a document from SharePoint 129 Working with Office on Your Smartphone or Tablet 131 Saving a new document to SharePoint 131 Opening a document from SharePoint 133 Chapter 10: Getting Social 135 Sharing and Following SharePoint Sites 136 Setting up alerts 139 Managing alerts 142 Staying Up to Date with News 143 Information Sharing with Blog Style Sites and Wikis 144 Creating a blog-style site 145 Publishing a new post 145 Using wikis to collaborate and coauthor 146 Communicating with Discussion Boards 149 Creating a Discussion Board app 149 Posting and replying to a subject 149 Connecting with Others Using RSS Feeds 151 Viewing RSS feeds 151 Reading RSS feeds with Outlook 153 Part 3: Customizing SharePoint 155 Chapter 11: Customizing SharePoint with Apps 157 Introducing SharePoint Apps 158 Adding Apps to Your Site 159 Accessing App Settings 160 Configuring the General Settings 164 Changing the title, description, and navigation 164 Versioning settings 164 Advanced settings 167 Validation settings 171 Audience Targeting settings 172 Rating settings 172 Form settings 173 Chapter 12: Developing a Custom App 175 Planning Your App 176 Creating Your App 176 Adding columns to your app 177 Working with the Title column 184 Importing a Spreadsheet as an App 186 Taking Your App to the Next Level: Calculated and Lookup Columns 188 Creating a calculated column 188 Using a lookup column 190 Keeping Track of Locations 191 Downloading Apps from the SharePoint Store 191 Chapter 13: Taking Control of Your Profile and Content 193 Organizing Your Personal Content with OneDrive 193 Saving stuff with OneDrive 195 Creating or uploading documents in your OneDrive 196 Expressing Yourself with Your Profile 198 Creating a holistic profile experience 198 Filling in your profile information 199 Tracking Your Favorite Sites 201 Chapter 14: Organizing and Viewing Content 203 Working with Documents 204 Using the ellipsis 204 Editing a document’s properties 206 Viewing documents in the browser 208 Sharing Your Documents 209 Recovering Deleted Documents 209 Uploading Documents into a Folder 211 Discovering SharePoint Views 215 Switching the view 215 Getting to know view formats 217 Creating a Standard View 217 Choosing columns for your view 220 Filtering apps with views 221 Grouping results 222 Quickly edit app data with Edit In Grid View (a.k.a Quick Edit) 223 Choosing a display style 225 Managing App Data in a Datasheet View 225 Using Ad Hoc Views 226 Creating a Calendar View 227 Displaying Tasks in a Gantt View 228 Managing Existing Views 229 Modifying your views 229 Setting the default view 229 Other SharePoint built-in views 230 Displaying Views via Web Parts 230 Chapter 15: Creating Workflows with Microsoft Power Automate 231 Understanding Workflow 232 Introducing Microsoft Power Automate 232 Signing into Microsoft Power Automate 232 Getting familiar with Power Automate 233 Building your first flow 236 Using the Traditional SharePoint-Only Workflow 240 Chapter 16: Getting Answers with Microsoft Forms 243 Signing into Microsoft Forms 243 Creating a Form in Microsoft Forms 244 Analyzing Microsoft Forms Data 247 Displaying a Form in SharePoint 248 Capturing Forms Data in SharePoint 250 Part 4: Becoming a SharePoint Administrator 251 Chapter 17: Building Business Apps with Power Apps 253 Introducing Power Apps 253 Signing into Power Apps 254 Getting familiar with Power Apps 254 Building your first Power App 256 Sharing your Power App 260 Using Power Apps on your Mobile Device 261 Embedding a Power App within a SharePoint Page 261 Viewing SharePoint Sites in a Web Browser on a Mobile Device 262 Creating views for small screens 263 Targeting devices using channels 263 Chapter 18: Realizing You Are a SharePoint Administrator 265 Changing Your Site’s Basic Information 266 Finding Site Settings 267 Digging into Site Settings 269 Look and Feel 269 Site Actions 272 Site Collection Administration 272 Microsoft Search 273 Web Designer Galleries 273 Site Administration 275 Search 275 Getting a High-Level View of SharePoint Features 277 Turning Features On and Off 278 Exploring Common Features 279 Extending SharePoint with Features 280 Changing the Look and Feel of Your Site 280 A note on fonts 283 A word on usability 284 The benefits of composed looks 285 Checking Out SharePoint Metrics 285 Chapter 19: Configuring Site Navigation 287 Changing Team Site Navigation 288 Staying local with Quick Launch 288 Adding quick links to a page 290 Taking on Advanced Navigation 294 Configuring SharePoint navigation 294 Configuring global navigation 295 Configuring current navigation 296 Configuring Static Navigation 297 Navigating with Web Parts 300 Understanding Managed Navigation 301 Chapter 20: Creating a Client or Partner Portal 303 Sharing a Site with External Guests 303 Inviting Guests Using Outlook Groups 308 Planning for Your Client or Guest Portal 308 Launching Your Portal 310 Creating a Public-Facing Website 311 Chapter 21: Securing SharePoint 313 Using SharePoint Groups 314 Adding users to a group 315 Understanding the permission structure 316 Securing a site collection 318 Securing Apps, Folders, Documents, and Items 319 Creating unique permissions for a subsite 320 Removing existing permissions 321 Creating unique permissions for an app or document 321 Managing permissions scenarios 323 Viewing a group’s permissions 324 Checking a user’s permissions 325 Granting Administrative Access 327 Viewing Site Permissions 328 Locking Down a Partner Portal 331 Permissions in SharePoint Online versus SharePoint On-Premises 332 Going Further with Custom Permissions 332 Part 5: Managing Enterprise Content 335 Chapter 22: Managing Content and the Content Lifecycle 337 Starting Simple: Co-Authoring 338 Checking a Document In and Out 338 Configuring Content Approval 340 Turning on content approval 341 Identifying approvers 343 Casting an approving eye 343 Disapproving: Not just for stern parents 345 Getting alerts on approval/rejection status 346 Digging into a SharePoint Records Center 346 Defining the terms 346 Creating information management policies 347 Setting Up a Records Center 351 Using the Content Organizer 353 Managing Records in Place 355 Placing Records on Litigation Hold 356 Chapter 23: Finding What You Need with Search 359 Understanding How SharePoint Search Works 359 Searching for Content 360 Searching for a string using quotation marks 361 Wildcard searches 362 Including and excluding terms 362 Building compound search queries using Boolean operators 363 Getting fancy with the parentheses 363 Finding terms in proximity 364 Same meaning, different terms 364 Viewing and Refining Search Results 365 Making Search Your Users’ Best Friend 366 Removing Content from Search Results 372 Reviewing Search Analytics 373 Adding a Search Center Site 373 Chapter 24: Integrating with Power BI 377 Signing into Power BI 377 Installing the Power BI Desktop 378 Building Your First Power BI Report 380 Pulling Data into Power BI from SharePoint 383 SharePoint Library app 384 SharePoint List app 386 Displaying a Power BI Report on a SharePoint Page 386 Part 6: The Part of Tens 389 Chapter 25: Ten Hot SharePoint Topics 391 Getting Up to Speed with SharePoint 391 SharePoint Online Videos 392 SharePoint Online Official Documentation 392 SharePoint Development 392 SharePoint Power Automate 393 Taking SharePoint for a Spin 393 Staying Current: The SharePoint Blog 394 New On-Premises Features in SharePoint Server 394 Plan for SharePoint 394 SharePoint from the Leader 395 Chapter 26: Ten Ways to Maintain Control with Governance 397 Failure Is Not an Option (Neither Is Looking Away and Whistling) 398 Getting Executive Buy-In and Support 398 Building an Effective Governance Group 398 Finding the Right Level 399 Yours, Mine, Ours: Deciding Who Owns What 399 (Re)Visiting Social Networking Policies 400 Applying Consistent Design and Branding 400 Implementing Effective Content Management 401 Reusing Web Parts 401 Keeping Things Current: Web Operations Management 401 Chapter 27: Ten Ways to Become a SharePoint Server Guru 403 Getting Information from the Horse’s Mouth 404 Reading SharePoint Blogs 405 Finding Local User Groups 406 Building a Virtual Lab 406 Starting with a Good Foundation 407 Borrowing from Others 407 Getting Certified 408 Taking a Peek under the Covers 408 Digging Deeper under the Covers 408 Deconstructing a SharePoint Site 409 Index 411
£23.74
London Publishing Partnership Digital Transformation at Scale: Why The Strategy
Book SynopsisThis book is for people worrying about their sinking ship. Based on experience, it is a guide for navigating the blockers, buzzwords and bloody-mindedness that doom any analogue organisation trapped into thinking that while the internet has changed the world, it won't change their world. Companies that grew up on the web have changed our expectations of the services we rely on. We demand simplicity, speed and low cost. Organizations founded before the Internet aren't keeping up - despite spending millions on IT, marketing and 'innovation'. This revised, expanded second edition of Digital Transformation at Scale is a guide to building a digital institution. It explains how a growing band of reformers in businesses and governments around the world have helped their organizations pivot to this new way of working, and what lessons others can learn from their experience. It is based on the authors' experience designing and helping to deliver the UK's Government Digital Service (GDS). The GDS was a new institution made responsible for the digital transformation of government, designing public services for the Internet era. It snipped £4 billion off the government's technology bill, opened up public sector contracts to thousands of new suppliers, and delivered online services so good that citizens chose to use them over the offline alternatives, without a big marketing campaign. Other countries and companies noticed, with the GDS model now being copied around the world.Trade Review"Now more than ever we need to take the chance to shape the digital world as it shapes us. All governments and large organisations must take part. The story in this powerful book is essential reading." — Martha Lane Fox, Baroness Lane-Fox of Soho; "Business transformation is hard. Government transformation is harder. But both must make the transition to the digital age if they are to thrive. Digital Transformation at Scale is written by those who know how it’s done, because they’ve led that transformation. This is THE invaluable guide to bringing legacy institutions into the 21st century." — Tim O’Reilly, Founder and CEO, O’Reilly Media; "The transformation the authors led in the UK sparked change in governments around the world, including the Obama White House. Their approach broke open decades of dysfunction and waste and made the public believe in government. And that belief is foundational to our democracy." — Jen Pahlka, Executive Director of Code for America; "The Government Digital Service was one of the great unsung triumphs of the last parliament. This book is indispensable for any leader looking to emulate that success." — David Cameron, Prime Minister of the United Kingdom (2010–16); "An important and timely book. Dealing with government online should be as easy as ordering from Amazon. The UK model – acting like a start-up rather than a traditional government agency – is one from which all big organisations should learn." — Malcolm Turnbull, Prime Minister of Australia (2015–18)
£14.24
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
£18.69
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
£24.79
Pearson Education (US) Microsoft Excel VBA and Macros Office 2021 and
Book SynopsisTable of ContentsIntroduction 1. Unleash the Power of Excel with VBA 2. This Sounds Like BASIC, So Why Doesn't It Look Familiar? 3. Referring to Ranges 4. Looping and Flow Control 5. R1C1-style Formulas 6. Creating and manipulating Names in VBA 7. Event Programming 8. Arrays 9. Creating Classes and Collections 10. Userforms: An Introduction 11. Data Mining with Advanced Filter 12. Using VBA to Create Pivot Tables 13. Excel Power 14. Sample User-Defined Functions 15. Creating Charts 16. Data Visualizations and Conditional Formatting 17. Dashboarding with Sparklines in Excel 18. Reading from the Web using M and VBA 19. Text File Processing 20. Automating Word 21. Using Access as a Back End to Enhance Multiuser Access to Data 22. Advanced Userform Techniques 23. Windows Application Programming Interface (API) 24. Handling Errors 25. Customizing the Ribbon to Run Macros 26. Creating Excel Add-Ins 27. An Introduction to Creating Office Add-ins 28. What's New in Excel 365 and What's Changed
£27.19
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
£46.40
Pearson Education (US) Adobe Acrobat DC Classroom in a Book
Book SynopsisBrie Gyncild aims to make technical information accessible to those who need it. Brie wrote The Photoshop CS5 Pocket Guide and The Photoshop Elements 8 Pocket Guide. She has also co-written The Photoshop Show Starring Russell Brown; numerous editions of the Classroom in a Book series on Photoshop, After Effects, Flash, and Acrobat; and several editions of the How to Wow series. Brie lives in Seattle with cats and an overgrown garden. Lisa Fridsma has long loved the process of teaching others to use Adobe products. She has written, edited, and designed over thirty books in the Classroom in a Book series over the last two decades (including books on Photoshop and After Effects), starting with her time on-staff at Adobe. She is currently the owner of Darlington Hill Productions (informational illustrations and publishing). Lisa lives in Bethesda, MarylandTable of ContentsGetting Started 1. Introducing Adobe Acrobat DC 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
£33.74
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 (US) PHP and MySQL for Dynamic Web Sites
Book SynopsisLarry Ullman is a writer, Web and software developer, trainer, instructor, speaker, and consultant. He has written more than 20 books, which have sold over 400,000 copies worldwide in more than 20 languages. As his readers, students, and co-workers can attest, Larry's strength is in translating geek into English: converting the technical and arcane into something comprehensible and useful. Table of Contents Chapter 1 Introduction to PHP Chapter 2 Programming with PHP Chapter 3 Creating Dynamic Web Sites Chapter 4 Introduction to MySQL Chapter 5 Introduction to SQL Chapter 6 Database Design Chapter 7 Advanced SQL and MySQL Chapter 8 Error Handling and Debugging Chapter 9 Using PHP with MySQL Chapter 10 Common Programming Techniques Chapter 11 Web Application Development Chapter 12 Cookies and Sessions Chapter 13 Security Methods Chapter 14 Perl-Compatible Regular Expressions Chapter 15 Introducing jQuery Chapter 16 An OOP Primer Chapter 17 Example–Message Board Chapter 18 Example–User Registration Appendix A Installation
£35.14
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) BehaviorDriven Development with Cucumber
Book SynopsisRichard Lawrence is co-owner of the consulting firm Agile For All. He trains and coaches people to collaborate more effectively with other people to solve complex, meaningful problems. He draws on a diverse background in software development, engineering, anthropology, and political science. Richard was an early adopter of behavior-driven development and led the development of the first .NET version of Cucumber, Cuke4Nuke. He is a popular speaker at conferences on BDD and Agile software development. Paul Rayner co-founded and co-leads DDD Denver. He regularly speaks at local user groups and at regional and international conferences. If you are looking for an expert hands-on team coach and design mentor in domain-driven design (DDD), BDD with Cucumber, or lean/agile processes, Paul is available for consulting and trainTable of Contents Chapter 1: Focusing on Value When Scrum Isn’t Enough Finding a High-Value Feature to Start With Before You Start with Cucumber Finding the First MMF Slicing an MMF into User Stories Summary Reference Chapter 2: Exploring with Examples BDD Is a Cooperative Game BDD Is a Whole Team Thing Allow Time and Space to Learn Flesh Out the Happy Path First Use Real Examples Example Mapping Gives the Discussion Structure Optimizing for Discovery Addressing Some Concerns Treat Resistance as a Resource Playing the BDD Game Opening Exploring Closing Summary References Chapter 3: Formalizing Examples into Scenarios Moving from Examples to Scenarios Feature Files as Collaboration Points BDD Is Iterative, Not Linear Finding the Meaningful Variations Gherkin: A Language for Expressive Scenarios Summary Resources Chapter 4: Automating Examples The Test Automation Stack Adjusting to Working Test-First Annotating Element Names in Mockups How Does User Experience Design Fit In to This? Did They Really Just Hard Code Those Results? Anatomy of a Step Definition Simple Cucumber Expressions Regular Expressions Anchors Wildcards and Quantifiers Capturing and Not Capturing Just Enough Custom Cucumber Expressions Parameter Types Beyond Ruby Slow Is Normal (at First) Choose Cucumber Based on Audience, Not Scope Summary Chapter 5: Frequent Delivery and Visibility How BDD Changes the Tester’s Role Exploratory Testing BDD and Automated Builds Faster Stakeholder Feedback How Getting to Done More Often Changes All Sorts of Things Frequent Visibility and Legacy Systems Documentation: Integrated and Living Avoiding Mini-Waterfalls and Making the Change Stick Summary References Chapter 6: Making Scenarios More Expressive Feedback About Scenarios How to Make Your Scenarios More Expressive Finding the Right Level of Abstraction Including the Appropriate Details Expressive Language in the Steps Refactoring Scenarios Good Scenario Titles Summary References Chapter 7: Growing Living Documentation What Is Living Documentation and Why Is It Better? Cucumber Features and Other Documentation Avoid Gherkin in User Story Descriptions The Unexpected Relationship Between Cucumber Features and User Stories Stable Scenarios Growing and Splitting Features Split When Backgrounds Diverge Split When a New Domain Concept Emerges Secondary Organization Using Tags Structure Is Emergent Summary Chapter 8: Succeeding with Scenario Data Characteristics of Good Scenarios Independent Repeatable Researchable Realistic Robust Maintainable Fast Sharing Data When to Share Data Raising the Level of Abstraction with Data Personas Data Cleanup Summary Reference Chapter 9: Conclusion 9780321772633 TOC 4/22/2019
£24.69
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
Taylor & Francis Ltd Quantitative Data Analysis with SPSS 12 and 13 A
Book SynopsisThis new edition has been completely updated to accommodate the needs of users of SPSS Release 12 and 13 for Windows, whilst still being applicable to those using SPSS Release 11 and 10.Alan Bryman and Duncan Cramer provide a non-technical approach to quantitative data analysis and a user-friendly introduction to the widely used SPSS. No previous familiarity with computing or statistics is required to benefit from this step-by-step guide to techniques including: Non-parametric tests Correlation Simple and multiple regression Multivarate analysis of variance and covariance Factor analysis The authors discuss key issues facing the newcomer to research, such as how to decide which statistical procedure is suitable, and how to interpret the subsequent results. Each chapter contains worked examples to illustrate the points raised and ends with a comprehensive range of exercises which allow the reader to test their understandinTrade Review"The strengths of this book include its ability to integrate good advice on choosing the appropriate statistical test for the data yielded, procedures for carrying out appropriate statistical analyses, and on the interpretation of the findings from the analyses. It will prove an essential guide to students and researchers alike." - Tom Heffernan, Senior Lecturer in Psychology, Northumbria UniversityTable of ContentsData Analysis and the Research Process. Analyzing Data with Computers: First Steps with SPSS 12. Analyzing Data with Computers: Further Steps with SPSS 12. Concepts and their Measurement. Summarizing Data. Sampling and Statistical Significance. Bivariate Analysis: Exploring Differences between Scores on Two Variables. Bivariate Analysis: Exploring Relationships. Multivariate Analysis: Exploring Differences Among Three or More Variables. Multivariate Analysis: Exploring Relationships Among Three or More Variables. Aggregating Variables: Exploratory Factor Analysis. Answers to Exercises.
£114.00
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
