Basic ETL Exercise in Power BI

-

 Hi,

Please watch this video before doing the exercise.

ETL-2 video link


Download the data from here: Github link

Task

1. Get the excel file into the Power BI
2. Launch Power Query Editor
3. Check all the columns are properly named (if not, name it properly)
4. Remove the null values (Rows)
5. Delete the irrelevant columns
6. Add a new table with simple columns.


If you face any issues, please comment. 

Comments

Post a Comment

Popular posts from this blog

Learning Path: Business Central Technical Consultant | Dynamics 365 Business Central

-
Image
Basic Concepts in Business Central The below image shows the mind map of Business Central Basic concepts to learn. Learn the below concepts.  Basic Introduction to BC Hand-on Download & install Objects in AL programming Table Table Extension Page Page Extension Codeunit Query Report Deep dive into AL programming Intermediate Functions Custom Functions Filtering Inter-object communication Deep dive into AL programming Report Extension Advanced XMLPort Web-services Efficient designing Role-center Report Customization Projects and Exercises Simple projects Projects with functions Exercises with XML-Port Exercises for forecasting
Read more

Top Business Central Interview Questions for Technical Consultants: Tips and Strategies for Nailing Your Interview

-
Image
Introduction As Business Central's reputation as a robust ERP solution grows, so has the demand for qualified technical consultants. Therefore, many businesses are trying to recruit seasoned technical consultants. In order to succeed in your interview for a position as a Business Central technical consultant, you should study some sample questions and practice answering them. This blog post is intended to help technical consultants get ready for the most typical Business Central interview questions they'll be asked during an interview. Whether you're an experienced pro or just starting out, this book will equip you with the knowledge and self-assurance to ace any Business Central-related interview. Disclaimer Certainly! The blog's responses will draw on the collective expertise of Business Central's technical experts rather than any one consultant in particular. Although these are typical interview questions for a Business Central technical consultant position, it i
Read more

Table in Business Central

-
Image
The table in Business Central Introduction The table, which functions as both a data definition and a data container (a table's contents), is distinct from the data. The table specification (container) includes descriptions of data identification, data structure, validation processes, storage, and retrieval. Due to its innate architecture, changing this definition would require the assistance of a programmer. The information in the data is dynamic and derived from user behaviour. We see that the data is explicitly referred outside of the table as a definition of structure in the permissions setup data. Table Tables are the fundamental data storage units in Dynamics 365 Business Central.  The data will finally wind up in a table, regardless of whether a person inputs their information via a web service or by swiping their finger on a mobile app. The framework of a table is made up of four main parts: General information about the table, such as its kind, is included in the first sec
Read more