fbpx
Successful Data Analysts have a unique set of skills, and represent important value to organizations eager to make data-powered business decisions, uncover insights, communicate critical findings, and create data-driven solutions.

EXCEL – POWER BI – TABLEAU

 

Prerequisites:

  • NONE

 

Training Program Description:

  • This Training Program is an introduction level to business and data analytics. The aim is to address several competencies, Data awareness, statistical applications in excel, business intelligence software, and machine learning awareness.
  • By the end of this Training Program, you should feel comfortable Implementing business intelligence solutions to your organization using tools such as Excel or Power BI or Tableau that improve the current reporting system and add greater depth to the information to aid in the business decision making process.

Projects

  • This program is comprised of many career-oriented projects. Each project you build will be an opportunity to demonstrate what you’ve learned in the lessons. 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

 

  • Building a project is one of the best ways both to test the skills you’ve acquired and to demonstrate your newfound abilities to future employers. Throughout this program, you’ll have the opportunity to prove your skills by building the following projects:

 

  • Project 1: Creating Salary Table contains ID, employees names, titles, address, birth date, hire date and salary using EXCEL
  • Project 2: Add (bonus, overtime, tax, insurance) to Salary Table and calculate the net salary using EXCEL
  • Project 3: Creating a dashboard for the Salary table using EXCEL
  • Project 4: Connect to employee excel file and transform the data to best shapes using Power BI
  • Project 5: Add some fields to the employee excel file and create some visuals Using Power BI
  • Project 6: Creating filters for Salary table, creating measures for salary data, aerating computed column for salary data Using Power BI
  • Project 7: Creating a dashboard for Salary table using Power BI
  • Project 8: Connect to Salary table and make some calculations using Tableau
  • Project 9: Working with salary data Using Tableau
  • Project 10: Creating a dashboard for Salary table Using Tableau
  • Capstone Project

 

program outcomes:

  • 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 gather, transform, model, and visualize data with Power BI and Tableau
  • You will gain an advanced level of awareness of the types of machine learning and how it works
  • You will feel confident in implementing Excel, Power BI, and Tableau data solutions to your organizations

 

Program Duration: 5 Weeks

Program Language: English / Arabic

Location: EPSILON AI INSTITUTE | Head Office

Participants will be granted a completion certificate from Epsilon AI Institute, USA if they attend a minimum of 80 percent of the direct contact hours of the Program and after fulfilling program requirements (passing both Final Exam and Project to obtain the Certificate)

 

CURRICULUM

Training Program Curriculum

 

1. Data analysis using Excel

    • Excel Basics
    • Create an Excel table
    • Condition Formats
    • Sort and Filter
      • Project 1: Creating Salary Table contains ID, employees names, titles, address, birth date, hire date and salary
    • Using Formulas
    • Create an Excel report
      • Project 2: Add (bonus, overtime, tax, insurance) to Salary Table and calculate the net salary
    • Create a pivot table and pivot chart
    • Create a dashboard and analyze data
    • Create an Excel data model and connect it to external data
    • Working with Power Query
    • Working with Power Pivot
      • Project 3: Creating dashboard for Salary table

 

2. Data analysis using Power BI

    • Power Bi Introductions
    • Data source types
    • Connecting to data source
    • Connecting to more than date source
    • Edit Query with power query
    • Transforming data with power query
      • Project 4: Connect to employee excel file and transform the data to best shapes
    • Add fields to query in power query
    • Using M language to assign values in new filed
    • Assign parameter and use it to retrieve data
    • Report page
    • Format report
    • Add elements to your report
    • Add Visualize to your report
    • Select the best visual for selected data
    • Create and Visual Hierarchy Fields
    • Format visual
      • Project 5: Add some fields to the employee excel file and create some visuals Using Power BI
    • Visual analytics
    • Filter visuals
    • Filter reports
    • Work with AI elements
    • Introduction to DAX
    • Creating new measures
    • Creating Calculated Column
      • Project 6: Creating filters for Salary table, creating measures for salary data, aerating computed column for salary data
    • Performing Data Modeling
    • Understanding for relations and type of relations
    • Join data from more than table
    • Create join visual
    • Connect to Power bi Service
    • Create environment
      • Project 7: Creating a dashboard for Salary table

 

3. Data analysis using Tableau.

    • Data Connections
    • Transforming Data
    • Calculations in Tableau
    • Advanced Calculations
      • Project 8: Connect to Salary table and make some calculation
    • Parameters and Filters
    • Sorting
    • Grouping Techniques
    • Formatting
    • Map Basics
      • Project 9: Working with salary data
    • Visualizations
    • Analytics
    • Collect many Reports
      • Project 10: Creating a dashboard for Salary table Using Tableau

 

4. CAPSTONE PROJECT

 

 

 

Course Curriculum

No curriculum found !

Download Brochure

Download Certified Data Analyst Professional- CDAP Brochure PDF

    Drop Us A Query

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