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: Create an Excel report
  • Project 2: Create an Excel data model and connect to external data
  • Project 3: Analyzing Data with Self-Service BI
  • Project 4: Visualizing Data with Power BI
  • Project 5: Analyzing Data with Tableau
  • Project 6: Visualizing Data with 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 on 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: 4 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

  • Create an Excel report
  • Create an Excel table
  • Create a pivot table and pivot chart
  • Create a dashboard and analyze data
  • Create Hierarchies
  • Create an Excel data model and connect to external data
  • Working with Power Query
  • Working with Power Pivot

 

2. Data analysis using Power BI

  • Analyzing Data with Self-Service BI
    • Data Analysis and Visualization for Business Intelligence
    • Self-Service BI with Microsoft Power BI
  • Connecting to Data
    • Create Data Connections
    • Model Data with Relationships
    • Save Power BI Files
  • Performing Advanced Data Modeling and Shaping
    • Clean and Transform Data with the Query Editor
    • Shape Data with the Query Editor
    • Combine and Manage Data Rows
  • Visualizing Data with Power BI
    • Create Visualizations in Power BI
    • Chart Data in Power BI
  • Enhancing Data Analysis
    • Enhance Analysis with Customized Visuals and Pages
    • Enhance Analysis with Tooltips
    • Enhance Analysis with AI Tools
  • Modeling Data with Calculations
    • Create Calculations with Data Analysis Expressions (DAX)
    • Create Calculated Measures and Conditional Columns
    • Working with Parameters
    • Working with Variables
    • Working with M Language
  • Creating Interactive Visualizations
    • Create and Manage Data Hierarchies
    • Filter and Slice Reports
    • Create KPI's
    • Create Dashboards in Power BI

3. Data analysis using Tableau

  • Data Connections
    • Getting to data from Tableau Desktop
    • Learning the basics of visualizing data
    • Visualizing business needs
  • Transforming Data
    • Why transforms data?
    • Data Blends
    • Data Joins
  • Calculations in Tableau
    • Data Aggregates
    • Calculation Wizards
    • Table Calculations
    • Logical Calculation
    • Customized Calculations
  • Advanced Calculations
    • Strings
    • Floor and Ceiling
    • Dates
    • IF then else
    • case
  • Parameters and Filters
    • Basics of Filtering
    • Basics of Parameters
    • Putting it all together
  • Sorting
    • Ascending and Descending Order manually
    • Computes and Sorting
    • Nested Sorting
  • Grouping Techniques
    • Sets
    • Groups
    • Combining Fields
  • Formatting
    • Colors
    • Custom Colors
    • Highlighters
    • Conditional Format
  • Map Basics
    • Layers
    • Editing
    • Customizing
  • Visualizations
    • Understanding Charts
    • Text Charts
    • Visual Charts
    • Time Charts
    • Trend Charts
  • Analytics
    • Constant Line
    • Reference line
    • Average line
    • Standard Deviation
    • Percentiles
    • Quantiles
    • Distribution Band
  • Collect many Reports.
    • Create Story
    • Create Standard Dashboards
    • Create Interactive Dashboard

 

4.CAPSTONE PROJECT

 

 

Download Certified Data Analyst Associate- CDAA Brochure PDF

     

    Course Curriculum

    No curriculum found !

    Download Brochure

    Drop Us A Query

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