Design, implement, and deliver successful streaming applications, machine learning pipelines and graph applications using Spark SQL API About This Book ? Learn about the design and implementation of streaming applications, machine learning pipelines, deep learning, and large-scale graph processing applications using Spark SQL APIs and Scala. ? Learn data exploration, data munging, and how to process structured and semi-structured data using real-world datasets and gain hands-on exposure to the issues and challenges of working with noisy and "dirty" real-world data. ? Understand design considerations for scalability and performance in web-scale Spark application architectures. Who This Book Is For If you are a developer, engineer, or an architect and want to learn how to use Apache Spark in a web-scale project, then this is the book for you. It is assumed that you have prior knowledge of SQL querying. A basic programming knowledge with Scala, Java, R, or Python is all you need to get started with this book. What You Will Learn ? Familiarize yourself with Spark SQL programming, including working with DataFrame/Dataset API and SQL ? Perform a series of hands-on exercises with different types of data sources, including CSV, JSON, Avro, MySQL, and MongoDB ? Perform data quality checks, data visualization, and basic statistical analysis tasks ? Perform data munging tasks on publically available datasets ? Learn how to use Spark SQL and Apache Kafka to build streaming applications ? Learn key performance-tuning tips and tricks in Spark SQL applications ? Learn key architectural components and patterns in large-scale Spark SQL applications In Detail In the past year, Apache Spark has been increasingly adopted for the development of distributed applications. Spark SQL APIs provide an optimized interface that helps developers build such applications quickly and easily. However, designing web-scale production applications using Spark SQL APIs can be a complex task. Hence, understanding the design and implementation best practices before you start your project will help you avoid these problems. This book gives an insight into the engineering practices used to design and build real-world, Spark-based applications. The book's hands-on examples will give you the required confidence to work on any future projects you encounter in Spark SQL. It starts by familiarizing you with data exploration and data munging tasks using Spark SQL and Scala. Extensive code examples will help you understand the methods used to implement typical use-cases for various types of applications. You will get a walkthrough of the key concepts and terms that are common to streaming, machine learning, and graph applications. You will also learn key performance-tuning details including Cost Based Optimization (Spark 2.2) in Spark SQL applications. Finally, you will move on to learning how such systems are architected and deployed for a successful delivery of your project. Style and approach This book is a hands-on guide to designing, building, and deploying Spark SQL-centric production applications at scale.

Creating and Sharing Maps and Data using ArcGIS Pro About This Book ? Leverage the power of ArcGIS to build beautiful 2D and 3D maps. ? Work with ArcGIS to analyze and process data. ? Extend the power of ArcGIS to ArcGIS Online to create and edit content. Who This Book Is For GIS developers who are comfortable using ArcGIS, and are looking to increase their capabilities and skills, will find this book useful. What You Will Learn ? Edit data using standard tools and topology ? Convert and link data together using joins and relates ? Create and share data using Projections and Coordinate Systems ? Access and collect data in the field using ArcGIS Collector ? Perform proximity analysis and map clusters with hotspot analysis ? Use the 3D Analyst Extension and perform advanced 3D analysis ? Share maps and data using ArcGIS Online via web and mobile apps In Detail ArcGIS is Esri's catalog of GIS applications with powerful tools for visualizing, maintaining, and analyzing data. ArcGIS makes use of the modern ribbon interface and 64-bit processing to increase the speed and efficiency of using GIS. It allows users to create amazing maps in both 2D and 3D quickly and easily. If you want to gain a thorough understanding of the various data formats that can be used in ArcGIS Pro and shared via ArcGIS Online, then this book is for you. Beginning with a refresher on ArcGIS Pro and how to work with projects, this book will quickly take you through recipes about using various data formats supported by the tool. You will learn the limits of each format, such as Shapefiles, Geodatabase, and CAD files, and learn how to link tables from outside sources to existing GIS data to expand the amount of data that can be used in ArcGIS. You'll learn methods for editing 2D and 3D data using ArcGIS Pro and how topology can be used to ensure data integrity. Lastly the book will show you how data and maps can be shared via ArcGIS Online and used with web and mobile applications. Style and approach This book takes a recipe-based approach, teaching you how to create and share maps and data using ArcGIS Pro.

