skilldevelopment.cpe@lpu.co.in

What you'll learn

Description: Data analysis and visualization has emerged as one of the important skills in the present corporate world. Microsoft Excel is one of the most widely used tool among analysts. Tableau and Power BI are important, in-demand skill in Business Intelligence (BI) industry. This certification course will provide participants with a formal grounding in data analysis and visualization. These software’s convert complex data into meaningful information, visually appealing, interactive graphs/ charts/ tables/ dashboard/ story.

  • Introduction And General Utility Functions:: Filters, Advance Filters, Sorting, Freeze Panes, Duplicates, Paste Special, Text To Column, Conditional Formatting, Sum, Count And Average Functions (Including If And Ifs), Left, Right, Trim, Upper, Lower, Proper, Min, Max, Large, Small, Concatenate, Text To Column, Text Join, Date, Time, Month, Year, Dated If, Round Off, Random, Unique,Etc.
  • Relative And Absolute References, Cell Linking And Cell Freezing, Data Validation, Protection Of Data And Worksheet, Lookup (Lookup, Hlookup, Xlookup); If Statement, Nested If, If Error, Whatif Analysis: Goal Seek, Data Table And Scenario Analysis; Pivot Tables, Power Pivot, Slicers And Dashboards; Macros, Model Building Through Excel.
  • Introduction To Tableau: Interface, Environment, Cards, Shelfs, Marks, Data Connections, Metadata, Data Types, Extracts And Live Connections, Cross Database Joins And Union.Visualizations: Word Cloud, Time & Motion Chart, Dual Axis Chart, Maps, Map Options, Tree Map, Heat Map, Area Chart, Pie Chart, Field Map, Stacked Bar, Donut Chart, Scatter Plot, Constant, Reference And Drop, Line Chart, Cross Tabulation Etc.
  • Forecasting, Trend Analysis, Bin Creation, Group Creations, Text Filets, Number Filets, Date Filters, Drill Down Functionality And Hierarchies, Quick Table Calculations, Logical Calculations (Number, Date Etc), If Condition, Nested If, Parameters Creation And Control.Dashboard Creation And Storytelling: Fundamentals, Design, Web Integrity, Interactivity.
  • Introduction To Power Bi: Interface, Environment, Cards, Filters, Data Connections, Data Types, Aggregation, Data Transformation. Design Fundamentals: Bar Chart, Stacked Bar, Clustered Column Chart, Clustered Bar Chart, Pie Chart, Donut Chart, Gauge Chart, Ribbon Tree Map, Heat Map, Line Chart, Area Chart, Funnel Chart, Scatter Plot, Tables And Matrix, Other Advanced Charts.
  • Cards, Filters And Slicers, Drilldown Functionality, Hierarchies, Dax Functions And Dashboard.

Avatar
Dr. Harpreet Singh Bedi
Professor & Assistant Dean

Dr. Harpreet Singh Bedi is a Professor at the Mittal School of Business, Lovely Professional University, with over 2 decades of teaching experience. He holds a Gold Medal in MBA and has received the Academic Honour Award in PGDBM, along with a distinction in M. Com. Dr. Bedi is a certified professional in Microsoft Excel (by Microsoft) and Financial Modelling (by NSE, India). He specializes in Data Analysis and Data Visualization – Tableau and Power BI. He regularly conducts Executive Development Programs (EDPs) and Faculty Development Programs (FDPs) for various organizations and educational institutions.