Google BigQuery: The Definitive Guide

Google BigQuery: The Definitive Guide
Author: Valliappa Lakshmanan
Publisher: O'Reilly Media
Total Pages: 522
Release: 2019-10-23
Genre: Computers
ISBN: 1492044431

Work with petabyte-scale datasets while building a collaborative, agile workplace in the process. This practical book is the canonical reference to Google BigQuery, the query engine that lets you conduct interactive analysis of large datasets. BigQuery enables enterprises to efficiently store, query, ingest, and learn from their data in a convenient framework. With this book, you’ll examine how to analyze data at scale to derive insights from large datasets efficiently. Valliappa Lakshmanan, tech lead for Google Cloud Platform, and Jordan Tigani, engineering director for the BigQuery team, provide best practices for modern data warehousing within an autoscaled, serverless public cloud. Whether you want to explore parts of BigQuery you’re not familiar with or prefer to focus on specific tasks, this reference is indispensable.

Getting Started with Salesforce Einstein Analytics

Getting Started with Salesforce Einstein Analytics
Author: Johan Yu
Publisher: Apress
Total Pages: 193
Release: 2019-09-11
Genre: Computers
ISBN: 1484252004

Build interactive dashboards using Salesforce Einstein analytics. Explore all of your data quickly and easily by providing AI-powered advanced analytics, right in Salesforce. You will manage datasets, query data with Salesforce Analytics Query Language (SAQL), and customize dashboards. Because Einstein Analytics is new, the curve to learn this technology can be difficult. This book guides you step-by-step in simple, easy-to-understand terms to get data from the Salesforce platform to the Einstein Analytics platform and also shows you how to import external data (e.g., CSV files). Core chapters focus on understanding data sources, dataflow, dataset, and lens leading up to building dashboards from scratch. Advanced features such as data transformation using computeExpression and computeRelative as well as dataflow with a multi-value lookup are explored. What You Will Learn Use data from Salesforce and external sources Create a dataflow to build a flexible datasetBuild dashboards using Einstein Analytics Explore and analyze data using Einstein Analytics Utilize SAQL and binding to create advance dashboards Who This Book Is For IT users getting started with Einstein Analytics, Salesforce consultants starting new Einstein Analytics projects, and power users familiar with Salesforce reporting and dashboards who want to get up to speed on new analytics features

Qualitative Text Analysis

Qualitative Text Analysis
Author: Udo Kuckartz
Publisher: SAGE
Total Pages: 193
Release: 2014-01-23
Genre: Reference
ISBN: 1446297764

How can you analyse narratives, interviews, field notes, or focus group data? Qualitative text analysis is ideal for these types of data and this textbook provides a hands-on introduction to the method and its theoretical underpinnings. It offers step-by-step instructions for implementing the three principal types of qualitative text analysis: thematic, evaluative, and type-building. Special attention is paid to how to present your results and use qualitative data analysis software packages, which are highly recommended for use in combination with qualitative text analysis since they allow for fast, reliable, and more accurate analysis. The book shows in detail how to use software, from transcribing the verbal data to presenting and visualizing the results. The book is intended for Master’s and Doctoral students across the social sciences and for all researchers concerned with the systematic analysis of texts of any kind.

A Practitioner's Guide to Business Analytics (PB)

A Practitioner's Guide to Business Analytics (PB)
Author: Randy Bartlett
Publisher: McGraw Hill Professional
Total Pages: 289
Release: 2013-01-25
Genre: Business & Economics
ISBN: 0071807608

Gain the competitive edge with the smart use of business analytics In today’s volatile business environment, the strategic use of business analytics is more important than ever. A Practitioners Guide to Business Analytics helps you get the organizational commitment you need to get business analytics up and running in your company. It provides solutions for meeting the strategic challenges of applying analytics, such as: Integrating analytics into decision making, corporate culture, and business strategy Leading and organizing analytics within the corporation Applying statistical qualifications, statistical diagnostics, and statistical review Providing effective building blocks to support analytics—statistical software, data collection, and data management Randy Bartlett, Ph.D., is Chief Statistical Officer of the consulting company Blue Sigma Analytics. He currently works with Infosys, where he has helped build their new Business Analytics practice.

