Uploaded September 2023 | Updated September 2026, 1 day ago
Power Query tutorial for beginners on how to transpose the dataset which is about changing rows to columns or columns to rows to create wider dataset. This is a helpful feature in those tricky scenarios where you need to transpose the entire dataset for business analysis or dashboarding.
Want to take your power bi dashboarding skills to next level? then join my advance power bi dashboard training, email me - abhishek.agarrwal@gmail.com
In this training I cover 10 advance dashboards with lot of dax and visualization configuration for standard and professional looking business dashboards.
Power BI Tutorials Google Sheet - docs.google.com/spreadsheets/d/1UlV8vTxzcCR2WaYUYfL-JI_6ae1aOTPqORU1YjLfuSk/edit?usp=sharing
Dataset - tinyurl.com/yd65vnf3
#powerbi #datacleaning #datatransformation #powerquery
Power Query tutorial for beginners on how to transpose the dataset which is about changing rows to columns or columns to rows to create wider dataset. This is a helpful feature in those tricky scenarios where you need to transpose the entire dataset for business analysis or dashboarding.
Want to take your power bi dashboarding skills to next level? then join my advance power bi dashboard training, email me - abhishek.agarrwal@gmail.com
In this training I cover 10 advance dashboards with lot of dax and visualization configuration for standard and professional looking business dashboards.
Power BI Tutorials Google Sheet - docs.google.com/spreadsheets/d/1UlV8vTxzcCR2WaYUYfL-JI_6ae1aOTPqORU1YjLfuSk/edit?usp=sharing
Dataset - tinyurl.com/yd65vnf3
#powerbi #datacleaning #datatransformation #powerquery
![Qlik Sense Basic Tutorial for Beginners [2024] - Complete Tutorial - Getting Started - Part 1](https://i.ytimg.com/vi/q-3wKfdmiJE/mqdefault.jpg "Qlik Sense Basic Tutorial for Beginners [2024] - Complete Tutorial - Getting Started - Part 1
Qlik Sense tutorial for beginners where Ill teach you qlik sense from scratc. Well start with how to download and install qlik sense and then well see how we can unlock the qlik sense, then well look at the data that well use and then well import the excel data in qlik sense and then well apply the filter in on the data and load data. Once data is loaded in qlik sense then well look at the data manager to understand how we can review the data, remove or change the filters and also apply setting like replacing value, setting null values, splitting values and the statistic of the column like how many unique values it has.
Once well complete the review of data manager in qlik sense, well then create and format the KPIs for Qlik Sense business performance dashboard and then well create and format bar chart, line chart, tree map chart and scatter chart.
A lot of tips and tricks related to distinct values and enabling data labels, formatting data lables and removing the header of kpis will be discussed and implemented.
Here Ive taken the project based approach where Ill show you the final qlik sense dashboard that youll create and then step by step well create this qlik sense dashboard end to end.
Github link to download qliksense and unlock file - https://github.com/qlik-download/qlik-sense-desktop/releases/
Dataset Link https://tinyurl.com/yd65vnf3
Previous Qlik Sense Tutorial Video - https://youtu.be/zs24DVVIALU
Questions? - abhishek.agarrwal@gmail.com
Important Timestamp in this video
1:02 Topics discussed in this tutorial
4:03 How to download and install Qlik Sense Desktop
9:06 Reviewing the Qlik Sense dashboard that we’ll create today
11:10 Data used in this tutorial and reviewing it
14:32 Creating New App
18:00 Importing Data and Applying Filters
22:50 Reviewing the Data Manager
30:15 Creating and Formatting KPIs
43:33 Creating and Formatting Bar Chart
46:56 Creating and Formatting Line Chart
51:45 Creating and Formatting Treemap Chart
53:54 Creating and Formatting Scatter Scatter Chart
56:27 Creating Filters and interacting with filters
1:02:21 Next Steps – Next Sessions & Advance Dashboards Training")
