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

21st Century Teaching Practices

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

Course Design & Development

Dr Launa Gauthier & Talha Dogar
  • Coming Soon
Course

Personal Health & Wellness – A Manual

Dr Basmaa Ali
  • Coming Soon
Course

Machine Learning

Dr Agha Ali Raza
  • Coming Soon
Previous
Next

Related Masterclasses

Explore all >
< Back to LUMS

About Us

Schools

Centers

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