Data Mashup with Microsoft Excel Using Power Query and M

Data Mashup with Microsoft Excel Using Power Query and M

Master the art of loading external data into Excel for use in reporting, charting, dashboarding, and business intelligence. This book provides a complete and thorough explanation of Microsoft Excel’s Get and Transform feature set, showing you how to connect to a range of external databases and other data…

The Modern Data Warehouse in Azure

The Modern Data Warehouse in Azure

Gone are the days when data warehousing projects were lumbering dinosaur-style projects that took forever, drained budgets, and produced business intelligence (BI) just in time to tell you what to do 10 years ago. This book will show you how to assemble a data warehouse solution like a…

SQL Server Big Data Clusters, 2nd Edition

SQL Server Big Data Clusters, 2nd Edition

Use this guide to one of SQL Server 2019’s most impactful features―Big Data Clusters. You will learn about data virtualization and data lakes for this complete artificial intelligence (AI) and machine learning (ML) platform within the SQL Server database engine. You will know how to use Big Data Clusters…

MySQL 8 Query Performance Tuning

MySQL 8 Query Performance Tuning

Identify, analyze, and improve poorly performing queries that damage user experience and lead to lost revenue for your business. This book will help you make query tuning an integral part of your daily routine through a multi-step process that includes monitoring of execution times, identifying candidate queries for…

PostgreSQL Configuration

PostgreSQL Configuration

Obtain all the skills you need to configure and manage a PostgreSQL database. In this book you will begin by installing and configuring PostgreSQL on a server by focusing on system-level parameter settings before installation. You will also look at key post-installation steps to avoid issues in the…

Build A Career in Data Science

Build A Career in Data Science

Build a Career in Data Science is the top guide to help readers get their first data science job, then quickly becoming a senior employee. Industry experts Jacqueline Nolis and Emily Robinson lay out the soft skills readers need alongside their technical know-how in order to succeed in the…

Machine Learning with R, tidyverse, and mlr

Machine Learning with R, tidyverse, and mlr

Machine Learning with R, tidyverse, and mlr teaches readers how to gain valuable insights from their data using the powerful R programming language. In his engaging and informal style, author and R expert Hefin Ioan Rhys lays a firm foundation of ML basics and introduces readers to the tidyverse,…

Building a Data Integration Team

Building a Data Integration Team

Find the right people with the right skills. This book clarifies best practices for creating high-functioning data integration teams, enabling you to understand the skills and requirements, documents, and solutions for planning, designing, and monitoring both one-time migration and daily integration systems. The growth of data is exploding….

Data Mashups in R

Data Mashups in R

How do you use R to import, manage, visualize, and analyze real-world data? With this short, hands-on tutorial, you learn how to collect online data, massage it into a reasonable form, and work with it using R facilities to interact with web servers, parse Html and Xml, and…

Kafka in Action

Kafka in Action

Kafka in Action is a practical, hands-on guide to building Kafka-based data pipelines. Filled with real-world use cases and scenarios, this book probes Kafka’s most common use cases, ranging from simple logging through managing streaming data systems for message routing, analytics, and more. In systems that handle big data,…