Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletter Hub
Free Learning
Arrow right icon
timer SALE ENDS IN
0 Days
:
00 Hours
:
00 Minutes
:
00 Seconds
Business Intelligence with Databricks SQL
Business Intelligence with Databricks SQL

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

Arrow left icon
Profile Icon Vihag Gupta
Arrow right icon
₱1726.99 ₱1918.99
Full star icon Full star icon Full star icon Full star icon Half star icon 4.6 (13 Ratings)
eBook Sep 2022 348 pages 1st Edition
eBook
₱1726.99 ₱1918.99
Paperback
₱2398.99
Subscription
Free Trial
Arrow left icon
Profile Icon Vihag Gupta
Arrow right icon
₱1726.99 ₱1918.99
Full star icon Full star icon Full star icon Full star icon Half star icon 4.6 (13 Ratings)
eBook Sep 2022 348 pages 1st Edition
eBook
₱1726.99 ₱1918.99
Paperback
₱2398.99
Subscription
Free Trial
eBook
₱1726.99 ₱1918.99
Paperback
₱2398.99
Subscription
Free Trial

What do you get with eBook?

Product feature icon Instant access to your Digital eBook purchase
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
Product feature icon AI Assistant (beta) to help accelerate your learning
OR
Modal Close icon
Payment Processing...
tick Completed

Billing Address

Table of content icon View table of contents Preview book icon Preview Book

Business Intelligence with Databricks SQL

Left arrow icon Right arrow icon
Download code icon Download Code

Key benefits

  • Learn about business intelligence on the lakehouse with features and functions of Databricks SQL
  • Make the most of Databricks SQL by getting to grips with the enablers of its data warehousing capabilities
  • A unique approach to teaching concepts and techniques with follow-along scenarios on real datasets

Description

In this new era of data platform system design, data lakes and data warehouses are giving way to the lakehouse – a new type of data platform system that aims to unify all data analytics into a single platform. Databricks, with its Databricks SQL product suite, is the hottest lakehouse platform out there, harnessing the power of Apache Spark™, Delta Lake, and other innovations to enable data warehousing capabilities on the lakehouse with data lake economics. This book is a comprehensive hands-on guide that helps you explore all the advanced features, use cases, and technology components of Databricks SQL. You’ll start with the lakehouse architecture fundamentals and understand how Databricks SQL fits into it. The book then shows you how to use the platform, from exploring data, executing queries, building reports, and using dashboards through to learning the administrative aspects of the lakehouse – data security, governance, and management of the computational power of the lakehouse. You’ll also delve into the core technology enablers of Databricks SQL – Delta Lake and Photon. Finally, you’ll get hands-on with advanced SQL commands for ingesting data and maintaining the lakehouse. By the end of this book, you’ll have mastered Databricks SQL and be able to deploy and deliver fast, scalable business intelligence on the lakehouse.

Who is this book for?

This book is for business intelligence practitioners, data warehouse administrators, and data engineers who are new to Databrick SQL and want to learn how to deliver high-quality insights unhindered by the scale of data or infrastructure. This book is also for anyone looking to study the advanced technologies that power Databricks SQL. Basic knowledge of data warehouses, SQL-based analytics, and ETL processes is recommended to effectively learn the concepts introduced in this book and appreciate the innovation behind the platform.

What you will learn

  • Understand how Databricks SQL fits into the Databricks Lakehouse Platform
  • Perform everyday analytics with Databricks SQL Workbench and business intelligence tools
  • Organize and catalog your data assets
  • Program the data security model to protect and govern your data
  • Tune SQL warehouses (computing clusters) for optimal query experience
  • Tune the Delta Lake storage format for maximum query performance
  • Deliver extreme performance with the Photon query execution engine
  • Implement advanced data ingestion patterns with Databricks SQL

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Sep 16, 2022
Length: 348 pages
Edition : 1st
Language : English
ISBN-13 : 9781803237596
Vendor :
Databricks
Category :

What do you get with eBook?

Product feature icon Instant access to your Digital eBook purchase
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
Product feature icon AI Assistant (beta) to help accelerate your learning
OR
Modal Close icon
Payment Processing...
tick Completed

Billing Address

Product Details

Publication date : Sep 16, 2022
Length: 348 pages
Edition : 1st
Language : English
ISBN-13 : 9781803237596
Vendor :
Databricks
Category :

Packt Subscriptions

