Before u proceed below to check the jobs/CVs, please select your favorite job categories, whose top job alerts you want in your email & Subscribe to our Email Job Alert Service For FREE
Table of Contents
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:
Job Id | Company | Role | Location | Exp. |
4064 | MSCI Inc | Power BI Developer | Mumbai | 2 – 6 years |
4654 | NICE | Business Operations Analyst(Power BI) | Pune | 4 – 8 years |
4782 | TeamPlus Staffing Solution Pvt Ltd | POWER BI Developer – Office Work Job | Bangalore | 2 – 7 years |
7334 | Huquo Consulting Pvt. Ltd | Power BI/Tableau Developer – R/SQL/Python | Gurgaon | 3 – 8 years |
7339 | Capita | Power Bi developer / Senior Analyst / Performance Dashboard | Mumbai | 3 – 7 years |
8962 | Info Corporate Service | Product Delivery Analyst – Power BI / Tableau | Bangalore | 2 – 5 years |
14844 | Irish Taylor & Co Pty Ltd | Microsoft certified trainer Power BI,Excel-Japanese & English language | New Delhi | 1 – 3 years |
17630 | eClerx | eClerx is hiring Power BI / Tableau Experts | Navi Mumbai | 0 – 2 years |
17927 | Tranzita Systems | Knime & Power BI Developer | Noida | 2 – 6 years |
28137 | Bridge Global Indonesia | Power BI Developer | India | NA |
28141 | BRIDGE Global | Power BI Developer | Cochin | NA |
28145 | Genpact | Lead Consultant – DMR – Power BI | Gurgaon | NA |
28540 | ANKR CONSULTING PRIVATE LIMITED | Vba Macro Developer and Power BI | Hyderabad | 1 – 6 years |
30736 | Spectral Consultants | Power BI | Pune | 3 – 10 years |
32308 | NS Matrix Services Pvt. Ltd | NSMX – 6009 – Power BI Specialist | New Delhi | 1 – 6 years |
36079 | Dell Technologies | Power BI Analyst | Hyderabad | NA |
36287 | NS Matrix Services | Power BI Specialist | New Delhi | NA |
37279 | Yashoda Super Speciality Hospital | Walkin – MIS Analyst ( Power BI)- Yashoda Hospitals | Hyderabad | 2 – 6 years |
39007 | Dell Technologies | Power Bi Analyst | Bangalore | 7 – 8 years |
41386 | Evalueserve | Looking For a Senior Power BI Developer For Evalueserve | Gurgaon | 5 – 8 years |
43031 | AstraZeneca | Junior Associate – Power BI | Chennai | NA |
571 | Deloitte | Power BI -Senor Analyst | Hyderabad | NA |
1851 | Vidushi Infotech | Power BI Developer (VIT/HR/PBI/001/1221) | Pune | NA |
1852 | Spectral Consultants | Power BI Developer | Gurgaon | NA |
1879 | visualbi | Power BI Developer | Chennai | NA |
1921 | Vatsa Solutions | Power BI Developer | Pune | NA |
1934 | vslpc | Power BI Developer | Pune | NA |
2033 | Motorola Solutions | Power BI Developer | Bangalore | NA |
Please LIKE & SHARE this post among your social networks if it made a difference in your life…