How To Gather And Use Data For Business Analysis
()
About this ebook
These days the business world is full of talk about data science, big data, and how data analysis can transform your business.
And it's absolutely true that collecting the right information, in the right way, analyzing that information, and then using it effectively to manage your business can give your business a competitive edge.
But most businesses don't need to go so far as big data and data science. They just need to understand and implement some basic steps for gathering the right information about their business and using it effectively.
Leveraging over twenty years of experience using data for business, M.L. Humphrey will walk you through what you need to know to help improve your bottom line today.
So don't wait. Get started now.
This title was previously published as Data Principles for Beginners.
M.L. Humphrey
Hi there Sci Fi fans, my name is Maurice Humphrey. I am a Vermont native, husband, father, grandfather, well over 60, Navy veteran, retired IBM engineer, retired printer repairman, Graduated: Goddard Jr. College, VT Technical College, and Trinity College. Over the years I've written technical articles, taught technical classes, and presented at technical conventions. I've been reading science fiction for over 50 years now. First books were "Journey to the Centre of the Earth" by Jules Verne and "The Stars Are Ours" by Andre Norton. I've read and collected many great stories, and a considerable amount of junk ones as well. I'd say by now that I probably have a good idea of what I consider a good story.
Read more from M.L. Humphrey
Excel 2019 Formulas and Functions Study Guide Rating: 0 out of 5 stars0 ratingsAccess Essentials 2019 Rating: 0 out of 5 stars0 ratingsAccess 2019 Beginner: Access Essentials 2019 Rating: 0 out of 5 stars0 ratingsExcel 365 Essentials Rating: 0 out of 5 stars0 ratingsMicrosoft Office 2019 Beginner Rating: 0 out of 5 stars0 ratingsExcel Tips and Tricks Rating: 0 out of 5 stars0 ratingsPowerPoint 365 Essentials: PowerPoint 365 Essentials Rating: 0 out of 5 stars0 ratingsAccess 2019 Intermediate: Access Essentials 2019 Rating: 0 out of 5 stars0 ratingsPowerPoint Essentials Rating: 0 out of 5 stars0 ratingsMicrosoft Office for Beginners Rating: 0 out of 5 stars0 ratingsWord Essentials 2019 Rating: 0 out of 5 stars0 ratingsWord 365 Essentials Rating: 0 out of 5 stars0 ratingsTails of the North Rating: 0 out of 5 stars0 ratingsWord Essentials Rating: 0 out of 5 stars0 ratingsToll Booth Rating: 0 out of 5 stars0 ratingsMicrosoft Office 365 for Beginners Rating: 0 out of 5 stars0 ratingsGateway Rating: 0 out of 5 stars0 ratingsThe Excel Essentials Quiz Book Rating: 0 out of 5 stars0 ratings
Related to How To Gather And Use Data For Business Analysis
Related ebooks
Hands-On Microsoft Lists: Create custom data models and improve the way data is organized using Lists in Microsoft 365 Rating: 0 out of 5 stars0 ratingsBusiness Rules Management and Service Oriented Architecture: A Pattern Language Rating: 4 out of 5 stars4/5E-Invoicing Second Edition Rating: 0 out of 5 stars0 ratingsSharePoint Online knowledge Standard Requirements Rating: 0 out of 5 stars0 ratingsSharePoint 2010 Site Owner's Manual: Flexible Collaboration without Programming Rating: 0 out of 5 stars0 ratingsInventory Management System A Complete Guide - 2019 Edition Rating: 0 out of 5 stars0 ratingsSelf-Service Data & Analytics Third Edition Rating: 0 out of 5 stars0 ratingsExtract, transform, load Third Edition Rating: 5 out of 5 stars5/5ColdFusion 9 Developer Tutorial Rating: 0 out of 5 stars0 ratingsPeople, Places, and Things: A Framework for Pain-Free ERP Implementation Rating: 0 out of 5 stars0 ratingsFrom Zero to Hero: Your Journey to Becoming a Data Scientist Rating: 0 out of 5 stars0 ratingsSalesforce Pardot A Complete Guide - 2019 Edition Rating: 0 out of 5 stars0 ratingsMicrosoft Dynamics GP 2016 Cookbook Rating: 0 out of 5 stars0 ratingsSAP SCM: Applications and Modeling for Supply Chain Management (with BW Primer) Rating: 0 out of 5 stars0 ratingsMicrosoft Dynamics GP 2013 Financial Management Rating: 0 out of 5 stars0 ratings100 Puzzles to Learn Data Warehousing Rating: 0 out of 5 stars0 ratingsIBM Cognos Business Intelligence 10.1 Dashboarding Cookbook Rating: 0 out of 5 stars0 ratingsPlanning NetSuite A Complete Guide - 2021 Edition Rating: 0 out of 5 stars0 ratingsLinux Basics for SysAdmin: Learn core linux concepts and command-line skills to kickstart your system administration career Rating: 0 out of 5 stars0 ratingsJava Essentials For Dummies Rating: 0 out of 5 stars0 ratingsLove Thy Data: & Eliminate the Pain Rating: 0 out of 5 stars0 ratingsData Pipelines A Complete Guide - 2019 Edition Rating: 0 out of 5 stars0 ratingsBusiness Analysis with QuickBooks Rating: 0 out of 5 stars0 ratingsJIRA 5.x Development Cookbook Rating: 0 out of 5 stars0 ratingsMobile Apps A Complete Guide - 2021 Edition Rating: 0 out of 5 stars0 ratingsSalesforce CRM A Complete Guide - 2021 Edition Rating: 0 out of 5 stars0 ratingsOrder To Cash A Complete Guide - 2020 Edition Rating: 0 out of 5 stars0 ratingsExcel Functions for the Daily User - Vol 2 Rating: 0 out of 5 stars0 ratingsRed to Black: Secrets of a Savvy Cfo to Run Your Business Successfully Rating: 0 out of 5 stars0 ratings
Business For You
The Unfair Advantage: BUSINESS BOOK OF THE YEAR AWARD-WINNER: How You Already Have What It Takes to Succeed Rating: 5 out of 5 stars5/5The Intelligent Investor, Rev. Ed: The Definitive Book on Value Investing Rating: 4 out of 5 stars4/5Never Split the Difference: Negotiating As If Your Life Depended On It Rating: 4 out of 5 stars4/5Collaborating with the Enemy: How to Work with People You Don't Agree with or Like or Trust Rating: 4 out of 5 stars4/5The Concise Mastery Rating: 5 out of 5 stars5/5The Hard Thing About Hard Things: Building a Business When There Are No Easy Answers Rating: 4 out of 5 stars4/5Triggers: Sparking positive change and making it last Rating: 4 out of 5 stars4/5Business English Vocabulary Builder: Idioms, Phrases, and Expressions in American English Rating: 5 out of 5 stars5/5On Writing Well, 30th Anniversary Edition: An Informal Guide to Writing Nonfiction Rating: 4 out of 5 stars4/5Courage Is Calling: Fortune Favours the Brave Rating: 4 out of 5 stars4/5Discipline Is Destiny: A NEW YORK TIMES BESTSELLER Rating: 5 out of 5 stars5/5High Conflict: Why We Get Trapped and How We Get Out Rating: 4 out of 5 stars4/5Summary of Erin Meyer's The Culture Map Rating: 4 out of 5 stars4/5The Concise Laws of Human Nature Rating: 4 out of 5 stars4/5Finance Basics (HBR 20-Minute Manager Series) Rating: 5 out of 5 stars5/5The Visual Mba: Two Years of Business School Packed into One Priceless Book of Pure Awesomeness Rating: 4 out of 5 stars4/5Work: A History of How We Spend Our Time Rating: 4 out of 5 stars4/5Your Next Five Moves: Master the Art of Business Strategy Rating: 5 out of 5 stars5/5Consulting Interview Case Preparation: Frameworks and Practice Cases Rating: 0 out of 5 stars0 ratingsAn MBA in a Book: Everything You Need to Know to Master Business - In One Book! Rating: 0 out of 5 stars0 ratingsSustainable Innovation: The impact on the success of US large caps Rating: 0 out of 5 stars0 ratingsBusiness Model Generation: A Handbook for Visionaries, Game Changers, and Challengers Rating: 5 out of 5 stars5/5Outstanding business English: Tips for email, social media and all your business comminications Rating: 5 out of 5 stars5/5Sprint: How to Solve Big Problems and Test New Ideas in Just Five Days Rating: 4 out of 5 stars4/5CFA 2025: Level 1 corporate Issuers: CFA level 1, #1 Rating: 4 out of 5 stars4/5A Degree in a Book: Economics: Everything You Need to Know to Master the Subject - in One Book! Rating: 0 out of 5 stars0 ratingsThe Art of Statistical Thinking Rating: 5 out of 5 stars5/5
Reviews for How To Gather And Use Data For Business Analysis
0 ratings0 reviews
Book preview
How To Gather And Use Data For Business Analysis - M.L. Humphrey
ALSO BY M.L. HUMPHREY
Listing of all books by M.L. Humphrey
Regulatory Compliance Fundamentals
AML Compliance Fundamentals
Budgeting for Beginners
Budgeting for Beginners
Excel for Budgeting
Excel for Beginners
Word for Beginners
Access for Beginners
PowerPoint for Beginners
HOW TO GATHER AND USE DATA FOR BUSINESS ANALYSIS
M.L. HUMPHREY
CONTENTS
Introduction
Understand Your Business
Track Every Variable You Want to Analyze In a Usable Way
Separate the Information You Want to Track Into Discrete Units
Enter Once, Use Many Times
Be Consistent Across Data Tables or Data Sources
Use Categorical Variables Instead of Free Text Where Possible
Use Dropdown Menus Where Feasible
Consider Using an Other Option
Keep Your Values Up To Date
Take Care When Making Changes to Your Data
Don't Change Your Raw Data
Document Your Data Clean-Up and Analysis Steps
Save Versions
Test Your Results
Make Assumptions Visible
Know the Limitations of Your Programs
Know the Difference Between a Report and Raw Data
View Your Data From a Business Perspective
Build In Checks and Balances Where You Can
Activity-Based Costing
Conclusion
About the Author
Copyright
INTRODUCTION
There's a lot of buzz these days around big data, data science, and data analysis. And for good reason. Because the more you understand about your business and your customers the more profitable your business can be.
For example, say you have two products, widgets and whatchamacallits, but you don't track the product-level revenue or the product-level expenses. All you know is that last quarter you made $10,000 and you spent $8,000 and that you sold a lot more widgets than whatchamacallits.
You might be tempted given that limited amount of information to think that you should abandon whatchamacallits and sell only widgets. But if you had detailed information about each product you would instead see that you made $6,000 selling whatchamacallits and $4,000 selling widgets and that your expense for selling those whatchamacallits was only $1,000 while your expense for selling widgets was $7,000.
Put those product-level numbers together and you'd see that you made a profit of $5,000 on your whatchamacallit sales and lost $3,000 on your widget sales.
Given those numbers, you'd want to abandon widget sales and focus on whatchamacallits. Or you'd want to fix the issue with why widgets are costing you more than they're making you.
But do you see there why having good information about your business can be so valuable?
Often we make decisions from the gut—I sure sell a lot of widgets, I must be good at that
—instead of using factual information that maybe tells a different story. That's why collecting good data and using the data you have to the best effect is so important and crucial to success. That’s why all the buzz.
But data science is a complicated field. There's a lot of that goes into doing it well and not everyone has the type of mind that can process data at those levels. I myself have dabbled in learning R programming and taken a few courses on big data and data science and while I found it interesting and challenging I realized that it wasn't really what I needed as a small business owner. I'm not trying to parse social trends by mining Twitter feeds, for example.
I just want to know what product sells the best so I can make more of it.
So what I'm going to cover for you in this book are some very basic principles around how to collect information, how to store that information, and how to use that information effectively. These principles are a good foundation for even highly complex analysis, but you don't