Become an Analytics and Business Intelligence Expert
Data visualization is the process of
presenting information in a graphic or visual format, making it easier to perceive and
analyze the data. It's used in business, scientific research, and analytics to identify
trends, patterns, and key insights.
Power BI is a cloud service from Microsoft
for business analysis and data visualization. It enables users to create interactive reports
and dashboards by integrating data from various sources for deeper analysis.
What is data visualization?
working on the data analysis project will
gain practical skills in visualization and analysis, which will help them successfully
present their research.
will learn the essential tools and methods
for working with data, laying a solid foundation for their future growth in the field.
of data analysis-related subjects will be
able to improve their teaching methods and enrich the learning process with modern
visualization tools.
who need to build dashboards for their
projects will learn to present data effectively, helping them make better-informed decisions
and improve their campaign results.
Who will benefit from the course?
Students
Analysts and Data Science
Instructors
Marketers
What will you learn on the course?
Get the advantages when looking for a job 4.9
out of 5
>76%
01/
03/
02/
04/
Portfolio cases
Prepare for the interview
A lot of practice
Intensive course.
$2100
01/03
03/03
02/03
You'll learn how to:
You will develop skills to:
You will be able to:
how to use different data types, visualize
data, set up dashboards, create relationships, and build data models.
Pick and design charts Create an effective
dashboard layout Use advanced Power BI features
visualize data in clear reports, create
informative dashboards, and apply data transformation methods to prepare them for analysis.
course rating based on employer reviews on
Sravni
of students found a job right after finishing
the course
Create projects that showcase your skills and
highlight your expertise.
In the course, you not only gain basic
knowledge but also advanced techniques that elevate your qualification.
All the knowledge you gain is reinforced
through practical assignments. This will help you get a better grasp and become a confident
specialist.
Learn everything essential for working and
getting a quick start in the IT field.
is the salary of our graduates in their first
month of work
With these skills, you'll become a versatile
specialist in demand across any business.
Modules
Introduction
Announcement
How will we learn?
What’s this section about?
Corporate jargon
Array and consolidated report
Variables (columns) in the array
Summary of the section
What is Power BI?
Features of Power BI
Install Power BI Desktop
Functionality of Power BI
Elements of the Power BI interface
Try connecting a data source via the RIBBON
Interface: REPORT
In-depth look at the REPORT
Interface: MODEL
In-depth look at the MODEL
Interface: DATA
In-depth look at the DATA (and also Power Query)
Try updating the data
Summary of the section
Interface test
A minute introduction to the section
Loading data
Task: Load a PDF
Task: Connect to a website
Theory: what types of visualizations are there in
Power BI
Building visualizations/Reports
Task: Report on staffing
Basics of formatting visual elements
Task: Formatting the report
Publishing the report
Registering on Power BI Service
Publishing your report
Exporting reports (PDF, CSV/EXCEL, PowerPoint)
Task: Export the report
Summary of the section
Once again, the overall scheme and components of
data processing
Again about data arrays
What’s the practical deal? A simple example with
data processing
Module 6. Working with data: loading and
transformation. ETL - Power Query toolkit
What are queries?
Introduction to Power Query
QUERIES: connecting to sources
Load queries
QUERIES: systematization
Systematize some queries
QUERIES: merging queries - adding rows
"Finishing off" the rows
QUERIES: the tricky part in Power Query - joining
variables/columns
Pulling prices into the table
Double unique identifier
Fuzzy match
QUERIES: grouping/aggregation
Working with the query
Renaming COLUMNS/VARIABLES
Task: Renaming
Sorting COLUMNS/VARIABLES
Task: rearranging columns
Changing format/type of COLUMNS/VARIABLES
Task: Changing formats and types
Creating, deleting, duplicating COLUMNS/VARIABLES
Task: creating, deleting, and duplicating
Splitting and merging COLUMNS/VARIABLES
Task: Split-Merge
Adding and merging COLUMNS/VARIABLES: column from
the example
Calculating new COLUMNS/VARIABLES
Task: Calculating
Conditional COLUMN
Task: calculate 2 conditional columns
Replacing certain VALUES in column cells with
other values
Task: value replacement in variables
Replacing ERRORS
Task: transforming variables
Replacing values for DATE
Month and quarter
Replacing values for QUANTITATIVE variables
Rounding for sampling
Replacing values for TEXT
Transforming text values.
Extracting from text
BULK FILLING of empty values in columns
Task: bulk filling of empty cells.
Filtering ROWS
Task: Filter for removal
Task: Filtering out excess
Deleting ROWS
Getting the exchange rate
Task: Combinatorics
Removing duplicate ROWS
Task: Removing duplicates
Creating the list right away
Task: Multiple
Task: creating a duplicates table (saving
duplicates)
Transposing (swapping COLUMNS and ROWS)
Task: Transposing
Turning a summarized report into an array:
canceling the folding of COLUMNS/VARIABLES
Task: Canceling folding (unpivot)
Summaries for Power Query
Relationships Between Queries
Fact and Dimension Tables
Table Identification
Cardinality of Relationships
Identifying Cardinality
Assignment: 1 to 1
Before Discussing Relationship Direction: The
Concept of FILTERING
A specialist in business analytics and the
author of popular courses on Power BI and Tableau. A leading webinar host on creating
dashboards for businesses.
A professional in ETL and process automation,
the author of the book "Effective Data Processing." A leading specialist in Apache Airflow.
He has worked at major consulting firms,
where he developed analytical solutions for clients.
Since 2014, she has been teaching students
and professionals modern methods of data processing and analysis.
Introductory
Navigator
FREE
$38
Introductory lectures of the 1st, 2nd and 3rd modules
I never thought that data visualization could
be so exciting. The instructors share their experiences and offer a lot of useful tips. The
practical assignments were challenging, but they really helped me understand the material
better. Now I confidently create reports for my team!
Maria
The course turned out to be very useful for
my work. I particularly appreciated the attention to detail and the opportunity to ask
questions to the instructors. This is really quality education that is worth the money!
Igor
Each module is logically organized, and the
information is presented in an accessible way. The practical assignments truly help
reinforce the material. I learned not only to work with Power BI but also to better
understand how to visualize data for different audiences. I recommend it to anyone who wants
to deepen their knowledge!
Elena
The experts explain complex concepts really
well, and I was able to quickly grasp the main tools. I especially liked the practical
assignments, which helped me apply the theory in practice. Now I confidently create
dashboards and graphics!
Alexander
The course is structured in such a way that
it first gives you an overview of the process of working with Power BI, and you immediately
go through all its main components and steps. Because of this, you have a general
understanding of the program and how to work with it, and you already feel quite confident
using it. A big plus for me was the presence of practical exercises. There are a lot of
them, and it takes time to complete them all, but you can immediately apply what you learn
in the course to reinforce your understanding. This is a very high-quality course!
Olga
Answering Questions
Yes, you will definitely be able to. The course material
is presented in a clear and structured way, allowing you to gradually grasp
all the nuances of working with data visualization.
You will need a laptop or PC to solve tasks; lectures and
lessons can be watched on a mobile phone.
All of the learning takes place online. You study the
lessons, complete assignments after each lesson, and communicate with
classmates and the teacher in the chat.
To do this, you need to contact the course coordinator
and request a refund. We will fully refund you for the first three lessons,
and starting from the fourth lesson, we will calculate the refund amount or
help you choose another course.
You can build a portfolio of practical work that you will
complete during the course and show it to employers when applying for jobs.
All assignments are based on real projects.