Microsoft Power BI For Professionals

كورس لتعليم برنامج الباور بي أي من الصفر وحتي الاحتراف

4.70 (52 reviews)
Udemy
platform
العربية
language
Management
category
405
students
11.5 hours
content
Feb 2023
last update
$199.99
regular price

What you will learn

Power BI Interface - All Charts - Advanced Charts

How to Format All Charts & Create professional Dashboards

Dashboards Examples

Power Query Edit For ( Text - Numbers )

Data Types

How to Link Excel With Power BI and create live dashboard

How to control Your project Online by mobile

How to create a link which have your projects reports

Advanced Excel Lectures Also added to the course

Description

كورس بالتفصيل من الصفر وحتي الاحتراف لبرنامج ال Power BI هتتعلم فيه كل شيء عن برنامج ال Power BI

إنضم الي اكثر من 5000 طالب حضرو معنا كورسات ال ICDL & Primavera


Power BI provides cloud-based BI (business intelligence) services, known as "Power BI Services", along with a desktop based interface, called "Power BI Desktop". It offers data warehouse capabilities including data preparation, data discovery and interactive dashboards.


يستخدم برنامج ال Power BI في اظهار رسومات بيانيه توضح لاداره الشركات والادارات بسهوله جدا جميع الاحصائيات المطلوبه والتي تساعد الاداره في اتخاذ قرارات مصيريه للشركه


Course Content : 


Introduction


First Video ( Introduction to the course )

( 1 )

- Why We Use Power BI & Power BI Definition

- How to Download & install Power BI

( 2 )

Introduction to basic charts in power BI

- How to create clustered column chart

- stacked column chart

- Pie chart

- Donut chart

- funnel chart

- ribbon chart

- Include & execlude data

- View data & export data

( 3 )

-  Maps in Power BI

- creating simple map

- simple field map

- map with pie chart

- formatting maps

- change map background

- Map of egypt

( 4 )

- Tables and Matrix in power BI

- Create table

- Format table

- conditional format for table

- change aggregation in table ( choose sum or averag for columns )

- Creat A matrix in power BI

- conditional format in matrix

- automatic hirearchies in matrix

- show totals & subtotals in matrix

- Number Formatting in Power BI

( 5 )

- Other Charts in Power BI

- Line chart

- Drill down in line chart

- Area Chart

- Line Vs column chart

- Scatter Plot

- Waterfall chart

- Tree Map

- Gauage chart

( 6 )

- Cards and Filters

- Number Card

- Text Card

- Data Card

- Multi-Row Card

- Filter on visual

- Filter on page

- Filter in all pages

- Drill Throw

( 7 )

- Slicers in Power BI

- Silcer for text

- format text slicer

- data slicer

- format date slicer

- number slicer

( 8 )

- Introduction to advanced charts in Power BI

- Animated Bar chart Race

- Drill down Donut chart

- Drill down column chart

- Word cloud

- sankey chart

- infographic

- play axis

- scroller

- sunburst chart

- histogram

( 9 )

- Images - Text - Buttons in Power BI

- Insert image

- Insert Text

- Insert Shapes

- Insert Buttons

- Web URL action

- Page Navigation

- Book Mark action

- Drill Throw action

( 10 )

- Publishing Reports & Connecting With Power BI Services

- How to create power BI report

- How to create acount on power BI Services

- Publish reports to Power BI Services

- Export Power BI to PPT & PDF

- Comment & share & subscribe to Power BI reports

- Create dashboard in power BI services

- Problems & Solutions for Power BI Dashboard

- How to refresh reports automatically on power BI services

( 11 )

- Text Function in power Query

- Merge

- Split & Trim

- Upper , Lower , Proper

- Add suffix & prefix

- Left & right & MID

- Extract text with delimiter

( 12 )

- Date Function in Power Query

- Year , Quarter , Month , Day

- Difference between Dates & earliest , latest

- Name of day , month

