Excel & Power BI for Data Professionals: Complete Analytics

Name: Excel & Power BI for Data Professionals: Complete Analytics
Rating: 4.2 (4 reviews)

Master Excel formulas, Power BI dashboards, and advanced DAX for comprehensive business intelligence.

Created byLearnsector LLP, Navya Kannan

Last updated 6/2026

English

What you'll learn

Create and manage complex spreadsheets using essential Excel formulas, functions, and formatting techniques for data hygiene.
Analyze large datasets effectively using Excel PivotTables, sorting, filtering, and smart analysis tools to derive initial insights.
Develop interactive, professional-grade dashboards in Microsoft Power BI Desktop and deploy them to the Power BI Service.
Transform and clean raw data from multiple sources using Power Query to prepare robust data models for analysis.
Construct advanced data models by defining relationships between tables and adhering to industry-standard schema best practices.
Write and implement Data Analysis Expressions (DAX) including calculated columns, measures, and time-intelligence functions.
Utilize logical, text, and date-time DAX functions to solve complex business problems and automate reporting logic.
Publish and share secure reports within an organization, understanding the governance of Power BI workspaces.

Course content

25 sections • 132 lectures • 12h 33m total length

Introduction to Excel1:49
In this lecture, you'll delve into Excel, understanding what it is and why it's vital. Get acquainted with Excel's interface and pick up useful navigation tips to get started efficiently.
What is Excel?1:59
This lecture provides an introduction to Microsoft Excel, explaining its purpose, functions, and significance in data management and analysis.
Why is Excel important?2:46
Delve into the importance of Excel in various professional and personal contexts. Learn why Excel is a crucial tool for data organization and analysis.
Excel interface and navigation6:31
Get to know the Excel interface, including its menus, ribbons, and toolbars. Understand the layout and structure of the Excel application.
Worksheet navigation4:25
Learn how to efficiently navigate through Excel worksheets. Discover techniques for moving between sheets and managing multiple worksheets.
Excel Workbook3:47
Explore the concept of an Excel workbook, understanding how it's structured and how it houses multiple worksheets. Gain insights into managing workbooks effectively.
Navigation Tips2:42
Master useful navigation tips and shortcuts in Excel. These tricks will enhance your efficiency when working with spreadsheets, making your tasks smoother and faster.

Formulas and Cell References9:40
Unlock the power of Excel by grasping the essentials of formulas and cell references. This fundamental knowledge lays the groundwork for effective data manipulation and calculation in spreadsheets.
Ways to find Excel function4:13
Discover various methods to efficiently locate and utilize Excel functions. These tools will empower you to perform complex calculations and automate tasks within your spreadsheets.
Common Excel functions12:11
Explore the world of common Excel functions, from SUM and AVERAGE to COUNT and IF. Learn how to apply these functions to streamline your data analysis and management.

Sort and filter data5:24
Dive into data organization as you master the art of sorting and filtering in Excel. These skills will help you make sense of large datasets and extract valuable insights.
Pivot tables6:01
Pivot tables are a powerful tool for data analysis. In this lecture, you'll learn how to create and use pivot tables to summarize and visualize data, making complex data more understandable.
Charts and graph9:49
Unleash your creativity as you discover how to create, customize, and use charts and graphs in Excel. This skill is crucial for visually presenting data and drawing valuable conclusions.
How to use macros7:41
Explore the world of macros and learn how to automate repetitive tasks in Excel. This lecture will boost your efficiency and productivity when working with spreadsheets.

How to use VBA to create your own functions5:38
Take your Excel skills to the next level by delving into VBA (Visual Basic for Applications). Learn how to create custom functions, opening up endless possibilities for data manipulation and automation.
How to create custom templates12:57
Discover the art of creating custom templates in Excel. This skill will save you time and ensure consistency in your document creation and data management.
Share and collaborate on Excel4:54
Learn how to share and collaborate on Excel projects with colleagues or teammates. These skills are essential for effective teamwork and project management.

Introduction to Business Intelligence5:00
In this lecture, you will get an introduction to Microsoft Power BI and also recognize the five Whats that Power BI helps us answer.
The Relation Between Business Intelligence and Data Warehouse4:10
In this lecture, you will understand what an ETL (Extract, Transform, Load) Process is and the relationship between Business Intelligence and data warehouse.
Power BI Overview & Installation3:24
In this lecture, you will be introduced to the different components of Power BI and then taken through step-by-step on how to install Power BI desktop.
Introduction Power BI Desktop9:54
In this lecture, you will be taken through the Power BI Interface and understand the Power BI settings.
Connecting with Data4:03
In this lecture, you will be given a brief introduction to connecting data and also explore the different file formats and different data sources that can be connected to Power BI.

Downloadable resources for Hands-on Excercise0:05
Connect to Excel in Power BI Desktop5:22
In this lecture, you will learn how to connect Excel File to Power BI desktop
Connect to CSV files in Power BI Desktop3:04
In this lecture, you will learn how to connect CSV or Text File to Power BI desktop
Connect to SQL Server in Power BI Desktop1:49
In this lecture, you will learn how to connect SQL Server to Power BI desktop
Connect to a Web page from Power BI Desktop4:04
In this lecture, you will learn how to connect data on web to Power BI desktop
Enter data directly into Power BI Desktop3:13
In this lecture, you will learn how to manually enter data into Power BI desktop

