AFZALA TC

Developing comprehensive dashboards for a contracting company, leveraging Power BI to enhance business insights and decision-making.
Extracted data from Tally software, loaded it into SQL Server, and developed Power BI reports using SQL queries.
Automated the Power BI reports using batch files for seamless updates and insights.
Analysing sales data to track performance and identify trends.
Monitoring purchasing activities, payment cycles, and expense management.
Classifying sales by product or service categories for a detailed breakdown.
Assessing customer behaviours, segmenting by various factors for improved targeting.

Developing comprehensive dashboards for a contracting company, leveraging Power BI to enhance business insights and decision-making., Extracted data from Tally software, loaded it into SQL Server, and developed Power BI reports using SQL queries., Automated the Power BI reports using batch files for seamless updates and insights., Analysing sales data to track performance and identify trends., Monitoring purchasing activities, payment cycles, and expense management., Classifying sales by product or service categories for a detailed breakdown., Assessing customer behaviours, segmenting by various factors for improved targeting.

Developed an interactive dashboard to analyse data trends for management review at a cargo shipment company.
Utilized Microsoft Excel data, performing ETL (Extract, Transform, Load) processes to Power BI for dynamic reporting.
Visualized shipment data on a map to identify high-performing regions.
Tracked total collections, expenses, and credit balances, improving financial oversight.
Monitored stock and sales trends of different carton types.
Delivered insights on top expenses, category-wise breakdowns, and day-wise trends.
Assessed staff performance through sales data, total pickups, and day-wise pickup analysis.
Developed salary reports with commission-based calculations, streamlining payroll processes.

Developed an interactive dashboard to analyse data trends for management review at a cargo shipment company., Utilized Microsoft Excel data, performing ETL (Extract, Transform, Load) processes to Power BI for dynamic reporting., Visualized shipment data on a map to identify high-performing regions., Tracked total collections, expenses, and credit balances, improving financial oversight., Monitored stock and sales trends of different carton types., Delivered insights on top expenses, category-wise breakdowns, and day-wise trends., Assessed staff performance through sales data, total pickups, and day-wise pickup analysis., Developed salary reports with commission-based calculations, streamlining payroll processes.

Developing Power BI reports, dashboards, and data models to provide data insights to business users, ensuring alignment with organizational goals and objectives.
Collaborating with business analysts and data engineers to identify data needs and develop ETL processes, facilitating seamless data integration and analysis.
Gathering data from various sources, including databases, spreadsheets, APIs, and other data repositories.
Analyzing large datasets using statistical and data analysis techniques.
Identify patterns, trends, and insights to help make informed business decisions.
Creating various charts and custom visualizations using Power BI, optimizing the visual experience and performance for enhanced user engagement, and understanding.
Designing, developing, and maintaining complex SQL queries and stored procedures, enabling efficient data retrieval and analysis for informed decision-making.
Working on projects for data insights, including financial reporting and operational performance tracking, contributing to the overall success of the organization.

Developing Power BI reports, dashboards, and data models to provide data insights to business users, ensuring alignment with organizational goals and objectives., Collaborating with business analysts and data engineers to identify data needs and develop ETL processes, facilitating seamless data integration and analysis., Gathering data from various sources, including databases, spreadsheets, APIs, and other data repositories, Analyzing large datasets using statistical and data analysis techniques. Identify patterns, trends, and insights to help make informed business decisions., Creating various charts and custom visualizations using Power BI, optimizing the visual experience and performance for enhanced user engagement, and understanding., Designing, developing, and maintaining complex SQL queries and stored procedures, enabling efficient data retrieval and analysis for informed decision-making., Working on projects for data insights, including financial reporting and operational performance tracking, contributing to the overall success of the organization.