5 Reasons You SHOULDN'T USE EXCEL To Build Dashboards

Рет қаралды 3,096

Жыл бұрын

In this video, I explain why you shouldn't build interactive dashboards in Excel
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 Looker Studio - geni.us/vbi-edu
Google Data Analytics Course - geni.us/coursera_analytics
Learn SQL - geni.us/learnsql
SKILLSHARE - 30-day free trial! - geni.us/skillshare30day
UDEMY - geni.us/udemy_vb
📕 FREE EBOOKS
7 Top Tips For Better Dashboard Design - geni.us/dashdes-ebook
Skills You Need To Succeed In BI - geni.us/biskills-ebook
🧰 BI TOOLS
Power BI - powerbi.microsoft.com/
Tableau - www.tableau.com/
Looker Studio - datastudio.google.com/
📊 DATA HUBS & WEBSITES:
Power My Analytics: geni.us/YLc9Re
Supermetrics: geni.us/5SNn
Data Slayer: geni.us/dataslayer
Kaggle - www.kaggle.com/
Statista - www.statista.com/
Data World - data.world/
📕THE DATA VISUALISATION BIBLE - geni.us/iJTa8
🎥 MY KZfaq GEAR
My Camera - amzn.to/3J5lbeo
Most Used Lens - amzn.to/3hXoE2Q
Main Key Light - amzn.to/366KaPI
Softbox - amzn.to/35HrR46
LED Panel Kit - amzn.to/35K3Lpf
Teleprompter - amzn.to/3hWGT8p
Main Mic - amzn.to/3t1n1aK
Lavalier Mic - amzn.to/3vVUi8V
DISCLAIMER: Some of the above links are affiliate links where I'll earn a small commission if you make a purchase using them, at no additional cost to you. It really helps support the channel so thanks in advance if you do use them 🙏
✅ LET'S CONNECT!
BUSINESS INQUIRIES - learnbi.online/contact
CONSULTING CALL WITH ADAM - geni.us/bookacall-adamfiner
JOIN MY MAILING LIST - geni.us/PSgRsF
FACEBOOK GROUP - geni.us/learnbi-fbg

Пікірлер: 13

@josuemejiasvaglio1947 Жыл бұрын

As a Business Analyst working for a FANG company I have to say that there are instances where Excel can be quite useful for a certain scale of dashboards. For example when you deal with database access restrictions(SQL) but have access to exporting the raw data. (Sounds weird but believe me if you’re starting in a big company permissions are a pain to go through) I’ve built two Excel Dashboards automated with VBA / Power Query and shared via Excel Online in SharePoint. It’s a Weekly update concept where I have to upload the updated file to SharePoint (SharePoint replaces the file if it has the same name). But since all I do is to download the latest data, run a VBA routine and upload the file(5mins total), for a medium scale dataset but impactful KPI indicator in the department it’s a very awesome product. Don’t count it out for instances like these. But if you do have the access to the database for real time refreshed data then just use PowerBi, QuickSight, Tableau or whatever you’re experienced with. Cheers

@LearnBI Жыл бұрын

I get where you’re coming from and I do understand the Data governance issues at larger corporations. I’ve worked at a large tech company in SF on projects for some of the largest brands on the planet. All using BI tools because they were fed up of creating and receiving reports in Excel. We always found a solution that suited their data security protocols. Would you still use Excel if you didn’t have to? Or would you use a BI tool specifically built for creating dashboards?

@vaughngaminghd Жыл бұрын

Thanks for the tips Adam… So helpful for someone like me who's just starting out!

@LearnBI Жыл бұрын

You’re welcome!

@pauliuspariokas3156 Жыл бұрын

Excellent video. I wouldn't dismiss Excel altohether. In its defence, it does have the awesome Power Query Feature which allows connecting to various data sources. To quote from Microsoft "Power Query lets you analyze your data right from within Excel, while seamlessly connecting to a wide range of external data sources. Easily reshape and transform your data along the way if needed"

@LearnBI Жыл бұрын

Like I say, I love Excel. But it's still a question of "square pegs and round holes" when it comes to Excel being used for interactive dashboards IMO

@Victroll47 Жыл бұрын

TOP quality content, wish all Content Creators worked like this. Keep on the good work Adam

@LearnBI Жыл бұрын

Thanks!

@tascrphs Жыл бұрын

Must admit it's been quite awhile since i've seen KZfaqrs brutalized by another KZfaqr. Especially popular ones everyone knows. It's like hey, that's my neighbor. Strange, but hilarious. Great post btw, I may take you up on the Learn Bi course in the not too distant future.

@LearnBI Жыл бұрын

I must admit that I totally disagree with your assessment that I have in any way ‘brutalized’ other KZfaqrs in this video. I simply give my opinion on excel being the wrong tool for interactive dashboards, which is absolutely is.

@Hotdads1 11 ай бұрын

@@LearnBI I have built fairly comprehensive dashboards in Excel that are completely dynamic and professional. To be fair, I asked for Power BI or Tableau and was basically told no. I think the right tool is the one you have access to. Learn to use it to its full capability even if it's not the best tool to use in certain instances. Overall I do get where your coming from and mostly agree with your points!

@v3r0x Жыл бұрын

Bullshit. When u started a dashboard on the wrong granularity/ aggregation you fucked up already and have to rebuild later on anyway - doesnt matter if excel ir any other "tool". Going down in granularity is hard, going up is not for most DBs (or Excel). What u mention is frontends anyway and often more than a joke for serious jobs or Master data harmonization, hierarchy builing, etc Excel is crap, but sometimes i think PowerBI or all other Tools are so over the top. In the end all a business wants is a dataset that is updated. Having the automation going AND be able to self graph from the the tool he knows and can manipulate is worth much. Thats why i like raw queries in Analysis for Office and automation in Thinkcell. DWH guy happy - Business guy happy.