Relational Analytics

Download Relational Analytics PDF Online Free

Author :
Publisher : Taylor & Francis
ISBN 13 : 1000391574
Total Pages : 205 pages
Book Rating : 4.0/5 (3 download)

DOWNLOAD NOW!


Book Synopsis Relational Analytics by : Jody Hoffer Gittell

Download or read book Relational Analytics written by Jody Hoffer Gittell and published by Taylor & Francis. This book was released on 2021-06-13 with total page 205 pages. Available in PDF, EPUB and Kindle. Book excerpt: This guidebook goes beyond people analytics to provide a research-based, practice-tested methodology for doing relational analytics, based on the science of relational coordination. We are witnessing a revolution in people analytics, where data are used to identify and leverage human talent to drive performance outcomes. Today’s workplace is interdependent, however, and individuals drive performance through networks that span department, organization and sector boundaries. This book shares the relational coordination framework, with a validated scalable analytic tool that has been used successfully across dozens of countries and industries to understand, measure and influence networks of relationships in and across organizations, and which can be applied at any level in the private and public sectors worldwide. Graduate students and practitioners in human resource management, health policy and management, organizational behavior, engineering and network analysis will appreciate the methodology and hands-on guidance this book provides, with its focus on identifying, analyzing and building networks of productive interdependence. Online resources include data appendices and statistical commands that can be used to conduct all these analyses in readers’ own organizations.

Relational Analytics

Download Relational Analytics PDF Online Free

Author :
Publisher : Routledge
ISBN 13 : 1000391639
Total Pages : 196 pages
Book Rating : 4.0/5 (3 download)

DOWNLOAD NOW!


Book Synopsis Relational Analytics by : Jody Hoffer Gittell

Download or read book Relational Analytics written by Jody Hoffer Gittell and published by Routledge. This book was released on 2021-06-13 with total page 196 pages. Available in PDF, EPUB and Kindle. Book excerpt: This guidebook goes beyond people analytics to provide a research-based, practice-tested methodology for doing relational analytics, based on the science of relational coordination. We are witnessing a revolution in people analytics, where data are used to identify and leverage human talent to drive performance outcomes. Today’s workplace is interdependent, however, and individuals drive performance through networks that span department, organization and sector boundaries. This book shares the relational coordination framework, with a validated scalable analytic tool that has been used successfully across dozens of countries and industries to understand, measure and influence networks of relationships in and across organizations, and which can be applied at any level in the private and public sectors worldwide. Graduate students and practitioners in human resource management, health policy and management, organizational behavior, engineering and network analysis will appreciate the methodology and hands-on guidance this book provides, with its focus on identifying, analyzing and building networks of productive interdependence. Online resources include data appendices and statistical commands that can be used to conduct all these analyses in readers’ own organizations.

Predictive Analytics in Human Resource Management

Download Predictive Analytics in Human Resource Management PDF Online Free

Author :
Publisher : Taylor & Francis
ISBN 13 : 1000208079
Total Pages : 237 pages
Book Rating : 4.0/5 (2 download)

DOWNLOAD NOW!


Book Synopsis Predictive Analytics in Human Resource Management by : Shivinder Nijjer

Download or read book Predictive Analytics in Human Resource Management written by Shivinder Nijjer and published by Taylor & Francis. This book was released on 2020-12-03 with total page 237 pages. Available in PDF, EPUB and Kindle. Book excerpt: This volume is a step-by-step guide to implementing predictive data analytics in human resource management (HRM). It demonstrates how to apply and predict various HR outcomes which have an organisational impact, to aid in strategising and better decision-making. The book: Presents key concepts and expands on the need and role of HR analytics in business management. Utilises popular analytical tools like artificial neural networks (ANNs) and K-nearest neighbour (KNN) to provide practical demonstrations through R scripts for predicting turnover and applicant screening. Discusses real-world corporate examples and employee data collected first-hand by the authors. Includes individual chapter exercises and case studies for students and teachers. Comprehensive and accessible, this guide will be useful for students, teachers, and researchers of data analytics, Big Data, human resource management, statistics, and economics. It will also be of interest to readers interested in learning more about statistics or programming.

HBR's 10 Must Reads for HR Leaders Collection (5 Books)

Download HBR's 10 Must Reads for HR Leaders Collection (5 Books) PDF Online Free

