› › Data Crunching

Data Crunching

Author : Greg Wilson

Publisher :

Page : 212 pages

File Size : 14,72 MB

Release : 2005

Category : Computers

ISBN :

Get eBook

Book Description

Every day, all around the world, programmers have to recycle legacy data, translate from one vendor's proprietary format into another's, check that configuration files are internally consistent, and search through web logs to see how many people have downloaded the latest release of their product. This kind of "data crunching," may not be glamorous, but knowing how to do it efficiently is essential to being a good programmer. This book describes the most useful data crunching techniques, explains when you should use them, and shows how they will make your life easier. Along the way, it will introduce you to some handy, but under-used, features of Java, Python, and other languages. It will also show you how to test data crunching programs, and how data crunching fits into the larger software development picture.



Pivot Table Data Crunching

Author : Bill Jelen

Publisher : Pearson Education

Page : 581 pages

File Size : 37,49 MB

Release : 2010-10-20

Category : Computers

ISBN : 0789746689

Get eBook

Book Description

PivotTables may be Excel's most powerful feature, but Microsoft has estimated that only 15% of Excel users take advantage of them. That's because PivotTables (and their companion feature, PivotCharts) have a reputation for being difficult to learn. Not any more! In this book, Excel legends Bill Jelen ("MrExcel") and Michael Alexander teach PivotTables and PivotCharts step-by-step, using realistic business scenarios that any Excel user can intuitively understand. Jelen and Alexander go far beyond merely explaining PivotTables and PivotCharts: they present practical "recipes" for solving a wide range of business problems. Drawing on more than 30 combined years of Excel experience, they provide tips and tricks you won't find anywhere else, and show exactly how to sidestep common mistakes. Coverage includes: " Creating PivotTables, customizing them, and changing the way you view them " Performing calculations within PivotTables " Using PivotCharts and other visualizations " Analyzing multiple data sources with PivotTables " Sharing PivotTables with others " Working with and analyzing OLAP data " Making the most of Excel 2010's powerful new PowerPivot feature " Using Excel 2010's Slicer to dynamically filter PivotTables " Enhancing PivotTables with macros and VBA code This book is part of the new MrExcel Library series, edited by Bill Jelen, world-renowned Excel expert and host of the enormously popular Excel help site, MrExcel.com. Teaches PivotTables, PivotCharts, and Excel 2010's new PowerPivot feature through real-world scenarios that make intuitive sense to users at all levels Includes proven PivotTable recipes for instant on-the-job results Helps Excel users avoid common pitfalls and mistakes Part of the brand-new MrExcel Library series, edited by Excel legend Bill Jelen



Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365)

Author : Bill Jelen

Publisher : Microsoft Press

Page : 935 pages

File Size : 22,39 MB

Release : 2021-12-21

Category : Computers

ISBN : 0137521782

Get eBook

Book Description

Use Microsoft 365 Excel and Excel 2021 pivot tables and pivot charts to produce powerful, dynamic reports in minutes: take control of your data and your business! Even if you've never created a pivot table before, this book will help you leverage all their flexibility and analytical power— including important recent improvements in Microsoft 365 Excel. Drawing on more than 30 years of cutting-edge Excel experience, MVP Bill Jelen (“MrExcel”) shares practical “recipes” for solving real business problems, expert insights for avoiding mistakes, and advanced tips and tricks you'll find nowhere else. By reading this book, you will: Master easy, powerful ways to create, customize, change, and control pivot tables Transform huge datasets into clear summary reports Instantly highlight your most profitable customers, products, or regions Use the data model and Power Query to quickly analyze disparate data sources Create powerful crosstab reports with new dynamic arrays and Power Query Build geographical pivot tables with 3D Maps Construct and share state-of-the-art dynamic dashboards Revamp analyses on the fly by dragging and dropping fi elds Build dynamic self-service reporting systems Share your pivot tables with colleagues Create data mashups using the full Power Pivot capabilities in modern Excel versions Generate pivot tables using either VBA on the Desktop or Typescript in Excel Online Save time and avoid formatting problems by adapting reports with GetPivotData Unpivot source data so it's easier to work with Use new Analyze Data artificial intelligence to create pivot tables



