Explanation
Data Analysis and Business Intelligence in Microsoft Excel The first thing you need to know about this course is that this is not your grandfather’s Excel. Instead of the same old paper material, we’re going to dive deep into a truly revolutionary tool that enables you to do the industry’s most powerful business secret: the art and science of converting data – often in large quantities. – meaningful, actionable insights. In the past, doing “real” BI meant using expensive business software that a select few people had access to anyway. But what you’ll learn in this course, you’ll be building complex business intelligence solutions in no time, using nothing more than an Excel spreadsheet on your desktop.
And in each section, I use hands-on demonstrations, practical examples, and intuitive, intelligent 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 at work. But most importantly, I’ve packed the course with TONS of exercises – ranging from simple to complex – that will help you retain, and even build on, what you’ve learned. So if you want to master this game-changing tool and build professional-level business intelligence solutions right on your desktop, all you need is Microsoft Excel – and this course – to do it. I hope to see you there!
What will you learn?
-
Use Excel Query to pull data out of Excel, and convert it to whatever format is needed for your analysis.
-
Learn the art and science of Data Modeling in Excel, linking your data from Query to Query for analysis
-
Build the “power” of Index Tables to quickly extract insights from your Data Model, whether your data tables have 10 rows or 10 million.
-
Become proficient in the DAX formula language, so you can inject more sophisticated calculations and KPIs into your Pivot Charts than you even thought possible.
-
Refine your statistics into professional presentations with data visualization tools such as Pivot charts and conditional modeling
-
Take advantage of Slicers and Timelines to craft dynamic dashboards that maximize the amount of information you can display 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 is this course for?
- Aspiring analysts who want to take their skills to the next level by unlocking the business intelligence functionality of Microsoft Excel to build visible and intuitive data solutions.
- Data professionals who want to quickly increase their skills with easy-to-use, yet industry-leading Business Intelligence tools
- Business owners or managers who want to enable their employees to provide self-service Business Intelligence without purchasing expensive, specialized software
- Any Excel user who wants to unlock the secrets of their data using best-in-class analysis tools right in the Excel spreadsheet.
Specialization in Data Analysis and Business Intelligence in Microsoft Excel
- Publisher: Udemy
- Teacher: Travis Cuzick
- Language : English
- Level : All Levels
- Number of courses: 73
- Duration: 9 hours and 3 minutes
Includes 1/2023
Requirements
-
Microsoft Excel 2013 or higher
-
A Windows PC (unfortunately, most of these tools won’t work with Excel on Mac)
-
Basic knowledge of Microsoft Excel, especially formulas and functions
Pictures
Sample Clip
Installation Guide
Extract files and watch your favorite player
Subtitle : English
Quality: 720p
Download Links
Password file: free download software
file size
3.32GB