SE Factory logo
SE Factory logoClose Icon
Close Icon

Choose which program you want to apply for:

FCS

Apply

FSW

Apply

FSD

Apply

UIX

Apply
HomeHello world!MilestonesProgramsHire talentTestimonialsFAQsContact usPartnersNewsletter

Data Analytics

$250 $200

Unlock the power of data and turn insights into impactful decisions. In this course, you'll learn how to analyze, visualize, and present data using industry-standard tools.
From designing interactive dashboards to mastering key Excel functions, you'll gain practical skills to drive data-driven strategies in any business..

Course Info: 📅 April 7 – April 17 | ⏰ 6:00 PM – 8:00 PM | 🗓 MWF | 🌐 Online
Enroll Now

2 Weeks

12 hours

3+ Exercices

Online

Certification of Completion

Curriculum
Learning Outcomes
Requirements & Prerequisites
Fees

Day 1: Introduction to Business Concepts in Data Analysis

  • Understand the importance of data analysis in business strategy and operations.
  • Learn how to translate business problems into analytical questions.
  • The connection between data analysis and business strategy.
  • Case study discussions: How businesses used data analysis to solve problems.

Day 2: Key Performance Indicators (KPIs) and Metrics

  • What are KPIs, and why are they important?
  • Types of KPIs: Leading vs. Lagging, Financial vs. Non-Financial.
  • Metrics used to measure business performance.
  • Exercise: Defining KPIs for a sample business.

Day 3: Basic SQL (Structured Query Language) – Part 1

  • Introduction to databases and tables.
  • Basic SQL queries: SELECT, FROM, WHERE.
  • Filtering and sorting data.
  • Hands-on practice: Writing simple SQL queries.

Day 4: Basic SQL (Structured Query Language) – Part 2

  • Data aggregation using COUNT, SUM, AVG, etc.
  • JOIN operations to link related tables.
  • Using GROUP BY and HAVING to summarize data.
  • Hands-on practice: Writing aggregation queries.

Day 5: Power BI – Introduction and Basics

  • Introduction to Power BI and its interface.
  • Connecting Power BI to different data sources.
  • Basic data transformation and cleaning in Power BI.
  • Walkthrough: Importing data and transforming it in Power BI.

Day 6: Power BI – Advanced Features and Data Visualization

  • Creating interactive reports and dashboards.
  • Automating reports and integrating Power BI with other tools.
  • Best practices in data visualization: Choosing the right chart type.
  • Advanced visualization techniques: Dynamic charts, geographic mapping, real-time dashboards.
  • Hands-on practice: Building an interactive Power BI dashboard.

Student Learning Outcomes

  • SLO1: Explore the role of data analysis in business strategy and learn to translate business problems into analytical questions.
  • SLO2: Dive into KPIs and metrics, understanding their importance in measuring business success and decision-making.
  • SLO3: Get hands-on with basic SQL, learning to query, filter, and sort data from databases.
  • SLO4: Build on SQL skills by learning aggregation techniques, data relationships, and advanced query operations.
  • SLO5: Introduction to Power BI, focusing on data import, transformation, and basic report creation.
  • SLO6: Master Power BI's features for building interactive dashboards and data visualizations to drive insights.

Requirements

  • A well-functioning laptop Windows Operating System.
  • Reliable internet connection.

Prerequisites

  • No prior experience is required.
  • Basic knowledge of Excel Functions (SUM, COUNT, Filters, etc..)

$200 (VAT might apply).

Michel Arnaout
Michel Arnaout is a highly skilled Data Analyst and Engineer with a strong background in driving data-driven solutions for multinational corporations.
With years of experience working with some of the world's largest companies, Michel possesses a deep understanding of global business operations and how data can be leveraged to make critical, informed decisions. His expertise spans data engineering, analytics, and management, enabling him to bridge the gap between raw data and actionable insights in complex organizational environments.
SE FACTORY Pro
HomeHello world!MilestonesProgramsHire Talent
F&QsTestimonialsContact usPartners
© 2023 SE Factory SAL. All rights reserved.
Privacy policy