Explore the modern market of data analytics platforms and the benefits of using Snowflake computing, the data warehouse built for the cloud. With the rise of cloud technologies, organizations prefer to deploy their analytics using cloud providers such as Amazon Web Services (AWS), Microsoft Azure, or Google Cloud Platform. Cloud vendors are offering modern data platforms for building cloud analytics solutions to collect data and consolidate into single storage solutions that provide insights for business users. The core of any analytics framework is the data warehouse, and previously customers did not have many choices of platform to use. Snowflake was built specifically for the cloud and it is a true game changer for the analytics market. This book will help onboard you to Snowflake, present best practices to deploy, and use the Snowflake data warehouse. In addition, it covers modern analytics architecture and use cases. It provides use cases of integration with leading analytics software such as Matillion ETL, Tableau, and Databricks. Finally, it covers migration scenarios for on-premise legacy data warehouses. What You Will Learn Know the key functionalities of Snowflake Set up security and access with cluster Bulk load data into Snowflake using the COPY command Migrate from a legacy data warehouse to Snowflake integrate the Snowflake data platform with modern business intelligence (BI) and data integration tools Who This Book Is For Those working with data warehouse and business intelligence (BI) technologies, and existing and potential Snowflake users

Solve real-world data problems and create data-driven workflows for easy data movement and processing at scale with Azure Data Factory Key Features Learn how to load and transform data from various sources, both on-premises and on cloud Use Azure Data Factory's visual environment to build and manage hybrid ETL pipelines Discover how to prepare, transform, process, and enrich data to generate key insights Book DescriptionAzure Data Factory (ADF) is a modern data integration tool available on Microsoft Azure. This Azure Data Factory Cookbook helps you get up and running by showing you how to create and execute your first job in ADF. You'll learn how to branch and chain activities, create custom activities, and schedule pipelines. This book will help you to discover the benefits of cloud data warehousing, Azure Synapse Analytics, and Azure Data Lake Gen2 Storage, which are frequently used for big data analytics. With practical recipes, you'll learn how to actively engage with analytical tools from Azure Data Services and leverage your on-premise infrastructure with cloud-native tools to get relevant business insights. As you advance, you'll be able to integrate the most commonly used Azure Services into ADF and understand how Azure services can be useful in designing ETL pipelines. The book will take you through the common errors that you may encounter while working with ADF and show you how to use the Azure portal to monitor pipelines. You'll also understand error messages and resolve problems in connectors and data flows with the debugging capabilities of ADF. By the end of this book, you'll be able to use ADF as the main ETL and orchestration tool for your data warehouse or data platform projects. What you will learn Create an orchestration and transformation job in ADF Develop, execute, and monitor data flows using Azure Synapse Create big data pipelines using Azure Data Lake and ADF Build a machine learning app with Apache Spark and ADF Migrate on-premises SSIS jobs to ADF Integrate ADF with commonly used Azure services such as Azure ML, Azure Logic Apps, and Azure Functions Run big data compute jobs within HDInsight and Azure Databricks Copy data from AWS S3 and Google Cloud Storage to Azure Storage using ADF's built-in connectors Who this book is forThis book is for ETL developers, data warehouse and ETL architects, software professionals, and anyone who wants to learn about the common and not-so-common challenges faced while developing traditional and hybrid ETL solutions using Microsoft's Azure Data Factory. You'll also find this book useful if you are looking for recipes to improve or enhance your existing ETL pipelines. Basic knowledge of data warehousing is expected.

