Reporting on maps in Excel & Power BI course

Impresses your audience by showing the data on a map
Free tutorial
Rating: 4.2 out of 5 (10 ratings)
3,752 students
1hr 46min of on-demand video
English
English [Auto]

Learn how to create and analyse maps in many different ways - in Excel and Power BI
If you are new to maps, there are full videos at your disposal where I go through the different charts and options step by step.
I also talk a lot about pitfalls and problems that are not lacking in working with maps.
Maps are not free from problems and errors (e.g. in the process of geocoding). In the course you will learn what to watch out for.

Requirements

  • I recorded the course in 2020 in Office 365, but you will do a large part of the course in previous versions.
  • Regardless of the version, download the current version of Power BI Desktop for free.

Description

Free course for Excel and Power BI users interested in map reports. If you're new to maps, there are full-length videos that give you a step-by-step overview of how different charts and options work. I also talk a lot about pitfalls and problems that are not lacking in working with maps.

7 reasons why you should take the course

  1. Lots of tools - In the course, I show all the options related to maps in Excel and Power BI.

  2. The practical nature of the tasks - Most of the scenarios created life - customers and readers asked about it.

  3. Full downloads - Below you will find a full set of downloadable materials that you can use however you want. Moreover, there are some extra tools to make your job easier.

  4. Tool traps - Maps are not free from problems and errors (e.g. in the geocoding process). In the course you will learn what to watch out for.

  5. Excel 365 news - I recorded the course in 2020 and used new charts such as the Kartogram. Moreover, the course will be constantly updated with what's new in Excel.

  6. Examples of projects - In the course, I share examples of projects completed for various clients.

  7. Only proven and practical advice - Tasks for self-completion

Who is the course for?

  • The course is aimed at both beginners and advanced users of Excel. Anyone interested in maps and Excel will find something for themselves here.

  • From my experience, the course will be especially useful in the following departments: sales, logistics, controlling, finance, planning, analysis, production (plant and product maps) and many others.

  • If you are interested in a particular tool, you can only find the lessons that are relevant to it.

Who this course is for:

  • For everyone looking for a quick way to visualize the data on maps.
  • The course is also a great preparation for further deepening the knowledge of creating reports in Excel - with the use of Power Query, Power Pivot, dashboards and Power BI.

Instructor

Excel BI Academy_com / SkuteczneRaporty_pl
Bartosz Czapiewski
  • 4.4 Instructor Rating
  • 44 Reviews
  • 6,528 Students
  • 8 Courses

My name is Bartosz Czapiewski.

I come from Poland and live in Warsaw.

I run two most popular blogs in Poland dedicated to:

- Data visualization & dashboard design – SkuteczneRaporty_pl

- Power Query, Power Pivot, Power BI – ExcelBI_pl

Since 2010 I run trainings in Polish and English, many of which are Fortune 500 companies, like Coca-Cola, 3M, BMW, Danone. At Excel BI Academy I gathered all my knowledge and expierence from +100 live trainings on:

- Power Query for Excel & Power BI

- Power Pivot aka Data model & DAX language

- Power BI

- Data Visualization & Dashboard design

Since 2020 my courses are available online at Excel BI Academy_com.

What's my motto?

Effective Reports = Automation + Visualization and Analysis + Good Decision

English term Effective Reports (SkuteczneRaporty in Polish) has become my company name.

Where did my interest in dashboards come from?

It was 2009 when, while working as an analyst in an international company from the financial industry, I was asked by my supervisor to prepare a “dashboard”. The word sounded strange to me, so I checked it thoroughly in a search engine, where I found car dashboards and analogous dashboards showing business results. Both forms had two important features – they fit on one screen within the sight of the recipient and present numbers in a graphic and visual form. It was a completely different approach than the one I had known before. Traditional reports, most common in companies and organizations, contain thousands of columns of numbers spread over multiple sheets. While looking for the best dashboard building practices, I came across the principles of data visualization, i.e. an approach that starts with how the human brain works in the context of data analysis. Only by combining these two elements – correct data visualization and dashboards, we make working with reports much easier.

Why do I think this is important?

Every day, millions of people around the world create reports in the form of text, tables, charts and graphics, the purpose of which is to convey information and share knowledge to the recipient. Reports are both a compilation of business data, a financial report or a press article. We are an information society where the ability to collect, process, analyze and present information is extremely valuable. Especially in business, reports are worth their weight in gold as they are the basis for making everyday decisions. Their accuracy largely depends on the effectiveness of the report. Here are my insights on data visualization:

Most of the people who create charts cannot handle them properly.
The most popular charts (e.g. pie charts) are among the least effective.

It is fashionable to “colorize” reports that is contrary to the work of the brain.

The most popular computer programs that are used to visualize data, including Microsoft Excel, mislead the user and violate the basic principles of data visualization.

The charts that appear in the press and reports also mislead the public.

The concept of dashboards was reflected only in Excel 2013, in a way so camouflaged that few users will discover it.

Data visualization is not a subject that is taught at any economic university in Poland, nor is it included in MBA programs.

Top companies trust Udemy

Get your team access to Udemy's top 15,000+ courses