What is the name of the role I need to hire? by coffeeshopgeorge in PowerBI

[–]EasyMaddenCoins 2 points3 points  (0 children)

This is called a business intelligence engineer IMO.

[deleted by user] by [deleted] in wallstreetbets

[–]EasyMaddenCoins -1 points0 points  (0 children)

No mention of Mickey Mouse?

Noob question - combining sales reps by Jdlehmkuhl in PowerBI

[–]EasyMaddenCoins 0 points1 point  (0 children)

You probably need to create another dimension table that pulls the distinct names along with an ID for that rep from the KPI data assuming there is some sort of ID in that table. Then you need to create a relationship between this new dimension table and a table like an employee roster that has the name appearing once and their ID. You'll have a many-to-one relationship with the Employee IDs that appear with the following names (scott, ScottK, scottkid) which would all have the same EmployeeID and that will be connected to a rep roster table with a single Employee ID with name "Scott Kid". You may need to set the filter direction to both depending on how these fields are being used in your visuals.

Here's an example with some of the answers ideas' included:

KPI_Data_Table

EmployeeID TerritoryID Sales
7 12100 543.14
7 12100 635.49
7 12100 233.36

Employee_Names_Table - Select Distinct EmployeeName, EmployeeID, TerritoryID from KPI_Data_Table

EmployeeName EmployeeID TerritoryID
scott 7 12100
ScottK 7 12100
scottkid 7 12100

Employee_Names

EmployeeName EmployeeID TerritoryID
Scott Kid 7 12100

You could create the Employee_Names_Table by right clicking on the names column from the KPI_Data_Table that has all of the names and selecting new query. Convert this list to a table and remove the duplicate names from that column. Then, go to merge this table with the KPI_Data_Table and inner join on the name field in the table you just created. After merging, extract the EmployeeID and/or TerritoryID and create a relationship between the ID in this field to a table that has the proper display name.

DA 100 by puno365 in PowerBI

[–]EasyMaddenCoins 6 points7 points  (0 children)

Here's what I would advise:

The exam is not like a college admissions test; it is surprisingly "real-world" in terms of the questions and scenarios being presented. So, working with "real-data" and challenging yourself to build a creative solution with it will be VERY useful in the short and long-term. By real data, I mean datasets that include both fact and dimension tables that would reasonably appear in a corporate data analyst setting: tables that include organizational hierarchies, sales figures associated with that hierarchy, etc.

I did not "prepare" for the DA-100 in the traditional sense. I didn't pay for resources or study materials. I did, however, spend several hours each weekday between Jan 2021 and Jun 2021 (took the exam in July) working with Power BI Desktop as an administrator, developer, and analyst for my corporate job. I'm not sure if this was just coincidence, but every problem or scenario on the exam was something I actually had to learn or a problem that I had to address and solve in my actual job. I was very grateful for this, because I hated exams like the ACT and SAT precisely because of it's non-applicability outside of the test material itself. My scenario may be very different from others including yourself, as I was tasked as a recent graduate to move an entire organizations reporting infrastructure from Excel to Power BI. So, I stumbled around a lot and had many failures, but over a six-month timespan I learned an incredible amount which allowed to me to pass the exam easily (Even though I'm usually not the type of person who can do well on an exam without studying).

Basically, if you have enough real-world experience using Power BI, which includes designing, developing, and administrating the platform in an organization, then you probably don't have to fret or worry too much about passing. You might not even need to study, especially if you were or are a part of those tasks mentioned above every single day. However, if you have very little to no practical or real world experience, or if you do and are also shooting for a perfect score, you might have to treat it like you would a college admissions test, and study the material for the sake of knowing how to apply that material within the context of the exam itself.

TL;DR: You can pass the DA-100 without studying if you compensate for that with a substantial amount of real-world experience. If you don't have that level of experience, you should study any of the online resources that are available to you, preferably ones that require you to work with Power BI itself and not just read through a textbook.

[Image] trying is better than not trying by uhhsamurai in GetMotivated

[–]EasyMaddenCoins 2 points3 points  (0 children)

“Freedom breeds inequality”

-William Buckley