See our plans and pricing
Modal Close icon
$19.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
$199.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just ₱260 each
Feature tick icon Exclusive print discounts
$279.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just ₱260 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total 7,706.97
Business Intelligence with Databricks SQL
₱2398.99
SQL Server Query Tuning and Optimization
₱2653.99
Azure Data Engineering Cookbook
₱2653.99
Total 7,706.97 Stars icon

Table of Contents

20 Chapters
Part 1: Databricks SQL on the Lakehouse Chevron down icon Chevron up icon
Chapter 1: Introduction to Databricks Chevron down icon Chevron up icon
Chapter 2: The Databricks Product Suite – A Visual Tour Chevron down icon Chevron up icon
Chapter 3: The Data Catalog Chevron down icon Chevron up icon
Chapter 4: The Security Model Chevron down icon Chevron up icon
Chapter 5: The Workbench Chevron down icon Chevron up icon
Chapter 6: The SQL Warehouses Chevron down icon Chevron up icon
Chapter 7: Using Business Intelligence Tools with Databricks SQL Chevron down icon Chevron up icon
Part 2: Internals of Databricks SQL Chevron down icon Chevron up icon
Chapter 8: The Delta Lake Chevron down icon Chevron up icon
Chapter 9: The Photon Engine Chevron down icon Chevron up icon
Chapter 10: Warehouse on the Lakehouse Chevron down icon Chevron up icon
Part 3: Databricks SQL Commands Chevron down icon Chevron up icon
Chapter 11: SQL Commands – Part 1 Chevron down icon Chevron up icon
Chapter 12: SQL Commands – Part 2 Chevron down icon Chevron up icon
Part 4: TPC-DS, Experiments, and Frequently Asked Questions Chevron down icon Chevron up icon
Chapter 13: Playing with the TPC-DS Dataset Chevron down icon Chevron up icon
Chapter 14: Ask Me Anything Chevron down icon Chevron up icon
Index Chevron down icon Chevron up icon
Other Books You May Enjoy Chevron down icon Chevron up icon

Customer reviews

Top Reviews
Rating distribution
Full star icon Full star icon Full star icon Full star icon Half star icon 4.6
(13 Ratings)
5 star 61.5%
4 star 38.5%
3 star 0%
2 star 0%
1 star 0%
Filter icon Filter
Top Reviews

Filter reviews by




AL Oct 25, 2022
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Reading this book is like learning from a private tutor. The book covers the Databricks Lakehouse architecture, data security and governance. The author uses simple, easy to understand diagrams and examples to illustrate how various components such as Delta Lake, Unity Catalog, SQL Warehouse, Photon etc fits within the Lakehouse architecture. Whether you are new or an experienced Databricks users, you will find something useful and refreshing. The lab exercises on Databricks SQL is fun to follow as it uses real world data sets and the benchmarking using TPC-DS dataset is a bonus!
Amazon Verified review Amazon
amazonVerifiedBuyer Dec 10, 2022
Full star icon Full star icon Full star icon Full star icon Full star icon 5
It is well written, with good explanations, and concrete examples, and it covers a large variety of topics. The author knows what he is talking about.The writing and examples are all very clear, and there are plenty of figures and code snippets to help you follow along, as well as some diagrams to explain certain concepts. What is particularly good about this book, it's that it is written from experience on the fields. It's not academic book describing how things should work. It is actually coming from experience with real projects.I had the opportunity to review the book Business Intelligence with Databricks SQL by Vihag Gupta, a master practitioner of the Databricks platform.This book is great for both newcomers and experienced users of the Databricks platform. It starts with a nice overview that can get anyone up to speed in no time. However, as you progress, Vihag will start to dig deeper into traditional SQL and Databricks SQL (including Photon).If you have been curious about Photon, this book will allow you to better understand the internals and know how to write efficient, optimal queries.
Amazon Verified review Amazon
Kieran O'Driscoll Nov 13, 2022
Full star icon Full star icon Full star icon Full star icon Full star icon 5
This book walks through each component of the Databricks Lakehouse platform and covers the basics along with more technical aspects. The section on the Photon engine was extremely helpful in understanding how Databricks SQL is so powerful.A great read for anyone getting started on the Lakehouse journey!
Amazon Verified review Amazon
vfortier Oct 27, 2022
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Great book about Databricks SQL, how to set it up, how to use it and how to make the best of it. Highly recommended
Amazon Verified review Amazon
Hales Sep 20, 2022
Full star icon Full star icon Full star icon Full star icon Full star icon 5
This book provides both high-level context and detailed examples and explanations, which are useful for novice to experienced BI practitioners and data engineers supporting BI workloads. As the book does not cover set-up, it will be most beneficial for those with access to an existing environment and some experience with SQL. The book is written in simple, easy-to-understand explanations and loaded with screenshots, code snippets, and diagrams to support the concepts covered.The book's first section is helpful if you are new to cloud architecture and jump into the product with a tour. The data and security chapters cover storing and accessing data and the latest Unity catalog components. While the book doesn’t go deep on user provisioning, it has enough detail to understand privileges to secure your tables, views, and dashboards. The SQL warehouse chapter dives into the architecture in the cloud and includes case studies around how to scale your data and manage performance. The BI section has code and screenshots using built-in datasets that you can follow along to build a dashboard or connect to an external tool. The second section goes deep into the nuts and bolts of Databricks SQL, optimizations and performance features, and the underlying engines. It ends with an example implementation of a cloud data warehouse using the lakehouse architecture and is geared towards people familiar with data modeling and warehouse design.The third section has SQL commands with many code examples, including CDC commands, time travel, and dealing with nested data. The last section has exercises around a TPC-DS dataset, using IDEs, more case studies, and FAQs. Note that you will need the jar file from GitHub. The last two sections are dense with information but are still easy to follow.One thing worth mentioning is that the features outlined in this book are not available in the free Databricks Community edition, so you will need a standard or enterprise account to follow along with the examples and create the dashboard, alerts, etc.
Amazon Verified review Amazon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

