The Data Analytics Process: Six Steps from Question to Decision
Six steps that most analytics projects follow, with an example for each.
Read guide →Excel, Power BI & Data Analytics Blog
Practical tutorials and career guides from the CharterPeak training team - organised around the same learning paths we teach.
What Is Data Analytics? Types, Process and Tools
A clear explanation of data analytics: what it is, the main types and the typical process.
Read guide →Power BI Data Modeling: Star Schema and Relationships
Why a star schema works best in Power BI and how to set up relationships correctly.
Read guide →Power Query in Power BI: Prepare Data Before You Model
Prepare data in Power Query before modeling, so DAX and visuals stay simple.
Read guide →How to Create a Power BI Dashboard
Step-by-step process for building a clear, interactive Power BI dashboard.
Read guide →DAX in Power BI: Fundamentals and Essential Functions
Understand filter context, CALCULATE and time intelligence so your measures stay correct.
Read guide →What Is Power BI? A Plain-English Introduction
A plain-English explanation of Power BI, its components and who uses it.
Read guide →How to Build an Excel Dashboard (Step by Step)
A step-by-step approach to Excel dashboards using pivots, slicers and clear layout rules.
Read guide →Power Query in Excel: Clean and Combine Data Automatically
Import, clean, merge and refresh data with Power Query - the same engine used in Power BI.
Read guide →Excel for Data Analysis: A Practical Workflow
A five-step workflow for analysing data in Excel, with the tools to use at each step.
Read guide →