• Post category:StudyBullet-7
  • Reading time:9 mins read


Connect to various data sources, clean ,transform ,analyse data and create visualizations

What you will learn

Connect to multiple data sources

Analyse data and create visualization with Power BI

Create dashboards with Power BI

Publish reports to Power BI Service

Connect Power BI to databases

Data preparation and exploration with SQL

Write CTE queries to explore data with SQL

Create temp tables and views with SQL

Analyse and extract data with Python

Learn skills to scrape data from web pages

Create data visualizations with Tableau

Description

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.

A data analyst collects, cleans, and interprets data sets in order to answer a question or solve a problem. They can work in many industries, including business, finance, criminal justice, science, medicine, and government.

Data analyst tasks and responsibilities

A data analyst is a person whose job is to gather and interpret data in order to solve a specific problem. The role includes plenty of time spent with data, but entails communicating findings too.

Here’s what many data analysts do on a day-to-day basis:


Get Instant Notification of New Courses on our Telegram channel.


Gather data: Analysts often collect data themselves. This could include conducting surveys, tracking visitor characteristics on a company website, or buying datasets from data collection specialists.

Clean data: Raw data might contain duplicates, errors, or outliers. Cleaning the data means maintaining the quality of data in a spreadsheet or through a programming language so that your interpretations won’t be wrong or skewed.

Model data: This entails creating and designing the structures of a database. You might choose what types of data to store and collect, establish how data categories are related to each other, and work through how the data actually appears.

Interpret data: Interpreting data will involve finding patterns or trends in data that will help you answer the question at hand.

Present: Communicating the results of your findings will be a key part of your job. You do this by putting together visualizations like charts and graphs, writing reports, and presenting information to interested parties.

English
language

Content

Power BI Setup

Introduction
Introduction to Data Analytics
What is Power BI
Install Power BI Desktop
Exploring Power BI Desktop
Office 365 setup
Getting started with Office365
Adding users to Office365

Overview of Power BI

Power BI Overview : Part 1
Power BI Overview : Part 2
Power BI Overview : Part 3
Components of Power BI
Building blocks of Power BI
Exploring Power BI Desktop interface
Power BI Apps

Clean Transform and Visualize Data

Connecting to Web Based Data
Clean and transform data : Part 1
Clean and transform data : Part 2
Combining data sources
Creating Visuals in Power BI: Part 1
Creating Visuals in Power BI: Part 2
Publishing Report to Power BI Service

Connecting Databases to Power BI

Download SQL Server
Install SQL Server
Install SSMS
Connect SSMS to SQL Server
Attach sample database
Connect SQL Server to Power BI
Install PostgreSQL
Connect to PostgreSQL Server
Attach sample database to PostgreSQL
Connect PostgreSQL to Power BI : Part 1
Connect PostgreSQL to Power BI : Part 2

Data Exploration with SQL – COVID Datasets

Create a database
Data Preparation
Importing Datasets into database
How many continents do we have data for
Possibility of dying from COVID
Percentage of population infected with COVID
Countries with highest infection
Countries with highest deaths
Continents with highest death
Global COVID Cases and death
Number of people vaccinated
Data Exploration with CTE
Data Exploration with Temporary Tables
Data Exploration with Views

Tableau Setup

What is Tableau
Tableau Public Desktop
Tableau Public Overview: Part 1
Tableau Public Overview: Part 2
Tableau Online
Tableau Data Sources
Tableau File Types
Tableau Help Menu

Data Analysis and Visualization with Tableau

Connecting to data source
Join related data sources
Join data sources with inconsistent fields
Data cleaning
Tableau interface
Reordering Visualization
Change summary

Python Setup

Install Python on Windows
Install Python on Macs
Install Visual studio code
Create a virtual environment on Windows
Updating pip
Activate virtual environment on Windows
Create a virtual environment on Macs
Activate virtual environment on Macs
Install Beautiful soup

Data Extraction with Python ( Web Scraping )

What is web scraping
What we will scrape ( extract )
Inspecting elements
How internet works
What is http
Building a web scraping script : Part 1
Building a web scraping script : Part 2
Prototyping the script: part 1
Prototyping the script: part 2
Prototyping the script: part 3
Prototyping the script: part 4
Prototyping the script: part 5
Saving extracted data