Video

How the hell is the syntax easier than Python? lol. Watching your videos before taking a self paced online class. Excited to aquire a new skill.

lmao I know Im bad when the horror movie music starts and I was thinking that's a decent dashboard

I am not a fan of pie charts and especially detest those 3D charts that Excel makes.

What are the names of the tables? Should I copy the information? Is it possible to download the excel spreadsheet? Thank you very much. Good Information!

thank you for this amazing concise video! been enjoying the first part too

Thanks for this - good vid! I don't hate pie charts, i just think they are overused. But if you want to see the relative distribution of a small number of elements that are a part of a whole, it's hard to beat a pie chart. That said, I always start by asking myself "what question is being answered" and if there's a better option!

14:10 thanks for doing it wrong, to show how it would look in that case. it's good that you did not jump straight to the solution and shoedw how SQL will handle it when done without the group by. Which just shows the overall sum and the first row if i understood that correctly. great tutorial

Thank you, for sharing. Warm regards from Indonesia.

What about bi mgr

you are so amazing....... God bless you!!!!!!!!!!!!!🙏

I will add something out of my own experience. You absolutely want to be a data base owner as a Data Analyst. Of course, you don't want to mess up with the ERP system or the currently existing data warehouse. However, it is ALWAYS possible (don't believe them if they tell you otherwise) to get a small isolated database on one of the company's servers and get a database management tool installed (they are freeware so it is all about getting an IT permission). Use your database to store parts of business logic, which otherwise exist in Excel or are calculated on reporting level: alternative hierarchies, manual number patches, some alternative descriptions etc. Also if you are in need to perform a large calculation, which is slowing your reporting software down, do it in your database. That way your reporting software (I use PBI primarily) gets ready to serve data and the performance of your reports gets a big boost.

What text editor is this ? And how can i download it ? Is there any steps

wow so great thanks!!!

How do I get the data used ?

I was about to migrate my MicroStrategy stand-alone (Workstation) baseball stats app to Looker Studio... no anymore...

If you were my teacher in highschool, I'd be in much better place now

i will pray for you

What editor are you using?

10:08 Make it thing more complicated! 😀 We need that

Hi... do you have these course on udemy? (with real project and data like in real world) please give me the link. Thank You..

I just did a course from udemy on Microsoft power bi only cost $15 now I'm going to try setup dashboards and reports for companies by starting my own business

You should not be selling the data. You should have provided the data for free so people can follow along 🙄

where is dataset?

Binging your videos to prepare for a job interview.... thank you SO MUCH for high quality content!!! 💛💛💛

Can you help me determine why the new rows in the Google sheet do not appear in my chart? I reconnected, refreshed, etc

Incredible work, Adam

MADE MY CONCEPTS MORE CLEAR.Thank youu😃

i am confused. please why are my RFM columns having the same values after dragging to autofill?

Could you provide a Every Data set for practice purpose,🙏👍 It's a humble request to you

Thanks 🙏 I hope you are providing daily a valuable content

Really Great and helpful

The referred dataset is in .sqlite file format and not able to import to mysql workbench. Can anyone help me out plz ?

Ok. I've got a windows laptop. My Navicat is open. How do you download the EA Sports database? I downloaded it and it shows a lot of technobabble. What's next? Thanks.

Good video, just confusing that you have set columns as INT but set data in those columns as varchars

That was excellent -- you just helped me loads with this video. Thanks mate!

This was helpful. Thank you!

Really helpful. We have been observing that enterprise data migrations have been using legacy methodology for too long

Should at least Provide the “DataSet.xls” file at open source level in the description directly and not with the paid course material ….. so that at least school students can practice at their own pace though working professionals can buy the course

Thank you for sharing your experience, it sounds like you had a tough time at the hospital - 28 days! I had a similar diagnosis and procedure two years ago, it's really important to act fast as my cancer hadn't spread. A dark humour always helps, I'm stealing the semicolon line ;) - nice work 🤭 Keep positive and best wishes for the rest of your recovery.

❤❤❤

can i get the link to the database

why date is in blue?

use higher resolution in your screen captures. Can barely read it