Warren Dean

Co-Founder

Melbourne, Victoria, Australia16 yrs experience

AI ML PractitionerAI Enabled

Key Highlights

15 years of experience in government data analysis.
Trained over 2,100 people in Power BI.
Founded the Victorian Local Government BI Meetup.

Stackforce AI infers this person is a Government-focused Power BI specialist with extensive training and consulting experience.

Contact

Skills

Core Skills

Power BiData Analysis

Other Skills

Power BI TrainingConsultingReport/Dashboard creationSelf-service EnablementTrainingCoachingGoogle AnalyticsBusiness IntelligenceCommunity DevelopmentAnalytics ProjectsAIMachine LearningBig DataStatistical AnalysisStatistics

About

Connect with Warren at DataTale.com.au Examples of my work are available here: https://datatale.com.au/pbi_gallery/ Examples of my clients are available here: https://datatale.com.au/clients/ Youtube content: youtube.com/c/DataTaleAU Warren Dean is a Power BI specialist, skilled in understanding government reporting requirements, building strong Power BI user communities and has expertise in Power BI report development. Warren has 15 years’ experience as a data analyst in government roles, previously leading the analytics function at the City of Casey. He also founded the Victorian Local Government BI Meetup and has spoken at multiple events and conferences across the world. He is a Microsoft Certified Trainer (MCT) and also Certified Power BI developer and has trained over 2,100 people in Power BI from over 50 government agencies and top 200 ASX. His company DataTale is a Microsoft Partner that provides Power BI training, consultation and support.

Experience

16 yrs

Total Experience

3 yrs

Average Tenure

Current Experience

Im systems

Senior Power BI Architect

Dec 2021 – Aug 2023 · 1 yr 8 mos · Australia · Hybrid

Responsible for developing, supporting and implementing business intelligence solutions using Power BI.

Business IntelligencePower BI

Newcrest mining

Power BI Trainer & Community Development

Mar 2020 – Jun 2023 · 3 yrs 3 mos · Melbourne, Victoria, Australia

Power BI training, self-service dataset training, course development, mentoring, creating a Power BI community and running events.

Power BI TrainingCommunity DevelopmentPower BI

Datatale

Founder

Feb 2019 – Present · 7 yrs 3 mos · Melbourne, Australia

Power BI Training, Consulting, Report/Dashboard creation, Self-service Enablement for the Government Sector.
Clients:
Newcrest Mining: Power BI Training, Coaching and Self Service enablement via Meetups, Release Updates and Data Culture
Glenelg Council - Google Analytics Report in Power BI
Greater Geelong Council - Engineering Power BI Report
Vic & NT Hockey - Analytics on Player distribution by division for restructure.
Darebin City Council - City Works Power BI report containing Waste Operations, Fleet Services and Infrastructure Maintenance.
CAB Plumbing: Work order reporting
Ballarat City Council: Data-driven decision making in Local Government PD's
Victorian Ombudsman: Customised Viewer and Beginner Power BI training and development
Moreland City Council: Social Planning Power BI Report with Mapbox
Glen Eira City Council: Digital Uptake Power BI Report
Portable Long Service Authority: Touchpoint and CRM reporting
Manningham City Council: HR Power BI Report from Chris21, Asset Dashboard POC
Freight People: POS Reporting using Power BI and Azure B2B for client access
Delaware North at Marvel Stadium: POS Reporting from DWH and customised training
Telstra Business Centre - Casey and Cardinia: POS & People Counter Reporting in Power BI
SocioLogic: Power BI reports using Mapbox for client access
Training:
Government - Over 500 people
Corporate - Over 1000 people

Power BI TrainingConsultingReport/Dashboard creationSelf-service EnablementPower BIData Analysis

Multiple

List of Speaking Engagements

Oct 2017 – Mar 2021 · 3 yrs 5 mos

