Business Analytics: Sales Data (2020)
51mBeginner2022-02-11
Authors

John David Ariansen
Helping organizations understand and use data

Madecraft
Full-Service Learning Content Company
Course details
The sales data at your organization can tell you more than how much revenue you earned. The information you’re generating can be used to produce powerful insights for your entire organization. In this focused course from John David Ariansen, you can learn how to use business analytics tools and techniques to harness your sales data and help your organization get more leads, close more deals, and ultimately grow your book of business. Discover the different challenges sales analysts encounter, the nuances of sales data collection, and how to effectively analyze sales data with tools like Excel, Power BI, and Google Analytics. Plus, learn how to create visualizations such as sales dashboards to communicate your insights in an engaging way.
Learning objectives
Explain the value of sales data.
Analyze data governance and its importance in sales analysis.
Distinguish between performance indicators for tracking sales metrics.
Apply sales analysis techniques in the dashboards.
Examine the importance of PivotCharts.
Distinguish between sales analysis dependencies.
Learning objectives
Explain the value of sales data.
Analyze data governance and its importance in sales analysis.
Distinguish between performance indicators for tracking sales metrics.
Apply sales analysis techniques in the dashboards.
Examine the importance of PivotCharts.
Distinguish between sales analysis dependencies.
Skills covered
Sales MetricsBusiness AnalyticsSalesData ScienceDeep Dive (X:Y)
Concepts
Introduction
- Generating sales insights
Sales Data 101
- Tools to track sales data
- Common challenges
- Sales metrics to study
- Using data source maps
- How data is structured
Effective Sales Analysis
- Tools for studying your data
- Building a PivotChart in Excel
- Data visualization basics
- Sales dashboard
- Reporting infrastructure
- Sales and marketing dashboard
Types of Sales Analysis
- Type of sales analysis
- Identifying seasonality
- Categorical analysis
- Regional analysis
Tools to Analyze Sales Data
- Sales analysis with Google Analytics
- Sales analysis with Tableau
- Sales analysis with Power BI
Additional Resources
- Tableau forums
- Utilizing Reddit
- Watching YouTube
Conclusion
- Time to analyze
Related courses
Related learn paths
- Get Ahead in Business Analytics and Analysis
- Moving from Data Analyst to Data Scientist
- Advance Your Business Analytics Skills
- Become a Business Intelligence Specialist
- Master Key Financial Analyst Skills
- Starting Your Career in Tech: Data Science
- Develop Your Skills as a Program Manager
- Mastering Executive-Level Data Analytics