Streamline your workflow, transform raw data into actionable insights, and use Alteryx Designer to shape, design, and visualize data Key Features Acquire the skills necessary to perform analytics operations like an expert Discover hidden trends and insights in your data from various sources to make accurate predictions Reduce the time and effort required to derive insights from your data Purchase of the print or Kindle book includes a free eBook in the PDF format Book DescriptionAlteryx allows you to create data manipulation and analytic workflows with a simple, easy-to-use, code-free UI, and perform fast-executing workflows, offering multiple ways to achieve the same results. The Alteryx Designer Cookbook is a comprehensive guide to maximizing your Alteryx skills and determining the best ways to perform data operations This book's recipes will guide you through an analyst's complete journey, covering all aspects of the data life cycle. The first set of chapters will teach you how to read data from various sources to obtain reports and pass it through the required adjustment operations for analysis. After an explanation of the Alteryx platform components with a particular focus on Alteryx Designer, you’ll be taken on a tour of what and how you can accomplish by using this tool. Along the way, you’ll learn best practices and design patterns. The book also covers real-world examples to help you apply your understanding of the features in Alteryx to practical scenarios By the end of this book, you’ll have enhanced your proficiency with Alteryx Designer and an improved ability to execute tasks within the tool efficientlyWhat you will learn Speed up the cleansing, data preparing, and shaping process Perform operations and transformations on the data to suit your needs Blend different types of data sources for analysis Pivot and un-pivot the data for easy manipulation Perform aggregations and calculations on the data Encapsulate reusable logic into macros Develop high-quality, data-driven reports to improve consistency Who this book is for This book is for data analysts, data professionals, and business intelligence professionals seeking to harness the full potential of the tool. A basic understanding of Alteryx Designer and Alteryx terminology, including macros, apps, and workflows, is all you need to get started with this book.

Implement your Business Intelligence solutions without any coding - by leveraging the power of the Alteryx platform About This Book Experience the power of codeless analytics using Alteryx, a leading Business Intelligence tool Uncover hidden trends and valuable insights from your data across different sources and make accurate predictions Includes real-world examples to put your understanding of the features in Alteryx to practical use Who This Book Is For This book is for aspiring data professionals who want to learn and implement self-service analytics from scratch, without any coding. Those who have some experience with Alteryx and want to gain more proficiency will also find this book to be useful. A basic understanding of the data science concepts is all you need to get started with this book. What You Will Learn Create efficient workflows with Alteryx to answer complex business questions Learn how to speed up the cleansing, data preparing, and shaping process Blend and join data into a single dataset for self-service analysis Write advanced expressions in Alteryx leading to an optimal workflow for efficient processing of huge data Develop high-quality, data-driven reports to improve consistency in reporting and analysis Explore the flexibility of macros by automating analytic processes Apply predictive analytics from spatial, demographic, and behavioral analysis and quickly publish, schedule Share your workflows and insights with relevant stakeholders In Detail Alteryx, as a leading data blending and advanced data analytics platform, has taken self-service data analytics to the next level. Companies worldwide often find themselves struggling to prepare and blend massive datasets that are time-consuming for analysts. Alteryx solves these problems with a repeatable workflow designed to quickly clean, prepare, blend, and join your data in a seamless manner. This book will set you on a self-service data analytics journey that will help you create efficient workflows using Alteryx, without any coding involved. It will empower you and your organization to take well-informed decisions with the help of deeper business insights from the data.Starting with the fundamentals of using Alteryx such as data preparation and blending, you will delve into the more advanced concepts such as performing predictive analytics. You will also learn how to use Alteryx's features to share the insights gained with the relevant decision makers. To ensure consistency, we will be using data from the Healthcare domain throughout this book. The knowledge you gain from this book will guide you to solve real-life problems related to Business Intelligence confidently. Whether you are a novice with Alteryx or an experienced data analyst keen to explore Alteryx's self-service analytics features, this book will be the perfect companion for you. Style and approach Comprehensive, step by step guide filled with real-world examples to step through the complex business questions using one of the leading data analytics platform.

Dealing with massive amounts of messy data as part of Microsoft Excel(TM) calculations has traditionally been an enormously labor-intensive and time-consuming challenge for accounting, tax and finance professionals. This book explains how Alteryx(TM) can be used to address these challenges in a progressive, fully illustrated manner.- Learn how to import data from Excel and other sources into Alteryx using the Input Data tool.- Develop Alteryx "workflows" to quickly and systemically organize, format, cleanse and analyze large amounts of data using tools such as Select Records, Dynamic Rename, Select, Filter, Unique, Text to Columns, DateTime and several others.- Cleanly and accurately combine separate datasets using the Join and Union Tools.- Learn advanced techniques for manipulating data presented in rows and columns using the CrossTab and Transpose tools.- Use the Summarize tool to perform calculations and to aggregate data in rows.- Export data that you've cleaned and organized to Excel using the Output Data tool for further computations and analysis.- Review methods and techniques for taking advantage of the speed and power of Alteryx while simultaneously strengthening internal controls.All of the material presented in this book is explained in the context of financial and other examples that matter to accounting, tax and finance professionals. If you've been searching for a better, faster and more accurate way to organize large amounts of data that feed into and support complex Excel calculations, this is the guide you've been looking for!

