Retail Analytics And Market Intelligence

“Learning Unit 1: Metrics and Measurements for Data Analytics

Define Retail Analytics.
Explain what Market Intelligence is.
Discuss Types of Data Collection Tools and Data Collection Techniques.
Describe how data collected is used for Market Intelligence.

Learning Unit 2: All About Data Models and Data Linkages

Import data into Excel (Spreadsheets, CSV, Database).
Create tables and conduct basic analysis.
Create Pivot Table with aggregation and built-in calculations.
Introduce and explain Calculated Items and Calculated Fields.
Introduce PowerPivot.
Understand relationships within data models.
Create data models and explain the difference between Calculated Items and Calculated Fields.
Import data from multiple sources and create data models with relationships.

Learning Unit 3: Data Analytics and Data Visualization Trends

Create and format Pivot Charts.
Understand and create DAX measures.
Learn DAX syntax and apply it in creating measures within Pivot Tables.

Learning Unit 4: Effectiveness of Data Analytical Tools

Evaluate the effectiveness of data analytical tools.
Compare Power Pivot vs Pivot Table.
Contrast Excel vs Power BI Desktop.

Learning Unit 5: Analysing Key Performance Metrics to Manage Business Performance

Identify key retail business performance metrics such as churn analysis, revenue growth, cost optimization, and predictive modeling.
Identify Excel functions and DAX measures to generate these metrics.

Learning Unit 6: Analysing Customer Activities and Behaviour

Use visualizations to create dashboards with slicers.
Observe business trends based on the interactivity of visualization.
Discuss how to observe trends using trend lines and patterns, provide examples, and analyze observed trends and patterns.

Learning Unit 7: Address Business Questions Through Analysing Reports and Dashboards

Identify types of reports required for retail such as sales analysis, churn analysis, revenue growth, and consumer segmentation.
Analyze data from market intelligence.”