Atul Kadlag
Atul Kadlag
  • 423
  • 1 022 080
Joins in SQL | Intermediate SQL tutorial
Lets learn joins in SQL with practical example
📖 Download SQL joins Query file from Github : github.com/AtulKadlag/MySQL_Intermediate_YTSeries/blob/main/Intermediate%20-%20joins.sql
Resources:
Udemy Courses:
📖 Take my Full Power BI course here - www.udemy.com/course/master-microsoft-power-bi-in-21-days/
📖 Take my Full SQL Course here - www.udemy.com/course/complete-sql/
📖 Take Excel to pro course here - www.udemy.com/course/pro-excel/
zhlédnutí: 16

Video

Limit and Alas in SQL | MySQL for Beginners
zhlédnutí 21Před 16 hodinami
In this lesson we are going to learn about Limit and Alas in SQL Download Limit and Alias Query file from Github : github.com/AtulKadlag/MySQL_Beginner_YT_Series/blob/main/6. limit and Alias.sql Resources: Udemy Courses: Take my Full Power BI course here - www.udemy.com/course/master-microsoft-power-bi-in-21-days/ Take my Full SQL Course here - www.udemy.com/course/complete-sql/ Take Excel ...
Where vs Having in SQL | MySQL for Beginners
zhlédnutí 28Před 14 dny
In this lesson we are going to learn about group by and Order by in SQL Download Having vs Where Query file from Github : github.com/AtulKadlag/MySQL_Beginner_YT_Series/blob/main/5.Having vs Where.sql Resources: Udemy Courses: Take my Full Power BI course here - www.udemy.com/course/master-microsoft-power-bi-in-21-days/ Take my Full SQL Course here - www.udemy.com/course/complete-sql/ Take ...
Group by + Order by SQL | MySQL for Beginners
zhlédnutí 23Před 21 dnem
In this lesson we are going to learn about group by and Order by in SQL Download MySQL here: dev.mysql.com/downloads/installer/ Download WHERE Clause query file from Github : github.com/AtulKadlag/MySQL_Beginner_YT_Series/blob/main/4.Group By + Order By.sql Resources: Udemy Courses: Take my Full Power BI course here - www.udemy.com/course/master-microsoft-power-bi-in-21-days/ Take my Full S...
WHERE Clause SQL | MySQL for Beginners
zhlédnutí 35Před 28 dny
In this lesson we are going to learn about WHERE clause in SQL Download MySQL here: dev.mysql.com/downloads/installer/ Download WHERE Clause query file from Github : github.com/AtulKadlag/MySQL_Beginner_YT_Series/blob/main/3.WHERE Clause.sql Resources: Udemy Courses: Take my Full Power BI course here - www.udemy.com/course/master-microsoft-power-bi-in-21-days/ Take my Full SQL Course here -...
Basic SELECT Statement | MySQL for Beginners
zhlédnutí 313Před měsícem
In this lesson we are going to learn about basics SELECT statement in SQL Download MySQL here: dev.mysql.com/downloads/installer/ Download SELECT query file from Github : github.com/AtulKadlag/MySQL_Beginner_YT_Series/blob/main/2.BASIC SELECT TUTORIAL.sql Resources: Udemy Courses: Take my Full Power BI course here - www.udemy.com/course/master-microsoft-power-bi-in-21-days/ Take my Full SQL...
Installing MySQL and Creating Databases | MySQL for Beginners
zhlédnutí 123Před měsícem
In this lesson we are going to install MySQL and create our database. Download MySQL here: dev.mysql.com/downloads/installer/ Download Database file from Github : github.com/AtulKadlag/MySQL_Beginner_YT_Series/blob/main/Beginner - Supply_and_Logistics_Create_db.sql Resources: Udemy Courses: Take my Full Power BI course here - www.udemy.com/course/master-microsoft-power-bi-in-21-days/ Take m...
Start your Data Journey | Understand Data | Data Learning
zhlédnutí 59Před měsícem
Start your Data Journey | Understand Data | Data Learning
Grow your career 10X with these tools #career #reportingtool
zhlédnutí 467Před rokem
As a report developer if you are feeling stuck and do not see many opportunities outside just learn some of advance tools which will help you to advance your career. In this video I have shared some of the tips which you can learn and become a data analyst. Complete SQL tutorial - bit.ly/3Tf3OOg complete Microsoft Power BI tutorial - bit.ly/425Vt3u
How to keep track of attendance in Google Sheets #shorts #googlesheets #excel
zhlédnutí 105Před rokem
In this video we will see how to keep track of attendance in Google sheets. With the help of tick box we can easily keep track of attendance very quickly. -
7 Ways to use CHAT GPT for Data Analytics
zhlédnutí 330Před rokem
Lets understand how we can use ChatGPT for Data analytics project
How to compare two files in notepad++ | Notepad++ tutorial | Compare files easily
zhlédnutí 17KPřed rokem
How to compare two files in notepad | Notepad tutorial | Compare files easily
Step-by-Step Guide: Writing a Resume for Freshers with ChatGPT
zhlédnutí 273Před rokem
Step-by-Step Guide: Writing a Resume for Freshers with ChatGPT
Chat GPT for Report developers | Chat GPT for Data Analyst | How to use Chat GPT effectively
zhlédnutí 397Před rokem
Chat GPT for Report developers | Chat GPT for Data Analyst | How to use Chat GPT effectively
Mathematical Operations in SQL #sqlcourse
zhlédnutí 137Před rokem
Mathematical Operations in SQL #sqlcourse
Aliases in SQL
zhlédnutí 224Před rokem
Aliases in SQL
how to remove space in sql table column value | remove left space | remove right space in SQL
zhlédnutí 3,9KPřed rokem
how to remove space in sql table column value | remove left space | remove right space in SQL
calculated fields in SQL query | How to do calculation in SQL | Theory with Hands on
zhlédnutí 791Před rokem
calculated fields in SQL query | How to do calculation in SQL | Theory with Hands on
import CSV file in SQL server | sql Full SQL Course | step by step
zhlédnutí 127Před rokem
import CSV file in SQL server | sql Full SQL Course | step by step
practical Join in SQL | sql Full SQL Course | step by step
zhlédnutí 125Před rokem
practical Join in SQL | sql Full SQL Course | step by step
Join in SQL | sql Full SQL Course | step by step
zhlédnutí 65Před rokem
Join in SQL | sql Full SQL Course | step by step
practical example of group by | sql Full SQL Course | step by step
zhlédnutí 55Před rokem
practical example of group by | sql Full SQL Course | step by step
How to group data in table | sql Full SQL Course | step by step
zhlédnutí 49Před rokem
How to group data in table | sql Full SQL Course | step by step
Practical | How to sort data in table | sql Full SQL Course | step by step
zhlédnutí 58Před rokem
Practical | How to sort data in table | sql Full SQL Course | step by step
How to sort data in table | sql Full SQL Course | step by step
zhlédnutí 41Před rokem
How to sort data in table | sql Full SQL Course | step by step
future of BO developers #sap | sap bo
zhlédnutí 3,3KPřed rokem
future of BO developers #sap | sap bo
Practical like operator in sql | string pattern in sql Full SQL Course | step by step
zhlédnutí 62Před rokem
Practical like operator in sql | string pattern in sql Full SQL Course | step by step
like operator in sql | string pattern in sql Full SQL Course | step by step
zhlédnutí 53Před rokem
like operator in sql | string pattern in sql Full SQL Course | step by step
how to update data in sql table in SQL | Full SQL | step by step | how to delete data in table
zhlédnutí 41Před rokem
how to update data in sql table in SQL | Full SQL | step by step | how to delete data in table
Clear AWS cloud practitioner exam in less time | AWS Cloud practitioner exam - CLF-C01
zhlédnutí 633Před rokem
Clear AWS cloud practitioner exam in less time | AWS Cloud practitioner exam - CLF-C01

