Digital marketing

Slide 1: Course Overview DATA VISUALIZATION – POWER BI & TABLEAU Lecturer: Dr. Abdiwahab Hashi Software Setup: Download Power BI: https://microsoft.com/power-bi/desktop Slide 2: Power BI – Data Preparation Power Query Editor: Clean data before analysis. Key Steps: Remove unwanted columns/duplicates. Fix null values, merge columns, correct data types. Dataset: Market Data. Data Modeling: Star schema (fact + dimension tables). Example: E-Commerce Data. Slide 3: Power BI Visualizations Basic Charts: Bar/Column: Compare categories. Cluster Bar: Multiple series side-by-side. Proportional Charts: Pie/Donut: Parts of a whole. Trend Charts: Line/Area: Trends over time. Combo: Bar + line in one visual. Advanced Visuals: Waterfall: Incremental changes. Scatter: Correlations. Funnel: Process stages. Slide 4: Power BI Dashboard Elements KPI: Single metric (e.g., profit). Card/Gauge: Single value or progress. Slicer: Interactive filters. Multi-row Card: Compact data display. Slide 5: Tableau Section Recreate Power BI visuals in Tableau. Use DAX for calculations. Follow lifecycle: Connect → Prepare → Analyze → Visualize. Slide 6: Assessment Activities: Classwork + Practical sessions. Projects: Group-based. Final Exam: Hands-on Power BI & Tableau.