4.81
Course Overview
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.
Learning Options
Schedule Dates
Microsoft Power BI for End Users
Microsoft Power BI for End Users
Microsoft Power BI for End Users
Microsoft Power BI for End Users
Course Content
- 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
- 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
- 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
- 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
- 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
- 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
FAQs
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.
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
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.
Upon completing the course, participants will receive a certificate of completion from CounselTrain.
Yes, CounselTrain offers customized training solutions for organizations. Contact our corporate training team for information on tailored programs.
Participants have access to instructors for support and clarification throughout the course, along with comprehensive course materials and resources.
Duration
Language
Batch Options
Upcoming Batch
Soft copy of Courseware
Certificate of Course Complition
Experienced and Professional Trainer
Lab and Exercises During Training 
Sample Questions for Exam Prepration
Mock Test on the Last Day of Training 
Exam Registration Guidance 
5-Star Training Environmment