Author :
Publisher : Harvard Business Press
ISBN 13 : 163369934X
Total Pages : 773 pages
Book Rating : 4.6/5 (336 download)

DOWNLOAD NOW!


Book Synopsis HBR's 10 Must Reads for HR Leaders Collection (5 Books) by : Harvard Business Review

Download or read book HBR's 10 Must Reads for HR Leaders Collection (5 Books) written by Harvard Business Review and published by Harvard Business Press. This book was released on 2019-12-10 with total page 773 pages. Available in PDF, EPUB and Kindle. Book excerpt: Build the workforce of the future. In our volatile and complex era--which boasts a competitive market for top talent--HR's traditional model will fail. Your company needs to adopt the latest skills to successfully manage performance and evaluate potential. HBR's 10 Must Reads for HR Leaders Collection features innovative ideas on how to foster a vibrant, high-performing company culture, spearhead constructive change, and reap the benefits of a diverse workforce. Included in this five-book set are HBR's 10 Must Reads on Reinventing HR, HBR's 10 Must Reads on Change Management, HBR's 10 Must Reads on Building a Great Culture, HBR's 10 Must Reads on Diversity, and HBR's 10 Must Reads on Managing People. The collection includes fifty articles selected by HBR's editors from renowned thought leaders including Marcus Buckingham, W. Chan Kim, Renee Mauborgne, and Sylvia Ann Hewlett, plus the indispensable article "People Before Strategy" by Ram Charan, Dominic Barton, and Dennis Carey. With HBR's 10 Must Reads for HR Leaders Collection, break free from the traditional HR mindset and learn how to build the workforce of the future. HBR's 10 Must Reads paperback series is the definitive collection of books for new and experienced leaders alike. Leaders looking for the inspiration that big ideas provide, both to accelerate their own growth and that of their companies, should look no further. HBR's 10 Must Reads series focuses on the core topics that every ambitious manager needs to know: leadership, strategy, change, managing people, and managing yourself. Harvard Business Review has sorted through hundreds of articles and selected only the most essential reading on each topic. Each title includes timeless advice that will be relevant regardless of an ever‐changing business environment.

Beginning Relational Data Modeling

Download Beginning Relational Data Modeling PDF Online Free

Author :
Publisher :
ISBN 13 :
Total Pages : 646 pages
Book Rating : 4.3/5 (91 download)

DOWNLOAD NOW!


Book Synopsis Beginning Relational Data Modeling by : Sharon Allen

Download or read book Beginning Relational Data Modeling written by Sharon Allen and published by . This book was released on 2005-03-24 with total page 646 pages. Available in PDF, EPUB and Kindle. Book excerpt: *Immediately accessible to anyone who must design a relational data model—regardless of prior experience *Concise, straightforward explanations to a usually complex/ jargon-rich discipline *Examples are based on extensive author experience modeling for real business systems

Linked Open Data -- Creating Knowledge Out of Interlinked Data

Download Linked Open Data -- Creating Knowledge Out of Interlinked Data PDF Online Free

Author :
Publisher : Springer
ISBN 13 : 3319098462
Total Pages : 218 pages
Book Rating : 4.3/5 (19 download)

DOWNLOAD NOW!


Book Synopsis Linked Open Data -- Creating Knowledge Out of Interlinked Data by : Sören Auer

Download or read book Linked Open Data -- Creating Knowledge Out of Interlinked Data written by Sören Auer and published by Springer. This book was released on 2014-07-31 with total page 218 pages. Available in PDF, EPUB and Kindle. Book excerpt: Linked Open Data (LOD) is a pragmatic approach for realizing the Semantic Web vision of making the Web a global, distributed, semantics-based information system. This book presents an overview on the results of the research project “LOD2 -- Creating Knowledge out of Interlinked Data”. LOD2 is a large-scale integrating project co-funded by the European Commission within the FP7 Information and Communication Technologies Work Program. Commencing in September 2010, this 4-year project comprised leading Linked Open Data research groups, companies, and service providers from across 11 European countries and South Korea. The aim of this project was to advance the state-of-the-art in research and development in four key areas relevant for Linked Data, namely 1. RDF data management; 2. the extraction, creation, and enrichment of structured RDF data; 3. the interlinking and fusion of Linked Data from different sources and 4. the authoring, exploration and visualization of Linked Data.

Human Capital Dilemma

Download Human Capital Dilemma PDF Online Free

