![Adam Finer - Learn BI Online](/img/default-banner.jpg)
- 97
- 3 989 324
Adam Finer - Learn BI Online
United Kingdom
Приєднався 12 кві 2017
LearnBI.online is a channel dedicated to demystifying and democratising Business Intelligence for beginners and beyond. We look at things like data analysis, data visualisation as well as business intelligence platforms and tools.
We're here to show you that you don't need to be a data scientist or have a big budget to get started with basic BI for any business, big or small. All you need are a few simple tools, techniques and concepts that we'll be featuring and teaching you all about.
Be sure to comment and say hello and let me know if you have any ideas for videos and content you'd like to see.
@learnbi_online www.learnbi.online
We're here to show you that you don't need to be a data scientist or have a big budget to get started with basic BI for any business, big or small. All you need are a few simple tools, techniques and concepts that we'll be featuring and teaching you all about.
Be sure to comment and say hello and let me know if you have any ideas for videos and content you'd like to see.
@learnbi_online www.learnbi.online
Відео
Why Looker Studio Is Better Than Power BI For Business Intelligence
Переглядів 2,6 тис.8 днів тому
It's a controversial statement to make but I believe that it's true. When it comes to Business Intelligence, Looker Studio is a better tool than Power BI. In this video I compare Power BI to Looker Studio and explain why one is better suited to Business Intelligence than the other. 🎓 LEARN BUSINESS INTELLIGENCE - geni.us/lbi_academy 🚀 BECOME A BI ANALYST - geni.us/lbia_biasp 🏆 TAKE THE BI CONSU...
Looker Studio Bins & Groups - New Functionality
Переглядів 61219 днів тому
Google just added a new calculations functionality to Looker Studio called bins. And along with the other recently added groups functionality, together they are two great little tools that help make data analysis easier. In this video, I break them down. 🎓 LEARN BUSINESS INTELLIGENCE - geni.us/lbi_academy 🚀 BECOME A BI ANALYST - geni.us/lbia_biasp 🏆 TAKE THE BI CONSULTANT MASTERCLASS - geni.us/...
Learn BI Announcement - Livestream
Переглядів 200Місяць тому
📈Your New Path To Business Intelligence Analyst - Introducing The Learn BI Academy!
Переглядів 6 тис.Місяць тому
SPECIAL LAUNCH OFFER! Get 25% Of All Courses & Classes Using The Code EVERYTHING25 At Checkout! Valid until 25 May 2024. JOIN THE LEARN BI ACADEMY 🚀 BI Analyst Starter Program - geni.us/lbia_biasp 🏆 BI Consultant Masterclass - geni.us/lbia_bicm 🧰 TOOLS & SKILLS Excel For BI Analysts - geni.us/lbia_excel SQL For BI Analysts - geni.us/lbia_sql Power BI For BI Analysts - geni.us/lbia_powerbi Table...
F is for Funnel Analysis - Business Intelligence For Beginners
Переглядів 3573 місяці тому
Discover the basics of business intelligence with our #biforbeginners series! In this video, we are at the beginning with F for Funnel Analysis, breaking down the A to Z of business intelligence for beginners. Learn the fundamentals and join us on the journey to becoming a BI pro!
E is for ETL - Business Intelligence For Beginners #businessintelligence #bianalyst #etl #data
Переглядів 4243 місяці тому
Discover the basics of business intelligence with our #biforbeginners series! In this video, we are at the beginning with E is for ETL, breaking down the A to Z of business intelligence for beginners. Learn the fundamentals and join us on the journey to becoming a BI pro!
D is for Dashboard - Business Intelligence For Beginners #businessintelligence #dashboards
Переглядів 3103 місяці тому
Discover the basics of business intelligence with our #biforbeginners series! In this video, we are at the beginning with D is for Dashboard, breaking down the A to Z of business intelligence for beginners. Learn the fundamentals and join us on the journey to becoming a BI pro!
C is for Cleaning - Business Intelligence for Beginners #businessintelligence #datacleaning
Переглядів 1983 місяці тому
Discover the basics of business intelligence with our #biforbeginners series! In this video, we are at the C for Cleaning (data), breaking down the A to Z of business intelligence for beginners. Learn the fundamentals and join us on the journey to becoming a BI pro!
B is For Big Data - Business Intelligence For Beginners #bigdata #businessintelligence #bianalyst
Переглядів 2323 місяці тому
Discover the basics of business intelligence with our #biforbeginners series! In this video, we are at B for Big Data, breaking down the A to Z of Business Intelligence for beginners. Learn the fundamentals and join us on the journey to becoming a BI pro!
A is for Analytics - Business Intelligence for Beginners #biforbeginners #businessintelligence
Переглядів 1233 місяці тому
Discover the basics of business intelligence with our #biforbeginners series! In this video, we start at the beginning with A for Analytics, breaking down the A to Z of business intelligence for beginners. Learn the fundamentals and join us on the journey to becoming a BI pro!
The A Z of BI - Business Intelligence For Beginners
Переглядів 1,4 тис.3 місяці тому
🙏🏻 Thanks to Zoho Analytics for sponsoring this video! Start your free trial - geni.us/zohoanalytics Looking to learn the basics of business intelligence? Look no further! In this beginner-friendly video, we break down the A-Z of BI and provide you with a solid understanding of what it is and how it can benefit your business. From data analysis to reporting, we've got you covered! #Businessinte...
Discovering Navicat Charts Creator. A Surprisingly Good Data Viz Tool.
Переглядів 7854 місяці тому
START YOUR 14-DAY FREE TRIAL OF NAVICAT CHARTS CREATOR HERE geni.us/navicat_cc DISCOVER THE FULL NAVICAT PRODUCT RANGE geni.us/navicat_range 🟣 In this video we discover Navicat's data visualisation and dashboarding tool, Charts Creator. How does it compare to other more established BI tools? 🚨 THE BI ANALYST STARTER PROGRAM - ENROL NOW! - geni.us/bicsp_yt START YOUR BI JOURNEY! - learnbi.online...
How I Build Predictive Analytics Models With AI
Переглядів 9 тис.4 місяці тому
🟣 Thanks to Pecan for sponsoring this video. Visit Pecan Today to start exploring Predictive Models www.pecan.ai/ In this video, I'll show you how I use AI and the Pecan platform to build predictive analytics models that accurately predict customer churn. Watch as I walk you through the process step by step and share my tips for building effective and efficient models. Whether you're new to pre...
So, I had cancer.
Переглядів 1,6 тис.5 місяців тому
🚨 THE BI ANALYST STARTER PROGRAM - ENROL NOW! geni.us/bicsp_yt START YOUR BI JOURNEY! - learnbi.online 🎥 RECOMMENDED VIEWING 7 Steps to Your 1st BI Analyst Job - geni.us/7stepstobivid Learn Basic SQL in 15 Minutes - geni.us/learnbasicsql15-1 BI For Beginners Playlist - geni.us/biforbeginners-play 🎓 RECOMMENDED COURSES Power BI For Business Intelligence - geni.us/powerbi-udemy Ultimate Guide to ...
BI Career Starter Update & Black Friday Week Hangout
Переглядів 3627 місяців тому
I haven't been around much lately because of working on and teaching my brand new BI Career Starter Program. Now that the first cohort is almost at an end, I thought I'd jump on livestream and catch you up. Also to tell you about some changes to the program and some amazing Black Friday deals you won't want to miss!
Thank you for letting me know about it. I plan to check out the Google Project Management certification
I want to get into data consultant for local and federal. Knowing how to charge will be my challenge.
Try this video... ua-cam.com/video/J0Iyx76xPEU/v-deo.html
Will you be doing a video on backfilling BigQuery with GA4 data?
I’m not sure tbh. If you’re looking to do it, you’ll need to use a data hub like Power My Analytics.
Hey everyone, if you're looking to master SQL or deepen your understanding, check out my UA-cam channel through my profile! I provide practical tutorials and tips to navigate SQL with ease, catering to beginners and those refining their skills alike. Subscribe to join our SQL learning community today!
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.
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.
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.
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).
but what about the ETL?
ETL Tools For Business Intelligence. Do We Still Need Them? ua-cam.com/video/0NoHF0nDqiA/v-deo.html
Hi! I'm not Abel to download the file for practice can you please help me with that?
The file is not available for download, sorry.
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.
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!
@@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?
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.
the book, wic)h one?
The Visual Display of Quantitative Information by Edward Tufte
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.
You're very welcome!
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?
You can add metrics to the dimensions area of queries.
I am loving this tutorial.
I started watching but stopped when I realised it was mysql
Thanks for your feedback, very helpful!
How about Tableau?
Love Tableau 😍
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.
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)
Great video and very well presented. Thank you
the whole video is about skill issue💀
In what way?
@@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
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.
I kind of agree for date and kpi cards. Power BI can get better in terms of user friendly levels
Nah, pbi is better 😂
This is so good! Very well explained, thank you!
You’re welcome!
blasfemy, shunt the nom believer shunt
😢
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..
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!
You’re welcome
I pressed 👍from min 1 , I have the ability to judge the quality form the introduction part
Great video, thank you!
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!
The Excel data is available as a paid download from here ➡️ www.learnbi.academy/courses/pizzeria-sql-project
thank you for this amazing concise video! been enjoying the first part too
My pleasure
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!
Well said!
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
Thanks!
Thank you, for sharing. Warm regards from Indonesia.
What about bi mgr
you are so amazing....... God bless you!!!!!!!!!!!!!🙏
You too!!
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
I use Navicat
wow so great thanks!!!
How do I get the data used ?
There’s a link in the description 👍🏻
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
Thank you
What editor are you using?
Navicat
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 have a complete e-learning platform at www.learnbi.academy
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
I'm assuming that was a "tongue-in-cheek" comment? If not, that's a terrible idea 🤦🏻♂️
@@LearnBI whatever loser what are you talking about