Data Analysis Using SQL and Excel

Data Analysis Using SQL and Excel
Author :
Publisher : John Wiley & Sons
Total Pages : 698
Release :
ISBN-10 : 9780470952528
ISBN-13 : 0470952520
Rating : 4/5 (520 Downloads)

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.


Data Analysis Using SQL and Excel Related Books

Data Analysis Using SQL and Excel
Language: en
Pages: 698
Authors: Gordon S. Linoff
Categories: Computers
Type: BOOK - Published: 2010-09-16 - Publisher: John Wiley & Sons

GET EBOOK

Useful business analysis requires you to effectively transform data into actionable information. This book helps you use SQL and Excel to extract business infor
The Definitive Guide to DAX
Language: en
Pages: 1515
Authors: Alberto Ferrari
Categories: Computers
Type: BOOK - Published: 2015-10-14 - Publisher: Microsoft Press

GET EBOOK

This comprehensive and authoritative guide will teach you the DAX language for business intelligence, data modeling, and analytics. Leading Microsoft BI consult
T-SQL Window Functions
Language: en
Pages: 716
Authors: Itzik Ben-Gan
Categories: Computers
Type: BOOK - Published: 2019-10-18 - Publisher: Microsoft Press

GET EBOOK

Use window functions to write simpler, better, more efficient T-SQL queries Most T-SQL developers recognize the value of window functions for data analysis calc
Guerilla Data Analysis Using Microsoft Excel
Language: en
Pages: 156
Authors: Bill Jelen
Categories: Computers
Type: BOOK - Published: 2002 - Publisher: Tickling Keys, Inc.

GET EBOOK

Jelen uses his combined experience and analytical ingenuity to demystify the arduous task of dealing with downloaded data. He uses real-life examples of real-li
The Microsoft Data Warehouse Toolkit
Language: en
Pages: 794
Authors: Joy Mundy
Categories: Computers
Type: BOOK - Published: 2007-12-10 - Publisher: John Wiley & Sons

GET EBOOK

This groundbreaking book is the first in the Kimball Toolkit series to be product-specific. Microsoft’s BI toolset has undergone significant changes in the SQ