We have 10+ years specialising in analysing company data and presenting business insights using visualisation tools.
Creating dashboard reports showcasing how your business's KPI is currently performing or producing historical/investigative analysis to find trends and improve business processes.
As senior consultants, we understand the key performance areas across various industries including marketing, finance, retail, healthcare, government, insurance and hospitality industries.
Data Analysis & Visualizations - over ten years experience working with various software solutions to analyse databases, create reporting queries and developing dashboards (including MSSQL, Azure, SSRS, SSAS, SSIS, Tableau and Power BI).
• Leading workshops to create project requirements and refinement with stakeholders based worldwide
• Design of ETL scripts to facilitate data quality control for various client’s data sources and KPI
• Creation of ETL process across Python, Redshift, Lambda, S3, QlikSense, Power BI and custom API scheduler
• Writing of complex stored procedures to calculate conditional and hierarchical KPI
• Analysing trends of customer product usage to determine client specific KPI
thg 8 2016 - thg 1 2017 (5 tháng, 1 ngày)
• Design and built cube to support end user requirements
• Create cube structure and data hierarchies using MDX (SSAS)
• Designing Report Content in SSRS
• Validating and disseminating reports in the correct format to strict deadlines
• Managing Report User Acceptance testing and reporting cycles
• Additional dashboard/report refinement and development
Lead BI Developer
National Institute of Health Research – Leeds University
thg 9 2014 - thg 7 2015 (10 tháng, 1 ngày)
•Developed BI solution within an Agile Scrum Environment using SQL Server (2008R2), SSIS, SSRS, QlikView and Power BI
• Extensive profiling to determine data integrity
• Developed complex packages and workflows to facilitate ETL
• Staging database developed for data cleansing and data standardisation
• SSIS package developed to deal with all data cleansing, isolating duplicates and invalid records, standardisation of data-types and formats
Leeds Metropolitan University, United Kingdom 1997 - 2000
Securities & Investment Institute Securities Certificate
Financial Regulation/ Principles of Financial Regulation
Liên hệ Depicting Data về công việc của bạn
Đăng nhập để trao đổi thông tin chi tiết thông qua chat.
Freelancer Ưa Thích
Đã Xác Thực Danh Tính
Đã Xác Thực Thanh Toán
Đã Xác Thực Điện Thoại
Đã Xác Thực Email
Đã Kết Nối Facebook
Preferred Freelancer Program SLA 1 92% SQL 1 85% US English 1 85%