Course Overview
Data analysis is a process of inspecting, cleansing, transforming, and modelling data with the goal of discovering useful information, informing conclusions, and supporting decision-making.
Data analysts are in high demand across all sectors, such as finance, consulting, manufacturing, pharmaceuticals, government and education.
The ability to pay attention to detail, communicate well and be highly organised are essential skills for data analysts. They not only need to understand the data, but be able to provide insight and analysis through clear visual, written and verbal communication.
Some responsibilities of a data analyst includes:
Developing records management processes and policies
identify areas to increase efficiency and automation of processes
set up and maintain automated data processes
identify, evaluate and implement external services and tools to support data validation and cleansing
produce and track key performance indicators
develop and support reporting processes
monitor and audit data quality
liaise with internal and external clients to fully understand data content
gather, understand and document detailed business requirements using appropriate tools and techniques
design and carry out surveys and analyse survey data
manipulate, analyse and interpret complex data sets relating to the employer's business
prepare reports for internal and external audiences using business analytics reporting tools
create data dashboards, graphs and visualisations
provide sector and competitor benchmarking
mine and analyse large datasets, draw valid inferences and present them successfully to management using a reporting tool
In this course we will perform some task of a Data Analyst using Python ,Excel, SQL, and Power BI. We will connect to a variety of data sources, perform data transformation ,cleaning and exploration . We will create dashboards to visual data .
FAQ
FAQ area empty
Course curriculum
Chương 1 Introduction 4 bài
- What Is a Data Analyst? Học thử
- Understanding Data and Data Types Học thử
- The Data Analysis Process Học thử
-
Essential Tools Used by Data Analysts
Chương 2 Python and Jupyter Notebook Setup 11 bài · 51 phút
-
Introduction 0:20
- What is Python Học thử 5:16
-
What is Jupyter Notebook 1:20
- Installing Jupyter Notebook Server Học thử 6:45
- Running Jupyter Notebook Server Học thử 8:44
- Jupyter Notebook Commands Học thử 7:28
-
Jupyter Notebook Components 4:26
-
Jupyter Notebook Dashboards 4:20
-
Creating a new notebook 6:45
-
Jupyter Notebook user interface 5:44
-
Python and Jupyter Notebook Setup
Chương 3 Data Analysis & Visualization with Python & Jupyter Notebook 10 bài · 1 giờ 21 phút
-
Kaggle Datasets 3:06
-
Tabular data 8:00
-
Exploring Pandas Data frame 2:20
-
Manipulating Pandas Data frame 12:57
-
What is data cleaning 3:28
-
Performing data cleaning 22:42
-
What is data visualization 2:35
-
Qualitative data visualization 12:00
-
Quantitative data visualization 13:49
-
Data Analysis & Visualization with Python & Jupyter Notebook
Chương 4 Data Analysis & Visualization with Excel 18 bài · 1 giờ 35 phút
-
What is Power Pivot 1:02
-
Versions of Power Pivot 1:32
-
Enabling Power Pivot in Excel 1:29
-
What is Power query 3:30
-
Please Read
-
Connecting to data source 4:26
-
Preparing your query 4:51
-
Cleansing data 7:37
-
Enhancing your query 9:21
-
Creating a data model 6:02
-
Build data relationships 6:56
-
Create lookups as new fields with DAX 7:01
-
Analyse data using Pivot tables 8:42
-
Analyse data with Pivot charts 8:14
-
Refreshing source data 7:34
-
Updating queries 9:18
-
Creating new reports 7:18
-
Data Analysis & Visualization with Excel
Chương 5 Microsoft SQL Server Setup 12 bài · 36 phút
-
What is SQL Server 2:57
-
SQL Server Editions 4:45
-
Hardware and Software Requirements
-
Download SQL Server 2:20
-
Install SQL Server 7:56
-
Install SSMS 1:32
-
Connect SSMS to SQL Server 2:20
-
SQL Server System Databases 5:56
-
Download sample databases 5:24
-
Restore sample databases into SQL Server 2:15
-
Create a database 0:32
-
Microsoft SQL Server Setup
Chương 6 Data Exploration & Analysis with SQL 14 bài · 1 giờ 15 phút
-
Data Preparation 8:36
-
Importing datasets into database 7:31
-
How many continents do we have data for 4:52
-
Possibility of dying from COVID 6:38
-
Percent of population infected with COVID 5:00
-
Countries with highest infection 5:40
-
Countries with highest COVID deaths 4:58
-
Continents with highest COVID deaths 2:50
-
Global Covid deaths 3:23
-
Number vaccinated against COVID 10:13
-
Exploring data with temporary tables 6:17
-
Exploring data with views 3:45
-
What is the purpose of Common Table Expressions (CTEs) in SQL?
-
Exploring data with CTE 5:43
Chương 7 Power BI Setup 8 bài · 28 phút
-
What is Power BI 5:47
-
What is Power BI Desktop 3:40
-
Install Power BI Desktop 2:55
-
Explore Power BI Interface 5:02
-
Microsoft 365 setup 3:43
-
Exploring Microsoft 365 4:04
-
Add users to Microsoft 365 2:54
-
Power BI Setup
Chương 8 Power BI Overview 6 bài · 30 phút
-
Power BI Overview : Part 1 4:24
-
Power BI Overview : Part 2 4:05
-
Power BI Overview : Part 3 4:49
-
Components of Power BI 2:57
-
Building blocks of Power BI 9:31
-
Power BI Apps 3:56
Chương 9 Data Analysis & Visualization with Power BI 9 bài · 46 phút
-
Important Update – Course Dataset Links
-
Connect to data source 5:07
-
Clean & transform data : part 1 7:12
-
Clean & transform data : part 2 9:45
-
Combine data source 7:59
-
Create visualization : Part 1 6:09
-
Create visualization : Part 2 5:23
-
Publish report to Power BI Service 4:47
-
Data Analysis & Visualization with Power BI
Chương 10 Analyse & consume database data with Power BI 7 bài · 50 phút
-
Connect to SQL Server with Power BI 7:15
-
What is PostgreSQL 1:41
-
Install PostgreSQL 10:46
-
Connect to PostgreSQL 9:35
-
Install sample database 11:49
-
Connect to PostgreSQL with Power BI : Part 1 3:28
-
Connect to PostgreSQL with Power BI : Part 2 5:00
Chương 11 Transforming Data with Power BI 19 bài · 1 giờ 55 phút
-
Importing Microsoft access database file 12:58
-
Changing locale settings 1:47
-
Connect to data source 7:09
-
Power query editor and queries 6:49
-
Creating & managing query groups 4:35
-
Renaming queries 4:54
-
Splitting columns 7:06
-
Changing data types 5:47
-
Removing & reordering columns 6:54
-
Duplicating & adding columns 3:31
-
Creating conditional columns 6:18
-
Connecting to files in folder 7:17
-
Appending queries 6:58
-
Merge queries 5:35
-
Query dependency view 4:32
-
Transform less structured data 9:10
-
Create tables 3:47
-
Query Parameters 9:28
-
Transforming Data with Power BI
Chương 12 Visual Studio Setup 4 bài · 10 phút
-
What is Visual Studio
-
Visual Studio Installation Requirements
-
Installing Visual Studio 3:32
-
Installing Visual Studio templates 6:17
Chương 13 AI Powered Data Warehouse 10 bài · 1 giờ 1 phút
-
What is Data Warehouse
-
What is AI 10:34
-
Create a ChatGPT Account 3:13
-
Generating ETL Scripts with ChatGPT 7:46
-
Create a staging table 3:36
-
What is SSIS
-
Create and execute SSIS Package 9:07
-
Dimensional Modelling Concepts 11:35
-
AI Dimensional Modelling 6:51
-
Building the data warehouse model 8:37
Chương 14 Python Setup 7 bài · 30 phút
-
What is Python
-
Python Installation 3:47
-
What are virtual environments 1:51
-
Creating and activating a virtual environment 6:43
-
Updating Pip 1:53
-
Installing Visual Studio Code 7:28
-
Installing and Importing Libraries 7:55
Chương 15 Analytics & Business Intelligence for AI Modelled Data Warehouse 13 bài · 54 phút
-
Setting up page and database configuration 8:30
-
Writing SQL Queries for KPI Metrics with ChatGPT 4:50
-
Writing SQL Queries for Activity by Type with ChatGPT generated script 4:16
-
Writing SQL Queries for Engagement Levels with ChatGPT generated script 3:15
-
Writing SQL Queries for Channel Performance with ChatGPT generated script 4:01
-
Writing SQL Queries for Top Customers with ChatGPT generated script 4:32
-
Writing SQL Queries for Activity by Day of Week with ChatGPT generated script 3:56
-
Building the dashboard Part 1 7:08
-
Building the dashboard Part 2 3:15
-
Building the dashboard Part 3 3:25
-
Building the dashboard Part 4 3:50
-
Running Streamlit app 3:25
-
Download App code
Chương 16 Enterprise Data Analysis Using Oracle SQL and Oracle Autonomous AI Database 17 bài · 1 giờ 21 phút
-
Introduction 3:35
-
Oracle Cloud Setup 3:37
-
Login to OCI 1:37
-
What is Autonomous Database. 1:59
-
Create an autonomous database 4:16
-
Create a Database Admin Account 9:36
-
Accessing OCI and Database Actions 4:28
-
What is SH Schema 3:23
-
How to access SH Schema Data 0:56
-
Understanding SH Star Schema 17:18
-
Data Exploration 5:52
-
Core Business Metrics( KPIs) 1:17
-
Time Series Analysis 2:49
-
Customer Analytics 3:54
-
Product Performance 3:26
-
Advanced Enterprise SQL Analytics 4:40
-
Executive Reporting & Business Insights 8:03
Chương 17 Capstone Project 2 bài
-
Project Steps
-
Example Solution Guide to project
Requirment
-
Basic knowledge of Excel advised
-
Basic knowledge of database concepts advised
-
Basic knowledge of SQL advised
-
Basic knowledge of Python advised
Outcomes
-
Perform data analysis & visualization with Python
-
Perform data analysis & visualization with Excel
-
Perform data exploration and analysis with SQL
-
Perform data analysis & visualization with Power BI
-
Write SQL Queries to explore and analyse data
-
Connect to multiple data sources with Power BI
-
Clean & transform data
-
Create Dashboards with Power BI
-
Write SQL temporary table queries to extract and query data
-
Write SQL CTE queries to extract and query data
0 Student
1 Course
0 review