Delve into the SAP Data Services environment to efficiently prepare, implement, and develop ETL processes About This Book * Install and configure the SAP Data Services environment * Develop ETL techniques in the Data Services environment * Implement real-life examples of Data Services uses through step-by-step instructions to perform specific ETL development tasks Who This Book Is For This book is for IT technical engineers who want to get familiar with the EIM solutions provided by SAP for ETL development and data quality management. The book requires familiarity with basic programming concepts and basic knowledge of the SQL language. What You Will Learn * Install, configure, and administer the SAP Data Services components * Run through the ETL design basics * Maximize the performance of your ETL with the advanced patterns in Data Services * Extract methods from various databases and systems * Get familiar with the transformation methods available in SAP Data Services * Load methods into various databases and systems * Code with the Data Services scripting language * Validate and cleanse your data, applying the Data quality methods of the Information Steward In Detail Want to cost effectively deliver trusted information to all of your crucial business functions? SAP Data Services delivers one enterprise-class solution for data integration, data quality, data profiling, and text data processing. It boosts productivity with a single solution for data quality and data integration. SAP Data Services also enables you to move, improve, govern, and unlock big data. This book will lead you through the SAP Data Services environment to efficiently develop ETL processes. To begin with, you'll learn to install, configure, and prepare the ETL development environment. You will get familiarized with the concepts of developing ETL processes with SAP Data Services. Starting from smallest unit of work- the data flow, the chapters will lead you to the highest organizational unit-the Data Services job, revealing the advanced techniques of ETL design. You will learn to import XML files by creating and implementing real-time jobs. It will then guide you through the ETL development patterns that enable the most effective performance when extracting, transforming, and loading data. You will also find out how to create validation functions and transforms. Finally, the book will show you the benefits of data quality management with the help of another SAP solution-Information Steward. Style and approach This book is an easy-to-follow guide with step-by-step instructions to perform specific ETL development tasks.

Over 150 real-world recipes to simplify database management, automate repetitive tasks, and enhance your productivity About This Book * This book helps you build a strong foundation to get you comfortable using PowerShell with SQL Server, empowering you to create more complex scripts for your day-to-day job * The book provides numerous guidelines, tips, and explanations on how and when to use PowerShell cmdlets, WMI, SMO, .NET classes, or other components * It offers easy-to-follow, practical recipes to help you get the most out of SQL Server and PowerShell Who This Book Is For If you are a SQL Server database professional (DBA, developer, or BI developer) who wants to use PowerShell to automate, integrate, and simplify database tasks, this books is for you. Prior knowledge of scripting would be helpful, but it is not necessary. What You Will Learn * Explore database objects and execute queries on multiple servers * Manage and monitor the running of SQL Server services and accounts * Back up and restore databases * Create an inventory of database properties and server configuration settings * Maintain permissions and security for users * Work with CLR assemblies, XML, and BLOB objects in SQL * Manage and deploy SSIS packages and SSRS reports In Detail PowerShell can be leveraged when automating and streamlining SQL Server tasks. PowerShell comes with a rich set of cmdlets, and integrates tightly with the .NET framework. Its scripting capabilities are robust and flexible, allowing you to simplify automation and integration across different Microsoft applications and components. The book starts with an introduction to the new features in SQL Server 2014 and PowerShell v5 and the installation of SQL Server. You will learn about basic SQL Server administration tasks and then get to know about some security-related topics such as the authentication mode and assigning permissions. Moving on, you will explore different methods to back up and restore your databases and perform advanced administration tasks such as working with Policies, Filetables, and SQL audits. The next part of the book covers more advanced HADR tasks such as log shipping and data mirroring, and then shows you how to develop your server to work with BLOB, XML, and JSON. Following on from that, you will learn about SQL Server's BI stack, which includes SSRS reports, the SSIS package, and the SSAS cmdlet and database. Snippets not specific to SQL Server will help you perform tasks quickly on SQL servers. Towards the end of the book, you will find some useful information, which includes a PowerShell tutorial for novice users, some commonly-used PowerShell and SQL Server syntax, and a few online resources. Finally, you will create your own SQL Server Sandbox VMs. All these concepts will help you to efficiently manage your administration tasks. Style and approach SQL Server 2014 with PowerShell v5 Cookbook is an example-focused book that provides step-by-step instructions on how to accomplish specific SQL Server tasks using PowerShell. Each recipe is followed by an analysis of the steps or design decisions taken and additional information about the task at hand. Working scripts are provided for all examples so that you can dive in right away. You can read this book sequentially by chapter or you can pick and choose which topics you need right away.

