fbpx

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 it to external data

 

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
  • Modeling Data with Calculations
    • Create Calculations with Data Analysis Expressions (DAX)
    • Create Calculated Measures and Conditional Columns
  • Creating Interactive Visualizations
    • Create and Manage Data Hierarchies
    • Filter and Slice Reports
    • 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
    • Customized Calculations
  • Advanced Calculations
    • Strings
    • Floor and Ceiling
    • Dates
  • 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
    • Combining Fields
  • Formatting
    • Colors
    • Custom Colors
    • Highlighters
  • Map Basics
    • Layers
    • Editing
    • Customizing
  • Visualizations
    • Understanding Charts
    • Text Charts
    • Visual Charts
    • Time Charts
    • Trend Charts

 

4.CAPSTONE PROJECT

 

Download Certified Data Analyst Associate – CDAA Brochure PDF

     

     

     

     

     

     

     

     

    Course Curriculum

    No curriculum found !

    Drop Us A Query

       

       

       

       

       

       

       

       

       

       

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