YBIFoundation at Microsoft Power BI Community
Power BI is an interactive data visualization software product developed by Microsoft with a primary focus on business intelligence. Microsoft Power BI easily connect to your data sources, clean, and model your data without affecting the underlying source, visualize (or discover) what's important, and share that with anyone or everyone you want.
The Ecommerce transaction analysis is one of great way to learn data visualization with Power BI or Tableau. Your visualization must reveals customer sales, product sales, regional sales, monthly sales, time of the day sales to gain valuable insights and business planning. You may use Combo Charts, Cards, Bar Charts, Tables, or Line Charts; for the customer segmentation page, you could employ Column Charts, Bubble Charts, Point Maps, Tables, etc.
Keeping a high customer engagement is key for business growth, specially when you are into online food business. Data analyst works both with business and technical stakeholders to provide insights for potential business growth.
- Perform robust exploratory analysis with actionable business insights and data driven proposals to add value to the company customer engagement and business growth.
- Perform statistical analysis beyond mean, variation etc. and use data analytics techniques like clustering, predictive models etc.
Financial performance analysis for business intelligence is based on optimizing financial analysis for a firm that provides accounting services to clients who seek timely delivery of critical financial reports. Use one or combination of below
- for the summary/overview page, you can use Funnel Charts, Combo Charts (Column Charts, Line Charts, Waterfall Charts);
-for the income statement page, you can use Cards, Funnel Charts, and Combo Charts (Line Charts and Column Charts); and
- for the balance sheet page, you can use Cards and Tables.
Annual Financial Statement Analysis of Companies
Quarterly Financial Statement Analysis of Companies
Pharma Drug sales dataset consist of transaction collected for a period 2014-2019 on hourly frequency, drug type and quantity. Group of drugs in dataset constructed from 57 drugs for various medical uses.
Anomaly detection for credit card transactions of state employees. Import data and train model for anomaly detection in Power BI desktop or Notebook. To label outliers in Power BI, you'll need to run a Python script in the Power Query Editor and use the get_outliers() method. Create dashboard to visualize with the help of Line Charts, Bubble Charts, TreeMaps, etc.
Source: Delaware Open Data
Road accidents are major cause of property and life losses. The dataset gives opportunity to deep dive into the pattern of accidents and create dashboard visualization for meaningful insight.
Source: Delaware Open Data