Unlock more than 50 amazing tips and tricks to enhance your QlikView skills About This Book * Learn QlikView development best practices from the experts * Discover valuable tips, tricks, and undocumented features * A fast-paced guide with techniques and best practices to optimize high-performance, robust, and scalable applications Who This Book Is For QlikView Unlocked is intended for anyone with at least some experience in designing, developing, or supporting QlikView applications. Whether you are new to QlikView or are a seasoned developer, there is something for everyone in this book. What You Will Learn * Build the QlikView environment correctly so that it is flexible and robust * Deliver a successful QlikView project * Understand and implement QlikView best practices * Discover the best way to prototype, develop, and deploy applications * Overcome data modeling challenges * Explore the in's and out's of Section Access * Solve post-deployment issues in Server and Publisher In Detail QlikView is considered as one of the most used tool for Business Intelligence (BI). An efficient BI tool should provide five important capabilities for effective data analysis-collection (gathering important information), reporting, analysis (the ability to interact with data), visualization (the presentation of data), and discovery (exploring data). QlikView offers all these necessary skills required to deal with big data in real-world scenarios. QlikView Unlocked will provide you with new insights to get the very best from QlikView. This book will help you to develop skills to work with data efficiently. We will cover all the secrets of unleashing the full power of QlikView, which will enable you to make better use of the tool and create better results for future projects. In the course of this book, we will walk you through techniques and best practices that will enable you to be more productive. You will gain quick insights into the tool with the help of short steps called "keys," which will help you discover new features of QlikView. Moving on you will learn new techniques for data visualization, scripting, data modeling, and more. This book will then cover best practices to help you establish an efficient system with improved performance. We will also teach you some tricks that will help you speed up development processes, monitor data with dashboards, and so on. By the end of this book, you will have gained beneficial tips, tricks, and techniques to enhance the overall experience of working with QlikView. Style and approach Written in a fairly informal style, this is a book that can be read cover-to-cover or simply used as a "how-to" reference. Using real-world examples with clear explanations, code samples, and screenshots, you will be able understand each topic fully. You will be able to apply the knowledge gained to your QlikView projects.

Enhance your SAP HANA skills using this step-by-step guide to creating and reporting data models for real-time analytics About This Book * This book will help you to process analytical and transactional data in real time with the help of SAP HANA. * Walk through the steps of the data modeling process and build various data models and artifacts in SAP HANA Studio. * Packed with rich examples and use cases that are closely focused on developing real-time applications. Who This Book Is For If you are a SAP HANA data modeler, developer, implementation/migration consultant, project manager, or architect who is responsible for implementing/migrating to SAP HANA, then this book is for you. What You Will Learn * Get to grips with the basic building blocks of Analytics/Data models in the SAP HANA environment. * Discover various schemas, modeling principles, Joins, and the architecture of the SAP HANA engine. * Build data models and artifacts in Sap HANA Studio. * Design decision tables and understand the concept of transport management in the SAP HANA landscape. * Work with the different views in SAP HANA Studio. * Explore full-text search and fuzzy search in SAP HANA. * Create your own scenarios and use cases using sample data and code. In Detail SAP HANA is an in-memory database created by SAP. SAP HANA breaks traditional database barriers to simplify IT landscapes, eliminating data preparation, pre-aggregation, and tuning. SAP HANA and in-memory computing allow you to instantly access huge volumes of structured and unstructured data, including text data, from different sources. Starting with data modeling, this fast-paced guide shows you how to add a system to SAP HANA Studio, create a schema, packages, and delivery unit. Moving on, you'll get an understanding of real-time replication via SLT and learn how to use SAP HANA Studio to perform this. We'll also have a quick look at SAP Business Object DATA service and SAP Direct Extractor for Data Load. After that, you will learn to create HANA artifacts-Analytical Privileges and Calculation View. At the end of the book, we will explore the SMART DATA access option and AFL library, and finally deliver pre-packaged functionality that can be used to build information models faster and easier. Style and approach This is an easy-to-follow, step-by-step, rapid guide to help you learn analytics in SAP HANA through ample hands-on exercises and use case scenarios.

