Workshop Business Intelligence with Excel & PowerBI | DATA SCIENCE duration Evening
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.
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
Who is this course aimed at?
The course is also open to beginners, who are recommended to have basic knowledge of Excel.
What will you gain from this course?
At the end of the course, you will be able to:
- Use Excel to collect, clean and analyze large data sets;
- Tell compelling stories with your data thanks to effective dashboards
Diploma & Certifications
At the end of the course, you will receive a certificate of completion “GEEKS ACADEMY DIPLOMA”, a “DIPLOMA SUPPLEMENT” and the EXIN INTERNATIONAL CERTIFICATIONS included in your study plan – if you choose to sit the exam, which is not mandatory.
For a period of 5 years after the conclusion of the course, you will have the chance to benefit from our Career Coaching service for free.
Over 95% of our graduates have found a job within 3 months since the end of the course!
To our students we offer the possibility to take part in exciting study trips in Dubai, Seoul, Milan, Rome and Singapore, where the hubs of our international network are located. These immersive experiences represent a great way to enrich students’ wealth of knowledge and increase their career opportunities.
Global Alumni Community
By joining this course, you will automatically become a member of the AGA: the Alumni Geeks Academy.
AGA is the community that gathers all our former students in order to offer them support, help them strengthen and develop professional relationships, provide them with networking opportunities and notify them about the latest job offers. The Alumni International Day represents the community’s most important international networking event, as well as a valuable opportunity to keep up-to-date with the latest trends and technologies.
Teaching Arrangements & Technical Equipment
Smart Education Formula
Course delivery mode: synchronous distance learning
The lessons will take place either in the evening (21: 00-22: 40) and/or during the weekend (Saturday and/or Sunday 10:00-13:20 and/or 14:10-17:40).
*The hours indicated are intended as academic hours of 50 minutes each.
Our flexible approach allows you to study wherever and whenever you want, even if you work and do not have much time.
All lessons are delivered OnlineLive by qualified teachers, and are recorded in real time to give you the opportunity to watch them asynchronously on our e-learning platform, in case you miss one lesson or you want to review some contents. Among other things, on the platform you will also find many useful materials for self-studying, such as self-assessment tests, exercises and exam simulations.
Minimum technical equipment
Notebook: i3 / i5 multi-core CPU | 8GB RAM | O.S. Windows 10 (recommended), Linux / Mac Os X
Excel 2016 or later
Payment must be issued in one single solution before the beginning of the course.
The number of places available is limited
Please fill out the form to inquire about our services & promotions and to check the availability.