LPU - Lovely Professional University
What you'll learn

Power BI and Tableau are important, in-demand skill in Business Intelligence (BI) industry. This course is designed to equip participants with essential skills in data analysis and visualization. Through this course, learners will gain a formal grounding in transforming complex datasets into visually appealing and interactive graphs, charts, dashboards, and stories. The curriculum covers a wide range of topics, from fundamental data connections and design principles to advanced decision analytics, interactivity, and dashboard creation, preparing participants to excel in their data-driven roles.

  • Introduction to Tableau: Interface, Environment, Cards, Shelfs, Marks, Data Connections, Metadata, Data Types, Extracts and Live Connections, Cross Database Joins and Union.
  • Design Fundamentals and 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 Filters, Number Filters, 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, and Data Transformation.
  • Design Fundamentals: Cards, Filters and Slicers, Drilldown Functionality, Hierarchies, 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.
  • Power Query, 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.