HOT
blank

Excel Dashboards & Power BI Bootcamp – Finance & Accounting

Business

Rating4.5
Enroll Now

Excel Dashboards & Power BI Bootcamp – Finance & Accounting, available at $54.99, has an average rating of 4.45, with 41 lectures, 6 quizzes, based on 23 reviews, and has 165 subscribers.

You will learn about How to create beautiful, powerful, dynamic dashboards and reports in Power BI How to get more out of Microsoft excel including great dashboards Make reports available to stakeholders 24/7 on all devices Simple methods to Analyze data with Power BI and gain Insights Different visualizations & how to use them Explore your data with Power BI Master the rules for Data Preparation Identify what a dashboard really is and dashboard best practices Connect your data to Microsoft Power BI This course is ideal for individuals who are Finance analysts and accountants who want to upskill reporting and analytics or Excel users who want to learn how to create professional reports in Power BI or Business Intelligence enthusiasts or Data Science enthusiasts or Small business owners who want to better understand and visualize their data or Business Students It is particularly useful for Finance analysts and accountants who want to upskill reporting and analytics or Excel users who want to learn how to create professional reports in Power BI or Business Intelligence enthusiasts or Data Science enthusiasts or Small business owners who want to better understand and visualize their data or Business Students.

Enroll now: Excel Dashboards & Power BI Bootcamp – Finance & Accounting

Summary

Title: Excel Dashboards & Power BI Bootcamp – Finance & Accounting

Price: $54.99

Average Rating: 4.45

Number of Lectures: 41

Number of Quizzes: 6

Number of Published Lectures: 41

Number of Published Quizzes: 6

Number of Curriculum Items: 47

Number of Published Curriculum Objects: 47

Number of Practice Tests: 1

Number of Published Practice Tests: 1

Original Price: $34.99

Quality Status: approved

Status: Live

What You Will Learn

  • How to create beautiful, powerful, dynamic dashboards and reports in Power BI
  • How to get more out of Microsoft excel including great dashboards
  • Make reports available to stakeholders 24/7 on all devices
  • Simple methods to Analyze data with Power BI and gain Insights
  • Different visualizations & how to use them
  • Explore your data with Power BI
  • Master the rules for Data Preparation
  • Identify what a dashboard really is and dashboard best practices
  • Connect your data to Microsoft Power BI

Who Should Attend

  • Finance analysts and accountants who want to upskill reporting and analytics
  • Excel users who want to learn how to create professional reports in Power BI
  • Business Intelligence enthusiasts
  • Data Science enthusiasts
  • Small business owners who want to better understand and visualize their data
  • Business Students

Target Audiences

  • Finance analysts and accountants who want to upskill reporting and analytics
  • Excel users who want to learn how to create professional reports in Power BI
  • Business Intelligence enthusiasts
  • Data Science enthusiasts
  • Small business owners who want to better understand and visualize their data
  • Business Students

Being able to visually present your analysis is key! Learn to create beautiful, powerful, and dynamic dashboards in Excel and Power BI.

What will you learn in this course?

  • Identify what a dashboard really is and dashboard best practices

  • Create a powerful, dynamic Excel dashboard

  • Create many of the most common visualizations used in dashboards

  • Connect your data to Microsoft Power BI

  • Utilize Power BI to create powerful visualizations

  • Derive a deeper knowledge of your data using the tools in Power BI

Want to be the team Rockstar? Learn to create dashboards! Dashboards are interactive tools that provide insights and analyses to users. This course will quickly teach you how to create amazing dashboards in Excel and Microsoft Power BI.

After learning dashboard fundamentals in Excel, we’ll supercharge your skills by teaching you Power BI. Power BI is Microsoft’s free business intelligence tool that allows you to easily create interactive and powerful dashboards.

We recommend taking our Intro to Data Analytics using Excel in conjunction with this course. In order to truly understand your data, you need to know some analytics.

At completion, you’ll know how to make dynamic dashboards in both Excel and Power BI.

What makes our course so awesome?

· Real world case-studies: In depth, real-world case studies using fictitious companies

· Fun: Light-hearted, fun, and enjoyable course (we never take ourselves too seriously)

· Knowledgeable instructor:Nate is a CPA and Joe is a CFO, a lot of experience and expertise!

· No fluff: We don’t teach theory or waste your time with useless information. Everything we teach you can start applying TODAY

Let’s start learning!

Course Curriculum

Chapter 1: Welcome to the course!

Lecture 1: Introduction

Chapter 2: Introduction to Dashboards & to the Case Study

Lecture 1: Key components of a dashboard

Lecture 2: Introducing the case study pt. I

Lecture 3: Introducing the case study pt. II

Lecture 4: Setting up our data pt. I

Lecture 5: Setting up our data pt. II

Chapter 3: Creating a Dynamic Excel Dashboard pt. I

Lecture 1: Creating KPI squares pt. I

Lecture 2: Creating KPI squares pt. II

Lecture 3: Creating KPI squares pt. III

Lecture 4: Creating a speedometer chart pt. I

Lecture 5: Creating a speedometer chart pt. II

Lecture 6: Creating a speedometer chart pt. III

Lecture 7: Creating a combo chart

Chapter 4: Creating a Dynamic Excel Dashboard pt. II

Lecture 1: Comparing CY vs. PY sales pt. I

Lecture 2: Comparing CY vs. PY sales pt. II

Lecture 3: Creating a dynamic chart w/ a spin button pt. I

Lecture 4: Creating a dynamic chart w/ a spin button pt. II

Lecture 5: Using COUNTIFS and Recommended Charts pt. I

Lecture 6: Using COUNTIFS and Recommended Charts pt. II

Lecture 7: Drawing conclusions from our data pt. I

Lecture 8: Drawing conclusions from our data pt. II

Chapter 5: Analyzing Our Data Using Microsoft Power BI pt. I

Lecture 1: Downloading Power BI

Lecture 2: Overview of the Power BI visualizations

Lecture 3: Overview of the Power BI

Lecture 4: Importing data into Power BI

Lecture 5: Connecting and updating our data sources

Lecture 6: Creating a column chart

Lecture 7: Formatting our data in Power BI

Lecture 8: Creating a pie chart

Lecture 9: Creating a bar chart and slicer

Lecture 10: Editing the interaction between charts

Chapter 6: Analyzing Our Data Using Microsoft Power BI pt. II

Lecture 1: Creating a filled map visualization

Lecture 2: Creating a scatter plot

Lecture 3: Creating a speedometer chart

Lecture 4: Creating a funnel chart

Lecture 5: Creating KPI squares

Lecture 6: Creating a combo chart with a custom calculation pt. I

Lecture 7: Creating a combo chart with a custom calculation pt. II

Lecture 8: Creating a dashboard on the BI cloud

Lecture 9: Gaining greater insights into our data

Chapter 7: Conclusion

Lecture 1: Conclusion

Instructors

Rating Distribution

  • 1 stars: 1 votes
  • 2 stars: 1 votes
  • 3 stars: 1 votes
  • 4 stars: 6 votes
  • 5 stars: 14 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 Relationship Building Courses to Learn in November 2024

Top 10 Storytelling Courses to Learn in November 2024

Top 10 Resilience Training Courses to Learn in November 2024