Subscribe To Our YouTube Channel
The Data Analyst Practice Platform I Wish I Had 12 Years Ago
DataSimHQ is an AI powered data analyst job simulation. You join fictional companies, receive briefs from simulated stakeholders, work with real databases, submit your work, and get graded feedback in seconds. Every task you complete builds a portfolio automatically.
In this walkthrough I take you through the whole thing:
The Work Desk, where you pick a company and a track. Meridian Retail, Nexus Financial Services, VitalCore Health Network, FlowRoute Logistics and Pitchside Soccer Co., each with its own branded database and its own business problems.
Three tool tracks. SQL, Power BI and Microsoft Excel, with tasks arranged from Junior Analyst up to Lead Analyst.
Real business requests. Not “build a bar chart”. Something closer to “build the Foundation page, four KPI cards, apply our brand styling”, written the way a manager would actually write it.
The AI Mentor. Ask it anything about the task and it will teach you how to think about it without handing you the answer.
Instant grading with specifics. It tells you exactly what passed, what could not be confirmed, and the steps to bring the work to full marks.
Design mockups on request. Copy a prompt, paste it into your AI tool of choice, and get back a polished reference layout so you know what good looks like before you build.
The Analyst Board. Rank against other analysts by XP earned, weekly and all time.
Start practising: https://datasimhq.comShow More

Now Playing
The Data Analyst Practice Platform I Wish I Had 12 Years Ago
You have watched the tutorials. You can follow along. But sit in front …
You have watched the tutorials. You can follow along. But sit in front of a real business request from a real manager and everything freezes. That gap is what DataSimHQ …closes.
DataSimHQ is an AI powered data analyst job simulation. You join fictional companies, receive briefs from simulated stakeholders, work with real databases, submit your work, and get graded feedback in seconds. Every task you complete builds a portfolio automatically.
In this walkthrough I take you through the whole thing:
The Work Desk, where you pick a company and a track. Meridian Retail, Nexus Financial Services, VitalCore Health Network, FlowRoute Logistics and Pitchside Soccer Co., each with its own branded database and its own business problems.
Three tool tracks. SQL, Power BI and Microsoft Excel, with tasks arranged from Junior Analyst up to Lead Analyst.
Real business requests. Not “build a bar chart”. Something closer to “build the Foundation page, four KPI cards, apply our brand styling”, written the way a manager would actually write it.
The AI Mentor. Ask it anything about the task and it will teach you how to think about it without handing you the answer.
Instant grading with specifics. It tells you exactly what passed, what could not be confirmed, and the steps to bring the work to full marks.
Design mockups on request. Copy a prompt, paste it into your AI tool of choice, and get back a polished reference layout so you know what good looks like before you build.
The Analyst Board. Rank against other analysts by XP earned, weekly and all time.
Start practising: https://datasimhq.comShow More
DataSimHQ is an AI powered data analyst job simulation. You join fictional companies, receive briefs from simulated stakeholders, work with real databases, submit your work, and get graded feedback in seconds. Every task you complete builds a portfolio automatically.
In this walkthrough I take you through the whole thing:
The Work Desk, where you pick a company and a track. Meridian Retail, Nexus Financial Services, VitalCore Health Network, FlowRoute Logistics and Pitchside Soccer Co., each with its own branded database and its own business problems.
Three tool tracks. SQL, Power BI and Microsoft Excel, with tasks arranged from Junior Analyst up to Lead Analyst.
Real business requests. Not “build a bar chart”. Something closer to “build the Foundation page, four KPI cards, apply our brand styling”, written the way a manager would actually write it.
The AI Mentor. Ask it anything about the task and it will teach you how to think about it without handing you the answer.
Instant grading with specifics. It tells you exactly what passed, what could not be confirmed, and the steps to bring the work to full marks.
Design mockups on request. Copy a prompt, paste it into your AI tool of choice, and get back a polished reference layout so you know what good looks like before you build.
The Analyst Board. Rank against other analysts by XP earned, weekly and all time.
Start practising: https://datasimhq.comShow More

Now Playing
Power BI DAX Tip: Stop CALENDARAUTO() From Creating Unwanted Dates

Now Playing
Avoid this 2 Power Query transformations in Power BI

Now Playing
Can Claude AI Really build a Financial Model in Excel?