The Definitive Guide to DAX

The Definitive Guide to DAX
Author: Alberto Ferrari
Publisher: Microsoft Press
Total Pages: 1515
Release: 2015-10-14
Genre: Computers
ISBN: 0735698376

This comprehensive and authoritative guide will teach you the DAX language for business intelligence, data modeling, and analytics. Leading Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization. You’ll learn exactly what happens under the hood when you run a DAX expression, how DAX behaves differently from other languages, and how to use this knowledge to write fast, robust code. If you want to leverage all of DAX’s remarkable power and flexibility, this no-compromise “deep dive” is exactly what you need. Perform powerful data analysis with DAX for Microsoft SQL Server Analysis Services, Excel, and Power BI Master core DAX concepts, including calculated columns, measures, and error handling Understand evaluation contexts and the CALCULATE and CALCULATETABLE functions Perform time-based calculations: YTD, MTD, previous year, working days, and more Work with expanded tables, complex functions, and elaborate DAX expressions Perform calculations over hierarchies, including parent/child hierarchies Use DAX to express diverse and unusual relationships Measure DAX query performance with SQL Server Profiler and DAX Studio

Decision Management Systems

Decision Management Systems
Author: James Taylor
Publisher: Pearson Education
Total Pages: 387
Release: 2011-10-13
Genre: Business & Economics
ISBN: 0132884445

"A very rich book sprinkled with real-life examples as well as battle-tested advice.” —Pierre Haren, VP ILOG, IBM "James does a thorough job of explaining Decision Management Systems as enablers of a formidable business transformation.” —Deepak Advani, Vice President, Business Analytics Products and SPSS, IBM Build Systems That Work Actively to Help You Maximize Growth and Profits Most companies rely on operational systems that are largely passive. But what if you could make your systems active participants in optimizing your business? What if your systems could act intelligently on their own? Learn, not just report? Empower users to take action instead of simply escalating their problems? Evolve without massive IT investments? Decision Management Systems can do all that and more. In this book, the field’s leading expert demonstrates how to use them to drive unprecedented levels of business value. James Taylor shows how to integrate operational and analytic technologies to create systems that are more agile, more analytic, and more adaptive. Through actual case studies, you’ll learn how to combine technologies such as predictive analytics, optimization, and business rules—improving customer service, reducing fraud, managing risk, increasing agility, and driving growth. Both a practical how-to guide and a framework for planning, Decision Management Systems focuses on mainstream business challenges. Coverage includes Understanding how Decision Management Systems can transform your business Planning your systems “with the decision in mind” Identifying, modeling, and prioritizing the decisions you need to optimize Designing and implementing robust decision services Monitoring your ongoing decision-making and learning how to improve it Proven enablers of effective Decision Management Systems: people, process, and technology Identifying and overcoming obstacles that can derail your Decision Management Systems initiative

Jumpstart Snowflake

Jumpstart Snowflake
Author: Dmitry Anoshin
Publisher: Apress
Total Pages: 270
Release: 2019-12-20
Genre: Computers
ISBN: 1484253280

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

Data Governance

Data Governance
Author: John Ladley
Publisher: Academic Press
Total Pages: 352
Release: 2019-11-08
Genre: Technology & Engineering
ISBN: 0128158328