Learn through hands-on exercises covering a variety of topics including data connections, analytics, and dashboards to effectively prepare for the Tableau Desktop Certified Associate exam Key Features Prepare for the Tableau Desktop Certified Associate exam with the help of tips and techniques shared by experts Implement Tableau's advanced analytical capabilities such as forecasting Delve into advanced Tableau features and explore best practices for building dashboards Book DescriptionThe Tableau Desktop Certified Associate exam measures your knowledge of Tableau Desktop and your ability to work with data and data visualization techniques. This book will help you to become well-versed in Tableau software and use its business intelligence (BI) features to solve BI and analytics challenges. With the help of this book, you'll explore the authors' success stories and their experience with Tableau. You'll start by understanding the importance of Tableau certification and the different certification exams, along with covering the exam format, Tableau basics, and best practices for preparing data for analysis and visualization. The book builds on your knowledge of advanced Tableau topics such as table calculations for solving problems. You'll learn to effectively visualize geographic data using vector maps. Later, you'll discover the analytics capabilities of Tableau by learning how to use features such as forecasting. Finally, you'll understand how to build and customize dashboards, while ensuring they convey information effectively. Every chapter has examples and tests to reinforce your learning, along with mock tests in the last section. By the end of this book, you'll be able to efficiently prepare for the certification exam with the help of mock tests, detailed explanations, and expert advice from the authors. What you will learn Apply Tableau best practices to analyze and visualize data Use Tableau to visualize geographic data using vector maps Create charts to gain productive insights into data and make quality-driven decisions Implement advanced analytics techniques to identify and forecast key values Prepare customized table calculations to compute specific values Answer questions based on the Tableau Desktop Certified Associate exam with the help of mock tests Who this book is forThis Tableau certification book is for business analysts, BI professionals, and data analysts who want to become certified Tableau Desktop Associates and solve a range of data science and business intelligence problems using this example-packed guide. Some experience in Tableau Desktop is expected to get the most out of this book.

Perform advanced dashboard, visualization, and analytical techniques with Tableau Desktop, Tableau Prep, and Tableau Server Key Features Unique problem-solution approach to aid effective business decision-making Create interactive dashboards and implement powerful business intelligence solutions Includes best practices on using Tableau with modern cloud analytics services Book DescriptionTableau has been one of the most popular business intelligence solutions in recent times, thanks to its powerful and interactive data visualization capabilities. Tableau 2019.x Cookbook is full of useful recipes from industry experts, who will help you master Tableau skills and learn each aspect of Tableau's ecosystem. This book is enriched with features such as Tableau extracts, Tableau advanced calculations, geospatial analysis, and building dashboards. It will guide you with exciting data manipulation, storytelling, advanced filtering, expert visualization, and forecasting techniques using real-world examples. From basic functionalities of Tableau to complex deployment on Linux, you will cover it all. Moreover, you will learn advanced features of Tableau using R, Python, and various APIs. You will learn how to prepare data for analysis using the latest Tableau Prep. In the concluding chapters, you will learn how Tableau fits the modern world of analytics and works with modern data platforms such as Snowflake and Redshift. In addition, you will learn about the best practices of integrating Tableau with ETL using Matillion ETL. By the end of the book, you will be ready to tackle business intelligence challenges using Tableau's features. What you will learn Understand the basic and advanced skills of Tableau Desktop Implement best practices of visualization, dashboard, and storytelling Learn advanced analytics with the use of build in statistics Deploy the multi-node server on Linux and Windows Use Tableau with big data sources such as Hadoop, Athena, and Spectrum Cover Tableau built-in functions for forecasting using R packages Combine, shape, and clean data for analysis using Tableau Prep Extend Tableau's functionalities with REST API and R/Python Who this book is forTableau 2019.x Cookbook is for data analysts, data engineers, BI developers, and users who are looking for quick solutions to common and not-so-common problems faced while using Tableau products. Put each recipe into practice by bringing the latest offerings of Tableau 2019.x to solve real-world analytics and business intelligence challenges. Some understanding of BI concepts and Tableau is required.

