From Spreadsheet Logic to Analytics Logic: Excel → Power BI Thinking Name
Duration: 75 Minutes
This course has the aim of developing a thought process, a work flow, that illustrates how we move from row, ranges and tables of data in an Excel workbook to an exploration of the ways in which the data behave, interact with each other and help to explain where they came from and how they help us to understand the messages hidden in them.
- Appreciate the Various Potential Sources of data
- Importing data into Excel and Power BI
- Dirty Data is no data: how to clean data manually, programmatically
- Dealing with missing data
- Descriptive Statistics: early statistical analysis for understanding
- Tables, Graphs and Chart for the Visualisation of data
- What if some of the data don’t fit? Anomalies/Outliers: the King Kong Effect
- Finding and downloading/importing data from source
- Importing data: copying data from another file, manually typing it in, copy and paste, Power Query, Power Pivot
- Cleaning data by inspection and by analysis, using Regular Expressions, using Power Query: replace values, split column
- Decisions involving missing data
- Data Analysis ToolPak in Excel: correlation matrix, descriptive statistics
- Basic visualisation in Excel, more comprehensive visualisation in Power BI
- Assessing anomalies and outliers in Power BI
Even as recently as a decade ago, we wrote two words and believed we had encapsulated the world of data Analytics: data and information. We saw data as the raw materials and information as the finished product. Since then, we have come to appreciate that the information is just step two on the longer road to analytics, action and reflection.
In this seminar we will use real world data examples such as financial results, house/vehicle pricing models and even weather patterns to illustrate the ways in which data becomes information becomes analytics.
In this seminar we will use real world data examples such as financial results, house/vehicle pricing models and even weather patterns to illustrate the ways in which data becomes information becomes analytics.
- Bookkeepers and accountants
- Financial analysts
- Sales and Marketing staff
- Budget Accountants
Cost accountant in process industries in the UK
Further Education College Lecturer
Reader and Associate Professor, University of Malawi: teaching financial and management accounting
Honorary Professor, Kazakhstan Institute of Management, Economics and Strategic Research: 1993-1998
Teacher, trainer, author, management consultant, project management in a variety of settings in a variety of countries
Currently focusing on online and face to face training in a post experience environment as well as writing/creating teaching/learning materials
Upcoming Webinars
By Duncan Williamson
Date: Feb. 23, 2026
By Margie Faulk
Date: Feb. 23, 2026
By Dr. Susan Strauss
Date: Feb. 23, 2026
By Don Phin
Date: Feb. 23, 2026
By Marcia Zidle
Date: Feb. 24, 2026
By Ritu Arora
Date: Feb. 24, 2026
By Melveen Stevenson
Date: Feb. 25, 2026
By David Nettleton
Date: Feb. 25, 2026
By Edwin Waldbusser
Date: Feb. 26, 2026
By Paul Pelletier
Date: Feb. 26, 2026
By Mike Thomas
Date: Feb. 27, 2026
By Mark Gorkin
Date: March 2, 2026
By Marcia Zidle
Unlock Employee Loyalty: Stay Interviews Will Keep Them Engaged Before They Start Looking Elsewhere!
Date: March 2, 2026
By Beverly Beuermann-King
Date: March 2, 2026
By Daniel Clark
Date: March 2, 2026
By Marcia Zidle
Date: March 5, 2026
By Dr. Susan Strauss
Date: March 9, 2026
By Brian G. Rosenberg
Recorded Session
By Kelly Thomas
Recorded Session
By Ronald L. Adler
Recorded Session
By Edwin Waldbusser
Recorded Session
By Brian G. Rosenberg
Recorded Session
By Marcia Zidle
Recorded Session
By Rachelle D Souza
Recorded Session
By Bruce Lee
Recorded Session
By Ritu Arora
Recorded Session
By Carolyn Troiano
Recorded Session
By Ginette M. Collazo
Recorded Session
By Justin Muscolino
Recorded Session
By Jonnie Keith
Recorded Session
By Bruce Lee
Recorded Session
By Cathy Horwitz
Recorded Session
By Beverly Beuermann-King
Recorded Session
By Nancy Amert
Recorded Session
By Deb Schaffer
Recorded Session
By Charles H. Paul
Recorded Session
By Allen Evitts
Recorded Session
By Charles H. Paul
Recorded Session
By Dr. Susan Strauss
Recorded Session
By Dev Strischek
Recorded Session
By Kelly Thomas
Recorded Session
By Diane L. Dee
Recorded Session
