Business Intelligence with Looker Cookbook


Book Description

Use Looker for visualizing data, data analysis, and reporting, and learn how to connect to your data, build dashboards and reports, and share insights with your team Key Features Explore data visualization, analysis, and reporting with Looker to gain insights from your data Connect to data sources, build dashboards, and create reports to track and share key metrics Share insights with your team to make better business decisions Purchase of the print or Kindle book includes a free PDF eBook Book DescriptionLooker is a data analytics and business intelligence platform that allows organizations to explore, analyze, and visualize their data. It provides tools for data modeling, exploration, and visualization, enabling you to gain insights from your data to make informed business decisions. You’ll start with the basics, from setting up your Looker environments to configuring views and models using LookML. As you progress, you’ll delve into more advanced topics, such as navigating data in Explore, tailoring dashboards to your needs, and adding dynamic elements for interactivity. Along the way, you'll gain invaluable troubleshooting skills to tackle common issues and optimize your Looker usage, ensuring a smooth and seamless experience. Furthermore, the book extends your understanding beyond the basics, equipping you with the knowledge you need to develop Looker applications and seamlessly integrate them with other tools and applications. You'll also explore advanced techniques for harnessing Looker's full potential, empowering you to establish data-driven decision-making and innovation within your organization. By the end of this BI book, you'll have gained a solid understanding of how to use Looker to find important information, make tasks easier, and derive important insights.What you will learn Understand Looker's key components, including LookML, data models, and dashboards. Explore Looker's functionality, including custom fields, calculations, and visualizations. Work with Looker dashboards using dynamic elements like links and actions. Use different types of filters for dimensions to create dashboards Develop Looker applications using essential tools and frameworks Explore additional applications for the Looker organization Integrate Looker with other tools using APIs, connectors, and data pipelines Who this book is for If you’re a business analyst, data analyst, or BI developer who wants to get well-versed with the features of Looker, this book is for you. Basic knowledge of business intelligence is required to get started.




Effective Business Intelligence with QuickSight


Book Description

From data to actionable business insights using Amazon QuickSight! About This Book A practical hands-on guide to improving your business with the power of BI and Quicksight Immerse yourself with an end-to-end journey for effective analytics using QuickSight and related services Packed with real-world examples with Solution Architectures needed for a cloud-powered Business Intelligence service Who This Book Is For This book is for Business Intelligence architects, BI developers, Big Data architects, and IT executives who are looking to modernize their business intelligence architecture and deliver a fast, easy-to-use, cloud powered business intelligence service. What You Will Learn Steps to test drive QuickSight and see how it fits in AWS big data eco system Load data from various sources such as S3, RDS, Redshift, Athena, and SalesForce and visualize using QuickSight Understand how to prepare data using QuickSight without the need of an IT developer Build interactive charts, reports, dashboards, and storyboards using QuickSight Access QuickSight using the mobile application Architect and design for AWS Data Lake Solution, leveraging AWS hosted services Build a big data project with step-by-step instructions for data collection, cataloguing, and analysis Secure your data used for QuickSight from S3, RedShift, and RDS instances Manage users, access controls, and SPICE capacity In Detail Amazon QuickSight is the next-generation Business Intelligence (BI) cloud service that can help you build interactive visualizations on top of various data sources hosted on Amazon Cloud Infrastructure. QuickSight delivers responsive insights into big data and enables organizations to quickly democratize data visualizations and scale to hundreds of users at a fraction of the cost when compared to traditional BI tools. This book begins with an introduction to Amazon QuickSight, feature differentiators from traditional BI tools, and how it fits in the overall AWS big data ecosystem. With practical examples, you will find tips and techniques to load your data to AWS, prepare it, and finally visualize it using QuickSight. You will learn how to build interactive charts, reports, dashboards, and stories using QuickSight and share with others using just your browser and mobile app. The book also provides a blueprint to build a real-life big data project on top of AWS Data Lake Solution and demonstrates how to build a modern data lake on the cloud with governance, data catalog, and analysis. It reviews the current product shortcomings, features in the roadmap, and how to provide feedback to AWS. Grow your profits, improve your products, and beat your competitors. Style and approach This book takes a fast-paced, example-driven approach to demonstrate the power of QuickSight to improve your business' efficiency. Every chapter is accompanied with a use case that shows the practical implementation of the step being explained.




Machine Learning with BigQuery ML


Book Description