Author :
Publisher : Notion Press
ISBN 13 : 1649517912
Total Pages : 150 pages
Book Rating : 4.6/5 (495 download)

DOWNLOAD NOW!


Book Synopsis Human Capital Dilemma by : Tuhin Biswas

Download or read book Human Capital Dilemma written by Tuhin Biswas and published by Notion Press. This book was released on 2020-08-18 with total page 150 pages. Available in PDF, EPUB and Kindle. Book excerpt: Often, we have seen the custodian of human capital the Human Resources function becomes a scapegoat for Management decisions. It is a pity that, while HR is liable for employees’ well-being, motivation and morale, they are considered to be a liability to organizations/employers sometimes. What makes them so? Is it a myth that HR does what CEOs wants them to do? or are they sandwiched between employer and employees to maintain a diplomatic figure? or do they not understand what the expectations of the organization or management are? A must-read book for all Managers/Leaders as everyone is a human resource manager when they deal with individuals/teams or even at home when you deal with your own people. Some interesting factual stories/case studies will make you realize how important the above questions are. Also, this book will make you aware of practical issues faced in the day-to-day life of HR professionals, the dilemmas faced by them with management and employees, how they can become an able business HR leader, and a few worthy solutions you can deal with. This will also help CEOs to understand how to deal with human capital better. I’m sure this book will inspire you to change your mind-set on Human resources.

R for Data Science

Download R for Data Science PDF Online Free

Author :
Publisher : "O'Reilly Media, Inc."
ISBN 13 : 1491910364
Total Pages : 521 pages
Book Rating : 4.4/5 (919 download)

DOWNLOAD NOW!


Book Synopsis R for Data Science by : Hadley Wickham

Download or read book R for Data Science written by Hadley Wickham and published by "O'Reilly Media, Inc.". This book was released on 2016-12-12 with total page 521 pages. Available in PDF, EPUB and Kindle. Book excerpt: Learn how to use R to turn raw data into insight, knowledge, and understanding. This book introduces you to R, RStudio, and the tidyverse, a collection of R packages designed to work together to make data science fast, fluent, and fun. Suitable for readers with no previous programming experience, R for Data Science is designed to get you doing data science as quickly as possible. Authors Hadley Wickham and Garrett Grolemund guide you through the steps of importing, wrangling, exploring, and modeling your data and communicating the results. You'll get a complete, big-picture understanding of the data science cycle, along with basic tools you need to manage the details. Each section of the book is paired with exercises to help you practice what you've learned along the way. You'll learn how to: Wrangle—transform your datasets into a form convenient for analysis Program—learn powerful R tools for solving data problems with greater clarity and ease Explore—examine your data, generate hypotheses, and quickly test them Model—provide a low-dimensional summary that captures true "signals" in your dataset Communicate—learn R Markdown for integrating prose, code, and results

HBR's 10 Must Reads on Reinventing HR (with bonus article "People Before Strategy" by Ram Charan, Dominic Barton, and Dennis Carey)

Download HBR's 10 Must Reads on Reinventing HR (with bonus article

Author :
Publisher : Harvard Business Press
ISBN 13 : 1633697851
Total Pages : 201 pages
Book Rating : 4.6/5 (336 download)

DOWNLOAD NOW!


Book Synopsis HBR's 10 Must Reads on Reinventing HR (with bonus article "People Before Strategy" by Ram Charan, Dominic Barton, and Dennis Carey) by : Harvard Business Review

