Business Data Analysis with Excel
Details
https://a248.e.akamai.net/secure.meetupstatic.com/photos/event/b/d/2/2/600_456828418.jpeg
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 meetup presenter Dave Langer will show how to get started analyzing business data in a robust way using Excel – no programming or statistics required!
Dave 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 (https://github.com/datasciencedojo/meetup/tree/master/business_data_analysis_with_excel) will be made available via GitHub for those folks who wish to follow along during the presentation.
**Pizza and refreshments will be served.
Bio:
Dave is a veteran BI, analytics, and data science professional. He is currently the VP of Data Science at Data Science Dojo, focusing on growing the educational services practice. Previously, Dave was a Sr. Director for BI and Analytics at Microsoft where he managed a team that owned the mission-critical data platforms used to run Microsoft’s $10+ Billion supply chain. Dave’s current passions are text analytics, event log mining, and mathematical programming. Dave holds a MS in Computer Science and a BA in Economics from the University of Washington.
https://a248.e.akamai.net/secure.meetupstatic.com/photos/event/1/b/b/b/600_458767099.jpeg
Can't make it? Watch the live stream here:
