Certification Course Power BI & Alteryx MasterClass by CA Nikhil Dhingra

Session Plan

What is Data Analytics and why is it important
What is Data Visualisation
Common Tools used for Data Analytics and Visualisation

Dive into the world of built-in MS Excel functions.
Learn essential MS Excel skills including Importing text file to excel, text to column function, basic navigation & formatting, Paste Special commands
Absolute referencing, relative referencing, logical functions, Filtering & use cases, Linking, Tracing Dependents & Precedents, Transpose function

Learn range of tools including Move and Copy, Duplicate Values, Concatenate, VLOOKUP, and Pivot Tables for multi-dimensional analysis, Pareto Analysis.
Create various charts such as bar graphs, histograms, pie charts, Line Diagrams, 2 Variable Charts etc.

Introduction to Power BI
Visualizing data on Power BI that was previously analysed on MS Excel
Creating dynamic pivots and charts on Power BI
Creating Relationships between tables

Analyse & visualize data on Power BI
Create a dashboard on real life company data
Formatting and Dynamic Analysis on Power BI

Understand the tool and how it can help analyse heavy data
Learn range of tools and functions available in the application including connecting to data source, browsing the data, data cleansing tools, filtering out data, using formula tool, sorting the data, generating rows, using join tool, transposing data, summarizing/ grouping data etc.
Analyse real life data set to apply some of the common tools
Some useful tips to keep in mind while using the application

Performing previously used excel based analysis on Alteryx
Finding Anomalies in Data
Using Alteryx and Power BI together
Certificate of Completion
Revision Manual and Interview Guidebook

MCQs Based Exam Online - Practical Exam based on Course Module

Meet Your Instructor

CA Nikhil Dhingra

Nikhil Dhingra-is a Chartered Accountant. With over 7 years of experience, Nikhil has handled Internal Audit and Risk Consulting assignments in one of the Big 4s involving intensive data analytics and visualization to provide practical and focused business decisions. His consultancy experience spans across diverse industries.