So, I had cancer.
7:45
5 ай бұрын
Let's Practice SQL!
20:26
8 ай бұрын
How I Use SQL as a BI Analyst
9:01
Пікірлер
@Bhimaphenomenon
@Bhimaphenomenon Күн бұрын
Jai shri mahakal❤
@ericaleverson9430
@ericaleverson9430 2 күн бұрын
Thank you for letting me know about it. I plan to check out the Google Project Management certification
@ericaleverson9430
@ericaleverson9430 3 күн бұрын
I want to get into data consultant for local and federal. Knowing how to charge will be my challenge.
@LearnBI
@LearnBI 2 күн бұрын
Try this video... kzfaq.info/get/bejne/gJZ5rNtom960dYk.html
@susanfishman2561
@susanfishman2561 3 күн бұрын
Will you be doing a video on backfilling BigQuery with GA4 data?
@LearnBI
@LearnBI 3 күн бұрын
I’m not sure tbh. If you’re looking to do it, you’ll need to use a data hub like Power My Analytics.
@tsojin8846
@tsojin8846 4 күн бұрын
I've created thay exact toolbox in power bi in several different ways. I can agree it looks easier to do in thay studio, but that doesn't make it "better". I can do that in tabaleu and quicksight also. I'd still choose power bi over either. What makes power bi "better" (imo) then tabaleu or quicksight (never used the google one) is simplely tje ability to customize everything to whay I want and need. Yes, something are "harder" in power bi b/c of thay but I value the flexibility over ease of use.
@LearnBI
@LearnBI 4 күн бұрын
I appreciate your point of view. I’m not sure you can make an educated judgement if you haven’t even tried “that Google one”. I’m not saying that Looker Studio is more powerful or better than Power BI overall, because it isn’t. I’m saying that is better for Business Intelligence. Because it is.
@stingyblue8189
@stingyblue8189 4 күн бұрын
Are you based in the USA? Would your certificate be accepted here? How does it compare to Google’s or Microsoft’s BI certificates? Will a potential employer require that I have a certificate? How does your certificate or any certificate compare to the bachelors degree or masters degree that I see many schools in the United States are promoting? Would a $500 investment make me competitive with someone who made a $5K, $15K or $50K investment in their education? What I am really asking is what I can really expect to accomplish after I spend a studying and preparing to transition from a career in education to a BI career? (In the US, teachers are required to sign a yearly contract.) I look forward to your reply.
@LearnBI
@LearnBI 4 күн бұрын
I’m based in Europe (France). I don’t see why the BI Analyst Starter Program Certification would not be accepted in the US. The main difference between the Google/Microsoft certificates and ours is that ours is 100% focused on Business Intelligence and landing you a job as an entry-level BI Analyst. Theirs tend to be far more general and “analytics” focused. Our program has been designed by someone who has worked exclusively in BI for the past 15 years. Someone who has worked on hundreds of BI projects for hundreds of different organisations. In terms of the price comparison, our program is by far and away the best value out there for learning Business Intelligence tools and skills. If you compare our syllabus to that of Tripleten, for example, we pretty much teach the same things. Except they charge $6000. Our program is very new and we’re keeping the price low to get students through the door and build up some social proof. Once we become more established, the price will definitely be increasing. Why don’t we organise a Zoom call where you can tell me more about your educational goals and I will give you honest advice about whether our program would be best for you? If that sounds good, please feel free to reach out via the website (footer).
@user-tm8qc9dm7m
@user-tm8qc9dm7m 4 күн бұрын
but what about the ETL?
@LearnBI
@LearnBI 4 күн бұрын
ETL Tools For Business Intelligence. Do We Still Need Them? kzfaq.info/get/bejne/ZrSfe6lh06rVmXU.html
@syedfarhaan1998
@syedfarhaan1998 7 күн бұрын
Hi! I'm not Abel to download the file for practice can you please help me with that?
@LearnBI
@LearnBI 7 күн бұрын
The file is not available for download, sorry.
@manuelespitia10
@manuelespitia10 7 күн бұрын
Hi! Almost found what I was looking for in this awesome video, thanks. Do you know if there’s a way to use a data range control as a calendar table? This is, that it uses two different date columns to filter? Both columns are in the same blended table. Thanks in advance.
@LearnBI
@LearnBI 7 күн бұрын
A date filter control applies the date range to whichever date field is selected in the widget of each visualisation. So it can apply to more than one date. But each visualisation cannot have more than one date included. Hope this helps!
@manuelespitia10
@manuelespitia10 7 күн бұрын
@@LearnBI thanks, it helps!! Just one more question: for a table visual that has the date columns in it… is it possible to filter it in that way using a date range control?
@LearnBI
@LearnBI 7 күн бұрын
A date range filter control will apply the date range to any visualization that has a date field included in the query. It will use that date field to filter the rows in the result.
@indiamarispereira6944
@indiamarispereira6944 8 күн бұрын
the book, wic)h one?
@LearnBI
@LearnBI 7 күн бұрын
The Visual Display of Quantitative Information by Edward Tufte
@Alvin-eq5rc
@Alvin-eq5rc 8 күн бұрын
Thank you so much! I took a course on it a while back and this is the exact video I am looking for to refresh my memories for an interview.
@LearnBI
@LearnBI 7 күн бұрын
You're very welcome!
@user-yg3mu7id8u
@user-yg3mu7id8u 8 күн бұрын
Very helpful, thank you. I have a question. With this new feature, I wanted to create metric data as a dimension, but is that not possible?
@LearnBI
@LearnBI 8 күн бұрын
You can add metrics to the dimensions area of queries.
@henry-zh3rv
@henry-zh3rv 8 күн бұрын
I am loving this tutorial.
@darrylw99
@darrylw99 8 күн бұрын
I started watching but stopped when I realised it was mysql
@LearnBI
@LearnBI 8 күн бұрын
Thanks for your feedback, very helpful!
@patrickyong1501
@patrickyong1501 9 күн бұрын
How about Tableau?
@LearnBI
@LearnBI 9 күн бұрын
Love Tableau 😍
@roycemekolle7334
@roycemekolle7334 9 күн бұрын
I agree with the KPI cards. To create that in Power BI you will need at least 3 measures and if you are to add absolute value then u need even more.
@tsojin8846
@tsojin8846 4 күн бұрын
That doesn't make it "better" just easier. I've not used this studio but it seem similar to the tabaleu v power bi debate. Tabaleu let you do a lot via the UI but the instant you can't do it via the UI either you can't do it period or it is WAY more difficult then power bi. Power bi's greatest strength is it's flexibility in both modeling and making visuals (charticulator, py/r, declaritive)
@roycemekolle7334
@roycemekolle7334 12 сағат бұрын
@@tsojin8846 Looker studio as a stand alone tool is not even close to power BI. The lack of data transformation and cleaning means it's not very useful on its own except when combined with something like SQL. But I understand where he is coming from.
@emoon777
@emoon777 10 күн бұрын
Great video and very well presented. Thank you
@user-yk4mq3uc2k
@user-yk4mq3uc2k 10 күн бұрын
the whole video is about skill issue💀
@LearnBI
@LearnBI 10 күн бұрын
In what way?
@user-yk4mq3uc2k
@user-yk4mq3uc2k 10 күн бұрын
@@LearnBI 1. Time. Yes, in looker studio learning curve is smooth, but once you master DAX and modeling, time calculations will become almost as easy. 2. Yeah, it's cloud-based, but the number of features is very small, and it can't handle like 200M rows data. 3. SQL-based means it can't be used as semantic layer
@LearnBI
@LearnBI 10 күн бұрын
1. "Almost as easy" but not as powerful. My point is that time/date management and analysis is an in-built part of the tool, and not something that you need to calculate using formulas. It is simply better for BI use cases. 2. Because it's cloud-based, it can handle billions of rows in sources like BigQuery, Amazon Redshift and Microsoft Azure. And with regard to features, which ones specifically are missing from Looker Studio that you would need for the majority of BI projects? 3. That literally makes no sense to the point I make, which is that the calculation language in Looker Studio is based on SQL whereas DAX is a completely separate language. A Powerful language, yes, but only relevant to Power BI users.
@albedoguardian875
@albedoguardian875 10 күн бұрын
I kind of agree for date and kpi cards. Power BI can get better in terms of user friendly levels
@LJ-jd5yy
@LJ-jd5yy 10 күн бұрын
Nah, pbi is better 😂
@isabelledias2338
@isabelledias2338 10 күн бұрын
This is so good! Very well explained, thank you!
@LearnBI
@LearnBI 10 күн бұрын
You’re welcome!
@welcometomathy6944
@welcometomathy6944 10 күн бұрын
blasfemy, shunt the nom believer shunt
@LearnBI
@LearnBI 10 күн бұрын
😢
@DayatDC
@DayatDC 10 күн бұрын
I must drag 2 card when I want compare 2 measure cards in looker studio .. but in power BI more easier if you want compare 2 measure .. But anyway I very love looker studio because easy to learn .. very friendly for beginners.. that's very true..
@Christopheralb
@Christopheralb 11 күн бұрын
This is exactly what I wanted to inform me if I should proceed with BI. I was told SQL can be a little intimidating but it's pretty straight forward. Anyways, thank you for the concise and informative intro!
@LearnBI
@LearnBI 11 күн бұрын
You’re welcome
@abdulbasital-sufyani6828
@abdulbasital-sufyani6828 14 күн бұрын
I pressed 👍from min 1 , I have the ability to judge the quality form the introduction part
@sargata3054
@sargata3054 15 күн бұрын
Great video, thank you!
@Deristrome
@Deristrome 17 күн бұрын
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.
@IluvinortheIneffable
@IluvinortheIneffable 17 күн бұрын
lmao I know Im bad when the horror movie music starts and I was thinking that's a decent dashboard
@haraldurkarlsson1147
@haraldurkarlsson1147 17 күн бұрын
I am not a fan of pie charts and especially detest those 3D charts that Excel makes.
@lucasgonzalezsonnenberg3204
@lucasgonzalezsonnenberg3204 17 күн бұрын
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!
@LearnBI
@LearnBI 16 күн бұрын
The Excel data is available as a paid download from here ➡️ www.learnbi.academy/courses/pizzeria-sql-project
@annisaautami
@annisaautami 17 күн бұрын
thank you for this amazing concise video! been enjoying the first part too
@LearnBI
@LearnBI 17 күн бұрын
My pleasure
@Tom-kp2lv
@Tom-kp2lv 17 күн бұрын
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!
@LearnBI
@LearnBI 17 күн бұрын
Well said!
@michalkiwanuka938
@michalkiwanuka938 17 күн бұрын
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
@LearnBI
@LearnBI 17 күн бұрын
Thanks!
@Septiandi-so3vu
@Septiandi-so3vu 18 күн бұрын
Thank you, for sharing. Warm regards from Indonesia.
@rapatel1642
@rapatel1642 19 күн бұрын
What about bi mgr
@mierafshimelis7616
@mierafshimelis7616 21 күн бұрын
you are so amazing....... God bless you!!!!!!!!!!!!!🙏
@LearnBI
@LearnBI 20 күн бұрын
You too!!
@alexgry4763
@alexgry4763 22 күн бұрын
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.
@Salamanca-joro
@Salamanca-joro 23 күн бұрын
What text editor is this ? And how can i download it ? Is there any steps
@LearnBI
@LearnBI 22 күн бұрын
I use Navicat
@mariakata8787
@mariakata8787 24 күн бұрын
wow so great thanks!!!
@magbomajoshua1585
@magbomajoshua1585 24 күн бұрын
How do I get the data used ?
@LearnBI
@LearnBI 24 күн бұрын
There’s a link in the description 👍🏻
@tonper
@tonper 27 күн бұрын
I was about to migrate my MicroStrategy stand-alone (Workstation) baseball stats app to Looker Studio... no anymore...
@Lailahiipek
@Lailahiipek 28 күн бұрын
If you were my teacher in highschool, I'd be in much better place now
@mierafshimelis7616
@mierafshimelis7616 29 күн бұрын
i will pray for you
@LearnBI
@LearnBI 29 күн бұрын
Thank you
@abdirauf72
@abdirauf72 Ай бұрын
What editor are you using?
@LearnBI
@LearnBI 29 күн бұрын
Navicat
@kunjd26
@kunjd26 Ай бұрын
10:08 Make it thing more complicated! 😀 We need that
@dede2007x
@dede2007x Ай бұрын
Hi... do you have these course on udemy? (with real project and data like in real world) please give me the link. Thank You..
@LearnBI
@LearnBI 29 күн бұрын
I have a complete e-learning platform at www.learnbi.academy
@jimross8150
@jimross8150 Ай бұрын
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
@LearnBI
@LearnBI Ай бұрын
I'm assuming that was a "tongue-in-cheek" comment? If not, that's a terrible idea 🤦🏻‍♂️
@jimross8150
@jimross8150 Ай бұрын
@@LearnBI whatever loser what are you talking about