Build world-class enterprise Business Intelligence solutions with MicroStrategy 10 About This Book * Fix the gap between BI tools and implementation/integration processes with big data and predictive analytics using this comprehensive guide to MicroStrategy 10 * Highly practical, example-rich guide that lets you implement business intelligence with MicroStrategy 10 in your organization * Create the best user experience with BI dashboards using MicroStrategy using this up-to-date, comprehensive guide Who This Book Is For This book is intended for BI, DWH, ETL developers, BI/DWH/Analytics managers, analysts, and business users who already have MicroStrategy in their organization and want to take it to the next level in order to increase performance and improve user experience. In addition, it helps the reader to migrate from MicroStrategy 9 to MicroStrategy 10 and to start using the new capabilities. What You Will Learn * Explore various visualization techniques for presenting analyzed data * Customize MicroStrategy in order to meet your business requirements * Develop and design mobile dashboards * Use the advanced techniques such as designing reports, documents and interactive dashboards for building dashboards * Understand the concepts of data discovery and Desktop capabilities * Explore the best practices for Microstrategy system administration * Find and fix issues based on connections, environment or documents * Integrate third party ESRI map tools with MicroStrategy to create geo based reports In Detail Business intelligence is becoming more important by the day, with cloud offerings and mobile devices gaining wider acceptance and achieving better market penetration. MicroStrategy Reporting Suite is an absolute leader in the BI market and offers rich capabilities from basic data visualizations to predictive analytics. It lets you various delivery methods such as the Web, desktops, and mobiles. Using real-world BI scenarios, this book helps you to implement Business Analytics solutions in big e-commerce companies. It kicks off with MicroStrategy 10 features and then covers schema design models and techniques. Building upon your existing knowledge, the book will teach you advanced techniques for building documents and dashboards. It further teaches various graphical techniques for presenting data for analysis using maps, graphs, and advanced charts. Although MicroStrategy has rich functionality, the book will show how to customize it in order to meet your business requirements. You will also become familiar with the native analytical functions that will help you to maximize the impact of BI solutions with powerful predictive analytics. Furthermore, the book will focus on MicroStrategy Mobile Analytics along with data discovery and desktop capabilities such as connecting various data sources and building interactive dashboards. The book will also uncover best practices, troubleshooting techniques for MicroStrategy system administration, and also security and authentication techniques. Lastly, you will learn to use Hadoop for MicroStrategy reporting. By the end of the book, you will become proficient in evaluating any BI software in order to choose the best one that meets all business requirements. Style and approach This book will be focusing on providing extensive guide to plan how to design and develop complex BI architecture for real world scenario, using Microstrategy 10, best practices and collected experience working with BI, predictive analytics, and Microstrategy and big data.

Visualize and analyze your Hadoop data using Hunk About This Book * Explore your data in Hadoop and NoSQL data stores * Create and optimize your reporting experience with advanced data visualizations and data analytics * A comprehensive developer's guide that helps you create outstanding analytical solutions efficiently Who This Book Is For If you are Hadoop developers who want to build efficient real-time Operation Intelligence Solutions based on Hadoop deployments or various NoSQL data stores using Hunk, this book is for you. Some familiarity with Splunk is assumed. What You Will Learn * Deploy and configure Hunk on top of Cloudera Hadoop * Create and configure Virtual Indexes for datasets * Make your data presentable using the wide variety of data visualization components and knowledge objects * Design a data model using Hunk best practices * Add more flexibility to your analytics solution via extended SDK and custom visualizations * Discover data using MongoDB as a data source * Integrate Hunk with AWS Elastic MapReduce to improve scalability In Detail Hunk is the big data analytics platform that lets you rapidly explore, analyse, and visualize data in Hadoop and NoSQL data stores. It provides a single, fluid user experience, designed to show you insights from your big data without the need for specialized skills, fixed schemas, or months of development. Hunk goes beyond typical data analysis methods and gives you the power to rapidly detect patterns and find anomalies across petabytes of raw data. This book focuses on exploring, analysing, and visualizing big data in Hadoop and NoSQL data stores with this powerful full-featured big data analytics platform. You will begin by learning the Hunk architecture and Hunk Virtual Index before moving on to how to easily analyze and visualize data using Splunk Search Language (SPL). Next you will meet Hunk Apps which can easy integrate with NoSQL data stores such as MongoDB or Sqqrl. You will also discover Hunk knowledge objects, build a semantic layer on top of Hadoop, and explore data using the friendly user-interface of Hunk Pivot. You will connect MongoDB and explore data in the data store. Finally, you will go through report acceleration techniques and analyze data in the AWS Cloud. Style and approach A step-by-step guide starting right from the basics and deep diving into the more advanced and technical aspects of Hunk.

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.