Embedded Files
PROJECT Links
Churn Analysis:- Churn analysis
Covid-19 Project:- Covid-19 Analysis
Olympics 1896-2016:- Olympics 1896-2016
SQL
PROJECT-1 COVID-19 ANALYSIS (GLOBAL REPORT)
I use Microsoft-SQL-server for analysis because Importing data into the database is very easy as compared to other RDBMS. I use comments before writing any code because it makes it easy while documenting & making reports.
TABLEAU
TABLEAU
PROJECT-1 COVID-19 ANALYSIS (GLOBAL REPORT)
PROJECT-1 COVID-19 ANALYSIS (GLOBAL REPORT)
This is the visualization process in the lifecycle. I used Tableau to create a dashboard and communicate my findings.
R-STUDIO
R-STUDIO
BASIC VISUALIZATION USING R
I use R-studio to execute programs, create basic statistical calculations, create a visualization using ggplot, create reports and documents.
EXCEL
EXCEL
After i collect raw data from the source. the next task i assign myself is to clean, organise and format data.
Before
Before
Collected raw data from source.
After
After
After formatting, sorting, and filtering data.
CLEANING DATA USING EXCEL
CLEANING DATA USING EXCEL
' GARBAGE IN AND GARBAGE OUT '
' GARBAGE IN AND GARBAGE OUT '
Having good quality data is very important. Good data is important to obtain the right insight. Data cleaning is a subset of the DATA WRANGLING process. For data cleaning, I use:-
Having good quality data is very important. Good data is important to obtain the right insight. Data cleaning is a subset of the DATA WRANGLING process. For data cleaning, I use:-
Removing duplicates.
Remove blank cells.
Change mixed case into a single upper/lower/proper case.
Spell check.
To Trim extra space using TRIM function.
Join two cells such as ( first_name & last_name ) using CONCATENATE function.
Adding filters and sorting the data.
Assignment - 1
In this assignment, you will be following the scenario of a recently hired Junior Data Analyst in a local government office, who has been tasked with sorting and analyzing fleet inventory data that was previously imported and cleaned. You plan to use pivot tables to analyze the data in preparation for the results to be visualized in a dashboard and added to a data findings report later.
IBM ASSIGNMENTS
IBM ASSIGNMENTS
Format the data as a table: Use the Format as Table option to format the data as a table.
Use AutoSum to calculate values: Use AutoSum to find the following values for column 'C' and record each of the values:
Create a Pivot Table: Use the PivotTable feature to create a pivot table that displays the Department field in the Rows section, and the Equipment Count in the Values section, so that the pivot table displays the sum of equipment count by department.
Sort the pivot table data: Use the Sort By Value setting on the pivot table to sort it in descending order by the sum of equipment count.
Make two more pivot tables exactly the same as task 3: Follow the same steps you performed in Tasks 3 and 4 to create two more identical pivot tables so that you end up with 3 worksheets that contain identical pivot tables.
Analyze data in the pivot table: Use the PivotTable Fields pane to manipulate and analyze data in the two copied pivot table as follows:
In pivot table 2, i Collapsed all fields except the top one - Transportation.
In pivot table 3, i Collapsed all fields except the top one - CUV.
Page updated
Google Sites
Report abuse