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.• Display the data in different images through interactive charts.• Design more than Dashboard • Create interactive slides to display the data

Outcomes

• Proper planning of the data analysis process.• Using Power Query.• Working with Advanced different functions.• Analyzing data and converting it into useful information that contributes to decision making• Dashboard design

Course Contents

• Basic functions in Excel• Data analysis fundamentals using Excel• Excel chars • Data analysis steps• Power query • Interactive Excel dashboard• Visualization data • Power Bi implementation• Dashboard by using power Bi• Get data from sources to Power Bi• Relations between data using power Bi• Charts and maps in power Bi