Course overview:

• Introduction to Data Analytics in Sales and Targeted Marketing
  • Descriptive Analytics
  • Normal Distributions
  • Confidence Intervals for Decision Making Process
  • Inferential Statistics through Hypothesis Tests
• Journey from Data to Value with SQL​​​​​​​
  • Aggregate Functions
  • Joins and Set Operations
  • Understanding Select Statement
  • Sorting Data Using Order By Clause
  • Count, Sum, Min, Max, Avg, and Group
  • Cross Joins, Inner Join, Outer Join, Self-Join
• Data Analytics and Reporting with Power BI​​​​​​​
  • General workflow in Microsoft Power BI
  • Merging and Appending Datasets
  • Importing other Visualization Tools
  • Types of Reporting and Building Consistent Dashboards (Sales, KPI, Marketing, Targeted Channels)
  • Managing Relationship
  • SQL Joins Proceedings
  • Basic DAX Formulas
  • Sharing Reports on Web and Power BI Service
• Converting Data to Money with Sales Analytics​​​​​​​
  • Identifying the Right Sales Channels
  • Future Sales and Revenue Prediction
  • Sales Churn Prevention Modeling
  • Cross-Sell Recommendations
  • Lead Targeting for Sales Channels
  • Advanced Lead Scoring for Sales Channels
  • Customer Personas & Profiling for Sales Channels
  • Product Development for Sales Channels
  • Procurement Budget Optimization through Sales Analytics  
  • Establishing Professional Sales Dynamic Dashboards
• Journey from Data to Value with Targeted Marketing​​​​​​​
  • Marketing Budget Optimization for Sales Channels
  • Marketing to the Right Audience
  • Lead Targeting on Marketing Strategies
  • Real-Time Interaction Marketing
  • Customer Loyalty Prevention Modeling
  • Matching Marketing Strategies with Customers
  • Content Strategy Creation Based on CB
  • Camping Management process Based on CB
  • Maximization of Customer Lifetime Value (CLV)
  • Establishing Professional Targeted Marketing Dynamic Dashboards