Get 25% OFF On All Courses, Use Code - AJCAZ4 | Valid Till 26-09-2021 (COVID-19 Pandemic) Stay Home, Stay Safe

Benefits of Certification

  • Government Certification
  • Job Credibility
  • Certification Valid for Life
  • Lifelong E-Learning Access

Description

In this course, you will learn the advanced pivot tables and also you will learn to create pivot tables and manipulate the data, meanwhile, you’ll be learning to import the data from Microsoft Access and Microsoft Excel into the tables, and even how to prepare the data in order to analyze like sort and filter.

And another thing you are going to learn is to create an interactive dashboard which is a very common option and also useful tools, while learning this option, you will be able to have the interactive dashboard that will help you to manage things quickly and easily.

And in the next section, you will be taught Power Pivot, Power Query, and Data Analysis, and also you will know how to discover the Power BI to create striking Data Visualization.

Along with that, you will also be learning python programming language so that you can write the python scripts and can automatically update data in a spreadsheet without any error.

After having this course certification, you will be a certified student of our organization.

Syllabus

Duration
Maximum Duration 1 Year
Syllabus
Module 1 Advanced Pivot Tables: Introduction Advanced Pivot Tables: Importing Data Advanced Pivot Tables: Preparing Data for Analysis Advanced Pivot Tables: Creating and Manipulating Pivot Tables Advanced Pivot Tables: Formatting a Pivot Table
Module 2 Advanced Pivot Tables: Value Field Settings Advanced Pivot Tables: Sorting and Filtering Advanced Pivot Tables: Interacting with a Pivot Table Advanced Pivot Tables: Calculations Advanced Pivot Tables: Pivot Charts
Module 3 Advanced Pivot Tables: Conditional Formatting Advanced Pivot Tables: Dashboards Advanced Pivot Tables: Summary Introduction to Power Pivot and Power Query Getting Started with Power Query
Module 4 Useful Power Query Features Creating a Data Model Introduction to Data Analysis Expressions (DAX) More Data Analysis Expressions (DAX) Measures Using Pivot Tables and Slicers
Module 5 Power Pivot, Power Query, and Data Analysis Expressions (DAX): Summary Introduction to Power BI Power BI: Getting and Transforming Data Power BI: Data Modelling Introduction to Data Analysis Expressions (DAX) Measures
Module 6 Power BI: Adding Visualizations to Your Report Power BI: Report Design Power BI: Editing Interactions and Filters Power BI Service Power BI: Summary
Module 7 Python: The Workplace Tech Divide Introduction to Python Basic Data Types Python Built-in Functions Variables and Functions
Module 8 Errors and Debugging Python Keywords If-Else Statements Storing Complex Data Python Modules
Module 9 Installing Python and Modules
Certification
Type Certificate

Reviews

Please login or register to review

Related Courses

beginner

Microsoft Excel

4.4 (20)
₹1,770 ₹3,540

beginner

Certificate in Python Machine Learning

4.4 (20)
₹3,540 ₹12,036

beginner

Certificate in Python

4.4 (20)
₹3,540 ₹26,550

beginner

Certificate in Python for Finance

4.4 (20)
₹2,950 ₹10,030

beginner

Certificate in AI with Python

4.4 (20)
₹2,950 ₹2,950

beginner

Power BI for Business Professionals

4.4 (20)
₹3,540 ₹23,600

beginner

Advanced Python Programming With Weird Concepts

4.4 (20)
₹3,540 ₹23,600
Frequently Asked Question Related To Course