Hîndarî
Introduction to Power BI
Organization Name
mselect
Sign-up Due
Nov 19, 2023
Dîrokên Perwerdehiyê
Duration: 4 days
Time: 14:00 - 17:00
Location: Erbil, mselect office
Format: classroom based
Fee: $250
Cureyê Perwerdehiyê
Technical Speciality, Information Technology, Humanitarian, Information Management, Monitoring and Evaluation, Project Management
Kurte Kurte
Gain a 360° overview of exploring and using Power BI to build impactful reports. In this course, you will learn how to navigate this intuitive tool through hands-on exercises so you can have a better understanding on Power BI’s Data, Model, and Report views. You’ll load multiple datasets in the Data view, build a data model to understand the relationships between your tables in Model view, and create your first bar graph and interactive map visualization in Report view.
Danasîna Berfireh
Gain a 360° overview of exploring and using Power BI to build impactful reports. In this course, you will learn how to navigate this intuitive tool through hands-on exercises so you can have a better understanding on Power BI’s Data, Model, and Report views. You’ll load multiple datasets in the Data view, build a data model to understand the relationships between your tables in Model view, and create your first bar graph and interactive map visualization in Report view.
What is Power BI?
Power BI Desktop is a free Business Intelligence application from Microsoft that lets you load, transform,
and visualize data
Course Units
Prepare the data
Create a model
Create Visualization
Analyze and prepare insights
Deploy and maintain deliverables
Course Content
Module 1: Introduction to Power BI
Getting Started
Class Introduction (BI Basics)
Class Introduction (Power BI Desktop Overview)
Data Discovery with Power BI Desktop
Transforming Data (Basic Transforms)
Transforming Data (Add Column from Example)
Transforming Data (Appending Queries)
Transforming Data (Merging Queries)
Transforming Data (Combine Files)
Transforming Data (M Query Basics)
Transforming Data (Parameters and Templates)
Transforming Data (Other Query Features)
Introduction to Modeling Data
Creating the Data Model (Modeling Basics)
Creating the Data Model (Model Enhancements)
Creating the Data Model (What If Parameters)
Creating Calculated Columns and Tables (DAX Basics)
Creating Calculated Columns and Tables (Navigation Function)
Creating Calculated Columns and Tables (Calculated Tables)
Creating Calculated Measures (Measure Basics)
Creating Calculated Measures (Time Intelligence Functions)
Module 2: Introduction to Power
Introduction to Visualizing Data
Creating Basic Reports with the Power BI Desktop
Creating Interactive Reports (Adding Slicers for Filters)
Creating Interactive Reports (Visualizing Tabular Data)
Creating Interactive Reports (Visualizing Categorical Data)
Creating Interactive Reports (Visualizing Data Trends)
Creating Interactive Reports (Visualizing Categorical and Trend Data Together)
Creating Interactive Reports (Visualizing Geographical Data with Maps)
Creating Interactive Reports (Visualizing Goal Tracking)
Creating Interactive Reports (Using Custom Visuals)
Creating Interactive Reports (Digital Storytelling)
Creating Interactive Reports (Other Features)
Using the Power BI Service (Deploying to the Power BI Service)
Using the Power BI Service (Creating and Sharing Dashboards)
Using the Power BI Service
Refreshing the Data (Refreshing Data Overview)
Refreshing the Data (Installing the Data Gateway)
Refreshing the Data (Scheduling a Data Refresh)
Course Outcomes
Define and use Power BI
Define and use Power BI Desktop
Work with CSV, TXT, and Excel Worksheets
Connect to Databases
Merge, Group, Summarize, and Calculate Data
Report
Class Introduction (BI Basics)
Class Introduction (Power BI Desktop Overview)
Zimanê Perwerdehiyê
English
Erbil
Walîtiyên Perwerdehiyê
Cihê/yên taybetî yên Perwerdehiyê
Location: Erbil, mselect office
Mesrefên Tevlêbûna Perwerdehiyê
Fee: $250
Pêdiviyên Kêmtirîn Ji bo Tevlêbûna Perwerdehiyê
Recommended to know the basics of working with data in Excel
In the course, you will need a work email address to sign up for the free Microsoft Power BI service
Download the Power BI Desktop app which is available free from Microsoft for Windows Power BI Desktop—Interactive Reports | Microsoft Power BI
Meriv çawa Serlêdana Perwerdehiyê dike
You can register by emailing training@mselect.com with the following details:
Full Name:
City/Town:
Email Address:
Phone number:
Name of the course: