Location

Community Services & Continuing Education - Alexandria

Objectives

• The ability to analyze data is a powerful skill that helps you make better decisions, Data analysis delivers answers to real world problems, especially for businesses. By taking qualitative factors, data analysis can help businesses develop action plans, make marketing and sales decisions, and excel in a crowded marketplace. Analysis of data allows businesses to processing company-wide issues such as productivity and performance. It can also identify patterns that then inform business decisions.• 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.• Using logical functions, date and time functions, texts and other various functions to collect data and extract the required data from them.• Using differen

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, creating graphs and planning them.• Dealing with different skills of (Excel - Power BI – Tableau) programs.• Using Power Query.• Creating interactive Dashboard (that contribute to decision-making).• Dashboard design using (Excel - Power BI – Tableau).• Critical thinking.• Data protection.

Course Contents

 Reviewing 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 Create measures using advanced DAX functions Combing data Power View & Power Pivot How to use power map Using Excel with Power Bi Creating a Power Bi Dashboard with Excel Protection workbooks Finalization interactive Reports 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 Sharing dashboard using power bi Tableau basics Linking th