Geeks Academy
DATA SCIENCE: Business Intelligence with Excel & PowerBI

Workshops DATA SCIENCE
Business Intelligence with Excel & PowerBI
REQUEST INFOPRMATION

Workshops DATA SCIENCE
Business Intelligence with Excel & PowerBI

DATA SCIENCE

DATA SCIENCE

Workshops Business Intelligence with Excel & PowerBI

WorkshopsDATA SCIENCEDuration Weekend

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.


DATA SCIENCE: Business Intelligence with Excel & PowerBI

DATA SCIENCE

Duration: 16

Job Placement

English

Where the Workshops Business Intelligence with Excel & PowerBI will take place?

City

Promotions

Scholarships

Capacity

Online - November 2020

No promotion at the moment

2 Scholarships
available at the moment

10 places available
Workshops capacity: 12

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.

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

The course is also open to beginners who are recommended to have basic knowledge of Excel.

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

Minimum technical equipment
i3 / i5 multi-core CPU | RAM 8GB
S.O. Windows 10 (recommended), macOS, Linux
Excel 2016 or later

Request information

AND DOWNLOAD THE BROCHURE


Register with your profile:

Or fill in the fileds:

Share with:


Workshops Teachers

Workshops Area

DATA SCIENCE

DATA SCIENCE


European Data Workers will grow from the current 6 millions to 13.4 millions by 2026; the worldwide value of the Big Data Analytics market will rise from $8.5 billion in 2017 to $40.6 billion in 2023. In 2019, the value of the Italian Big Data market was estimated at €1.4 billion, registering an increase of 26% if compared to the previous year.

Check out also these courses of DATA SCIENCE

Digital training courses Geeks Academy

Blockchain: 4,9€ billion European investments by 2023

The value of the Cyber Security global market will be 300 billion in 2025.

13,4 million European Data Workers by 2028

REQUEST INFORMATION

Our Partner

powered by dunp