Through my hands-on experience as a data analyst intern, I have mastered Excel and SQL, and delved into the world of Power BI using Dax functions. I’ve faced challenges like missing data and duplicate values, but my biggest achievement is building self-confidence. In the next 5 years, I aim to be an integral part of a company’s growth and success. So, are you ready to dive deep into powerbi? Let’s talk about creating drill up and drill down or how to identify types of license in workspace. With every challenge comes an opportunity to excel, and that’s the kind of mindset I bring to the table. #DataAnalyst #PowerBIExperience π
π Data Analyst Interview – For Freshers
- Key takeaways
| Topic | Key Point |
|---|---|
| Introduction | Self-introduction and previous experience |
| Skills | Excel, SQL, Power BI, and data analytics |
| Challenges | Data cleaning and visualization challenges |
| Technical | Discussions on Power BI technical questions |
| Licensing | Types and sizes of workspaces and licenses |
| Reporting | Unit testing, report validation, and automation |
| Future goals | Aspirations for the future 5 years |
Introduction
π Self-introduction and previous experience
Satarupa introduces herself as a data analyst intern with experience in Excel, SQL, and Power BI. She emphasizes her work at Matrix Private Limited.
- Table: Roles and Responsibilities at Matrix Private Limited
| Roles and Responsibilities |
|---|
| Creating dashboards |
| Data filtration |
| Data cleaning using various functions |
| Mining Work on Excel |
| Delivering client content per requirements |
Skills
π Excel, SQL, Power BI, and data analytics
Satarupa highlights her expertise in Excel, SQL, and Power BI, including DAX functions and data visualization challenges.
- List of Skills
- Excel
- SQL
- Power BI
- Data Visualization
Challenges
π οΈ Data cleaning and visualization challenges
She discusses facing challenges such as missing data, duplicate values, and data cleaning while working on projects.
"During my projects, the challenges were like missing data, finding duplicate values, and data cleaning."
Technical
π₯οΈ Discussions on Power BI technical questions
Satarupa answers technical questions related to Power BI, covering topics like data maintenance, predictive analysis, and constraints.
- Table: Technical Questions on Power BI
| Technical Questions | Answers |
|———————————————————|———–|
| Use of username and user principal name in static RLS | No |
| Maintenance of historical data in Power BI | No |
| Creation of drill up and drill down in interconnected tables | Possible |
| Impact of primary key and foreign key in Power BI | Breaks the one-to-many relationship |
| Retaining data after truncating a table in Power BI | Retains data according to the current status of the database |
Licensing
π Types and sizes of workspaces and licenses
She elaborates on the types of licenses in Power BI and the workspace sizes for each type, showcasing her deep understanding of the technical aspects of Power BI.
- Quote: "The model size should not exceed 400 GB for premium quality of license."
Reporting
π Unit testing, report validation, and automation
Satarupa explains the concepts of unit testing, report validation, and automation in Power BI, demonstrating her comprehensive knowledge in this field.
"Unit testing in Power BI means testing the report at the minimum level, row by row, to ensure data accuracy."
- Italics: "Report validation means using different data quality tools to detect and remove errors and duplicates."
Conclusion
π Aspirations for the future 5 years
She expresses her vision of being an integral part of an organization, contributing to its growth and success through skill development and taking on more responsibilities.
- FAQ: Is it possible to use username and user principal name in static RLS?
- No, they can only be used in dynamic RLS.
In conclusion, Satarupa’s technical interview showcases her in-depth knowledge and expertise. Her proficiency in Power BI and data analytics, along with a strong foundation in data visualization, makes her a promising candidate. Her future goals indicate a dedication to continuous improvement and a desire to contribute significantly to organizational success.
EN_GB