Vihag Gupta - Business Intelligence with Databricks SQL: Concepts, tools, and techniques for scaling business intelligence on the data lakehouse

Concepts, tools, and techniques for scaling business intelligence on the data lakehouse

Vihag Gupta

BIRMINGHAMMUMBAI

Copyright 2022 Packt Publishing

All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.

Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the author(s), nor Packt Publishing or its dealers and distributors, will be held liable for any damages caused or alleged to have been caused directly or indirectly by this book.

Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.

Group Product Manager: Reshma Raman

Publishing Product Manager: Heramb Bhavsar

Senior Editor: Nazia Shaikh

Technical Editor: Sweety Pagaria

Copy Editor: Safis Editing

Project Coordinator: Farheen Fathima

Proofreader: Safis Editing

Indexer: Rekha Nair

Production Designer: Vijay Kamble

Marketing Coordinator: Nivedita Singh

First published: September 2022

Production reference: 1260822

Published by Packt Publishing Ltd.

Livery Place

35 Livery Street

Birmingham

B3 2PB, UK.

ISBN 978-1-80323-533-2

www.packt.com

This book came into life with the eternal blessings from Dada Ji & Dadi Ji &Love from Mom, Dad, Utkarsh, Suteja, Toffee & Love for the One who is arriving.

Vihag Gupta

Vihag Gupta is a solutions architect with a specialization in cloud data platform architecture and design. He has a background in data engineering and a professional interest in machine learning. He loves getting hands-on and solving real business problems with technology. He graduated with a degree in information technology from PES University, Bengaluru, in 2011 and earned a degree in information systems management from Carnegie Mellon University, Pittsburgh, in 2016. He has worked at companies including Deloitte Consulting, DataSpark, and Qubole. He currently works at Databricks, helping clients bring their lakehouse platforms for analytics to life.

Originally from Jharkhand, India, Vihag currently lives in Singapore with his wife and dog.

Jerrold Law currently works at Databricks as a specialist solutions architect, specializing in data engineering and streaming. He helps organizations all over the world to adopt scalable big data processing use cases with the Lakehouse architecture. Prior to Databricks, he worked for Confluent, helping enterprise organizations to enable their real-time streaming use cases as part of the solutions engineering field team.

Ivan Tang is a solutions architect at Databricks, helping enterprises in the ASEAN region in their cloud transformation journey. Previously, he worked with Confluent Professional Services, where he helped enterprises from the APAC region to design, build, operate, and maintain event streaming platforms using Apache Kafka and Confluent. Prior to that, he was wrangling data and building models while being an architect, builder, and user of distributed systems, including Hadoop, Storm, Kafka, and Spark. Prior to that, he worked for Confluent, GIC (Singapores sovereign wealth fund), and other firms.

With over 15 years of experience working as a solutions architect for some of the largest and most innovative companies in the world, including Amazon, Bridgewater, and Bloomberg, Tomasz Kurzydym is a strong supporter and advocate for constant learning, experimentation, and curiosity. His work has taken him from his native country of Poland to the USA and UK, and he now lives with his family in Singapore working for Databricks a data and AI company. In his spare time, Tomasz enjoys traveling, skiing, and photography.

Mahdi Askari is a lead solutions architect at Databricks. He is a software engineer at heart, and has been working in the data and big data space since 2010. He has worked across different industries with customers and prospects using Databricks Lakehouse to derive insight from their data.

Roja Boina is an engineering senior advisor. She provides data-driven solutions to enterprises. She takes pride in her get-it-done attitude. She enjoys defining requirements, designing, developing, testing, and delivering backend applications, and communicating data through visualizations. She is very passionate about being a Women in Tech (WIT) advocate and being a part of WIT communities. Outside of her 9-5, she loves to volunteer for non-profits and mentor fellow women in STEM. She believes in having a growth mindset.