Collect, Combine, and Transform Data Using Power Query in Excel and Power BI
Using Power Query, you can import, reshape, and cleanse any data from a simple interface, so you can mine that data for all of its hidden insights. Power Query is embedded in Excel, Power BI, and other Microsoft products, and leading Power Query expert Gil Raviv will help you make the most of it. Discover how to eliminate time-consuming manual data preparation, solve common problems, avoid pitfalls, and more. Then, walk through several complete analytics challenges, and integrate all your skills in a realistic chapter-length final project. By the time you're finished, you'll be ready to wrangle any data - and transform it into actionable knowledge. Prepare and analyze your data the easy way, with Power Query; Quickly prepare data for analysis with Power Query in Excel (also known as Get & Transform) and in Power BI; Solve common data preparation problems with a few mouse clicks and simple formula edits; Combine data from multiple sources, multiple queries, and mismatched tables; Mas ...
Using Power Query, you can import, reshape, and cleanse any data from a simple interface, so you can mine that data for all of its hidden insights. Power Query is embedded in Excel, Power BI, and other Microsoft products, and leading Power Query expert Gil Raviv will help you make the most of it. Discover how to eliminate time-consuming manual data preparation, solve common problems, avoid pitfalls, and more. Then, walk through several complete analytics challenges, and integrate all your skills in a realistic chapter-length final project. By the time you're finished, you'll be ready to wrangle any data - and transform it into actionable knowledge. Prepare and analyze your data the easy way, with Power Query; Quickly prepare data for analysis with Power Query in Excel (also known as Get & Transform) and in Power BI; Solve common data preparation problems with a few mouse clicks and simple formula edits; Combine data from multiple sources, multiple queries, and mismatched tables; Mas ...
Microsoft Excel 2019 Inside Out
Dive into Microsoft Excel 2019 - and really put your spreadsheet expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds - all you need to make the most of Excel's most powerful tools for analyzing data and making better decisions. Renowned Excel expert Bill Jelen offers a complete tour of Excel 2019 and Excel in Office 365, from efficient interface customizations to advanced analysis, visualizations, and dashboards. Discover how experts tackle today's key tasks - and challenge yourself to new levels of mastery. Enter formulas more efficiently, and fully control operators and dates; Master the most widely-used functions in Excel; Integrate external data from the web and other sources; Easily transform complex datasets with Power Query; Quickly summarize millions of records with Pivot Tables; Perform ad hoc analyses with slicers and other filters; Create advanced data mashups with Power Pivot; Solve complex problems with Wha ...
Dive into Microsoft Excel 2019 - and really put your spreadsheet expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds - all you need to make the most of Excel's most powerful tools for analyzing data and making better decisions. Renowned Excel expert Bill Jelen offers a complete tour of Excel 2019 and Excel in Office 365, from efficient interface customizations to advanced analysis, visualizations, and dashboards. Discover how experts tackle today's key tasks - and challenge yourself to new levels of mastery. Enter formulas more efficiently, and fully control operators and dates; Master the most widely-used functions in Excel; Integrate external data from the web and other sources; Easily transform complex datasets with Power Query; Quickly summarize millions of records with Pivot Tables; Perform ad hoc analyses with slicers and other filters; Create advanced data mashups with Power Pivot; Solve complex problems with Wha ...
Exam Ref 70-483 Programming in C#, 2nd Edition
Prepare for the latest versions of Microsoft Exam 70-483 and help demonstrate your real-world mastery of modern C# programming. Designed for experienced C# developers ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: Manage program flow; Create and use types; Debug applications and implement security; Implement data access. This Microsoft Exam Ref: Organizes its coverage by exam objectives; Features strategic, what-if scenarios to challenge you; Assumes you have experience programming essential business logic with C# for diverse application types, hardware, and software platforms. ...
Prepare for the latest versions of Microsoft Exam 70-483 and help demonstrate your real-world mastery of modern C# programming. Designed for experienced C# developers ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: Manage program flow; Create and use types; Debug applications and implement security; Implement data access. This Microsoft Exam Ref: Organizes its coverage by exam objectives; Features strategic, what-if scenarios to challenge you; Assumes you have experience programming essential business logic with C# for diverse application types, hardware, and software platforms. ...
Programming for Mixed Reality with Windows 10, Unity, Vuforia, and UrhoSharp
This is a complete guide to programming AI-powered mixed reality apps with the Windows Mixed Reality platform. Step by step, Dawid Borycki guides you through every type of mixed reality development, from simple 2D to cutting-edge apps for Microsoft HoloLens and immersive headsets. First, you'll learn to write UWP 2D apps that adapt for any Windows 10 device, transfer camera images to machine learning services, and use mobile sensor readings to control headset content. Then, building on these skills, you'll master every facet of building cross-platform 3D apps that link augmented reality content to real objects. Advanced Microsoft technology expert Dawid Borycki shows how to: Set up a mixed reality development environment with all the tools you'll need, including HoloLens and Mixed Reality simulators; Write Universal Windows 2D apps for all Windows 10 devices, and adjust their views and capabilities to specific hardware; Render media streams, acquire video from world-facing cameras, ...
This is a complete guide to programming AI-powered mixed reality apps with the Windows Mixed Reality platform. Step by step, Dawid Borycki guides you through every type of mixed reality development, from simple 2D to cutting-edge apps for Microsoft HoloLens and immersive headsets. First, you'll learn to write UWP 2D apps that adapt for any Windows 10 device, transfer camera images to machine learning services, and use mobile sensor readings to control headset content. Then, building on these skills, you'll master every facet of building cross-platform 3D apps that link augmented reality content to real objects. Advanced Microsoft technology expert Dawid Borycki shows how to: Set up a mixed reality development environment with all the tools you'll need, including HoloLens and Mixed Reality simulators; Write Universal Windows 2D apps for all Windows 10 devices, and adjust their views and capabilities to specific hardware; Render media streams, acquire video from world-facing cameras, ...
Programming iOS 12
If you're grounded in the basics of Swift, Xcode, and the Cocoa framework, this book provides a structured explanation of all essential real-world iOS app components. Through deep exploration and copious code examples, you'll learn how to create views, manipulate view controllers, and add features from iOS frameworks. Create, arrange, draw, layer, and animate views that respond to touch; Use view controllers to manage multiple screens of interface; Master interface classes for scroll views, table views, text, popovers, split views, web views, and controls; Dive into frameworks for sound, video, maps, and sensors; Access user libraries: music, photos, contacts, and calendar; Explore additional topics, including files, networking, and threads. Stay up-to-date on iOS 12 innovations, such as User Notification framework improvements, as well as changes in Xcode 10 and Swift 4.2. All example code is available on GitHub for you to download, study, and run. Want to brush up on the bas ...
If you're grounded in the basics of Swift, Xcode, and the Cocoa framework, this book provides a structured explanation of all essential real-world iOS app components. Through deep exploration and copious code examples, you'll learn how to create views, manipulate view controllers, and add features from iOS frameworks. Create, arrange, draw, layer, and animate views that respond to touch; Use view controllers to manage multiple screens of interface; Master interface classes for scroll views, table views, text, popovers, split views, web views, and controls; Dive into frameworks for sound, video, maps, and sensors; Access user libraries: music, photos, contacts, and calendar; Explore additional topics, including files, networking, and threads. Stay up-to-date on iOS 12 innovations, such as User Notification framework improvements, as well as changes in Xcode 10 and Swift 4.2. All example code is available on GitHub for you to download, study, and run. Want to brush up on the bas ...
UX for Lean Startups
Great user experiences (UX) are essential for products today, but designing one can be a lengthy and expensive process. With this practical, hands-on book, you'll learn how to do it faster and smarter using Lean UX techniques. UX expert Laura Klein shows you what it takes to gather valuable input from customers, build something they'll truly love, and reduce the time it takes to get your product to market. No prior experience in UX or design is necessary to get started. If you're an entrepreneur or an innovator, this book puts you right to work with proven tips and tools for researching, identifying, and designing an intuitive, easy-to-use product. Determine whether people will buy your product before you build it; Listen to your customers throughout the product's lifecycle; Understand why you should design a test before you design a product; Get nine tools that are critical to designing your product; Discern the difference between necessary features and nice-to-haves; Learn how ...
Great user experiences (UX) are essential for products today, but designing one can be a lengthy and expensive process. With this practical, hands-on book, you'll learn how to do it faster and smarter using Lean UX techniques. UX expert Laura Klein shows you what it takes to gather valuable input from customers, build something they'll truly love, and reduce the time it takes to get your product to market. No prior experience in UX or design is necessary to get started. If you're an entrepreneur or an innovator, this book puts you right to work with proven tips and tools for researching, identifying, and designing an intuitive, easy-to-use product. Determine whether people will buy your product before you build it; Listen to your customers throughout the product's lifecycle; Understand why you should design a test before you design a product; Get nine tools that are critical to designing your product; Discern the difference between necessary features and nice-to-haves; Learn how ...
Web 2.0: A Strategy Guide
Web 2.0 makes headlines, but how does it make money? This concise guide explains what's different about Web 2.0 and how those differences can improve your company's bottom line. Whether you're an executive plotting the next move, a small business owner looking to expand, or an entrepreneur planning a startup, Web 2.0: A Strategy Guide illustrates through real-life examples how businesses, large and small, are creating new opportunities on today's Web. This book is about strategy. Rather than focus on the technology, the examples concentrate on its effect. You will learn that creating a Web 2.0 business, or integrating Web 2.0 strategies with your existing business, means creating places online where people like to come together to share what they think, see, and do. When people come together over the Web, the result can be much more than the sum of the parts. The customers themselves help build the site, as old-fashioned "word of mouth" becomes hypergrowth. Web 2.0: A Strategy Gu ...
Web 2.0 makes headlines, but how does it make money? This concise guide explains what's different about Web 2.0 and how those differences can improve your company's bottom line. Whether you're an executive plotting the next move, a small business owner looking to expand, or an entrepreneur planning a startup, Web 2.0: A Strategy Guide illustrates through real-life examples how businesses, large and small, are creating new opportunities on today's Web. This book is about strategy. Rather than focus on the technology, the examples concentrate on its effect. You will learn that creating a Web 2.0 business, or integrating Web 2.0 strategies with your existing business, means creating places online where people like to come together to share what they think, see, and do. When people come together over the Web, the result can be much more than the sum of the parts. The customers themselves help build the site, as old-fashioned "word of mouth" becomes hypergrowth. Web 2.0: A Strategy Gu ...
Continuous API Management
A lot of work is required to release an API, but the effort doesn't always pay off. Overplanning before an API matures is a wasted investment, while underplanning can lead to disaster. This practical guide provides maturity models for individual APIs and multi-API landscapes to help you invest the right human and company resources for the right maturity level at the right time. How do you balance the desire for agility and speed with the need for robust and scalable operations? Four experts from the API Academy show software architects, program directors, and product owners how to maximize the value of their APIs by managing them as products through a continuous life cycle. Learn which API decisions you need to govern and how and where to do so; Design, deploy, and manage APIs using an API-as-a-product (AaaP) approach; Examine ten pillars that form the foundation of API product work; Learn how the continuous improvement model governs changes throughout an API's lifetime; Explore ...
A lot of work is required to release an API, but the effort doesn't always pay off. Overplanning before an API matures is a wasted investment, while underplanning can lead to disaster. This practical guide provides maturity models for individual APIs and multi-API landscapes to help you invest the right human and company resources for the right maturity level at the right time. How do you balance the desire for agility and speed with the need for robust and scalable operations? Four experts from the API Academy show software architects, program directors, and product owners how to maximize the value of their APIs by managing them as products through a continuous life cycle. Learn which API decisions you need to govern and how and where to do so; Design, deploy, and manage APIs using an API-as-a-product (AaaP) approach; Examine ten pillars that form the foundation of API product work; Learn how the continuous improvement model governs changes throughout an API's lifetime; Explore ...
Java in a Nutshell, 7th Edition
This updated edition of Java in a Nutshell not only helps experienced Java programmers get the most out of Java versions 9 through 11, it's also a learning path for new developers. Chock full of examples that demonstrate how to take complete advantage of modern Java APIs and development best practices, this thoroughly revised book includes new material on Java Concurrency Utilities. The book's first section provides a fast-paced, no-fluff introduction to the Java programming language and the core runtime aspects of the Java platform. The second section is a reference to core concepts and APIs that explains how to perform real programming work in the Java environment. Get up to speed on language details, including Java 9-11 changes; Learn object-oriented programming, using basic Java syntax; Explore generics, enumerations, annotations, and lambda expressions; Understand basic techniques used in object-oriented design; Examine concurrency and memory, and how they're intertwined; Wo ...
This updated edition of Java in a Nutshell not only helps experienced Java programmers get the most out of Java versions 9 through 11, it's also a learning path for new developers. Chock full of examples that demonstrate how to take complete advantage of modern Java APIs and development best practices, this thoroughly revised book includes new material on Java Concurrency Utilities. The book's first section provides a fast-paced, no-fluff introduction to the Java programming language and the core runtime aspects of the Java platform. The second section is a reference to core concepts and APIs that explains how to perform real programming work in the Java environment. Get up to speed on language details, including Java 9-11 changes; Learn object-oriented programming, using basic Java syntax; Explore generics, enumerations, annotations, and lambda expressions; Understand basic techniques used in object-oriented design; Examine concurrency and memory, and how they're intertwined; Wo ...
Drupal 8 Quick Start Guide
Drupal is a powerful content management platform, flexible enough to accommodate almost any content requirements. This flexibility comes with a cost: complexity. Drupal 8 Quick Start Guide will clear your path from installation to a building usable site in minutes, and to a customized site in one sitting. You will begin with installation of Drupal and going through the main sections of the Drupal UI. Then, you will create a content type that describes its content, which simplifies the act of creating and editing the actual content later. You will learn about user roles, using real-world examples. This will help you to learn how to design roles, and how to assign appropriate permissions to them. Next, you will learn to use the WYSIWYG editor, configure it for other roles, navigate the various fields on the content creation form, and publish content. To begin to appreciate the flexibility and expandability of Drupal, you will make use of popular content-focused modules that extend ...
Drupal is a powerful content management platform, flexible enough to accommodate almost any content requirements. This flexibility comes with a cost: complexity. Drupal 8 Quick Start Guide will clear your path from installation to a building usable site in minutes, and to a customized site in one sitting. You will begin with installation of Drupal and going through the main sections of the Drupal UI. Then, you will create a content type that describes its content, which simplifies the act of creating and editing the actual content later. You will learn about user roles, using real-world examples. This will help you to learn how to design roles, and how to assign appropriate permissions to them. Next, you will learn to use the WYSIWYG editor, configure it for other roles, navigate the various fields on the content creation form, and publish content. To begin to appreciate the flexibility and expandability of Drupal, you will make use of popular content-focused modules that extend ...