كامران خان

reporting using Power BI and Advance Excel and Data transformation Using Power Query and Data molding Power Pivot cloud base
Present Business-Related Dashboard and report Business strategy Like Comparison between Year to Month and Month To year Forecasting Related business Inventory transaction and Sales Related Report Reporting using Power BI and Advance Excel and Data transformation Using Power Query and Data molding Power Pivot cloud base Present Business-Related Dashboard and report Business strategy Like Comparison between Year to Month and Month To year Forecasting Related business Inventory transaction and Sales Related Report
•
o Skills: Data Analysis · Business Planning · Business Strategy · advance excel · Microsoft Power Query · Business Intelligence (BI) · Microsoft Power BI

• Have knowledge in Advance Microsoft Excel-365, Pivot table Power Pivot
• And Complex Excel Formulas creating dynamically Reports
• Using Power bi connect with SQl Server creating analysis- matrix dashboard and visualization using Advance Dax, and time intelligence function
• For data transformation/ data cleansing using ETL Power Query
• And for data modeling having knowledge in Star schema and snow flex
• Using Sql for retrieving Record from Database, insert update and modify and where cluse and many more function
• Creating reports summary report Like, Region wise, branch wise, sales performance, sale contribution report, performance report related to Salesman, branch, region
• Cost of good revenue and, inventory analysis and forecasting with historical data
• And many more as per management requirement

Data Analyst

Preparing KPI Releated to Warranty Analysis Trending Automotive Sales after Sales Ratio trending
Market share growth YOY comparsion
MTD YTD comparsion using Advance Excel Formulas power Query & Pivot Table

They are dealing Lubrication Product, Castrol, Caltex, Gulf lubricants, Master Oil, Shell.
Looking all distribution operation collecting Order, Dispatching, Prepare the Sale invoice, Receive Voucher, Purchase Invoice, Paid Voucher, Reconciliation the customer & vendor Ledger, Check the Stock inventory Weekly base. Item Issue, Item receipt,

They are dealing Lubrication Product, Castrol, Caltex, Gulf lubricants, Master Oil, Shell.
Looking all distribution operation collecting Order, Dispatching, Prepare the Sale invoice, Receive Voucher, Purchase Invoice, Paid Voucher, Reconciliation the customer & vendor Ledger, Check the Stock inventory Weekly base. Item Issue, Item receipt,