Asif S.
PeshawarPakistan
100% Job Success
Top Rated

extract and transform data from diverse sources using power bi

1. Data Extraction and Transformation: I will extract data from various sources, such as SQL databases, APIs, or web scraping. I will then transform and clean the data to make it suitable for analysis. 2. Data Analysis: I will perform a wide range of analyses, including descriptive statistics, pivot tables, advanced formulas, and statistical functions which are used to gain insights from the data and identify trends or patterns. 3. Visualization and Dashboards: I will use Power BI is an excellent tool for creating interactive dashboards and visualizations. I can create charts, graphs, maps, and other visualizations that effectively communicate your data insights. Also, I add interactivity and filters to allow users to explore the data on their own. 4. DAX Measures: I will use Power BI's Data Analysis Expressions (DAX) language to create custom calculations, measures, and calculated columns. This allows you to perform complex calculations and create meaningful metrics that align with your data analysis requirements. 5. Trend Analysis and Forecasting: By analyzing historical data, I will generate trends over different time periods, such as yearly, quarterly, or weekly. Additionally, I can apply forecasting techniques to predict future trends based on historical patterns. 6. Process automation: I will use Microsoft Power Automate to automate your daily repeated process. 7. Data scraping from website: I will programmatically scrap/extract/parse website contents and store it into database. 8. Data Visualization in Google Looker Studio: I will create reports and Dashboards in Google Data Studio (Google Looker Studio) from different Data Sources.

Asif S. has more jobs. Create an account to review them

Skills

  • Data Transformation
  • Looker Studio
  • Microsoft SQL Server
  • Data Wrangling
  • Microsoft Power Automate
  • SQLite