Català
Español
English
Activitat ajornada
Motiu:
| Addressed to: | Employees in charge of analyzing data and communicating or sharing results |
| Dates: | January 3, 5, 10, 12, 17, 19, 24, 26 and 31 (Tuesday and Thursday) 2023 |
| Schedule: | From 16.00 to 18.00 hours |
| Assistants: | 6/25 |
| Duration: | 20 hours |
| Programming: | 1. Introduction 1.1 What is Power BI? 1.2 Download and install Power BI 1.3 Power BI interface and components 1.4 Use cases 2. Obtain data 2.1 Introduction to Power BI Desktop 2.2 Installation and commissioning 2.3 Connected data sources in Power BI Desktop 2.4 Vista Data and Power BI Desktop 2.5 Data filtering 3. Consult Power BI Desktop 3.1 Power Query editor interface 3.2 Types of data 3.3 Group files 3.4 Create custom columns 3.5 Dynamize Columns 3.6 Custom query formulas 3.7 Conditionals
4. Data modeling 4.1 Introduction to data modeling 4.2 Use data relationships 4.3 Create columns 4.4 Models Optimizing the data 4.5 Create tables 5 Relationships in Power BI 5.1 Introduction to the relationships between tables 5.2 Automatic detection of relationships 5.3 Relationship creation manual 5.4 Editing relationships and properties 6. Introduction to DAX 6.1 Functions and types 6.2 Column Calculations 6.3 Measures 6.4 Filter context 6.5 DAX variables and expressions 6.6 Aggregation functions 6.7 CALCULATION function 6.8 Time intelligence 6.9 Rates and DAX relationships 6.10 Tables and filtering 7. Views 7.1 Introduction to the date view 7.2 Create and modify simple views 7.3 Column, bar, donut graphs... 7.4 Data segmentation - Slicers 7.5 Matrices and tables 7.6 Modify colors 7.7 Shadows and images 8. Data visualizations with maps 8.1 Introduction to views with maps 8.2 Integration with Bing Maps 8.3 Creation and use of choroplethic maps 8.4 Creation and use of shape maps 9. Boards 9.1 Power BI Server 9.2 Create and configure a Dashboard 9.3 Sharing panels 9.4 Update widgets 10. Publish and Share 10.1 Publish Power BI reports 10.2 Export panels 10.3 Republish and update dates 10.4 Introduction to Power BI Mobile. |
| Documentation: | The documentation will be available on the platform between 24 and 48 hours before the start of the training. In the event that there is additional documentation once the training is completed, we will provide it to you later. |
| Certification: | Once the training has been completed, students will receive a certificate of attendance that can be downloaded from the platform. |
| Bonuses: | We manage the procedures so that you can benefit from the corresponding training bonus. |
| Bonus instructions: | 1. Request the forms from the CETIT at formacio@ingenijerstarragona.cat 2. Provide all the information 10 calendar days before the start of the course. 3. IMPORTANT NOTE: the bonuses are carried out by means of an external consultancy. Those who wish to take advantage of the bonus for any training action, the price will be increased by 20% (which can also be bonused and recovered). |
.png)
| Conditions: | Cancellation of registrations: Depending on the registrations that are made, the training action will be viable or not, for this reason it is important that you notify cancellations. The cancellation must be communicated 48 hours before the start of the training through the email formacio@cetit.org, otherwise 100% of the amount of the training action will be invoiced. Images and recording of the course: we inform you that, in compliance with the RGPD, the current legal regulations on data protection and Law 1/1982 on civil protection, right to honor, personal and family privacy and the image itself, photographs will be taken during the course and in certain cases they will be recorded and/or broadcast live. Under no circumstances will the name of the interested party be published. The image is used legitimately for the College's legitimate interest in promoting these courses and their possible subsequent viewing by attendees. By attending, these images will be kept as long as the course is uploaded to the platform. Once the period for viewing it later has passed, it will no longer be uploaded to the platform and the images will be deleted with appropriate security measures. Likewise, you have the right to request access, rectification, portability and deletion of your data and the limitation and opposition to its treatment by sending an email to dpd@cetit.org. For more information on data protection rights, access our website: http://www.ingenijerstarragona.cat/home/article/privacit. |
