Excel Power Query Tutorial - (Case Study) | Cross Tab vs Flat file | Data Reshaping for Data Analyst
▶ Upcoming LIVE WEBINAR
https://topmate.io/analyticalguy/1930473
▶ Dataset Excel file for practice
https://bit.ly/3QUt8I2
▶ Self Evaluate Yourself if you can become a successful Business Analyst.
https://topmate.io/analyticalguy/132311
In this video, I have taken a raw data of HR feedback form (Capturing the responses of the employees of different companies). Applying various techniques in Excel to clean and transform the data into the shape where we can analyze the data to generate the insights.
If you're a Data Analyst, you must know this technique. This technique is used in every organization depending on the requirements.
Cross Tab ▶▶▶ Flat File (Data Reshaping?)
▶ TIMESTAMPS:
00:00 Objective of this video
00:40 Dataset explanation
01:40 Cross Tab vs Flat File (Very Important concept)
05:38 Soultion (Using Power Query Editor)
07:52 Pivoting the table.
09:15 PivotTable Analyze (Calculate % of Row Total)
10:20 Conditional Formatting (Heat Map)
11:20 Adding Slicers
12:20 Data Analysis
💡 END-TO-END POWER BI DASHBOARD
========================
End-To-End Power BI Dashboard Tutorial for everyone | Data Storytelling in 2023 | Data Visualization
https://bit.ly/PowerBIDashboardDataSt...
📁 Data Analyst Resume:
================
Data Analyst Resume with No Work Experience | Step by Step Guide | Templates + Tips + Examples
https://bit.ly/3TZIKtG
🛑Data Analyst Journey:
=====================
How I would Study Data Analytics in 2023 (If I had to start over) | Schedule | Salaries | Skill Set?
https://bit.ly/StudyDataAnalytics
Timetable And Efficient Strategy to Learn Data Analytics while Working | Improve Productivity
https://bit.ly/StudyDataAnalyticsWhil...
💡 LEARN MORE
========================
▶ Power BI Playlist -- https://bit.ly/3U3NVts
▶ Data Analytics Projects -- https://bit.ly/3hb84zd
▶ Excel Training - https://bit.ly/3WvCUTs
💡 LET'S TALK
========================
☮Any specific query? Want to get an Interview ready? Ask me anything!
https://bit.ly/3DB03ex
▶ Data Visualization using Power BI in 2023
▶Data Storytelling in Power BI using various graphs
▶Generate insights from the raw data
#powerbi #powerbitutorial