Data Analytic From Beginner To Advance

Data Analytic From Beginner To Advance
Published 5/2025
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz

Learn Data Analytics with Excel & Power BI: Data Cleaning, Visualization, Dashboards & Business Insights

What you’ll learn

Understand the data analytics lifecycle and apply the problem-solving framework to real-world challenges.

Clean, analyze, and visualize data using Microsoft Excel, including pivot tables and advanced formulas.

Build interactive dashboards in Power BI to communicate insights and track KPIs.

Apply statistical techniques like hypothesis testing and correlation to drive data-informed decisions.

Create a personal portfolio website to showcase your analytics projects and skills to potential employers.

Requirements

No prior experience is required-this course is designed for complete beginners!

Willingness to learn and practice

A stable internet connection

A laptop or desktop computer (Windows or Mac)
A Microsoft Excel (guided in the course)

A free Power BI (guided in the course)

Description

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 What To Expect In This Course

Lecture 3 Free Video

Lecture 4 Free Video

Lecture 5 Free Video

Lecture 6 Free Video

Lecture 7 Free Video

Section 2: Data sources and access

Lecture 8 How to install microsoft excel on windows
Lecture 9 An introduction to spreadsheets

Lecture 10 Important spreadsheet terminology

Lecture 11 Spreadsheet file format

Lecture 12 Spreadsheet text file format

Lecture 13 How to import data into Microsoft excel through Get Data feature.

Section 3: Function you need to know as a data analyst

Lecture 14 10 Basic function in Microsoft Excel

Section 4: Problem solving skills and data analytics process

Lecture 15 Problem Solving

Lecture 16 Data analysis process

Section 5: Data aggregations and descriptie statistics

Lecture 17 Descriptive Statistics

Lecture 18 Pivot Table Overview

Lecture 19 Pivot Table Walkthrough

Section 6: An introduction to data visualisation

Lecture 20 Data Visualization Intoduction

Lecture 21 Data Visualization Walkthrough

Section 7: Samples and distributions

Lecture 22 Sample and sample size

Lecture 23 Hypothesis testing

Lecture 24 Hypothesis testing walkthrough

Section 8: Indentifying patterns

Lecture 25 Line of best fit

Lecture 26 Line of best fit equation

Lecture 27 Line of best fit walkthrough

Section 9: Microsoft Excel Project

Lecture 28 Micorsoft Project Introduction

Lecture 29 Microsoft Excel Project: Data Importation

Lecture 30 Microsoft Excel Project: Data Cleaning

Lecture 31 Microsoft Excel Project: Data Transformation

Lecture 32 Microsoft Excel Project: Exploratory Data Analysis

Lecture 33 Microsoft Excel Project: Data Modeling

Lecture 34 Microsoft Excel Project: KPI

Lecture 35 Microsoft Excel Project: Analysis

Lecture 36 Microsoft Project: Data Visualization

Lecture 37 Microsoft Excel Project: Template

Lecture 38 Microsoft Project: Import KPI to Dashboard

Lecture 44 Microsoft Project: How to design Slicer

Lecture 45 Microsoft Project: How to design Title

Section 10: Communicating our findings

Lecture 46 Crafting experiences through data stories

Lecture 47 EPIC communication

Section 11: Design for impactful communication

Lecture 48 The four pillars of effective communication design

Lecture 49 Presentation design principles

Section 12: Introduction to dashboard and reporting

Lecture 50 Dashboards and reports

Lecture 51 Power BI as a dashboarding tool

Lecture 52 How to install Power BI into Windows Laptop
Lecture 53 Importing data in Power BI

Section 13: Creating Visuals in Power BI

Lecture 54 Creating a visualization

Lecture 57 Compositions in Power BI

Lecture 59 Maps in Power BI

Section 14: Formatting Visuals in Power BI

Lecture 60 Basic formatting of visualisations

Lecture 61 Communicating additional information through visualisations

Lecture 62 Conditional formatting in Power BI

Section 15: Data Model in Power BI

Lecture 63 An introduction to data models in Power BI

Lecture 64 Importance of data model

Section 16: Data Transformations In Power Bi

Lecture 66 Data type in power bi

Lecture 67 Spliting and replacing value in power bi

Lecture 68 Analyzing data profile and groupby with power query

Section 17: Calculated Column With Dax

Lecture 69 Concatenating column using dax

Lecture 71 Using control flow and string functions

Lecture 72 Referencing columns using the RELATED function

Section 18: Dax Aggregation

Lecture 73 Creating a simple year table

Lecture 74 Creating a table of unique values and descriptions

Lecture 75 Creating a simple measure

Lecture 76 Creating a compound measure

Section 19: First Power BI Project

Lecture 77 Dashboard planning

Lecture 78 Creating power BI template with power point

Lecture 79 Project: Dashboard KPI

Lecture 80 Project: Creating a quick measure

Lecture 81 Project: Creating calendar table with dax

Lecture 82 Project: Creating growth rate

Lecture 86 Project: Formating slicer

Lecture 87 Project: Creating a greating message

Lecture 88 Project: How to hide some element on your dashboard

Lecture 89 Project: Dynamically add image into dashboard

Lecture 90 Project: Creating a drillthrough in your dashboard

Section 20: Exploratory data analysis in power bi

Lecture 91 EDA Overview

Lecture 92 EDA Key Influncer

Lecture 93 Power BI analyze feature

Lecture 94 Looking for trends and patterns with conditional formating

Section 21: Final Project: Tracking Njiwa’s Water Funds

Lecture 96 Final Project: Project Overview

Lecture 97 Final Project: Data Importation

Lecture 98 Final Project: Data Cleaning

Lecture 99 Final Project: Data Modeling

Lecture 100 Final Project: Data Enrichment

Lecture 101 Final Project: Calculate Water Improvement Percenatage

Lecture 102 Final Product: Calculate Cumulative Cost and Budget

Lecture 103 Final Project: Calculating Incompleted Project

Lecture 104 Final Project: Calculating Other Metrics

Lecture 105 Final Project: Importing Template From Power Point Into Power BI Desktop

Lecture 106 Final Project: Formating Card In Power BI Desktop Desktop

Lecture 107 Final Project: Formating Guage Map Power BI Desktop

Lecture 110 Final Project: Formating Shape Map Power BI Desktop

Lecture 111 Final Project: Creating Buton Power BI Desktop

Section 22: Portfolio Website

Lecture 112 Creating A Portfolio Website.