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


Learn Data Analytics and Business Intelligence Skill using : Python | Power BI | Power Query | Tableau | SQL

What you will learn

Connect to multiple data sources

Clean and transform Data

Model Data

Transform less structured data

Create data relationships

Create queries with Power query

Merge queries with Power query

Create reports

Create visualizations

Create dashboards

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 gathers, cleans, and studies data sets to help solve problems. Here’s how you can start on a path to become one.

Data analytics is the process of examining data sets to extract information that may be hidden from the casual user and draw conclusions about the impact of that information. Data analytics can range from the simplest of business intelligence, to online analytical processing, all the way up to very advanced analytics.

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.


Get Instant Notification of New Courses on our Telegram channel.


Data analysis is the process of gleaning insights from data to help inform better business decisions. The process of analysing data typically moves through five iterative phases:

  • Identify the data you want to analyse
  • Collect the data
  • Clean the data in preparation for analysis
  • Analyse the data
  • Interpret the results of the analysis

Data analysis can take different forms, depending on the question youโ€™re trying to answer. Briefly, descriptive analysis tells us what happened, diagnostic analysis tells us why it happened, predictive analytics forms projections about the future, and prescriptive analysis creates actionable advice on what actions to take.

Business intelligence (BI) combines business analytics, data mining, data visualisation, data tools and infrastructure, and best practices to help organisations to make more data-driven decisions. In practice, you know youโ€™ve got modern business intelligence when you have a comprehensive view of your organisationโ€™s data and use that data to drive change, eliminate inefficiencies and quickly adapt to market or supply changes.ย  Business intelligence comprises the strategies and technologies used by enterprises for the data analysis and management of business information.

English
language

Content

Python and Jupiter Notebook Setup

Introduction
What is Jupiter Notebook
Installing Jupiter Notebook Server
Running Jupiter Notebook Server
Common Jupiter Notebook Commands
Jupiter Notebook Components
Jupiter Notebook Dashboard
Creating a new notebook
Jupiter Notebook User Interface

Data Analysis and Visualisation with Python and Pandas

Introduction to Kaggle Datasets
Tabular Data
Exploring Pandas DataFrame
Manipulating Pandas DataFrame
What is data cleaning
Performing Data Cleaning
What is Visualisation
Qualitative Data Visualisation
Quantitative Data Visualisation

Power BI Setup

Introduction to Data Analytics
What is Power BI
What is Power BI Desktop
Installing Power BI Desktop
Microsoft 365 Setup
Exploring Microsoft 365
Add users to Microsoft 365

Power BI Overview

Exploring Power BI Interface
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 Service
Power BI Apps

Connecting Power BI to Data Source

Connecting to web based data
Clean and transform data: Part 1
Clean and transform data: Part 2
Combining Data Source

Create Visualizations and Dashboards with Power BI

Creating Visualizations: Part 1
Creating Visualizations: Part 2
Publish report and create dashboards

Transforming Data with Power BI and Power Query

Connecting to Data Source
Power Query Editor and Queries
Creating and managing query groups
Renaming Queries
Splitting Columns
Changing Data Types
Removing and Reordering Columns
Duplicating and Adding Columns
Creating Conditional Columns
Connecting to files in a folder
Appending Queries
Merge Queries
Query Dependency View
Transform less structured data
Create Tables
Query Parameters

Data Modelling with Power BI

What is Data Modelling
Creating and managing Data Relationships
Creating Calculated Columns
Optmizing Models for Reporting
Time Intelligence
Applying Filters to Visuals

Tableau Setup

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

Data Analysis and Visualisation with Tableau

Connecting to data source
Join related data sources
Join data sources with inconsistent fields
Cleaning data
Reordering Visualisation
Change Summary
Split text into multiple columns
Presenting data using stories

SQL Server Setup

What is SQL Server
SQL Server Editions
SQL Server Installation Requirements
Download SQL Server
Install SQL Server
Install SSMS
Connect SSMS to SQL Server
Create a database
What is SQL
Data Preparation
Importing Datasets into database

Data Exploration: Asking questions from data with SQL

How many continents do we have data for
Possibility of dying from COVID
Percentage of population infected with COVID
Countries with highest Covid infection
Countries with highest COVID deaths
Continents with highest COVID death
Global COVID death and cases
Number of people vaccinated
Using SQL CTE to explore data
Using SQL temp tables to explore data
Using SQL Views to explore data