Contoso Data Analytics Project

Ready to Upgrade Your Career?

Are you a student, job seeker, or young professional looking to break into tech or enhance your digital skills?

This Master Class is designed to equip you with the in-demand, practical tech skills you need to thrive in the Data Analytics market.

Who Should Attend?

Recent graduates & university students

Job seekers and career switchers

Entrepreneurs and freelancers

.

Professionals looking to upskill

Register Here
Click Me!
Register Here

FAQ's.

This class is designed for students, trainees, business analysts, data enthusiasts, and professionals who want to move from Excel basics into advanced data analytics, modeling, and visualization.

  • Basic Excel knowledge is recommended (formulas, tables, charts).

  • No prior knowledge of Power Query or DAX is required — we’ll cover them step by step.

  • Microsoft Excel (2016 or later / Office 365) with Power Query and Power Pivot enabled.

  • A sample dataset (ContosoDB) will be provided.

By the end of this master class, you’ll be able to:

  • Clean and transform raw data using Power Query.

  • Build a data model (star schema) with relationships.

  • Create calculated columns and DAX measures (e.g., Revenue, Profit Margin, YoY Growth).

  • Analyze business scenarios using Pivot Tables & Charts.

  • Present insights for decision-making.

Yes. You will receive:

  • The dataset (ContosoDB extracts).

  • Step-by-step exercise files.

  • A summary guide/notes for Power Query, Power Pivot, and DAX formulas.

Yes. Participants who complete the class will receive a Certificate of Completion from Dayfigurez Consult Ltd.