SKILLS AND TRAININGS

Business Intelligence and Business Analytics for Strategic Development

Date

November 28 from 9:00 AM to 13:00 AM and 29 December 3 and 10, from 14:00 PM to 18:00 PM
Supply Partner
Made
Participants
20

Duration

16 hours

Delivery method

Online

Cost

€ 1100 + IVA for partecipant
Who is it aimed at?
SME Entrepreneurs, Managers, HR Managers

Goals

This course aims to develop appropriate skills in Business Intelligence (BI) methods and procedures for utilizing company data, enabling multidimensional and multi-level performance monitoring. It provides expertise on BI techniques and functionalities of integrated ERP information systems for control and strategic and operational decision-making, based on preventive and predictive analyses of management data available to the company. Additionally, the course illustrates Business Analytics methods for predictive analysis that integrates BI functionalities with data from online sources, such as Open Data and Big Data.
Contents

• Introduction to Power BI
• Connecting to data sources
• Data preparation operations in Power Query
• Model creation: difference between imported data and Direct Query
• Table relationships
• Date dimension
• Calculated columns, measures, and tables in DAX
• Creation of charts/tables
• Formatting visual objects and interaction between them
• Filters panel
• Drill-down/up and Drill-through
• Bookmarks
• RLS (Row-Level Security)
• Publishing to the cloud and workspace management
• Dashboards
• Gateway and scheduled refreshes
• Creation of business Apps
• Appendix: Power Query deep dive, data modeling techniques for unstructured sources