fbpx

Certified Data Analyst Professional - CDAP
Certified Python Data Analyst Professional - CPDAP.PY


Data Analysis

Excel / Power BI / Tableau / Looker Studio / MySQL
Python / Data collection (web scraping) / MySQL / EDA (Numpy / Pandas) / Data visualization (Dash / Plotly) / Data Pre-Processing

Training Program Description
Embark on a transformative journey with our Data Analysis Diploma, mastering essential tools like Excel, Power BI, Tableau, Looker Studio, MySQL, Python, NumPy, Pandas, Dash, Plotly, and web scraping. Elevate your data awareness and statistical prowess, unleashing the power of business intelligence and data software. Dive into the art of modeling and transforming data, shaping it into actionable insights that drive clear, informed decision-making. By program’s end, you’ll confidently implement business intelligence solutions using Excel, Power BI, or Google Data Studio, revolutionizing your organization’s reporting system and enhancing decision-making depth. Make data your advantage; enroll now
5/5
more than 99% of Participants rate this Diploma content and results as Super   

CDAP Curriculum:

Certified Data Analyst Professional – CDAP

Excel / Power BI / Tableau / Looker Studio / MySQL

Duration: 110 Hours

Delivery Method: Online Live / Offline

Price Before Discount: 12,000.00 EGP 

Price After 25% Discount : 8,900.00 EGP 

What is Data analysis?.

Data analysis Process.

• What skills, knowledge, and way of thinking do a data analyst need?.

• Excel Basics
• Tables
• Statistics with Excel
     Working with Analysis Toolpak
        • Descriptive Statistics
        • Mean
        • Median
          Mode
          Range
         • Minimum
         • Maximum
         • Skewness
         • Standard Deviation
• Sort & Filter
• Condition Format
• Project#1 create, and Design Table then make conditional format, make custom sort and use Data analysis Icon to get Statistics Values
• Text functions
• Logical Functions
• Statistic Functions
        • Sumif
        • Sumifs
        • Countif
        • Countifs
        • Maxif
        • Minif
        • Averageif
        Count
        • Counta
        • Subtotals
• Lookup Functions
         V lookup
         H lookup
         • Index
         • Match
         X lookup
• Project#2 Create Sales Report Using Functions

• Pivot Tables
      o  Preparing Data to Create Pivot Tables
      o Create, design, change layout and Refresh pivot table
      o Grouping Data (dates, text, and numbers)
      o Calculated Fields and Items
      o Show Value as
      o Auto Generate Multiple Reports
      o GEVERATE GET PIVOT DATA
      o  Double click, Filter, Sort, and search & sort filed list
      o  Auto fit Column Width, Show & Hide Labels and Custom Style
      o Pivot Chart, Format charts, Slicer and Timeline
      o  Conditional Format in pivot table
      o Paste Link & Distinct count
• Working with Power Query: Introduction & Interface
      o Extract data from different Sources
            • Excel
            • Text File
            • Csv
            • Access
            • Web
            • From Folder
• Project#3 Create Sales Report
• Power Query Editor
      o Home Tab
      o Choice & Remove Columns
      o Keep & Remove Rows
      o Split column & Grouping By
      o Transform (Change type & Replace Value)
      o Merge & Append Queries
      o Sort & Change Data Source
• Transform Tab
      o Transpose
      o Pivot & Unpivot Columns
      o Fill & Count Rows
      o Detect Data Type
      o Use First row as header
      o Convert to list & Move

• Add Column Tab
      o Custom From Examples
      o Custom Column
      o Index Column
      o Merge Columns & Extract
      o Standard
      o Date
• View Tab
      o Show & Hide Applied Steps
      o Show & Hide Formula bar
      o Column Quality & Column Profile
• Introduction to Data Model & relationships
      o Create Models
• Introduction to Dax
      o Create Measures
      o Create New Columns
      o Create KPIS
• Project#4 import Data to power Pivot and Power Query then create Marketing Report
• Data Visualization with Excel

•Capstone Project

  • • Introduction & Interface
  •       • Get Data
    •             o  Excel, CSV, Access, SQL Server, Web and Text
  • • Working With Charts
    •       Optimum use of each chart
    •       Format chart
  • • Filter Pane
    •       Filter on this visual
    •       Filter on this page
    •       Filter on all pages
  • • Working with all Tabs
    •       Home Tab
    •       Insert Tab
    •       Modeling Tab
    •       View Tab
    •       Format, Data / Drill
      • • Grouping Data
      • • Conditional Format
      • • Hierarchies
      • • Bookmarks, Page tooltip and Drill through
      • • Learn how to Create Professional Dashboard
      • • Difference between dashboard & Report
      • • How to ask Questions as a data analyst?
      • • Statistics for data analyst
      • • Data Cleaning by Power Query
      • • Reshape Complex Data by Power Query
      • • Working with many to many relationships and Star schema
      • Project#5 – create HR dashboard
      • • Working with advanced DAX Functions
        •        • Time Intelligence functions
        •        • Aggregation Functions
        •        • Filter Functions
        •        • Relationships Functions
        •        • Logical Functions
        •        • Other useful functions
      • • Project#6 – create Sales dashboard
      • • Working with Power BI Service
        •        • Publish Reports
        •        • Create & Manage Workspace
      • • Create & work with Parameters
      • • Quick Review about all Topics
      • • Project#7 – create marketing dashboard
      • Capstone Project

Overview
Access Controls
Home Page
Create Dashboard
Project#8 – create dashboard Using Google Data Studio

  • • Overview
  • • Building and Customizing Visualizations
  • • Analytics
  • • Collect many Reports
  • Project#9 – Creating dashboard Using Tableau

• Tables, Columns and Data types.
• How to design a database.
• One-To-Many & Many-To-Many Relationships.
• MySQL Workbench.
• ACTIVITY DESIGN DATABASE STRUCTURE LIKE FACEBOOK, TALABAT, YOUTUBE.
• PROJECT #10 DESIGN E-COMMERCE DATABASE.
• SQL.
• CRUD.
• Selecting data.
• Filtering data.
• Ordering data.
• Limiting data.
• Aggregate Functions.
• Joining tables.
• Grouping data.
• Dealing with date and time SQL.
• Subqueries.
• Window Functions.
• Inserting new data.
• Updating data.
• Deleting data.
• Python and MySQL.

• DATA ANALYSIS CAPSTONE PROJECT DISCUSSION.

• This program is comprised of many career-oriented projects. Each project you build will be an opportunity to demonstrate what you’ve learned. Your completed projects will become part of a career portfolio that will demonstrate to potential employers that you have skills in data analysis.

• One of our main goals at EAII is to help you create a job-ready portfolio of completed projects. Building a project is one of the best ways to test the skills you’ve acquired and to demonstrate your newfound abilities to future employers or colleagues. Throughout this program, you’ll have the opportunity to prove your skills by building the following projects.

  • Project 1: Create, and Design Table then make conditional format, make custom sort
    and use Data analysis Icon to get Statistics Values using Excel
  • Project 2: Create Sales Report Using Functions using Excel
  • Project 3: Create Sales Report using Excel
  • Project 4: Import Data to power Pivot and Power Query then create Marketing Report using Excel
  • Project 5: Create HR dashboard using Power BI
  • Project 6: Create Sales dashboard using Power BI
  • Project 7: Create marketing dashboard using Power BI
  • Project 8: Create dashboard using google data studio
  • Project 9: Creating dashboard Using Tableau
  • Project #10 (Design E-commerce Database)
  • Capstone Project

CPDAP.PY Curriculum:

Certified Python Data Analyst Professional – CPDAP.PY

Python / Data collection (web scraping) / MySQL / EDA (Numpy / Pandas) / Data visualization (Dash / Plotly) / Data Pre-Processing

Duration: 128 Hours

Delivery Method: Online Live Only

Price Before Discount: 12,000.00 EGP 

Price After 43% Discount : 5,900.00 EGP 

• Introduction to Data Analysis, Machine Learning, Data Science.
• Introduction to AI, Computer Vision, Autonomous and NLP.
• Data Science Process Activities.
• Data Different jobs (Data Engineer – Data Analyst – Data scientist – ML engineer – MLOps Engineer) .
• Roadmap for Data Science and AI.

• Environment Setup (Anaconda).
• Virtual Environments Concept.
• Command Line.
• Conda & pip package managers.
• Jupyter Notebook.
• Why python for data science.
• Intro to python.
    o Input & Output.
    o Variables.
    o Data types.
            • Numbers & Math.
            • Boolean & Comparison & Bitwise. and Logic.
            • Strings – Strings Methods.
    o If Conditions.
    o For & While Loops.
    o Lists.
    o Tuples.
    o Sets.
    o Dictionaries.
    o List Comprehensions.
    o Dictionary Comprehensions.