Download or read book HBR's 10 Must Reads on Reinventing HR (with bonus article "People Before Strategy" by Ram Charan, Dominic Barton, and Dennis Carey) written by Harvard Business Review and published by Harvard Business Press. This book was released on 2019-05-21 with total page 201 pages. Available in PDF, EPUB and Kindle. Book excerpt: How HR can lead. If you read nothing else on reinventing human resources, read these 10 articles. We've combed through hundreds of Harvard Business Review articles and selected the most important ones on how HR leaders can partner with the C-suite, drive change throughout the organization, and develop the workforce of the future. This book will inspire you to: Overhaul performance management practices to jump-start motivation and engagement Use agile processes to transform how you hire, develop, and manage people Establish diversity programs that increase innovation and competitiveness as well as inclusion Use people analytics to bring unprecedented insight to hiring and talent management Prepare your company for the double waves of artificial intelligence and an older workforce Close the gap between HR and strategy This collection of articles includes: "People Before Strategy: A New Role for the CHRO," by Ram Charan, Dominic Barton, and Dennis Carey; "How Netflix Reinvented HR," by Patty McCord; "HR Goes Agile," by Peter Cappelli and Anna Tavis; "Reinventing Performance Management," by Marcus Buckingham and Ashley Goodall; "Better People Analytics," by Paul Leonardi and Noshir Contractor; "21st-Century Talent Spotting," by Claudio Fernandez-Araoz; "Tours of Duty: The New Employer-Employee Contract," by Reid Hoffman, Ben Casnocha, and Chris Yeh; "Creating the Best Workplace on Earth," by Rob Goffee and Gareth Jones; "Why Diversity Programs Fail," by Frank Dobbins and Alexandra Kalev; "When No One Retires," by Paul Irving; and "Collaborative Intelligence: Humans and AI Are Joining Forces," by H. James Wilson and Paul R. Daugherty.

IBM Cognos Dynamic Query

Download IBM Cognos Dynamic Query PDF Online Free

Author :
Publisher : IBM Redbooks
ISBN 13 : 0738438723
Total Pages : 124 pages
Book Rating : 4.7/5 (384 download)

DOWNLOAD NOW!


Book Synopsis IBM Cognos Dynamic Query by : Nigel Campbell

Download or read book IBM Cognos Dynamic Query written by Nigel Campbell and published by IBM Redbooks. This book was released on 2013-09-12 with total page 124 pages. Available in PDF, EPUB and Kindle. Book excerpt: This IBM® Redbooks® publication explains how IBM Cognos® Business Intelligence (BI) administrators, authors, modelers, and power users can use the dynamic query layer effectively. It provides guidance for determining which technology within the dynamic query layer can best satisfy your business requirements. Administrators can learn how to tune the query service effectively and preferred practices for managing their business intelligence content. This book includes information about metadata modeling of relational data sources with IBM Cognos Framework Manager. It includes considerations that can help you author high-performing applications that satisfy analytical requirements of users. This book provides guidance for troubleshooting issues related to the dynamic query layer of Cognos BI. Related documents: Solution Guide : Big Data Analytics with IBM Cognos BI Dynamic Query Blog post : IBM Cognos Dynamic Query Extensibility

Grassroots Law in Papua New Guinea

Download Grassroots Law in Papua New Guinea PDF Online Free

Author :
Publisher : ANU Press
ISBN 13 : 1760466123
Total Pages : 210 pages
Book Rating : 4.7/5 (64 download)

DOWNLOAD NOW!


Book Synopsis Grassroots Law in Papua New Guinea by : Melissa Demian

Download or read book Grassroots Law in Papua New Guinea written by Melissa Demian and published by ANU Press. This book was released on 2023-12-14 with total page 210 pages. Available in PDF, EPUB and Kindle. Book excerpt: The introduction of village courts in Papua New Guinea in 1975 was an ambitious experiment in providing semi-formal legal access to the country’s overwhelmingly rural population. Nearly 50 years later, the enthusiastic adoption of these courts has had a number of ramifications, some of them unanticipated. Arguably, the village courts have developed and are working exactly as they were supposed to do, adapted by local communities to modes and styles consistent with their own dispute management sensibilities. But with little in the way of state oversight or support, most village courts have become, of necessity, nearly autonomous. Village courts have also become the blueprint for other modes of dispute management. They overlap with other sources of authority, so the line between what does and does not constitute a ‘court’ is now indistinct in many parts of the country. Rather than casting this issue as a problem for legal development, the contributors to Grassroots Law in Papua New Guinea ask how, under conditions of state withdrawal, people seek to retain an understanding of law that holds out some promise of either keeping the attention of the state or reproducing the state’s authority.

SQL for Data Science

Download SQL for Data Science PDF Online Free

Author :
Publisher : Springer Nature
ISBN 13 : 3030575926
Total Pages : 290 pages
Book Rating : 4.0/5 (35 download)

DOWNLOAD NOW!


Book Synopsis SQL for Data Science by : Antonio Badia