2026 Mar - Civica Connect Sydney
2026 Feb - Civica Connect Melbourne
2021 May - Digital Innovation & Smart Agriculture Festival
2021 Feb - Smart Cities Virtual Conference
2020 Oct - Portland Power BI User Group
2020 Sep - Wellington Power BI User Group
2020 Aug - Berlin Power BI User Group
2020 July - Resagratia - Lunch & Learn Series (Nigeria)
2020 June - Agile Analytics - Lunch & Learn Series (Sydney)
2020 June - Manchester Power BI User Group - Lunch & Learn Series (UK)
2020 Jan - South East Water - Power BI Meetup
2019 Oct - To Infinity and Beyond (LGITSA)
2019 Aug - Microsoft Business Applications Summit Melbourne
2019 Jul - LinkedIn Local Casey
2019 Jun - TechX Cardinia
2019 Jun - Social Infrastructure Planners Forum (LGPRO)
2019 Mar - Riding the Wave (MAV)
2019 Feb - 10th Digital RIM Summit
2018 Dec - Melbourne Power BI User Group
2018 Dec - Datalicious (MAV)
2018 Oct - 11th Social Media for GOV Summit
2018 Oct - LGPRO - Corporate Planners Network Conference
2018 Sep - Zurich Power BI User Group
2018 Jun - Shared Services and Outsourcing Week in Melbourne (SSOW)
2018 May - Mayors Business Leaders Dinner (City of Casey)
2018 May - Local Government Transformation Series 2018 (KPMG)
2018 May - Innovation Series with Melbourne Football Club (City of Casey)
2018 Mar - Big Data & Analytics Summit Melbourne (Innovation Enterprise)
2017 Oct - National Local Government Infrastructure & Asset Management Conference (MAV)

City of casey

Senior Data Analyst

May 2017 – Apr 2020 · 2 yrs 11 mos

Lead the Analytics function.
Part of the team awarded the Victorian I-Award for AI or ML innovation of the year in 2018.
Founded the Local Gov BI Meetup, 6 events, 150 people and approximately 40 councils collaborating.
Spoke at many conferences and events.
Delivering over 100 analytics projects in Power BI on the following datasets:
Active Directory, Aged Care, Assets, Bin Contamination, Bin Requests, Building Permits, Capital Works, Census, Claims, Contractor Usage, Corporate Planning, Crash Stats, Crime Stats, Customer Experience, Customer Service Call Times, Direct Care Workers, Dumped Rubbish, Engagement Strategy, Facebook, Finance, Fleet, Footpaths, Function Attendees Postcodes, Google Analytics, Graffiti, Hard Waste, Here Mapping Data, Homelessness, Kepler People Sensors, Kindergarten, Kindergarten Relief Teachers, Lots, MailChimp, Maternal Child Health, Meeting Room Utilisation, Myki, MyPrint, New Dwellings, Online Forms, Population Forecasts, Public Transport Data, School Crossings, SEIFA, Serraview Utilisation, Service Desk Ticketing, Service Planning, Service Reviews, Smart Parking, Stats Planning, Surveys, Trees, Twitter, Water Assets, Youth Services, ServiceNow, Rates, Animal Registrations, ABN.

Data AnalysisAnalytics Projects

Department of justice

Technical Data Analyst

Jul 2013 – Apr 2017 · 3 yrs 9 mos · Melbourne, Australia

Completed Big data proof of concept, development in R and Hive
Completed research document that resulted in dramatic improvement on ANPR system
Automate processes for data extraction, collation, processing & analysis
Responsible for ensuring high levels of reporting availability through support
functions and in-depth testing
Production and recording of weekly, monthly, quarterly and annual reports
Enhance existing reports, applications and data warehouse systems as per business requirements
Validation & data cleansing of Data Warehouse
Provide quality client service (internal/external)
High-level analyses & investigations used for publications, media requests and various government websites
Assist with monitoring Contractors’ performance by conducting quantitative
and qualitative analysis on large data sets

Big DataData Analysis

Victorian curriculum and assessment authority

2 roles

Senior Data Analyst

Promoted

Jan 2008 – Jun 2013 · 5 yrs 5 mos · Melbourne, Australia

Analysis, interpretation, reporting, manipulation of psychometric data (NAPLAN, VCE)
Develop and perform testing, improvements and changes of NAPLAN code and macros in SPSS.
Problem solving of various requests from VCAA to provide statistical information. Involving SQL queries to extract information, then SPSS/Excel/Access manipulation and analysis.
Developing code, technical documentation to enable the extraction and manipulation of data for entry into Oracle database via SPSS/Excel for maintenance and improvements.
Taught approximately 20 teachers for professional development 'Turning information into data' sessions.

Data AnalysisStatistical Analysis

Administration Support Officer

Jan 2005 – Jan 2007 · 2 yrs · Melbourne

MS Access, MS Excel, UAT, Oracle SQL

Database ManagementStatistics

Department of education and early childhood development, victoria, australia

Management Information Systems Officer

Jan 2007 – Jan 2008 · 1 yr · Melbourne, Australia

Providing statistics to The Department of Education and other departments within the Government in regards to Victorian International Students.
Managed MS Access database for reporting.

StatisticsDatabase Management