PRACTICAL DATA ANALYTICS USING EXCEL VBA & POWER BI WITH DAX

PRACTICAL DATA ANALYTICS USING EXCEL VBA & POWER BI WITH DAX, available at $59.99, has an average rating of 4.5, with 14 lectures, 1 quizzes, based on 4 reviews, and has 26 subscribers.

You will learn about Basics of the programming language for Excel called VBA How to import data into Excel and data pre-processing using VBA What, why and when to use power BI along with its components How to import data into Power BI from Excel and how to link tables and create new fields/variables Everything about DAX (power query) and the M-Language and the differences and when to use it How to practically implement DAX calculations for columns and measures How to practically implement M-Language calculations About the different visualizations in Power BI and when to use them and how to format them How to do comparative analyses using the slicer in visualizations Create columns, quick measures and measures using DAX in Power BI Know how and where to use DAX and M-Language in Power Business Intelligence Transform raw data in Excel using VBA into correct format for importing into Power BI Create awesome easy to understand interactive visuals by using the power BI M-language in power query and DAX functions This course is ideal for individuals who are Beginner or Anyone with a passion to learn working with data, programming and creating awesome dashboards. or If you would like to become a data analyst, data scientist or data engineer or Anyone who would like to help businesses avoid the problem of "garbage in and garbage" out, resulting from inaccurate or insufficient data analysis. or Become an expert in data mining, process analysis, performance benchmarking and descriptive analytics. or Learn to develop easy-to-digest reports, performance measures, and trends that inform management decisions. or Know how to build amazing, professional, easy to understand and high quality business intelligence reports from the ground up or Know how and where to use DAX and M-Language in Power Business Intelligence or Create columns, quick measures and measures using DAX in Power BI or Learn how to transform raw data in Excel using VBA into correct format for importing into Power BI or Create awesome easy to understand interactive visuals by using the power BI M-language in power query and DAX functions It is particularly useful for Beginner or Anyone with a passion to learn working with data, programming and creating awesome dashboards. or If you would like to become a data analyst, data scientist or data engineer or Anyone who would like to help businesses avoid the problem of "garbage in and garbage" out, resulting from inaccurate or insufficient data analysis. or Become an expert in data mining, process analysis, performance benchmarking and descriptive analytics. or Learn to develop easy-to-digest reports, performance measures, and trends that inform management decisions. or Know how to build amazing, professional, easy to understand and high quality business intelligence reports from the ground up or Know how and where to use DAX and M-Language in Power Business Intelligence or Create columns, quick measures and measures using DAX in Power BI or Learn how to transform raw data in Excel using VBA into correct format for importing into Power BI or Create awesome easy to understand interactive visuals by using the power BI M-language in power query and DAX functions.

Enroll now: PRACTICAL DATA ANALYTICS USING EXCEL VBA & POWER BI WITH DAX

Summary

Title: PRACTICAL DATA ANALYTICS USING EXCEL VBA & POWER BI WITH DAX

Price: $59.99

Average Rating: 4.5

Number of Lectures: 14

Number of Quizzes: 1

Number of Published Lectures: 14

Number of Published Quizzes: 1

Number of Curriculum Items: 26

Number of Published Curriculum Objects: 26

Number of Practice Tests: 1

Number of Published Practice Tests: 1

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Basics of the programming language for Excel called VBA
How to import data into Excel and data pre-processing using VBA
What, why and when to use power BI along with its components
How to import data into Power BI from Excel and how to link tables and create new fields/variables
Everything about DAX (power query) and the M-Language and the differences and when to use it
How to practically implement DAX calculations for columns and measures
How to practically implement M-Language calculations
About the different visualizations in Power BI and when to use them and how to format them
How to do comparative analyses using the slicer in visualizations
Create columns, quick measures and measures using DAX in Power BI
Know how and where to use DAX and M-Language in Power Business Intelligence
Transform raw data in Excel using VBA into correct format for importing into Power BI
Create awesome easy to understand interactive visuals by using the power BI M-language in power query and DAX functions

Who Should Attend

Beginner
Anyone with a passion to learn working with data, programming and creating awesome dashboards.
If you would like to become a data analyst, data scientist or data engineer
Anyone who would like to help businesses avoid the problem of "garbage in and garbage" out, resulting from inaccurate or insufficient data analysis.
Become an expert in data mining, process analysis, performance benchmarking and descriptive analytics.
Learn to develop easy-to-digest reports, performance measures, and trends that inform management decisions.
Know how to build amazing, professional, easy to understand and high quality business intelligence reports from the ground up
Know how and where to use DAX and M-Language in Power Business Intelligence
Create columns, quick measures and measures using DAX in Power BI
Learn how to transform raw data in Excel using VBA into correct format for importing into Power BI
Create awesome easy to understand interactive visuals by using the power BI M-language in power query and DAX functions

Target Audiences

Beginner
Anyone with a passion to learn working with data, programming and creating awesome dashboards.
If you would like to become a data analyst, data scientist or data engineer
Anyone who would like to help businesses avoid the problem of "garbage in and garbage" out, resulting from inaccurate or insufficient data analysis.
Become an expert in data mining, process analysis, performance benchmarking and descriptive analytics.
Learn to develop easy-to-digest reports, performance measures, and trends that inform management decisions.
Know how to build amazing, professional, easy to understand and high quality business intelligence reports from the ground up
Know how and where to use DAX and M-Language in Power Business Intelligence
Create columns, quick measures and measures using DAX in Power BI
Learn how to transform raw data in Excel using VBA into correct format for importing into Power BI
Create awesome easy to understand interactive visuals by using the power BI M-language in power query and DAX functions

