Hi Adam, I would like to buy the data but unfortunately I don't have a credit card. Is it possible to make the payment via PayPal?
@LearnBI
2 жыл бұрын
Hi Deepak, I've activated PayPal for checkout. Thanks
@ibejibenson6065
10 ай бұрын
The "timestampdiff" function is a little simpler, it returns the difference in your specified unit -> (timestampdiff(minute, sh.start_time, sh.end_time))/60 : for the number of hours (timestampdiff(minute, sh.start_time, sh.end_time))/60 * s.Hourly_rate : for the pay
@CatalinPaval
9 ай бұрын
Nice explanations. For staff_cost I would go with transforming hourly_rate into minute_rate and multiply it by timediff. If there is no need to show hours _in_shift.
@pauliuspariokas3156
2 жыл бұрын
That's an excellent project. Thank you for sharing it. I have a question though. In your opinion, what would be the best practice - to do the calculations on the database side or select the necessary data using SQL, send it to your preferred BI tool and then create calculated measures? Or as an option, use the BI tool to connect to the database directly and skip the SQL altogether?
@LearnBI
2 жыл бұрын
That is a great question and the answer really deserves its own video. There are lots of different variables and factors to consider when deciding what work (if any) needs to be done in the SQL DB before connecting it to the BI tool. You could theoretically create a separate SQL query that gives the exact data you need for each of the required charts/tables in the project brief. But then you would have to deal with loads of different data sources in your BI tool that would impact a dashboard's interactivity capabilities. You always need to consider that reporting needs may evolve and change over time so you also don't want to paint yourself into a corner with the data. And sometimes, just connecting the database as it is to a BI tool will not mean you won't have to write custom queries to get the results you need. It really is one of those "it depends" answers where you learn with experience to evaluate the best approach from the project brief. Hope this helps!
@freerockneverdrop1236
Жыл бұрын
The "group by" looks so verbose, e.g., r.ing_id is enough to group by ing, what's the point to add ing.quantity and ing.price?
@LearnBI
Жыл бұрын
Every field that you want in the result that is not being aggregated needs to appear in the group by.
@o7mach
2 жыл бұрын
🔜
@singhsaab1229
2 жыл бұрын
Hi , Adam. Where can I access the 3 part of this tutorial series?
@LearnBI
2 жыл бұрын
I’ve not made it yet ☺️ but it's coming fairly soon. Don't forget to subscribe and turn on notifications so you don't miss it!
@arcaneknight9799
10 ай бұрын
anyone else having trouble importing orders and rota tables into MySQL?
@LearnBI
10 ай бұрын
Answered
@naminabantu
10 ай бұрын
Hey, I am facing the same issue. Did you figure out how to fix the issue?
@naminabantu
10 ай бұрын
@@LearnBI hey Adam. May I know how i can fix this issue that i am facing. I am having trouble importing orders and rota tables into MySQL.
@arcaneknight9799
10 ай бұрын
@@naminabantu for me, I changed the date/time format of the csv files in those tables and saved.
@meditatesleepandtravel8795
Жыл бұрын
Hi Adam, where, how do u get the ing, i, o, S1, etc? Do you make them up or memorize from the SQL software?
@LearnBI
Жыл бұрын
Great question, aliases can be almost anything that isn't already used in SQL syntax. I just made them up to suit the table name. Lots of people just use 't1', 't2' etc to alias table 1, table 2 etc.
@paintwithtihani9926
Жыл бұрын
@@LearnBII’m a bit curious about this alias concept. In the video for example, you input o.order_id. Does SQL understand this as alias or did you input other command before that like AS for example
@kawtharbh1223
Жыл бұрын
@@paintwithtihani9926 if you notice on the code where he wrote " FROM orders o " that's where he specified that the "o" is an alias for the table "orders" and that's how SQL will recognize the "o" from "o.order_id".
@paintwithtihani9926
Жыл бұрын
@@kawtharbh1223 i see. thank you Kawthar! That clears things up for me :)
@equiwave80
2 жыл бұрын
Hi Adam, Where can I access the part 3 of this series?
@LearnBI
2 жыл бұрын
I’m working on it at the moment and it should be posted tomorrow or Monday 👍🏻
@equiwave80
2 жыл бұрын
@@LearnBI Superb thanks for the prompt reply. I really appreciate your content. Can't thank you enough
@sandeepbabusirisinagandla2504
Жыл бұрын
@@equiwave80 Hi, Can someone please provide me with the data files?
Пікірлер: 25