This course finally made pivot tables click for me in a way years of using Excel at work never did. The transition into Power BI feels smooth because it builds on the same data cleaning habits taught in the Excel section. I walked away able to build a dashboard I'd actually be comfortable presenting to management.
Data Analysis with Excel and Power BI for Business Analysts
Transform raw data into actionable business insights using modern Excel formulas, Power Query, and interactive Power BI dashboards.
-
💬
AI instructor
Ask about any lesson and get a clear answer instantly, anytime. -
🕐
Start anytime
No schedules or deadlines — learn at your own pace, whenever suits you. -
🌐
In English
Lessons, tasks and certificate — all fully in your language.
About this course
In today's data-driven business world, the ability to quickly turn raw numbers into clear, actionable insights is a critical skill for analysts and controllers. This text-based course guides you through the foundational concepts of data analysis, bridging the gap between spreadsheet management and modern business intelligence.\n\nYou will start with the absolute basics of data structures and progress to building robust data models. By reading detailed explanations and working through practical text-based exercises, you will learn how to clean messy datasets, perform complex calculations, and present your findings effectively.\n\nWhat you'll learn:\n- Understand core data analysis concepts, terminology, and the data lifecycle\n- Clean and transform unstructured data using Power Query in both Excel and Power BI\n- Write modern Excel formulas, including dynamic arrays and advanced lookup functions\n- Build relational data models and write basic DAX measures for key business metrics\n- Design clear, interactive dashboards in Power BI to highlight key performance indicators\n- Apply analytical frameworks to solve real-world business and financial scenarios\n\nThe course begins with essential definitions and data preparation techniques before moving into advanced Excel functions. You will then transition to Power BI, learning how to connect data sources, model relationships, and build reports entirely through written guides and step-by-step conceptual walkthroughs.\n\nThis course is designed for beginners, aspiring business analysts, and financial controllers who want to upgrade their skills. No prior experience with Power BI or advanced Excel is required.\n\nStart reading today to unlock the power of your business data and elevate your reporting capabilities.
Course contents
6 modules · 30 lessons · 3h
1
Foundations of Data Analysis
Understand the fundamental concepts, terminology, and frameworks used by business analysts.
- The Role of a Business Analyst
Introduction to how data analysis drives business decisions and the core mindset of an analyst.6 min - Essential Data Terminology
Defining key terms like qualitative vs. quantitative data, variables, and observations.6 min - The Data Lifecycle Explained
Walking through the stages of data from collection and cleaning to analysis and visualization.6 min - Understanding Data Structures
Learning the difference between flat files, structured tables, and unstructured data.6 min - Analytical Frameworks for Business
Introduction to frameworks like SWOT and Root Cause Analysis in the context of data.6 min
2
Data Preparation with Power Query
Learn to clean and transform messy data in both Excel and Power BI.
- Intro to Power Query in Excel
Navigating the Power Query interface and importing your first dataset.6 min - Basic Transformations
Learning to filter rows, remove columns, and sort data to focus on what matters.6 min - Cleaning Messy Datasets
Using 'Split Column' and 'Replace Values' to fix unstructured text and errors.6 min - Data Types and Formatting
The importance of setting correct data types (Date, Currency, Text) for analysis.6 min - Power Query in Power BI
Applying transformation skills within the Power BI Desktop environment.6 min
3
Modern Excel for Analysts
Master advanced formulas and dynamic arrays to automate spreadsheet reporting.
- Introduction to Dynamic Arrays
Understanding the 'Spill' behavior and how modern Excel handles multiple values.6 min - The UNIQUE and SORT Functions
Using dynamic array functions to create self-updating lists and rankings.6 min - Advanced Lookups with XLOOKUP
Replacing VLOOKUP with the more flexible and robust XLOOKUP function.6 min - Logical Functions for Business
Using nested IF, AND, and OR to categorize business data and flag issues.6 min - Multi-Criteria Aggregations
Summarizing data using SUMIFS and COUNTIFS for complex business reporting.6 min
4
Data Modeling and DAX Basics
Build relational models and write basic calculations in Power BI.
- Relational Data Modeling Concepts
Why multiple related tables are better than one giant spreadsheet.6 min - Modeling Relationships
Creating One-to-Many relationships between Fact and Dimension tables.6 min - Connecting Data Sources
Linking Power BI to Excel files, CSVs, and web-based data sources.6 min - Intro to DAX: Columns vs. Measures
Understanding when to use Calculated Columns and when to use Measures.6 min - Your First DAX Measures
Writing basic aggregation measures using SUM, AVERAGE, and COUNT.6 min - Calculating Key Business Metrics
Creating DAX measures for Gross Margin, Profit, and Year-over-Year growth.6 min
5
Interactive Dashboards in Power BI
Design professional visuals and interactive reports to present findings.
- Power BI Report Canvas
Navigating the visualization pane and report view interface.6 min - Choosing the Right Visuals
Selecting between bar charts, line graphs, and pie charts for different data stories.6 min - Highlighting KPIs with Cards
Using Card and Multi-row Card visuals to make key metrics stand out.6 min - Adding Interactivity with Slicers
Allowing users to filter report data dynamically using slicers and filters.6 min - Principles of Dashboard Design
Layout and color theory basics for creating clear, professional dashboards.6 min
6
Business Scenarios and Final Reporting
Apply all skills to solve real-world problems and finalize a business report.
- Financial Scenario Analysis
Applying analytical frameworks to a monthly financial performance review.6 min - Solving Business Problems with Data
Using your data model to identify trends and anomalies in sales performance.6 min - Data Storytelling for Stakeholders
Structuring a narrative that explains the 'why' behind the numbers.6 min - Finalizing and Building the Report
Putting all elements together into a cohesive, multi-page business report.6 min
Final project
The Executive Sales Performance Dashboard
You will take a messy CSV file of raw sales data, clean it in Power Query, build a relational model with a Date table, and create a 3-page interactive Power BI dashboard.
What you'll get
-
📜
Certificate of completion
Add it to your LinkedIn profile -
💬
Personal AI tutor
Stuck on a lesson? Ask your built-in tutor anything, any time. -
🎧
Audio version included
Learn on the go — no screen needed -
♾️
Lifetime access
Come back anytime, no expiry -
📱
Phone or computer
Works anywhere, any device -
💸
14-day refund
No questions asked -
⚡
Short & focused
3h of practical content
Certificate of completion
Every course you complete on PickAClass issues a credential like this — original, with its own code, verifiable by URL, and detailed about what was actually demonstrated.
P
PickAClass
Skills profile · verifiable
Document
Certificate of Mastery
This certifies that
Name Surname
has successfully demonstrated mastery of
Data Analysis with Excel and Power BI for Business Analysts
Skills demonstrated
✓
Behavioral pattern analysis
Foundational
1.2 hrs
✓
Decision-architecture frameworks
Proficient
1.4 hrs
✓
A/B test design
Proficient
1.7 hrs
✓
Behavioral copywriting
Advanced
1.9 hrs
P
PickAClass — Name Surname
Data Analysis with Excel and Power BI for Business Analysts
Page 2 of 2
Performance detail
Coursework summary
Lessons completed
14 / 14
Practice questions
26 / 28
Assignments submitted
4 (avg 4.5 / 5)
Capstone project
Reviewed — 4.6 / 5
Total practice
6.2 hrs
Performance benchmark
Cohort rank
Top 12% of 1,625
Time to completion
11 days (median: 22)
Mastery score
91 / 100
Practice-question score
94%
Skill verification
Verified Skill Path
Reviews (9)
A parte de tabelas dinâmicas junto com Power BI mudou completamente a forma como eu monto meus relatórios no trabalho.
Excelの関数からPower BIでの可視化まで流れがつながっていて分かりやすかったですが、ダッシュボード作成の部分はもう少し丁寧な説明が欲しかったです。
Sebagai analis bisnis, materi ini benar-benar mengubah cara saya bekerja dengan data. Dulu saya butuh berjam-jam membersihkan data manual, tapi setelah belajar Power Query, prosesnya jadi otomatis dan rapi. Bagian dashboard Power BI paling saya suka karena akhirnya saya bisa menyajikan angka mentah menjadi insight yang gampang dipahami atasan. Rumus Excel modern seperti XLOOKUP juga dijelaskan dengan contoh nyata. Sangat direkomendasikan untuk siapa pun yang ingin presentasi datanya lebih meyakinkan.
I came into this with decent Excel skills but almost no exposure to Power BI, and the course does a great job bridging the two. The early modules on cleaning messy datasets with formulas like INDEX/MATCH and pivot tables were a solid refresher, and then it builds naturally into building actual dashboards in Power BI. What I appreciated most was that every example uses a realistic messy dataset instead of clean textbook numbers, so the techniques actually transfer to real reports. By the end I put together a sales dashboard for my team that would have taken me days to figure out on my own before this.
Mình làm việc với Excel khá lâu nhưng toàn dùng công thức cơ bản, học xong khóa này mới thấy mình bỏ lỡ nhiều thứ hay ho như hàm INDEX MATCH hay cách xử lý dữ liệu lộn xộn cho gọn gàng. Phần chuyển sang Power BI được sắp xếp rất tự nhiên, không bị rời rạc với phần Excel trước đó. Điểm mình thích nhất là dữ liệu ví dụ trong bài khá thực tế, không phải kiểu số liệu đẹp sẵn như trong sách giáo khoa, nên áp dụng vào công việc thực tế dễ hơn nhiều. Sau khóa học mình đã tự làm được một dashboard báo cáo doanh số cho phòng mình mà trước đây phải nhờ người khác làm hộ. Cảm giác tự tin hơn hẳn khi phải làm việc với số liệu lớn.
ปกติใช้ Excel แค่พื้นฐาน พอมาเรียนคอร์สนี้เข้าใจสูตรที่ซับซ้อนขึ้นเยอะ โดยเฉพาะการทำ Pivot Table กับข้อมูลที่ยุ่งเหยิงจริงๆ ไม่ใช่ตัวอย่างสวยๆ ที่จัดมาแล้ว ส่วนของ Power BI ก็สอนตั้งแต่การเชื่อมข้อมูลไปจนถึงทำแดชบอร์ดที่ดูเป็นมืออาชีพ ชอบที่แต่ละบทมีแบบฝึกหัดให้ลองทำตามจริง ไม่ใช่แค่ดูอาจารย์ทำ พอเรียนจบเอาไปปรับใช้กับรายงานยอดขายที่บริษัทได้ทันที รู้สึกว่ามั่นใจเรื่องการวิเคราะห์ข้อมูลมากขึ้นเยอะ
สอนสูตร Excel ได้ละเอียดดีมาก แต่ส่วน Power BI อยากให้มีตัวอย่างเคสธุรกิจเพิ่มอีกหน่อย
Les formules Excel avancées expliquées ici m'ont vraiment débloqué au travail, même si j'aurais aimé un peu plus de temps sur Power BI.
Learners also took
🔥 In demand
🎓 With certificate
Modern Data Analyst: SQL, Python, Power BI, and AI Tools
Certificate
Hands-on
800 zł
→
💼 Job-ready
🎓 With certificate
Financial Reporting in Power BI: Build Professional Statements
Certificate
Hands-on
760 zł
→
⚡ Best to start
🎓 With certificate
Advanced Data Analytics with Power BI
Certificate
Hands-on
780 zł
→
🏆 Most popular
🎓 With certificate
Applied Power BI: Building Data Dashboards and Reports
Certificate
Hands-on
270 zł
→
Frequently asked
What do I need to take this course? +
Just a phone or computer with internet. No installs, no special hardware.
How do I pay? +
By card via Stripe. We don’t store card details — Stripe handles them securely.
Can I get a refund? +
Yes — full refund within 14 days, no questions asked.
How long will I have access? +
Forever. Once you purchase, the course is yours to revisit anytime.
Will I get a certificate? +
Yes. On completion you'll receive a certificate you can add to your LinkedIn profile.
Built for learners in
Tech
Design
Finance
Marketing
Healthcare
Education
Hospitality
Manufacturing
10
Get 10 courses a month
Members get 10 courses of their choice every month for 0 zł. No per-course charges — you pay only the subscription.
1.300 zł / per month
- ✓ 10 courses every month
- ✓ Cancel anytime
Renews monthly. Unused courses expire at the end of each billing month.