This is the course that will help you walk right into a workplace as a data analyst with some knowledge of programming and working with business intelligence platforms specifically power BI from Microsoft Office. This course has a very practical angle with the theoretical knowledge necessary to become a data analyst hitting the ground running. This course covers some aspects of EXCEL and the programming language VBA which is software packages supplied by Microsoft. Power Business Intelligence (BI) which is free software from Microsoft and helps with data mining, process analysis, performance benchmarking, and descriptive analytics resulting in an increased competitive advantage is taught in this course. also provided for free by Microsoft. You will learn how to populate excel with data from the web and then write a program in VBA to pre-process the data for importing it into a power BI application. The two languages namely M-language and DAX in Power BI are discussed and the differences are pointed out. The case study which includes GDP (Gross Domestic Product) of most countries in the world with data from 1960 to 2020 is used throughout to practically apply all the concepts that are taught. Visuals including the slicer are taught in order to compare different countries with each other. To demonstrate individual as well as comparative analyses the BRICS (Brazil, Russia, India, China and South Africa) are used. The course is divided and presented in 9 chapters. Below a brief description of each chapter.

CHAPTER 1: EXCEL AND VBA BASICS

This chapter will cover the concepts, principles, and terminology of programming languages. What is a syntax and an expression as well as how to develop program solving skills are discussed. A quick overview of the programming language of Microsoft Excel called Visual Basic for Applications (VBA) including declaring variables, message and input boxes, iterative loops, popular statements and benefits are also covered. Data analytics and the different types are also taught. How to make the developer tab visible is explained in this chapter.

CHAPTER 2: IMPORTING DATA AND USING VBA FOR PRE-PROCESSING

The importing of data into EXCEL from a webpage, that will then be used throughout the course to analyse and present the data, is demonstrated. The programming language VBA, with an ActiveX command box, is used to prepare the data in the correct format for importing into the Power BI application of Microsoft. The VBA program makes use of variable declaration, a message box, arrays and iterative loops. The case study using GDP (Gross Domestic Product which is a country’s total economic output) and population for more than 266 countries from 1960 to 2020 obtained from the world bank is introduced.

CHAPTER 3: POWER BI WHERE, WHY AND WHEN

Chapter 3 discusses what is business intelligence (BI), where and why it is used. BI strategies, tools, techniques, trends, software and systems are covered. The software Microsoft power BI parts, concepts and dashboard with its features are discussed. The power BI report, data and model views are covered.

CHAPTER 4: VISUALS, IMPORT, LINKING OF TABLES AND CREATING FIELDS

Standard Power BI visuals and best practices are covered. How to import the case study into power BI is shown in a video. The power BI query is introduced in a video where new fields for the case study are created using the power query editor and M-language. How to link tables are demonstrated.

CHAPTER 5: DAX AND THE M-LANGUAGE

The two languages of Power BI namely the M-language and DAX are discussed. The power query used for the M-language is shown along with its interface. The differences between the M language and DAX are pointed out as well as when to use M, and when do I use DAX.

CHAPTER 6: M-LANGUAGE CALCULATIONS

The key points about power query and the M-Language as well as the M-language syntax is discussed in this chapter. Some of the M-language functions are covered. Calculations using the M-language for the case study is demonstrated in a video.

CHAPTER 7: DAX CALCULATIONS

What DAX is, its key points and importance is discussed. DAX calculations for measures, columns, tables and row-level security is covered. DAX functions and statements are demonstrated. DAX calculations using Case study is done through a video.

CHAPTER 8: BASIC STATISTICS AND VISUALIZATIONS

Exploratory data analysis (EDA) statistical functions including measures of central tendencies and dispersion along with shape properties kurtosis and skewness are discussed. Practical examples of the standard visualizations in power BI are given along with the formatting of the visuals.

CHAPTER 9: COMPARATIVE ANALYSES USING THE SLICER

GDP growth comparative analyses of BRICS countries (Brazil, Russia, India, China, South Africa) is demonstrated through videos. Comparisons for BRICS countries using box plots on GDP per capita is illustrated for any chosen year from 1960 to 2020 . The line graphs, boxplots and scatter visualizations are all done using a slicer for choosing different countries or years.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction to lecturer and Pecunua

Lecture 2: Chapter 0 -Introduction to course and content

Lecture 3: Chapter 1 -Excel and VBA basics

Lecture 4: Chapter 2 Section 1 -Importing data into Excel

Lecture 5: Chapter 2 Section 2 -Pre-processing using VBA application

Lecture 6: Chapter 3 – What, why and when to use Power BI along with its components

Lecture 7: Chapter 4 -Power BI visuals, import, linking tables and creating new variables

Lecture 8: Chapter 5 – DAX and the M-Language, their differences and when to use it

Lecture 9: Chapter 6 Section 1 – Practical implementation of M-Language in Power BI

Lecture 10: Chapter 6 Section 2 – Practical Implementation of the M-language using Power BI

Lecture 11: Chapter 7 – Practical implementation of the DAX language in Power BI

Lecture 12: Chapter 8 Section 1 Basic statistics and visualizations in Power BI

Lecture 13: Chapter 8 Section 2 Basic statistics and visualizations

Lecture 14: Chapter 9 – Comparative analyses using the slicer in visualizations

Instructors

Alida Herbst
Lecturer

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 1 votes
4 stars: 0 votes
5 stars: 3 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu