Udemy – Data Analysis And Business Intelligence With Microsoft Excel 2021-10

Published on: 2023-06-27 03:18:00

Categories: 28

Descriptions

Data Analysis And Business Intelligence With Microsoft Excel The first thing you need to know about this course, is that this is NOT your granddad’s Excel. Instead of the same old spreadsheet stuff, we’ll do a deep dive on a truly revolutionary set of tools that empower you to do industrial-strength Business Intelligence: the art and science of transforming data – usually massive amounts of it – into meaningful, actionable insights. In the past, doing “real” BI meant using expensive enterprise software that only a select few people would have access to anyway. But with what you’ll learn in this course, you’ll be building robust Business Intelligence solutions in no time, using nothing more than an Excel spreadsheet on your desktop.

And in each section, I use hands-on demos, practical examples, and intuitive, common-sense explanations to teach you these concepts in a way that will help you see the connection between your new skills and the problems you’re trying to solve on the job. But just as importantly, I’ve packed the course with TONS of exercises – ranging from straightforward to challenging – that will help you retain, and even build on, what you’ve learned. So if you want to master these game-changing tools and build professional-grade Business Intelligence solutions right on your desktop, all you need is Microsoft Excel – and this course – to do it. I look forward to seeing you there!

What you’ll learn

Use Power Query to pull external datasets into Excel, and transform them into whatever shape is needed for your analysis
Master the art and science of Data Modeling in Excel, connecting your datasets from Power Query so they can be analyzed together
Build “Power” Pivot Tables to rapidly extract insights from your Data Model, whether your data tables have 10 rows or 10 million
Become proficient in the DAX formula language, to inject more sophisticated calculations and KPIs into your Pivot Tables than you even thought possible
Polish your calculations into professional presentations with data visualization tools like Pivot Charts and conditional formatting
Leverage Slicers and Timelines to engineer dynamic dashboards that maximize the amount of information you can present on a single screen
Retain – AND build on – everything you’ve learned, by tackling dozens of hands-on exercises that cover every concept in the course

Who this course is for

Aspiring Analysts who want to take their careers to the next level by unleashing Microsoft Excel’s Business Intelligence functionality to build data solutions that stand out and get noticed
Data Professionals who want to quickly augment their skills by mastering an easy to use, yet industrial-strength Business Intelligence toolset
Business owners or executives who want to empower their employees to deliver self-service Business Intelligence without buying expensive, specialized software
Any Excel user who wants to unlock the secrets of their data using the best-in-class analytical tools right in their Excel spreadsheet