Business Intelligence Consultant
Rawcliffe, United Kingdom
Dan has developed a broad toolkit of skills and has extensive knowledge of a range of applications, technical languages and methods applied in the Business Intelligence and Analytics field, including;
> SQL (MS SQL, MYSQL, ORACLE, PostgreSQL)
> POWER BI
> ADVANCED EXCEL
> MS ACCESS
> DATA VISUALISATION
> PROJECT MANAGEMENT
Dan has a keen eye for UI/UX best practice within analytics and is aware through experience, that this is the key to user engagement. Dan regularly keeps abreast of articles, trends and industry publications on Data Visualisation, Data Science and best practice within the field.
Through exposure in a wide range of roles, Dan has developed a solid soft skill set including; excellent attention to detail and strong interpersonal and communication skills with the ability to convey technical subjects to non-technical stakeholders. Dan has excellent stakeholder management skills and remains composed during challenging situations.
Dan has sound influencing and negotiation skills, and, as a result of having a blend of strong technical skills and business acumen, quickly builds credibility and engagement with new teams and colleagues. Dan has honed a confident and articulate presentation style, particularly through his consulting work.
to a range of ERP systems, databases and other such technologies for data collection, cleansing and validation. Core
responsibilities centred around the ownership of the development lifecycle for a suite of BI reports, largely within Tableau. Prior
to the BI development phase was an extensive period of data preparation and analysis using a range of tools, including; MS
Excel, Access, Alteryx, Python & SQL. The final deliverable saw the development of a wide variety of modelling, reporting and data analysis, published into a robust BI suite. Dan frequently played a critical role as "the" technical member of a non-technical
cross functional team, for both client facing and internal subject matters.
KPI's as well as the development of new analytical insights specifically around service level performance and client retention.
Overhauled company reporting from manual, Excel/PowerPoint basis, to an automated BI suite within the MS Power BI
including distribution to an extended user base. The project involved ownership of the end to end solution development, with complex data transformations in MS SQL and the creation of a variety of measures in DAX.
VMO PARTNERS, SEATTLE, WA - served as a Virtual Campaign Analyst (contractor) for VMO for a period of 18 months, while in parallel; developed a bespoke performance reporting, modelling and dashboard solution in Tableau. Incorporated structured,
unstructured and disparate client data, as well as contextual US census Bureau data, into a SQL data warehouse in Postgres.
Tableau development comprised three separate outputs, and over 300 unique Tableau views. Solution was later developed into a proprietary SaaS product and spin-off company, Remarkably.io.
APPLIED INSPIRATION (AI), CIRENCESTER, UK - focused in the Higher Education consultancy sector, Dan developed a sophisticated
data model, incorporating various statistical and analytical techniques in Excel, using HESA data. Building upon this, a Tableau
solution produced a single, uniform output but featured various parameters and other such advanced features to enable
In addition to the three above, Dan has successfully collaborated with tens of clients across a broad geographic spectrum,
diverse range of industries, and organisation types; from Start-ups & SMEs through to large global corporates. Undertaking a
range of projects including; data analysis, reporting, modelling, database development and the implementation of BI solutions.
PI, in order to present business users with a multi-layered, automated view of Cost of Losses and Operating Efficiency.
Underpinning the BI development work was a comprehensive data validation phase which engaged key stakeholders as
part of a cross functional team.
performance and seasonality analysis. BBRG used many legacy systems and as such there was a heavy emphasis on the use and
development of MS Excel and Access solutions for much of the analysis work. Key achievements at BBRG; (1) As part of the digital transformation; end to end scoping, development and roll out of a suite of automated Power BI dashboards and reports.
(2) Optimisation of price and lead time matrix - an in-house tool developed to aid quote turnaround. (3) Development of automated OTIF reporting.
cross functional collaboration on projects such as automation of product level forecasting, promotional forecasting, and new
product introduction strategies. Heavy retail analysis using Tableau, Crystal Reports and developing ad-hoc, complex SQL
queries providing insight on specific C-level business questions. Additional areas of responsibility included; category and range
development, end to end strategic sourcing including; extensive analysis of the company spend portfolio, and the supply
landscape, defining 'best fit' sourcing strategies and conducting direct negotiations as part of the RFX process. Achieved c.£2.7m
annualised cost savings in 2016, on direct spend, through negotiated price reductions, resourcing and/or value engineering.
Reports, and within MS Excel; advanced formulas, macros/VBA, data modelling, pivot tables.
Bachelors, Business Studies
Contact Dan Blyth
Worksome removes the expensive intermediaries and gives you direct contact with relevant talents.
Create a login and get the opportunity to write to Dan directly in Worksome.
33600+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled freelancers in Denmark