Jayesh Dhokia Email & Phone Number

London, England, United Kingdom

Power Bi – Visualising and Reporting refreshable data. Using Power Query to connect and transform various data sources including Public APIs, Government data sources, SharePoint files and Microsoft SQL Server. Requirements gathering from various teams across the company to inform report design. Seeking feedback to improve reports. Programming in DAX.Power apps / Power automate – Creating bespoke digital solutions to improve ways of working across different projects. Management of the… Show more Power Bi – Visualising and Reporting refreshable data. Using Power Query to connect and transform various data sources including Public APIs, Government data sources, SharePoint files and Microsoft SQL Server. Requirements gathering from various teams across the company to inform report design. Seeking feedback to improve reports. Programming in DAX.Power apps / Power automate – Creating bespoke digital solutions to improve ways of working across different projects. Management of the automation and creation of processes to help organise and give visibility to work within the team.Microsoft Azure – Managing the company’s ETL solution. Connecting to data and creating pipelines through Azure data factory and deployment of Azure functions from python.Microsoft SQL server – Managing users, views, stored procedures, using management studio to write SQL queries and transform data.Python – connecting to various data sources and API’s, looping through and transforming data, uploading or exporting data.Google Analytics – Connecting and extracting data from google analytics 4 and google big query. Times Top 50 – Creation and design of the assessment process. Data modelling: scoring and ranking.The Responsible Business Tracker – Responsible for the end-to-end process of assessment and scoring. Creation and design of the assessment process.Tableau – Visualisation and analysis of Knowledge Exchanges and Consultancy projects. Writing reports in Microsoft Word and Microsoft PowerPoint. Presenting and explaining the results to internal stakeholdersSurvey design – Creating surveys using online platforms. Requirements gathering, evaluation and editing survey design with collaboration from stakeholders. Implementation of best practice in design and process. Writing HTML to create survey invitation email.Insight requests - In charge of delivering and managinig bespoke business requests Show less

Edinburgh, United Kingdom

Using R/R-Studio for statistical analysis on data, creating clean R-scripts so my work can be verified, creating visuals and graphs, downloading/installing packages for ease of use.Programming regression analysis with Microsoft excel to help create a mathematical model using real time data. Using Microsoft access (SQL) to implement a probabilistic mathematical model on a large database of over 2 million entries, while learning how to use SQL.Knowledge of Microsoft… Show more Using R/R-Studio for statistical analysis on data, creating clean R-scripts so my work can be verified, creating visuals and graphs, downloading/installing packages for ease of use.Programming regression analysis with Microsoft excel to help create a mathematical model using real time data. Using Microsoft access (SQL) to implement a probabilistic mathematical model on a large database of over 2 million entries, while learning how to use SQL.Knowledge of Microsoft SharePoint to upload and manage data on an online database. Linking the Microsoft SharePoint data to Microsoft PowerBI, to create reproducible and updatable graphs.Knowledge of ARC-GIS (SQL focused on location-based queries). Implementing a company wide solution linking ARC-GIS to R/R-studio with a GitHub script, which meant analysts could pull data directly from ARC-GIS geodatabases into R to do statistical analysis. Show less

Edinburgh

Helping students understand theory taught to them in lectures in order to lead them into the solutions of the problems they were struggling with.