Over 70 practical recipes to analyze multi-dimensional data in SQL Server 2016 Analysis Services cubes About This Book Updated for SQL Server 2016, this book helps you take advantage of the new MDX commands and the new features introduced in SSAS Perform time-related, context-aware, and business related-calculations with ease to enrich your Business Intelligence solutions Collection of techniques to write flexible and high performing MDX queries in SSAS with carefully structured examples Who This Book Is For This book is for anyone who has been involved in working with multidimensional data. If you are a multidimensional cube developer, a multidimensional database administrator, or a report developer who writes MDX queries to access multidimensional cube, this book will help you. If you are a power cube user or an experienced business analyst, you will also find this book invaluable in your data analysis. This book is for you are interested in doing more data analysis so that the management can make timely and accurate business decisions. What You Will Learn Grasp the fundamental MDX concepts, features, and techniques Work with sets Work with Time dimension and create time-aware calculations Make analytical reports compact, concise, and efficient Navigate cubes Master MDX for reporting with Reporting Services (new) Perform business analytics Design efficient cubes and efficient MDX queries Create metadata-driven calculations (new) Capture MDX queries and many other techniques In Detail If you're often faced with MDX challenges, this is a book for you. It will teach you how to solve various real-world business requirements using MDX queries and calculations. Examples in the book introduce an idea or a problem and then guide you through the process of implementing the solution in a step-by-step manner, inform you about the best practices and offer a deep knowledge in terms of how the solution works. Recipes are organized by chapters, each covering a single topic. They start slowly and logically progress to more advanced techniques. In case of complexity, things are broken down. Instead of one, there are series of recipes built one on top of another. This way you are able to see intermediate results and debug potential errors faster. Finally, the cookbook format is here to help you quickly identify the topic of interest and in it a wide range of practical solutions, that is – MDX recipes for your success. Style and approach This book is written in a cookbook format, where you can browse through and look for solutions to a particular problem in one place. Each recipe is short, to the point and grouped by relevancy. All the recipes are sequenced in a logical progression; you will be able to build up your understanding of the topic incrementally.

Create interactive cross-platform reports and dashboards using SQL Server 2016 Reporting Services About This Book Get up to speed with the newly-introduced enhancements and the more advanced query and reporting features Easily access your important data by creating visually appealing dashboards in the Power BI practical recipe Create cross-browser and cross-platform reports using SQL Server 2016 Reporting Services Who This Book Is For This book is for software professionals who develop and implement reporting solutions using Microsoft SQL Server. It is especially relevant for professionals who are software engineers, software architects, DW/BI engineers, and DW/BI architects who perform simple to complex report authoring implementations. This book is also suitable for those who develop software solutions that integrate reporting solutions and are keen to learn about Microsoft SQL Server 2016’s features and capabilities. What You Will Learn Key capabilities, architecture, and components of Reporting Services New features that have been added to Reporting Services Design the architecture for reporting solutions Design the architecture for BI solutions Implement reporting solutions using Reporting Services Improve the performance, availability, and scalability of the reporting solution Enhance reporting solutions with custom programming and improved security In Detail Microsoft SQL Server 2016 Reporting Services comes with many new features. It offers different types of reporting such as Production, Ad-hoc, Dashboard, Mash-up, and Analytical. SQL Server 2016 also has a surfeit of new features including Mobile Reporting, and Power BI integration. This book contains recipes that explore the new and advanced features added to SQL Server 2016. The first few chapters cover recipes on configuring components and how to explore these new features. You’ll learn to build your own reporting solution with data tools and report builder, along with learning techniques to create visually appealing reports. This book also has recipes for enhanced mobile reporting solutions, accessing these solutions effectively, and delivering interactive business intelligence solutions. Towards the end of the book, you’ll get to grips with running reporting services in SharePoint integrated mode and be able to administer, monitor, and secure your reporting solution. This book covers about the new offerings of Microsoft SQL Server 2016 Reporting Services in comprehensive detail and uses examples of real-world problem-solving business scenarios. Style and approach This comprehensive cookbook follows a problem-solution approach to help you overcome any obstacle when creating interactive, visually-appealing reports using SQL Server 2016 Reporting Services. Each recipe focuses on a specific task and is written in a clear, solution-focused style.

This book is written in a practical and friendly style with practical tutorials, exercises, and detailed images which will help you master the third dimension. This book is intended for everyone who wants to create accurate 3D models in AutoCAD, like architecture, engineering, or design professionals, and students. Only basic understanding of 2D AutoCAD is needed.

A practical tutorial containing clear, step-by-step explanations of all the concepts required to understand the technology involved in virtualizing your application infrastructure. Each chapter uses real-world scenarios so that the readers can put into practice what they learn immediately and with the right guidance. Each topic is written defining a common need and developing the process to solve it using Microsoft App-V. This book is for system administrators or consultants who want to master and dominate App-V, and gain a deeper understanding of the technology in order to optimize App V implementations. Even though the book does not include basic steps like installing App-V components or sequencing simple applications; application virtualization beginners will receive a comprehensive look into App-V before jumping into the technical process of each chapter.

This is a practical guide providing comprehensive solutions for SQL query problems, and is full of concrete real-world examples to help you create and troubleshoot your SQL queries in SAP Business One. If you are a system administrator who uses SQL query as your tool of choice for solving specific problems throughout SAP Business One, then this book is for you. It may also be useful if you are a developer or consultant using this technology, and can benefit end users by improving your search for important business information. A rudimentary knowledge of SAP Business One and SQL Server is required to use this book efficiently. Examples covered are relevant to SBO 2007A users, for which the 8.8 release is mostly compatible. All SQL query examples within the book are verified under SQL Server 2005, so they are guaranteed to run under this release, in addition to SQL Server 2008. Non-SAP Business One users can also gain knowledge from the many examples throughout the book. It is hard to find another book with so many SQL query examples.

