Features
Description
Infoshare is the largest tech community in CEE and the organizer of the leading tech conference in Gdańsk. It connects startups, investors, corporations, and innovation enthusiasts. It promotes entrepreneurship, knowledge sharing, and networking. Through events, competitions, and programs, it supports the development of the tech ecosystem in Poland and the region.
The training is intended for individuals involved in processing and analyzing large amounts of data. The training covers data preparation using PowerQuery and its visualization using Microsoft Power BI. It includes the use of the DAX library. The training also addresses topics related to storytelling with data.
- For analysts, marketers, and anyone working with data.
- For individuals involved in processing and analyzing large amounts of data.
- For those wanting to learn the DAX library.
- You will learn how to effectively acquire and process data for business decision-making.
- You will get to know PowerQuery and data preparation techniques.
- You will learn the terminology and tools necessary for retrieving information from databases and presenting it in Power BI.
- You will discover how to use the DAX library for reporting and data analysis.
- You will learn to tell stories using data and visualization techniques.
Module 1 – Introduction to Data Analysis Using Power BI Desktop
What is business intelligence?
5 layers of business intelligence solutions
Power BI as a business intelligence tool
Power BI Desktop – tool overview, interface
Module 2 – PowerQuery – Data Preparation Tool
Using data connectors (Web, csv, Excel, SQL)
Connecting to multiple data sources in one report
The concept of ETL – Extract – Transform – Load
Basic data transformation functions
Merging and appending queries
Creating custom functions
Introduction to M language
Using the advanced editor
Best practices in data preparation processes
Dataflows – PowerQuery online
The issue of "query folding" in PowerQuery
Module 3 – Data Modeling in Power BI
The concept of star and snowflake schema
Preparing fact and dimension tables using PowerQuery
Preparing a calendar table
Working with hierarchies in Power BI
Best practices in data modeling
Analyzing the data model for performance
Imported report vs DirectQuery
Module 4 – Data Analysis Using DAX Language
Introduction to DAX language
Using DAX language – calculated columns, calculated tables, measures, queries
Basic DAX functions
Using DAX iterators
Row context, evaluation context, and filter context in DAX language
Changing calculation context using CALCULATE() function
Advanced time analysis using time intelligence functions
Best practices for creating advanced queries
Module 5 – Storytelling with Data – Visualization Techniques
Explanation of "storytelling with data" concept
Correct use of various types of visualizations
Working with visualizations in Power BI
Ways to filter data in the visual layer
Managing interactions between visualizations
Advanced formatting techniques for report appearance and visualizations
Using drill-through functionality
Using bookmarks in report building
Working with field parameters
Additional information through tooltip implementation
Best practices for creating the visual layer of the report
Module 6 – Publishing and Sharing Reports
Introduction to Power BI Service
Rules for publishing reports
Data security – Row Level Security, Object Level Security
Refreshing data in Power BI Service
Using Power Automate to automate work with Power BI
32 h/ 4 days