Data analyst junior
Сreate stunning visualisations and interactive dashboards with Excel spreadsheets and Power BI.
/6571 learners
4, 6
Boost your career
with bonus training
with bonus training
Study face-to-face online
Training duration
8
practical workshops
per week
per week
week
course
course
2
each workshop
is 1.5 hours
is 1.5 hours
Request a call back
We will contact you within 15 minutes to give you all the information you need.
By clicking on the button, you agree to the privacy policy.
You master a new skill
The course will be suitable if:
You want to enhance your career
You improve your skills
You want to change your profession
Data visualisation is popular nowadays. This course is designed for beginners who have no idea about PowerBI and Excel so they can quickly get a glimpse of how to create a report in PowerBI or make a dashboard in Excel. After learning you will gain skills in visualisation of the information and apply it in studying at university, at work or for your personal use
Project managers who work with huge amounts of data in different systems sources and need to learn the tools of visualisation to make their data structured and clear
Acquiring data visualisation skills, you can create your first steps to Data analyst junior. While studying the course you make your portfolio and can start earning in the digital field right after training.
Specialists from various fields who are already fully or partly working with Excel and Power BI and need to systematise all their knowledge
We'll help you to achieve the profession you dream of, from scratch to your first earnings
We will teach you to use Excel tools and functions for data visualisation
• You will understand the different types of data in Excel and use appropriate functions to work with them
/ 01
We will help you create a portfolio
• You will use powerful Excel and tools to arrange the data into the desired formats and create useful visualisations
/ 02
We will teach you how to work with Power BI
• You will learn how to create Power Bi dynamic reports and visualisations for financial data analysis
/ 03
• You will learn how to use Named Ranges and Tables to automate your analysis
• You will master a broad range of charts and create interactive dashboards
• You will build reports easily and generate informative charts from each report
• You can choose powerful visuals to highlight information on a dashboard
• You will learn which steps are key to making an effective financial report dashboard
• You will get to know how to connect your report for dynamic visualisations
Do you need
the detailed curriculum?
the detailed curriculum?
Course programme
You will do
face-to-face virtual workshops
face-to-face virtual workshops
You will study online with a live teacher
with whom you can communicate and fully interact in real-time
Power BI function
1
content and tools
- Learning the interface of the Power BI data analysis program
- Loading data in different formats into Power BI, collecting information for analytics from sites
- Loading data in different formats into Power BI, collecting information for analytics from sites
Tools
1. Analytics in Power BI
2. Power BI interface
3. Programme goals
4. Data for work
5. Data sources
6. Ways of loading data
7. Work with requests
8. Preparation of data for analysis
2. Power BI interface
3. Programme goals
4. Data for work
5. Data sources
6. Ways of loading data
7. Work with requests
8. Preparation of data for analysis
You will practice
You will learn
Requests
Data import
Data sources
Power BI desktop
Data sources
2
content and tools
- Loading data into BI and forming a clear table
- Grouping data and combining queries
- Grouping data and combining queries
Tools
1. Data operations
2. Interface Power Query
3. Data preparation
4. Grouping in Power BI
5. Creating of custom column
6. Ways of connecting the data
7. Combining data from different sources
2. Interface Power Query
3. Data preparation
4. Grouping in Power BI
5. Creating of custom column
6. Ways of connecting the data
7. Combining data from different sources
You will practice
You will learn
Updating requests
Data conversion
Grouping
Power Query
Data modeling
3
content and tools
- Loading data from a file and creating a summary of income
- Create links between data from different sources
- Working with filters for visualisation and tables
- Create links between data from different sources
- Working with filters for visualisation and tables
Tools
1. Principles of building a data model
2. Organising tables into a complex structure
3. Schemes for building data models
4. Managing connections between tables
5. Creating Data Models
6. Setting up data models
7. DAX data analysis language
8. Creating directories
2. Organising tables into a complex structure
3. Schemes for building data models
4. Managing connections between tables
5. Creating Data Models
6. Setting up data models
7. DAX data analysis language
8. Creating directories
You will practice
You will learn
Breaks
Tables
Managing connections
Data connections
DAX Data analysis language
4
content and tools
- Creating calculated columns, writing measures
- Creating a calculated table, visualising the result in a table
- Creating a calculated table, visualising the result in a table
Tools
1. Built-in calculations
2. Creating and Applying Measures
3. Function sum, average, count
4. Function sumx, averagex, countax
5. Function distance count function, filter
6. Calculated columns
7. Creating calculated tables
8. Group by function
2. Creating and Applying Measures
3. Function sum, average, count
4. Function sumx, averagex, countax
5. Function distance count function, filter
6. Calculated columns
7. Creating calculated tables
8. Group by function
You will practice
You will learn
Calculated tables
Measures
Calculated columns
DAX language
Data visualisation
5
content and tools
- Preparing a visual component for data
Tools
1. Creating visual elements
2. Visual elements setting
3. Design tools
4. Types of visualisation
5. Creating Graphs and Tables
6. Applying filters
7. Preparing reports for external users
2. Visual elements setting
3. Design tools
4. Types of visualisation
5. Creating Graphs and Tables
6. Applying filters
7. Preparing reports for external users
You will practice
You will learn
Filter
Diagrams
Schemes
Charts
Excel tools for working with data
6
content and tools
- Creating a simple table
- Sort cells based on the selected criteria
- Multi Level sorting
- Applying simple filtering
- Creation of utm tags
- Sort cells based on the selected criteria
- Multi Level sorting
- Applying simple filtering
- Creation of utm tags
Tools
1. Program workspace
2. Working with data in cells
3. Sorting cells based on criteria
4. Change the style and colour of cells
5. Making hyperlinks
2. Working with data in cells
3. Sorting cells based on criteria
4. Change the style and colour of cells
5. Making hyperlinks
You will practice
You will learn
Hyperlinks
Formats and Values
Sorting in cells
Data entry and processing
Functions and formulas
7
content and tools
- A task with a mathematical function.
- Analyse the number of requests on a particular topic. Sorting this information into the table
- Analyse the number of requests on a particular topic. Sorting this information into the table
Tools
1. Apply formulas in tables
2. Simple and complex calculations using mathematical functions
3. Data Analysis with Logic Functions
4. Statistical functions for analysing data in cells
5. Working with Text Functions
6. Absolute and relative links
2. Simple and complex calculations using mathematical functions
3. Data Analysis with Logic Functions
4. Statistical functions for analysing data in cells
5. Working with Text Functions
6. Absolute and relative links
You will practice
You will learn
Links
"if" function
Mean
Calculations and formulas
Working with date and time functions
8
content and tools
- Calculation of dates
- Creating names for cells and ranges
- Creating names for cells and ranges
Tools
1. Adding and subtracting dates
2. Subtract dates with functions
3. Adding days, weeks, months to a date
4. Creating Named Cells and Ranges
5. Conditional Data Formatting
2. Subtract dates with functions
3. Adding days, weeks, months to a date
4. Creating Named Cells and Ranges
5. Conditional Data Formatting
You will practice
You will learn
Named cells
Summation
Formatting
Data and time
Work with data
9
content and tools
- Calculation of profitability of sales
- Summarising subtotals in the table
- Data protection in the table.
- Summarising subtotals in the table
- Data protection in the table.
Tools
1. Adding subtotals
2. Merging multiple tables into one
3. Standard Filtration
4. Working with advanced filter
5. Lock Cells and Sheets for protection
6. Hiding data in a cell
2. Merging multiple tables into one
3. Standard Filtration
4. Working with advanced filter
5. Lock Cells and Sheets for protection
6. Hiding data in a cell
You will practice
You will learn
Data protection
Data aggregation
Advanced Filter
Subtotals
Analyse data with pivot tables
10
content and tools
- Create a pivot table for total sales
- Creation of a pivot table on the results of sales with a breakdown by region and seller
- Calculation of % completion of the plan.
- Creation of a pivot table on the results of sales with a breakdown by region and seller
- Calculation of % completion of the plan.
Tools
1. Building pivot tables
2. Filtering Data in a pivot table
3. Adding fields for calculation
4. Sorting and grouping data
5. Pivot table Formatting
6. Consolidation of data in one document
2. Filtering Data in a pivot table
3. Adding fields for calculation
4. Sorting and grouping data
5. Pivot table Formatting
6. Consolidation of data in one document
You will practice
You will learn
Consolidation
Filter
Sorting & Formatting
Pivot tables
Data visualisation
11
content and tools
- KPI calculation
- Building a chart with company performance data
- Create a complex chart with sales growth data
- Building a chart with company performance data
- Create a complex chart with sales growth data
Tools
1. Creating diagram
2. Multilevel axis labels
3. Binding labels to cells
4. Complex diagram
5. Scatter plot
6. Lollipop diagram
2. Multilevel axis labels
3. Binding labels to cells
4. Complex diagram
5. Scatter plot
6. Lollipop diagram
You will practice
You will learn
Template
Complex diagram
Secondary axle
Basic Diagrams
Dynamic diagrams
12
content and tools
- Creating diagram to track daily sales
- Application of automatic data addition
- Making a chart of the exchange rate by years with time control
- Application of automatic data addition
- Making a chart of the exchange rate by years with time control
Tools
1. Building dynamic diagrams
2. Automatic data addition
3. Tracking data with diagrams
4. Adding a Series to a diagram
5. Diagrams with controls
6. Diagrams with a choice of displayed data
2. Automatic data addition
3. Tracking data with diagrams
4. Adding a Series to a diagram
5. Diagrams with controls
6. Diagrams with a choice of displayed data
You will practice
You will learn
Data adding
Diagram management
Automation
Dynamic diagrams
Working with histograms and graphs
13
content and tools
- Making sparklines
Tools
1. Create a standard chart
2. Working with dynamic charts
3. Histogram with overlap
4. Normalized distribution histogram
5. Stacked histogram
6. Construction and design of the sparkline
2. Working with dynamic charts
3. Histogram with overlap
4. Normalized distribution histogram
5. Stacked histogram
6. Construction and design of the sparkline
You will practice
You will learn
Sparkline
Dynamic charts
Histogram
Standart charts
External sources
14
content and tools
- Setting up Power Query and Power Pivot
- Import and export of documents
- Import and export of documents
Tools
1. Export and import of information
2. Transferring data to Google Sheets
3. Working with databases
4. Using the Power Query add-in
5. Power Pivot add-in features
6. Differences between Power Query and Power Pivot
2. Transferring data to Google Sheets
3. Working with databases
4. Using the Power Query add-in
5. Power Pivot add-in features
6. Differences between Power Query and Power Pivot
You will practice
You will learn
Power Pivot
Power Query
Import to Google Sheets
Data export
Dashboard in Excel
15
content and tools
- Creating a dashboard
Tools
1. Data visualisation with a dashboard
2. Fields of using a dashboard
3. Collecting data for visualisation using a dashboard
4. Dashboard design
6. Tools for formatting and analysing data
2. Fields of using a dashboard
3. Collecting data for visualisation using a dashboard
4. Dashboard design
6. Tools for formatting and analysing data
You will practice
You will learn
Data Analytics
Adding data
Creating a Layout
Construction algorithm
You will do
face-to-face virtual workshops
face-to-face virtual workshops
You will study online with a live teacher
with whom you can communicate and fully interact in real-time
Compare course delivery methods
Face2face
training with us
training with us
Recorded
courses
courses
In class
courses
courses
Timesaving on travel
Have access to recorded webinars
Increase your motivation level
Have the ability to ask personalized questions and get feedback
Compare course delivery methods
Face2face
training with us
training with us
Recorded
courses
courses
In class
courses
courses
Timesaving on travel
Have access to recorded webinars
Increase your motivation level
Have the ability to ask personalized questions and get feedback
A Data analyst is an in-demand profession
> 950 vacancies are currently open in the UK
Data analyst junior focus on taking complex data and communicating it in ways non-experts can understand.
Related Jobs
You can get a job in a company with data analytics or work on a freelance basis.