Now Playing
Save multiple filters in Excel with Custom Views

Now Playing
How to use Power BI without Work/School Email (2025 Update)
How to use Power BI without Work/School Email Microsoft Intune Free …
How to use Power BI without Work/School Email
Microsoft Intune Free Trial Link – https://www.microsoft.com/en-us/security/business/microsoft-intune
Free Training Resources with Certificates of completion – https://training.foresightbi.com.ng/collections/b2c550
Microsoft Intune Free Trial Link – https://www.microsoft.com/en-us/security/business/microsoft-intune
Free Training Resources with Certificates of completion – https://training.foresightbi.com.ng/collections/b2c550

Now Playing
How to use Power BI without Work/School Email (2024 Update)
How to use Power BI without Work/School Email (2024 Update) M365 Free …
How to use Power BI without Work/School Email (2024 Update)
M365 Free Trial 👉🏾 https://www.microsoft.com/en/microsoft-365/business/compare-all-microsoft-365-business-products-d?
Learn Power BI Quick in less than 5 hours 👉https://www.udemy.com/course/data-analytics-essentials-with-power-bi/?referralCode=E5A0CDD34285EFC0F75A
Master Excel Formulas & Functions 👉https://www.udemy.com/course/mastering-microsoft-excel-formulas/?couponCode=XLFORMULAS
M365 Free Trial 👉🏾 https://www.microsoft.com/en/microsoft-365/business/compare-all-microsoft-365-business-products-d?
Learn Power BI Quick in less than 5 hours 👉https://www.udemy.com/course/data-analytics-essentials-with-power-bi/?referralCode=E5A0CDD34285EFC0F75A
Master Excel Formulas & Functions 👉https://www.udemy.com/course/mastering-microsoft-excel-formulas/?couponCode=XLFORMULAS

Now Playing
Power BI Developer Internship – How to approach and deliver power bi reporting requirements
Internship Link: …
Internship Link: https://training.foresightbi.com.ng/courses/power-bi-developer-internship
Learn Power BI Quick in less than 5 hours 👉https://www.udemy.com/course/data-analytics-essentials-with-power-bi/?referralCode=E5A0CDD34285EFC0F75A
Master Excel Formulas & Functions 👉https://www.udemy.com/course/mastering-microsoft-excel-formulas/?couponCode=XLFORMULAS
Learn Power BI Quick in less than 5 hours 👉https://www.udemy.com/course/data-analytics-essentials-with-power-bi/?referralCode=E5A0CDD34285EFC0F75A
Master Excel Formulas & Functions 👉https://www.udemy.com/course/mastering-microsoft-excel-formulas/?couponCode=XLFORMULAS

Now Playing
40. Data Cleaning Example 6
Subscribe and turn on your notifications. More playlists and videos in …
Subscribe and turn on your notifications. More playlists and videos in development.
Download the course files here https://drive.google.com/drive/folders/1Nef5R0ZtEshPuqM96pQuO4kSQsoRBqlJ?usp=sharing
Download the course files here https://drive.google.com/drive/folders/1Nef5R0ZtEshPuqM96pQuO4kSQsoRBqlJ?usp=sharing

Now Playing
34. Introduction to Data Cleaning
Subscribe and turn on your notifications. More playlists and videos in …
Subscribe and turn on your notifications. More playlists and videos in development.
Download the course files here https://drive.google.com/drive/folders/1Nef5R0ZtEshPuqM96pQuO4kSQsoRBqlJ?usp=sharing
Download the course files here https://drive.google.com/drive/folders/1Nef5R0ZtEshPuqM96pQuO4kSQsoRBqlJ?usp=sharing

Now Playing
35. Data Cleaning Example 1
Subscribe and turn on your notifications. More playlists and videos in …
Subscribe and turn on your notifications. More playlists and videos in development.
Download the course files here https://drive.google.com/drive/folders/1Nef5R0ZtEshPuqM96pQuO4kSQsoRBqlJ?usp=sharing
Download the course files here https://drive.google.com/drive/folders/1Nef5R0ZtEshPuqM96pQuO4kSQsoRBqlJ?usp=sharing

