Data Analytics Course

Module1- Introduction: - • Power BI Desktop Overview – Interface and getting started • Connecting to Data Sources – Excel, PDF, CSV, databases, web, and SaaS apps • Advanced Data Integration – Azure SQL, Analysis Services, OData, SharePoint • Using Scripts for Data – Importing with Python and R • Power Query Introduction – Power Query Editor and Advanced Editor basics

Module 2- Data Transformation • Power Query Basics – Editor, steps, and M language • Data Cleaning & Structuring – Formatting, profiling, splitting, replacing • Transformations – Merge, append, pivot/unpivot, group by, transpose • Dynamic Logic – Parameters, conditional/custom columns, fill, reverse • Best Practices – Naming, joins, headers, references, hierarchies • Introduction to Python Library

Module 3 - Data Modelling and DAX • Data Relationships – Create, manage, and understand relationships, cardinality, and cross-filtering • DAX Fundamentals – Learn DAX syntax, structure, and its role in Power BI modelling • Calculated Elements – Build calculated columns, measures, and tables using DAX • DAX Functions & Contexts – Use row/filter context, logical, text, iterator, and time intelligence functions • Advanced DAX Techniques – Implement cumulative totals, rankings, performance tuning, and best practices

Data Visualization with Analytics(Report View) • Visualization Fundamentals – Power BI visuals overview, formatting, interactivity, and best practices • Advanced Visual Techniques – Drill-down, drill-through, slicers, filters, tooltips, and hierarchies • Custom & Specialized Visuals – Waterfall, KPI, combo charts, scatter, maps, and creating custom visuals • Navigation & Layout Optimization – Bookmarks, page navigation, selection pane, themes, and templates • Performance & Smart Features – Performance Analyzer, Power BI Q&A, syncing slicers, and conditional formatting

Power BI Service (Cloud), Q & A, and Data Insights • Power BI Service Overview – Workspaces, dashboards, reports, and apps • Dashboard & Report Management – Creation, customization, sharing, and subscriptions • Natural Language & Quick Insights – Power Q&A, custom questions, and quick insights • Collaboration & Security – Usage stats, row-level security, and collaborative features

Advanced Topics • Power BI Settings, Administration, and Direct Connectivity • Demo of data flow • Demo of deployment pipelines • Demo of incremental load of data in Power BI

SQL for Data Analytics

Excel for Data Analytics

Data Entry & Formatting Tables, ranges, data types (number, text, date) ▪ Basic Formulas SUM, AVERAGE, MIN, MAX, COUNT, IF • Sorting & Filtering AutoFilter, Custom Sort, multi-level sorting • Conditional Formatting Highlight duplicates, values above/below average, data bars, colour scales • Charts & Visualizations Column, Line, Pie, and Bar charts for trend and categorical analysis

PivotTables & Pivot Charts Summarize large datasets, explore patterns by categories • Lookup & Reference Functions VLOOKUP, XLOOKUP, INDEX + MATCH • Text Functions for Cleaning TRIM, LEFT, RIGHT, MID, CONCAT, TEXTSPLIT • Date/Time Analysis TODAY, DATEDIF, YEAR, MONTH, EOMONTH • Data Validation & Cleaning Remove duplicates, handle blanks and errors (IFERROR, ISBLANK) • Dashboards (Intro) Combine visuals, slicers, charts into a summary view