SERVICES
Courses
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