LPU - Lovely Professional University
What you'll learn

This is a comprehensive course designed to transform the Data analysis and visualization skills of participants from basic to advanced level. The course equips participants with the ability to analyse big data sets, automate tasks with intelligent functions, and unlock the full potential of Excel, Tableau and Power BI for both personal and professional use. By the end of the course, participants will proficiency in Data Analysis, Data Visualization and Dashboard Designing.

  • Introduction and General Utility Functions: Filters, Advance Filters, Sorting, Freeze Panes, Duplicates, Paste Special, Text to Column, Conditional Formatting: highlight cell rules, data bars, colour scales, icon sets, colour coding. General Utility Functions: 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, Round off, Random, Unique, IF Statement, Nested if, If error etc. General Utility Functions using AI tools.
  • Data Validation, Lookup (Lookup, Hlookup, Xlookup). Whatif Analysis: Goal Seek, Data Table and Scenario Analysis. Charts and Graphs: Gantt Chart, Pie Chart, Line chart, Area Chart, Bar Graph, Stacked Bar chart, Heatmap, Treemap, Spider Chart, Combo Chart, Donut Chart etc.
  • Pivot Tables: Creation of pivot tables, Data Analysis and summarization, Filters in Pivot Table, Sorting, Aggregate Functions, Pivot Charts
  • Introduction to Power BI: Interface, Environment, Data Connections, Data Types, Aggregation, and Data Transformation. Report Creation and Design Fundamental: Bar and Column Chart, Stacked and Clustered Bar/ Column Chart, Combo Charts, Pie Chart, Donut Chart, Gauge Chart, Tree Map, Line Chart, Area Chart, Funnel Chart, Scatter Plot, Decomposition Tree, Filed Map, Symbol Map, and Other Advanced Charts like Infographics, Word Cloud, Scroller, Animated Bar Chart etc. Cross Tabulation: Tables and Matrix, Text and Number Filters, Filters on Visuals and page, Slicers, Cards, Hierarchies and Drilldown.
  • DAX Queries: Sum, Average, Count, Product, Divide, Left, Right, Upper, Lower, Max, Min, Rand, Randbetween, Concatenate, & operator, Related, Today, IF Condition, Nested IF, IF AND, IF OR etc. Data Models: Working with multiple databases and data files, integration and connectivity. Data Blending with Power Query (Get & Transform): Import, Transform, Clean, Combine data and files with Merge and Append Query.
  • Analytics: Forecasting, Trend Analysis, Reference and Average Lines, Group Creation, Bin formation and application, Parameter creation and applications. Dashboard: Fundamentals, Design and Interactivity. Publishing Report: Power BI Cloud Services. Project Presentations

Avatar
Dr. Abhay Grover
Associate Professor

Dr. Abhay Grover is an Associate Professor and Head of Training and Placements at the Mittal School of Business, Lovely Professional University, Punjab. With over fifteen years of academic experience and valuable industry exposure, he has consistently driven student success through impactful teaching and placement strategies. His expertise spans Excel, GST, Accounting, and Business Law, complemented by active research interests in marketing, social commerce, and emerging business trends. Known for bridging the gap between academia and industry, he is committed to developing future-ready professionals.


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.