• Exceptions.
• File Handling.
• Functions.
• Built-in functions &  Operators (zip, enumerate, range, …).
• Map, Filter, Reduce.
• Lambda Expressions.
• PROJECT #1 ROCK PAPER SCISSORS.
• PROJECT #2 HANG MAN.
• Modules & Packages
• Git & GitHub (Version Control).
• GitKraken.
• PROJECT #3 PY.
• Object-Oriented Programming (OOP)
    o Classes & Objects.
    o Data Hiding and Encapsulation.
    o Inheritance. 
    o PROJECT #4 LIBRARY SYSTEM USING OOP.
    o PROJECT #5 BANK SYSTEM USING OOP.

• Public datasets websites.
• Network Topologies.
• Internet and Web Servers.
• HTTP Request/Response Cycle.
• Web Services & JSON.
• Intro to HTML and CSS – Online Playlist.
• Scrapping Concept.
• Download Files.
• Beautiful Soap Library.
• PROJECT #6 WUZZUF JOBS DATA COLLECTING USING WEB SERVICES.
• PROJECT #7 DIWAN BOOKS DATA COLLECTING SYSTEM.

• Tables, Columns and Data types.
• How to design a database.
• One-To-Many & Many-To-Many Relationships.
• MySQL Workbench.
• ACTIVITY DESIGN DATABASE STRUCTURE LIKE FACEBOOK, TALABAT, YOUTUBE.
• PROJECT #8 DESIGN E-COMMERCE DATABASE.
• SQL.
• CRUD.
• Selecting data.
• Filtering data.
• Ordering data.
• Limiting data.
• Aggregate Functions.
• Joining tables.
• Grouping data.
• Dealing with date and time SQL.
• Subqueries.
• Window Functions.
• Inserting new data.
• Updating data.
• Deleting data.
• Python and MySQL.
• PROJECT #9 ECOMMERCE SYSTEM DATABASE ANALYSIS.
• PROJECT #10 LYNDA COURSES DATABASE ANALYSIS.

• Liner Algebra.
    o Vector’s operations.
    o Matrix operations.
    o Victor Norm.
    o Eigen Values, Eigen Vectors and Eigen. decomposition.
• Statistics.
    o Understanding data.
    o Central Tendency.
    o Measures of Dispersions.
    o Correlation.
    o Normal Distributions.
    o Standard Normal Distributions.
    o Sample Distribution.
    o Central Limit Theorem.
    o Confidence Interval.
    o Statistical Significance.
    o Hypothesis Testing.
    o A/B Testing.
• Probability.
• Calculus.
    o Rate of Change.
    o First order and second order derivatives.
    o Partial Derivatives.
    o Chain rule.

• EDA Process.
• Linear Algebra.
    o Vector’s operations.
    o Matrix operations.
    o Victor Norm.
• NumPy.
    o Create NumPy Array
    Indexing.
    o Arithmetic and Logic.
    o Universal Array Functions.
• Statistics.
    o Understanding data.
    o Central Tendency.
    o Measures of Dispersions.
    o Correlation.
    o Normal Distributions.
    o Standard Normal Distributions.
    o Sample Distribution.
    o Central Limit Theorem
    o Confidence Interval.
    o Statistical Significance.
    o Hypothesis Testing.
    o A/B Testing.
• Pandas.
    o Series.
    o Data Frames.
    o Data Input & Output.
    o Useful Methods.
    o Apply function.
    o Grouping data and aggregate functions.
    o Merging, Joining and Concatenating.
    o Pivoting.
• PROJECT #11 MOVIES DATASET FROM KAGGLE.
• PROJECT #12 SHOPPING CART DATASET FROM KAGGLE.
• PROJECT #13 FIFA DATASET FROM KAGGLE.

• Plotly.
    o Distribution Plots.
    o Categorical Plots.
    o Matrix Plots.
