Ashish kumar Sahoo

Ashish kumar Sahoo

Data Analyst
India

About Me

Highly motivated and detail-oriented Data Analyst with 1.6+ years of experience transforming complex datasets into actionable insights. Proven ability to leverage statistical methods and programming languages to drive da…

Experience

Data Analyst

TALENTELE
Dec 2023 - Present · 2 years 7 months

As a data analyst, I used to gather messy data, clean it and generate actionable insights and visualize by using tools like microsoft power bi . well proficient in tools like ms sql ,advanced excel and power bi

Data Analyst

Talentele
Dec 2023 - May 2024 · 5 months

Ensured data quality through rigorous checks.
Connected to various data sources for importing data into Power BI.
Imported, cleaned, transformed, and validated data for decision-making purposes.
Created diverse visualizations like Line, Bar, Histograms, Scatter, Water, Bullet, Heat maps, Tree maps.
Generated pivot tables for data summary.
Utilized advanced excel functions for data cleaning and processing.
Wrote joins, sub-queries, Group By, CTE queries to fetch data of specific date range as per management requests.

Data Analyst

Impulsion laser consulting pvt. Ltd
Nov 2021 - Aug 2022 · 9 months

Acquired geospatial data from databases.
Championed data quality through meticulous data exploration and cleaning processes.
Performed data cleaning and pre-processing using QGIS and SQL to address inconsistencies and errors.
Conducted thorough data cleaning and validation processes in Excel to ensure accuracy and reliability of extracted data.
Collaborated with the data team to securely access information and use various SQL queries to pull out specific details as per requirement.
Generated tailored reports using pivot tables in Excel, providing valuable insights into project progress and effectiveness.
Utilized Power BI to import and visualize cleaned data, creating interactive dashboards for stakeholders.
Delivered valuable business insights by creating reports, models, and dashboards using MS Excel, SQL Server, and Power BI.
Created diverse visualizations like Line, Bar, Histograms, Scatter, Water, Bullet, Heat maps, Tree maps.
Proficient in SQL queries (Group By, Joins, Subqueries, CTEs, Window Functions, Stored Procedures) and MS Excel functions (VLOOKUP, HLOOKUP, PivotTables, Charts).

Skills

Analytics Data Analysis Professional Information Systems Management Data Mining Microsoft Access Statistical Analysis System (SAS) Structured Query Language (SQL) Data Representation Data Analysis Skills Power BI R Programming Language (R) Tableau MS Excel Python Statistical Analysis Hypothesis Testing Regression Modelling SQL Server QGIS VLOOKUP HLOOKUP PivotTables Charts Joins Subqueries Group By CTEs Window Functions Stored Procedures
Report this Profile?