- 59
- 4 606
Beyond Numbers
India
Приєднався 3 кві 2013
Welcome to my channel your ultimate destination for unlocking the power of data analytics! Join us on a journey into the fascinating world of of data Whether you're a beginner looking to dive into the fundamentals or an experienced analyst seeking advanced insights, my channel is your go-to resource.
I believe in demystifying complex concepts and empowering learners to harness the full potential of data. From in-depth tutorials and hands-on projects to expert tips and industry insights, our goal is to equip you with the skills and knowledge needed to excel in the ever-evolving field of analytics.
Join our vibrant community of data enthusiasts, where collaboration and learning thrive. Let's explore data together and unlock new possibilities. Subscribe now and embark on your journey to becoming a data wizard with me
I believe in demystifying complex concepts and empowering learners to harness the full potential of data. From in-depth tutorials and hands-on projects to expert tips and industry insights, our goal is to equip you with the skills and knowledge needed to excel in the ever-evolving field of analytics.
Join our vibrant community of data enthusiasts, where collaboration and learning thrive. Let's explore data together and unlock new possibilities. Subscribe now and embark on your journey to becoming a data wizard with me
SQL Interview Question No of Business days between two dates
In this video i have explained how can we find the number of business days between two dates in SQL.
Download and practice github.com/ranjan717/Beyond-Numbers
#sqlserver #sqlinterviewquestionsandanswers #interviewquestions #technicalinterview #dataanalystinterview #dataanalysis #dataanalytics #sqlinterviewquestions #sqltraining #dataanalyst
Download and practice github.com/ranjan717/Beyond-Numbers
#sqlserver #sqlinterviewquestionsandanswers #interviewquestions #technicalinterview #dataanalystinterview #dataanalysis #dataanalytics #sqlinterviewquestions #sqltraining #dataanalyst
Переглядів: 49
Відео
YOY Growth over any period in Power BI
Переглядів 835 місяців тому
In this video i have explained how can we create a visual which will show YOY growth of sales of any period. #powerbi #yoygrowth #powerbi_training #powerbideveloper #dataanalysis #dataanalyst #dataanalytics #data #sqlserver
SQL tricky interview question
Переглядів 545 місяців тому
In this video i have explained how we can transform a table by applying mathematical logic and using cross join. Download the solution file from this repository: github.com/ranjan717/Beyond-Numbers.git #sql #sqlserver #sqlforbeginners #sqlinterviewquestions #sqlforbeginners #sqltraining #interviewquestions #interview #interviewpreparation #interviewhacks #dataanalyst #dataanalysis #dataanalytics
SQL Interview Question (Medium level)
Переглядів 385 місяців тому
In this video, we delve into the powerful #SQL operation known as #UNPIVOT. Have you ever had data spread across multiple columns that you wished were organized differently? UNPIVOT comes to the rescue! UNPIVOT is a versatile #SQL operation that allows you to rotate columns of a table into rows, providing a more flexible format for analysis and reporting. Whether you're dealing with quarterly s...
SQL Most Popular Interview Questions
Переглядів 735 місяців тому
In this video i have explained the solution to two of the popular interview questions often asked in interviews where interviewer wants to check advanced sql concepts like correlated sub query and , group by or date functions knowledge. Download the file and practice on your own. Fork my Github Repo github.com/ranjan717/Beyond-Numbers.git #sqlserver #sqlinterviewquestionsandanswers #sqlforbegin...
Lead and Lag in SQL Server
Переглядів 265 місяців тому
In this video i have explained what are lead and lag function and where is it useful. I have also solved one popular interview question using lead and lag that is finding the YOY sales growth. you can download the data set and sql file to practice from my github repository github.com/ranjan717/Beyond-Numbers.git #sqlserver #sqltips #sqlinterviewquestionsandanswers #sqlforbeginners #sqltraining ...
Combine two data sources to backfill data in Tableau
Переглядів 205 місяців тому
In this video i have showed the hands on how to solve a common real time challenge of backfilling data from an excel file when your tableau is having connection with another data source. Download the data and files from my github repo github.com/ranjan717/Beyond-Numbers.git #sqlserver #tableaudesktop #tableaututorial #interviewquestions #tableauinterviewquestions #tableaucertification #tableauv...
Show Top3 and Bottom 3 in the same table in SQL
Переглядів 575 місяців тому
In this video i have explained the #solution to the popular #sqlinterviewquestion of showing the both top 3 and bottom 3 product by sales. I have solved it using CTE. You can download the dataset and solution file from this github repo github.com/ranjan717/Beyond-Numbers.git #sqlinterviewquestions #sql #sqltips #sqlinterviewquestionsandanswers #sqltraining #sqlserver #datascience #dataanalysis ...
PIVOT in SQL
Переглядів 565 місяців тому
In this video i have explained what is pivot in sql and how is it useful. You can download the sql file and practice from here github.com/ranjan717/Beyond-Numbers.git SQL Pivot is a powerful operation that allows you to transform rows of data into columns, making it easier to analyze and present data in a more readable format. SQL Pivot helps analysts by improving readability, aggregation, simp...
I did this without ZN and IFNULL
Переглядів 185 місяців тому
In this video, learn how to replace blank or NULL values with zeros in your data visualizations using the LOOKUP function and Special Values. Sometimes, when working with data in Tableau, you may encounter blank or NULL values, which can affect the accuracy of your analysis and visualizations. In this hands on video, we'll explore how to use the LOOKUP function along with the ZN function to con...
Show Top 10 with a twist in SQL
Переглядів 145 місяців тому
Welcome to Beyond Numbers 🎉 In this video, you'll learn how to craft a powerful query to showcase the top 10 cities from your database. But wait, there's a twist! We'll also explore how to ensure that if a particular city doesn't make the top 10, it gracefully appears as the 11th record or joins the top tier. Whether you're a beginner looking to enhance your SQL skills or a seasoned pro seeking...
SQL Query to find fastest to 100k sales
Переглядів 415 місяців тому
In this video i have solved another popular interview question which is to find the category name which took least number of days to reach 100k sales. There can be many variations to this questions which can be asked in the interview but the logic will be the same as explained in this video. First you have to take the columns that you want in the table in select statement then create a ranking ...
Create Combined Axis Chart in Tableau using 3 Measures
Переглядів 1135 місяців тому
In this video i have shown how we can create a chart using 3 different measures along with one dimension. #tableau #tableaudesktop #tableaututorial #tableauvisualization #tableaufullcourse #dataanalysis #dataanalyst #datavisualization
Find the Highest Sales Month for each sub category in SQL
Переглядів 575 місяців тому
In this video i have solved one interview question to find the highest sales month of each sub category using common table expressions and window function. first we are writing a cte to find the sub category wise year wise and month wise total sales and then we rank the sales over sub category in the descending order of year and month and then apply filter to pick only the highest sales. #sqlse...
Find month wise cumulative sales in SQL
Переглядів 925 місяців тому
In this video, we dive into SQL to analyze sales data and calculate cumulative sales using window functions. I have used a Common Table Expression (CTE) to aggregate sales data by month. Next, we utilize the SUM() window function along with the OVER (ORDER BY) clause to calculate the cumulative sales for each month. By the end of the video, you'll understand how to use cte and window functions....
I had high hopes from Tableau Pulse, but disappointed!
Переглядів 375 місяців тому
I had high hopes from Tableau Pulse, but disappointed!
Last Business day of the month in SQL
Переглядів 1255 місяців тому
Last Business day of the month in SQL
SQL Join Explained: with duplicate values
Переглядів 305 місяців тому
SQL Join Explained: with duplicate values
Tableau Pulse: Did Tableau Get It Right?
Переглядів 265 місяців тому
Tableau Pulse: Did Tableau Get It Right?
How to make a map dashboard with dynamic web page in Tableau
Переглядів 8Рік тому
How to make a map dashboard with dynamic web page in Tableau
Tableau | How to show both Top N and Bottom N in the same sheet
Переглядів 39Рік тому
Tableau | How to show both Top N and Bottom N in the same sheet
Tableau all file formats and their uses- Part1
Переглядів 17Рік тому
Tableau all file formats and their uses- Part1
Tableau | Data interpreter | 3 ways to clean your Data
Переглядів 17Рік тому
Tableau | Data interpreter | 3 ways to clean your Data
Create Bar chart in five different ways using Tableau
Переглядів 18Рік тому
Create Bar chart in five different ways using Tableau
Nice script
Useful
Great
Yes.. Please put the schema and solution that would be helpful for all of us..
please fork my repo github.com/ranjan717/Beyond-Numbers.git
please put the schema and solution here too so that we can practice :)
please fork my repo github.com/ranjan717/Beyond-Numbers.git
Great Work
Thank you bhuwnesh bhai
❤️😇
♥️❣️
♥️♥️
Amazing channel! You deserve more views! Why don’t you use PromoSM?! You should use it to help your videos rank better in the search.
Please like and subscribe to my channel
🤩
Beautiful ❤️❤️
Wow
❤️❤️
Very nice
Nice