Question: One sister has asked on Data Science Career Coach youtube channel “Sir, Can you make a video on how much excel is required in Data Analytics & Power BI Jobs For Freshers ?”..

In this post we are covering, how much excel is required in Power BI Developer Jobs…

Answer By Data Science Career Coach

To answer above question, We have explored BigDataKB.com Power BI Jobs where Excel was mentioned in the job description as shown in screenshot below…please fine below all the Excel based requirements of the companies looking to hire Power BI Developers…

• Proven ability to create reports and dashboards from various data sources like SQL server, SSIS, Redshift, data extracts, excel files.
• Knowledge of Advanced Excel and PowerPoint.
• Strong knowledge of and experience with reporting packages- SSRS and SSIS, databases (SQL etc), programming ( Javascript, or ETL frameworks) and Excel Macro.
• Solid Microsoft Excel skills. Experience with VBAs and Macros, Power query, power pivot tables and pivot reporting highly desirable.
• Create automated templates in excel with use of advance excel formulas (Power Query, Power Pivot Table, Pivot Table , Index Match, Vlookup, Hlookup)
• Create custom dashboard in Power BI and Excel
• Knowledge of Excel – Power Pivot & Power Query, Data Models
• Expert in MS Excel and MS Access
• Conceptual Knowledge (algorithms and basic syntax) in VBA is required.
• Experience in Python and other programming languages, Web Automation, Excel VBA
• Experience in SQL Query or Excel Macros is a plus.
• Proficiency  RDBMS, MS Access, MS PowerPoint, MS Excel pivots/formulas/Vlookup, VB Scripting, Macros writing, Power Pivots.
• Handling database management by using Advanced Excel tools & MS Acess.
• Should be proficient with Advanced Excel Formulas such as, Pivot Table, VLookup, Conditional.
• Advanced Excel is must
• Candidate will be responsible for building unit test cases, analyzing data using Sql queries and Excel and build Power BI Models and Dashboards.
• Interface Management with the different data base like Green Production Data Base / DUDIS/Excel imports
• Should know Advanced Microsoft Excel (VLOOKUP, SUMIF, COUNTIF, PivotTables, text manipulation, data validation, OFFSET, INDEX, MATCH, array formulas)
• Should have Experience in MIS Reporting and Excel
• Data needs to be extracted either from SAP or MS excel files.
• Well versed with Power BI and Power Automate modules of office 365 and should be able to create dashboard using excel files and SAP data.
• Advance excel skills with in-depth knowledge of developing VBA, Macros & Dashboards.

Conclusion:

If you are a fresher and you are planning for Power BI Developer jobs then start with Power BI and in between wherever Excel is needed , just learn that part…, don’t waste too much of time on Excel…

The reason Why I have said above is, out of total 14,470 Data Science jobs that we have posted on BigDataKB.com, Power BI Developer jobs are 510 and out of these 510 jobs excel was mentioned in only 39 jobs…moreover, these 39 jobs were mostly experienced power BI developer jobs. You may please try the same search on any other job sites like Glassdoor or Indeed and may see the same analysis.

Here are the Names of the companies & the Job Role they were offering, who had mentioned Excel in their Job Description:

List of Power BI Jobs on BigDataKB.com Where Excel Was Mentioned:

Please LIKE & SHARE this post among your social networks if it made a difference in your life…

Detailed Video on Same Topic on Data Science Career Coach Youtube channel: