Course Outline
Module 1: Basics
- Course structure and content
- Download: project files
- Introduction to the course project
- Important information about the course
Module 2: Introduction to Microsoft in Power BI
- Presentation of Power BI Desktop and its components
- Download, Installation and Power BI Desktop settings
- Important: settings and options
- Power BI Service and mobile application
Module 3: Connecting and modeling data in Microsoft Power BI Desktop
- Types of data connectors in Power BI Desktop
- Query Editor (Power Querry)
- Data import from Excel and CSV
- Basic table transformations in Power BI Desktop
- Working with TEXT type tools
- Working with NUMERIC type tools
- Working with DATE and TIME instruments
- Generating conditional and index type columns
- Data grouping and aggregation
- Pivot / Unpivot in Power BI
- Data fusion in Power Query (Merge)
- Pasting data in Power Query (Append)
- Import from a Folder
- Modification of data sources and refresh (Refresh)
Module 4: Creating links between tables and data models in Power BI Desktop
- What is a Data Model?
- DATE type tables and DIMENSION type tables
- Creating Relationships between tables
- Management and editing of relationships between tables
- Cardinality of relationships; Filter Flow
- Connecting several DATA type tables
Module 5: Data analysis with DAX calculations in Power BI
- Introduction to DAX (Data Analysis Expressions) + SYNTAX
- Intro DAX – Calculated Columns
- Intro DAX – Measures
- The filter context of the Measures
- Categories of DAX functions
- Date and Time functions
Module 6: Data visualization in Power BI
- Introduction to the "Report" Mode
- Inserting visuals in Power BI
- Visual formatting options
- Filtering options
- Explore data with the Matrix visual
- Data filtering using Slicers
- Displaying the values using the Card and KPI visuals
- Editing interactions between reports
Module 7: Power BI Service and integration with Teams
- Publishing reports from Power BI Desktop in Power BI Service
- Creating Dashboards from published reports
- Sharing options with team members using Microsoft Teams
- Sharing and collaboration in Power BI Service
- Data export: Excel, PowerPoint, PDF
Requirements
Power BI Desktop 64 bit
Power BI Service or Power BI Pro licence for module 7.
Testimonials (7)
The thinking model of Power BI. How to build a chart and a dashboard that can be used by people without experience in Power BI + as the myth we all had in our heads that Power BI is only for visualization has been shattered, it is much more than that, and the logic of functioning that the trainer demonstrated to us will surely help us understand many other tools and how to formulate a prompt for any AI we will use. +
Emilian Manea - Molson Coors
Course - Power BI Basic
Machine Translated
The fact that Power BI is a powerful and highly versatile tool can help in various ways when presenting reports through just a few clicks, provided the connections are set up correctly.
Szilard Ferenczi - DARWIN TECHNOLOGIES
Course - Power BI Basic
Machine Translated
How powerful is PowerBI? I had only been thinking about some dashboards, when in fact the backend is quite complex. I will need to put a little effort into understanding that star schema (admittedly, my colleagues distracted me right when I shouldn't have been, but I'll deal with it).
Cojocariu Marius - DARWIN TECHNOLOGIES
Course - Power BI Basic
Machine Translated
the basic principles of working with Power BI and using GitHub Copilot with Power BI
Lavinia Malancraveanu - DARWIN TECHNOLOGIES
Course - Power BI Basic
Machine Translated
Power BI capacities, where they are suitable to use and their limitations.
Bogdan Nicule - DARWIN TECHNOLOGIES
Course - Power BI Basic
Machine Translated
I learned many tips and tricks about some concepts that I already knew, but the way the trainer explained things gave me a new perspective. Additionally, the trainer showed us how we can achieve the same result using different approaches.
Deac Alexandra - DARWIN TECHNOLOGIES
Course - Power BI Basic
Machine Translated
By learning Power BI on my own and in an unstructured way, the information I had was all over the place, lacking a broader context to fully understand the tool. After this training, even within the first few hours, I gathered actionable steps to improve both my data model and overall workflow. Extremely comprehensive for a two-day training, with a wealth of contextualized information that I can immediately apply to my reports. Truly a highly valuable training.
Andreea Nohai - DARWIN TECHNOLOGIES
Course - Power BI Basic
Machine Translated