Komentáře

  • @sss4-tk8bf
    @sss4-tk8bf Před 3 dny

    Am working on SAC.

  • @katyhessni
    @katyhessni Před 27 dny

    thanks

  • @cyborgat23
    @cyborgat23 Před měsícem

    App_ unavailable_select_new error is not letting me save my planning story in SAC. What could be the reason behind it?

    • @AtulKadlag
      @AtulKadlag Před měsícem

      seems server error, please try again after sometime..

  • @cyborgat23
    @cyborgat23 Před měsícem

    App_ unavailable_select_new error is not letting me save my story in SAC. What could be the reason behind it?

  • @devenderpattem9801
    @devenderpattem9801 Před měsícem

    Hi bro how r u

    • @AtulKadlag
      @AtulKadlag Před měsícem

      Doing well, thanks for asking, Hope you are doing great!!

  • @Josh4ualways
    @Josh4ualways Před měsícem

    Bro how to add radio buttons in story board?

    • @AtulKadlag
      @AtulKadlag Před měsícem

      there is a option available for Radio button while you design the story..check in menu option.

  • @Fullcontact1992
    @Fullcontact1992 Před měsícem

    Can I create model from multiple model ? I have some problem with data blending on story level. Some of the functions are not working but I have two model that is why I want to merge two model

    • @AtulKadlag
      @AtulKadlag Před měsícem

      yes, this can be done with data blending. add the two models in the data source one by one .. Once you add the models perform following steps. 1) Once you have added both models to your story, you can start blending the data. 2) Go to the story page and create a new table or chart. 3) Select the primary model for the table or chart. 4) Then, click on the “Blend Data” icon (usually represented by a link or chain symbol). 5) Select the secondary model you want to blend with the primary model. 6) Create a Link: You will need to create a link between the two models. This is done by selecting a common dimension or measure that exists in both models. Define the relationship (e.g., Inner Join, Left Join) based on your requirement. 7) Configure Blend Options: You can configure various blend options such as aggregation types, link type, and others to ensure the data is combined correctly. 8) Use Blended Data: After creating the link, you can now use the blended data in your story. You can drag and drop measures and dimensions from both models into your table or chart. Hope this helps

  • @sarthakdukane1073
    @sarthakdukane1073 Před měsícem

    गुरु गोविंद दोऊ खड़े काके लागू पाय...! बलिहारी गुरु आपने गोविंद दियो बताए...!! गुरुपर्णिमेच्या हार्दिक शुभेच्छा सर...🙏🏻

  • @amiyasagar2258
    @amiyasagar2258 Před měsícem

    Very helpful. You discussed everything I was worried about. Is switching from BO to ABAP a good option?

    • @AtulKadlag
      @AtulKadlag Před měsícem

      I would suggest instead of ABAP, look at ETL side(SAP BODS), or datasphere... because ABAP has steady growth and limited opportunities as per my understanding.. thank you..

  • @patrycjakoek944
    @patrycjakoek944 Před měsícem

    Hello how to connect two excel models. One of them contain indicators (for 10 dimensions) the other model contain targets (but just for 2 dimensions). How to connect this and make that if user filter data by dimensions (which are not included in model with targets) that will show blank space or 0?

  • @vardhankonda
    @vardhankonda Před 2 měsíci

    how to make open a new browser tab in sac stories using scripting or any other way if any

    • @AtulKadlag
      @AtulKadlag Před 2 měsíci

      below is the sample code for this you can try in SAC script var url = "www.example.com"; // Replace with your desired URL Application.openURL(url, false); // 'false' opens the URL in a new tab make sure you add it in onClick on a buton

  • @binita5648
    @binita5648 Před 2 měsíci

    Is there a way to define a static variable without using table in SAP Bo IDT tool? I don't want to use the table.i need to manually enter the constant values

  • @prakashchandradas7955
    @prakashchandradas7955 Před 2 měsíci

    Do you have the video or blog link ready- how to make dropdown as multi selection?

  • @SiddhiiiJadhav
    @SiddhiiiJadhav Před 2 měsíci

    Well explained

  • @John_theodore
    @John_theodore Před 2 měsíci

    Good overview!!!

  • @user-yq3em4zz6y
    @user-yq3em4zz6y Před 3 měsíci

    Hi Atul, I am working in SAP ABAP module. Can I learn SAC? Do I need to learn any other module before starting SAC? Thanks in Advance!!

    • @AtulKadlag
      @AtulKadlag Před 3 měsíci

      Yes, you can.. you can directly learn SAC

  • @ndz7372
    @ndz7372 Před 3 měsíci

    Thanks a bunch!

  • @user-xp6hg2ld6z
    @user-xp6hg2ld6z Před 3 měsíci

    Hi, Thank you so much.. I am working as data Analyst using Crystal report and Power bi reporting tool.. will Sac and sap business one help me to get new Sap role in the Market? I want to make career in Sap..

    • @AtulKadlag
      @AtulKadlag Před 3 měsíci

      yes, definitely, if you want to switch to SAP side, SAC will be good option, I will suggest along with SAC you can learn SAP Datasphere as well, which will help you to boost your profile.

    • @user-xp6hg2ld6z
      @user-xp6hg2ld6z Před 3 měsíci

      @@AtulKadlag thank you for your valuable reply 🙏

  • @AasvithaAdikkesavelu-wb6eh
    @AasvithaAdikkesavelu-wb6eh Před 3 měsíci

    Where can I find the other model??

  • @aryachauhan1388
    @aryachauhan1388 Před 4 měsíci

    Hi Atul, i am working on FPnA profile. Already working on on Planning, Forecasting, Budgeting. I want to move on SAC, can you pla help me better platform to learn and certification

  • @rayhanhidayat899
    @rayhanhidayat899 Před 4 měsíci

    Hello atul, can you send me the sample datasource? i was check in "Public Folder-> Design Studio Samples" of the BI launchpad installed but not found it, because im used SAP Lumira Designer

  • @conradblume4274
    @conradblume4274 Před 4 měsíci

    Need a little more information, why ISNUMBER?

  • @jeremyflowers8908
    @jeremyflowers8908 Před 4 měsíci

    Plugin Admin is best way to add compare plugin.. It will put DLL in appropriate folder for you then and handle the legit download.

  • @Pkrish344
    @Pkrish344 Před 4 měsíci

    Hi Atul, Please teach security in detail level

  • @emilymobley7420
    @emilymobley7420 Před 5 měsíci

    Amazing amazing amazing thank you!!!!!

  • @logdotcoder1748
    @logdotcoder1748 Před 5 měsíci

    It's good content sir i was looking for thank you so much

  • @santoshpenmetsa7197
    @santoshpenmetsa7197 Před 6 měsíci

    Thank you 🙏

  • @arnohurlimann1406
    @arnohurlimann1406 Před 6 měsíci

    It's very usefull! Thanks. In next SAP BO Version UDT will not be supported anymore. So this Playlist / Videos will have some more watchers 🙂

  • @priyankadesina6949
    @priyankadesina6949 Před 6 měsíci

    Hello sir can i get your number please

  • @ChPetru
    @ChPetru Před 6 měsíci

    Thank you, sir!

  • @dipankarnaskar1047
    @dipankarnaskar1047 Před 6 měsíci

    Sir what about datasphere?

    • @AtulKadlag
      @AtulKadlag Před 6 měsíci

      yes,it is also good in SAP area and yes it will have more demand in future as well

  • @sreenivasannarayanan5652
    @sreenivasannarayanan5652 Před 7 měsíci

    Excellent explanation on Data models, really appreciate your effort for helping the Learning community.

  • @atereoluwashina3052
    @atereoluwashina3052 Před 7 měsíci

    Straight forward and very helpful!

  • @puneetgupta2867
    @puneetgupta2867 Před 8 měsíci

    Hi Sir I have still not figured out where to start and what to study? Can you please share links or pdf for initial study material? Also please let me know if you provide weekend training on SAC and help prepare for certification as well

    • @AtulKadlag
      @AtulKadlag Před 7 měsíci

      this should be your starting point - training.sap.com/certification/c_sacs_2321-sap-certified-application-associate---sap-analytics-cloud-story-design-g/ it has all details which course to follow for preparation.. if you have SAP Learning Hub access you will get the course details in that..

  • @pamelabordachar3402
    @pamelabordachar3402 Před 8 měsíci

    no encuentro el nombre correcto del modelo

  • @saikrishna9672
    @saikrishna9672 Před 8 měsíci

    Hello one question: How can we define the primary key for data foundation in Information desgin tool, can you share some videos or reply how to do this.

  • @manishgoyal7205
    @manishgoyal7205 Před 8 měsíci

    How to save the results of Compare?

  • @user-mu7ol9vf3g
    @user-mu7ol9vf3g Před 8 měsíci

    My dear friends advanced Christmas wishes

  • @hungnguyentuan585
    @hungnguyentuan585 Před 9 měsíci

    Thanks for your video. I'm planning an upcoming presentation session focused on SAP Analytics Cloud. Specifically, I am interested in demonstrating a report on "SAP Analytics Cloud for Planning - Operational Headcount Planning. Can you make a video to instruct that report? Thanks a lot

  • @harrypoppins30
    @harrypoppins30 Před 9 měsíci

    Hi Atul sir, I am from Non - Tech Back ground. Can I do this SAP Analytics Cloud course and transform my career from Sales to Business Analytics consultant?

    • @AtulKadlag
      @AtulKadlag Před 9 měsíci

      It can be possible to transition, but please check internally if you have any projects in your company which requires SAP SAC skill, that way it will help you get entry to start working in SAC, otherwise you have to search outside for SAC openings(which might be tough initially).. one more thing I would suggest, you can learn Data analytics/business Analytics which will have more broader opportunities..

  • @ramyashree8867
    @ramyashree8867 Před 10 měsíci

    Good Atul thank you 😊

  • @leokadia2009
    @leokadia2009 Před 10 měsíci

    How to delete FILTERED rows?? You don’t explain it.. unfortunately 😢

  • @user-mv2xy3tj4v
    @user-mv2xy3tj4v Před 10 měsíci

    👍🏻

  • @coolmanu55
    @coolmanu55 Před 10 měsíci

    why this difference from is not available now in SAC ? is it removed now ?

  • @mohankanuri9905
    @mohankanuri9905 Před 10 měsíci

    hi sir . in old version there is option convert to numeric chart to table . in present version there is unable to find it. so there is option or removed from new version .

    • @AtulKadlag
      @AtulKadlag Před 10 měsíci

      I think it is moved to menu option in new version, we can convert chart to table.