Course Outline

Module 1: Introduction to Data Manipulation with SPSS and Visualization with Power BI

• Installation and familiarization with Training Software (Power BI).
• Refresher on Open HMIS and Kenya EMR.
• Use Kenya EMR data tools to export data to other applications.
• Case Study: Analyze the impact of data visualization on healthcare outcomes using Kenya EMR data.

Module 2: Connecting to Data Sources & Data Transformation: Data Management and Data Cleaning in Power BI (Power Query)

• Exporting data to Power BI.
• Using first rows as headers.
• Rename fields & replacing data values in cells, rows.
• Changing data types & changing the order of columns.
• Un-pivoting columns.
• Grouping and splitting columns into multiple.
• Extract feature (before/after delimiter).
• Adding new columns.
• Filters and parameters.
• Case Study: Cleaning and transforming sales data for a retail business to improve reporting accuracy.

Module 3: Analyzing and Visualizing Data using Microsoft Power BI

• Introduction to Power BI.
• Components of Power BI.
• Features of Power BI.
• Power BI workflow.
• Self-Service ETL (Extract, Transform, Load).
• Setup and Configuration of Power BI.
• Case Study: Visualizing customer demographics to enhance marketing strategies in a telecommunications company.

Module 4: Connecting to Data Sources

• Excel.
• Online sources.
• SQL.
• Case Study: Integrating data from multiple sources to analyze sales performance across different regions.

Module 5: Modeling in Power BI

• Table relationship (one to one, one to many, many to many).
• Data Analysis Expression (DAX).
• Measures and calculated columns.
• Mastering DAX using quick measures.
• Case Study: Creating a sales dashboard that utilizes DAX to calculate year-over-year growth for a financial analysis.

Module 6: Visualization and Charts (Power View)

• Stacked bar chart and stacked column chart.
• Clustered bar chart and clustered column chart.
• Line chart & area chart.
• Line and clustered column chart.
• Line and stacked column chart.
• Ribbon & waterfall chart.
• Funnel & tree map visuals.
• Pie chart and doughnut chart.
• Case Study: Designing a dashboard with various chart types to showcase project progress in a construction company.

Module 7: Visualization and Charts (Power View)

• Table chart and matrix chart.
• Slicer, gauge, card visuals.
• Map and filled map.
• ArcGIS maps for Power BI.
• KPI.
• Q & A visual.
• Use and application of Slicers.
• Case Study: Implementing geographic data visualization to track delivery performance across different locations in a logistics firm.

Module 8: Power BI for Mobile

• Configuring Power BI for Mobile.
• Visualize dashboards and reports on Power BI Mobile.
• Commenting on reports and dashboards in Power BI Mobile.
• Case Study: Analyzing the effectiveness of mobile dashboards in improving field sales team performance.

Module 9: Building and Sharing a Dashboard

• Workspace.
• Datasets.
• Reports.
• Create Dashboard.
• Modify and update Dashboard.
• Share your Dashboard.
• Power Q&A and Insights.
• Case Study: Collaborating on a shared dashboard to track key performance indicators (KPIs) in a marketing department.

Module 10: Excel Power BI

• Power Query and Power Pivot on Excel.
• Visualize and edit Power BI reports using Excel analyzer.
• Building reports on Excel and publishing to Power BI service.
• Case Study: Enhancing financial reporting by integrating Excel models with Power BI for dynamic updates and visualizations.