Data Analysis and Visualization using Microsoft Power BI Training in Kenya
Info
Sign Up: Here
Course Summary
This course on Data Analysis and Visualization using Microsoft Power BI aims to equip participants with a strong foundation in the use of Power BI, covering essential functionalities from basic operations to more advanced analytical techniques. Attendees will gain skills necessary for crafting impactful dashboards and reports that facilitate better decision-making within their organizations.
Who Should Attend
The course is designed for beginners keen to utilize Microsoft Power BI for detailed data analysis and visualization. A basic understanding of data concepts and analysis tools will enhance the learning experience.
Learning Goals:
Upon completing this training, participants will have the ability to:
- Grasp the fundamental elements and features of Power BI.
- Import data from varied sources into Power BI.
- Execute data transformation and shaping techniques.
- Create visually engaging and interactive reports.
- Use DAX for advanced analytics applications.
- Collaborate effectively within their organization.
- Understand data governance and security protocols in Power BI.
Prerequisites
- Access to Microsoft Power BI Desktop
- This training is geared towards PC/Windows users only
Duration of the Course
Online format: 6 days
In-person format: 5 days
Course Modules
Module 1: Power BI Introduction and Data Connections
- Components of Power BI
- Power BI Features
- Workflow in Power BI
- Self-Service ETL process
- Setting up Power BI
- Data from Excel
- Online sources
- Database connectivity
Module 2: Data Cleaning and Transformation
- Using Headers for Rows
- Renaming Fields & Replacing Cell Values
- Data Type Adjustments
- Un-pivoting Columns
- Grouping and Splitting Columns
- Feature Extraction
- Addition of Columns
- Filtering Data
- Native vs Unfold Queries
Module 3: Data Modeling and Relationships
- Types of Table Relationships
- Introduction to DAX
- Creating Measures and Calculated Columns
- Understanding Row vs Filter Context
Module 4: Working with DAX Functions
- Aggregate Functions
- Date Functions
- Intelligence Functions
- Filter Functions
- Relationship Functions
- Logical Functions
- Text Processing Functions
Module 5: Creating Visualizations with Power View
- Bar and Column Charts
- Line and Area Charts
- Pie and Donut Charts
- Map Visualizations
- Funnel and Tree Map Graphs
- Using Parameters and Slicers in Visuals
- Determining Appropriate Visual Types
Module 6: Dashboard Creation and Sharing
- Understanding Workspaces
- Datasets and Reports
- Dashboard Creation and Management
- Sharing Dashboards
- Configuring Security Settings
- User Role Setup
Module 7: Power BI for Mobile Devices
- Configuring Mobile Access
- Viewing Dashboards on Mobile
- Commenting and Editing via Mobile
- Using Excel with Power BI
- Building Reports in Excel for Power BI
Contact Information
Monica C. | Training Coordinator
Cell / WhatsApp: +254 712 028 449
Email:training@perk-gafrica.com
Website:perk-gafrica.com
When
Where
Other events events in Nairobi Kenya
