Mirek Cerny

I will teach you
how to do Data Analytics
powerfully and profitably

PRACTICAL COURSES
FOR YOU AND YOUR COMPANY

Advanced course D2:

Become a GREAT Data Expert

I will teach you in one day:

1. How to view and manage the business through an aggregate lens and prevent biases

  • Different ways to aggregate values
  • What most people get wrong when they look at the numbers, and how to prevent it
  • What is Context, what are its types and how not to mess up aggregate calculations
  • Hands-on exercise: Use data to assess whether a job applicant is asking for a reasonable salary given the company’s circumstances.

2. How to make the analysis easier for yourself and for people by choosing the right data model

  • How to organise and relate the data appropriately
  • A data model suitable for transactional systems and operational management
  • How to make simple analyses fast and swift
  • A data model suitable for detailed financial reporting
  • How to enable the average people to perform complex business analysis across departments
  • What some large companies are doing to decentralize and improve team autonomy
  • The opportunities and pitfalls of a robust solution for historicizing and tracking changes in data
  • Analytical queries across multiple business processes
  • Fast queries on large volumes of data
  • Hands-on exercise: Selecting the appropriate data model for a specific assignment from management.
3. How to build a well-organized, reliable and secure data warehouse
  • Master-data tables, document registers and their roles in systems
  • Fundamental parts and objects in a data warehouse
  • How data is loaded into the data warehouse and processed efficiently
  • How data is transformed, what happens to it and why
  • How to improve the speed, reliability and transparency of data processing
  • How to ensure that every user can see the information they are allowed to see and should see
  • Practical exercise: you will suggest to the management of a large company how to use data to improve their business after acquiring a competitor.

4. How to create deep insights and act on them

  • How to derive useful and in-depth insights from raw data
  • Types of quantitative modeling and variously advanced AI
  • The principle and magic of data stories
  • What to build prescriptive and recommender models and systems on
  • How to model data for Power BI, Tableau and other analytics tools
  • Practical exercise: Choosing the most profitable decision predictive model

5. How to design intelligence to work easily, smartly and reliably

  • How to visualize insights in a clear, deep and beneficial way
  • How to appropriately integrate insights and intelligence into enterprise systems
  • Data and information security at different levels
  • How to manage changes in the data warehouse on the fly and maintain reliability
  • How to deal with the impact of external circumstances and business changes
  • Practical exercise: You will build and draw a simple yet smart company dashboard.

6. How to practically easily launch your own, proven and powerful BI

  • How to decide whether to start with a data warehouse in the cloud, on-premise or locally
  • Where to get realistic, enterprise-grade, example data suitable for creating BI
  • How to set up your own data warehouse and what to look out for
  • The four essential parts of the Power BI platform, how to get them up and running, and what to watch out for
  • Effective ways to further your data science knowledge and experience
  • Hands-on exercise: You’ll build a plan for what you don’t already have and how you’ll get it all up and running.

After the D2 (advanced) course:

  • You’ll use data analytics purposefully, reliably, and effectively

  • You’ll take control of your business data, engage your users, and increase your company’s profits

  • You’ll incorporate smarter intelligence into a variety of processes and systems

  • You’ll dramatically increase the success and benefit of any data, BI and AI projects

  • You’ll bring purpose, depth and order to data analytics and BI

  • You’ll become a wise partner to management and business people

  • You’ll start to truly embrace data and enjoy it more than ever before

I'll teach you in a human-friendly way

I will explain it to you in a way that you will really understand it and I will answer all your questions.

I will tell you the essentials and the principles so that you can use them correctly and I will not burden you with technical details.

You will enjoy hands-on exercises.

References of attendees

How the educational workshops work

No computers are needed for the training and you will receive all needed materials.

The workshop is non-technical and does not require previous experience in data analysis. I will teach you principles that you can use in any technology.

If you need advice or help beyond the workshop, we’ll set up a time for a BI consultation.

Some of my clients also come to us for data coaching in a long run, gaining international-level know-how that is not available anywhere else.

Company courses

I will come to your company anywhere in the Czech Republic.

The company course lasts 7 hours plus an hour for lunch break, typically from 9am to 5pm.

The ideal number of participants is 5, we can increase this if needed.

We need a projector and flipchart or whiteboard in the training room.

The price of the trainings are:

  • D1 (Basic) – 56 000 CZK (excluding VAT)
  • D2 (Advanced) – 56 000 CZK (excluding VAT)
  • D1 (Basic) + D2 (Advanced) bundle – 95 000 CZK (excluding VAT)

For training outside of Prague I charge a transport fee of 1000 CZK for every 50 km.

In case of cancellation or change of the date after the binding order I charge a cancellation fee of 5000 CZK.

Individual courses

The individual courses go with a 50% discount compared to the Company courses.

They can be made online or in-person.