How do I buy and download an eBook? Chevron down icon Chevron up icon

Where there is an eBook version of a title available, you can buy it from the book details for that title. Add either the standalone eBook or the eBook and print book bundle to your shopping cart. Your eBook will show in your cart as a product on its own. After completing checkout and payment in the normal way, you will receive your receipt on the screen containing a link to a personalised PDF download file. This link will remain active for 30 days. You can download backup copies of the file by logging in to your account at any time.

If you already have Adobe reader installed, then clicking on the link will download and open the PDF file directly. If you don't, then save the PDF file on your machine and download the Reader to view it.

Please Note: Packt eBooks are non-returnable and non-refundable.

Packt eBook and Licensing When you buy an eBook from Packt Publishing, completing your purchase means you accept the terms of our licence agreement. Please read the full text of the agreement. In it we have tried to balance the need for the ebook to be usable for you the reader with our needs to protect the rights of us as Publishers and of our authors. In summary, the agreement says:

  • You may make copies of your eBook for your own use onto any machine
  • You may not pass copies of the eBook on to anyone else
How can I make a purchase on your website? Chevron down icon Chevron up icon

If you want to purchase a video course, eBook or Bundle (Print+eBook) please follow below steps:

  1. Register on our website using your email address and the password.
  2. Search for the title by name or ISBN using the search option.
  3. Select the title you want to purchase.
  4. Choose the format you wish to purchase the title in; if you order the Print Book, you get a free eBook copy of the same title. 
  5. Proceed with the checkout process (payment to be made using Credit Card, Debit Cart, or PayPal)
Where can I access support around an eBook? Chevron down icon Chevron up icon
  • If you experience a problem with using or installing Adobe Reader, the contact Adobe directly.
  • To view the errata for the book, see www.packtpub.com/support and view the pages for the title you have.
  • To view your account details or to download a new copy of the book go to www.packtpub.com/account
  • To contact us directly if a problem is not resolved, use www.packtpub.com/contact-us
What eBook formats do Packt support? Chevron down icon Chevron up icon

Our eBooks are currently available in a variety of formats such as PDF and ePubs. In the future, this may well change with trends and development in technology, but please note that our PDFs are not Adobe eBook Reader format, which has greater restrictions on security.

You will need to use Adobe Reader v9 or later in order to read Packt's PDF eBooks.

What are the benefits of eBooks? Chevron down icon Chevron up icon
  • You can get the information you need immediately
  • You can easily take them with you on a laptop
  • You can download them an unlimited number of times
  • You can print them out
  • They are copy-paste enabled
  • They are searchable
  • There is no password protection
  • They are lower price than print
  • They save resources and space
What is an eBook? Chevron down icon Chevron up icon

Packt eBooks are a complete electronic version of the print edition, available in PDF and ePub formats. Every piece of content down to the page numbering is the same. Because we save the costs of printing and shipping the book to you, we are able to offer eBooks at a lower cost than print editions.

When you have purchased an eBook, simply login to your account and click on the link in Your Download Area. We recommend you saving the file to your hard drive before opening it.

For optimal viewing of our eBooks, we recommend you download and install the free Adobe Reader version 9.