Analyzing Data With Power BI-1

Download as pdf or txt
Download as pdf or txt
You are on page 1of 3

Analyzing data

with

Power
BI
About this course
The main purpose of the course is to give students the
ability to use Power BI to analyze and visualize data. This
includes connecting to different data sources, transforming
data and creating measures, in addition to creating visuals,
reports and dashboards in Power BI.

Audience profile
This course is intended for students who are experienced with
analyzing data with Excel and who wish to add Power BI
capabilities and techniques.

The prerequisites of this course include basic knowledge of


data andanalytics, including business awareness.

The course will likely be attended by business users


who use Excel tools and want to collect and transform
data from multiple data sources to Power BI. It is also
recommended for SQL Server report creators who are
interested in alternative methods of presenting data.
Goals of the Training:
• Create reports using different Power BI Desktopvisuals
• Connect to different data sources with Power BIDesktop
• Transform data with Query Editor
• Learn advanced Query Editortechniques
• Create measures using advanced DAXfunctions.
• Use the different capabilities of Power BIService.

Course Outline at glance:


Power BI Basics Review: Connections and visuals
• Module 1: Connecting to different common datasources
• Module 2: Adding and formatting Out Of The Box visuals
and Custom visuals.
Power Query: Importing and Transforming Data
• Module 3: Data transformationreview
• Module 4: Advanced data transformation andscripting.
• Module 5: Query refreshsettings.
Advanced Techniques
• Module 6: Using Advanced DAXfunctions
• Module 7: Putting all thingstogether
• Module 8: Using Power BI Cloudcapabilities.
Outline is subject to be customized including several hands-on
tasks that fits in the basic needs of the attendees. Labs are
delivered using case method, with full real-world subjects
support.
Hands-on Tasks:
Bring your own laptopto run up
the exercises and tasks provided by the
instructor. To be sure that you can
perform all tasks, the most recent
version of Office 2016 or 2019 for
W i n d o w s with PowerPivot Add-
in) is required.

Training duration:
Total24 hours, can be divided into 4 days, 6 hours per day.

Instructor:
Instructor is highly Experienced, Bilingual
(English / Arabic) and has trained HR
managers, seniors and specialists, senior
accountants and financial managers,
Engineers, teachers, and
students. He is a Microsoft Certified Trainer, holding the
following credentials:

You might also like