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.• The use of various functions to perform arithmetic operations.• Use logical functions, date and time functions, texts and other various functions to collect data and extract the required data from them.• Use different commands and analysis tools for all used programs.• Create pivot tables to summarize data and create interactive reports.• Query data and reshape it in different ways.• 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.• Working with orders that contribute to simplifying data analysis.• Working with Advanced different 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, create graphs and plan them.• Using Power Query.• Creating interactive slides that contribute to decision-making.• Dashboard design whether using Excel • Critical thinking.• Data protection.

Course Contents

 Reviewing of Advanced Functions in Excel Data Analysis Fundamentals Using Excel Introducing Excel chars & sparklines and Formatting data Data analysis steps Pivot tables & Type of Charts &slicers and Timeline Interactive Excel Dashboard 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 Import data from a report Power Pivot using DAX functions Create measures using advanced DAX functions Combing Data How to use power Map Creating Dashboard  Protection Workbooks Finalization Interactive Reports Visualization data