If you want to grasp the complete workflow when working with Power BI to understand the logic of this tool and start the journey towards automation, we recommend enrolling in this training.
Delivery Method: In-Person/Online
Complexity
Duration: 16 hours
Maximum of 8 people
Who is this training for?
This course is aimed at business-oriented profiles with a focus on data analysis (experience in Excel or SQL), or IT profiles familiar with business processes, who are interested in delving deeper into the Power BI cycle and gaining a detailed understanding of each component.
This training will cover the entire development cycle in Power BI, allowing users to understand the complete logic of the tool and provide an in-depth examination of each of its components.
What will you learn?
ETL
Modeling
Metrics
Visualizations
Collaboration
The complete workflow of a Business Intelligence development.
Connect to data stored in different data sources.
Perform data transformations.
Generate joins and combine multiple queries using PowerQuery.
Connect and merge data from various sources for comprehensive analysis.
Design and develop efficient data models in Power BI.
Create a model with two fact tables to understand the logic of analysis in those scenarios.
Use DAX formulas to create a calendar table, calculate metrics, and custom columns.
Introduction to Calculate and Time Intelligence to answer complex business questions.
Identify which visualizations to use in different scenarios and types of analysis.
Create interaction buttons in reports, develop a theme for the company, and format reports to have a professional appearance.
Understand different ways to collaborate in the Power BI web service.
Implement roles, configure gateways, and create apps in the Power BI web service.
Content and Duration
The training has a duration of 16 hours, typically divided into 8 sessions of 2 hours each.
Module 1
Introduction to Business Intelligence, Power Query, and Data Modeling.
Module 2
Interactive Visualizations
Module 3
Calculated Columns, Measures, and Calculated Tables with DAX
Module 4
Collaborative Features in the Power BI Web Service
Module 5
Merge, Append, and Advanced Data Modeling
Module 6
Calculate & Time Intelligence in DAX
Module 7
Data Storytelling and Professional Report Design
Module 8
Power BI Web Service
What is the methodology?
Practical and dynamic courses with hands-on exercises and real-world applications.
Certified expert instructors in Data Analytics and Business Intelligence.
Completion certificate to validate your skills and knowledge.
Live in-person or virtual classes with practical sessions and Q&A.
A practical and applied approach to acquiring relevant skills in your workplace.