Managing data continues to grow as a necessity for modern organizations. There are seemingly infinite opportunities for organic growth, reduction of costs, and creation of new products and services. It has become apparent that none of these opportunities can happen smoothly without data governance. The cost of exponential data growth and privacy / security concerns are becoming burdensome. Organizations will encounter unexpected consequences in new sources of risk. The solution to these challenges is also data governance; ensuring balance between risk and opportunity. Data Governance, Second Edition, is for any executive, manager or data professional who needs to understand or implement a data governance program. It is required to ensure consistent, accurate and reliable data across their organization. This book offers an overview of why data governance is needed, how to design, initiate, and execute a program and how to keep the program sustainable. This valuable resource provides comprehensive guidance to beginning professionals, managers or analysts looking to improve their processes, and advanced students in Data Management and related courses. With the provided framework and case studies all professionals in the data governance field will gain key insights into launching successful and money-saving data governance program. - Incorporates industry changes, lessons learned and new approaches - Explores various ways in which data analysts and managers can ensure consistent, accurate and reliable data across their organizations - Includes new case studies which detail real-world situations - Explores all of the capabilities an organization must adopt to become data driven - Provides guidance on various approaches to data governance, to determine whether an organization should be low profile, central controlled, agile, or traditional - Provides guidance on using technology and separating vendor hype from sincere delivery of necessary capabilities - Offers readers insights into how their organizations can improve the value of their data, through data quality, data strategy and data literacy - Provides up to 75% brand-new content compared to the first edition

Data Smart

Data Smart
Author: John W. Foreman
Publisher: John Wiley & Sons
Total Pages: 432
Release: 2013-10-31
Genre: Business & Economics
ISBN: 1118839862

Data Science gets thrown around in the press like it'smagic. Major retailers are predicting everything from when theircustomers are pregnant to when they want a new pair of ChuckTaylors. It's a brave new world where seemingly meaningless datacan be transformed into valuable insight to drive smart businessdecisions. But how does one exactly do data science? Do you have to hireone of these priests of the dark arts, the "data scientist," toextract this gold from your data? Nope. Data science is little more than using straight-forward steps toprocess raw data into actionable insight. And in DataSmart, author and data scientist John Foreman will show you howthat's done within the familiar environment of aspreadsheet. Why a spreadsheet? It's comfortable! You get to look at the dataevery step of the way, building confidence as you learn the tricksof the trade. Plus, spreadsheets are a vendor-neutral place tolearn data science without the hype. But don't let the Excel sheets fool you. This is a book forthose serious about learning the analytic techniques, the math andthe magic, behind big data. Each chapter will cover a different technique in aspreadsheet so you can follow along: Mathematical optimization, including non-linear programming andgenetic algorithms Clustering via k-means, spherical k-means, and graphmodularity Data mining in graphs, such as outlier detection Supervised AI through logistic regression, ensemble models, andbag-of-words models Forecasting, seasonal adjustments, and prediction intervalsthrough monte carlo simulation Moving from spreadsheets into the R programming language You get your hands dirty as you work alongside John through eachtechnique. But never fear, the topics are readily applicable andthe author laces humor throughout. You'll even learnwhat a dead squirrel has to do with optimization modeling, whichyou no doubt are dying to know.

Python for Data Analysis

Python for Data Analysis
Author: Wes McKinney
Publisher: "O'Reilly Media, Inc."
Total Pages: 553
Release: 2017-09-25
Genre: Computers
ISBN: 1491957611

Get complete instructions for manipulating, processing, cleaning, and crunching datasets in Python. Updated for Python 3.6, the second edition of this hands-on guide is packed with practical case studies that show you how to solve a broad set of data analysis problems effectively. You’ll learn the latest versions of pandas, NumPy, IPython, and Jupyter in the process. Written by Wes McKinney, the creator of the Python pandas project, this book is a practical, modern introduction to data science tools in Python. It’s ideal for analysts new to Python and for Python programmers new to data science and scientific computing. Data files and related material are available on GitHub. Use the IPython shell and Jupyter notebook for exploratory computing Learn basic and advanced features in NumPy (Numerical Python) Get started with data analysis tools in the pandas library Use flexible tools to load, clean, transform, merge, and reshape data Create informative visualizations with matplotlib Apply the pandas groupby facility to slice, dice, and summarize datasets Analyze and manipulate regular and irregular time series data Learn how to solve real-world data analysis problems with thorough, detailed examples