Embrace the new world of fiance by leveraging the power of crypto-currencies using Bitcoin and the Blockchain About This Book * Set up your own wallet, buy and sell Bitcoin, and execute custom transactions on the Blockchain * Leverage the power of Bitcoin to reduce transaction costs and eliminate fraud * A practical step-by-step guide to break down the Bitcoin technology to ensure safe transactions Who This Book Is For If you are familiar with online banking and want to expand your finances into a resilient and transparent currency, this book is ideal for you. A basic understanding of online wallets and financial systems will be highly beneficial to unravel the mysteries of Bitcoin. What You Will Learn * Set up your wallet and buy a Bitcoin in a flash while understanding the basics of addresses and transactions * Acquire the knack of buying, selling, and trading Bitcoins with online marketplaces * Secure and protect your Bitcoins from online theft using Brainwallets and cold storage * Understand how Bitcoin's underlying technology, the Blockchain, works with simple illustrations and explanations * Configure your own Bitcoin node and execute common operations on the network * Discover various aspects of mining Bitcoin and how to set up your own mining rig * Dive deeper into Bitcoin and write scripts and multi-signature transactions on the network * Explore the various alt-coins and get to know how to compare them and their value In Detail The financial crisis of 2008 raised attention to the need for transparency and accountability in the financial world. As banks and governments were scrambling to stay solvent while seeking a sustainable plan, a powerfully new and resilient technology emerged. Bitcoin, built on a fundamentally new technology called "The Blockchain," offered the promise of a new financial system where transactions are sent directly between two parties without the need for central control. Bitcoin exists as an open and transparent financial system without banks, governments, or corporate support. Simply put, Bitcoin is "programmable money" that has the potential to change the world on the same scale as the Internet itself. This book arms you with immense knowledge of Bitcoin and helps you implement the technology in your money matters, enabling secure transactions. We first walk through the fundamentals of Bitcoin, illustrate how the technology works, and exemplify how to interact with this powerful and new financial technology. You will learn how to set up your online Bitcoin wallet, indulge in buying and selling of bitcoins, and manage their storage. We then get to grips with the most powerful algorithm of all times: the Blockchain, and learn how crypto-currencies can reduce the risk of fraud for e-commerce merchants and consumers. With a solid base of Blockchain, you will write and execute your own custom transactions. Most importantly, you will be able to protect and secure your Bitcoin with the help of effective solutions provided in the book. Packed with plenty of screenshots, Learning Bitcoin is a simple and painless guide to working with Bitcoin. Style and approach This is an easy-to-follow guide to working with Bitcoin and the Blockchain technology. This book is ideal for anyone who wants to learn the basics of Bitcoin and explore how to set up their own transactions.

Manage, analyze, and visualize data with Microsoft Excel 2013 to transform raw data into ready to use information About This Book * Create formulas to help you analyze and explain findings * Develop interactive spreadsheets that will impress your audience and give them the ability to slice and dice data * A step-by-step guide to learn various ways to model data for businesses with the help of Excel 2013 Who This Book Is For If you want to start using Excel 2013 for data analysis and business modeling and enhance your skills in the data analysis life cycle then this book is for you, whether you're new to Excel or experienced. What You Will Learn * Discover what Excel formulas are all about and how to use them in your spreadsheet development * Identify bad data and learn cleaning strategies * Create interactive spreadsheets that engage and appeal to your audience * Leverage Excel's powerful built-in tools to get the median, maximum, and minimum values of your data * Build impressive tables and combine datasets using Excel's built-in functionality * Learn the powerful scripting language VBA, allowing you to implement your own custom solutions with ease In Detail Excel 2013 is one of the easiest to use data analysis tools you will ever come across. Its simplicity and powerful features has made it the go to tool for all your data needs. Complex operations with Excel, such as creating charts and graphs, visualization, and analyzing data make it a great tool for managers, data scientists, financial data analysts, and those who work closely with data. Learning data analysis and will help you bring your data skills to the next level. This book starts by walking you through creating your own data and bringing data into Excel from various sources. You'll learn the basics of SQL syntax and how to connect it to a Microsoft SQL Server Database using Excel's data connection tools. You will discover how to spot bad data and strategies to clean that data to make it useful to you. Next, you'll learn to create custom columns, identify key metrics, and make decisions based on business rules. You'll create macros using VBA and use Excel 2013's shiny new macros. Finally, at the end of the book, you'll be provided with useful shortcuts and tips, enabling you to do efficient data analysis and business modeling with Excel 2013. Style and approach This is a step-by-step guide to performing data analysis and business modelling with Excel 2013, complete with examples and tips.