Manage different business scenarios with the right machine learning technique using Google's highly scalable BigQuery ML Key FeaturesGain a clear understanding of AI and machine learning services on GCP, learn when to use these, and find out how to integrate them with BigQuery MLLeverage SQL syntax to train, evaluate, test, and use ML modelsDiscover how BigQuery works and understand the capabilities of BigQuery ML using examplesBook Description BigQuery ML enables you to easily build machine learning (ML) models with SQL without much coding. This book will help you to accelerate the development and deployment of ML models with BigQuery ML. The book starts with a quick overview of Google Cloud and BigQuery architecture. You'll then learn how to configure a Google Cloud project, understand the architectural components and capabilities of BigQuery, and find out how to build ML models with BigQuery ML. The book teaches you how to use ML using SQL on BigQuery. You'll analyze the key phases of a ML model's lifecycle and get to grips with the SQL statements used to train, evaluate, test, and use a model. As you advance, you'll build a series of use cases by applying different ML techniques such as linear regression, binary and multiclass logistic regression, k-means, ARIMA time series, deep neural networks, and XGBoost using practical use cases. Moving on, you'll cover matrix factorization and deep neural networks using BigQuery ML's capabilities. Finally, you'll explore the integration of BigQuery ML with other Google Cloud Platform components such as AI Platform Notebooks and TensorFlow along with discovering best practices and tips and tricks for hyperparameter tuning and performance enhancement. By the end of this BigQuery book, you'll be able to build and evaluate your own ML models with BigQuery ML. What you will learnDiscover how to prepare datasets to build an effective ML modelForecast business KPIs by leveraging various ML models and BigQuery MLBuild and train a recommendation engine to suggest the best products for your customers using BigQuery MLDevelop, train, and share a BigQuery ML model from previous parts with AI Platform NotebooksFind out how to invoke a trained TensorFlow model directly from BigQueryGet to grips with BigQuery ML best practices to maximize your ML performanceWho this book is for This book is for data scientists, data analysts, data engineers, and anyone looking to get started with Google's BigQuery ML. You'll also find this book useful if you want to accelerate the development of ML models or if you are a business user who wants to apply ML in an easy way using SQL. Basic knowledge of BigQuery and SQL is required.




Jumpstart Snowflake


Book Description

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




The Definitive Guide to Conversational AI with Dialogflow and Google Cloud


Book Description

Build enterprise chatbots for web, social media, voice assistants, IoT, and telephony contact centers with Google's Dialogflow conversational AI technology. This book will explain how to get started with conversational AI using Google and how enterprise users can use Dialogflow as part of Google Cloud. It will cover the core concepts such as Dialogflow essentials, deploying chatbots on web and social media channels, and building voice agents including advanced tips and tricks such as intents, entities, and working with context. The Definitive Guide to Conversational AI with Dialogflow and Google Cloud also explains how to build multilingual chatbots, orchestrate sub chatbots into a bigger conversational platform, use virtual agent analytics with popular tools, such as BigQuery or Chatbase, and build voice bots. It concludes with coverage of more advanced use cases, such as building fulfillment functionality, building your own integrations, securing your chatbots, and building your own voice platform with the Dialogflow SDK and other Google Cloud machine learning APIs. After reading this book, you will understand how to build cross-channel enterprise bots with popular Google tools such as Dialogflow, Google Cloud AI, Cloud Run, Cloud Functions, and Chatbase. ​​What You Will Learn Discover Dialogflow, Dialogflow Essentials, Dialogflow CX, and how machine learning is used Create Dialogflow projects for individuals and enterprise usage Work with Dialogflow essential concepts such as intents, entities, custom entities, system entities, composites, and how to track context Build bots quickly using prebuilt agents, small talk modules, and FAQ knowledge bases Use Dialogflow for an out-of-the-box agent review Deploy text conversational UIs for web and social media channels Build voice agents for voice assistants, phone gateways, and contact centers Create multilingual chatbots Orchestrate many sub-chatbots to build a bigger conversational platform Use chatbot analytics and test the quality of your Dialogflow agent See the new Dialogflow CX concepts, how Dialogflow CX fits in, and what’s different in Dialogflow CX Who This Book Is For Everyone interested in building chatbots for web, social media, voice assistants, or contact centers using Google’s conversational AI/cloud technology.




The Defining Moment


Book Description

In this dramatic and authoritative account, the author shows how Franklin Delano Roosevelt used his famous "fear itself" speech and the first 100 days in office to lift the country from despair and paralysis and transform the American presidency.




Learning Tableau


Book Description

If you want to understand your data using data visualization and don't know where to start, then this is the book for you. Whether you are a beginner or have years of experience, this book will help you to quickly acquire the skills and techniques used to discover, analyze, and communicate data visually. Some familiarity with databases and data structures is helpful, but not required.




