The workshop will drive the attendees through the specific instruments and good-practices in order to proficiently use Power BI in the Sales Management field.
Power BI is the most powerful tool for your own Business Intelligence! The goal of this course is to give the attendees specific know-how about the development of a BI report with a particular focus on sales reports. The well-known functionalities of PowerBI for data cleaning and visualisation will be explicitly applied for sales reports, covering from the data ingestion up to the final visualisation through nice-looking plots and useful dashboards. The student will understand how to analyse and present the data to extract and make visually apparent the information content of the data itself.
Day 1
POWER BI DESKTOP Recap on basic functionalities | ad-hoc tools for sales data DATA MANAGMENT Data Import | Data Cleaning | native functions | complex languages | table relations build of a BI project REPORT MANAGMENT Sales Report | Pages | Sub-Reports | Dynamics filters | advanced functionalities for end-users HANDS-ON LAB Report creation with infographics for budget analysis
Day 2
POWER BI SERVICE Web portal | time-series comparison KPI | company portal creation for reporting and data sharing ADVANCED FUNCTIONALITY Ingestion from multiple data sources | schedule data update | the configuration of KPI alerts BI Salse time series comparison | dynamics filters | data drill through HANDS-ON LAB The creation of a Power BI report with a particular focus on time series comparison