SQL for Data Analytics by Upom Malik; Matt Goldwasser; Benjamin JohnstonTake your first steps to become a fully qualified data analyst by learning how to explore large relational datasets Key Features Explore a variety of statistical techniques to analyze your data Integrate your SQL pipelines with other analytics technologies Perform advanced analytics such as geospatial and text analysis Book Description Understanding and finding patterns in data has become one of the most important ways to improve business decisions. If you know the basics of SQL, but don't know how to use it to gain the most effective business insights from data, this book is for you. SQL for Data Analytics helps you build the skills to move beyond basic SQL and instead learn to spot patterns and explain the logic hidden in data. You'll discover how to explore and understand data by identifying trends and unlocking deeper insights. You'll also gain experience working with different types of data in SQL, including time-series, geospatial, and text data. Finally, you'll learn how to increase your productivity with the help of profiling and automation. By the end of this book, you'll be able to use SQL in everyday business scenarios efficiently and look at data with the critical eye of an analytics professional. Please note: if you are having difficulty loading the sample datasets, there are new instructions uploaded to the GitHub repository. The link to the GitHub repository can be found in the book's preface. What you will learn Perform advanced statistical calculations using the WINDOW function Use SQL queries and subqueries to prepare data for analysis Import and export data using a text file and psql Apply special SQL clauses and functions to generate descriptive statistics Analyze special data types in SQL, including geospatial data and time data Optimize queries to improve their performance for faster results Debug queries that won't run Use SQL to summarize and identify patterns in data Who this book is for If you're a database engineer looking to transition into analytics, or a backend engineer who wants to develop a deeper understanding of production data, you will find this book useful. This book is also ideal for data scientists or business analysts who want to improve their data analytics skills using SQL. Knowledge of basic SQL and database concepts will aid in understanding the concepts covered in this book.
Publication Date: 2019-08-23
Marketing Metrics by Paul Farris; Neil Bendle; Phillip E. Pfeifer; David J. ReibsteinToday''s Definitive Guide to Marketing Metrics Choosing Them, Implementing Them, Applying Them New quantitative formulas, applications, and analytical techniques Best practices for measuring promos, ads, distribution, perception, market share, pricing, margins, portfolios, channels, dashboards, and more All-new chapter on leveraging today''s rich online, email, and mobile metrics Expert guidance for clarifying what to measure, and testing reliability and validity Now extensively updated, this award-winning book will help you apply today''s most effective metrics to all your marketing investments, get accurate answers, and use them to systematically improve ROI. You''ll find practical techniques for measuring everything from brand equity to social media, market share to email performance. For each metric, the authors present real-world pros, cons, and tradeoffs--and help you understand what the numbers really mean. You''ll learn how to design and interpret marketing dashboards to identify emerging opportunities and risks, and use powerful modeling techniques to optimize every decision you make. A brand-new chapter on online metrics brings desperately needed clarity to metrics such as pageviews; rich media display time and interaction rates; clickthrough rates; cost-per-click, order, and customer acquired; visits, abandonments, and bounce rates; friends, followers, supporters, and even "likes." This Third Edition adds important new coverage of topics ranging from brand valuation to neuromarketing, as well as crucial insights for selecting the right metrics, and making sure you can trust your data. www.management-by-the-numbers.com Marketing Metrics, Third Edition, is the definitive guide to today''s most valuable marketing metrics. In this thoroughly updated and significantly expanded book, four leading marketing researchers show exactly how to choose the right metrics for every challenge. The authors show how to use marketing dashboards to view market dynamics from multiple perspectives, maximize accuracy, and "triangulate" to optimal solutions. You''ll discover high-value metrics for virtually every facet of marketing: promotional strategy, advertising, and distribution; customer perceptions; market share; competitors'' power; margins and pricing; products and portfolios; customer profitability; sales forces and channels; and more. This edition adds a rigorous and comprehensive discussion of the latest web, online, social, and email metrics, helping you navigate today''s many new metrics to gain usable and trustworthy information. The authors have added new insights into measuring marketing ROI and brand equity, as well as practical advice for managing complex issues such as advertising elasticity and "double jeopardy." You''ll also find updated and expanded discussions of prioritizing the right metrics for your business, and ensuring the information you capture is valid, reliable, and actionable. Choose the right metric for every marketing challenge Understand the full spectrum of marketing metrics: pros, cons, nuances, and application Gain a deep and thorough understanding of Marketing ROI (MROI) Quantify how your marketing spending actually contributes to profits Understand and apply web/online metrics far more effectively Get actionable knowledge from new web, rich media, and social metrics--including Google Analytics Measure what matters, and measure it reliably Choose the right metrics, and ensure accurate, valid data for decision-making
Publication Date: 2015-08-27
Data Strategy by Bernard MarrBRONZE RUNNER UP: Axiom Awards 2018 - Business Technology Category Less than 0.5 per cent of all data is currently analyzed and used. However, business leaders and managers cannot afford to be unconcerned or sceptical about data. Data is revolutionizing the way we work and it is the companies that view data as a strategic asset that will survive and thrive. Data Strategy is a must-have guide to creating a robust data strategy. Explaining how to identify your strategic data needs, what methods to use to collect the data and, most importantly, how to translate your data into organizational insights for improved business decision-making and performance, this is essential reading for anyone aiming to leverage the value of their business data and gain competitive advantage. Packed with case studies and real-world examples, advice on how to build data competencies in an organization and crucial coverage of how to ensure your data doesn't become a liability, Data Strategy will equip any organization with the tools and strategies it needs to profit from Big Data, analytics and the Internet of Things (IoT).
Publication Date: 2017-04-25
A Practitioner's Guide to Business Analytics: Using Data Analysis Tools to Improve Your Organization's Decision Making and Strategy by Randy BartlettThe Definitive Guide to Using Analytics for Better Business Decisions "A must-read for anyone who is directly or indirectly leading or managing an analytics function--and anyone who wants to make better decisions based on analytics, not just intuition or an ''overemphasis on industry knowledge, which crowds out good analytics.''" -- Charlotte E. Sibley, President, Sibley Associates, a bioPharma consulting company "Over the long term, those who show the greatest imagination, grow the right skills, build the deepest organizations, and follow rigorous statistical practice will reap the greatest rewards from their analytics efforts. A Practitioner''s Guide to Business Analytics lights the way." -- Thomas C. Redman, PhD, the Data Doc, Navesink Consulting Group "Executives beware. This is not your typical management book. This book contains real information from analytical professionals who are outside the executive bubble. . . . Hold on to your seat and be prepared to change the way you think about leaders, leadership qualities, and leadership skills needed for future success in the changing business landscape." -- Thomas J. Scott, Director/Advisor, Marketing Sciences Solutions, TGaS Advisors "Randy Bartlett has written an important and useful book, filling at least some of the large void between books that exhort managers to think more analytically without explaining how, and overly technical books that only quantitative analysts would appreciate. Particular strengths are the recommendations about how to organize to integrate analytical expertise into decision-making and the guidance about how managers can assess whether they are getting good analytical advice." -- Douglas A. Samuelson, D.Sc., President and Chief Scientist, InfoLogix, Inc., Annandale, VA; quantitative analyst, inventor, entrepreneur and executive About the Book: The real tragedy of a company failing while using analytics is the fact that its leaders will have the data to explain the failure, but they won''t have the capabilities in place to filter the data and convert itinto actionable business insights. One implication of Big Data is that we need to adapt . . . quickly. A Practitioner''s Guide to Business Analytics integrates powerful strategies for leveraging analytics inside a business with a how-to playbook of tactics to make it happen. The case for competing based on analytics is clear, but until now, there hasn''t been authoritative guidance for inciting a corporate community to evolve into a thriving, analytics-driven environment. This hands-on book gives you the tools, knowledge, and strategies to capture the level of organizational commitment you need to get business analytics up and running in your company. It helps youdefine what business analytics is, quantify the exponential value it brings to an organization, and show others how to harness its power to gain advantage over competitors. Accomplished business information professional Randy Bartlett brings his comprehensive coverage to life with firsthand accounts of using business analytics at brand-name global companies. Through in-depth examinationsof success stories and failures in analytics-baseddecision making and data analyses, he fully prepares you to: Assess your company''s analytics needs and capabilities, and develop a strategic analytics plan Steward the three pillars of Best Statistical Practice and accurately measure the quality of analytics-based decisions and data analyses Build and organize a specialized Business Analytics Team to lead infrastructural changes Upgrade the foundation that supports business analytics--data collection, data software, and data management Create the essential synergy for success between the Business Analytics Team and IT Effectively integrating analytics into everydaydecision making, corporate culture, and business strategy is a multifront exercise in leadership, execution, and support. The specialized tools and skill sets required to succeed are finally in one resource--A Practitioner''sGuide to Business Analytics.