• 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

• 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

• 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

This interactive Training will be highly interactive, with opportunities to advance your opinions and
ideas and will include;
• Lectures
• Workshop & Work Presentation
• Case Studies and Practical Exercise
• Videos and General Discussions

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

CDGA attendance certificate will be issued to all attendees completing minimum of 75% of the total
course duration.