Microsoft Power BI:
1. Data from various resources (like Excel, csv, SQL databases etc.) will be extracted and visualize it in a simple and straightforward graphical way. Power BI Desktop, Service, and Embedded are all included in this.
2. Clean and cluster the data in Power Query, if needed, and develop star schema.
3. As I have an engineering management background with great knowledge of quality control charts (7QC tools), I will develop charts which involves check sheet, histogram, fishbone diagram, Pareto chart, Scatter diagram, Gantt chart and All types of charts that are available in power bi.
4. Write calculated columns, measures and DAX queries to perform complex calculations to be used in Power BI reports.
Microsoft Excel:
1. By using this software, I can create stunning and insightful dynamic dashboards with the help of pivot table, line, bar, scatter, area, doughnut, combo, advance slicers, hyperlink etc.
2. I will make Gantt chart in MS PROJECT and import it in Excel files.
Domain:
Sales, Project Management, Logistics, E-commerce, Digital marketing, , Manufacturing, Retail, HR etc.