Download or read book SQL for Data Science written by Antonio Badia and published by Springer Nature. This book was released on 2020-11-09 with total page 290 pages. Available in PDF, EPUB and Kindle. Book excerpt: This textbook explains SQL within the context of data science and introduces the different parts of SQL as they are needed for the tasks usually carried out during data analysis. Using the framework of the data life cycle, it focuses on the steps that are very often given the short shift in traditional textbooks, like data loading, cleaning and pre-processing. The book is organized as follows. Chapter 1 describes the data life cycle, i.e. the sequence of stages from data acquisition to archiving, that data goes through as it is prepared and then actually analyzed, together with the different activities that take place at each stage. Chapter 2 gets into databases proper, explaining how relational databases organize data. Non-traditional data, like XML and text, are also covered. Chapter 3 introduces SQL queries, but unlike traditional textbooks, queries and their parts are described around typical data analysis tasks like data exploration, cleaning and transformation. Chapter 4 introduces some basic techniques for data analysis and shows how SQL can be used for some simple analyses without too much complication. Chapter 5 introduces additional SQL constructs that are important in a variety of situations and thus completes the coverage of SQL queries. Lastly, chapter 6 briefly explains how to use SQL from within R and from within Python programs. It focuses on how these languages can interact with a database, and how what has been learned about SQL can be leveraged to make life easier when using R or Python. All chapters contain a lot of examples and exercises on the way, and readers are encouraged to install the two open-source database systems (MySQL and Postgres) that are used throughout the book in order to practice and work on the exercises, because simply reading the book is much less useful than actually using it. This book is for anyone interested in data science and/or databases. It just demands a bit of computer fluency, but no specific background on databases or data analysis. All concepts are introduced intuitively and with a minimum of specialized jargon. After going through this book, readers should be able to profitably learn more about data mining, machine learning, and database management from more advanced textbooks and courses.

Transforming Relationships for High Performance

Download Transforming Relationships for High Performance PDF Online Free

Author :
Publisher : Stanford University Press
ISBN 13 : 0804797048
Total Pages : 320 pages
Book Rating : 4.8/5 (47 download)

DOWNLOAD NOW!


Book Synopsis Transforming Relationships for High Performance by : Jody Hoffer Gittell

Download or read book Transforming Relationships for High Performance written by Jody Hoffer Gittell and published by Stanford University Press. This book was released on 2016-08-03 with total page 320 pages. Available in PDF, EPUB and Kindle. Book excerpt: A guide to using positive organizational change to do more with less, from the acclaimed author of The Southwest Airlines Way. Whether from customers, supply-chain partners, policymakers, or regulators, organizations in virtually every industry are facing calls to do more with less. They are feeling compelled to provide higher-quality outcomes, more rapidly, at a lower cost. This book offers a road-tested approach for delivering these outcomes through positive organizational change. Its message comes just in time—for too many companies have gone the way of low-road strategies, such as cutting pay and perks, and working harder not smarter. Drawing on her pathbreaking research, Jody Hoffer Gittell reveals that high performance is fundamentally relational—rooted in both human and social capital. Based on this insight, she provides a unique model that will help companies build meaningful relationships among colleagues, develop smarter work processes, and design organizational structures fit for today’s pressure test. By following four organizations on their change journeys, she illustrates how “relational coordination” unfolds in real-world settings. In addition, tools for change guide readers as they learn how to implement this new model in their own workplaces.

Data and Analytics in Accounting

Download Data and Analytics in Accounting PDF Online Free

Author :
Publisher : Wiley Global Education
ISBN 13 : 1119889146
Total Pages : 667 pages
Book Rating : 4.1/5 (198 download)

DOWNLOAD NOW!


Book Synopsis Data and Analytics in Accounting by : Ann C. Dzuranin

Download or read book Data and Analytics in Accounting written by Ann C. Dzuranin and published by Wiley Global Education. This book was released on 2024-06-27 with total page 667 pages. Available in PDF, EPUB and Kindle. Book excerpt: Data Analytics in Accounting: An Integrated Approach develops an integrated data analysis and critical thinking skill set needed to be successful in the rapidly changing accounting profession. Following a pattern-based approach to profiling, cleaning, and transforming data, the book helps explore data from a variety of perspectives for analytical purposes and key data relationships. The text guides students to develop the professional skills they need to plan, perform, and communicate data analyses effectively and efficiently in the real world. This international edition introduces a new feature “Data Analytics and Decision Making” at the end of the book, which offers students the opportunity to see how they can use data analytics to help solve realistic business problems. In addition, topical changes have been made in select chapters and brief exercises along with multiple-choice questions have been revised in all the chapters.

