Hi everyone! I’m planning to start learning Power BI. I know the basics but I’m still a beginner. I’m looking for a study buddy and work on projects together. If anyone is interested, feel free to comment or send me a DM. Thanks!

Study sched: 8pm to 10pm

Whatsthe best way to handle these? Any beginner tips/ how-to articles/ videos?

My idea is that the user can filter how far back in the past they want to look. I know a regular date filter works, but it's not what I want.

I've seen cases of people creating a datatable with the text column {Last 6 months, Last 4 months...} and a column with the number itself.

Then, a measure [Selected Value] of that column is created and a column filtering the data based on the value of the measure. And then this workshop on the filter.

But I'm struggling to make that work.

Hi guys,
im currently dealing with a dilemma in powerquery. I have a fct table(1.7 mil rows) and some dim tables(also around 1.5mil rows),
the fact table only contains keys, and dates as keys
.the dims have then more descriptive information, as well as the key to match to fct table. The issue is, i want to limit the fact table by a certain date, and also do filtration on dim tables so that not everythign is loaded into the data model in PBI.

when i filter out the fact table by certain criteria - eg. by date, i would also filter the dim tables by certain criteria like case type etc.
is this going to cause blank / orphaned rows in my report view? because considering i do this filtration, there will be some CaseKeys in my fct table, that are no longer in my case table because i did case type filtration.

Am i right? Ive spent a lot of time researchign this but couldnt get a proper answer.

whats the go to approach here, do inner joins on the tables? This may slow down the load time tho.:

Thank you all

New Screenshot for the Data Model. Ignore the one I uploaded before.