Microsoft Excel 2019 Pivot Table Data Crunching

Author : Bill Jelen

Publisher : Microsoft Press

Page : 976 pages

File Size : 29,76 MB

Release : 2018-12-27

Category : Computers

ISBN : 1509308229

Get eBook

Book Description

Renowned Excel experts Bill Jelen (MrExcel) and Michael Alexander help you crunch data from any source with Excel 2019 pivot tables. Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you’ve never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical power–including valuable improvements in Excel 2019 and Excel in Office 365. Drawing on more than 45 combined years of Excel experience, Bill Jelen and Michael Alexander offer practical “recipes” for solving real business problems, help you avoid common mistakes, and present tips and tricks you’ll find nowhere else. By reading this book, you will: • Master easy, powerful ways to create, customize, change, and control pivot tables • Control all future pivot tables using new pivot table defaults • Transform huge data sets into clear summary reports • Instantly highlight your most profitable customers, products, or regions • Use Power Query to quickly import, clean, shape, and analyze disparate data sources • Build geographical pivot tables with 3D Map • Construct and share state-of-the-art dynamic dashboards • Revamp analyses on the fly by dragging and dropping fields • Build dynamic self-service reporting systems • Share your pivot tables with colleagues • Create data mashups using the full Power Pivot capabilities of Excel 2019 and Excel in Office 365 • Automate pivot tables with macros and VBA • Save time by adapting reports with GetPivotData • Discover today’s most useful pivot table tips and shortcuts



Excel 2013 Pivot Table Data Crunching

Author : Bill Jelen

Publisher : Pearson Education

Page : 432 pages

File Size : 43,11 MB

Release : 2013-03-18

Category : Computers

ISBN : 0789748754

Get eBook

Book Description

PivotTables may be Excel's most powerful feature, but Microsoft has estimated that only 15% of Excel users take advantage of them. That's because PivotTables (and their companion feature, PivotCharts) have a reputation for being difficult to learn. Not any more! In this expert tutorial, Excel legends Bill Jelen ("MrExcel") and Michael Alexander teach PivotTables and PivotCharts step-by-step, using realistic business scenarios that any Excel user can intuitively understand. Jelen and Alexander go far beyond merely explaining PivotTables and PivotCharts: they present practical "recipes" for solving a wide range of business problems. Drawing on more than 35 combined years of Excel experience, they provide tips and tricks readers won't find anywhere else, and show exactly how to sidestep common mistakes. Coverage includes: * Creating PivotTables, customizing them, and changing the way you view them * Performing calculations within PivotTables * Using PivotCharts and other visualizations * Analyzing multiple data sources with PivotTables * Sharing PivotTables with others * Working with and analyzing OLAP data * Making the most of Excel 2013's powerful new PowerPivot feature * Using Excel 2013's Slicer to dynamically filter PivotTables * Enhancing PivotTables with macros and VBA code This book is part of the popular MrExcel's Library series, edited by Bill Jelen, world-renowned Excel expert and host of the world-renowned Excel help site, MrExcel.com.



Big Data

Author : Viktor Mayer-Schönberger

Publisher : Houghton Mifflin Harcourt

Page : 257 pages

File Size : 30,9 MB

Release : 2013

Category : Business & Economics

ISBN : 0544002695

Get eBook

Book Description

A exploration of the latest trend in technology and the impact it will have on the economy, science, and society at large.



Excel 2016 Pivot Table Data Crunching

Author : Bill Jelen

Publisher : Que Publishing

Page : 783 pages

File Size : 29,37 MB

Release : 2015-11-05

Category : Computers

ISBN : 0134390601

Get eBook

Book Description

