Description
Data Analysis And Business Intelligence With Microsoft Excel, the course of data analysis and business intelligence with Microsoft Excel, is published by Udemy Academy. Instead of the old stuff, we’re going to take an in-depth look at a truly revolutionary set of tools that enable you to do business intelligence at an industrial level: the art and science of turning data—usually massive amounts of it—into information. Meaningful and applicable. In the past, doing real BI meant using expensive enterprise software that only a select few had access to; But with what you’ll learn in this course, you’ll be building powerful business intelligence solutions in no time, using nothing more than an Excel sheet on your desktop.
In each section, I use practical examples and intuitive explanations to teach you these concepts in a way that helps you see the connection between your new skills and the problems you want to solve at work. I’ve filled this course with tons of exercises—from simple to challenging—that will help you retain and even build on what you’ve learned. So if you want to master these enlab tools and build professional business intelligence solutions right on your desktop, all you need is Microsoft Excel – and this course – to do it.
What you will learn
- Use Power Query to import external data sets into Excel and transform them into whatever format is needed for your analysis.
- Learn the art and science of data modeling in Excel, connect your data sets with Power Query so you can analyze them together.
- Build pivot tables to quickly extract information from your data model, whether your data tables have 10 rows or 10 million
- Master the DAX formula language to inject more complex KPIs and calculations into your Pivot Tables than you ever thought possible.
- Turn your calculations into professional presentations with data visualization tools like Pivot Charts and conditional formatting
- Use Leverage Slicers and Timelines to engineer dynamic dashboards to maximize the amount of information you can present on one screen.
- retain and build on everything you’ve learned by doing dozens of hands-on exercises that cover every concept in this course.
Who is this course suitable for?
- Aspiring analysts who want to take their career to the next level by leveraging the business intelligence capabilities of Microsoft Excel to create solutions that stand out and get noticed.
- Data professionals who want to quickly increase their skills by mastering an easy-to-use, yet functional business intelligence tool.
- Business owners or managers who want to empower their employees to provide their business intelligence without buying expensive and specialized software.
- Any Excel user who wants to discover the secrets of their data using superior analytical tools on the Excel page.
Data Analysis And Business Intelligence With Microsoft Excel course specifications
- Publisher: Udemy
- teacher : Travis Cuzick
- English language
- Education level: all levels
- Number of courses: 73
- Training duration: 9 hours and 3 minutes
At the beginning of the course seasons on 1-2023
Course prerequisites
-
Microsoft Excel 2013 or above
-
A Windows PC (unfortunately, most of these tools won’t work on Excel for Mac)
-
Basic knowledge of Microsoft Excel, especially formulas and functions
Pictures
Sample video
Installation guide
After Extract, view with your favorite Player.
English subtitle
Quality: 720p
download link
File(s) password: www.downloadly.ir
Size
3.32 GB
Be the first to comment