Advanced Excel Bootcamp: Data Analytics and Business Intelligence Free Download
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.
Why this Excel BI course?
This course is focused on efficiency.
So you never have to waste your time on confusing, out-of-date, incomplete tutorials anymore.
Instead, you’ll learn everything from the basics of Business Intelligence to using the most advanced ‘power’ features Excel has to offer. All in one course.
And you’ll be learning Excel BI in a fun and supportive environment.
By enrolling today, you’ll also get to join our exclusive live online community classroom to learn alongside thousands of students, alumni, mentors, TAs and Instructors.
Most importantly, you will be learning from an industry expert that has actual real-world experience working as a Data Solutions Engineer on massive datasets for some of the largest companies.
What you’ll learn
Become a top 10% Business Intelligence Analyst or Data Analyst to enhance your skillset and career opportunities
Build an end-to-end Business Intelligence solution for a fictional surf shop, including dozens of powerful KPIs that provide deep insight into business performance
Use Power Query to pull external datasets into Excel, and transform them into whatever shape is needed for data analysis
Master the art and science of Data Modeling in Excel, connecting relational datasets from Power Query so they can be analyzed together
Build ‘Power’ Pivot Tables to rapidly extract insights from the Excel Data Model, whether your data tables have 10 rows or 10 million
Proficiently apply the DAX formula language, to inject sophisticated calculations and KPIs into Pivot Tables
Polish calculations into professional presentations, with data visualization tools like Pivot Charts and conditional formatting
Use Excel’s powerful charting engine to tell the story of your data with attractive data visualizations
Learn how to build Excel formulas for data analysis, data science, data entry, and everyday office use
Leverage Slicers and Timelines to engineer dynamic dashboards that maximize the amount of information you can present on a single screen
Learn how to use Microsoft Excel to supplement your Power BI skills
Loads of exercises to practice and perfect your skills
Learn why Excel is one of the most popular pieces of software across all industries
Master Excel’s built-in ‘power’ tools and see how they’re nearly identical to those found in Microsoft’s flagship Business Intelligence tool, Power BI