Introduction to Data Science


Book Description

Introduction to Data Science: Data Analysis and Prediction Algorithms with R introduces concepts and skills that can help you tackle real-world data analysis challenges. It covers concepts from probability, statistical inference, linear regression, and machine learning. It also helps you develop skills such as R programming, data wrangling, data visualization, predictive algorithm building, file organization with UNIX/Linux shell, version control with Git and GitHub, and reproducible document preparation. This book is a textbook for a first course in data science. No previous knowledge of R is necessary, although some experience with programming may be helpful. The book is divided into six parts: R, data visualization, statistics with R, data wrangling, machine learning, and productivity tools. Each part has several chapters meant to be presented as one lecture. The author uses motivating case studies that realistically mimic a data scientist’s experience. He starts by asking specific questions and answers these through data analysis so concepts are learned as a means to answering the questions. Examples of the case studies included are: US murder rates by state, self-reported student heights, trends in world health and economics, the impact of vaccines on infectious disease rates, the financial crisis of 2007-2008, election forecasting, building a baseball team, image processing of hand-written digits, and movie recommendation systems. The statistical concepts used to answer the case study questions are only briefly introduced, so complementing with a probability and statistics textbook is highly recommended for in-depth understanding of these concepts. If you read and understand the chapters and complete the exercises, you will be prepared to learn the more advanced concepts and skills needed to become an expert.




Beginning Apache Spark Using Azure Databricks


Book Description

Analyze vast amounts of data in record time using Apache Spark with Databricks in the Cloud. Learn the fundamentals, and more, of running analytics on large clusters in Azure and AWS, using Apache Spark with Databricks on top. Discover how to squeeze the most value out of your data at a mere fraction of what classical analytics solutions cost, while at the same time getting the results you need, incrementally faster. This book explains how the confluence of these pivotal technologies gives you enormous power, and cheaply, when it comes to huge datasets. You will begin by learning how cloud infrastructure makes it possible to scale your code to large amounts of processing units, without having to pay for the machinery in advance. From there you will learn how Apache Spark, an open source framework, can enable all those CPUs for data analytics use. Finally, you will see how services such as Databricks provide the power of Apache Spark, without you having to know anything about configuring hardware or software. By removing the need for expensive experts and hardware, your resources can instead be allocated to actually finding business value in the data. This book guides you through some advanced topics such as analytics in the cloud, data lakes, data ingestion, architecture, machine learning, and tools, including Apache Spark, Apache Hadoop, Apache Hive, Python, and SQL. Valuable exercises help reinforce what you have learned. What You Will Learn Discover the value of big data analytics that leverage the power of the cloudGet started with Databricks using SQL and Python in either Microsoft Azure or AWSUnderstand the underlying technology, and how the cloud and Apache Spark fit into the bigger picture See how these tools are used in the real world Run basic analytics, including machine learning, on billions of rows at a fraction of a cost or free Who This Book Is For Data engineers, data scientists, and cloud architects who want or need to run advanced analytics in the cloud. It is assumed that the reader has data experience, but perhaps minimal exposure to Apache Spark and Azure Databricks. The book is also recommended for people who want to get started in the analytics field, as it provides a strong foundation.




What Could Be Saved


Book Description

When a mysterious man claims to be her long-missing brother, a woman must confront her family’s closely guarded secrets in this “delicious hybrid of mystery, drama, and elegance” (Jodi Picoult, #1 New York Times bestselling author). Washington, DC, 2019: Laura Preston is a reclusive artist at odds with her older sister Beatrice as their elegant, formidable mother slowly slides into dementia. When a stranger contacts Laura claiming to be her brother who disappeared forty years earlier when the family lived in Bangkok, Laura ignores Bea’s warnings of a scam and flies to Thailand to see if it can be true. But meeting him in person leads to more questions than answers. Bangkok, 1972: Genevieve and Robert Preston live in a beautiful house behind a high wall, raising their three children with the help of a cadre of servants. In these exotic surroundings, Genevieve strives to create a semblance of the life they would have had at home in the US—ballet and riding classes for the children, impeccable dinner parties, a meticulously kept home. But in truth, Robert works for American intelligence, Genevieve finds herself drawn into a passionate affair with her husband’s boss, and their serene household is vulnerable to unseen dangers in a rapidly changing world and a country they don’t really understand. Alternating between past and present as all of the secrets are revealed, What Could Be Saved is an unforgettable novel about a family broken by loss and betrayal, and “a richly imagined page-turner that delivers twists alongside thought-provoking commentary” (Kirkus Reviews).