Infra & Admin10
Microsoft Power BI for End Users
Duration
2 Days
Upcoming Batch
23 November 2026 - 24 November 2026
Batch Options
8 hours & 4 hours
Language
English / Arabic
Microsoft Power BI for End Users
The Microsoft Power BI for End Users course at CounselTrain is designed to empower business professionals with the skills needed to transform data into actionable insights using Microsoft Power BI. This comprehensive course covers the essentials of Power BI, from data loading and transformation to creating compelling visualizations and interactive reports. Participants will learn to connect to various data sources, clean and shape data, and utilize Power BI’s powerful features to build dynamic dashboards. The course also includes best practices for sharing and collaborating on reports within their organization. By the end of the course, learners will have the expertise to leverage Power BI for enhanced data-driven decision-making, enabling them to communicate insights effectively and drive business performance.
Course Content
6 modules · 85 topics01Module 1: An Introduction to Power BI10 topics
- What is business intelligence?
- Introducing Power BI
- Power BI tools and services
- Power BI Report Server
- Power BI (Online)
- Power BI Desktop
- Case studies
- Support and information
- Data stories
- Lab 1: Getting Ready
02Module 2: Requirements Gathering12 topics
- Welcome to House Rules Board Games
- Beginning a BI project
- Grain statements
- Data discovery
- Refining information
- Modelling data
- Building reports
- Roles
- Publishing
- Creating dashboards
- Choosing workspaces
- Create and share a report in Power BI
03Module 3: Extract, transform and load data20 topics
- Creating a project with Power BI desktop
- Pinning an active project
- What is in a PBIX file?
- Connecting to data sources
- Managing data connections
- Refine data with Power Query
- Applied steps
- M code language
- Designing your query
- Choose columns
- Rename columns
- Moving columns
- Formatting columns
- Replacing values
- Expanding related columns
- Star schemas
- Merge columns
- Split columns
- Custom and conditional columns
- Lab 1: Starting a project in Power BI desktop
04Module 4: Creating a data model12 topics
- Understanding relationships
- Cardinality
- Cross filter direction
- Hiding tables and columns
- Formatting columns
- Introducing DAX
- Designing calculated columns
- Creating measures
- Adding lookup tables
- Structuring data with dimensional hierarchies
- Roles and row level security
- Lab 1: Designing a data model
05Module 5: Designing Reports11 topics
- Adding pages and navigation buttons
- Using shapes, text and images
- Creating a theme
- Adding visualisations
- Using filters and slicers
- Controlling filters
- Adding drill throughs
- Adding custom visualisations
- Configure phone layouts
- Report tips
- Lab 1: Creating a report
06Module 6: Using workspaces and dashboards20 topics
- Power BI licensing
- My workspaces
- App workspaces
- Premium capacity workspaces
- Creating a new workspace
- Publishing a project
- Parallels with Microsoft Excel
- Publishers and viewers
- Reconnecting with data sources
- Introducing the on-premises data gateway
- Scheduling the data refresh frequency
- Assigning security roles
- Creating and populating dashboards
- Customising dashboard tiles
- Creating tiles using Q&A and quick insights
- Creating a mobile dashboard
- Sharing reports and dashboards
- Publishing apps in a workspace
- Publishing content to websites
- Lab 1: Publish and share reports and dashboards
Schedule Dates
4 upcoming batchesSession TypePhysical sessions run at our training facility.
| Batch Dates | Duration | Batch Options | Language | Action |
|---|---|---|---|---|
| 23 November 2026 - 24 November 2026 | 2 Days | 8 hours & 4 hours | English / Arabic | |
| 01 March 2027 - 02 March 2027 | 2 Days | 8 hours & 4 hours | English / Arabic | |
| 07 June 2027 - 08 June 2027 | 2 Days | 8 hours & 4 hours | English / Arabic | |
| 13 September 2027 - 14 September 2027 | 2 Days | 8 hours & 4 hours | English / Arabic |
Can’t find a suitable date? Request a schedule that fits your team.
Request More InformationFAQs
What are the prerequisites for this course?
There are no formal prerequisites for this course. However, a basic understanding of data concepts and familiarity with Excel or other data analysis tools is beneficial.
What will I learn from this course?
By the end of the course, participants will:
Be able to connect to and transform data from various sources.Understand how to create and customize visualizations in Power BI.Be skilled in designing interactive reports and dashboards.Know how to share reports and collaborate with others in their organization.Gain best practices for effective data visualization and report design
How is the course delivered?
The course is delivered through a mix of instructional content, hands-on labs, and practical exercises. Participants will have access to comprehensive study materials and resources to support their learning.
Will I receive a certification upon completion?
Upon completing the course, participants will receive a certificate of completion from CounselTrain.
Can the course be customized for corporate training?
Yes, CounselTrain offers customized training solutions for organizations. Contact our corporate training team for information on tailored programs.
What support is available during the course?
Participants have access to instructors for support and clarification throughout the course, along with comprehensive course materials and resources.
How We Deliver
Flexible Training Options to Meet Your Needs
Choose how you learn — live online, in-classroom, at your workplace, or internationally. CounselTrain delivers certified IT training across the UAE in the format that fits your team.
Select the method that best suits your needs.
Online Instructor-Led Training
Learn from the comfort of your workplace or at home through live virtual sessions led by expert trainers.
Learn moreHighlights
Classroom Training
Participate in interactive, face-to-face training in our top 5-star training facilities in Dubai.
Learn moreHighlights
Onsite Training
Learn a customised curriculum in your workplace to ensure the most impact and team participation.
Learn moreHighlights
Overseas Training
Participate in our international training sessions and improve your abilities with world-class instructors.
Learn moreHighlights
Related Courses
Other courses in the same category that might interest you.
Infra & Admin10
T|IE: Threat Intelligence Essentials
View Course
Infra & Admin11
I|SE: IoT Security Essentials
View Course
Infra & Admin10