Data Craft HQ - datacrafthq.com

Loading

English

Hello There!

Lorem ipsum dolor sit amet, consectetur adipiscing elit,

Information

Follow Us

My Dashboard / Login

OUR TOP Program

Excel for being a data analyst

Excel for

Free

Be a part of future of Data Analysis

Learn Data Analysis from scratch!

Become a data analyst

Be prepare for the future of Analytics!

Master in data analytics

Data analytics is the key to success!

Overview of
Data Analytics

Learn the basics of the data analytics as a begineer.

Excel for
Data Analyst

Learn basics to advance of Excel for data analysis.

Python for
Data Analysis

Explore the uses of Python for data analytics.

Power BI for
Business Intelligence

Learn Power BI for data visualization for Business Intelligence.

Most Demanding

Best Data Analysis Learning

Data Analytics Beginner’s Journey

Let's go over the key topics and concepts within Data Analytics

Overview of data analytics

What is data analytics?

Tools needed to be a data analyst

Why data analytics?

Scope of a data analyst

Use of Chat GPT in data analytics

Introduction to excel

Introduction to Excel interface

Cell formatting - Copy, Cut and Paste in Excel

Formatting Shortcuts & Use of Excel Shortcuts

Cell Referencing (Related vs absolute referencing)

Flash Fill Tutorial

Conditional Formatting

Beginner to advance excel formula and function

All types of SUM, COUNT, COUNTIF, IFERROR, TEXT Functions

Lookup function (V-lookup, H-lookup, X-LOOKUP)

Index Match, XMatch

How to Create Dummy Data in Excel

Excel function Explanation with Chat GPT

Power Pivot and Power Query

What is a Power Pivot and Power Query?

Data cleaning with Power query

Working with multiple tables in power pivot

Pivot Table

Creating a Pivot Table

Design & Formatting a Pivot Table

Working with Slicer

Excel Chats & Graphs

What is Visualization? How to choose your best chart?

All types of Excel Charts & Graphs formatting

Use of Pivot Table and Dynamic Chart

Power BI Main Interface

What is Power BI

Why Power BI

How to install Power BI

Basics about Power Bl interface

What is a power query?

Different data connectors

Working with text (split, trim, upper lower etc.)

Add columns, remove columns, rows, etc.

Mean, mode, median, std count etc.

Power Query

Append multiple CSV Files from a folder.

Append Different data source files in Power Query ( Power Bl )

Merge Tables/Sheets in Power Query (Power Bl)

Merge Data from multiple Excel Files/Workbooks in Group by in Power Query

Data Modeling in Power BI

What is a data model?

Fact vs dimension table.

Primary key vs foreign key

Building relationships between tables.

What is tar schema?

Filter Flow.

What is a snowflake schema?

Adding multiple fact tables

Power BI Charts and Graphs

Learn different types of charts: column, funnel, ribbon chart

Include and Exclude

Export data from Visual

All types of card: number, date card

All types of filter

Working with slicer

DAX Basic to Advance in Power BI

Basic DAX Syntax

Calculated Column s in DAX

Measure in DAX

Different formulas in DAX (Aggregation, logical Etc)

Creating advanced DAX measure in Power BI

Import and Direct query mode

Power BI Service

Create an Account on Power BI Service

Publish Report on Power BI Service Account

Export (PPT, PDF, PBIX) Report and Share

Comment, Share and Subscribe to a report

Connecting Power BI to Different Databases

Connecting Power BI to Rest APl

Two End to End Power Bl Real World Projects

Real World Projects With Inventory And Supply Chain Management

Real World Project With Sales Analysis, Customer Analysis, Products Analysis

Getting Started With MySQL

What is Database?

What is SQL?

What is MySQL?

SQL Installation

What is DDL (Data Definition Language)?

What is DML (Data Manipulation Language)?

What is DCL (Data Control Language)?

What is TCL (Transaction Control Language)?

Database Terminology

What is the Primary key?

What is Foreign key?

Relation between Primary & Foreign key

Relationship between tables

First step in SQL

Creating Database in MySQL

Data types in MySQL

Creating table in MySQL

SQL Statements

Select & Insert Statements

Update and Delete Statements

SQL Functions

Aggregation Function

Logical Function

Statistical Function

SQL Join Functions (Self join, inner join, right join, left join, cross join)

Probability

Sample space, events, and outcomes

Joint Probability Distribution

Conditional Probability Distribution

Bayesian Probability

Hypothesis Testing

Null & Alternative Hypothesis

Type I Error and Type II Error

Level of Significance & p-values

Regression

Simple Regression & Correlation

Multiple Regression Analysis

Introduction to Python

Python for Data Analysis

Installing Python step by step

Command Line Basics

Python environment setup

Running code in Python

Basics of Jupyter Notebook

Python data types

Variable assignments in Python

Python Numbers

Work with Python strings

String formatting in Python

Index slicing with string

String properties and method

Python Data Structure And Statements

List in python (List slicing, List functions, and methods)

Dictionaries in python (Dictionaries slicing, Dictionaries functions and methods)

Tuples in Python

Sets in Python

IO with basic file in Python

Python comparison operators(=,!=,<,,>=)

Python Loop (For Loop, While Loop in python)

If, elselif, else statements in python

Python Function

Introduction to Python function

Basics of Python Function

Function keywords

Logic with python function

Lambda expression

Python Libraries - NumPy

Introduction to Python libraries

Introduction to NumPy

Arrays in NumPy

How to generate different random numbers with NumPy

NumPy operations

Python Libraries - Pandas

Introduction to Pandas

What is a data frame in Pandas?

Reading different files in Pandas

Data cleaning with Pandas

Apply different functions in Pandas

Working with missing values

Group by operation in Pandas

Matplotlib For Data Visualization

Introduction to matplotlib

Basic of matplotlib

Creating a figure object

Figure parameters

Matplotlib subplot

Matplotlib styling

Seaborn For Data Visualization

Introduction to seaborn

Different types of plot in seaborn

Seaborn styling

Real World Projects with Python for Data Visualization

Real World Project with Pandas for data visualization

Real World Project with Seaborn for data visualization

Introduction To Machine Learning

Basics of Machine Learning

Types of Machine Learning

Python Libraries for Machine Learning

Machine Learning use cases

Introduction with Scikit-learn & pipeline

Regression and Classification

Regression VS Classification

Linear Regression

Implementation of linear regression in python

Logistic Regression

Naive Bayes Classier

Data Analytics Courses

Focusing on high demand self-paced learning.

Overview of data analytics

The Economics Major can be combined
with a Major in another subject in order Double Major Degree.

iconprograme Data Analytics

Excel for Data Analyst

The Economics Major can be combined
with a Major in another subject in order Double Major Degree.

iconprograme Microsoft Excel

Power BI for Business Intelligence

The Economics Major can be combined
with a Major in another subject in order Double Major Degree.

iconprograme Microsoft Power BI

Explore the most appropriate course.

View all Course

Recent & Upcoming Events

See More Events

No Event Found

Video Tour in logo

Testimonial

What Learners Says

“I found the Data Analytics course, advanced and informative with all the latest data analytics tools and materials. I highly recommend this course for whom are looking for best self-paced data analytics courses for beginner and job ready."

Monirul Islam

Learners

BLOG UPDATES

Lates News & Articles.

COURSES FOR FREE, REGISTER NOW

SELF-PACED LEARNING

Start Learning Now

A Free Data Learning and Data Crafting Platform For Becoming a Data Analyst.

Got Questions? Call us

About

Quick links

Our Newsletter

Sign up for getting free latest news letter about Data.