Data Analysis and Modeling Using Power BI

Objectives:
• Equip participants with essential skills in data analysis and modeling using Microsoft Power BI
• Provide a comprehensive understanding of data visualization, data transformation, and data modeling techniques in Power BI
• Enable participants to create interactive dashboards, reports, and visualizations for effective data analysis
Course Content:
• Introduction to Power BI
• Components and Features of Power BI
• Power BI Workflow
• Self-Service ETL (Extract Transform Load)
• Setup and Configuration of Power BI
• Connecting to Data Sources
• Excel
• Online sources (Google Sheet, Kobo Toolbox, ONA, SurveyCTO, DHIS)
• Databases (PostgreSQL, MySQL, Microsoft SQL Server)
• Data Transformation: Data Management and Data Cleaning Processes in Power BI (Power Query)
• Various data cleaning processes like renaming fields, changing data types, and adding new columns
• Data transformation techniques such as unpivoting columns, grouping, and splitting columns
• Modelling and Table Relationship
• Understanding table relationships (One to One, One to many, Many to many)
• Introduction to Data Analysis Expression (DAX)
• Working with measures and calculated columns
• DAX Functions
• Aggregate, Date and Time, Time Intelligence, Filter, Relationship/Navigation, Logical, and Text Functions
• Visualization and Charts (Power View)
• Various visualization types like Stacked Bar chart, Clustered Column chart, Line chart, Area Chart, and more
• Building and Sharing a Dashboard
• Workspace, Datasets, Reports, and Dashboards creation
• Sharing and modifying Dashboards, Power Q&A, and Insights
• Data Security in Power BI
• Configuring Row level security and user roles
• Publishing and Sharing
• Different sharing options, publishing from Power BI Desktop, and sharing with Power BI Service
• Configuring data refresh and Power BI for Mobile

Methodology
The training methodology integrates lectures, interactive discussions, collaborative group exercises, and illustrative examples. Participants will acquire a blend of theoretical insights and hands-on practical experience, emphasizing the application of learned techniques. This approach ensures that attendees return to their professional environments equipped with both the competence and self-assurance to effectively implement the acquired skills in their responsibilities
.

DATE:
1ST BATCH: 28th – 31st Jan, 2025
2ND BATCH: 1st – 4th July, 2025