Data Analysis And Business Intelligence With Microsoft Excel
Data Analysis And Business Intelligence With Microsoft Excel, available at $74.99, has an average rating of 4.67, with 74 lectures, based on 436 reviews, and has 33222 subscribers.
You will learn about 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 This course is ideal for individuals who are 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 or Data Professionals who want to quickly augment their skills by mastering an easy to use, yet industrial-strength Business Intelligence toolset or Business owners or executives who want to empower their employees to deliver self-service Business Intelligence without buying expensive, specialized software or Any Excel user who wants to unlock the secrets of their data using the best-in-class analytical tools right in their Excel spreadsheet It is particularly useful 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 or Data Professionals who want to quickly augment their skills by mastering an easy to use, yet industrial-strength Business Intelligence toolset or Business owners or executives who want to empower their employees to deliver self-service Business Intelligence without buying expensive, specialized software or Any Excel user who wants to unlock the secrets of their data using the best-in-class analytical tools right in their Excel spreadsheet.
Enroll now: Data Analysis And Business Intelligence With Microsoft Excel
Summary
Title: Data Analysis And Business Intelligence With Microsoft Excel
Price: $74.99
Average Rating: 4.67
Number of Lectures: 74
Number of Published Lectures: 74
Number of Curriculum Items: 74
Number of Published Curriculum Objects: 74
Original Price: $79.99
Quality Status: approved
Status: Live
What You Will 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 Should Attend
- 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
Target Audiences
- 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
The first thing you need to know about this course, is that this is NOTyour 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.
-
First up, we’ll dive into Power Query, a feature-packed yet easy to use tool for extracting, transforming, and loading (ETL for short) data from just about any source you can imagine into Excel. From text files to databases, wherever the data you want to analyze might be stored, you can use Power Query to pull it into Excel, and then transform it however you need to support your analysis.
-
Next, there’s an optional section on Pivot Tables, just in case you’re not already familiar with them. While Pivot Tables may not be a revolutionary new feature in and of themselves, they nonetheless play a crucial role in the Excel Business Intelligence landscape.
-
We’ll then learn to turn those Pivot Tables into “Power” Pivot Tables, by connecting them to the Excel Data Model…which is basically a relational database that lives right inside your Excel spreadsheet! This will allow us to mash up and analyze multiple datasets in a single Pivot Table…no VLOOKUPS required!
And remember how Excel usually starts to sputter out once you try to play around with more than a couple hundred thousand rows of data? No more! Power Pivot let’s you work with up to hundreds of millions of records in a single Excel file.
-
Then, so we can get the absolute most out of our Data Model (and into our Power Pivot Tables), we’ll learn DAX, an incredibly powerful formula language for creating complex calculations that you can drop right into your Pivots.
Since the basics of DAX syntax are easy to pick up if you’re already familiar with Excel formulas, we’ll venture into advanced topics like Time Intelligence, Iterator Functions, and Variables; and with exercises after almost every video, you’ll have plenty of opportunities to master what you’ve learned, right after you learn it.
-
Of course, all that number crunching doesn’t help much if we can’t present those numbers in an intuitive, easily digestible way. That’s why I close the course out with a series of powerful visualization techniques – from conditional formatting to Pivot Charts – that will transform your calculations into insights that can be used to make real-world decisions.
We’ll even explore techniques for building dynamic dashboards in Excel, using Slicers and Timelinesto not only filter our charts, but actually change the metrics we display in them. And all supported by the Data Model’s capacity for juggling hundreds of millions of rows of data in a single spreadsheet.
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!
Course Curriculum
Chapter 1: Introduction
Lecture 1: Introduction
Chapter 2: Power Query for Extract, Transform, and Load (ETL) operations
Lecture 1: DOWNLOAD: Resources For This Section
Lecture 2: A Note to Students Outside the US
Lecture 3: Introducing Power Query
Lecture 4: Applying Basic Transformations
Lecture 5: Editing Transformations
Lecture 6: Numerical Transformations
Lecture 7: Text Transformations
Lecture 8: Date Transformations – Building a Calendar Table
Lecture 9: Conditional Transformations
Lecture 10: IMPORTANT – If You're Following Along With The Examples
Lecture 11: Merging Datasets
Lecture 12: Appending Datasets
Lecture 13: DOWNLOAD: Exercise Files For This Section
Lecture 14: EXERCISES: Extracting, Transforming, and Loading With Power Query
Chapter 3: OPTIONAL: Pivot Tables 101
Lecture 1: Intro to Pivot Tables
Lecture 2: Adding Layers to Pivot Tables
Lecture 3: Pivot Table Formatting and Layout
Lecture 4: Filtering Pivot Tables
Lecture 5: Slicers
Lecture 6: Pivot Table Math
Lecture 7: Pivot Tables – Exercises
Chapter 4: The Excel Data Model
Lecture 1: DOWNLOAD: Resources For This Section
Lecture 2: Introducing Excel's Data Model
Lecture 3: Putting the Data Model to Work
Lecture 4: Relationships
Lecture 5: Relationships in the Excel Data Model
Lecture 6: Power Pivot Tables
Lecture 7: Calendar Tables
Lecture 8: Power Pivot Pitfalls
Lecture 9: Multiple Data Tables
Lecture 10: DOWNLOAD: Exercise Files For This Section
Lecture 11: EXERCISES: Data Modeling in Excel
Chapter 5: Analyzing the Data Model With DAX
Lecture 1: Calculated Columns With DAX
Lecture 2: EXERCISES: Calculated Columns With DAX
Lecture 3: The IF Function in DAX
Lecture 4: EXERCISES: The IF Function in DAX
Lecture 5: The SWITCH Function
Lecture 6: EXERCISES: The SWITCH Function
Lecture 7: The RELATED Function
Lecture 8: EXERCISES: The RELATED Function
Lecture 9: Introducing Measures
Lecture 10: EXERCISES: Introducing Measures
Lecture 11: Using DAX Functions in Measures
Lecture 12: EXERCISES: Using DAX Functions in Measures
Lecture 13: The CALCULATE Function
Lecture 14: EXERCISES: The CALCULATE Function
Lecture 15: The ALL Function
Lecture 16: EXERCISES: The ALL Function
Chapter 6: Advanced DAX
Lecture 1: Introducing Time Intelligence Functions
Lecture 2: The ISBLANK Function
Lecture 3: EXERCISES: The ISBLANK Function
Lecture 4: The DATEADD Function
Lecture 5: EXERCISES: The DATEADD Function
Lecture 6: The DATESINPERIOD Function
Lecture 7: EXERCISES: The DATESINPERIOD Function
Lecture 8: Variables in DAX
Lecture 9: EXERCISES: Variables in DAX
Lecture 10: The "X" Functions
Lecture 11: EXERCISES: The "X" Functions
Lecture 12: The RANKX Function
Lecture 13: EXERCISES: The RANKX Function
Lecture 14: The TOPN Function
Lecture 15: EXERCISES: The TOPN Function
Chapter 7: Data Visualization Techniques
Lecture 1: Pivot Table Formatting Tips
Lecture 2: Data Bars, Color Scales, and Icon Sets
Lecture 3: Custom Conditional Formats
Lecture 4: Introducing Pivot Charts
Lecture 5: Column Charts
Lecture 6: Line Charts, Area Charts, and Timelines
Lecture 7: Combo Charts
Lecture 8: Changing Measures With Slicers
Lecture 9: Using Pivot Tables as Formulas
Lecture 10: EXERCISES: Data Visualization Techniques
Instructors
-
Travis Cuzick
Data Solutions Engineer
Rating Distribution
- 1 stars: 5 votes
- 2 stars: 3 votes
- 3 stars: 22 votes
- 4 stars: 152 votes
- 5 stars: 254 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Language Learning Courses to Learn in November 2024
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024