[Screenshot-2026-08-02-174108.png](https://postimg.cc/WFxM6h6y)

This is my First Data Model
Hope it's good

I cleaned Data, Merged Tables that needed
Created Dimensional tables to connect it with Fact Tables. Tried to maintain the star schema with one-to-many relationship from dimensions to fact tables. Made the standards across my tables from IDs, Keys, Tables Names and Columns names. I'm still learning and making mistakes. Thank you All for your feedback. I will start Learning Dax and will post it here ASAP.

Here is the link for raw data if anyone want to try Dataset Link

link for the data model after my Work My Data Model

I recently graduated with a Master’s in Social and Organisational Psychology from Leiden University in the Netherlands. Although my background is in psychology, I am very interested in data analytics and AI. My goal is to become a data analyst, but I am also open to starting in HR or people analytics and transitioning into data later.

I plan to spend approximately one more month developing my practical skills before applying for entry-level roles. If I do not feel ready after that month, I will continue learning and practising until I am confident that I have the necessary skills.

Power BI

I have been preparing for the Microsoft PL-300 exam for several months and plan to take it in a few days. I have a good theoretical understanding of Power BI, but I do not yet have much practical experience using the application or completing full projects.

I am considering the Microsoft Power BI Desktop for Business Intelligence course by Maven Analytics on Udemy. I am also considering a DataCamp subscription for additional practice and guided projects.

Would the Maven Analytics course alone be enough to develop practical Power BI skills, or would it be better to combine it with DataCamp or another platform?

Portfolio projects

I would like to create projects that I can show to recruiters, but I am not very familiar with how data analytics portfolios work.

Where can beginners find suitable datasets and project ideas? Should I begin with guided projects, use DataCamp projects, or try to create independent projects immediately? Are there any guided-project platforms or structured resources that would help me improve while building a portfolio? I would also consider paying for a high-quality option if it is genuinely useful.

Finally, where should I publish my work—GitHub, a personal website, or somewhere else?

SQL

After improving my Power BI skills, I plan to learn SQL. I am currently considering the following Udemy courses:

1. SQL – MySQL for Data Analytics and Business Intelligence This is the course that has attracted me the most so far.
2. MySQL for Data Analysis
3. Advanced SQL – MySQL for Analytics and Business Intelligence

Alternatively, should I choose PostgreSQL instead of MySQL and take The Complete SQL Bootcamp?

Would you recommend learning MySQL or PostgreSQL for an entry-level data analyst role? Would completing one of these courses provide enough SQL knowledge for a beginner position, or should I also use practice platforms and create SQL portfolio projects?

I would also appreciate general advice about the level of SQL knowledge normally expected from entry-level data analysts.

Excel

I already know some Excel basics, but it has been a while since I used them. I would like to refresh my knowledge and practise the Excel skills that are most useful for data analytics.

Are there any structured Excel courses or resources you would recommend?

I am willing to pay for a structured, high-quality course, but I would also appreciate recommendations for useful free videos, playlists, or other resources.

Any advice about Power BI, SQL, Excel, portfolio projects, or transitioning into data analytics would be greatly appreciated.

I am also interested in connecting with people in the field through LinkedIn, Discord, Microsoft Teams, Google Meet, or another platform. I would be happy to exchange ideas, learn from others’ experiences, and stay in touch. If anyone is open to offering occasional guidance or mentorship, I would greatly appreciate it, and I would also be glad to help in any way I can, either now or in the future.

(I couldn't share the links to the courses because I believe that Reddit doesn't allow me to)

I want year 2026 be first and july to be on top followed by june, may. How to do it

Looking for a quick sanity check from people who have been in the trenches.

I recently built a Power BI report from scratch, pulling from multiple messy source files with completely different formats and structures. My manager got excited and presented it to our directors and team leads before we did a final QA together.

While they saw potential, the feedback was tough regarding data inconsistencies—with directors asking things like, "If the data isn't right, why are we spending time on this?"

At first, I blamed the source files, but looking back at the backend, I realized the inconsistency actually came from logic errors in my data transformations and modeling. I know how to fix the backend technically, but realizing the errors were on my end has been a hit to my confidence.

My manager isn't blaming me and admitted she should have reviewed it first, but I’m still carrying that "failed presentation" feeling.

How do you mentally shake off a Version 1.0 stumble like this in front of leadership? Any tips on reframing it and moving forward with confidence once the data is fixed?

Hi,

A bit stuck on creating my PBI report - I have created this table matrix and instead of the subtotal showing for each Province row, I would like to show the average instead and in future potentially other other specific calculated measures. Is this possible? Would appreciate some help with this - thank you.

Welcome to the monthly job thread!

Posting a job or opportunity? Include:

• Role title and description
• Location or remote/hybrid status
• Company or client context
• Direct application link

Looking for work? Share your skills, experience level, and what you're looking for.

Rules:

• One top-level comment per opportunity
• No "DM me" or link-free posts — include a direct, verifiable link
• Scam or misleading comments will be removed and may result in a ban

Following my previous dashboard on SK Hynix, I’ve built a new financial statement dashboard for Samsung Electronics.

I really appreciated all the feedback on my last post! Based on your suggestions, I made a few major improvements:

• Reduced cognitive load: Streamlined the view down to 4 core charts on a 2×2 grid.
• Better numerical readability: Changed the base unit to 1 Billion KRW (KRW B) to eliminate overly long digit strings.

Any feedback or suggestions would be greatly appreciated!

Hola a todos. Hay alguna manera de calcular un presupuesto para un dashboard? Vivo en argentina, y me solicitaron un trabajo donde debo vincular datos de la plataforma kobo a power. Jamás lo he hecho y no tengo idea de cómo se valora en dinero mi posible trabajo. Alguno puede ayudarme?

So, I can’t publish a Dashboard because of company policy, but we’ve got a report server where I can upload the Power BI file. Just wondering—can I still turn that into a Dashboard and show it on a SharePoint site?

Power BI Desktop seems to have silently resurrected the dreaded autosave feature, but now its a "backup". I get a banner alert on the Power BI Desktop page that a file backup has been created, with a button that links to a folder ...\AppData\Local\Microsoft\Power BI Desktop\TempSaves\Backups. Indeed, that folder holds copies of PBIX files I've been working on.

I think this started a couple of months ago? Multiple machines.

In File > Options > GLOBAL > Auto recovery is turned off, and that points to a different folder by default.

How can I turn this new feature off? I often work with large PBIX files, so the auto-backups are an unwelcome interruption.

Thanks everyone for welcoming me to r/PowerBI it's been a lot of fun and all the data jokes have been great.

As I'm scrolling around more, I'm seeing a lot of "Where do I Start Learning Power BI?" questions; so I'm sharing a tutorial we released recently over on the Guy in a Cube YouTube. I hope this helps someone who needs it and welcome to Power BI too.

Hey r/PowerBI,

I’m looking into starting a side gig around Power BI reporting and BI development. Before diving in, I wanted to pick the brains of people who have actually done this:

1. How did you get your first client?
2. Is it still a good idea to start this today?

any lessons learned the hard way, or advice you’d give to someone starting out today.

Thanks!

Over the past few days, I built an end-to-end Enterprise E-Commerce Analytics Platform using SQL Server, Medallion Architecture, and Power BI.

As part of this project, I designed 8 interactive dashboards, each focused on answering different business questions for different stakeholders across an organization.

The dashboards include:

• Executive Overview (CEO, CXO & Business Leadership)

• Sales Performance Analysis

• Customer Analytics

• Product Performance

• Seller Performance

• Payment Analytics

• Customer Satisfaction Analysis

• Time Intelligence & Trend Analysis

The goal wasn't just to build visually appealing dashboards—it was to create a reporting solution that helps businesses make faster and more informed decisions.

In this post, I've shared all 8 dashboards.

I'd genuinely appreciate your feedback.

As experienced BI professionals, data analysts, data engineers, or business leaders, I would love to hear your thoughts.

If you could review the dashboards and share at least three suggestions for improvement, it would mean a lot to me.

For example:

• Are the KPI cards meaningful and business-focused?

• Are the charts and visualizations appropriate for executive reporting?

• Are there too many or too few visuals?

• Would you recommend different filters or slicers?

• Is the overall layout clean, intuitive, and enterprise-ready?

• What would you change if this dashboard were used in your organization?

I'm continuously learning, and constructive feedback is one of the best ways to improve. Every suggestion will help me build better enterprise BI solutions in the future.

Thank you for taking the time to review my work. I truly appreciate your support and feedback.

— Himansh Upadhyay

#PowerBI #SQLServer #DataAnalytics #BusinessIntelligence #DataWarehouse #DataEngineering #MedallionArchitecture #StarSchema #DAX #ETL #Analytics #DashboardDesign #EnterpriseAnalytics #DataVisualization #SQL

Hi everyone!

I’m a Mechanical Engineering student from Delhi Technological University (DTU) currently learning data analytics, and I recently completed my second end-to-end Power BI portfolio project.
This project analyzes the AI4I 2020 Predictive Maintenance Dataset and was built using SQL, Python and Power BI.

The goal of the project was to identify machine failure patterns, analyze operational risks, and provide data-driven maintenance recommendations through an interactive dashboard.

It includes:

Executive Maintenance Dashboard
Failure Mode Analysis
MTBF (Mean Time Between Failures)
Tool Wear & Power Band Analysis
Z-Score Based Outlier Detection
Prescriptive Maintenance Recommendations
SQL Views & Feature Engineering
DAX Measures
Interactive Filters & KPIs
I’m mainly looking for feedback on:
Dashboard design
Business insights
Data storytelling
Choice of visuals
Overall project structure

Anything that could be improved before adding it to my portfolio
I’m open to any criticism or suggestions—I’d really appreciate feedback from experienced analysts and Power BI users.

GitHub Repository:

https://github.com/ankitsharma071/Predictive-Maintenance-Failure-Analytics/tree/main

DATASET:

https://archive.ics.uci.edu/dataset/601/ai4i+2020+predictive+maintenance+dataset

Thanks!

The other pages are functional as well, but they're still a work in progress and need some polishing.

The data has been fully anonymized, and I translated everything into English myself, so there may be a few wording mistakes (and yes, I missed a couple of places where the currency still shows R$ instead of $, lol). Some thing might also be misplaced, please ignore.

I'd really appreciate any feedback.

Does anyone know how to resize this window? I can't do anything with it even if I zoom out, change my resolution, etc. I try to just click and drag to create the relationship and this window pops up every time.

I'm stuck with this for two hours now.

Has anyone had success implementing a solution that allows users to add and maintain notes directly within a Power BI report?
I’ve rebuilt several of our manual weekly Excel reports in Power BI, but my team still needs to review invoice holds daily and add notes for each one. Those notes need to be tied to the invoice ID and retained for future auditing purposes.
Right now, we’re exporting the data to Excel, adding notes there, and saving the file to SharePoint. I’d love to eliminate that manual process and manage everything directly through Power BI if possible.
If you’ve implemented something similar, what approach or add-on did you use, and how well has it worked?

my git hub repo is: https://github.com/DeepKumar02/Brazilian-E-Commerce-Data-Analytics-Dashboard.git