![Clear Waters Analytics](/img/default-banner.jpg)
- 100
- 11 941
Clear Waters Analytics
Registrace 10. 07. 2023
Your one stop shop for learning Data Analytics, Visualization with Data Governance.
About Us: We have, over a decade of experience in analyzing data and effectively presenting it using best Visualization & Story Telling techniques. We cover real life scenarios so that it helps our students during interviews.
Recently, we are also adding a course on Data Governance, a skill in very high demand amidst the growing concerns around AI in Data Management.
Discord: discord.gg/snmtuKG4tS
Email: clearwatersanalytics@gmail.com
About Us: We have, over a decade of experience in analyzing data and effectively presenting it using best Visualization & Story Telling techniques. We cover real life scenarios so that it helps our students during interviews.
Recently, we are also adding a course on Data Governance, a skill in very high demand amidst the growing concerns around AI in Data Management.
Discord: discord.gg/snmtuKG4tS
Email: clearwatersanalytics@gmail.com
Video
Power BI & Data Analytics - KPI CARDS to show high-level KPIs (Class 12)
zhlédnutí 54Před 7 dny
Welcome to Clear Waters Analytics..! In this video, we will use KPI Cards to create high-level KPIs for Credit Analytics Team & compare the KPIs with Thresholds (Target) For any queries, please write to me at "clearwatesanalytics@gmail.com" #powerbi #mysql #dataanalytics #clearwatersanalytics To download all the files used in the video, visit our Discord Channel: discord.com/invite/snmtuKG4tS L...
Power BI & Data Analytics - Adding Dashboard Filters (Slicers) (Class 11)
zhlédnutí 73Před 7 dny
Welcome to Clear Waters Analytics..! In this video, we will start creating a Dashboard Page for Credit Analytics Team. We will start creating Dashboard Filters, also known as 'Slicers' For any queries, please write to me at "clearwatesanalytics@gmail.com" #powerbi #mysql #dataanalytics #clearwatersanalytics To download all the files used in the video, visit our Discord Channel: discord.com/invi...
Power BI & Data Analytics - Reviewing CWC Dashboard's Design (Class 10)
zhlédnutí 59Před 8 dny
Welcome to Clear Waters Analytics..! In this video, we will discuss the CWC Dashboard's design. For any queries, please write to me at "clearwatesanalytics@gmail.com" #powerbi #mysql #dataanalytics #clearwatersanalytics To download all the files used in the video, visit our Discord Channel: discord.com/invite/snmtuKG4tS Link to the Project 2 Playlist (SQL & Data Analytics): czcams.com/play/PLbH...
Power BI & Data Analytics - Building Relationships between Tables & Why it is Important? (Class 9)
zhlédnutí 28Před 14 dny
Welcome to Clear Waters Analytics..! In this video, we will learn how to build relationships between different tables & why it is important. For any queries, please write to me at "clearwatesanalytics@gmail.com" #powerbi #mysql #dataanalytics #clearwatersanalytics To download all the files used in the video, visit our Discord Channel: discord.com/invite/snmtuKG4tS Link to the Project 2 Playlist...
Power BI & Data Analytics - Creating a Table of DATES in PowerBI & Why do we need it? (Class 8)
zhlédnutí 61Před 14 dny
Welcome to Clear Waters Analytics..! In this video, we will learn how to create a new table to store Dates & why it is important. For any queries, please write to me at "clearwatesanalytics@gmail.com" #powerbi #mysql #dataanalytics #clearwatersanalytics To download all the files used in the video, visit our Discord Channel: discord.com/invite/snmtuKG4tS Link to the Project 2 Playlist (SQL & Dat...
Power BI & Data Analytics - Calculate % of Walk-Ins Converted (Class 7)
zhlédnutí 16Před 15 dny
Welcome to Clear Waters Analytics..! In this video, we will learn how to create our 7th KPI - % of Walk-Ins Converted. For any queries, please write to me at "clearwatesanalytics@gmail.com" #powerbi #mysql #dataanalytics #clearwatersanalytics To download all the files used in the video, visit our Discord Channel: discord.com/invite/snmtuKG4tS Link to the Project 2 Playlist (SQL & Data Analytics...
Power BI & Data Analytics - Calculate KPIs & Validate in MySQL - Part 2 (Class 6)
zhlédnutí 88Před 17 dny
Welcome to Clear Waters Analytics..! In this video, we will continue to create measures to calculate high level KPIs for CWC & validate them in MySQL. For any queries, please write to me at "clearwatesanalytics@gmail.com" #powerbi #mysql #dataanalytics #clearwatersanalytics To download all the files used in the video, visit our Discord Channel: discord.com/invite/snmtuKG4tS Link to the Project ...
Power BI & Data Analytics - Calculate KPIs & Validate in MySQL - (Class 5)
zhlédnutí 86Před 18 dny
Welcome to Clear Waters Analytics..! In this video, we will continue to create measures to calculate high level KPIs for CWC & validate them in MySQL. For any queries, please write to me at "clearwatesanalytics@gmail.com" #powerbi #mysql #dataanalytics #clearwatersanalytics To download all the files used in the video, visit our Discord Channel: discord.com/invite/snmtuKG4tS Link to the Project ...
Power BI & Data Analytics - Download PowerBI & Prepare Datasets (Class 2)
zhlédnutí 162Před 18 dny
Welcome to Clear Waters Analytics..! In this video, we will download Power BI & prepare our Data Sets (Including Importing the CWC Database). For any queries, please write to me at "clearwatesanalytics@gmail.com" #powerbi #mysql #dataanalytics #clearwatersanalytics To download all the files used in the video, visit our Discord Channel: discord.com/invite/snmtuKG4tS Link to the Project 2 Playlis...
SQL & Data Analytics - IMPORTING CWC DATABASE
zhlédnutí 87Před 18 dny
Welcome to Clear Waters Analytics..! In this video, we will see how we can import the entire CWC Database. Please follow the steps if you are still facing error importing data or while deploying the ERD diagram. For any queries, please write to me at "clearwatesanalytics@gmail.com" #SQL #mysql #database #clearwatersanalytics #dataanalytics To download all the files used in the video, visit our ...
SQL & Data Analytics - FIXING ERRORS while creating the Database & importing Data
zhlédnutí 25Před 18 dny
Welcome to Clear Waters Analytics..! In this video, we will address the errors you might face during: - Deploying the EDR diagram (Forward Engineer) - Importing the Data into tables For any queries, please write to me at "clearwatesanalytics@gmail.com" #SQL #mysql #database #clearwatersanalytics #dataanalytics To download all the files used in the video, visit our Discord Channel: discord.com/i...
Power BI & Data Analytics - Discuss CWC's Problem Statements & Create our First Measures (Class 4)
zhlédnutí 101Před 20 dny
Welcome to Clear Waters Analytics..! In this video, we will discuss & understand CWC's Problem Statements & create our first Key Measures to create high-level KPIs & address these problem statements. For any queries, please write to me at "clearwatesanalytics@gmail.com" #powerbi #mysql #dataanalytics #clearwatersanalytics To download all the files used in the video, visit our Discord Channel: d...
Power BI & Data Analytics - Importing Data from a Database into PowerBI (Class 3)
zhlédnutí 54Před 22 dny
Welcome to Clear Waters Analytics..! In this video, we will import the following Data sets: - All Applications (SQL Query on MySQL Database) - All Walkins For any queries, please write to me at "clearwatesanalytics@gmail.com" #powerbi #mysql #dataanalytics #clearwatersanalytics To download all the files used in the video, visit our Discord Channel: discord.com/invite/snmtuKG4tS Link to the Proj...
Power BI & Data Analytics - What will you learn in this Project? (Class 1)
zhlédnutí 125Před 23 dny
Welcome to Clear Waters Analytics..! In this video, we will start with our 3rd Project where we will be creating a KPI Dashboard for CWC in PowerBI. We learn in the video what will be covered in this project. For any queries, please write to me at "clearwatesanalytics@gmail.com" #powerbi #mysql #dataanalytics #clearwatersanalytics To download all the files used in the video, visit our Discord C...
SQL & Data Analytics - SQL Exercises - Applications within SLA
zhlédnutí 327Před měsícem
Welcome to Clear Waters Analytics..! In this video, we continue with the SQL exercises. We address CWC's Problem Statements & explore the following KPI - % of Applications within SLA (Service Level Agreement) For any queries, please write to me at "clearwatesanalytics@gmail.com" #SQL #mysql #database #clearwatersanalytics #dataanalytics To download all the files used in the video, visit our Dis...
Uplod full Series please ❤ Loved it
Here is the full playlist on SQL & Data Analytics czcams.com/play/PLbH1DZ2I6Y3-_wRgvGf9O29lPIVL0-syT.html&si=TdiIgBS6ArYUzZro
@@ClearWatersAnalytics I am following this Sir but I want further Topics your way of teaching is so cool and easy to understand I want to learn advance SQL too from you .
👌👌
Sir i am not able to find your discord channel. I search with this " clear water analytics " And nothing is showing there. Please help i am doing your sql course
Use the discord invite link: discord.com/invite/snmtuKG4tS
Data kha h for practice
All the materials and exercises are available on our discord channel. The link is the description of the video. Here is the link: discord.com/invite/snmtuKG4tS Let me know if you still need help. Happy Analytics.! 😊 Thanks for watching..!
Select updated_reason, count(message) from new_table group by updated_reason ; new_table = what u got this table in this video
Make sure you use count(*). This will ensure all the records in the displayed output is counted. If a column you are counting on contains null values, you might miss a few records. Your query looks good otherwise. 👍
thoda font size bda lo.. follow karne mai assan hoga.
Sure, absolutely..! Will do that from the next video. Thanks for sharing your feedback. 😊
Provide dataset and question pdf also
sure, please find the exercises file & csv files for the tables on our Discord server: discord.com/invite/snmtuKG4tS All our files are available there..!
As videos are comming can i say if i will follow you will make it to advance level
Are you saying you would like to see videos on advanced topics? If yes, for Data Analytics we only need to know basics of databases and SQL which will be covered in this SQL & Data Analytics playlist: czcams.com/play/PLbH1DZ2I6Y3-_wRgvGf9O29lPIVL0-syT.html&si=AmzvXaI4uN_H_Bbx Happy Analytics..! 😊
Hello, kindly share the data set so that I can practise along with the video
sure, please find the KPI Dashboard excel file on our Discord server: discord.com/invite/snmtuKG4tS All our files are available there..!
select application_id,date_tagged,date_actioned,qu.queue_id,queue_name , oc.outcome,oc.outcome_id,aly.analyst_id,aly.first_name,aly.last_name, gender,birth_year,ct.city_name,gn.gender_name,cn.name,st.store_name,message from applications ap left join queue qu on ap.queue_id=qu.queue_id left join outcome oc on ap.outcome_id=oc.outcome_id left join analysts aly on ap.analyst_id=aly.analyst_id left join city ct on aly.city=ct.city_id left join gender gn on aly.gender=gn.gender_id left join country cn on aly.country=cn.country_id left join store st on ap.store_id=st.store_id
perfect..! 💯
Nice..! 👌 🍻
Hi the video is very awesome. I have 1 questions i am pursuing right now data analytics coy near by 1yr complete but still I have lot confusion in MySQL. I am from non it background and I want switch my domain to hike my courier. Pls suggest something for MySQL and it is right decision to switch from mis to data analytics.
I am glad you found the videos helpful. It is of course a correct decision to move into data analytics if you are currently into MIS. So, you are on the right track. When it comes to SQL, always think about why you want to learn SQL. Mostly, you will be using to validate the numbers, just like how you do that in excel. And besides that, you will using mysql to extract data to eventually pull into some data visualisation tool such as power bi or tableau to create dashboards. Continue to watch my sql videos to get comfortable with the language. Post sql, I would recommend you start learning power bi or any other visualisation tool. All the best..!
Thank u so much sir, for ur suggestion. I am already learning tableu visualisation with MySQL. Pls make more videos in my Sql with the question base.
too good do you teach in batches if yes would love to take your course
Glad I am able to help. 😊 Yes, we have batches on weekends. Both offline & online lectures are conducted along with these videos. Please feel free to reach out on +91-9833882838 for further details.
sir plz provide this sheet 🥹 BTW your content is very helpful 💖💖💖💖💖💖
Sure Rohit. You can find all the materials on discord. Download the discord application on your phone or laptop and search for my channel name “clearwatersanalytics_14702” Also here is the invite to my discord channel: discord.com/invite/snmtuKG4tS
please make a dedicated video on sql joins..
Yes, we will get there once our database is ready. 😊
Hi Naved, I hope you are still engaged. Please check out new videos on SQL joins. Feel free to drop a comment or question. 😊
Thanks for making learning easy and fun! Great job!
Thanks for posting 😊
Thank you sir Please upload more videos ❤
I am glad you liked it. I try to upload videos on weekends. You may also think of joining our online classes. I will share the details if you are interested.
😂😂funny and knowledgeable at the same time
Superb explanation 👍😃
Welcome to Clear Waters Analytics..! In this video, we continue to build a database in MySQL for our fictitious company "Clear Waters Communication". We will learn what are fact & dimension tables and what are different types of database schemas. We will use MySQL to create the database. #databasedesign #mysql #databaseschema #clearwatersanalytics To download all the files used in the video, visit our Discord Channel: discord.gg/PD9y9P8P Link to the Project 1 Playlist (Data Analytics Using Excel): czcams.com/play/PLbH1DZ2I6Y38mfc1FSe5_JNuBj5ytx0mY.html
Thank you for posting 😊
Thanks Taizoon..! I hope this playlist let’s you revisit the database concepts we learnt in the class. 😊
In this video, we continue to build a database in MySQL for our fictitious company "Clear Waters Communication". We will continue to learn what is Entity Relationship Diagram (ERD) and Foreign Key and how these are used in creating a database. We will use MySQL to create the database. #dataanalytics #databasedesign #mysql #ERD #clearwatersanalytics To download all the files used in the video, visit our Discord Channel: discord.gg/PD9y9P8P Link to the Project 1 Playlist (Data Analytics Using Excel): czcams.com/play/PLbH1DZ2I6Y38mfc1FSe5_JNuBj5ytx0mY.html
In this video, we continue to create the Entity Relationship Diagram (ERD) for Clear Waters Communication. We will use MySQL to create ERD. #dataanalytics #databasedesign #ERD To download all the files used in the video, visit our Discord Channel: discord.gg/PD9y9P8P Link to the Project 1 Playlist (Data Analytics Using Excel): czcams.com/play/PLbH1DZ2I6Y38mfc1FSe5_JNuBj5ytx0mY.html
Discord invite to download the files are no longer valid. Kindly share the files again. Thank you.
In this video, we will start creating Entity Relationship Diagram (ERD) for Clear Waters Communication. We will use MySQL to create ERD. #sql #mysql #databasedesign #databases #dataanalytics To download all the files used in the video, visit our Discord Channel: discord.gg/PD9y9P8P Link to the Project 1 Playlist (Data Analytics Using Excel): czcams.com/play/PLbH1DZ2I6Y38mfc1FSe5_JNuBj5ytx0mY.html
nice explanation sir..
Thanks Naved. Glad you enjoyed it. 😊
Hi Naved. I have added 3 new videos to the SQL playlist. Please take a look. Hopefully it helps..! 😊
Please upload the video daily basis 😊😊
I wish I could. 😀 Currently I have a full time job that leaves me only weekends for my students in my data analytics class & for videos. I hope you like these videos and these are helpful. Thanks for watching..! ♥️
Uploaded 3 more videos to the SQL playlist. Please check out. Hope you are practising..! 😊
Sir 3 Months Daily 12,14 Hours' Learning kiya To Job Lag jayega Kya
Projects pe kaam karo. Jitna jyaada projects dikha paaoge utna jyaada seekh paaoge aur interviews main faayda hoga.
hello my name is manish i have 6 month of exp as intern & looking for job in data field. i want to learn ETL tool so which tool should i learn Altreyx or Informtica. and should i need to learn cloud?
Hi Manish, Thanks for reaching out. 😊 Informatica is widely used for more straightforward ETL processes and it is easier to learn with better online community for you to search for help/ documentation. The company I work for, extensively uses AbInitio as an ETL tool. The learning curve is longer but very rewarding. AbInitio is used for complex data integration tasks such as DQ rules, harvesting data dictionary, etc. I don’t know much about Altreyx so I can’t share a suggestion. Yes, surely get yourself familiar with cloud. More and more companies are moving their on-prem stuff to cloud. AWS has a few great training materials to get you started. Happy Exploring..! 👍
@@ClearWatersAnalytics Thank You
Good😊😊
🎉
Very nice
Here are the important links that you can use to follow along: All Materials & Files used in Project 1: discord.gg/PD9y9P8P CZcams Playlist on Project 1: czcams.com/play/PLbH1DZ2I6Y38mfc1FSe5_JNuBj5ytx0mY.html Happy Data Analytics..! 😃
Here are the important links that you can use to follow along: All Materials & Files used in Project 1: discord.gg/PD9y9P8P CZcams Playlist on Project 1: czcams.com/play/PLbH1DZ2I6Y38mfc1FSe5_JNuBj5ytx0mY.html Happy Data Analytics..! 😃
Here are the important links that you can use to follow along: All Materials & Files used in Project 1: discord.gg/PD9y9P8P CZcams Playlist on Project 1: czcams.com/play/PLbH1DZ2I6Y38mfc1FSe5_JNuBj5ytx0mY.html Happy Data Analytics..! 😃
Excellent clear and concise. Loved it
Thanks. Glad you enjoyed it..! 😊
Nice project