Retail: Analytics and Sales Forecasting with Microsoft Excel

• Learn the basics of Data Analytics
• Understand the importance of Data & Analytics in the retail sector
• Collect data and perform basic ETL (Extract, transform and load)
• Analyze data through organizing, summarizing, and grouping data using pivot tables.
• Create data visualization using pivot charts, slicers, and timelines.

What You'll Learn

The main purpose of the course is to give students a good understanding of data analysis with Microsoft Excel. The course covers the essential topics of performing data analytics and the process of doing collecting the data, cleaning, organizing, and summarizing the data. The latter which will be used to create the visualizing data which will be used to do forecasting and trends in the retail sector.

Minimum Entry Requirement

• Excellent knowledge of relational databases and reporting.
• Familiarity with Microsoft Office applications "“ particularly Excel.