Skip to content
  • Courses
  • Schools and Centers
    • Syed Ahsan Ali & Syed Maratib Ali School of Education
    • Shaikh Ahmad Hassan School of Law
    • Suleman Dawood School of Business
    • Syed Babar Ali School of Science & Engineering
    • Mushtaq Gurmani School of Humanities & Social Sciences
    • LUMS Learning Institute
    • Gurmani Center for Languages & Literature
    • Center for Continuing Education Studies
  • Programs
    • Professional Certificates
    • Open LUMS Courses
    • Executive Education
    • Events & Webinars
  • About
    • Our Purpose
    • Partners
    • Faculty
    • FAQS
    • LUMSx Perspective
Menu
  • Courses
  • Schools and Centers
    • Syed Ahsan Ali & Syed Maratib Ali School of Education
    • Shaikh Ahmad Hassan School of Law
    • Suleman Dawood School of Business
    • Syed Babar Ali School of Science & Engineering
    • Mushtaq Gurmani School of Humanities & Social Sciences
    • LUMS Learning Institute
    • Gurmani Center for Languages & Literature
    • Center for Continuing Education Studies
  • Programs
    • Professional Certificates
    • Open LUMS Courses
    • Executive Education
    • Events & Webinars
  • About
    • Our Purpose
    • Partners
    • Faculty
    • FAQS
    • LUMSx Perspective
  • Courses
  • Schools and Centers
    • Syed Ahsan Ali & Syed Maratib Ali School of Education
    • Shaikh Ahmad Hassan School of Law
    • Suleman Dawood School of Business
    • Syed Babar Ali School of Science & Engineering
    • Mushtaq Gurmani School of Humanities & Social Sciences
    • LUMS Learning Institute
    • Gurmani Center for Languages & Literature
    • Center for Continuing Education Studies
  • Programs
    • Professional Certificates
    • Open LUMS Courses
    • Executive Education
    • Events & Webinars
  • About
    • Our Purpose
    • Partners
    • Faculty
    • FAQS
    • LUMSx Perspective
Menu
  • Courses
  • Schools and Centers
    • Syed Ahsan Ali & Syed Maratib Ali School of Education
    • Shaikh Ahmad Hassan School of Law
    • Suleman Dawood School of Business
    • Syed Babar Ali School of Science & Engineering
    • Mushtaq Gurmani School of Humanities & Social Sciences
    • LUMS Learning Institute
    • Gurmani Center for Languages & Literature
    • Center for Continuing Education Studies
  • Programs
    • Professional Certificates
    • Open LUMS Courses
    • Executive Education
    • Events & Webinars
  • About
    • Our Purpose
    • Partners
    • Faculty
    • FAQS
    • LUMSx Perspective

Fundamentals of Data Analytics

By Hamza Farooq
Enroll Now

Charges

Rs.20000

Duration

6 weeks

Language

Bilingual

Course Access

Limited

Certificate

On Completion

Fundamentals of Data Analytics

By Hamza Farooq
Enroll Now

About this Course

In today’s data-driven age, understanding the basic concepts of Data Analytics has become imperative for the success of any organization. In this course, students will focus on the science of analysing data and making conclusions for effective business decisions.

What will you learn

Students will learn basic data techniques in Microsoft Excel and create dashboards for managing data. During the second phase of the course, students will focus on getting hands-on experience with SQL and creating databases using Microsoft SQL Server 2016. This will enable students to format and design databases for organizations.

Partners

Data is everywhere—from e-commerce sales, app downloads to a smartphone, to supply chain management. This massive increase in the amount of data being collected is translating to an exponential growth in the computer power needed to process that data.

Course Outline

Lecture 1
In this lecture, you will understand the basics of data analytics and what it entails as a field. You will also learn how to review data and format it in an understandable form in Microsoft Excel.
Lecture 2
In this lecture, we will discuss what comprises a database and how to create one using SQL Server. You will also receive an introduction to the SQL language.
Lecture 3
In this lecture, you will learn how to use SQL Joins, write SQL Queries and format data.
Lecture 4
This lecture provides a basic overview of Microsoft PowerPlatform and PowerBI and how to use these tools to connect to different data sources.
Lecture 5
At the end of this lecture you will be able to use filters, variables, and bookmarks in PowerBI to eventually create your first dashboard for Management. It also gives a quick overview of DAX and data formatting in PowerBI.

Instructors

Hamza Farooq

Senior Research Science Manager
Google

You might also like

Course

سیکھنا سیکھیں : کچھ بھی نیا کیسے سیکھ سکتے ہیں   

ڈاکٹر صبیح انور، ڈاکٹر ہانیہ اعظم، ڈاکٹر ارشد احمد اور ڈاکٹر سلیمان شاہد
  • PKR 2500
  • 4 ہفتے
  • 01/05/2023
Course
TEACHING PRACTICE: FUNDAMENTALS OF THE 5E MODEL

Teaching Practice: Fundamentals of the 5E Model

Dr Shazia Awan, Sabahat Quadri, Salahuddin Azmat Isa
  • PKR 4999
  • 4 - 6 weeks
  • 01/05/2023
Course
Course Design & Development

Course Design & Development

Dr Launa Gauthier & Talha Dogar
  • PKR 6751
  • Coming Soon
Course

Health & Wellness – A Manual

Dr Basmaa Ali
  • PKR 5250
  • Coming Soon
Course
Machine Learning by Dr. Agha Ali Raza

Machine Learning

Dr Agha Ali Raza
  • Coming Soon
Previous
Next

Related Masterclasses

Explore all >
< Back to LUMS

About Us

  • Our Purpose
  • FAQS
  • Faculty
  • Partners
  • Our Purpose
  • FAQS
  • Faculty
  • Partners

Schools

  • SBASSE
  • MGSHSS
  • SDSB
  • SOE
  • SAHSOL
  • SBASSE
  • MGSHSS
  • SDSB
  • SOE
  • SAHSOL

Centers

  • LLI
  • REDC
  • CES
  • GCLL
  • LLI
  • REDC
  • CES
  • GCLL
2023 (C) Lahore University of Management Sciences. All Rights Reserved
Facebook-f Instagram Youtube Twitter Linkedin-in