๐๐๐ฒ ๐- ๐๐จ๐ฐ๐๐ซ ๐๐ ๐๐๐๐ฅ ๐๐ข๐ฆ๐ ๐๐ซ๐จ๐ฃ๐๐๐ญ ๐๐๐ซ๐ข๐๐ฌ ๐
I have X table in which a column named 'Employee Class' with inputs 'Highest Level', 'Mid-Level', and 'Entry-Level'.
When I put it in a slicer, it appears in either ascending order based on the first letter (Entry-Level, Highest Level, Mid-Level) or descending order (Mid-Level, Highest Level, Entry-Level).
However, Client wants it to be shown in the order: Highest Level, Mid-Level, and Entry-Level. How can I achieve this in Power BI?
๐๐จ๐ฅ.
๐. Go to Data view in Power BI Desktop
๐. Select the table containing the "Employee Class" column.
๐. Create a new column (e.g., "SortOrder") with a formula to assign numerical values based on your desired order:
๐๐จ๐ซ๐ญ๐๐ซ๐๐๐ซ =
๐๐๐๐๐๐(
'๐'[๐๐ฆ๐ฉ๐ฅ๐จ๐ฒ๐๐ ๐๐ฅ๐๐ฌ๐ฌ],
"๐๐ข๐ ๐ก๐๐ฌ๐ญ ๐๐๐ฏ๐๐ฅ", ๐,
"๐๐ข๐-๐๐๐ฏ๐๐ฅ", ๐,
"๐๐ง๐ญ๐ซ๐ฒ-๐๐๐ฏ๐๐ฅ", ๐,
"๐๐"
)
๐. In the Data view, select the "Employee Class" column. Go to the "Modeling" tab in the ribbon. Click on "Sort by Column" and choose the "SortOrder" column.
๐. Insert a slicer by dragging the "Employee Class" field in Power BI Desktop.
The slicer should now display the "Employee Class" values in the order: Highest Level, Mid-Level, Entry-Level.
I have X table in which a column named 'Employee Class' with inputs 'Highest Level', 'Mid-Level', and 'Entry-Level'.
When I put it in a slicer, it appears in either ascending order based on the first letter (Entry-Level, Highest Level, Mid-Level) or descending order (Mid-Level, Highest Level, Entry-Level).
However, Client wants it to be shown in the order: Highest Level, Mid-Level, and Entry-Level. How can I achieve this in Power BI?
๐๐จ๐ฅ.
๐. Go to Data view in Power BI Desktop
๐. Select the table containing the "Employee Class" column.
๐. Create a new column (e.g., "SortOrder") with a formula to assign numerical values based on your desired order:
๐๐จ๐ซ๐ญ๐๐ซ๐๐๐ซ =
๐๐๐๐๐๐(
'๐'[๐๐ฆ๐ฉ๐ฅ๐จ๐ฒ๐๐ ๐๐ฅ๐๐ฌ๐ฌ],
"๐๐ข๐ ๐ก๐๐ฌ๐ญ ๐๐๐ฏ๐๐ฅ", ๐,
"๐๐ข๐-๐๐๐ฏ๐๐ฅ", ๐,
"๐๐ง๐ญ๐ซ๐ฒ-๐๐๐ฏ๐๐ฅ", ๐,
"๐๐"
)
๐. In the Data view, select the "Employee Class" column. Go to the "Modeling" tab in the ribbon. Click on "Sort by Column" and choose the "SortOrder" column.
๐. Insert a slicer by dragging the "Employee Class" field in Power BI Desktop.
The slicer should now display the "Employee Class" values in the order: Highest Level, Mid-Level, Entry-Level.
๐7โค1
How much Statistics must I know to become a Data Scientist?
This is one of the most common questions
Here are the must-know Statistics concepts every Data Scientist should know:
๐ฃ๐ฟ๐ผ๐ฏ๐ฎ๐ฏ๐ถ๐น๐ถ๐๐
โ๏ธ Bayes' Theorem & conditional probability
โ๏ธ Permutations & combinations
โ๏ธ Card & die roll problem-solving
๐๐ฒ๐๐ฐ๐ฟ๐ถ๐ฝ๐๐ถ๐๐ฒ ๐๐๐ฎ๐๐ถ๐๐๐ถ๐ฐ๐ & ๐ฑ๐ถ๐๐๐ฟ๐ถ๐ฏ๐๐๐ถ๐ผ๐ป๐
โ๏ธ Mean, median, mode
โ๏ธ Standard deviation and variance
โ๏ธ Bernoulli's, Binomial, Normal, Uniform, Exponential distributions
๐๐ป๐ณ๐ฒ๐ฟ๐ฒ๐ป๐๐ถ๐ฎ๐น ๐๐๐ฎ๐๐ถ๐๐๐ถ๐ฐ๐
โ๏ธ A/B experimentation
โ๏ธ T-test, Z-test, Chi-squared tests
โ๏ธ Type 1 & 2 errors
โ๏ธ Sampling techniques & biases
โ๏ธ Confidence intervals & p-values
โ๏ธ Central Limit Theorem
โ๏ธ Causal inference techniques
๐ ๐ฎ๐ฐ๐ต๐ถ๐ป๐ฒ ๐น๐ฒ๐ฎ๐ฟ๐ป๐ถ๐ป๐ด
โ๏ธ Logistic & Linear regression
โ๏ธ Decision trees & random forests
โ๏ธ Clustering models
โ๏ธ Feature engineering
โ๏ธ Feature selection methods
โ๏ธ Model testing & validation
โ๏ธ Time series analysis
Iโve launched a new YouTube playlist dedicated to teaching statistics from the ground up. This series covers fundamental concepts in a simple and structured way, making it perfect for beginners looking to build a strong foundation in statistics.
Watch the playlist here: Statistics from Basics โ YouTube- https://www.youtube.com/playlist?list=PLEt4gT_dNBRGCn0tsZpd14uA2q3s64ekq
This is one of the most common questions
Here are the must-know Statistics concepts every Data Scientist should know:
๐ฃ๐ฟ๐ผ๐ฏ๐ฎ๐ฏ๐ถ๐น๐ถ๐๐
โ๏ธ Bayes' Theorem & conditional probability
โ๏ธ Permutations & combinations
โ๏ธ Card & die roll problem-solving
๐๐ฒ๐๐ฐ๐ฟ๐ถ๐ฝ๐๐ถ๐๐ฒ ๐๐๐ฎ๐๐ถ๐๐๐ถ๐ฐ๐ & ๐ฑ๐ถ๐๐๐ฟ๐ถ๐ฏ๐๐๐ถ๐ผ๐ป๐
โ๏ธ Mean, median, mode
โ๏ธ Standard deviation and variance
โ๏ธ Bernoulli's, Binomial, Normal, Uniform, Exponential distributions
๐๐ป๐ณ๐ฒ๐ฟ๐ฒ๐ป๐๐ถ๐ฎ๐น ๐๐๐ฎ๐๐ถ๐๐๐ถ๐ฐ๐
โ๏ธ A/B experimentation
โ๏ธ T-test, Z-test, Chi-squared tests
โ๏ธ Type 1 & 2 errors
โ๏ธ Sampling techniques & biases
โ๏ธ Confidence intervals & p-values
โ๏ธ Central Limit Theorem
โ๏ธ Causal inference techniques
๐ ๐ฎ๐ฐ๐ต๐ถ๐ป๐ฒ ๐น๐ฒ๐ฎ๐ฟ๐ป๐ถ๐ป๐ด
โ๏ธ Logistic & Linear regression
โ๏ธ Decision trees & random forests
โ๏ธ Clustering models
โ๏ธ Feature engineering
โ๏ธ Feature selection methods
โ๏ธ Model testing & validation
โ๏ธ Time series analysis
Iโve launched a new YouTube playlist dedicated to teaching statistics from the ground up. This series covers fundamental concepts in a simple and structured way, making it perfect for beginners looking to build a strong foundation in statistics.
Watch the playlist here: Statistics from Basics โ YouTube- https://www.youtube.com/playlist?list=PLEt4gT_dNBRGCn0tsZpd14uA2q3s64ekq
YouTube
Statistics complete playlist
Statistics complete videos
๐4โค1
Must-Know Power BI Charts & When to Use Them
1. Bar/Column Chart
Use for: Comparing values across categories
Example: Sales by region, revenue by product
2. Line Chart
Use for: Trends over time
Example: Monthly website visits, stock price over years
3. Pie/Donut Chart
Use for: Showing proportions of a whole
Example: Market share by brand, budget distribution
4. Table/Matrix
Use for: Detailed data display with multiple dimensions
Example: Sales by product and month, performance by employee and region
5. Card/KPI
Use for: Displaying single important metrics
Example: Total Revenue, Current Monthโs Profit
6. Area Chart
Use for: Showing cumulative trends
Example: Cumulative sales over time
7. Stacked Bar/Column Chart
Use for: Comparing total and subcategories
Example: Sales by region and product category
8. Clustered Bar/Column Chart
Use for: Comparing multiple series side-by-side
Example: Revenue and Profit by product
9. Waterfall Chart
Use for: Visualizing increment/decrement over a value
Example: Profit breakdown โ revenue, costs, taxes
10. Scatter Chart
Use for: Relationship between two numerical values
Example: Marketing spend vs revenue, age vs income
11. Funnel Chart
Use for: Showing steps in a process
Example: Sales pipeline, user conversion funnel
12. Treemap
Use for: Hierarchical data in a nested format
Example: Sales by category and sub-category
13. Gauge Chart
Use for: Progress toward a goal
Example: % of sales target achieved
1. Bar/Column Chart
Use for: Comparing values across categories
Example: Sales by region, revenue by product
2. Line Chart
Use for: Trends over time
Example: Monthly website visits, stock price over years
3. Pie/Donut Chart
Use for: Showing proportions of a whole
Example: Market share by brand, budget distribution
4. Table/Matrix
Use for: Detailed data display with multiple dimensions
Example: Sales by product and month, performance by employee and region
5. Card/KPI
Use for: Displaying single important metrics
Example: Total Revenue, Current Monthโs Profit
6. Area Chart
Use for: Showing cumulative trends
Example: Cumulative sales over time
7. Stacked Bar/Column Chart
Use for: Comparing total and subcategories
Example: Sales by region and product category
8. Clustered Bar/Column Chart
Use for: Comparing multiple series side-by-side
Example: Revenue and Profit by product
9. Waterfall Chart
Use for: Visualizing increment/decrement over a value
Example: Profit breakdown โ revenue, costs, taxes
10. Scatter Chart
Use for: Relationship between two numerical values
Example: Marketing spend vs revenue, age vs income
11. Funnel Chart
Use for: Showing steps in a process
Example: Sales pipeline, user conversion funnel
12. Treemap
Use for: Hierarchical data in a nested format
Example: Sales by category and sub-category
13. Gauge Chart
Use for: Progress toward a goal
Example: % of sales target achieved
๐7โค1
Most interview guides are outdated. Here's what real data science interviews in 2025 are asking โ and why theyโre NOT on your prep site. Save this before your next technical round!
โค1๐1
๐ New Launch: Data Analysis with Python โ Recorded Course ๐
Ready to master Data Analysis with Python from the comfort of your home?
๐ฆ What's Included in the Full Course (โน2000):
โ 1-on-1 Doubt Solving Sessions (5 sessions ร 15 mins at your flexible timings)
โ Comprehensive Learning Material (PDF notes, Assignments, and .ipynb files for every session)
โ Lifetime Access to Course Recordings
๐ก Only Need the Learning Material & Recordings?
Get the Self-Learning Package for just โน1299
โ PDF Notes + Assignments + .ipynb Files
โ Lifetime Access to All Recordings
๐ No deadlines. No pressure. Learn at your own pace with expert support!
Ping me on whatsapp +91-9910986344
Ready to master Data Analysis with Python from the comfort of your home?
๐ฆ What's Included in the Full Course (โน2000):
โ 1-on-1 Doubt Solving Sessions (5 sessions ร 15 mins at your flexible timings)
โ Comprehensive Learning Material (PDF notes, Assignments, and .ipynb files for every session)
โ Lifetime Access to Course Recordings
๐ก Only Need the Learning Material & Recordings?
Get the Self-Learning Package for just โน1299
โ PDF Notes + Assignments + .ipynb Files
โ Lifetime Access to All Recordings
๐ No deadlines. No pressure. Learn at your own pace with expert support!
Ping me on whatsapp +91-9910986344
๐จ Join Our Discord Community! ๐๐
Hey #CodingFam! I'm super excited to invite you to new Discord server โ made just for YOU ๐ฅ
If you're a student, job seeker, or self-learner trying to build a career in Data Science, Python, SQL, Power BI, or ML โ this is the ultimate space youโve been waiting for ๐ป๐ก
๐ง Whatโs Inside?
โ Topic-wise roadmaps (Python, ML, SQL, etc.)
โ Daily goals & learning challenges
โ Project ideas & resume boosters
โ Notes, resources, and YouTube playlists
โ Real-time help & doubt-solving
โ Career guidance + Interview prep
๐ฌ Why Discord?
Because learning shouldn't feel lonely!
With Discord, we can:
๐ Interact instantly in focused channels
๐ Stay updated through announcements
๐ Ask & answer doubts in real time
๐ Build a support system with learners like you
๐ Get exclusive tips, content drops & live session alerts
๐ฏ Whether you're just starting out or already in the game, this community will help you stay consistent, stay motivated, and level up your skills โ together ๐ช
๐ Click to join: https://discord.gg/khBWeH5T
(It's FREE & beginner-friendly!)
Letโs build, learn, and grow together ๐ฉโ๐ป๐จโ๐ป
See you on the server! ๐
Hey #CodingFam! I'm super excited to invite you to new Discord server โ made just for YOU ๐ฅ
If you're a student, job seeker, or self-learner trying to build a career in Data Science, Python, SQL, Power BI, or ML โ this is the ultimate space youโve been waiting for ๐ป๐ก
๐ง Whatโs Inside?
โ Topic-wise roadmaps (Python, ML, SQL, etc.)
โ Daily goals & learning challenges
โ Project ideas & resume boosters
โ Notes, resources, and YouTube playlists
โ Real-time help & doubt-solving
โ Career guidance + Interview prep
๐ฌ Why Discord?
Because learning shouldn't feel lonely!
With Discord, we can:
๐ Interact instantly in focused channels
๐ Stay updated through announcements
๐ Ask & answer doubts in real time
๐ Build a support system with learners like you
๐ Get exclusive tips, content drops & live session alerts
๐ฏ Whether you're just starting out or already in the game, this community will help you stay consistent, stay motivated, and level up your skills โ together ๐ช
๐ Click to join: https://discord.gg/khBWeH5T
(It's FREE & beginner-friendly!)
Letโs build, learn, and grow together ๐ฉโ๐ป๐จโ๐ป
See you on the server! ๐
Discord
Join the Codingdidi Discord Server!
Check out the Codingdidi community on Discord - hang out with 32 other members and enjoy free voice and text chat.
โค5
Whatโs the biggest challenge you face in learning AI/ML?
Anonymous Poll
33%
Understanding math behind it
24%
Lack of projects/practice
28%
Too many resources, donโt know where to start
7%
Time management
9%
Staying consistent
โค3
https://youtu.be/Bd6EeCdDRiw -- Github in one complete video
YouTube
Git & GitHub Full Course for Beginners (2025) ๐ | Master GitHub, Repos, SSH, Pull Requests & More!
GitHub for Beginners to Pro: Complete Guide in One Video
Are you new to Git or GitHub and feeling overwhelmed? This beginner-friendly Git & GitHub full course (2025 edition) is all you need to go from zero to confident! ๐ป๐
In this comprehensive video, you'llโฆ
Are you new to Git or GitHub and feeling overwhelmed? This beginner-friendly Git & GitHub full course (2025 edition) is all you need to go from zero to confident! ๐ป๐
In this comprehensive video, you'llโฆ
โค2
Some practical interview questions for an entry-level data analyst role in Power BI:
โข Data Import Scenario: Describe how you would import data from various sources (Excel,SQL Server, CSV) into Power BI.
โข Data Cleaning Exercise: In Power BI, how would you handle a dataset with missing values and inconsistent formats to prepare it for analysis?
โข Handling Large Datasets: If you're working with a very large dataset in Power BI that is causing performance issues, what strategies would you use to optimize the data processing?
โข Calculated Columns and Measures: Explain how you would use calculated columns and measures in Power BI to analyze year-over-year growth.
โข Data Modeling Case: You have sales data in one table and customer data in another. How would you create a data model in Power BI to analyze customer purchase behavior?
โข Visualizations Task: Describe your approach to visualizing sales data in Power BI to highlight trends over time across different product categories.
โข Dashboard Optimization: A Power BI dashboard is loading slowly. What steps would you take to diagnose and improve its performance?
โข Data Refresh Scheduling: How would you set up and manage automatic data refreshes for a weekly sales report in Power BI?
โข Row-Level Security: How would you implement user-level security in Power BI for a report that needs different access levels for various users?
โข Troubleshooting a DAX Calculation: If a DAX formula in Power BI is not returning the expected results, how would you go about troubleshooting it?
โข Integration with Other Tools: Describe a scenario where you integrated Power BI with another tool or service (like Excel, Azure, or a web API).
โข Interactive Reports Creation: How would you design a Power BI report that allows user interaction, such as using slicers or drill-down features?
โข Adapting to Data Source Changes: If there are structural changes in a primary data source (like addition or removal of columns), how would you update your Power BI reports and dashboards?
โข Sharing Reports: Explain how you would share a report with your team and set up access controls using Power BI Service.
โข SQL Queries in Power BI: How do you use SQL queries in Power BI for advanced data transformation or analysis?
โข Error Handling in Data Sources: How do you manage and resolve errors in data sources or calculations in Power BI?
โข Custom Visuals Usage: Have you used custom visuals in Power BI? Describe the scenario and the benefit
โข Collaboration in Power BI Projects: Discuss how you have worked with others on a Power BI project. What collaboration tools or features within Power BI did you utilize?
โข Performance Tuning: What steps do you take to ensure your Power BI reports are performing optimally when dealing with large datasets or complex calculations?
โข Data Import Scenario: Describe how you would import data from various sources (Excel,SQL Server, CSV) into Power BI.
โข Data Cleaning Exercise: In Power BI, how would you handle a dataset with missing values and inconsistent formats to prepare it for analysis?
โข Handling Large Datasets: If you're working with a very large dataset in Power BI that is causing performance issues, what strategies would you use to optimize the data processing?
โข Calculated Columns and Measures: Explain how you would use calculated columns and measures in Power BI to analyze year-over-year growth.
โข Data Modeling Case: You have sales data in one table and customer data in another. How would you create a data model in Power BI to analyze customer purchase behavior?
โข Visualizations Task: Describe your approach to visualizing sales data in Power BI to highlight trends over time across different product categories.
โข Dashboard Optimization: A Power BI dashboard is loading slowly. What steps would you take to diagnose and improve its performance?
โข Data Refresh Scheduling: How would you set up and manage automatic data refreshes for a weekly sales report in Power BI?
โข Row-Level Security: How would you implement user-level security in Power BI for a report that needs different access levels for various users?
โข Troubleshooting a DAX Calculation: If a DAX formula in Power BI is not returning the expected results, how would you go about troubleshooting it?
โข Integration with Other Tools: Describe a scenario where you integrated Power BI with another tool or service (like Excel, Azure, or a web API).
โข Interactive Reports Creation: How would you design a Power BI report that allows user interaction, such as using slicers or drill-down features?
โข Adapting to Data Source Changes: If there are structural changes in a primary data source (like addition or removal of columns), how would you update your Power BI reports and dashboards?
โข Sharing Reports: Explain how you would share a report with your team and set up access controls using Power BI Service.
โข SQL Queries in Power BI: How do you use SQL queries in Power BI for advanced data transformation or analysis?
โข Error Handling in Data Sources: How do you manage and resolve errors in data sources or calculations in Power BI?
โข Custom Visuals Usage: Have you used custom visuals in Power BI? Describe the scenario and the benefit
โข Collaboration in Power BI Projects: Discuss how you have worked with others on a Power BI project. What collaboration tools or features within Power BI did you utilize?
โข Performance Tuning: What steps do you take to ensure your Power BI reports are performing optimally when dealing with large datasets or complex calculations?
โค6