Aakash Kumar Data Analyst, Business Analyst
No reviews yet

My Name is Aakash Kumar, I have experience in Data Analysis, Data Mining, Dashboard designing etc.. I have done my graduation in Bachelor of Technology. I have been working for almost 3 years as an Data Analyst and Business Analyst in different companies. I love to share my knowledge and help others with my professional skills.

I have strong knowledge in Power BI, Google Spreadsheets, MS Excel, SQL, T-SQL and Data warehousing concepts and have good knowledge in Python and Dundas BI.

Managing large datasets with functions: IF, SUM, INDEX, MATCH, VLOOKUP, Creating dynamic reports with PivotTables and Building charts and graphs .Building and applying advanced formulas, like SUMPRODUCT, INDIRECT, INDEX MATCH, and OFFSET.

Using automated tools to extract data from primary and secondary sources, Removing corrupted data and fixing coding errors and related problems in Python.

Developing and maintaining databases, data systems – reorganizing data in a readable format
Performing analysis to assess quality and meaning of data.

Supervising the development and maintenance of websites and ensuring the protection of users' data.

I am not interested in offline teaching classes, I am only open for freelancing hence please reach out who needs help in Advance excel, SQL and BI tools

Subjects

  • Python Beginner-Intermediate

  • Power BI Beginner-Expert

  • PostgreSQL Beginner-Expert

  • Excel Advanced Intermediate-Expert

  • Dundas BI Beginner-Expert


Experience

  • Consultant (Jan, 2023Present) at Technodata Analytics Pvt Ltd
    Giving business solutions to clients.
    Creating decision making dashboards to generate the profitability.
    Solving complex queries to get the KPIs for decision making.
    Designing end to end architecture of business solutions.
    Embedding of different technologies for development of business solutions.
  • Business Technology Associate (Sep, 2021Dec, 2022) at TechnoData Analytics
    • Dashboards: Created interactive dashboards in Dundas BI for Data Reporting using JS.

    • Data Cleaning in Excel using Advance formulas and creating reports in Excel.

    • Development of Dashboards and GUI Application in Dundas BI with the help of Write Back functionality
    using MS SQL server and API.
  • Data Analyst Trainee (Jan, 2021Jun, 2021) at Saimax Technologies
    • Performed Extract Transform Load (ETL) using Statistical techniques in Python and taking out
    inferences.
    • Dashboards: Created visually impactful dashboards in Excel and Tableau for data reporting by using
    pivot tables and VLOOKUP.
    • Extracted, interpreted and analyzed data to identify key metrics and transform raw data into meaningful,
    actionable information.
  • MIS Executive (Jul, 2019Jan, 2021) at Pranad Agro Industries Pvt Ltd
    • Presenting Business Reports and Dashboards with drilling out Insights to the higher management

    • Designing, monitoring, analyzing, and troubleshooting IT systems.

    • Produced accurate office files, updated spreadsheets and crafted presentations to support executives
    and boost team efficiency.

Education

  • Data Science (Mar, 2021Sep, 2021) from ANALYTIXLABS, GURGAON
  • B.Tech (Jul, 2013Jul, 2017) from Inderprastha Engineering College, Ghaziabad

Fee details

    200800/hour (US$2.369.43/hour)

    200: For simple problems in Excel, SQL and BI tool.
    400: For Intermediate Queries in SQL and Advance Excel formulas or DAX formulas.
    800: For making Dashboard and Data cleaning.


Reviews

No reviews yet. Be the first one to review this tutor.