
Morningstar Business Intelligence interview guide based on one candidate report: a Power BI take-home, a hands-on technical round covering Row-Level Security, and an in-person interpersonal round.
$88K
Avg. Base Comp
$100K
Avg. Total Comp
Not reported
Typical Rounds
Not reported
Process Length
The one Morningstar Business Intelligence Analyst experience we have starts with a Power BI take-home project that the candidate built and submitted before any live interview. The first technical round followed. The interviewer asked the candidate to perform a few steps directly in Power BI, which the candidate read as a check that the tool skill on the resume was real. The same round included a question asking the candidate to explain Row-Level Security. The candidate called this the main technical checkpoint and got through it.
The second round was scheduled by HR and held in person at the office. The candidate describes it as mostly interpersonal rather than technical. HR asked for the candidate's documents at the end, which the candidate took as a good sign. After about two weeks without word and several follow-ups, HR said the candidate had not cleared the round, with no specific feedback.
For preparation, practice building and explaining a Power BI report without leaning on notes, and be able to describe Row-Level Security in plain language. Prepare for conversational, behavioral questions too, since that is where this process ended. This is a single report, so other candidates may see a different sequence or different questions.
Synthesized from 1 candidate report by our editorial team.
Had an interview recently?
Share your experience. Unlock the full guide.
Real interview reports from people who went through the Morningstar process.
The whole process started with a take-home assessment: a Power BI project that I had to build out and submit. Once that was done, I got a first technical round where the interviewer had me walk through a few steps directly in Power BI, mostly to confirm I actually knew the tool and wasn't just listing it on my resume. He also asked me to explain what Row-Level Security is, which I answered and which seemed to be the main technical checkpoint. I got through that round without trouble.
The second round was scheduled by HR and was in person at the office. This one leaned toward interpersonal questions rather than technical ones, and it went well from my side. At the end of that round HR asked for my documents, which I took as a good sign.
After that, things went quiet. Two weeks passed with no word, and I had to follow up several times before HR finally told me I had not cleared the round. No specific feedback was offered. I came away feeling the process had cost me a lot of time and energy for an unclear result, and it was a frustrating way to end an otherwise promising set of interviews.
Prep tip from this candidate
Be ready to demonstrate hands-on Power BI steps and to explain Row-Level Security clearly, since the first technical round focused on both. Also prepare for interpersonal questions in the second round, which was the stage where the process stalled.
Share your own interview experience to unlock all reports, or subscribe for full access.
Sourced from candidate reports and verified by our team.
Topics based on recent interview experiences.
Featured question at Morningstar
How would you find out if an increase in user conversion rates after a new email journey is casual or just part of a wider trend?
| Question | |
|---|---|
| Why Do We Need Time Series Models? | |
| 1000 Sample Classifier | |
| Softmax vs Logistic | |
| Portfolio Platform Architecture | |
| Gradient Descent Calculation | |
| Logistic Regression from Scratch | |
| Search Timeout | |
| Linear vs Logistic Regression | |
| Your Strengths and Weaknesses | |
| 2nd Highest Salary | |
| Rolling Bank Transactions | |
| Closest SAT Scores | |
| Empty Neighborhoods | |
| Comments Histogram | |
| Top Three Salaries | |
| Subscription Overlap | |
| Button AB Test | |
| Monthly Customer Report | |
| Payments Received | |
| Experiment Validity | |
| Top 3 Users | |
| Employee Salaries | |
| Find the Missing Number | |
| Employees Before Managers | |
| Last Transaction | |
| Google Maps Improvement | |
| Duplicate Rows | |
| Size of Joins | |
| Weighted Average Sales |
Synthesized from candidate reports. Individual experiences may vary.
The candidate reports that the process began with a take-home Power BI project that had to be built out and submitted. Applicants may want to make the report clean and be ready to explain each design choice in later rounds.
The candidate was asked to walk through a few steps directly in Power BI, which they felt was meant to confirm real familiarity with the tool. They were also asked to explain Row-Level Security, which they described as the main technical checkpoint. They passed this round.
The candidate reports a second round held in person at the office, scheduled by HR. It leaned toward interpersonal questions rather than technical ones. The candidate felt it went well, and HR asked for their documents at the end.
After the in-person round, the candidate reports about two weeks of silence and several follow-ups before HR said they had not cleared the round. No specific feedback was given. Applicants may want to follow up politely and expect that timing could vary.