Main MenuMain Menu
Course Code: IT 154
566 Course Visits
Microsoft Power BI
Course Sector:
Information Technology
Course Dates and Locations
Choose a date and location to book your seat
No.
Date
Days
Location
Fees
Enrollment
01
5 Days
Madrid, Spain $4,950
02
5 Days
Dubai, UAE $4,250
Introduction
Training course introducion / brief
You want to analyze data from single or multiple sources? You want to
create your individual datasets based on these sources and transform
your results into beautiful and easy-to-make visualizations? You also
want to share your results with colleagues or collaborate on your
projects? Finally, you want to be able to access your data from multiple
devices? Then the Power BI tools are the tools to choose for you! In
this course you will learn why Power BI offers you a comprehensive set
of Business Intelligence tools for your data analysis goals and how to
use these tools to fulfill all of the above tasks - and more. Imagine to
quickly structure your data, to easily add calculations to it and to
create and publish nice-looking charts in just a few minutes.
Course Objectives
At the end of the training course, participants will be able to
- Get to know the different tools of the Power BI universe and learn how to use them
- Understand Power BI Desktop and its components
- Learn how to use the Query Editor to connect Power BI to various source types, how to work on the Data Model and understand the difference between those two steps
- How to work in the different views of the Data Model
- How to create calculated columns and measures
- How to build relationships between different tables
- How to create a report with different interactive visualization types
- Learn how to use Power BI Service (Power BI Pro) to create dashboards and to share and publish your results
- How to access your results from multiple devices using Power BI Mobile
- How to create custom visuals using typescript and the Power BI Developer Tools
Course Audience
Who is this course for, and can benefit the most
- Business Analysts & Data Professionals seeking to turn data into actionable insights
- Managers & Decision Makers who need to visualize trends and KPIs in real time
- Finance, HR, Sales & Operations Teams working with large datasets and reporting needs
- IT & Database Professionals integrating and maintaining data for enterprise reporting
- Excel Power Users looking to transition from static reports to dynamic dashboards
- Anyone aspiring to build a career in Data Analytics or Business Intelligence
Course Outline
The course aims and learning outcomes
Introduction to Power BI
- What is PowerBI?
- How can it be used to analyze financial data?
- First Project 1/3: Installing Power BI Desktop & Source File Connection
- First Project 2/3: Working in the Query Editor
- First Project 3/3: The Data View & Creating our First Visuals
- Exploring the Interface of the Data Model
- Understanding the Power BI Desktop Workflow
- Understanding the Query Editor Interface
- Important! Creating the Project File & Recommended Settings
- Connecting Power BI Desktop to Source Files
- Keeping & Removing Rows
- Working with Filters
- Removing Empty Rows
- Appending Queries
- Working with Columns
- Formatting Data & Handling Formatting Errors
- Pivoting & Unpivoting Data Splitting Columns
- Creating Groups & Cleaning Up our Project
- Creating a Group
Understanding Relationships
- Cardinality: Many-to-One & One-to-One
- Cross Filter Direction & Many-to-Many
- Understanding Active Properties
- Understanding the DAX Basics
- How to properly use the DAX Syntax
- Supported DAX Data Types
- Understanding "Data Category"
Understanding the CALENDAR Function
- Understanding IF & RELATED
- Calculated Columns vs Measures
- Understanding Basic Visual Concepts
- Getting Started with Visuals & Reports
- Understanding Tooltips & Interactions
- Diving Intro Hierarchies & Drill Mode
- Data Colors & Conditional Formatting
- Formatting Report Pages
- Formatting Visuals
Working with Report Themes
- Using the Slicer
- Understanding Default Summarization & Sorting
- Understanding Default Summarization & Sorting
- Working with Treemaps & Tables
- Understanding Filter Types (Visual, Page & Report)
- Creating Combined Visuals & Waterfalls
Final Project
- At the end of the course, the trainer summarizes all the material
explained during the previous days and focuses on the most important
points which are applicable in our daily life.
- Later, the trainer splits the class into several groups (teams) and distributes the final project which is a simulation of real life tasks and challenges.
- Every team
starts applying what is requested in the final project.
- Meanwhile, the
trainer passes through team members and tries to help them in case of
any difficulty faced. At the end of the day, every team should present
his final work in front of the class and an open discussion is held to
assess the work.
Providers and Associations
Providing the best training services and benefits to our valued clients
Boost certificate of completion
BOOST's Professional Attendance Certificate “BPAC” is always given to the delegates after completing the training course, and depends on their attendance of the program at a rate of no less than 80%, besides their active participation and engagement during the program sessions.
ENDORSED EDUCATION PROVIDER
Flexible deadlines
Customized dates accordance to your schedule
Shareable Certificate
Earn certificate upon completion
COURSE METHODOLOGY
Our Training programs are implemented by combining the participants' academic knowledge and practical practice (30% theoretical / 70% practical activities).
At The end of the training program, Participants are involved in practical workshop to show their skills in applying what they were trained for. A detailed report is submitted to each participant and the training department in the organization on the results of the participant's performance and the return on training. Our programs focus on exercises, case studies, and individual and group presentations.
Since 2001, we have been pioneering the training field in the middle east, we managed to unlock potential and help individuals, teams and organisations to be the best that they can be with our full and integrated solutions.
Quick Links
Our sister companies in Egypt and United Arab Emirates
MOST TRENDING
And Recommended Training Courses
trending
OSHA: Occupational Safety and Health Administration Standards
Date: Apr 13, 2025
Location:Riyadh, KSA
trending
Certified Treasury Professional
Date: Jan 20, 2025
Location:Dubai, UAE
trending
Practical Negotiation Skills for Contract Management
Date: Nov 10, 2024
Location:Jeddah, KSA
We believe in progress for everyone.
We helped more than 10.000 clients over 20 countries on 4 continents in boosting their knowledge, skills and careers.
Boost Training And Consulting © All Copyrights Reserved 2025