كورس بالتفصيل من الصفر وحتي الاحتراف لبرنامج ال 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 :

(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 .