top of page
Type
Category
110 items found for ""
- Power BI Project End to End- HR AnalyticsIn Power BI Projects·August 15, 2023Topics you will be learn in this Power BI Project: - Data Cleaning & Processing in Power BI - Power BI Dashboard Setup - Import data in Power BI - Power Query in Power BI - DAX in Power BI - Measures and Calculations in Power BI - Charts in Power BI - Filters and Slicers in Power BI - Dashboard in Power BI - Export Power BI Dashboard - Insights from Dashboard Create the below dashboard in power bi desktop. You can download the datasets to practice this project.0141
- Power BI report design plan document for a banking payments/payroll digital dashboard with sample data and visuals:In Tech Talk·July 20, 2023I. Introduction This report aims to create a Power BI digital dashboard for a banking payments/payroll system. The purpose of this dashboard is to provide HR and Finance Managers with easy access to key metrics and insights related to payroll expenses and payment processing. II. Key Metrics The following key metrics have been identified for this dashboard: Total Payroll Expenses Number of Payments Processed Average Payment Size Payment Processing Time III. Data Sources The following data sources will be used to populate the dashboard: Payroll Data from Internal Systems Payment Data from External Sources (banking APIs, third-party payment processors) IV. User Groups The dashboard will be designed to meet the needs of HR and Finance Managers. V. Visualizations The following visualizations will be used to display the key metrics and data: Bar Charts to display Total Payroll Expenses and Number of Payments Processed Line Graphs to display Average Payment Size and Payment Processing Time VI. Dashboard Organization The dashboard will be organized in the following way: Separate Pages for Payroll and Payment Data Filters for Users to Drill Down into Specific Areas VII. Interactivity The following interactivity will be included in the dashboard: Drill-Downs to View Detailed Payroll and Payment Information Filters and Slicers to Explore Data in More Detail VIII. Branding The dashboard will incorporate the following branding elements: Use of the Bank's Logo and Color Scheme Consistent Design Elements with Bank's Overall Brand Identity IX. Testing and Refinement The dashboard will be tested with HR and Finance Managers and refined based on their feedback. X. Sample Data and Visuals Please see below for sample data and visuals for the dashboard: Sample Data Sample Visuals Bar Chart displaying Total Payroll Expenses and Number of Payments Processed: Line Chart displaying Average Payment Size and Payment Processing Time: Conclusion In conclusion, this Power BI report design plan document outlines the key metrics, data sources, visualizations, dashboard organization, interactivity, branding, and testing and refinement for a banking payments/payroll digital dashboard. The sample data and visuals provided demonstrate how this dashboard can provide HR and Finance Managers with valuable insights and enable them to make informed decisions related to payroll expenses and payment processing.1010
- What is the DAX formula, if we want to do subtraction from a specific date with a specific date. If the date format is like this 15/08/2023In Questions & Answers·August 15, 2023Assuming you have two date columns named "Date1" and "Date2" in your table, and you want to calculate the difference between them in days: DateDifferenceInDays = DATEDIFF('Table'[Date1], 'Table'[Date2], DAY) Replace 'Table' with the actual name of your table containing the date columns. 2. If you need the result in months, you can replace DAY with MONTH: DateDifferenceInMonths = DATEDIFF('Table'[Date1], 'Table'[Date2], MONTH) 3. If you want a simple numeric result that represents the difference in days between two dates without considering months or years, you can use the '-' operator directly: DateDifferenceInDays = 'Table'[Date1] - 'Table'[Date2]109
- Power BI End to End Project ( Banking Domain)In Power BI Projects·August 15, 2023Datasets for practice you can download the below datasets and create the below dasboard by using datasets1011
- Some scenario-based Jira interview questions along with their answers, focusing on real-world situations you might encounter:In Ask Questions·March 16, 20241. Scenario: Managing Multiple Projects Q: You are managing multiple projects in Jira. How do you ensure each project's tasks are not only well organized but also visible to the relevant team members? A: To manage multiple projects effectively in Jira, I would: • Create separate projects for each team or project focus, ensuring tasks are organized within the relevant project space. • Use permissions schemes to control who can view or edit issues in each project, ensuring team members only have access to relevant projects. • Employ dashboards and filters to create customized views that highlight tasks by project, priority, due date, or team member, making it easier for everyone to see what's relevant to them. • Leverage Epics and Versions within projects to further organize tasks into larger goals or releases, aiding in overall project visibility and tracking. 2. Scenario: Prioritizing a Backlog Q: Your team has an overwhelming backlog. How would you use Jira to help prioritize tasks? A: In Jira, I would prioritize the backlog by: • Implementing a prioritization framework, such as MoSCoW (Must have, Should have, Could have, Won't have this time) or simply High, Medium, Low priority fields, to assess and assign priorities to each issue. • Using the backlog view to drag and drop issues into the desired order after priorities are assigned, ensuring the most critical tasks are at the top. • Conducting regular backlog grooming sessions with the team to review priorities, dependencies, and estimates, ensuring the backlog remains up-to-date and accurately reflects the team’s priorities. • Creating sprints (for Agile teams) and pulling the top-priority tasks into the sprint backlog, focusing the team's efforts on high-priority items. 3. Scenario: Reporting to Stakeholders Q: Stakeholders are asking for updates on the progress of various projects. How do you use Jira to provide comprehensive yet understandable updates? A: To report to stakeholders, I would: • Use Jira dashboards to create visual reports displaying key metrics such as sprint progress, issues resolved over time, and current priorities. Dashboards can be customized to show the most relevant information to stakeholders. • Generate specific reports available in Jira like Burnup Charts, Burndown Charts, or Cumulative Flow Diagrams for Agile projects to show progress towards goals. • Share filter results showing the status of critical tasks, upcoming deadlines, or completed work within a specified period. • Schedule regular reports to be emailed to stakeholders, ensuring they receive consistent updates. 4. Scenario: Improving Team Collaboration Q: Your team is facing collaboration issues, with many tasks being delayed due to miscommunications. How would you leverage Jira to enhance team collaboration? A: To improve team collaboration in Jira, I would: • Encourage the use of issue comments to keep all relevant communications and decisions about a task within its Jira issue, ensuring transparency and context are maintained. • Utilize @mentions in comments or descriptions to alert specific team members about updates or questions, ensuring they are notified of relevant information. • Implement Confluence integration for comprehensive documentation that can be linked directly to Jira issues, providing easy access to project specs, requirements, or meeting notes. • Create a ‘Team’ dashboard where all members can view their tasks, recent updates, and critical priorities, fostering a shared understanding of current project statuses and individual responsibilities. 5. Scenario: Handling Overdue Tasks Q: You notice a significant number of tasks are overdue. How would you address this issue using Jira? A: To manage overdue tasks in Jira, I would: • Review the overdue issues to identify any common factors such as unrealistic deadlines, dependencies, or workload distribution. • Adjust priorities and deadlines where necessary, in consultation with the team and stakeholders, to reflect a more realistic timeline. • Use the ‘Flagged’ status or a custom field to highlight tasks that are at risk of becoming overdue, drawing attention to them before they miss their deadlines. • Set up automated reminders for upcoming deadlines using Jira’s automation rules, helping team members stay aware of their commitments. • Conduct a retrospective to understand why tasks became overdue and to implement changes to processes or planning methods to prevent recurrence. These scenario-based questions and answers provide a gl003
- I'm a Jira administrator (and since I'm the only admin) and one of my colleages has managed to create a scrum board but no one can accessIn Ask Questions·March 13, 2024I'm a Jira administrator (and since I'm the only admin) and one of my colleages has managed to create a scrum board but no one can access this board now or not visible on the View Boards Menu that I can't see.Please help me . When you're the sole Jira administrator and encounter an issue where a colleague has created a Scrum board that isn't accessible or visible to others, including yourself, there are several steps you can take to troubleshoot and resolve the issue. Here's a structured approach to help you address this problem: 1. Check Board Permissions • Board Visibility: Boards in Jira are usually visible based on the filter that the board uses. The visibility of this filter dictates who can see the board. If the filter is private or restricted to certain users, the board will not be visible to others. • Action: Go to Boards > View All Boards, find the board created by your colleague, and check the ... menu for Configure. Under General settings, you can find the Filter settings. Ensure the filter is shared with the right people, groups, or projects. 2. Review Project Permissions • The issue might not be with the board itself but with the project permissions. If users do not have the necessary permissions to view the project associated with the board, they won't see the board. • Action: Go to the project settings and review the permissions scheme. Ensure that the appropriate roles or groups have Browse Projects permission. 3. Verify User Groups and Roles • Ensure that the users trying to access the board are in the correct groups or roles that have access to the board and the underlying filter. • Action: Review the user groups and roles under Jira Settings > User Management to ensure they align with the access configurations for the board and its filter. 4. Check if the Board Was Accidentally Deleted • In some cases, the board might have been accidentally deleted. While you can't directly recover a deleted board, you can recreate it using the same filter if that still exists. • Action: Verify if the board exists by looking at the list of all boards. If it's indeed deleted, check if the filter used by the board still exists under Issues > Search for issues, then save the filter and create a new board with it. 5. Examine Global Permissions • There might be global permissions affecting the visibility of boards. Although less likely, it's worth checking. • Action: Go to Jira Settings > System > Global Permissions and ensure there are no restrictive permissions affecting board visibility. 6. Direct URL Access • As a temporary workaround, ask your colleague for the direct URL to the board. If you can access it directly, this might indicate a visibility issue rather than a permission issue. • Action: Try accessing the board using the direct URL and see if there are any error messages or if it opens correctly.0071
- Welcome to the ForumIn General Discussion·July 18, 2023Share your thoughts. Feel free to add GIFs, videos, hashtags and more to your posts and comments. Get started by commenting below.002
- Here are some common SQL interview questions along with their answersIn Questions & Answers·August 7, 2023006
- Forum rulesIn General Discussion·July 18, 2023We want everyone to get the most out of this community, so we ask that you please read and follow these guidelines: Respect each other Keep posts relevant to the forum topic No spamming007
- In Power Bi,How to get the previous day date as current date with duplicate dates.In Questions & Answers·July 20, 2023To get the previous day's date as the current date in Power BI, you can use the TODAY() function to get today's date and then subtract one day from it to get the previous day. However, as you mentioned that there are duplicate dates, you may encounter issues when using simple date arithmetic. To handle duplicate dates, you can use the following approach: Create a calendar table: First, create a separate calendar table in Power BI that includes a unique list of all dates in your dataset, including duplicates if present. Add a calculated column: In the calendar table, add a calculated column that calculates the previous day's date. You can use the EARLIER() function to refer to the current row's date in the calculation. For example, if the name of the date column in your calendar table is "Date," and you want to create a new column called "PreviousDay," use the following DAX formula: PreviousDay = VAR CurrentDate = [Date] RETURN CALCULATE( MAX('Calendar'[Date]), 'Calendar'[Date] < CurrentDate ) This DAX formula calculates the maximum date that is less than the current date for each row, effectively giving you the previous day's date. Use the new column in your visuals: Once you have the "PreviousDay" column in your calendar table, you can use it in your Power BI visuals and analyses. You can now filter data based on the previous day's date as needed By using a separate calendar table and a calculated column, you can handle duplicate dates and ensure that the previous day's date is accurately calculated, even in cases where there are duplicates. This approach provides more flexibility and control over the date calculations in Power BI.0013
- Introduce yourselfIn General Discussion·July 18, 2023We'd love to get to know you better. Take a moment to say hi to the community in the comments.001
- How to store historical data in power bi if it's disappeared in server endIn Questions & Answers·July 30, 2023Storing historical data in Power BI can be accomplished by implementing proper data modeling and utilizing the built-in capabilities of Power BI. Even if the data disappears or gets updated in the server end, you can still maintain historical records in Power BI using the following methods: Data Refresh Options: By default, Power BI will attempt to refresh the data in your reports and datasets based on the data source settings. However, you can configure the data refresh options to keep the historical data even if it changes in the source. This can be done by going to the dataset settings in Power BI service and choosing "Keep data history" under the "Data Connectivity" tab. This ensures that Power BI keeps track of the changes made to the data over time. Versioning with Query Parameters: You can implement versioning in your data model using query parameters. Create a query parameter that represents the version of the data you want to retrieve. This can be a date or any other identifier that represents a specific point in time. Then, in your queries, use this parameter to filter the data based on the selected version. This way, you can always go back and view historical data by changing the parameter value. Snapshot Tables: Another method is to create snapshot tables in your data model. These tables capture the state of your data at specific points in time. You can set up a process to periodically copy the data from the source into these snapshot tables. This way, even if the original data changes or disappears, you'll still have historical data preserved in the snapshot tables. Archiving Data: Depending on your data source, you may have the option to archive historical data before it disappears. Archiving data involves moving older records to a separate database or storage location while keeping your primary dataset focused on the most recent data. Power BI can then be connected to both datasets, allowing you to access historical and current data in separate reports. Version Control: Consider using version control systems like Git to manage your Power BI files. This allows you to maintain historical versions of your reports and datasets, ensuring that you can always go back to previous states if needed.0025
bottom of page