I will make dashboard reports in power bi and excel using macros pivot and dax

Pakistan

I speak Urdu, English

2 orders completed

Data management, visualization, automation and Machine Learning expert

I have a versatile experience of Project Management and from Database creation to Data extraction with Complex SQL Queries(SnowFlake/BigQuery/SQL Server) and then visualizing through interactive repor...
About this Gig

I am an Engineer by Profession and have a lot of professional experience.


I have more than 7+ years of experience in working on Excel/power BI and have done many complex projects easily on excel while working in my professional work.


I will help you in following:


  1. Arranging raw data in Excel using pivot tables and graphs.
  2. Minimizing the daily routine work through use of MACROS.
  3. Present raw data in professional way in excel using graphs.
  4. Apply filters to raw data.
  5. Apply any find of formula in excel
  6. Make use of VLOOKUP and HLOOKUP to solve complex problems.
  7. Apply DAX to make data clean and workable in Power BI.
  8. Report/Dashoboard creation in Excel and Power BI.


Note: Kindly text me before ordering any GIG and discuss details of the order with me so that i can provide you professional work. 

 I will make sure of my customer satisfaction on any cost and provide as many revisions as required my customer until customer is satisfied.

Technology:

Excel

Jupyter Notebook

Power BI

Analysis type:

Quantitative analysis

Qualitative analysis

Expertise:

Business Insights

Algorithms

Prediction

Probability

Programming language:

Python

SQL

DAX

Other Data Analytics Services I Offer