Two Days (Class Room) Workshop
Basics of Data Visualisation using MS Excel and Power BI
05th and 06th May 2022 09:30 AM - 05:00 PM
Facilitator:
Mr . S. Bhanu Kumar Founder , ARRA Associates
1. The course aims to enable learners to Understand the concepts around Data Analytics, Visualization 2. Understand the advanced concepts in Microsoft Excel that enables Data Analytics 3. Learn a Tool beyond Excel for Data Visualization Power BI 4. Creating an interactive, intuitive Dashboard from a single source of truth using Microsoft Power BI
BRIEF OVERVIEW
SESSION CONTENT
Day 1
MS Excel Working with Data – beyond Sort & Filter Tables, Pivot Tables, Slicers Performing Calculations using formula including Formula Auditing Common Statistical functions Lookup & Reference Functions Date & Time Functions Text Functions Conditional Statements & Logical Operators Using Visuals – Filters / Combination Charts etc Formula based Formatting Excel as an Analytical Tool
SESSION CONTENT
Day 2
MS PowerBI Power BI Desktop - Introduction Getting Data Data Sources Settings Loading Data Basic Visuals Data from Excel Shaping, cleaning data and combining data sets Visualization - Types with and without filters – Formatting Visuals Creating Dashboard
For Whom Executives and Managers from all verticals Entrepreneurs Faculty Members
Key Takeaways Manipulate and Format data Analyse data and present the results in a user friendly manner Use formulae and functions for advanced calculations Use PowerBI to convert data into insights Create & Present dashboard in an interactive and intuitive format from a single source of truth
Facilitators' Profile: Mr . S. Bhanu Kumar A Technology industry veteran passionate about training. Bhanu specializes in technology training and workshops that caters to the needs of the students and is more experiential that enables the learner to apply the skill where necessary. More than 5000 hours of training across various aspects of technology and employability and still ticking Bhanu currently is focusing on Giving back to society and is a frequent speaker at industry events, delivered training and workshops on Technology basics, implementation of technology and technology transformations Bhanu is a Practitioner who trains and has worked in NTT DATA GDS for more than a decade and was Vice President of Cloud Services when he exited the company
Fee Details:
MMA Member Fee: ₹3800/- (Plus 18% GST) Non - Member Fee: ₹4560/- (Plus 18% GST)
For Registration, Mail us to mma@mmachennai.org with Your Name, Contact Number & E-Mail ID (Please await our advice before making Payment)