• Dash.
    o Customize plots (colors, markers, line styles, Limits, Legends, Layouts.
    o Text and Annotations.
• PROJECT #11 MOVIES DATASET FROM KAGGLE CONT.
• PROJECT #12 SHOPPING CART DATASET FROM KAGGLE CONT.
• PROJECT #13 FIFA DATASET FROM KAGGLE CONT.

• Feature Engineering and Extraction.
    o Domain knowledge features.
    o Date and Time features.
    o String operations.
    o Web Data.
    o Geospatial features.
• Feature Transformations.
    o Data Cleaning and Cleansing.
    o Work with Duplicated data.
    o Detect and Handle Outliers.
    o Work with Missing data.
    o Work with Categorical data.
    o Deal with Imbalanced classes.
    o Split data to Train and Test Sets.
    o Feature Scaling.
    o Data Preprocessing Mind Map.
    o PROJECT #14 GOOGLE PLAY STORE.
• PROJECT #15 DATA ANALYST JOBS ANALYSIS.
• PROJECT #16 UBER ANALYSIS.
• PROJECT #17 SALES PRODUCT DATA ANALYSIS.

• DATA ANALYSIS CAPSTONE PROJECT DISCUSSION.

• This program is comprised of many career-oriented projects. Each project you build will be an opportunity to demonstrate what you’ve learned. Your completed projects will become part of a career portfolio that will demonstrate to potential employers that you have skills in data analysis and feature engineering, machine learning algorithms, and training and evaluating models.

• One of our main goals at EAII is to help you create a job-ready portfolio of completed projects. Building a project is one of the best ways to test the skills you’ve acquired and to demonstrate your newfound abilities to future employers or colleagues. Throughout this program, you’ll have the opportunity to prove your skills by building the following projects.

  • Project 1:  Rock paper scissors
  • Project 2:  Hung man.
  • Project 3:  Thanos
  • Project 4:  Library System using OOP.
  • Project 5:  Bank System using OOP.
  • Project 6Wuzzuf Jobs data collecting using web services.
  • Project 7:  Diwan Books data collecting system.
  • Project 8:  Design E-commerce Database.
  • Project 9:  Ecommerce system database analysis
  • Project 10: Lynda Courses database analysis
  • Project 11: Movies dataset from Kaggle
  • Project 12: Shopping cart dataset from Kaggle
  • Project 13: FIFA dataset from Kaggle
  • Project 14: Google Play Store
  • Project 15: Data Analyst Jobs Analysis
  • Project 16: Uber Analysis
  • Project 17: Netflix data Analysis
  • Capstone Project

Certificate

Upon successful completion of the Program, participants will receive a verified digital certificate from EPSILON AI, Delaware, USA. if they attend a minimum of 85 percent of the direct contact hours of the Program and after fulfilling program requirements 
(passing both Final Exam and Project to obtain the Certificate)

• Familiar with the basic math and statistics concepts – Optional

• You will gain an advanced level of awareness on the types of data, the role of a data Analyst
• You will learn how to use advanced Excel Statistical functions
• You will learn how to Transform Data into INSIGHT and INTELLIGENCE using powerful methods of analysis, techniques, and tools
• You will learn how to gather, transform, model, and visualize data with Power BI and Google data studio
• You will Learn best practices for data analysis and data presentation
• You will Learn to ask the RIGHT questions of your data using comparison, trend, ranking, variance, and many other technique
• You will Learn best practices for the design and setup of interactive dashboards
• You will feel confident in implementing Excel, Power BI, and Google Data studio data solutions to your organizations.
• You will learn how to Build a dashboard using excel, power bi and google data studio

• Perform feature engineering
• demonstrate an understanding of fundamental principles of data analytics systems and technologies.
• Able to use standard techniques of mathematics, probability, and statistics to address problems typical of a career in data analysis
• Use statistical software packages such Python to solve data analysis problems.
• Communicate results effectively to stakeholders.
• Send and receive requests from deployed machine learning models.
• Transition from the Very Basics to a Point Where You Can Effortlessly Work with Large SQL Queries
• Web Scraping using Python, scrape data and store it locally or globally to access the data sets whenever needed.
• identifying opportunities for data analysis across many functional areas of the business

• This Program is primarily for individuals who are passionate about the field of data analysts and who are aspiring to apply Data Analysis in their business, industry, or research.

• Developers and Software Engineers

• Analytics Managers and Professionals

• Statisticians with an interest in Data Analysis

• Business Owners

• Accountants

• Data enthusiastic

 

Payment must be made prior to Program commencement at Epsilon AI Institute, HQs
• In-Person
       o In Cash to our address:
            • Elserag shopping mall, Residential Building 1, Entrance 1, Floor 11
            • Alfouad administrative Tower, Building 22, Floor 2, Anas ebn malek str., Shehab Str., Mohandessin, Cairo, Egypt

      o By cheque – Payable to: Epsilon ابسلون للتدريب
      o Credit Card
• Bank transfer to our ACC in (Excluding Bank Transfer Fees):
      o QNB ALAHLI Acc /20318280579-69 EGP Branch code / 00078
• Vodafone Cash to 01011933233
• Credit Card online
• Cash Collection from Client’s Premises
• Masary/Aman Service
• Fawry Service
• Wallet Transfer
• Banks Credit Card Installments (up to 36 months)
• VALU Installments (up to 36 months)
• Credit Card Bank installments

Learn with Data Analysis Industry leaders and Knowledgable instructors.

Instructors with more than +7 years of experience in the labor market.

Registration

Copyright © 2023 Epsilon AI Registered in Egypt with company no. 118268