Bring real business insights to your company through effective and engaging dashboards in QlikView About This Book * Build outstanding dashboards that respond to your company's information needs * Present the data in efficient and innovative ways to promote insights * Unleash the true power of QlikView by creating engaging visualizations Who This Book Is For This book is focused on QlikView developers with basic knowledge of scripting and layouts who want to improve their designing skills and build effective, eye-catching dashboards that deliver tangible value to their business. What You Will Learn * Build a comprehensive library of QlikView components to speed up your developments * Define a practical roadmap that will help you build business-driven dashboards * Explore the most effective and engaging ways to present data * Apply the best practices in the field of data visualization * Avoid common pitfalls when creating bar, line and pie charts * Create robust visualizations such as heat maps, histograms and scatter plots In Detail QlikView is one of the most powerful analytical tools in the market. Based on an in-memory associative model, it lets users freely navigate through the data, spot trends and make better decisions. This platform is capable of integrating a wide range of data sources like ERP systems, data warehouses or spreadsheets into a single application in order display dashboards with state-of-the-art visualizations. Creating Stunning Dashboards with QlikView is an easy to follow handbook that guides you through the process of creating an effective and engaging dashboard that delivers tangible value to the business. It starts with the identification of the business needs and the definition of the main KPIs, and takes you all the way to the application rollout. Throughout the book, you will learn how to apply some of the best practices in the field of data visualization, create a robust navigation schema, chose the best chart types for each scenario and many other things that will help you create effective dashboards that uncover all the stories behind the data. Style and approach This easy-to-follow compilation of best practices, tips, and tricks will help you leverage your QlikView developments. Each section presents practical guidelines to help you create dashboards that are not only functional, but also engaging and compelling.

A complete guide for Python programmers to master scientific computing using Python APIs and tools About This Book * The basics of scientific computing to advanced concepts involving parallel and large scale computation are all covered. * Most of the Python APIs and tools used in scientific computing are discussed in detail * The concepts are discussed with suitable example programs Who This Book Is For If you are a Python programmer and want to get your hands on scientific computing, this book is for you. The book expects you to have had exposure to various concepts of Python programming. What You Will Learn * Fundamentals and components of scientific computing * Scientific computing data management * Performing numerical computing using NumPy and SciPy * Concepts and programming for symbolic computing using SymPy * Using the plotting library matplotlib for data visualization * Data analysis and visualization using Pandas, matplotlib, and IPython * Performing parallel and high performance computing * Real-life case studies and best practices of scientific computing In Detail In today's world, along with theoretical and experimental work, scientific computing has become an important part of scientific disciplines. Numerical calculations, simulations and computer modeling in this day and age form the vast majority of both experimental and theoretical papers. In the scientific method, replication and reproducibility are two important contributing factors. A complete and concrete scientific result should be reproducible and replicable. Python is suitable for scientific computing. A large community of users, plenty of help and documentation, a large collection of scientific libraries and environments, great performance, and good support makes Python a great choice for scientific computing. At present Python is among the top choices for developing scientific workflow and the book targets existing Python developers to master this domain using Python. The main things to learn in the book are the concept of scientific workflow, managing scientific workflow data and performing computation on this data using Python. The book discusses NumPy, SciPy, SymPy, matplotlib, Pandas and IPython with several example programs. Style and approach This book follows a hands-on approach to explain the complex concepts related to scientific computing. It details various APIs using appropriate examples.

Over 90 hands-on recipes to design Internet scalable web and mobile applications with Amazon DynamoDB About This Book * Construct top-notch mobile and web applications with the Internet scalable NoSQL database and host it on cloud * Integrate your applications with other AWS services like AWS EMR, AWS S3, AWS Redshift, and AWS CloudSearch etc. in order to achieve a one-stop application stack * Step-by-step implementation guide that provides real-world use with hands-on recipes Who This Book Is For This book is intended for those who have a basic understanding of AWS services and want to take their knowledge to the next level by getting their hands dirty with coding recipes in DynamoDB. What You Will Learn * Design DynamoDB tables to achieve high read and write throughput * Discover best practices like caching, exponential back-offs and auto-retries, storing large items in AWS S3, storing compressed data etc. * Effectively use DynamoDB Local in order to make your development smooth and cost effective * Implement cost effective best practices to reduce the burden of DynamoDB charges * Create and maintain secondary indexes to support improved data access * Integrate various other AWS services like AWS EMR, AWS CloudSearch, AWS Pipeline etc. with DynamoDB In Detail AWS DynamoDB is an excellent example of a production-ready NoSQL database. In recent years, DynamoDB has been able to attract many customers because of its features like high-availability, reliability and infinite scalability. DynamoDB can be easily integrated with massive data crunching tools like Hadoop /EMR, which is an essential part of this data-driven world and hence it is widely accepted. The cost and time-efficient design makes DynamoDB stand out amongst its peers. The design of DynamoDB is so neat and clean that it has inspired many NoSQL databases to simply follow it. This book will get your hands on some engineering best practices DynamoDB engineers use, which can be used in your day-to-day life to build robust and scalable applications. You will start by operating with DynamoDB tables and learn to manipulate items and manage indexes. You will also discover how to easily integrate applications with other AWS services like EMR, S3, CloudSearch, RedShift etc. A couple of chapters talk in detail about how to use DynamoDB as a backend database and hosting it on AWS ElasticBean. This book will also focus on security measures of DynamoDB as well by providing techniques on data encryption, masking etc. By the end of the book you'll be adroit in designing web and mobile applications using DynamoDB and host it on cloud. Style and approach An easy-to-follow guide, full of real-world examples, which takes you through the world of DynamoDB following a step-by-step, problem-solution based approach.