Excel® 2016 PIVOT TABLE DATA CRUNCHING CRUNCH DATA FROM ANY SOURCE, QUICKLY AND EASILY, WITH EXCEL 2016 PIVOT TABLES! Use Excel 2016 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours... understand exactly what’s going on in your business... take control, and stay in control! Even if you’ve never created a pivot table before, this book will help you leverage all their amazing flexibility and analytical power. Drawing on more than 40 combined years of Excel experience, Bill Jelen and Michael Alexander offer practical “recipes” for solving real business problems, help you avoid common mistakes, and present tips and tricks you’ll find nowhere else! • Create, customize, and change pivot tables • Transform huge data sets into clear summary reports • Analyze data faster with Excel 2016’s new recommended pivot tables • Instantly highlight your most profitable customers, products, or regions • Quickly import, clean, and shape data with Power Query vBuild geographical pivot tables with Power Map • Use Power View dynamic dashboards to see where your business stands • Revamp analyses on the fly by dragging and dropping fields • Build dynamic self-service reporting systems • Combine multiple data sources into one pivot table • Use Auto grouping to build date/time-based pivot tables faster vCreate data mashups with Power Pivot • Automate pivot tables with macros and VBA About MrExcel Library Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will • Dramatically increase your productivity—saving you 50 hours a year or more • Present proven, creative strategies for solving real-world problems • Show you how to get great results, no matter how much data you have • Help you avoid critical mistakes that even experienced users make Bill Jelen is MrExcel, the world’s #1 spreadsheet wizard. Jelen hosts MrExcel.com, the premier Excel solutions site, with more than 20 million page views annually. A Microsoft MVP for Excel, his best-sellers include Excel 2016 In Depth. Michael Alexander, Microsoft Certified Application Developer (MCAD) and Microsoft MVP, is author of several books on advanced business analysis with Excel and Access. He has more than 15 years of experience developing Office solutions. CATEGORY: Spreadsheets COVERS: Microsoft Excel 2016



Pivot Table Data Crunching

Author : Michael Alexander

Publisher : Pearson Education

Page : 451 pages

File Size : 32,16 MB

Release : 2001-06-20

Category : Computers

ISBN : 0132714310

Get eBook

Book Description

Become a savvy Microsoft Excel user. Pivot tables are a great feature in Excel that help you organize and analyze data, but not many Excel users know how to use pivot tables. Pivot Table Data Crunching offers a comprehensive review of all the functionalities of Pivot Tables from author Bill Jelen, otherwise known as Mr. Excel from www.mrexcel.com, and Michael Alexander, a Microsoft Certified Application Developer. The authors' practical scenarios and real-world advice demonstrate the benefits of Pivot Tables and how to avoid the common pitfalls of every day data crunching. Each solution presented in the book can be accomplished with resources available in the Excel interface, making Pivot Table Data Crunching a beneficial resource for all levels of Excel users.



Python for Data Analysis

Author : Wes McKinney

Publisher : "O'Reilly Media, Inc."

Page : 553 pages

File Size : 46,9 MB

Release : 2017-09-25

Category : Computers

ISBN : 1491957611

Get eBook

Book Description

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



Effective Data Storytelling

Author : Brent Dykes

Publisher : John Wiley & Sons

Page : 338 pages

File Size : 21,32 MB

Release : 2019-12-10

Category : Computers

ISBN : 1119615720

Get eBook

Book Description

Master the art and science of data storytelling—with frameworks and techniques to help you craft compelling stories with data. The ability to effectively communicate with data is no longer a luxury in today’s economy; it is a necessity. Transforming data into visual communication is only one part of the picture. It is equally important to engage your audience with a narrative—to tell a story with the numbers. Effective Data Storytelling will teach you the essential skills necessary to communicate your insights through persuasive and memorable data stories. Narratives are more powerful than raw statistics, more enduring than pretty charts. When done correctly, data stories can influence decisions and drive change. Most other books focus only on data visualization while neglecting the powerful narrative and psychological aspects of telling stories with data. Author Brent Dykes shows you how to take the three central elements of data storytelling—data, narrative, and visuals—and combine them for maximum effectiveness. Taking a comprehensive look at all the elements of data storytelling, this unique book will enable you to: Transform your insights and data visualizations into appealing, impactful data stories Learn the fundamental elements of a data story and key audience drivers Understand the differences between how the brain processes facts and narrative Structure your findings as a data narrative, using a four-step storyboarding process Incorporate the seven essential principles of better visual storytelling into your work Avoid common data storytelling mistakes by learning from historical and modern examples Effective Data Storytelling: How to Drive Change with Data, Narrative and Visuals is a must-have resource for anyone who communicates regularly with data, including business professionals, analysts, marketers, salespeople, financial managers, and educators.