• 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

• Constantly being updated with new content and covering more areas of business data analysis.
• Be more productive and creative in their use of Microsoft Excel and Power BI for business and reporting
• Become proficient in using PivotTables for analyzing a large data
• Become proficient in the use of VLOOKUP, HLOOK, LOOKUP to get last item, INDEX and MATCH to make automated dynamic dashboards/reports.
• Learn how to use Sorting in more advanced ways: multi-level sorting, sorting left to right.
• Learn how to create professional and great looking charts in Excel and understand when to use a particular chart type.
• Learn creative uses of Excel and a lot of keyboard shortcuts that saves analysis time
• Be introduced to Excel VBA, shown how to create a macro by clicking a particular button twice.
• Make a sample Excel VBA user form that gets data from user and input into a table in Excel
• Learn Power BI and other new interesting business data analysis tools by Microsoft

• 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.

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

BTS attendance certificate will be issued to all attendees completing a minimum of 80% of the total course duration.