Banner Image

All Services

Engineering & Architecture

Analysis

$15/hr Starting at $25

Rich and insightful experience of 5+ years in Advance Excel, VBA Macros, Reporting & Report Automation, Data Manipulation & Analysis, SQL Server, Sap scripting, and Power BI etc. • Good understanding of data modelling and data ware house concepts. • Hands on creating SQL views based on data warehouse that meets business requirements. • Skilled in optimizing the SQL queries. • Analyze data from various sources, including database and flat files. • Efficient to build dynamic reports and dashboard. • Strong working knowledge of Excel as used in analytics/dashboards • Create basic visualization using charts and graphs in excel. • Able to do logical checks on the dashboard and conduct a thorough test plan to test the tool. • Able to guide and help other team members in developing dashboard through VBA codes • I prepare interactive dashboard from the prototype. • Reporting & Report Automation. • Automation using Sap Scripting. • Strong Knowledge on Power BI to import data from various sources such as SQL Server, Azure SQL DB, SQL Server Analysis Services (Tabular Model), MS Excel etc.

About

$15/hr Ongoing

Download Resume

Rich and insightful experience of 5+ years in Advance Excel, VBA Macros, Reporting & Report Automation, Data Manipulation & Analysis, SQL Server, Sap scripting, and Power BI etc. • Good understanding of data modelling and data ware house concepts. • Hands on creating SQL views based on data warehouse that meets business requirements. • Skilled in optimizing the SQL queries. • Analyze data from various sources, including database and flat files. • Efficient to build dynamic reports and dashboard. • Strong working knowledge of Excel as used in analytics/dashboards • Create basic visualization using charts and graphs in excel. • Able to do logical checks on the dashboard and conduct a thorough test plan to test the tool. • Able to guide and help other team members in developing dashboard through VBA codes • I prepare interactive dashboard from the prototype. • Reporting & Report Automation. • Automation using Sap Scripting. • Strong Knowledge on Power BI to import data from various sources such as SQL Server, Azure SQL DB, SQL Server Analysis Services (Tabular Model), MS Excel etc.

Skills & Expertise

AnalyticsExcelGraphsMicrosoftPower BIReportsSAPSapscriptSQLTableauVBAVBScriptVisual Basic

0 Reviews

This Freelancer has not received any feedback.