Whether you're a beginner just learning how to create data visualizations or a Jedi who's already used Tableau for years, this cookbook has a recipe for everyone. Author Lorna Brown provides more than 100 practical recipes to enhance the way you build Tableau dashboards--and helps you understand your data through the power of Tableau Desktop's interactive datavisualizations. With this cookbook, Tableau beginners will learn hands-on how this unique self-serve tool works, while experienced users will find this book to be an ideal reference guide on how to employ specific techniques. It also links you to online resources and community features, such as Tableau Tip Tuesday and Workout Wednesday. By the time you reach the end, you'll be a competent user of Tableau Desktop. You'll learn how to: Build both basic and complex data visualizations with Tableau Desktop Gain hands-on experience with Tableau's latest features, including set and parameter actions Create interactive dashboards to support business questions Improve your analytical skills to enhance the visualizations you've already created Learn data visualization skills and best practices to help you and your organization

Over the years, thousands of tools have been developed for debugging TCP/IP networks. They range from very specialized tools that do one particular task, to generalized suites that do just about everything except replace bad Ethernet cables. Even better, many of them are absolutely free. There's only one problem: who has time to track them all down, sort through them for the best ones for a particular purpose, or figure out how to use them?Network Troubleshooting Tools does the work for you--by describing the best of the freely available tools for debugging and troubleshooting. You can start with a lesser-known version of ping that diagnoses connectivity problems, or take on a much more comprehensive program like MRTG for graphing traffic through network interfaces. There's tkined for mapping and automatically monitoring networks, and Ethereal for capturing packets and debugging low-level problems.This book isn't just about the tools available for troubleshooting common network problems. It also outlines a systematic approach to network troubleshooting: how to document your network so you know how it behaves under normal conditions, and how to think about problems when they arise, so you can solve them more effectively.The topics covered in this book include: Understanding your network Connectivity testing Evaluating the path between two network nodes Tools for capturing packets Tools for network discovery and mapping Tools for working with SNMP Performance monitoring Testing application layer protocols Software sources If you're involved with network operations, this book will save you time, money, and needless experimentation.

A proven way to put together a portfolio that enhances performance and reduces risk Professor Craig Israelsen of Brigham Young University is an important voice in the area of asset allocation. The reason? He keeps things simple. Now, in 7Twelve, he shows you how to do the same, and demonstrates how his approach to investing can help you grow your money as well as protect it. 7Twelve outlines a multi-asset balanced portfolio that is a logical starting point when assembling a portfolio-either as the blueprint for the entire portfolio or as a significant building block. Page by page, he will show you how to create a balanced portfolio utilizing multiple asset classes to enhance performance and reduce risk. Discusses how the 7Twelve portfolio includes seven core asset classes and utilizes twelve specific mutual funds or exchange traded funds Details the tax efficiency of this specific investment approach Shows you how to use the 7Twelve portfolio as a pre-retirement accumulation portfolio or a post-retirement distribution portfolio If you want to build a well-balanced, multi-asset portfolio, 7Twelve is the book for you.

Simplify your ETL processes with these hands-on data hygiene tips, tricks, and best practices. Key FeaturesFocus on the basics of data wranglingStudy various ways to extract the most out of your data in less timeBoost your learning curve with bonus topics like random data generation and data integrity checksBook Description For data to be useful and meaningful, it must be curated and refined. Data Wrangling with Python teaches you the core ideas behind these processes and equips you with knowledge of the most popular tools and techniques in the domain. The book starts with the absolute basics of Python, focusing mainly on data structures. It then delves into the fundamental tools of data wrangling like NumPy and Pandas libraries. You’ll explore useful insights into why you should stay away from traditional ways of data cleaning, as done in other languages, and take advantage of the specialized pre-built routines in Python. This combination of Python tips and tricks will also demonstrate how to use the same Python backend and extract/transform data from an array of sources including the Internet, large database vaults, and Excel financial tables. To help you prepare for more challenging scenarios, you’ll cover how to handle missing or wrong data, and reformat it based on the requirements from the downstream analytics tool. The book will further help you grasp concepts through real-world examples and datasets. By the end of this book, you will be confident in using a diverse array of sources to extract, clean, transform, and format your data efficiently. What you will learnUse and manipulate complex and simple data structuresHarness the full potential of DataFrames and numpy.array at run timePerform web scraping with BeautifulSoup4 and html5libExecute advanced string search and manipulation with RegEXHandle outliers and perform data imputation with PandasUse descriptive statistics and plotting techniquesPractice data wrangling and modeling using data generation techniquesWho this book is for Data Wrangling with Python is designed for developers, data analysts, and business analysts who are keen to pursue a career as a full-fledged data scientist or analytics expert. Although, this book is for beginners, prior working knowledge of Python is necessary to easily grasp the concepts covered here. It will also help to have rudimentary knowledge of relational database and SQL.