Training Course on Data Analysis, Manipulation and Visualization with Power BI

Course Description

The course would start by introducing participants to the basics of data manipulation using Power BI. This would include topics such as data cleaning, data transformation, merging datasets, and creating new variables, then transition to introducing Power BI as a tool for data visualization and reporting. Participants would learn how to connect to various data sources, import data into Power BI, and create interactive visualizations.

The course aims to provide a solid foundation in data manipulation techniques using Power BI, including data cleaning, merging, filtering, and transforming. The course will also cover more advanced topics such as data aggregation, reshaping, and creating derived variables to enhance data analysis capabilities. The course will introduce participants to the basics of Power BI, including data connection, visualization creation, and interactive dashboard design. Further, the course will focus on best practices for creating effective and insightful visualizations using Power BI, including selecting appropriate chart types, designing interactive dashboards, and incorporating data storytelling principles. The course will also explore methods for integrating SPSS outputs and analyses with Power BI, enabling seamless data analysis and visualization workflows.

Course Objectives

Upon the successful completion of this Training Course on Data Analysis, Manipulation and Visualization with Power BI, participants will be able to:

• Understand the fundamentals of data manipulation
• Exploring advanced data manipulation techniques
• Utilize Power BI for data visualization
• Create meaningful visualizations using Power BI
• Integrate SPSS and Power BI

Training Methodology

The course is designed to be highly interactive, challenging and stimulating. It will be an instructor led training and will be delivered using a blended learning approach comprising of presentations, discussions, guided sessions of practical exercise, case study review, web-based tutorials, group work, exploration of relevant issues collaborative strength training, performance measurement, and workshops of participants’ displays, all of which adhere to the highest standards of training. The training technique is built on learning by doing, with lecturers using a learner-centered approach to engage participants and provide tasks that allow them to apply what they’ve learned. Experiential knowledge is also given equal importance within the format of training. Our facilitators are seasoned industry professionals with years of expertise in their chosen fields. All facilitation and course materials will be offered in English.

Who Should Attend?

This Training Course on Data Analysis, Manipulation and Visualization with Power BI would be suitable for, but not limited to:

• Professionals transitioning to Data-related Roles.
• Data Analysts.
• Business Intelligence Professionals.
• Data Scientists.

Course Content

Module 1: Introduction Data Manipulation 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.

Module 2: 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 & change order of columns.
• Un-pivoting columns.
• Grouping and splitting column into multiple.
• Extract feature (before / after delimiter)
• Adding new columns.
• Filters and parameters.

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

Module 4: Connecting to Data Sources

• Excel
• Online sources
• SQL

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

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

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.
• Q & A visual.
• Use and application of Slicers.

Module 8: Power BI for Mobile

• Configuring Power BI for Mobile
• Visualize dashboards and report on Power BI Mobile
• Commenting on reports and dashboards in Power BI Mobile.

Module 9: Building and Sharing a Dashboard

• Workspace
• Datasets
• Reports
• Create Dashboard
• Modify and update Dashboard
• Share your Dashboard
• Power Q&A and Insights.

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.

Requirements

• Participants should be reasonably proficient in English.
• Applicants must live up to Phoenix Center for Policy, Research and Training admission criteria.

NOTE

1. Discounts: Organizations sponsoring Four Participants will have the 5th attend Free
2. What is catered for by the Course Fees: Fees cater for all requirements for the training – Learning materials, Lunches, Teas, Snacks and Certification. All participants will additionally cater for their travel and accommodation expenses, visa application, insurance, and other personal expenses.
3. Certificate Awarded: Participants are awarded Certificates of Participation at the end of the training.
4. The program content shown here is for guidance purposes only. Our continuous course improvement process may lead to changes in topics and course structure.
5. Approval of Course: Our Programs are NITA Participating organizations can therefore claim reimbursement on fees paid in accordance with NITARules.

Booking for Training

Simply send an email to the Training Officer on training@phoenixtrainingcenter.com and we will send you a registration form. We advise you to book early to avoid missing a seat to this training.

Or call us on +254720272325 / +254737566961

Payment Options

We provide 3 payment options, choose one for your convenience, and kindly make payments at least 5 days before the Training start date to reserve your seat:

1. Groups of 5 People and Above – Cheque Payments to: Phoenix Center for Policy, Research and Training Limited should be paid in advance, 5 days to the training.
2. Invoice: We can send a bill directly to you or your company.
3. Deposit directly into Bank Account (Account details provided upon request)

Cancellation Policy

1. Payment for all courses includes a registration fee, which is non-refundable, and equals 15% of the total sum of the course fee.
2. Participants may cancel attendance 14 days or more prior to the training commencement date.
3. No refunds will be made 14 days or less before the training commencement date. However, participants who are unable to attend may opt to attend a similar training course at a later date or send a substitute participant provided the participation criteria have been met.

Tailor Made Courses

This training course can also be customized for your institution upon request for a minimum of 5 participants. You can have it conducted at our Training Centre or at a convenient location.

For further inquiries, please contact us on Tel: +254720272325 / +254737566961 or Email training@phoenixtrainingcenter.com  

Accommodation

Accommodation is arranged upon request and at extra cost. For reservations contact the Training Officer on Email: training@phoenixtrainingcenter.com or on Tel: +254720272325 / +254737566961