Workshop Business Intelligence with Excel & PowerBI | AI & BIG DATA duration Evening
Business Intelligence (BI) is the dynamic process through which unstructured corporate data is structured into strategic knowledge to support management decisions. As such, BI is considered fundamental for the business development of any organization, and its implementation requires appropriate adaptable and configurable software tools that, by acquiring and manipulating data, provide reports, statistics, indicators and graphs updated in real time.
Excel is by far the most widely used tool for business data analysis. However, only few specialists really know how to use it to its full potential for these specific applications. Essential for SMEs reporting, Excel is also a valid decision-making support tool for large organizations, thanks to the introduction over time of increasingly advanced features that represent the focus in this workshop.
Power BI is a business analysis solution that allows users to view data in innovative ways and to share detailed information that can also be incorporated into mobile apps or websites. The Power BI specialist is able to connect hundreds of data sources, present locally or in the cloud, to create advanced dashboards and dynamic reports.
Main Contents
UNIT1 | 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
UNIT 2 | 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
Request a one-on-one interview to learn more about each teaching unit.
Who is this course aimed at?
The course is open also to beginners, who are however recommended to have a 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.
Career Coaching
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!
International Experiences
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 on Saturday and Sunday (10:00-13:00 and 13:45-15:45 CET).
*The hours indicated are intended as academic hours of 50 minutes each.
E-learning Platform
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 Method
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.