Home Calendar Data Analysis using Excel & Power BI

Next Occurrence

QR Code


Jul 28 2024 - Sep 01 2024


8:00 am - 6:00 pm

Data Analysis using Excel & Power BI

Program Overview

Data Analysis is the process of modeling and transforming data into useful information, this information helps us to make a clear, uniform, and right decisions, but how can we do it with so much data?
This is the importance of data software In Data Analysis Diploma we will focus on 2 of the best data analysis software:

  1. Microsoft Excel
  2. Microsoft Power BI

This course is a combination of The Concept of Data Visualizations and Technical Skills to build a career future in one of the most important fields worldwide; where the most of global and innovative companies are utilizing data analysis to help making data-driven decisions using Business Intelligent Solutions

Program Content

Part 1: Data Analysis

Module 1: Data Analysis in Excel

  • Lesson 1: Classic Data Analysis with Excel
  • Lesson 2: Excel Pivot Tables
  • Lesson 3: Limitations of Classic Data Analysis
  • Lab: Building a Classic Excel Dashboard

Module 2: The Excel Data Model

  • Lesson 1: Using an Excel Data Model
  • Lesson 2: DAX
  • Lab 2: Explore an Excel Data Model

Module 3: Importing Data from Files

  • Lesson 1: Importing Data into Excel
  • Lesson 2: Shaping and Transforming Data
  • Lesson 3: Loading Data
  • Lab 3: Importing Data from a CSV File

Module 4: Importing Data from Databases

  • Lesson 1: Available Data Sources
  • Lesson 2: Previewing, Shaping, and Transforming Data
  • Lesson 3: Table Relationships and Hierarchies
  • Lesson 4: Loading Data
  • Lab 4: Import Data from Multiple Sources

Module 5: Importing Data from Excel Reports

  • Lesson 1: Importing Data from Excel Reports
  • Lesson 2: Transforming Excel report Data
  • Lab 5: Importing Data from a Report

Module 6: Creating and Formatting Measures

  • Lesson 1: DAX
  • Lesson 2: Measures
  • Lesson 3: Advanced DAX Functions
  • Lab 6: Creating Measures using Advanced DAX Functions

Module 7: Visualizing Data in Excel

  • Lesson 1: Pivot Charts
  • Lesson 2: Cube Functions
  • Lesson 3: Charts for Cube Functions
  • Lab 7: Data Visualization in Excel

Part 2: Power BI

Getting Started with Power BI Desktop

  • Power BI Concepts and Overview
  • Introduction to Main Features
  • Imports
  • Visualizations
  • Filters and Queries
  • Reports

Connecting to Data Sources with Power BI Desktop

  • Data Sources Power BI Desktop will connect to
  • Data Types and Properties in Power BI Desktop
  • Import and Enter Data
  • Get Data and Query Editor
  • Introducing the Query Editor
  • Using the Query Editor to Connect to Data
  • Combining Data Sources as a Mash Up
  • Working with Relationships in Data

Data Visualizations

  • Overview of Data Visualizations
  • Tables and Matrix Views
  • Applying Conditional Formats
  • Charts
  • Interactive Data and Date Slicers
  • Drill Visualizations to see underlying data
  • Create Reusable Field Hierarchies
  • Record Grouping and Binning in Visualizations
  • Drill Visualizations with using Dates
  • Clustering
  • Analytics and Forecast Lines in Visualizations
  • Creating Role Based Views
  • Data Categories, Geo-Data and Maps

Querying and Shaping the Data

  • Common Activities using Query Editor
  • Filters
  • Transforms
  • Pivot and Group By
  • Creating Custom Calculated Columns
  • Adding Conditional Columns
  • Introduction to DAX Expressions
  • Histograms

Power Pivot and Data Model

  • Relationship
  • Common DAX Functions
  • Concept of Measures
  • Calculated Columns

Reports and Output Options

  • Report Elements and Options
  • Working with Pages
  • Adding Graphics
  • Visual and Filter Settings
  • Export Power BI Data to CSV
  • Create a Power BI Template

Program Benefits

Upon completing the diploma, you will:

  • Differentiate yourself as Data Analyst Using Excel & Power BI
  • Be Prepared with solid jumpstarting to became Data Scientist
  • Understand the Concept of Data Analysis & Visualization
  • Understand the Data Analysis Process
  • Data Analyst Competencies and Roadmap
  • Connect, Transform, and Load Data Using Power Query
  • Enhance Data Modeling
  • Build Data Analysis Expression [DAX] in Excel
  • Mastering Data Visualizing in Excel & Creating Dynamics Dashboard
  • Understand the Concept of Business Intelligent Solutions
  • Connect, Transform, and Load Data Using Power BI
  • Working with DAX and Advanced DAX Measures
  • Mastering Data Visualizing & Data Driven decisions Using Power BI
  • Act as a data-driven visual storyteller for optimal presentation
  • Apply data visualization best practices, including choosing the right chart type for the situation

Who Should Attend

  • Professionals who wish to gain an understanding of the benefits and uses of data analysis and the techniques applied using Excel and Power BI when analyzing business data, to improve their analytical skills and understanding of data.
  • For Business Professionals, business analysts, data analysts, finance professionals, marketing and sales professionals, HR professionals, IT professionals, administrative staff, supervisors, general business professionals and staff from any function who need to learn and apply data analysis techniques to their daily business reporting and decision making.
  • For Professionals want to jumpstart to Data Analysis Career and gain the Knowledge and Practical Skills of Data Analysis Using Excel & Power BI.

Course Duration

40 Hours

Course Method


Registration Deadline

Three days before the course date.

Registration and Payment

  • Open www.thetraining-hub.com/ Training Facilities/Course Registration and fill your registration form.
  • Payment by cheque in The Training HUB’s name, cash to our address or by bank transfer.
  • Your registration is confirmed only after course payment
  • Payment is non-refundable; however, participant can be substituted or can attend next confirmed round of the same course or another course.

For More Information

Phone: 02 22907369 / 22909369

Mobile: 01280720167- 01280653407

Email: info@thetraining-hub.com


Leave a Comment

Need Help? Chat with us