Udemybeginneren

PRACTICAL DATA ANALYTICS USING EXCEL VBA & POWER BI WITH DAX

Master Power BI: M language, DAX, statistics & VBA. Analyze data with Excel & a real-world case study. Boost your data skills!

4.1(4)
30students
3h 11m
Certificate
Alida Herbst
Alida HerbstLecturer

Course Content

PRACTICAL DATA ANALYTICS USING EXCEL VBA & POWER BI WITH DAX is a beginner-level Udemy course taught by Alida Herbst. It runs 3h 11m, is taught in English, and includes a certificate of completion. Learners rate it 4.1 out of 5 from 4 reviews, with 30 students enrolled. It is a paid course, first published July 2022.

Learn Data Analysis with Power BI: A Practical Guide for Beginners

This comprehensive course equips you with the skills to confidently enter the data analysis field. Gain practical experience and the essential theoretical knowledge to become a proficient data analyst, ready to contribute immediately. We focus on real-world application, combining core concepts with hands-on techniques.

Key Skills You'll Master:

  • Data Analysis Fundamentals: Understand the principles and terminology of data analysis.
  • Excel & VBA for Data Preprocessing: Learn to manipulate and prepare data using Microsoft Excel and Visual Basic for Applications (VBA). Automate data cleaning and transformation tasks.
  • Power BI for Business Intelligence: Master Microsoft Power BI, a powerful business intelligence tool, for data mining, process analysis, performance benchmarking, and descriptive analytics.
  • Data Visualization: Create compelling and insightful visuals, including slicers, to effectively communicate data findings.
  • M-Language & DAX: Understand and utilize both M-language (Power Query) and DAX (Data Analysis Expressions) – the core languages of Power BI – and learn when to apply each.
  • Statistical Analysis: Apply basic statistical functions and exploratory data analysis (EDA) techniques to uncover trends and patterns in your data.

Course Highlights:

  • Practical, Hands-On Approach: Learn by doing with a real-world case study using global GDP data from 1960-2020.
  • Microsoft Software: Utilizes readily available Microsoft Office tools (Excel, VBA, Power BI) and free Power BI software.
  • Step-by-Step Learning: The course is structured into 9 chapters, each building upon the previous one.
  • Real-World Case Study: Analyze GDP data for over 266 countries, focusing on comparative analysis of BRICS nations (Brazil, Russia, India, China, South Africa).
  • Visualizations: Learn to create impactful visuals like line graphs, box plots, and scatter plots, enhanced with interactive slicers.

Course Outline:

  • Chapter 1: Excel & VBA Basics: Introduction to programming concepts, syntax, expressions, and VBA fundamentals (variables, loops, message boxes). Learn to enable the Developer tab in Excel.
  • Chapter 2: Data Import & VBA Pre-processing: Import data from webpages into Excel. Use VBA with ActiveX command boxes to format data for optimal import into Power BI. Introduction to the GDP/population case study.
  • Chapter 3: Power BI - Overview: Understand business intelligence (BI) concepts, strategies, tools, and trends. Explore Power BI's parts, concepts, and dashboard features. Learn about the Report, Data, and Model views.
  • Chapter 4: Power BI Visuals & Data Modeling: Master standard Power BI visuals and best practices. Import the case study into Power BI (video demonstration). Utilize Power Query Editor and M-language to create new fields. Learn how to link tables within Power BI.
  • Chapter 5: M-Language vs. DAX: Deep dive into the M-language (Power Query) and DAX (Data Analysis Expressions). Explore the Power Query interface and understand the differences between M and DAX – when to use each.
  • Chapter 6: M-Language Calculations: Learn M-language syntax and key functions. Demonstrations of M-language calculations applied to the case study (video).
  • Chapter 7: DAX Calculations: Explore DAX fundamentals, including measures, columns, tables, and row-level security. Learn and demonstrate DAX functions and statements (video).
  • Chapter 8: Basic Statistics & Visualizations: Apply exploratory data analysis (EDA) techniques, including measures of central tendency, dispersion, and shape properties (kurtosis, skewness). Learn to format Power BI visuals for clarity and impact.
  • Chapter 9: Comparative Analysis with Slicers: Perform comparative analysis of BRICS countries' GDP growth using box plots and line graphs. Utilize slicers to dynamically filter data by country and year (video demonstrations).

Who is this course for?

  • Individuals seeking a career in data analysis.
  • Professionals looking to enhance their data skills.
  • Anyone wanting to learn how to use Power BI for data visualization and analysis.
$ whoami — the devs behind tutorialsearch.io

Want AI in your product? Hire the team behind TutorialSearch.io

LLM features, RAG, agents and automation wired into a real product — built by the devs who shipped this site.

5.0
53m
beginner
pluralsight
5.0
1h 29m
beginner
pluralsight
5.0(391)
1h 8m
all
skillshare