LPU - Lovely Professional University
What you'll learn

This course offers an immersive, hands-on learning experience in key data analytics tools — Microsoft Excel, SQL, Python, Power BI, and Tableau. Designed for aspiring data professionals, it builds foundational and practical skills in data cleaning, analysis, visualization, dashboard creation, and storytelling. Participants will learn how to extract actionable insights and drive data-informed decisions, preparing them for careers in analytics and business intelligence.

  • Overview of Data Analytics: Understanding the role of data in decision-making and problem-solving. Key concepts: Types of data (structured vs. unstructured), sources (internal, external), and the life cycle of data analytics. Exploring different analytics types: Descriptive (what happened), diagnostic (why it happened), predictive (what might happen), and prescriptive (what should be done). Importance of leveraging tools like Excel, Python, SQL, and Power BI in real-world analytics. Use of AI in Data Analytics.
  • Data Analytics using MS Excel: Introduction to Microsoft Excel and its use in foundational analytics tasks. Cleaning and Preparing Data: Removing errors, handling missing values, finding & removing duplicates, and ensuring data integrity using conditional formatting and data validation for quality checks. Sorting and filtering data in Excel for analysis. 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, Relative and Absolute References, IF Statement, Nested if, If error etc, Logical Functions using AI tools, Lookup Functions (Lookup, Hlookup, Xlookup). Use of AI in Basic and Logical functions. Summarization and visualization Pivot tables to summarize data and basic and advanced charts for visualization. Dashboarding in Excel: Introduction to dashboard creation, Linking pivot tables, slicers, and charts for interactive dashboards. Best practices (using AI) for making dashboards user-friendly and insightful.
  • Foundations of SQL: Database basics and setup. Essential SQL commands: SELECT, INSERT, UPDATE, DELETE. Data Summarization using Aggregation functions (SUM, AVG, MIN, MAX, COUNT), and GROUP BY - HAVING. Data Relations and Transformation: Working with joins (INNER, LEFT, RIGHT, FULL joins), Using CASE statements for conditional data transformation. Subqueries. Data Pivoting using SQL using CASE statements and using PIVOT operator. Use of AI in above functions.
  • Introduction to Python: Installation, IDEs (Jupyter, VS Code. Google Colab), and Python essentials Keywords, Identifiers, Variables, Operators, Control Flow, Lists, Tuples, Sets, Dictionaries, Strings. Working with Pandas and NumPy to clean and analyse datasets: Import datasets from external source. Data Cleaning (Handling missing values and Removing duplicates). Data Transformation (Filtering and selecting subsets, Aggregating data, Merging multiple datasets). Handling missing data and outliers. Data Visualization: Creating visualizations with Matplotlib and Seaborn.
  • Power BI: Interface, Environment, Data Connections, Data Types, Aggregation, and Data Transformation. Design Fundamentals and Visualizations: 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. Usage of AI in Report Designing. Cross Tabulation: Tables and Matrix, Filters, Slicers, Cards, Drilldown; Forecasting and Trend Analysis. Power Query (Get & Transform): Import, Transform, Clean, Combine data and files. DAX Functions: New Measure Vs New Column, Number base calculation, Text based Calculations, Date base Calculation, Logic Based Calculation (IF Condition and Nested IF) and Bin Creation. Dashboard: Fundamentals, Design, Interactivity and AI usage for Theme creation and Designing. Publishing Report: Power BI Cloud Services.
  • Tableau: Interface, Environment, Cards, Shelfs, Marks, Data 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, Use of AI for visualization. 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 and usage of AI. Project Presentations

Avatar
Sumit Mittu
Assistant Professor

Mr. Sumit Mittu, Assistant Professor in School of Computer Science and Engineering, Lovely Professional University, is strong academician with 20+ years of experience in teaching as well as academic administration. He has trained thousands of undergraduate and post-graduate students with skills of programming using several languages like C/C++, Java, Python, VB, C#, SQL, HTML, JS, ASP, etc. as well as contributed in building strong foundation in students for core computer science courses including but not limited to Data Structures, Operating Systems, Computer Networks, DBMS, Data Analytics etc. He is the author of the book “A Workbook on C++” published by Cengage Learning. He has also delivered several guest lectures and FDPs on topics like e-learning, smart teaching, computer programming etc. He has a strong hold on handling data for diversified application areas and problems statements over academia and understands the career expectation of the recruiters and skill gap in students.


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.