Professional Data Analysis Diploma

Using Excel & Power BI

By: Mr. Mamdouh Gouda

New

Duration: 20h 15m / 11 lessons

level

Level: General

Course Language: Arabic

30-Days Money Back Guarantee

Get access to all lessons only for

3900 EGP 6500 EGP

By the end of this course, you will be able to:

Connect to any different types of Data Source using Power BI and Excel.

Apply various techniques to Extract, Clean, Transform, Combine Data (ETL).

Apply Various Techniques to Build Professional Data Model and Relationships.

Mastering the techniques of designing interactive Dashboard and Reporting using Power BI and Excel.

Mastering the techniques of build charts (Visuals) KPIs, Map, Matrix, filters, Combo, Slicers, Q&A, Decomposition tree and AI Visuals, etc.. in Power BI.

Mastering Storytelling of data visualizations to Managers and board of directors.

Publish and share your reports with others in Power BI Online and BI Mobile App.

Techniques to present and share your Dashboard to MS PowerPoint and MS SharePoint.

Using MS Excel Calculations Professionally, Pivot Table, Pivot Charts, Slicer, Filters and other analytics features to perform data analysis and Data Visualizations tasks.

Prerequisites:

  • A computer with Windows 10 or higher operating system.
  • A basic familiarity with Excel [optional but recommended].
  • Working Easley with Functions methods:- Sum, count, IF and LOOKUP Functions. [optional but recommended].
  • Must be Aware of data concepts and terminology, Numbers, Text, Dates, Ranges and Tables.

Syllabus:

  • Module 1:- Introduction to Data Analysis [Power BI & MS Excel].
  • Module 2:- Data Sources and Queries [Connections & transformations].
  • Module 3:- Data Modeling [Relationships & Analyzing with DAX ].
  • Module 4:- Data Visualization and Storytelling.
  • Module 5:- Data Sharing and Collaboration.
  • Module 6:- AI Tools in Excel and Power BI.

Support