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 Pro licence for module 7.
Testimonials (7)
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
That it takes time and practice to get accustomed to the new information. Now I also have a better idea on what to request, as I have understood the logics behind the end product.
