Comprehensive Data Analysis with Excel, Power BI & SQL

Target Audience

Aspiring data analysts, business professionals, and students seeking practical skills in data analysis and reporting.

1. Course Overview

This comprehensive course equips learners with practical skills in data cleaning, analysis, and visualization using Microsoft Excel, SQL, and Power BI. Designed for beginners and aspiring data professionals, the course follows a structured path—from foundational data handling in Excel, through SQL querying for data extraction, to building interactive dashboards. Whether you’re aiming to upgrade your analytical skills or pursue a career in data analysis, this course provides the tools and hands-on experience needed to succeed. This program also prepares participants for the Microsoft PL-300: Power BI Data Analyst certification exam, giving you both practical skills and certification readiness.

2. Course Outcomes

By the end of this course, participants will be able to:

• Clean, prepare, and analyze data using Microsoft Excel
• Create charts and dashboards to visualize trends and insights
• Write SQL queries to extract and manipulate data from relational databases
• Build interactive reports and dashboards using Power BI
• Apply for data analyst roles with confidence and a portfolio-ready project
• Prepare for the PL-300: Microsoft Power BI Data Analyst certification exam

3. Course Requirements

No prior experience in data analysis is required, but participants should have:

• Basic computer literacy
• Familiarity with spreadsheets (helpful, but not mandatory)
• A PC or laptop with:
  • Microsoft Excel (preferably 2016 or later)
  • Power BI Desktop (free download)
  • Stable internet connection (for SQL practice and course content access)

4. Job Opportunities

Upon completing this course, learners will be well-positioned for roles such as:

• Data Analyst
• Business Intelligence Analyst
• Excel Data Specialist
• Reporting Analyst
• Junior Data Engineer
• Power BI Developer
• Data Entry and Visualization Assistant

These roles are in demand across industries such as finance, marketing, healthcare, education, and e-commerce.

5. Course Duration

Total Duration: 6–8 weeks (depending on part-time or full-time learning pace)

• Excel Module: 3-4 weeks
• SQL Module: 1 week
• Power BI Module: 3 weeks
• Final Project & Assessment: 1–2 weeks

Includes a mix of video tutorials, hands-on practice, assignments, and assessments.

Course Content

Module 1: Introduction to Data Analysis

• What is Data Analysis?
• Types of Data and Analytical Techniques
• Overview of Tools: Excel, Power BI, SQL
• The Data Analysis Workflow

Module 2: Microsoft Excel for Data Analysis

2.1 Data Cleaning with Excel

• Importing Data from Different Sources (CSV, Web, Excel Files)
• Removing Duplicates & Handling Missing Values
• Using Text Functions (TRIM, LEFT, RIGHT, MID, FIND)
• Data Validation Techniques
• Flash Fill & Power Query Basics

2.2 Data Analysis in Excel

• Using Formulas and Functions (IF, VLOOKUP, INDEX/MATCH, etc.)
• Conditional Formatting for Data Insights
• Pivot Tables for Summarizing Data
• Descriptive Statistics with Excel (AVERAGE, STDEV, COUNTIF, etc.)

2.3 Data Visualization in Excel

• Creating Charts: Column, Line, Pie, Combo
• Dynamic Dashboards with Slicers and PivotCharts
• Best Practices for Effective Visualization

Module 3: SQL for Data Extraction

3.1 Introduction to Databases and SQL

• What is a Relational Database?
• Tables, Rows, and Columns

3.2 Writing Basic SQL Queries

• SELECT, WHERE, ORDER BY, LIMIT
• Filtering with AND, OR, NOT
• Aliases and Wildcards

3.3 Intermediate SQL

• JOINs (INNER, LEFT, RIGHT, FULL)
• GROUP BY and Aggregates (SUM, AVG, COUNT)
• Subqueries and Nested Queries
• Using CASE Statements

3.4 Working with Real-World Data

• Practice on Sample Business Database (e.g., Sales, Customers)
• Writing Queries for Reports and Dashboards

Module 4: Power BI for Data Visualization & Reporting

(Based on Microsoft PL-300: Power BI Data Analyst Certification)

4.1 Getting Started with Power BI

• Power BI Desktop Overview
• Connecting to Data Sources
• Data Transformation with Power Query

4.2 Modeling Data

• Creating Relationships
• Data Types and Hierarchies
• Using DAX Basics (Calculated Columns & Measures)

4.3 Visualizing Data

• Creating Reports and Dashboards
• Using Different Visuals: Bar, Line, Map, Card, Gauge, etc.
• Slicers, Filters, and Tooltips
• Designing User-Friendly Layouts

4.4 Publishing & Sharing

• Power BI Service Overview
• Publishing Reports to PowerBI.com
• Creating Dashboards in Power BI Service
• Scheduling Data Refresh

4.5 PL-300 Exam Readiness

• Overview of Exam Objectives
• Sample Exam Questions
• Tips for Passing the PL-300 Certification

Final Project & Assessment

• End-to-End Data Analysis Project using Excel, SQL, and Power BI
• Business Scenario: Clean, Analyze, Visualize, and Report
• Presentation & Peer Review

Certification of Completion

• Issued to participants who complete all modules and submit the final project.

⚠️ Disclaimer

Microsoft, Excel, Power BI, and SQL are trademarks of their respective owners. This course is independently developed by Velttech and is not affiliated with Microsoft.

📞 Contact Us Today to Enroll!

• Phone: 054 744 5155
• Email: info@velttech.org
• Website: www.velttech.org

 Start your journey into the world of data analysis with Velttech—where skills meet opportunity.