With their straightforward style, Suresh Krishna and TC Fenstermaker have put their years of experience and motivation into this practical guide that assists in finding an integrated approach to increased team productivity. The numerous tips, notes, and suggestions strengthen your grasp of fundamentals and the foundation upon which you are ready to build your customized Rational Team Concert application. Ample screenshots make sure that you get the configurations correct the first time. A real-world Book Manager Application walks you through all the core features of the Rational Team Concert during different phases of development and release. If you are a Project Manager or a Team Member, who would like to find an integrated approach to deal with modern software development challenges, you should read this book. Or if you are someone who likes to stay one step ahead in team management, you have got the right choice here.

Throughout the book, we will follow a fictional company, the case study will help you in implementing FIM 2010 R2. All the examples in the book will relate to this fictive company and you will be taken from design, to installation, to configuration of FIM 2010 R2. If you are implementing and managing FIM 2010 R2 in your business, then this book is for you. You will need to have a basic understanding of Microsoft based infrastructure using Active Directory. If you are new to Forefront Identity Management, the case-study approach of this book will help you to understand the concepts and implement them.

This book is written in a clear conversational style, which emphasizes a practical learn-by-doing approach. This step by step guide has illustrative examples to implement Ext JS library features in your Oracle APEX applications If you are an Oracle APEX application developer who wants to take APEX applications to the next level by taking advantage of Ext JS features, this book is for you. Prior knowledge of Oracle APEX is required, however, no prior knowledge of Ext JS is required.

This cookbook has recipes written in simple, easy to understand format with lots of screenshots and insightful tips and hints. If you are an Oracle Database Administrator, Security Manager or Security Auditor looking to secure the Oracle Database or prevent it from being hacked, then this book is for you. This book assumes you have a basic understanding of security concepts.

In order to make the most of the book, you should have a C++ programming background, knowledge of GNU/Linux systems, and general skills in computer science. No previous background in ROS is required, as this book takes you from the ground up.

This is a practical book with step-by-step guidelines to integrate Silverlight 4 applications in a SharePoint 2010 Server environment. This book focuses on the integration of the two technologies and is not a primer for any of the individual technologies. It offers clear examples to successfully perform the most important integration tasks. If you are an application developer who wants to implement Silverlight 4 applications within a SharePoint 2010 environment, this book is for you. We assume that the reader has prior knowledge of Silverlight and SharePoint 2010 and this book focuses more on the integration of Silverlight with SharePoint 2010.

Written as a tutorial to explore and understand the power of R for machine learning. This practical guide that covers all of the need to know topics in a very systematic way. For each machine learning approach, each step in the process is detailed, from preparing the data for analysis to evaluating the results. These steps will build the knowledge you need to apply them to your own data science tasks.Intended for those who want to learn how to use R's machine learning capabilities and gain insight from your data. Perhaps you already know a bit about machine learning, but have never used R; or perhaps you know a little R but are new to machine learning. In either case, this book will get you up and running quickly. It would be helpful to have a bit of familiarity with basic programming concepts, but no prior experience is required.

A practical guide which will help to discover how to setup and configure the Salesforce CRM application. It offers solutions and practical examples on how to further improve and maintain its functionality with clear systematic instructions. Being highly organized and compact, this book contains detailed instructions with screenshots, diagrams, and tips that clearly describe how you can administer and configure complex Salesforce CRM functionality with absolute ease.This book is for administrators who want to develop and strengthen their Salesforce CRM skills in the areas of configuration and system management. Whether you are a novice or a more experienced admin, this book aims to enhance your knowledge and understanding of the Salesforce CRM platform and by the end of the book, you should be ready to administer Salesforce CRM in a real-world environment.

Targeted at those with an existing familiarity with R programming, this practical guide will appeal directly to programmers interested in learning effective data visualization techniques with R and a wide-range of its associated libraries.

If you are a desktop architect, solution provider, end-user consultant, virtualization engineer, or anyone who wants to learn how to plan and design the implementation of a virtual desktop solution based on Horizon 6, then this book is for you. An understanding of VMware vSphere fundamentals coupled with experience in the installation or administration of a VMware environment would be a plus during reading.

This book is aimed at both new developers as well as experienced developers. If you are a new SAP BusinessObjects Universe developer who is looking for a step-by-step guide supported with real-life examples and illustrated diagrams, then this book is for you. If you are a seasoned BusinessObjects Universe developer who is looking for a fast way to map your old experience in Universe designer to the newer Information Design Tool, then this book is for you as well.

If you are a Visual Studio 2013 or .NET developer who would like to sharpen your existing skill set and adapt to new .NET technologies, this is the book for you. A basic understanding of .NET and C# is required.

If you are a business analyst, BI developer, or an IT professional who wants to learn the A to Z of how to work with Web Intelligence reporting tools and different types of data, then this book is for you. The only thing you need is a basic understanding of what Business Intelligence is and data concepts.

If you have C# knowledge but now want to become truly confident in creating fully functional 2D RPG games with Unity, then this book will show you everything you need to know.