Data Analysis - using Tableau and Power BI to conduct commercial performance analysis searching for trends, gaps, root causes and opportunities for improvements.
Data Visualisation - consolidating and presenting commercial performance data reports including charts, graphs and tables.
Datamodelling - importing, cleansing, validating and analysing data.
Maintaining and developing data capture templates.
Maintaining databases in MS Access, MS Excel.
Analysis and presentation of performance data, including charting techniques in Excel and Tableau.
Developing our analytical and data visualisation capability.
Creating ad-hoc analyses when required, using experience and knowledge to build bespoke files based on requirements.
Integration activity (ETL) using Azure Data Factory. Connecting multiple data sources to our Data warehouse and integration into the data model Help develop the BI Solution Architecture, Replication Warehouse and secure data sets using the Microsoft application stack.
Database management in data warehouses and data lakes for consolidation of client systems and data Problem solving, data validation and interpretation of findings.
Identify areas to increase efficiency and automate processes.
Set up and maintain automated reporting and processes.
Identify ways to increase profit.
Optimize operations.
Track performance.
Uncover any problems.
Predict success.
Compare data with competitors.