Discover how to make your business data more interactive and engaging with SAP Lumira About This Book * Create a powerful data discovery experience with the advanced capabilities of SAP Lumira * Find business insights in your data through data blending, wrangling, transformation, and visualization * A fast-paced guide packed with hands-on practical examples, real-world solutions, and best practices to get you started with SAP Lumira Who This Book Is For If you are a SAP user, business analyst, BI developer, or a junior data engineer who wants to use SAP Lumira to build creative visualizations, this book is for you. You should have a reasonable level of knowledge of SAP Business Objects and its components. What You Will Learn * Deploy SAP Lumira on your computer and learn more about the SAP Lumira interface * Extract data from different sources using SAP Lumira's data connecters * Prepare, filter, clean, and format your data * Discover visualization techniques and data discovery methods * Administrate and customize SAP Lumira to get basic knowledge of its SDK * Create various charts to deliver fantastic data visualizations * Connect to SAP BusinessObjects BI Platform and SAP HANA to extract, prepare, and visualize data In Detail SAP Lumira allows you to combine data from multiple sources into a single view and create engaging visualizations quickly and easily. It is a reporting platform that helps users access data and independently perform analysis. With the increasing interest in data discovery, self-service BI, and visualization around the world, tools like SAP Lumira help to eliminate the complexities of analyzing and discovering data. Learn data discovery techniques, build amazing visualizations, create fantastic stories, and share your visualizations through an electronic medium with one of the most powerful tools around-SAP Lumira. You will begin with an overview of the SAP Lumira family of products. You will then go through various data discovery techniques using real-world scenarios of an online e-commerce retailer through detailed recipes on the installation, administration, and customization of SAP Lumira. Next, you will work with data, starting from acquiring data from various data sources, then preparing and visualizing it using the rich functionality of SAP Lumira. Finally, you will present data via a data story or infographic and publish it across your organization or on the World Wide Web. Style and approach This is a step-by-step guide to learning SAP Lumira essentials packed with examples on real-world problems and solutions.

About This Book Get acquainted with the basics of Windows Server Hyper-V 2012 R2 and understand how to efficiently design a highly available virtualization solution Assess your physical server environment and understand the fundamentals of server consolidation and sizing of Hyper-V hosts Design practical solutions for common design patterns with explanations of these design decisions Who This Book Is For This book is aimed at IT admins, consultants, and architects alike who wish to deploy, manage, and maintain Hyper-V solutions in organizations of various sizes. You are expected to have a working knowledge of managing Windows Server and a fair understanding of networking and storage concepts. What You Will Learn Set up independent and highly available clustered Hyper-V hosts via GUI and PowerShell Acquire knowledge about Generation 1 and 2 Virtual Machines, their creation and management, and also look at the VM Conversion process Understand NIC teaming, Extensible Virtual Switch, and other networking advancements Gain insight into virtual machine storage changes and their follow-up benefits Discover backup and recovery patterns for Hyper-V Familiarize yourself with the essentials of Hyper-V Replica Leverage the benefits of Microsoft VDI In DetailThis book is a practical, example-oriented tutorial that will guide you through the basics and architecture of the Hyper-V platform and help you understand how to build your virtualization infrastructure from the ground up. It then goes on to focus on scalability and high availability aspects, and trains you to set up highly available Hyper-V clusters and perform the live migration of virtual machines. You will also learn about advancements in virtual networking and storage in Windows Server 2012 and Windows Server 2012 R2. Finally, the book then advises you on how to set up backup and recovery and how to prepare a disaster recovery plan via Hyper-V Replica, concluding with insight into Microsoft VDI implementation guidance.

COM051000

0

COM051360

About This Book Learn key principles to model business processes with BPMN and BPEL, and execute them in an SOA environment. Use best practices for composite applications, including service design and human interactions, and apply them in your daily projects. Design, implement, and optimize business processes with real-world examples illustrating all key concepts Who This Book Is ForThis book is intended for BPM and SOA architects, analysts, developers, and project managers who are responsible for, or involved in, business process development, modelling, monitoring, or the implementation of composite, process-oriented applications. The principles are relevant for the design of on-premise and cloud solutions.

0

0