- Видео 56
- Просмотров 15 378
Professor Analytics
Индия
Добавлен 29 июн 2021
Welcome to Professor Analytics! 📊🔍 Dive into our channel to master data analysis, Tableau, Python, SQL, BI solutions, and ML modeling. Whether you're a novice or pro, our tutorials cover everything!
#DataAnalysis #Tableau #Python #SQL #BISolutions
Discover the art of data cleaning, analysis, and preparation with our comprehensive tutorials. Learn how to craft visually stunning and insightful dashboards using Tableau, unravel Python's power for data manipulation, visualization, and machine learning.
#DataVisualization #DataPreparation #BusinessIntelligence
Empower yourself with BI tools, enabling informed decision-making within your organization.
#PredictiveModeling #DataDrivenDecisions #AnalyticsEducation
Join us at Professor Analytics, where we equip you with the skills to excel in the dynamic world of data analysis. Subscribe now for a transformative learning experience and become a proficient data-driven decision-maker!
#DataSkills #AnalyticsTraining #EmpowerWithData
#DataAnalysis #Tableau #Python #SQL #BISolutions
Discover the art of data cleaning, analysis, and preparation with our comprehensive tutorials. Learn how to craft visually stunning and insightful dashboards using Tableau, unravel Python's power for data manipulation, visualization, and machine learning.
#DataVisualization #DataPreparation #BusinessIntelligence
Empower yourself with BI tools, enabling informed decision-making within your organization.
#PredictiveModeling #DataDrivenDecisions #AnalyticsEducation
Join us at Professor Analytics, where we equip you with the skills to excel in the dynamic world of data analysis. Subscribe now for a transformative learning experience and become a proficient data-driven decision-maker!
#DataSkills #AnalyticsTraining #EmpowerWithData
Most Common SQL Interview Question : Fetch n consecutive records | Day 6
#sqlinterviewquestionsandanswers #sqlinterviewquestions #dataanalyst
#sqlinterviewquestionsandanswers #Solvingintermediatequeries
#sqlinterviewquestions
In this video, I solve a REAL SQL Interview PROBLEM asked for Business Analysts.
In this problem, we need to write a SQL Query to fetch n consecutive records.
THANK YOU for watching! Do subscribe if haven't yet!!
Query:
CREATE TABLE IF NOT EXISTS orders (
order_id VARCHAR(20) PRIMARY KEY,
order_date DATE NOT NULL
);
-- Insert values into the orders table
INSERT INTO orders (order_id, order_date) VALUES
('ORD1001', STR_TO_DATE('2021-Jan-01','%Y-%b-%d')),
('ORD1002', STR_TO_DATE('2021-Feb-01','%Y-%b-%d')),
('ORD1003', STR_TO_DATE('2021-Feb-02','%Y-%...
#sqlinterviewquestionsandanswers #Solvingintermediatequeries
#sqlinterviewquestions
In this video, I solve a REAL SQL Interview PROBLEM asked for Business Analysts.
In this problem, we need to write a SQL Query to fetch n consecutive records.
THANK YOU for watching! Do subscribe if haven't yet!!
Query:
CREATE TABLE IF NOT EXISTS orders (
order_id VARCHAR(20) PRIMARY KEY,
order_date DATE NOT NULL
);
-- Insert values into the orders table
INSERT INTO orders (order_id, order_date) VALUES
('ORD1001', STR_TO_DATE('2021-Jan-01','%Y-%b-%d')),
('ORD1002', STR_TO_DATE('2021-Feb-01','%Y-%b-%d')),
('ORD1003', STR_TO_DATE('2021-Feb-02','%Y-%...
Просмотров: 85
Видео
SQL Interview Query | Day 5: Facebook SQL Challenge| 11 days|#sqlinterviewquestionsandanswers
Просмотров 533 месяца назад
#sqlinterviewquestionsandanswers #sqlinterviewquestions #dataanalyst #sqlinterviewquestionsandanswers #Solvingintermediatequeries #sqlinterviewquestions In this video, I solve a REAL SQL Interview PROBLEM asked by Facebook. THANK YOU for watching! Do subscribe if haven't yet!!
SQL Interview Query | Day 4: Big 4 Interview Question| 11 days|#sqlinterviewquestionsandanswers
Просмотров 783 месяца назад
#sqlinterviewquestionsandanswers #sqlinterviewquestions #dataanalyst #sqlinterviewquestionsandanswers #Solvingintermediatequeries #sqlinterviewquestions In this video, I solve a REAL SQL Interview PROBLEM asked by Big 4 Consulting Firms. In this problem, we need to write a SQL Query to fetch the record of brand whose amount is increasing every year. THANK YOU for watching! Do subscribe if haven...
Amazon Sql interview question| Solving 11 day SQL Challenge #sqlinterviewquestionsandanswers
Просмотров 1793 месяца назад
#sqlinterviewquestionsandanswers #sqlinterviewquestions #dataanalyst #sqlinterviewquestionsandanswers #Solvingintermediatequeries #sqlinterviewquestions In this video, I solve a REAL SQL Interview PROBLEM asked for Business Analysts. In this problem, we need to write a SQL Query to Generate a report to showcase the period of presence and absense of each employee as shown in expected output. THA...
Solving SQL Interview Question for Business Analyst| Challenge 2| #sqlinterviewquestionsandanswers
Просмотров 2723 месяца назад
#sqlinterviewquestionsandanswers #sqlinterviewquestions #dataanalyst #sqlinterviewquestionsandanswers #Solvingintermediatequeries #sqlinterviewquestions In this video, I solve a REAL SQL Interview PROBLEM asked for Business Analysts. In this problem, we need to write a SQL Query to show most successful and Failed campaign run over an advertising company. THANK YOU for watching! Do subscribe if ...
Solving SQL Interview Questions by Product Based/Consultant Companies(11 Day Challenge)| Walmart
Просмотров 943 месяца назад
#sqlinterviewquestionsandanswers #Solvingintermediatequeries #sqlinterviewquestions In this video, I solve a REAL SQL Interview PROBLEM asked by Walmart. In this problem, we need to write a SQL Query to Find out first and last call was to the same person on a given day. THANK YOU for watching! Do subscribe if haven't yet!! Script for Creating Table: create table phonelogs( Callerid int, Recipie...
Analysing Customer behaviour using Churn Analysis Step by Step in Tableau @professoranalytics
Просмотров 1334 месяца назад
#DataScience #MachineLearning #DataAnalysis #churn #customerchurnanalysis "Welcome back, analytics enthusiasts, to another enlightening episode on Professor Analytics! Today, we're delving deep into the realm of churn and retention analysis, and what better tool to leverage than Tableau? Join us on a journey through insightful data visualizations as we uncover the patterns and trends that shape...
Unleash Your Data Visualisation Skills: Tableau Bootcamp April Month Enroll now!!! Date TBD
Просмотров 656 месяцев назад
Are you ready to dive into the dynamic world of data visualization? Join us for an immersive Tableau Bootcamp starting from next weekend, April 6th, 2024! Whether you're a beginner looking to kickstart your journey in data analytics or a professional aiming to enhance your Tableau skills, this bootcamp is tailored just for you. Bootcamp Overview: - Duration: 14 days - Location: Virtual (Zoom) -...
Mastering Ecommerce Funnel Analysis with MySQL | Boost Sales with Data Insights!
Просмотров 2717 месяцев назад
Welcome to our latest video where we dive deep into the world of ecommerce funnel analysis using MySQL! 📊💻 In this comprehensive tutorial, we'll show you how to leverage the power of data to optimize your sales funnel and skyrocket your revenue. Whether you're a seasoned data analyst or just starting out, this video has something for everyone! 🔍 Here's what you'll learn: Understanding the ecomm...
#WOW2023 | Week 51 | Elf Economics| Analysing The Toy Building Tracker, in all its festive glory !!!
Просмотров 2489 месяцев назад
#Tableau #workoutwednesdays #dataanalysis Challenge:workout-wednesday.com/2023w51/ The Christmas Season is upon us and with that we bring you one last collab for the year - the Preppin’ Data team is back with a festive challenge for you all. The goal of that challenge is to get the data Tableau-ready. You will produce two outputs which are both used in this special ‘Elf Economics’ Workout Wedne...
Master Python Visualization with Plotly and Dash Tutorial | Data Visualization Made Easy! Part 1
Просмотров 58310 месяцев назад
Welcome to your ultimate guide to mastering Python data visualization using Plotly and Dash! 🚀 Whether you're a beginner or an experienced coder, this comprehensive tutorial will walk you through the intricacies of Plotly's interactive plots and Dash's powerful web-based data visualization framework. In this tutorial series, we'll cover everything from the basics to advanced techniques, enablin...
Step by Step Process to prepare data for Modelling -Part 2 Transitioning from EDA to ML Algorithm
Просмотров 47910 месяцев назад
Step by Step Process to prepare data for Modelling -Part 2 Transitioning from EDA to ML Algorithm
Step By Step Process In EDA And Feature Engineering In Data Science Project| Customer ChurnEDAPython
Просмотров 1,6 тыс.10 месяцев назад
Step By Step Process In EDA And Feature Engineering In Data Science Project| Customer ChurnEDAPython
Dynamic Zone Visibility Comprehensive Tutorial: Use Case: Dynamic Zooming in and out in Dashboard
Просмотров 33011 месяцев назад
Dynamic Zone Visibility Comprehensive Tutorial: Use Case: Dynamic Zooming in and out in Dashboard
Wine Tasting by Blind| How to build cool Dashboard like this?#workoutwednesdays #tableau #analytics
Просмотров 160Год назад
Wine Tasting by Blind| How to build cool Dashboard like this?#workoutwednesdays #tableau #analytics
Tour de France 2023- Infographic (Feel like an Artist and my Bicycle is my brush)
Просмотров 65Год назад
Tour de France 2023- Infographic (Feel like an Artist and my Bicycle is my brush)
Bivariate Map in Tableau| Chloropeth Map in Tableau in 20 min | How to build customlegendsinTableau?
Просмотров 322Год назад
Bivariate Map in Tableau| Chloropeth Map in Tableau in 20 min | How to build customlegendsinTableau?
#tableau -Likert Chart | Survey Data Analysis using Airlines Passenger | Promoters and Detractors
Просмотров 637Год назад
#tableau -Likert Chart | Survey Data Analysis using Airlines Passenger | Promoters and Detractors
How to Calculate Year to Date(YTD) vs Prior Year to Date for a selected timestamp?|How to design KPI
Просмотров 363Год назад
How to Calculate Year to Date(YTD) vs Prior Year to Date for a selected timestamp?|How to design KPI
How to customise map using Sets and adding custom lists for end users in Tableau+ KPI altogether
Просмотров 203Год назад
How to customise map using Sets and adding custom lists for end users in Tableau KPI altogether
How to use Custom Shapes + Proportional brushing in Tableau using Set Actions? #Set#customshapes
Просмотров 151Год назад
How to use Custom Shapes Proportional brushing in Tableau using Set Actions? #Set#customshapes
Can you use Dynamic Axis Title in Tableau? |New Feature in Tableau| WOW2023|W15|@professoranalytics
Просмотров 116Год назад
Can you use Dynamic Axis Title in Tableau? |New Feature in Tableau| WOW2023|W15|@professoranalytics
How to calculate Day over Day change excluding weekends? | Tableau @professoranalytics |Industry Lvl
Просмотров 403Год назад
How to calculate Day over Day change excluding weekends? | Tableau @professoranalytics |Industry Lvl
Can you use Image Role + Dynamic Zone Visibility in Tableau?|#WOW2023 Week 1 | Building from Scratch
Просмотров 642Год назад
Can you use Image Role Dynamic Zone Visibility in Tableau?|#WOW2023 Week 1 | Building from Scratch
Dynamic Zone Visibility with Real World Use Cases | Tableau 2022.4 Sheet Swapping made easyinTableau
Просмотров 1,1 тыс.Год назад
Dynamic Zone Visibility with Real World Use Cases | Tableau 2022.4 Sheet Swapping made easyinTableau
How to Compare Latest Month Measure with prior N Months Measure in Tableau| @professoranalytics
Просмотров 93Год назад
How to Compare Latest Month Measure with prior N Months Measure in Tableau| @professoranalytics
Roadmap to Become an BI Expert | Data &Analytics | Business Intelligence Roadmap| Path to Analytics
Просмотров 184Год назад
Roadmap to Become an BI Expert | Data &Analytics | Business Intelligence Roadmap| Path to Analytics
Dynamic Dates in a Heatmap| Workout Wednesday| #WOW2022 #datafam #analytics
Просмотров 3422 года назад
Dynamic Dates in a Heatmap| Workout Wednesday| #WOW2022 #datafam #analytics
Relative Filtering in Tableau| Year to Date, Month to Date ,Quarter to Date| Dynamic Comparing 2 Yr.
Просмотров 8502 года назад
Relative Filtering in Tableau| Year to Date, Month to Date ,Quarter to Date| Dynamic Comparing 2 Yr.
Data Blending in Tableau | Professor Analytics | Data & Analytics | Business Intelligence
Просмотров 2842 года назад
Data Blending in Tableau | Professor Analytics | Data & Analytics | Business Intelligence