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 displa...
Posts
Showing posts from August, 2025