Introduction to Health and Safety Data Analysis with Power BI Course
Microsoft Power BI is the world's leading data analytics and business intelligence tool. Next-Step Consultores, for more than 10 years we have been developing data analysis and business intelligence and imparting training for individuals and companies about this technology. We have just launched this specific course for responsible for health and safety, occupational health and safety, occupational risk prevention, ORP and HRThe course, which will be given next October remotely, in real time via streaming.
Those attending this introductory course to Power BI They will learn how to connect to hundreds of data sources, prepare and transform data easily and generate customised analyses, with which they will be able to create interactive reports that will help them make the best decisions.
Advantages of the course:
- Specialised course in Health and Safety Data Analysis, with specific examples and case studies.
- Online course via streaming. You can take the course remotely, in real time via streaming and you can interact with the teacher and ask your questions as if you were in person..
- It uses a platform in which the teacher, in an entirely different way safe and controlledcan take control of your computer to help you if you get stuck with an exercise.
- All the documentation and exercises can be downloaded from the website training centre set up for this purpose.
- The classes are recorded and made accessible on a websiteThe course is a one-year course, so you can review and consolidate your knowledge as often as you need to.
Who the course is aimed at:
Some of the professionals targeted by the course are:
–Health and Safety at Work Area Professionals
-Prevention Service Managers
-Data Scientist and Data Managers
-IT managers
-HR managers.
–Professionals who need to make decisions based on their security data.
Course content:
Introduction. General Business Intelligence Concepts
There will be a brief introduction to the basic concepts of business intelligence, in order to be able to understand the rest of the points on the syllabus.
- Extraction and Transformation Module
This section will explain to the user how to obtain and transform data from different sources (Excel, databases, flat files, web pages, data in the cloud, etc.) and how to automate the data transformation with Power Query. Different examples of data extraction and transformation will be performed covering the broad functional spectrum.
- Modelling Module. The student will learn how to create an incident analysis model, being able to combine it with other information such as hours worked, and obtaining indicators such as frequency rate, severity, days lost and incidence, learning the necessary basic concepts of Power BI:
– Creating Models in Power BI
You will learn the basic rules to be able to relate the different tables with each other, as well as the fundamentals for building a good model.
– Calculated Fields and DAX Expressions
In this section the user will learn how to construct calculated fields, using different functions necessary to construct the most commonly used indicators.
– Time intelligence functions (cumulative year, variation compared to the same period of the previous year, etc.).
- Elaboration of KPI's
The user will acquire the necessary skills to produce and report on key indicators, with their various display options.
- Quick measures
- Visualisation Module
- Interactive Visualisation. Build interactive graphs, cross-filters, full filters and drill-down analysis.
- Custom visualisations. The range of graphical possibilities that Power BI incorporates is immense. Learn how to include powerful custom charts, such as the KPI with history.
- Geo-visualisation.
- Viewing reports on mobile devices.
- Markers and buttons
- Power BI.com module
- Automatic data publishing and refreshing. Learn how to automate data refresh directly from Power BI.
- Collaboration. Share the reports you create in Power BI or publish them on the web or intranet.
- Connecting Excel to Power BI. Connect your Excel file to Power BI and analyse millions of data with spectacular performance.
Calendar, Timetable and Price
Calendar and timetable:
- 7th, 9th, 14th, 16th, 21st and 23rd November 2023
- Tuesday and Thursday afternoons, from 16.00 to 19:00 hours
Price:
- Course 100 %, with FUNDAE bonus
- General price: 390 €.
- 10% Early Registration Discount
- Ask for group discounts
Register now! Places are limited:
Registration for the Data Entry Course with Power BI
We are waiting for you!
If you have any doubts, or if you prefer training tailored to the needs of your company, contact us and we will inform you: