SERVICES
Courses
SKILLS AND TRAININGS
Business Intelligence and Business Analytics for Strategic Development
Date
Two modules, the first module on October 23, 2024, and the second module on October 24, 2024.
Supply Partner
MADE
Participants
15
Duration
16 hours
Delivery method
Hybrid
Cost
1100 euro + IVA
Who is it aimed at?
Entrepreneurs of SMEs, Managers, HR Managers (non-technical target)
Goals
This course aims to develop appropriate skills regarding Business Intelligence (BI) methods and procedures for the use of company data, aimed at multidimensional and multi-level control of business performance. 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 forecast analyses of the company’s available management data. The course also illustrates Business Analytics methods for predictive analysis, which integrates BI functionalities with data from online sources such as Open Data and Big Data.
Contents
• Introduction to Power BI
• Connections to data sources
• Data preparation operations in Power Query
• Model generation: difference between imported data and Direct Query
• Relationships between tables
• 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 Drill-through
• Bookmarks
• RLS (Row-Level Security)
• Publishing to the cloud and workspaces
• Dashboards
• Gateway and scheduled updates
• Creation of company apps
• Appendix: Power Query deep dive, data modeling techniques from unstructured sources
