ARFAN S.

Power BI Expert | Data Analyst | Financial Analyst | Investment & Portfolio Analyst | Econometrics | Stata | SPSS | Excel I am a Power BI Expert, Data Analyst, Financial Analyst, and Investment & Portfolio Analyst with 17+ years of professional experience in Data Analytics, Business Intelligence, Economics, Finance, Econometrics, Statistical Analysis, Research, and Teaching. I help businesses, investors, researchers, and organizations transform raw data into interactive dashboards, financial models, optimized investment portfolios, econometric models, and actionable insights. My core services include Power BI dashboard development, Excel financial modeling, investment and portfolio analysis, statistical analysis, econometric modeling, data visualization, research analysis, and business intelligence reporting. POWER BI & BUSINESS INTELLIGENCE • Interactive Power BI Dashboards and Executive Dashboards • Business Intelligence and Management Reporting • KPI Dashboards and Performance Tracking • DAX Measures and Calculated Columns • Power Query and Data Transformation • Data Modeling and Table Relationships • Star Schema and Data Model Optimization • Drill Through and Interactive Reports • Row Level Security, RLS • Power BI Service and Report Server • Data Cleaning, ETL, and Report Automation • Financial, Sales, Operations, and Management Dashboards DATA ANALYSIS & ADVANCED EXCEL • Advanced Excel and Financial Modeling • Power Query and Power Pivot • Pivot Tables and Pivot Charts • XLOOKUP, VLOOKUP, INDEX MATCH, and Advanced Formulas • Excel Dashboards and Automated Reports • Data Cleaning, Transformation, and Validation • KPI Analysis and Performance Reporting • Scenario and Sensitivity Analysis INVESTMENT & PORTFOLIO ANALYSIS • Investment Portfolio Construction and Management • Portfolio Optimization and Performance Evaluation • Modern Portfolio Theory and Markowitz Optimization • Asset Allocation, Security Selection, and Diversification • Portfolio Rebalancing and Risk Management • Efficient Frontier and Tangency Portfolio • Capital Allocation Line, CAL • Capital Market Line, CML • Security Market Line, SML • CAPM, Beta, Alpha, and Expected Return • Sharpe Ratio, Treynor Ratio, Sortino Ratio, and Jensen's Alpha • Value at Risk, VaR, and Expected Shortfall • Risk and Return Analysis • Optimal Portfolio Weights using Excel Solver • Portfolio Tracking and Investment Dashboards • Customized Portfolio Analysis from 2 to 50+ Securities FINANCIAL ANALYSIS & CORPORATE FINANCE • Financial Statement Preparation and Analysis • Income Statement, Balance Sheet, and Cash Flow Statement • Financial Modeling and Forecasting • Capital Budgeting and Investment Decisions • NPV, IRR, Payback Period, and Profitability Index • Corporate Finance and Financial Management • Investment Decision Modeling • Scenario and Sensitivity Analysis • Financial Performance and Ratio Analysis ECONOMETRICS & STATISTICAL ANALYSIS • Panel Data, Time Series, and Cross Sectional Analysis • OLS and Multiple Regression Analysis • Fixed Effects and Random Effects Models • Dynamic Panel Data and GMM • Instrumental Variables, IV Regression • Difference in Differences, DiD • Event Study Analysis • VAR and VECM Models • ARDL and Cointegration Analysis • Granger Causality • ARCH and GARCH Models • Forecasting and Econometric Modeling STATISTICAL METHODS • Descriptive and Inferential Statistics • Correlation and Regression Analysis • T Tests and Chi Square Tests • ANOVA, MANOVA, and ANCOVA • CFA and EFA • Structural Equation Modeling, SEM • PLS SEM • Mediation and Moderation Analysis • Kruskal Wallis and Friedman Tests • Wilcoxon and McNemar Tests • Survival Analysis SOFTWARE & ANALYTICS TOOLS • Power BI • Microsoft Excel • Stata 18 and Stata 17 • SPSS • R and RStudio • EViews • Tableau • Gretl • Power Query • Power Pivot ECONOMICS & FINANCE EXPERTISE • Financial Economics • Investment and Portfolio Management • Corporate Finance • Financial Management • Microeconomics and Macroeconomics • International Economics • Mathematical Economics • Applied Econometrics RESEARCH & ACADEMIC DATA ANALYSIS I support researchers and postgraduate students with quantitative research and statistical analysis, including: • Research Methodology and Econometric Model Development • Secondary Data Collection • Data Cleaning and Preparation • Statistical and Econometric Analysis • Results Interpretation • Tables, Graphs, and Data Visualization • Thesis and Dissertation Data Analysis • Research Paper Analysis • APA Formatting and Academic Presentation I have published research in international academic journals, including research on cryptocurrency and portfolio risk diversification: "Impact of Crypto Assets as Risk Diversifiers: A VAR-based Analysis of Portfolio Risk Reduction." I also have experience working with large secondary datasets from sources including the World Bank, IMF, OECD, and United Nations.