• Home
  • Training
    • Finance
      • Managerial Accounting
      • Financial Accounting
      • Tax Accounting
      • Treasury
      • Auditing
    • People & Culture
    • Supply Chain
    • Management
    • Marketing
    • Cyber Security
    • Data-Science
    • Corporate Training
    • Consultation
      • Simflex Business Simulation
      • Development Centers
    QAC | Qualified Accounting Certificate

    QAC | Qualified Accounting Certificate

    Free
    Read More
    PD 02:  SCM Supply Chain Management Course [ CILT International Diploma]

    PD 02: SCM Supply Chain Management Course [ CILT International Diploma]

    Free
    Read More
  • Corporate
  • About Us
  • Blog
  • Careers
  • Contact
High Performance AcademyHigh Performance Academy
  • Home
  • Training
    • Finance
      • Managerial Accounting
      • Financial Accounting
      • Tax Accounting
      • Treasury
      • Auditing
    • People & Culture
    • Supply Chain
    • Management
    • Marketing
    • Cyber Security
    • Data-Science
    • Corporate Training
    • Consultation
      • Simflex Business Simulation
      • Development Centers
    QAC | Qualified Accounting Certificate

    QAC | Qualified Accounting Certificate

    Free
    Read More
    PD 02:  SCM Supply Chain Management Course [ CILT International Diploma]

    PD 02: SCM Supply Chain Management Course [ CILT International Diploma]

    Free
    Read More
  • Corporate
  • About Us
  • Blog
  • Careers
  • Contact

Business Technology

  • Home
  • All courses
  • Business Technology
  • Data Analysis Course

Data Analysis Course

Virtual | On Class
Business Technology, Data Science
Free
Data Analysis Course – HPA
  • Overview

Data Analysis Course

What is Data Analysis Course ?

In the modern world, making informed decisions requires data and analysis.
The Data Analysis Course will teach you how to analyze data in a way that will enable you to make the best choice possible at the right time.
Organizations can use data analysis to understand where they stand in the market in comparison to competitors.
It is what enables us to recognize possible risks that must be averted and chances that must be seized in order to advance.

Why this Course?

The importance of data analysis is rising in today’s data-driven community.
Organizations in various industries are collecting vast amounts of data, and they need skilled professionals who can analyze and interpret this data to make informed business decisions, this is why the Data Analysis Course should be taken.

Course Outline

Introduction to Data Analysis

  • Intro to data analysis
  • Data Analysis and Analytics
  • Data Analysis and Statistics
  • data analysis and making decisions
  • Data Analysis Process

Data collection and validation

  • Principles of data collection
  • Data collection techniques
  • Data validation process
  • Data Cleaning

Shaping and Modeling data

  • Shape power BI data
  • Create relationships
  • Calculations and measures

Analyzing Data with Excel

  • Introduction to data analysis with Excel
  • Importing Data into Excel
  • Shaping and Transforming Data
  • Table Relationships and Hierarchies
  • Excel Pivot Tables
  • Excel Data Modeling
  • Advanced DAX Functions
  • Creating Measures by Using DAX Functions
  • Visualizing Data in Excel

Analyzing Data with Power BI

  • Introduction to business intelligence
  • Exploring power BI
  • Import Data from Multiple Sources
  • Creating a Power BI report
  • Creating a Power BI dashboard
  • Connecting to Power BI data
  • Create a Power BI dashboard
  • Importing Excel files into Power BI
  • Viewing reports from Excel files
  • Power BI Mobile

Data visualization and dashboards (projects)

  • Intro to data visualization
  • Visualization Tools
  • Visualization and dashboards
  • Advanced Excel dashboards
  • Advanced BI dashboards
What You Will Learn?

After the Data Analysis Course completion; participants will be able to:   

  • Work with different forms of complex data.
  • Use Microsoft Excel to analyze data successfully.
  • Take a look at tools and methods for analysis and visualization.
  • Become familiar with Excel and Power BI’s data analysis processes.
  • Preparing and cleaning data for analysis.
  • Understand the BI Project Lifecycle.
  • Use Excel to create a Power BI dashboard.
  • Utilize tools to find solutions to your questions.
  • Create powerful visualizations and distribution dashboards
  • Utilize the Power BI Mobile app.
Target Audience
  • Users of advanced excel.
  • Professionals in related fields; market research, finance, marketing, or any other field that involves data analysis or decision-making based on data.

Course Features

  • Lectures 0
  • Quizzes 0
  • Duration 36 hours
  • Language ENG/AR
  • Students 0
  • Assessments Yes
  • Overview
Free
  • Share:

You May Like

PD 02:  SCM Supply Chain Management Course [ CILT International Diploma] Read More
HPA Learning

PD 02: SCM Supply Chain Management Course [ CILT International Diploma]

0
Free
PD 01: Management in Logistics and Transport [ CILT International Diploma ] Read More
Virtual | On Class

PD 01: Management in Logistics and Transport [ CILT International Diploma ]

0
Free
Thomas International Certification – PPA Assessment Read More
Virtual | On Class

Thomas International Certification - PPA Assessment

0
Free
ADIT Diploma Paper 1 Read More
HPA Learning

ADIT Diploma Paper 1

0
Free
LSSGB Certification | Lean Six Sigma Green Belt Read More
Virtual | On Class

LSSGB Certification | Lean Six Sigma Green Belt

0
Free

Install 6 months with 0% interest

SiteLock
CONNECT US

 (+202) 26903875 – 24182790

 01050222191 – 01050222192

 info@hpa.com.eg

Our Location

 Egypt  8 Mohamed Anies St. Kolyet El Banat, El Mergheny, Heliopolis, Cairo, Egypt

 KSA  2512 king Abdul-Aziz RD, Almasiaf Plaza, Riyadh

High Performance Academy © 2023
one of HPA Group

Modal title

Message modal