SQL Engines for Big Data Analytics

Download SQL Engines for Big Data Analytics PDF Online Free

Author :
Publisher : GRIN Verlag
ISBN 13 : 3346079090
Total Pages : 60 pages
Book Rating : 4.3/5 (46 download)

DOWNLOAD NOW!


Book Synopsis SQL Engines for Big Data Analytics by : Ajit Singh

Download or read book SQL Engines for Big Data Analytics written by Ajit Singh and published by GRIN Verlag. This book was released on 2019-12-09 with total page 60 pages. Available in PDF, EPUB and Kindle. Book excerpt: Master's Thesis from the year 2018 in the subject Computer Science - Internet, New Technologies, grade: 8, , course: Master of Computer Application, language: English, abstract: This book aims to describe how data analytics works for big data and how they are used in business. It gives an overview of existing technologies and ap-proaches to building data analytics infrastructures. It also defines points that should be taken into consideration while choosing the most suitable software solution for a particular use case. The research is done by studying architectural principles of big data sys-tems and investigating the market of data analytics software. The result of this work is a composite report including comparison of several technologies and a list of criteria considered. The final report can be used as a guideline for choosing the most suitable technology for implementing an analytical platform in a broad variety of organizations. With a growing amount of data generated, their changing and evolving, the concept of big data has become incredibly popular in last years. It provides a set of new approaches and techniques allowing to work e ciently with huge volumes of records. Nowadays, information is one of the most important resources; it can help with decision making and business processes optimization. However, to get actual insights and unlock a potential of data, it is necessary to process them and discover the information hidden inside it which is a goal of data analytics. Data analytic platforms allow to manipulate with raw data in order to find out what exactly they contain. These systems are complex and includes multiple components therefore their designing requires comprehensive analysis of available options.

Understanding Big Data: Analytics for Enterprise Class Hadoop and Streaming Data

Download Understanding Big Data: Analytics for Enterprise Class Hadoop and Streaming Data PDF Online Free

Author :
Publisher : McGraw Hill Professional
ISBN 13 : 0071790543
Total Pages : 176 pages
Book Rating : 4.0/5 (717 download)

DOWNLOAD NOW!


Book Synopsis Understanding Big Data: Analytics for Enterprise Class Hadoop and Streaming Data by : Paul Zikopoulos

Download or read book Understanding Big Data: Analytics for Enterprise Class Hadoop and Streaming Data written by Paul Zikopoulos and published by McGraw Hill Professional. This book was released on 2011-10-22 with total page 176 pages. Available in PDF, EPUB and Kindle. Book excerpt: Big Data represents a new era in data exploration and utilization, and IBM is uniquely positioned to help clients navigate this transformation. This book reveals how IBM is leveraging open source Big Data technology, infused with IBM technologies, to deliver a robust, secure, highly available, enterprise-class Big Data platform. The three defining characteristics of Big Data--volume, variety, and velocity--are discussed. You'll get a primer on Hadoop and how IBM is hardening it for the enterprise, and learn when to leverage IBM InfoSphere BigInsights (Big Data at rest) and IBM InfoSphere Streams (Big Data in motion) technologies. Industry use cases are also included in this practical guide. Learn how IBM hardens Hadoop for enterprise-class scalability and reliability Gain insight into IBM's unique in-motion and at-rest Big Data analytics platform Learn tips and tricks for Big Data use cases and solutions Get a quick Hadoop primer

Data Analysis Using SQL and Excel

Download Data Analysis Using SQL and Excel PDF Online Free

Author :
Publisher : John Wiley & Sons
ISBN 13 : 0470952520
Total Pages : 698 pages
Book Rating : 4.4/5 (79 download)

DOWNLOAD NOW!


Book Synopsis Data Analysis Using SQL and Excel by : Gordon S. Linoff

Download or read book Data Analysis Using SQL and Excel written by Gordon S. Linoff and published by John Wiley & Sons. This book was released on 2010-09-16 with total page 698 pages. Available in PDF, EPUB and Kindle. Book excerpt: Useful business analysis requires you to effectively transform data into actionable information. This book helps you use SQL and Excel to extract business information from relational databases and use that data to define business dimensions, store transactions about customers, produce results, and more. Each chapter explains when and why to perform a particular type of business analysis in order to obtain useful results, how to design and perform the analysis using SQL and Excel, and what the results should look like.