Introduction to Power Query2:11
In this section, we'll look at how to transform data using Power Query. It is very important to transform or edit your data before actually loading it to your Power BI to create an effective report and visualization.
Query Editor12:49
In this lecture, we will look into the working of a query editor.
Data formatting Troubleshoot- Option 20:31
Data formatting Troubleshoot - Option 1 (recommended)0:32
Text Transformations18:02
In this lecture, we will look into how to perform text transformation on a column in Query Editor.
Number Column Calculations5:22
In this lecture, we will look into how to perform number calculations on a column in Power Query Editor.
Data Type6:57
In this lecture, we will look into how to identify the data types and how to change from one data type to another.
Date and Time Calculations13:28
In this lecture, we will look into the Date transformation, group by, and conditional column options in Power Query.
Append Queries and Merge Queries20:00
In this lecture, we will look at how to append queries, merge queries, and to combine multiple workbooks using folder options.
Data Source Settings and Refresh Setings7:08
In this lecture, we will look at features of Data source settings and Refresh settings options in Power BI.
Power Query Data Formatting8:26
In this lecture, we will look into Data formatting which includes Date formatting, Currency formatting, and presenting our data in the form of a map.
Hierarchy Creation in PowerBI4:00
In this lecture, we will look Hierarchy creation and its levels.

Data Modeling Introduction3:29
In this lecture, let's do some analysis on data present in the tables to create a Data Model.
Primary key vs Foreign Key2:54
In this lecture, we will look primary and foreign key concepts.
Relationship build, Edit, Delete8:54
In this lecture, we will look at how to create, edit, and delete a relationship.
Snowflake Scheme4:33
In this lecture, we will look into Snowflakes scheme.
Active vs In Active relationship4:09
In this lecture, we will look into how to activate and inactivate relationships in Power BI.
Relationship Primary key with multiple foreign keys from different data9:50
In this lecture, we will look into how to create relationships where a primary key is related to multiple foreign keys, create reports and dashboards.

Requirements

Access to a computer running Microsoft Windows (Power BI Desktop is Windows-only). Microsoft Excel installed (Office 365, 2019, or 2021 recommended). No prior data analysis experience is required; the course begins with fundamentals.

Description

In the current business landscape of 2024–2025, data literacy is no longer a niche skill but a fundamental requirement for operational excellence. Organizations rely on professionals who can not only manage data in spreadsheets but also transform raw metrics into actionable, scalable business intelligence. This master course, Excel & Power BI for Data Professionals: Complete Analytics, is designed to bridge the gap between traditional spreadsheet management and modern data visualization, offering a seamless transition from Microsoft Excel to the robust ecosystem of Microsoft Power BI.

Strategic Learning Value This curriculum integrates three distinct competencies into a single, cohesive learning path. It begins by establishing a rigorous foundation in Microsoft Excel, the global standard for data entry and preliminary analysis. Learners will master essential syntax, formatting, and PivotTables, ensuring data hygiene before moving to complex tasks. The course then transitions to Microsoft Power BI, equipping participants with the skills to connect disparate data sources, utilize Power Query for transformation, and deploy interactive dashboards to the cloud. Finally, the instruction deepens with a focused module on Data Analysis Expressions (DAX), the formula language that drives advanced calculation and logic in Power BI.

Course Structure and Scope The training is structured to mirror a real-world data analyst’s workflow:

Excel Fundamentals: Mastering the interface, essential formulas, data validation, and introductory automation tools.
Power BI Ecosystem: Navigating Power BI Desktop and Service, managing datasets, and understanding the principles of effective data visualization.
Advanced Analytics with DAX: Moving beyond simple aggregations to create calculated columns, measures, and complex time-intelligence logic (e.g., Year-over-Year growth).

Professional Application By the conclusion of this program, learners will possess the technical capability to manage the entire data lifecycle—from raw extraction in Excel to published, decision-ready reports in Power BI. This skillset is critical for roles such as Business Analyst, Data Specialist, Finance Manager, and Operations Lead. The content is delivered with a focus on accuracy, efficiency, and best practices suitable for corporate environments.

Instructor Credibility and Updates Developed byNavya Kannan with extensive experience in enterprise reporting, this course reflects the latest software versions and features available in the Microsoft ecosystem. The methodology prioritizes hands-on application over theory, ensuring that every concept taught can be immediately applied to organizational challenges.

Who this course is for:

Business Analysts and Reporting Professionals seeking to modernize their skills from spreadsheets to BI platforms.
Financial Analysts and Accountants who need to automate reporting and visualize financial data.
Operations Managers and Administrative professionals looking to improve efficiency in data handling.
Aspiring Data Analysts preparing for a career transition into business intelligence.

Excel & Power BI for Data Professionals: Complete Analytics

What you'll learn

Explore related topics

Course content

Microsoft Excel Essentials7 lectures • 24min

Formulas and Functions3 lectures • 26min

Data Analysis4 lectures • 29min

Advanced Features3 lectures • 23min

Hands-On Demo1 lecture • 18min

Excel Assignment1 lecture • 1min

Microsoft Power BI Introduction5 lectures • 27min

Connecting Power BI with Different Data sources6 lectures • 18min

Power Query for Data Transformation12 lectures • 1hr 39min

Power BI Data Modeling – Relationship View & PowerPivot6 lectures • 34min

Requirements

Description

Who this course is for: