Reporting on maps in Excel & Power BI course
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
Lots of tools - In the course, I show all the options related to maps in Excel and Power BI.
The practical nature of the tasks - Most of the scenarios created life - customers and readers asked about it.
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.
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.
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.
Examples of projects - In the course, I share examples of projects completed for various clients.
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
![Bartosz Czapiewski](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.5 Instructor Rating
- 503 Reviews
- 16,404 Students
- 11 Courses
My name is Bartosz Czapiewski.
I come from Poland and live in Warsaw. I teach Excel every day, namely:
- Data visualization and dashboard design
- Power Query, Power Pivot, Power BI
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
From 2020, my courses are available online.
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.