Harnessing the Power of Power BI for Business Intelligence – Part 1
In today’s data-driven world, businesses of all sizes—from small startups to large conglomerates—collect vast amounts of data. However, the true challenge lies in transforming this raw data into actionable insights that drive informed decision-making. Microsoft’s Power BI is a powerful business intelligence tool designed to help organizations convert data into meaningful reports and visualizations, making data analysis more accessible, insightful, and actionable.
Why Power BI is Essential for Modern Businesses
1) Data Consolidation Across Multiple Sources: Power BI allows businesses to integrate data from multiple sources, such as Excel, cloud services, databases, and even the web. This unified data access means that businesses can analyze sales, operations, finance, and customer data all in one place, enabling cohesive decision-making across departments.
2) Real-Time Analytics: Power BI provides real-time data streaming, meaning businesses can track key performance indicators (KPIs) and metrics as they happen. This allows companies to respond proactively to changes in market conditions or internal performance issues, rather than relying on static, outdated reports.
3) Advanced Data Visualization: While tools like Excel can visualize data to a degree, Power BI takes this a step further with interactive, highly customizable dashboards. These dashboards provide a clear view of complex datasets and help users easily identify trends, outliers, and opportunities through modern visuals like heatmaps, treemaps, and geographic maps.
4) Self-Service Business Intelligence: One of the greatest advantages of Power BI is its ease of use. Users across the organization, not just those in IT, can create their own reports and dashboards. This empowers all team members to make data-driven decisions and fosters a culture of data literacy throughout the organization.
5) Scalability and Affordability: Power BI is built on scalable data engines capable of handling large datasets without performance degradation. Additionally, its pricing structure is progressive, offering free options for small organizations using Power BI Desktop, and affordable licensing for larger enterprises that need cloud sharing and collaboration.
How to Set Up Power BI for Success
To maximize the potential of Power BI, proper setup and ongoing optimization are critical. Here’s a step-by-step approach:
1) Define Clear Objectives: Before jumping into Power BI, businesses should outline their goals. What key metrics are you tracking? What decisions do you hope to influence with your data? Aligning Power BI with these objectives ensures you are focused on the right data and insights.
2) Data Integration and Cleaning: Power BI excels when data is clean and consistent. Use tools like Power Query to prepare data from various sources, ensuring accuracy and reliability before analysis. Once cleaned, Power BI can pull in data from sources such as SAP, Oracle, Azure, and even websites.
3) Establish Roles and Permissions: To protect sensitive data, businesses should set up appropriate user roles in Power BI. The platform allows administrators to grant different permissions, ensuring that data is secure while still enabling collaboration across departments.
4) Foster a Data-Driven Culture: Training employees to use Power BI is essential for unlocking its full potential. Encourage team members to build their own reports and dashboards, fostering a culture where data literacy thrives.
Best Practices for Power BI Optimization
Even after setting up Power BI, ongoing refinement is essential to ensure the tool evolves alongside your business. Here are some optimization tips:
– Automate Data Refreshes and Alerts: Set up automatic data refreshes to ensure your dashboards always display the latest information. Use alerts to notify key stakeholders when KPIs reach critical thresholds, enabling faster responses to emerging trends.
– Optimize Report Performance: As data volumes grow, it’s important to optimize reports for performance. Techniques like DirectQuery and incremental refreshes can help keep reports running smoothly, even with large datasets.
– Design with Simplicity: Power BI dashboards should be clear and concise. Avoid overloading users with too much information, and focus on the most critical data points. Use consistent visualizations, round numbers, and clean layouts to enhance readability.
– Security and Governance: Power BI offers robust data security features, such as row-level security, allowing businesses to protect sensitive data while still leveraging the platform’s collaborative features.
Conclusion: Unlock the Power of Your Data with Power BI
Power BI transforms data into actionable insights, making it a critical tool for businesses looking to gain a competitive edge in today’s data-driven world. By integrating data across multiple sources, offering real-time insights, and enabling self-service reporting, Power BI helps businesses make informed decisions that drive growth, efficiency, and profitability.
With proper setup, ongoing optimization, and a commitment to fostering a data-driven culture, your organization can fully unlock the power of Power BI and harness the full potential of your data.
Ask us about how RothTech can help your organization leverage the full potential of Power BI for deeper insights and better decision-making.
This material has been prepared for informational purposes only, and is not intended to provide or be relied upon for legal or tax advice. If you have any specific legal or tax questions regarding this content or related issues, please consult with your professional legal or tax advisor.
ERC Voluntary Disclosure 2.0: Is this the opportunity you’ve been waiting for?
The IRS defines voluntary disclosure as “a way for taxpayers with previously undisclosed income to contact the IRS and resolve their tax matters.” It’s their way of offering remiss taxpayers the opportunity to mitigate potential penalties.
This new program refers specifically to the COVID-era Employee Retention Credit (ERC). If you claimed and received the Employee Retention Credit (ERC) for 2021 tax periods, but you are, in fact, ineligible, you will need to repay the credit. The Voluntary Disclosure Program, or VDP, may be your chance to regroup.
An analysis conducted by the IRS found that a whopping 60% to 70% of applications for the ERC show an unacceptable “level of risk.” This is IRS lingo for claims they believe have a high likelihood of being ineligible for the credit. Tens of thousands of these are slated to be denied in the coming months. This high percentage of erroneous filings has inspired the IRS to temporarily reopen the Voluntary Disclosure Program and give businesses the chance to repair or retract their improperly filed claims to avoid potential civil penalties, audit costs and possible litigation.
Round two of the Voluntary Disclosure Program (VDP) was launched on August 15, 2024 and will close soon – on November 22, 2024. The VDP offers a 15% discount on the repayment of a claimant’s errant claim and the opportunity to avoid penalties, audits, or fees associated with that incorrect claim.
The IRS is marketing this “discount” as defraying the high expenses that many businesses needed to pay their (overly aggressive) advisors or promoters in order to get the ERC in the first place. Couched in another way, the IRS is willing to pay 15% of the claim in order to get their hands on the other 85% and to get the business to rat on the promoters of ineligible claims.
The first ERC VDP earlier this year offered a more generous 20% discount, but that offer is gone. If a taxpayer believes that it is eligible for the ERC, but wants to recalculate to claim a different amount, it will have to file an amended return to report that reduced amount.
Only those who have claimed ERC for 2021 (not 2020) and have received the refund or the credit against their employment taxes, are eligible to take advantage of VDP 2.0. If a claimant has already received an IRS “clawback” notice demanding repayment, they’re out of luck. If they are in the middle of an employment tax exam for the credit period or are under criminal investigation, they have also lost their chance. When a claimant is accepted to the Voluntary Disclosure Program, they must execute a closing agreement explicitly stating that they are not entitled to the ERC – and the IRS doesn’t stop there. In its efforts to identify potentially abusive ERC promotors, the claimant will have to provide the names and contact information of the preparer or advisor who helped them submit the claim.
If you’ve applied for the ERC but have not yet received a credit or refund or have received a check but have left it uncashed, then you are not eligible for this program. Instead, the IRS offers a withdrawal process. This process effectively reverses your claim, treating it as if it was never filed. The IRS will graciously hold back from imposing penalties or interest as well. However, you won’t get the 15% “discount.” To date, the claim withdrawal process has led to more than 7,300 entities withdrawing $677 million.
The IRS continues hunting for erroneous or fraudulent ERC claims and has already mailed out thousands of letters disallowing unpaid ERC claims to businesses in these last few months. This deluge of letters represents more than $1 billion in ERC claims.
It is interesting to note that the IRS seems to be targeting only those that have already received their credits. For many businesses that have already received (and in most cases, spent) the monies, it would be very hard to part with what they already have in hand.
Do you need to rethink your ERC claim? Was your preparer above board? Was he or she knowledgeable about your business and informed about ERC qualifications? Was your eligibility based on “general supply chain disruptions?”
Our recent experience handling numerous ERC audits have shown us that the IRS has been operating under a policy of “deny first, ask questions later.” Your claim may deserve a revisit, and the Voluntary Disclosure Program may be your return ticket to proper compliance.
This material has been prepared for informational purposes only, and is not intended to provide or be relied upon for legal or tax advice. If you have any specific legal or tax questions regarding this content or related issues, please consult with your professional legal or tax advisor.
Democracy’s Price Tag
“Democracy is the theory that the common people know what they want and deserve to get it good and hard.”
— H. L. Mencken
It’s that season again — when those running for public office start making promises of all shapes and sizes, even those that defy the laws of economics. But let’s not forget their ultimate goal: to get more votes. As Churchill lamented, “The best argument against democracy is a five-minute conversation with the average voter.”
Let’s examine a few recent examples:
Vice President Harris, in her “economic plan” released on August 15th, promised to ban price gouging. This term usually refers to sellers exploiting market power to unfairly raise prices. With grocery prices up 26% since 2020, addressing this issue sounds appealing. However, even The New York Times felt compelled to critique this proposal, quoting economist Jason Furman: “This is not sensible policy, and I think the biggest hope is that it ends up being a lot of rhetoric and no reality.” Harris’s economic advisers surely know that price gouging bans have never and will never work, but they’re banking on voters not noticing.
Then there’s former President Trump’s tariff proposal: a 10% tariff on all imported goods. While this might appeal to voters who favor “America First” policies and resist globalization, these tariffs would ultimately raise prices for consumers. Although certain adverse measures can be justified in certain areas like computer chips (national security) or medicine (as seen during COVID), they ignore the fact that importing cheaper goods has long kept American lifestyles more affordable.
A final example is the bipartisan silence on the solvency of Social Security and the national debt. Telling seniors they might face pay cuts, or juniors that they need to pay more into the system, doesn’t win votes. As a result, these topics remain taboo until they become ticking time bombs.
Historian Niall Ferguson recently highlighted his “personal law of history:” “Any great power that spends more on debt service (interest payments on the national debt) than on defense will not stay great for very long. True of Habsburg Spain, t ancient régime France, true of the Ottoman Empire, true of the British Empire, this law is about to be put to the test by the U.S. beginning this very year.” Tackling this issue isn’t politically advantageous, so it’s conveniently ignored.
While were not here to predict the future, it is important to recognize the incentives driving political stances. To draw from the Churchill well once again, “Democracy is the worst form of government, except for all those other forms that have been tried from time to time.” It’s high time for voters to wake up to economic reality – politics is often a game of fantasy.
This material has been prepared for informational purposes only, and is not intended to provide or be relied upon for legal or tax advice. If you have any specific legal or tax questions regarding this content or related issues, please consult with your professional legal or tax advisor.
Recent FTC Rule Could Affect Value of Non-Compete Agreements
Non-compete agreements have always been considered a valuable business tool, especially after a merger or acquisition. However, these agreements have become more complicated in the wake of a new and controversial final rule, issued in April 2024, by the Federal Trade Commission (FTC) proposing a ban on noncompete agreements for most employees and independent contractors. The rule would have gone into effect in September 2024.
To counter the FTC’s effort, the U.S. Chamber of Commerce and several business groups filed federal lawsuits challenging the final rule, arguing that the FTC lacked the authority to enact the ban and that it violated the Constitution. By August 20, 2024, they prevailed, and the rule was struck down. The Court concluded that the FTC’s decision was “arbitrary and capricious,” stating that the Non-Compete Rule was “unreasonably overbroad.” The Court was specifically offended by the rule’s “one size fits all” solution to the potential hazards of a non-compete.
This ruling will not impact state laws on non-competes. Several states have already limited their use. Minnesota banned workplace non-competes in July 2023, and New York nearly passed a similar ban before it was vetoed. States like Indiana have also restricted non-competes in specific cases.
Non-compete agreements have been around for decades. Some are required at the get-go, as a prerequisite for employment, and some kick in upon termination of employment. The employer will require an employee to sign a non-compete agreement to protect the employer’s business interests, guard against disclosure of trade secrets, and prevent the employee from poaching customers or clients. These agreements will generally limit employment activities in the same field, for a specified period, and their goal is to protect the employer.
Non-competes also may come into play in business combinations. These agreements typically prevent the seller from competing with the buyer within a specified geographic area for a certain time period (usually five years or less).
A non-compete agreement may be estimated in various circumstances, including legal disputes, mergers, financial reporting and tax matters. The most common approach to valuing a non-compete agreement is the ‘with-and-without’ method. Without a non-compete agreement, the worst-case scenario is that competition from the employee or seller will drive the company out of business. Therefore, the value of the entire business represents the highest ceiling for the value of a non-compete.
The business’ tangible assets possess some value and could be liquidated if the business failed, and it is unlikely that the employee or seller will be able to steal 100% of a business’s profits. So, when valuing non-competes, experts typically run two discounted cash flow scenarios — one with the non-compete in place, and the other without.
The valuation expert computes the difference between the two expected cash flow streams and includes consideration of several other factors:
- The company’s competitive and financial position
- Business forecasts and trends
- The employee’s or seller’s skills and customer relationships
Next, each differential must be multiplied by the probability that the individual will subsequently compete with the business. If the party in question has no incentive, ability, or reason to compete, then the non-compete can be worthless. Factors to consider when predicting the threat of competition include the individual’s age, health, financial standing and previous competitive experience. When valuing non-competes related to mergers and acquisitions, the expert will also consider any post-sale relocation and employment plans.
A critical factor to consider when valuing non-competes is whether the agreement is legally enforceable. The restrictions in the agreement must be reasonable. For example, some courts may reject non-competes that cover an unreasonably large territory or long period of time. What is “reasonable” varies from business to business, and is subject to the particulars of the business, the terms of the agreement, state statutes and case law.
What does this mean for your business? The legal battle over non-competes has drawn attention to their use, prompting the corporate world to reconsider work relationships without restrictive covenants. Non-competes will likely be viewed differently moving forward. As with all business-related legislation, businesses should stay updated and informed of changes and revisions that may affect its employment practices and its bottom line.
This material has been prepared for informational purposes only, and is not intended to provide or be relied upon for legal or tax advice. If you have any specific legal or tax questions regarding this content or related issues, please consult with your professional legal or tax advisor.
Video: Real Estate Right Now | SDIRAs
Real Estate Right Now is a video series covering the latest real estate trends and opportunities, and how you can make the most of them. Below, we talk about the benefits of investing in a Self-Directed IRA (SDIRA).
If you’re an independent-minded investor looking to diversify, an SDIRA, or Self-Directed IRA, might be the way to go.
An SDIRA is an individual retirement account that can hold alternative investments. Besides for standard investments – like stocks, bonds, cash, money market funds and mutual funds, an investor can hold assets that aren’t typically part of a retirement portfolio, like investment real estate. A custodian or trustee must administer the account, but SDIRAs are directly managed by the account holder, which is why they’re called self-directed.
SDIRAs come with complex rules and carry some risk, but they offer the opportunity for higher returns and greater diversification.
Self-directed IRAs are generally only available through specialized firms, like trust companies and certain banks. As custodians, these entities are not allowed to give financial or investment advice about your SDIRA. The account holder is responsible for all research, due diligence, and asset management within the account. Some downsides of maintaining an SDIRA include custodial fees and – if you’re not a savvy investor – exposure to fraud.
When investing in real estate through an SDIRA, the IRA’s funds are used to purchase the property. That means that the IRA will own the property, and it can only be used for investment purposes. Know that there are potential tax consequences when an SDIRA carries debt – like a mortgage – and the SDIRA will probably get taxed at a higher rate.
The upsides of investing in an SDIRA are its flexibility, diversification and the control it gives to the investor. SDIRAs offer a wide range of investment options, so the investor is not limited to stocks, bonds and mutual funds. SDIRA holders may also invest in real estate, private debt, privately held companies or funds, or even cryptocurrency. SDIRAs give the investor control to choose which specific assets he believes will perform the most advantageously based on his own research, due diligence and risk tolerance. And similarly to any IRA, investors benefit from tax-deferred or tax-free growth on their investments.
There are a number of rules an investor must be aware of when considering investing in real estate through an SDIRA, like steering clear of “prohibited transactions” and not engaging in transactions with “disqualified persons.”
Disqualified persons are people or entities that cannot be involved in any direct or indirect deals, investments, or transactions with the SDIRA. These persons include the investor, any beneficiaries of the IRA, all family members, any of the IRA’s service providers, any entities (corporations, partnerships etc.) that are owned by a disqualified person, or officer, shareholder or employee of those entities. The investor cannot transfer SDIRA income, property, or investments to a disqualified person, or lend IRA money or to a disqualified person.
Prohibited transactions are those that earn the investor personal financial gain on the investment. The investor may not sell, exchange or lease their personal property to the SDIRA as an investment (a.k.a “double dealing”). Moreover, the investor cannot supply goods, services or facilities to disqualified persons or allow fiduciaries to use the SDIRA’s income or investment(s) for their own interest. In practicality, this means that if you own a construction company or are another type of service provider, the SDIRA cannot contract with your company to do work on the property or provide it with any service. All income from SDIRA assets must be put back in the IRA and the investor must make sure that all rental income from an investment property owned by the SDIRA is deposited in the SDIRA account, and not in his personal account. The investor is not even allowed to spend the night in their SDIRA-owned rental property.
The consequences of breaking these rules are immediate. If an IRA owner or their beneficiaries engage in a prohibited transaction, the account stops acting as an IRA as of the first day of that year. The law will look at it as if the IRA had distributed all its assets to the IRA holder at fair market value as of the first day of the year. When the total value of the former-SDIRA is more than the basis in the IRA – which was the investor’s goal – the owner will show a taxable gain that will be included in their income. Depending on the infringement, they may even be subject to penalties and interest.
Reach out to your financial advisor to learn if an SDIRA is the right tool for you.
This material has been prepared for informational purposes only, and is not intended to provide or be relied upon for legal or tax advice. If you have any specific legal or tax questions regarding this content or related issues, please consult with your professional legal or tax advisor.