Excel Dashboards & Power BI Bootcamp – Finance & Accounting
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
-
Joseph @ Wisdify
CFO, Corporate Finance expert, Instructor, Mentor
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 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
- Top 10 Gardening Courses to Learn in November 2024