Create Advanced Reporting Solutions using Excel and PowerBI for business owners using MYOB Accounting Software.

Setup from scratch entire Human Resources Power BI Reporting Solution.* Extraction process from Aurion Payroll Software.* Storing data in Sharepoint Services* Create Power BI dataflows in Power BI service using Power Query.* Clean data and create data model* Design and Create HR Power BI dashboards.Setup Financial Reporting Systems in Power BI.* Store received financial data in Sharepoint services.* Create Power BI dataflows in Power BI service using Power… Show more Setup from scratch entire Human Resources Power BI Reporting Solution.* Extraction process from Aurion Payroll Software.* Storing data in Sharepoint Services* Create Power BI dataflows in Power BI service using Power Query.* Clean data and create data model* Design and Create HR Power BI dashboards.Setup Financial Reporting Systems in Power BI.* Store received financial data in Sharepoint services.* Create Power BI dataflows in Power BI service using Power Query.* Clean data and create data model* Design and Create Financial Power BI dashboards.Chair weekly meeting with higher level management on HR reporting requirements and progress.Discuss findings in data analysis research.Interview and discuss HR Reporting requirements with both HR and Financial department managers.Conduct one-on-one training for all HR staff on how to use Power BI Dataflows in Excel that have been setup from the Aurion payroll software. Show less

Short Term Project Based RoleSetup Power BI dataflows using Aurion Payroll Data.Setup PowerBI data modelDesign and Create Diversity, Equity and Inclusion Dashboard using Power BI from Dataflows created with Aurion Payroll Data.

Partner with business and technical stakeholders to ensure appropriate governance and utilisation of HR data, leveraging best-practice techniques and methodologies to achieve desired objectives and outcomes.Provide input into the direction for business analysis activities across the organisation, including business process modelling, business and solution requirements lifecycle management and data modelling.Maintaining knowledge of current, new and evolving data and analytics… Show more Partner with business and technical stakeholders to ensure appropriate governance and utilisation of HR data, leveraging best-practice techniques and methodologies to achieve desired objectives and outcomes.Provide input into the direction for business analysis activities across the organisation, including business process modelling, business and solution requirements lifecycle management and data modelling.Maintaining knowledge of current, new and evolving data and analytics enhancements to improve ongoing reporting, analytics, visualizations, and predictive analytics.Review current workforce data and reports and identify areas for improvement in data accuracy, accessibility and self-service offerings and recommend and implement new or modified reporting methods and procedures.Contribute to system, integration, user acceptance and production verification testing cycles by preparing and executing test plans and scripts.Write and optimise complex queries against relational databases and perform analysis across large composite datasets to identify and predict intrinsic workforce issues and challenges.Coordinate and collaborate with functional and technical staff from other organisational areas to identify, investigate and help address data quality issues, analyse data for completeness, address data architecture issues and develop tools and processes to monitor and alert when anomalies in the data are detected.Collaborate in developing and leading training sessions and educational opportunities on metrics, on using data as an analytical tool, and products and service available to help maximise end-user uptake.Collaborate within the department and with other technical specialists, service management stakeholders and relevant subject matter experts to map, document and establish business processes modelling of current, transitional and future states. Show less

• Preparing scheduled weekly, monthly and quarterly reports for a variety of stakeholders.• Gathering business requirements for the development of reports and dashboards.• Analysis of workforce data including attrition, onboarding and offboarding survey feedback,engagement data and safety and claims data to provide insights and recommendations to improveretention.• Ad-hoc reporting and analysis to support business initiatives.• Ensuring data quality and control of… Show more • Preparing scheduled weekly, monthly and quarterly reports for a variety of stakeholders.• Gathering business requirements for the development of reports and dashboards.• Analysis of workforce data including attrition, onboarding and offboarding survey feedback,engagement data and safety and claims data to provide insights and recommendations to improveretention.• Ad-hoc reporting and analysis to support business initiatives.• Ensuring data quality and control of employee and worker information, including working withInformation Services to cleanse data, document definitions and map data sources.• Maintaining reports and dashboards in PowerBI.• Working closely with stakeholders in People and Culture teams, Information Services andoperational managers to deliver timely scheduled reports.• Rewrite existing manual processes using PowerQuery, M Code, DAX and PowerBI Data Flows for complete automation.• Investigate and report to management on current data systems / data collections and provide improvement advice on ways to save staff time and improve performance/quality of reports. Show less

• Manage and improve Sunwaters’ Health, Safety and Environment PowerBI performance reporting.• Work closely with business leaders to identify and understand Health and Safety trends and insights.• Create Health, Safety and Environment Business Data Model.• Review and monitor the consistency of data entry quality and reporting.• Contribute PowerBI reports and essential KPI’s for use in the Monthly Executive and Board Reports.• Work with external parties to obtain additional… Show more • Manage and improve Sunwaters’ Health, Safety and Environment PowerBI performance reporting.• Work closely with business leaders to identify and understand Health and Safety trends and insights.• Create Health, Safety and Environment Business Data Model.• Review and monitor the consistency of data entry quality and reporting.• Contribute PowerBI reports and essential KPI’s for use in the Monthly Executive and Board Reports.• Work with external parties to obtain additional manual data for reports.• Work with EDAS in scoping data requirements and defining system wide measures for New Sunwater Data Gateway.• MYOSH system development and auditing. • Provide MYOSH support/training to HSE staff.• Work with MYOSH support to resolve MYOSH software faults/bugs and develop alternative options for Sunwater staff while issues are rectified. Show less