Have you ever been asked to analyze dozens of Excel files containing the same data structure? This is a common request that can easily be automated using a programming language such as Python. In this post, we will discuss how to concatenate Excel files into a single spreadsheet, which will result in increased productivity and […]
About John Frazier
John C. Frazier is an alumnus of North Carolina State University (M.S. Analytics) and Grand Valley State University (B.S. Statistics). John has business analytics experience working in sectors such as wholesale distribution, higher education, and finance/banking. He also holds four industry certifications. John enjoys exploring new restaurants and cities. He is also an avid gamer who is currently playing League of Legends (Plat) and Hearthstone.
Most Viewed in Business Analysis John Frazier, owner of actionable-business-analytics.com, is listed as a Most Viewed Writer in Business Analytics on Quora, a question-answer site among industry professionals. He has gained over 1,100 answer views during the previous month. On Quora, users may submit questions to be answered by the public, or specify industry leaders […]
Across industries, businesses have benefited from the falling cost of data acquisition and ease of automated data collection. Smart companies have established processes and teams to leverage their data in order to gain a competitive advantage. In this post, we’ll explore the crucial features of an organization’s data science initiative. Understand the Questions Data Can Answer To […]
Pandas is a Python data structure package that an analyst should strive to master. It essentially combines the functionality of Excel spreadsheets with the versatility of SQL joins with the processing power of a back-end programming language. You may need to turn to Pandas to analyze a 2 million row table (Excel maxes at 1,048,576), […]
Your CFO calls for a quick report on sales trends. What should you do? This post will explain how to create a clean, interactive table that highlights the important features of a data set. Through this example, we will provide an introduction to pivot tables, conditional formatting and pivot slicers. Not only will the table call attention to […]
A business analyst has one fundamental goal: to provide actionable, data-driven insight to improve future stakeholder decisions. Make no mistake, art and discretion are required to achieve this goal. An analyst has a multitude of techniques, platforms, and other “tools” at his or her disposal, and it’s likely that any given business question can be answered […]