Workshops Business Intelligence with Excel & PowerBI | DATA SCIENCE duration Weekend
Scenario
For each company organization, the Business Intelligence (BI) activity is intended as the dynamic process of transforming unstructured corporate data into strategic knowledge to support management decisions. The BI is considered of fundamental importance for business development, therefore, its implementation requires appropriate adaptable and configurable software tools which, by acquiring and manipulating data, provide reports, statistics, indicators and graphs updated in real time.
Excel is the most widely used tool for the analysis of company data. However, few specialists really know how to use it to its full potential. Essential for small / medium enterprise reporting, Excel is also a valid decision support tool for large organizations, thanks to the introduction over time of increasingly advanced features that represent the focus in this workshop.
The need to create a shared corporate culture and based on informed decisions has led to the creation of tools designed for business intelligence, capable of satisfying the diversified needs of each subject at every level of a corporate structure. Power BI is a business analysis solution that allows you to view data in innovative ways and share detailed information that can also be incorporated into mobile apps or websites. Specialists of this technology will be able to connect hundreds of data sources, located locally or in the cloud,and to create advanced dashboards and dynamic reports.
Modules Business Intelligence with Excel
- Data import from external sources (database and csv)
- Connect several tables (join and union)
- Pivot Power Pivot
- Pivot on cross platform
- DAX (Data Analysis expressions)
- Cohort Analysis with Excel, case study
Business Intelligence with PowerBI
- Introduction to the concept of business intelligence
- Power BI Desktop
- Power BI Service
- Sharing dashboards
- How to present the "KPI" data
- Create a dynamic infographic
Requirements The course is also open to beginners who are recommended to have basic knowledge of Excel.
Learning outcomes At the end of the course, participants will be able to:
- Use Excel to collect, clean and analyze large data sets;
- Tell compelling stories with your data thanks to effective dashboards
Equipment and Note Minimum technical equipment
i3 / i5 multi-core CPU | RAM 8GB
S.O. Windows 10 (recommended), macOS, Linux
Excel 2016 or later