Business Data Analysis with Excel


Business data presents a challenge for the data analyst. Business data is often aggregated, recorded over time, and tends to exhibit autocorrelation. Additionally, and most problematically, the amount of business data is usually quite limited. These characteristics lead to a situation where many of the tools in the analyst’s tool belt (e.g., regression) aren’t ideal for the task. Despite these challenges, proper analysis of business data represents a fundamental skill required of Business/Data Analysts, Product/Program Managers, and Data Scientists. At this community talk we will show how to get started analyzing business data in a robust way using Excel – no programming or statistics required!

We will cover the following during the presentation:

• The types of business data and why business data is a unique analytical challenge.

• Requirements for robust business data analysis.

• Using histograms, running records, and process behavior charts to analyze business data.

• The rules of trend analysis.

• How to properly compare business data across time, organizations, geographies, etc.Where you can learn more about the tools and techniques.

*Excel spreadsheets can be found here:
https://code.datasciencedojo.com/datasciencedojo/tutorials/tree/master/Business%20Data%20Analysis%20with%20Excel


Watch more community talks:
https://tutorials.datasciencedojo.com/category/community-talks/

Learn more about Data Science Dojo here:
https://datasciencedojo.com/data-science-bootcamp/

Watch the latest video tutorials here:
https://tutorials.datasciencedojo.com/

See what our past attendees are saying here:
https://datasciencedojo.com/reviews/

Like Us: https://www.facebook.com/datasciencedojo/
Follow Us: https://twitter.com/DataScienceDojo
Connect with Us: https://www.linkedin.com/company/data-science-dojo

Also find us on:
Instagram: https://www.instagram.com/data_science_dojo/
Vimeo: https://vimeo.com/datasciencedojo

#excel #exceltutorial #datascience

Guidelines For Effective Meetings

API quota exceeded. You can make 500 requests per day.

To Increase Your Productivity, Stop Acting Like a Dog!

Productivity – Key to Success

Harness the Power of a Calendar!

Why Office Partitions Are Essential For a Productive Working Environment

You May Also Like