Learn about the 4042 app from the very beginning, establish a connection to SQL Server, and broaden your understanding of the underlying data model.
The training course “Exporting Lucanet Data for BI Tools via App” will specifically teach you how to configure the 4042 app and establish a connection to SQL Server. You’ll also learn about the various options for executing the app and how to set up a night job.
You’ll find out how the tables are structured and how they work together, giving you an in-depth understanding of the star schema.
Attendance fee
Customers of Lucanet Group receive a 10% discount.
Partners of Lucanet Group receive a 20% discount.
Discounts are not combinable.
Target group
- This training course is aimed at IT administrators and controllers who want to gain insights into the 4042 app, as well as anyone interested in expanding their knowledge with regard to connecting Lucanet to Power BI.
- Previous knowledge of Microsoft Power BI is required. Participants should have ideally also completed the workshop Microsoft Power BI Fundamentals.
Note: The course is available for use in the Lucanet Learning Space for a maximum duration of 12 months. Once this period is up, you should have worked through all the learning modules, downloaded any learning material you want to keep, and completed the course.
Further training on Microsoft Power BI
Course procedure
Note: The registration deadline is 14 days before the start of the live training (subject to available spots).
Agenda/content
Implementing and executing the 4042 app
- The interplay between the app, SQL database, and BI tool
- Using and configuring the 4042 app and exporting values to the SQL database
SQL database: familiarization with the tables
Data model
- Familiarization with the star schema
- Difference between dimension tables and fact tables
- Primary key: interaction and relationship between tables
Deep dive into tables and relationships
- Where to find all relevant information and learn about the Lucanet dimensions
- A more in-depth introduction to each dimension and their relationship with other tables