Now Playing
39. Data Cleaning Example 5
Subscribe and turn on your notifications. More playlists and videos in …
Subscribe and turn on your notifications. More playlists and videos in development.
Download the course files here https://drive.google.com/drive/folders/1Nef5R0ZtEshPuqM96pQuO4kSQsoRBqlJ?usp=sharing
Download the course files here https://drive.google.com/drive/folders/1Nef5R0ZtEshPuqM96pQuO4kSQsoRBqlJ?usp=sharing

Now Playing
37. Data Cleaning Example 3
Subscribe and turn on your notifications. More playlists and videos in …
Subscribe and turn on your notifications. More playlists and videos in development.
Download the course files here https://drive.google.com/drive/folders/1Nef5R0ZtEshPuqM96pQuO4kSQsoRBqlJ?usp=sharing
Download the course files here https://drive.google.com/drive/folders/1Nef5R0ZtEshPuqM96pQuO4kSQsoRBqlJ?usp=sharing

Now Playing
38. Data Cleaning Example 4
Subscribe and turn on your notifications. More playlists and videos in …
Subscribe and turn on your notifications. More playlists and videos in development.
Download the course files here https://drive.google.com/drive/folders/1Nef5R0ZtEshPuqM96pQuO4kSQsoRBqlJ?usp=sharing
Download the course files here https://drive.google.com/drive/folders/1Nef5R0ZtEshPuqM96pQuO4kSQsoRBqlJ?usp=sharing

Now Playing
32. Dealing with Cell Errors in Power Query
Subscribe and turn on your notifications. More playlists and videos in …
Subscribe and turn on your notifications. More playlists and videos in development.
Download the course files here https://drive.google.com/drive/folders/1Nef5R0ZtEshPuqM96pQuO4kSQsoRBqlJ?usp=sharing
Download the course files here https://drive.google.com/drive/folders/1Nef5R0ZtEshPuqM96pQuO4kSQsoRBqlJ?usp=sharing

Now Playing
36. Data Cleaning Example 2
Subscribe and turn on your notifications. More playlists and videos in …
Subscribe and turn on your notifications. More playlists and videos in development.
Download the course files here https://drive.google.com/drive/folders/1Nef5R0ZtEshPuqM96pQuO4kSQsoRBqlJ?usp=sharing
Download the course files here https://drive.google.com/drive/folders/1Nef5R0ZtEshPuqM96pQuO4kSQsoRBqlJ?usp=sharing

Now Playing
31. Removing Duplicate Records
Subscribe and turn on your notifications. More playlists and videos in …
Subscribe and turn on your notifications. More playlists and videos in development.
Download the course files here https://drive.google.com/drive/folders/1Nef5R0ZtEshPuqM96pQuO4kSQsoRBqlJ?usp=sharing
Download the course files here https://drive.google.com/drive/folders/1Nef5R0ZtEshPuqM96pQuO4kSQsoRBqlJ?usp=sharing

Now Playing
25. Adding Conditional Columns (1)
Subscribe and turn on your notifications. More playlists and videos in …
Subscribe and turn on your notifications. More playlists and videos in development.
Download the course files here https://drive.google.com/drive/folders/1Nef5R0ZtEshPuqM96pQuO4kSQsoRBqlJ?usp=sharing
Download the course files here https://drive.google.com/drive/folders/1Nef5R0ZtEshPuqM96pQuO4kSQsoRBqlJ?usp=sharing

Now Playing
33. Checking for Cell Errors reasons in Power Query
Subscribe and turn on your notifications. More playlists and videos in …
Subscribe and turn on your notifications. More playlists and videos in development.
Download the course files here https://drive.google.com/drive/folders/1Nef5R0ZtEshPuqM96pQuO4kSQsoRBqlJ?usp=sharing
Download the course files here https://drive.google.com/drive/folders/1Nef5R0ZtEshPuqM96pQuO4kSQsoRBqlJ?usp=sharing

Now Playing
23. Adding new Columns from a Text Column
Subscribe and turn on your notifications. More playlists and videos in …
Subscribe and turn on your notifications. More playlists and videos in development.
Download the course files here https://drive.google.com/drive/folders/1Nef5R0ZtEshPuqM96pQuO4kSQsoRBqlJ?usp=sharing
Download the course files here https://drive.google.com/drive/folders/1Nef5R0ZtEshPuqM96pQuO4kSQsoRBqlJ?usp=sharing
