![Atul Kadlag](/img/default-banner.jpg)
- 423
- 1 022 080
Atul Kadlag
India
Registrace 3. 11. 2016
This channel is all about knowledge share about the tutorials for BI Products like SAP Business Objects, SAP Design Studio 1.6 Tutorials, SAP HANA, Lumira Designer, Microsoft Power BI and few data warehousing concepts.I will also be posting few tips and tricks related to SAP BI technologies that I will come across.
Also some of the technical posts also I will be posting on this channel.
The views and opinions on this Channel represent my own and not of people, institutions or organizations I am associated with. It is not associated with, neither does it represent the views, position or attitudes of my employer(s) their clients, or any of their affiliated companies.
If any of you have any questions or need clarifications please post that in the comments section and I will be happy to answer it.
Also some of the technical posts also I will be posting on this channel.
The views and opinions on this Channel represent my own and not of people, institutions or organizations I am associated with. It is not associated with, neither does it represent the views, position or attitudes of my employer(s) their clients, or any of their affiliated companies.
If any of you have any questions or need clarifications please post that in the comments section and I will be happy to answer it.
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/
📖 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
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
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
Am working on SAC.
good!
thanks
App_ unavailable_select_new error is not letting me save my planning story in SAC. What could be the reason behind it?
seems server error, please try again after sometime..
App_ unavailable_select_new error is not letting me save my story in SAC. What could be the reason behind it?
Hi bro how r u
Doing well, thanks for asking, Hope you are doing great!!
Bro how to add radio buttons in story board?
there is a option available for Radio button while you design the story..check in menu option.
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
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
गुरु गोविंद दोऊ खड़े काके लागू पाय...! बलिहारी गुरु आपने गोविंद दियो बताए...!! गुरुपर्णिमेच्या हार्दिक शुभेच्छा सर...🙏🏻
Very helpful. You discussed everything I was worried about. Is switching from BO to ABAP a good option?
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..
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?
how to make open a new browser tab in sac stories using scripting or any other way if any
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
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
Do you have the video or blog link ready- how to make dropdown as multi selection?
Well explained
Good overview!!!
thank you
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!!
Yes, you can.. you can directly learn SAC
Thanks a bunch!
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..
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.
@@AtulKadlag thank you for your valuable reply 🙏
Where can I find the other model??
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
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
Need a little more information, why ISNUMBER?
Plugin Admin is best way to add compare plugin.. It will put DLL in appropriate folder for you then and handle the legit download.
Hi Atul, Please teach security in detail level
Amazing amazing amazing thank you!!!!!
thank you so much!
It's good content sir i was looking for thank you so much
Thank you 🙏
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 🙂
Yes it will, thank you
Hello sir can i get your number please
Thank you, sir!
Sir what about datasphere?
yes,it is also good in SAP area and yes it will have more demand in future as well
Excellent explanation on Data models, really appreciate your effort for helping the Learning community.
Straight forward and very helpful!
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
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..
no encuentro el nombre correcto del modelo
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.
How to save the results of Compare?
My dear friends advanced Christmas wishes
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
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?
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..
Good Atul thank you 😊
thank you
How to delete FILTERED rows?? You don’t explain it.. unfortunately 😢
👍🏻
why this difference from is not available now in SAC ? is it removed now ?
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 .
I think it is moved to menu option in new version, we can convert chart to table.