Power Bi Training - From Basic To Advanced.

Training in Power BI, data import, data modeling and reporting

What you'll learn

Install and navigate the Power BI interface.stalar e navegar pela interface do Power BI.

Import data from multiple sources such as Excel, SQL and Web.

Treat, transform and organize data with Power Query.

Model data and create relationships between tables.

Use DAX formulas for advanced calculations.

Create interactive dashboards with graphs, maps and KPIs.

Publish and present reports online with clarity and impact.

Requirements

Basic computer skills, such as folder navigation and spreadsheet use (Excel is a plus, but not required). Computer with Windows installed and internet access to download Power BI Desktop (free). Basic/intermediate level of English, since the course is taught in that language, with a technical and practical focus;

Description

Power BI is a complete, practical and structured course that takes students from scratch to advanced mastery of the Power BI tool — Microsoft's powerful and widely used Business Intelligence solution. Developed with a focus on real results and applicability in the job market, the course enables students to transform large volumes of data into interactive and strategic visual reports, capable of supporting decision-making with efficiency and clarity in various business contexts.The journey begins with an introduction to Power BI, covering what the tool is, its applications and its importance in the world of data analysis and digital transformation. In the first few classes, students learn how to install the software and explore its intuitive and user-friendly interface.The course then progresses to:Importing data from sources such as Excel, SQL Server, Web and APIs;Transforming data with Power Query, adjusting and cleaning information for appropriate and optimized use;Finally, the course presents fundamental concepts of data processing and measurements, allowing the creation of advanced dashboards for insightful and dynamic data analysis.Each class was carefully designed to build knowledge sequentially, preparing students for real data analysis challenges and enhancing their competitiveness in the job market through hands-on learning, guided practice and practical exercises.

Overview

Section 1: Introduction

Lecture 1 Files used in classes

Lecture 2 Introduction

Section 2: Download Power BI

Lecture 3 Download Power BI

Section 3: Importing Data and Processing

Lecture 4 Group Tool and Merge Queries

Section 4: Query Formatting

Lecture 5 Conditional Columns

Lecture 6 Query Formatting

Section 5: Group Tool and Merge Queries

Lecture 7 Group Tool and Merge Queries

Section 6: Relations The Power BI Secret

Lecture 8 Relations The Power BI Secret

Section 7: Functions in Power BI - DAX

Lecture 9 Functions in Power BI - DAX

Section 8: Main DAX Formulas

Lecture 10 Main DAX Formulas

Section 9: Main DAX Fomulas

Lecture 11 Main DAX Formulas

Section 10: Repots - The result of Power BI

Lecture 12 Reports - The result of Power BI

Lecture 13 Continue - Conditional and Number For

Section 11: Cards, Maps and Others Reporting Tool

Lecture 14 Cards, Maps and Others Reporting Tool

Section 12: Indicators, KPI and Time Intelligence

Lecture 15 Indicators, KPI and Time Intelligence

Section 13: Publish your Report Online

Lecture 16 Publish your Report Online

This course is designed for professionals and students who want to master Power BI for data analysis. It is ideal for areas such as finance, HR, IT, logistics and management. It is also recommended for those looking to automate reports and generate strategic insights. Perfect for those who want to grow professionally and stand out in the market. If you are looking to advance in your career, this is the ideal course for you!