Location

Community Services & Continuing Education - Alexandria

Objectives

• Working with big data and collecting it from more than one source.• Organizing the data and handling the errors in it.• Consolidation of data, validation and deletion of duplicate data.• Format data in different ways to display it well.• Filtering and revising data.• Query data and reshape it in different ways.• Display the data in different images through interactive charts

Outcomes

• Proper planning of the data analysis process.• Working with orders that contribute to simplifying data analysis.• Working with DAX functions.• Working with big data and collect it from more than one source.• Analyzing data and converting it into useful information that contributes to decision making.• Acquiring the necessary skills to analyze various data.• The future outlook of the company.• Infer numbers, creating graphs and planning them.• Dealing with different skills of program.• Using Power Query.• Creating interactive Dashboard • Critical thinking.• Data protection.

Course Contents

 Power query (Extract, Transform and Load Data) Adding different sources to the data model Creating relationship between the imported sources Importing data from multiple sources e.g. Excel, CSV, Text, Access, Webpage and Folder Create measures using advanced DAX functions Creating a Power Bi Dashboard  Protection workbooks Visualization data  Power Bi implementation Charts and maps in power Bi Sharing dashboard using power bi