How Microsoft Fabric Certifications Can Boost Your Data Career
Hi everyone! 👋 I'm currently on my Microsoft Fabric certification journey and wanted to start a discussion about how these certifications can help us grow in our data careers. --- Why I'm Pursuing Microsoft Fabric Certifications: 1. Industry Recognition - Microsoft certifications are globally recognized - Employers actively look for certified professionals - Adds credibility to your profile 2. Skill Validation - Proves you know the platform - Shows you can work with modern data tools - Demonstrates commitment to learning 3. Career Growth - Opens new job opportunities - Higher salary potential - More project responsibilities 4. Free Learning Resources - Microsoft Learn is FREE - Community support is amazing - Regular webinars and events Certifications I'm Working On: - [ ] DP-800: Fabric Analytics Engineer Associate - [ ] PL-300: Power BI Data Analyst - [ ] DP-600: Fabric Data Engineer Associate - [ ] DP-700: Fabric Data Scientist Associate I'd love to hear from experienced members: 1. Which certification helped you the most? 2. What study resources do you recommend? 3. How did certification impact your career? 4. Any tips for preparing for the exams?
Work with time (Minutes)
hi, I am completely new to power bi. I am working with a sales report, in which I am measuring each seller, the number of clients, sales, and I have problems with timing. Time in calls is measured, and to show the data I am using a card (however, the data is not showing correct) Basically my values ​​is, start time and end time. From here comes a column of total, which is in duration format. Could you help me on how can I give the best function to this variable?Return top 5 items instead of all items with top 5 values in table
Dear Team, Could you please help me with the following issue. I have risks list. Each risk in the list has its score. I need to create a table which will reflect 5 top items based on score. I tried to use Top N filter in Power BI, but it returns 5 top values, which are repeated. But I need it to return 5 top items. For Example, based on list below I need to retur 6 lines Risks from 09 to 14 (6th line have to be returned too as it is equal to value for 5th item). Risk01 1 Risk02 1 Risk03 2 Risk04 2 Risk05 3 Risk06 3 Risk07 4 Risk08 4 Risk09 5 Risk10 5 Risk11 6 Risk12 6 Risk13 7 Risk14 7 Can you please help me with the issue please. I am not attaching the orignal file as it is huge in volume.
General Power BI information for mini guide.
I'm writing a mini guide on data analytics for ICAEW, which is the largest body of chartered accountants in the UK. I've included a list of questions below and would greatly appreciate if you could Note that these don't have to be quotes it is more for general background information to help[ me write the BI section. Additionally, is there an on demand video of key features available? If so this would be handy too. 1. Please list BI’s key features 2. Which accountancy software platforms integrate directly with BI, and can you please link me a full directory of direct add ons. 3. Which sectors and size of business is BI most suitable for? 4. Are you able to please provide me with a couple of examples of how finance leaders/teams can use BI within their roles and for use across their wider companies? 5. What makes BI unique amongst its competitors? Would truly appreciate any answers for this.
Public Dashboard Creation
I have been tasked with creating a public facing dashboard. This dashboard cannot interact directly with our database so I would build an excel spreadsheet that would populate the dashboard. We want to refresh it every 2 weeks with the most current data. We would like for there to be sliders so that people can narrow by time, location, and other types of general parameters. Our license is through the university we are housed in though I am not sure exactly what is needed for this dashboard. Where can I find trainings to help me do this? Thank you, GariNeed Help - University task
I am a student and never use power bi before. it seems very hard and difficult for me. Is anybody here who could help me please? here is the task: Using Power BI adequately import and prepare the data. The focus of your assignment is to investigate the passenger segment of the business. Analyze the available data to gain insights into the following areas: To gain some basic insights into the state of business in the passenger segment we would like to provide some basic stats regarding total, average, maximum, and minimum of transported passengers. The company would like to continue its analysis by reporting on number of passengers and number of available seats by flight type. Also, a comparison of such data is needed based on departure/arrival countries. It is believed that the number of transported passengers varies both between the years and within the years. On a monthly (quarterly) basis, what are some spotted patterns in the data? Analyze the relationship between the number of passengers, number of transported mail, and the number of performed departures at the carrier level. Not all offered routes are equally ‘popular’. What are the top 12 routes based on number of enplaned passengers? What other patterns can you spot on these routes? After requirement workshops and interviews with BlueSky Airlines’ executive team you have distilled the following KPIs: Load Factor %: this gives the number of enplaned passengers versus the number of available seats Enplaned passengers (in millions): this gives the number of transported passengers, in millions Revenue Passenger Miles (in millions): this gives the total number of miles that all passengers were transported, in millions Available Seat Miles (in millions): this gives the total number of miles that all seats (including unoccupied seats) were transported, in millions Market Share: this is based on transported passengers Prepare an executive dashboard to follow the proposed KPIs. How is the company performing on different routes and countries on these KPIs? Where are some places for improvements?Conditional formatting based on a measure
I am taking a class in which we are using PowerBI, which is new to me. We have created a measure that compares the target profit margin 2% to the actual profit margin. If the actual is below the expected, it is unfavorable and should be yellow. Otherwise it should be green. I have directions but they appear to be from a prior software version. In the directions I should be able to select f of x and say base the decition on my target. I don't see that feature.
