Dawood Ahamad Power BI, SQL, Excel, Power Query, DAX,Power Pivot
No reviews yet

I am a Data Analyst with practical experience in real world projects. I have worked on Power BI/SQL/Advanced Excel.
On top of that I have also secured the 1st Rank in the Codebasics Resume Challenge #7.
I have shared my Data Analytics projects with their video presentations.
I have helped many of my friends/LinkedIn connections complete their projects as well.
I am a Data Analyst with practical experience in real world projects. I have worked on Power BI/SQL/Advanced Excel.
On top of that I have also secured the 1st Rank in the Codebasics Resume Challenge #7.
I have shared my Data Analytics projects with their video presentations.
I have helped many of my friends/LinkedIn connections complete their projects as well.

Subjects

  • Power BI Intermediate-Expert

  • DAX Intermediate-Expert

  • Power BI dashboard Intermediate-Expert

  • Data analysis and visualization Intermediate-Expert

  • Excel Advanced Intermediate-Expert

  • SQL Queries Intermediate-Expert

  • Power Pivot, Power BI, Power Query Intermediate-Expert

Experience

  • Business Analyst Intern (Sep, 2023–Dec, 2023) at Atliq Technologies
    Developed a Power BI report for an insurance based client.
    Outperforming & Underperforming Cities: Delhi boasting around 40% in customer & 40% revenue base while Mumbai had only 24% share in both the metrics.
    Focused on Middle-Aged Customers and Online Sales: Customers aged 30-50 contributed 55% of total revenue, while online sales saw exponential growth from 5% to 27%, signaling a lucrative avenue for future profitability.
    Prepared a comprehensive report that contributed to strategic decisions, resulting in a 10% growth of total active users in the next quarter and a 20% revenue increase.
  • Associate Analyst (May, 2022–Jul, 2023) at Concentrix, Gurugram
    Conducted Data Mining and Validation on over 50 uncleaned datasets, followed by the Analysis, Visualization, and Presentation of results to diverse stakeholders.
    Examined a 600MB raw dataset, providing recommendations through Data Auditing, generating Reports using SQL queries, and manual audit processes.
    Utilized various Power BI features such as drill down, drill through, report page tooltips, and more than 10 others to create visually appealing and effective reports that support informed decision-making.
    Developed 10+ Dashboards using advanced features of Power BI like Bookmarks, Selection Panel, Button, etc.
    Mastered in cleaning & verifying data on excel using Pivot tables, VBA and functions like Xlookup, Vlookup,Countif, etc.
    Worked on Manipulating, Cleansing, and Processing data for over 5,000 customers using Python and SQL, leading to a 60-70% enhancement in client relationships and streamlined presentation pointers.

Education

  • M.Tech (Jul, 2017–Oct, 2020) from Integral university Lucknow

Fee details

    ₹500–1,000/hour (US$5.90–11.79/hour)

Reviews

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