Advanced Excel Bootcamp: Data Analytics and Business Intelligence

Source: https://zerotomastery.io/courses/business-intelligence-course/

Why learn Excel for Business Intelligence?

Business Intelligence, commonly referred to as “BI”, is one of the fastest growing and most in-demand fields in technology. BI is a broad term that encompasses data mining, data analysis, performance benchmarking using KPIs (Key Performance Indicators), and descriptive analytics.

Meanwhile, Excel is one of the most powerful applications ever built, with a massive and widely under-appreciated feature set. It has the horsepower and flexibility to play a crucial role in everyone’s toolbox.

Together? Well that’s where you can make magic happen. And that magic is what this Excel Business Intelligence Bootcamp teaches you.

Just because Excel is seemingly on everybody’s desktop does not mean that its BI tools are pedestrian.

To the contrary, Excel’s built-in “power” tools – such as Power Query for ETL (extract, transform, load) operations, the Excel Data Model for managing relational data (like that stored in relational databases), and the DAX formula language for advanced data analysis – are nearly identical to those found in Microsoft’s flagship Business Intelligence tool, Power BI.

And Excel’s extensive suite of charting and visualization tools, long considered one of its most powerful features, can translate the results of any data analysis into visually compelling and meaningful presentations that will ‘wow’ your colleagues and boss.