Business Analytics Certification Course with Excel
3652
Learners
This Business Analytics certification course teaches you the basic concepts of data analysis and statistics to help data-driven decision making. This training introduces you to Power BI and delves into the statistical concepts that will help you devise insights from available data in order to present your findings using executive-level dashboards.
Price
4000
Duration
45 Days
Business Analytics Certification Course with Excel
Overview of
Boost your analytics career with powerful new Microsoft® Excel skills by taking this Business Analytics course, which includes training on Power BI. These two commonly used tools, combined with official business analytics certification, will put you on the path of a successful career.
Key Features
Business Analytics Certification Course with Excel
12 hours of self-paced video
Two hands-on industry-based projects on healthcare and e-commerce
Includes training on business intelligence using Power BI
Eight practical exercises
Lifetime access to self-paced learning
Contact us: +918586014284
Benefits
Key Learning Outcomes:
When you complete this Business Analytics with Excel course, you will be able to
accomplish the following:
Understand the basic concepts of business analytics
Analyze data with pivot tables
Understand the principles of dashboard design and how to create charts in Excel
Learn data analysis using statistics
Understand conditional formatting and logical functions
Contact us on WhatsApp: +918586014284
Business Analytics Certification Course with Excel
Curriculum -
Prerequisites:
There are no prerequisites for this Business Analytics certification training other than an analytical mindset. However, we do expect the participants to have a basic knowledge of working with Microsoft Excel
Course Curriculum:
Lesson 01 - Introduction to Business Analytics
Introduction
What Is in It for Me
Types of Analytics
Areas of Analytics
Key Takeaways
Conclusion
Lesson 02 - Formatting Conditional Formatting and
Important Functions
Introduction
What Is in It for Me
Custom Formatting Introduction
Custom Formatting Example
Conditional Formatting Introduction
Conditional Formatting Example
Conditional Formatting Example
Conditional Formatting Example
Logical Functions
Lookup and Reference Functions
VLOOKUP Function
HLOOKUP Function
MATCH Function
INDEX and OFFSET Function
Statistical Function
SUMIFS Function
COUNTIFS Function
PERCENTILE and QUARTILE
STDEV, MEDIAN and RANK Function
Exercise Intro
Exercise
Key Takeaways
Conclusion
Lesson 03 - Analyzing Data with Pivot Tables
Introduction
What Is in It for Me
Pivot Table Introduction
Concept Video of Creating a Pivot Table
Grouping in Pivot Table Introduction
Grouping in Pivot Table Example
Grouping in Pivot Table Example
Custom Calculation
Calculated Field and Calculated Item
Calculated Field Example
Calculated Item Example
Slicer Intro
Creating a Slicer
Exercise Intro
Exercise
Key Takeaways
Conclusion
Lesson 04 - Dashboarding
Introduction
What Is in It for Me
What is a Dashboard
Principles of Great Dashboard Design
How to Create Chart in Excel
Chart Formatting
Thermometer Chart
Pareto Chart
Form Controls in Excel
Interactive Dashboard with Form Controls
Chart with Checkbox
Interactive Chart
Exercise Intro
Exercise1
Exercise2
Key Takeaways
Conclusion
Lesson 05 - Business Analytics With Excel
Introduction
5.002 What Is in It for Me
5.003 Concept Video Histogram
5.004 Concept Video Solver Addin
5.005 Concept Video Goal Seek
5.006 Concept Video Scenario Manager
5.007 Concept Video Data Table
5.008 Concept Video Descriptive Statistics
5.009 Exercise Intro
5.10 Exercise
5.012 Key Takeaways
5.013 Conclusion
Lesson 06 - Data Analysis Using Statistics
Introduction
What Is in It for Me
What is a Dashboard
Principles of Great Dashboard Design
How to Create Chart in Excel
Chart Formatting
Thermometer Chart
Pareto Chart
Form Controls in Excel
Interactive Dashboard with Form Controls
Chart with Checkbox
Interactive Chart
Exercise Intro
Exercise1
Exercise2
Key Takeaways
Conclusion
Lesson 07 - Power BI
Introduction
What Is in It for Me
Power Pivot
Power View
Power Query
Power Map
Key Takeaways
Conclusion
Why CertifyMind for this Course:
Upon successful completion of the this course, CertifyMind will provide you with an industry-recognized course completion certificate which has lifelong validity.
Why Online Bootcamp
Develop skills for real career growth
Cutting-edge curriculum designed in guidance with industry and academia to develop job-ready skills
Learn from experts active in their field, not out-of-touch trainers
Leading practitioners who bring current best practices and case studies to sessions that fit into your work schedule.
Learn by working on real-world problems
Capstone projects involving real world data sets with virtual labs for hands-on learning
Structured guidance ensuring learning never stops
24x7 Learning support from mentors and a community of like-minded peers to resolve any conceptual doubts
CONTACT
US
Mobile No: +91-8586014284
email: info@certifymind.com
Office Address: M-64, Saurabh Vihar, Jaitpur, Badarpur, Delhi , India- 110044
VISIT
US
Monday - Sunday 09:00 - 18:00
TELL
US
Disclaimer
PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.
ITIL® is a registered trade mark of AXELOS Limited, used under permission of AXELOS Limited. All rights reserved.
IT Infrastructure Library is a [registered] trade mark of AXELOS Limited used, under permission of AXELOS Limited. All rights reserved.
The Swirl logo™ is a trade mark of AXELOS Limited, used under permission of AXELOS Limited. All rights reserved.
PRINCE2® is a [registered] trade mark of AXELOS Limited, used under permission of AXELOS Limited. All rights reserved.
MSP® is a [registered] trade mark of AXELOS Limited, used under permission of AXELOS Limited. All rights reserved.
Certified ScrumMaster® (CSM) and Certified Scrum Trainer® (CST) are registered trademarks of SCRUM ALLIANCE®
Professional Scrum Master is a registered trademark of Scrum.org
The APMG-International Finance for Non-Financial Managers and Swirl Device logo is a trade mark of The APM Group Limited.
The Open Group®, TOGAF® are trademarks of The Open Group.
IIBA®, the IIBA® logo, BABOK® and Business Analysis Body of Knowledge® are registered trademarks owned by International Institute of Business Analysis.
CBAP® is a registered certification mark owned by International Institute of Business Analysis. Certified Business Analysis Professional, EEP and the EEP logo are trademarks owned by International Institute of Business Analysis.
COBIT® is a trademark of ISACA® registered in the United States and other countries.
CISA® is a Registered Trade Mark of the Information Systems Audit and Control Association (ISACA) and the IT Governance Institute.
CISSP® is a registered mark of The International Information Systems Security Certification Consortium ((ISC)2).
CISCO®, CCNA®, and CCNP® are trademarks of Cisco and registered trademarks in the United States and certain other countries.
Simplilearn and its affiliates, predecessors, successors and assigns are in no way associated, sponsored or promoted by SAP SE and neither do they provide any SAP based online or real-time courses or trainings
The KPMG name and logo are trademarks used under license by the independent member firms of the KPMG global organization. KPMG International’s Trademarks are the sole property of KPMG International and their use here does not imply auditing by or endorsement of KPMG International or any of its member firms.