- Day of week / month / year

- extract date from date and time

- calculate age in 2 clicks

- which day of year quarter , month your date of birth

( 13 )

- Power Quary ( Number Functions )

-Add , subtract , Divide , Multiply

- Percentage , Percent of , Modulo

- Rounding Number

- IS Even , Is Odd and sign

( 14 ) 

- Appending Files and tables in power query

- Append multiple CSV Files from a folder

- Append multiple Excel Tables / Sheets from a single folder

- Append Excel Tables with different number of columns

- Append multiple Excel files from afolder

- Append different data source files in power query

( 15 )

- Merge Files & tables in Power Query

- Merge tables / sheets

- merge data from multiple excel files / workbooks

- Merge data from different data source

- merge data having multiple matching columns or different criteria

( 16 )

- What is conditional columns & Columns from Excel

- Column from examples on splitting text

- columns from examples on merge text

- columns from examples ( data columns )

- columns from examples ( alphanumeric data )

- Conditional columns in one column

- Conditional columns in 2 columns

- conditional columns ( comparing 2 columns values )

- Conditional columns on dates

( 17 )

- Very Important Topics in Power Query

- Fill down and Fill up

- Grouping

- Transpose

- Unpivot

- Data types in Power Query

- Replace Errors and values

- Keep Rows & Remove Rows

- Keep Columns & Remove Columns

(18) How to link primavera P6 Database to Power BI

(19) How to create report using Primavera P6 & Power BI .

Content

Introduction

Power BI Lecture 1 ( Introduction )
Power BI Lecture 2 , Introduction to basic charts in power BI
Power BI Lecture 3 , Maps in Power BI
Power BI Lecture 4 , Tables and Matrix in power BI
Power BI Lecture 5 , Other Charts in Power BI
Power BI Lecture 6 , Cards and Filters
Power BI Lecture 7 , Slicers in Power BI
Lecture 8 , Introduction to advanced charts in Power BI
Lecture 9 , Images - Text - Buttons in Power BI

Excel Course

Excel Revision Lecture 1
Excel Revision Lecture 2
Excel Revision Lecture 3
Excel Revision Lecture 4

Screenshots

Microsoft Power BI For Professionals - Screenshot_01Microsoft Power BI For Professionals - Screenshot_02Microsoft Power BI For Professionals - Screenshot_03Microsoft Power BI For Professionals - Screenshot_04

Reviews

Muhamed
December 27, 2022
The best Power Bi Course for Planning Engineers out there. I am beyond happy with the results i got from this course . it helps me ALOT in my work and in my reporting skills in general . if you want to really impress your boss with your reporting skills and be one of a kind among your colleagues just buy this course and finish it and you wont regret trust me .
Ahmed
July 28, 2022
A useful and wonderful course full of information. I advise everyone who wants to study project planning to study from Eng. Ahmed Samir. Thank you very much, Engineer Ahmed Samir
Ahmed
July 2, 2022
شرح اكثر من رائع للمهندس احمد سمير، وهذا ما تعودنا عليه في جميع كورساته، بارك الله فيك، الشرح واضح وسهل ومفيد وجميع الريسورسس موجودة.
Ahmed
November 7, 2021
المحتوى مفيد جدا يوجد كمان مراجعة للاكسيل ضمن الكورس الصوت واضح جدا جدا اسلوب المهندس رائع وكلامه واضح وهدفه يوصل المعلومة بابسط طريقة. شكرا جزيلا والى الامام م.احمد بارك الله فيك

Coupons

DateDiscountStatus
5/1/2022100% OFF
expired

Charts

Price

Microsoft Power BI For Professionals - Price chart

Rating

Microsoft Power BI For Professionals - Ratings chart

Enrollment distribution

Microsoft Power BI For Professionals - Distribution chart

Related Topics

3908370
udemy ID
3/12/2021
course created date
3/21/2021
course indexed date
Bot
course submited by