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 analyze big data sets, automate tasks with intelligent functions, and unlock the full potential of Excel 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.
Course Details
Explore the comprehensive course modules
Introduction and General Utility Functions: Filters, Advance Filters, Sorting, Freeze Panes, Duplicates, Paste Special, Text to Column, Inserting Headers, Footers and Hyperlinks. Conditional Formatting: highlight cell rules, data bars, colour scales, icon sets, colour coding. Relative and Absolute References, Cell Linking and Cell Freezing, General Utility Functions: Sum, Count and Average functions (including IF and IFs), Sub- Totals, Left, Right, Trim, Upper, Lower, Proper, Min, Max, Large, Small, Concatenate, Text to Column, Text join, Grouping and Ungrouping, Date, Time, Month, Year, Round off, Random, Unique, IF Statement, Nested if, If error etc.
Data Validation, Lookup (Lookup, Hlookup, Xlookup). Data Protection: Locking/ Unlocking of Cells, Protection of Worksheet and Workbook. 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.
Integrating GPT AI tools in Excel. Pivot Tables: Creation of pivot tables, Data Analysis and summarization, Filters in Pivot Table, Sorting, Calculations, Aggregate Functions, Pivot Charts. Power Pivot. Dashboards Building in Excel: Fundamentals, designing and interactivity through slicers. Introduction to Macros and Recording of Macros.
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.
Learn from leading experts in stem cell research
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).
Report of NIRF Data Capturing System: Management Report of NIRF Data Capturing System: Pharmacy Report of NIRF Data Capturing System: Engineering Report of NIRF Data Capturing System: Overall Report of NIRF Data Capturing System: Law Report of NIRF Data Capturing System: Architecture Report of NIRF Data Capturing System: Innovation Report of NIRF Data Capturing System: Agriculture Report of SDG Institution Report of NIRF Data Capturing System: Management Report of NIRF Data Capturing System: Pharmacy Report of NIRF Data Capturing System: Engineering Report of NIRF Data Capturing System: Overall Report of NIRF Data Capturing System: Law Report of NIRF Data Capturing System: Architecture Report of NIRF Data Capturing System: Agriculture
