Found 420 bookmarks
Newest
Power BI Report Delivery: Scheduling, Broadcasting and Bursting Explained
Power BI Report Delivery: Scheduling, Broadcasting and Bursting Explained
Enterprise reporting plays a pivotal role in regular operations, enabling organizations to track performance metrics and communicate effectively with both internal teams and external stakeholders. Accurate and timely reporting is critical for driving decisions that positively impact business outcomes. Throughout this eBook, we will explore how to leverage these capabilities with real-world examples. You will learn how to create recurring schedules with flexible frequency options, broadcast reports to different user groups, and apply custom filters and bookmarks to tailor content for each recipient. Additionally, you will learn how to export high-resolution PDFs, include executive scorecards within emails, and schedule reports with complex datasets containing hundreds of charts and tables.
·inforiver.com·
Power BI Report Delivery: Scheduling, Broadcasting and Bursting Explained
Power BI implementation planning: Develop content and manage changes - Power BI
Power BI implementation planning: Develop content and manage changes - Power BI
This article helps you to develop content and manage changes as part of managing the content lifecycle.
Group changes into distinct releases with version history.
Depending on how you author content, you'll make different decisions about how to manage it. For instance, for Power BI reports and semantic models, a Power BI Desktop (.pbix) file has fewer options for version control compared to the Power BI Desktop project (.pbip) format. That's because a .pbix file is a binary format, whereas the .pbip format contains text-based human-readable content and metadata. Having human-readable content and metadata allows for easier tracking of model and report changes by using source control. Source control is when you view and manage changes within content to its code and metadata
Excel: A client tool for pivot tables and live connected tables that work with a semantic model. Power BI Report Builder: A desktop application for creating paginated report (.rdl) files.
You can develop and test content without affecting the content that's currently in use. This avoids changes that can cause unintentional disruption to content in production. You can use separate resources for developing and testing content, like using separate data gateways or Fabric capacities. This avoids that resources used for development and testing disrupts production workloads, causing slow data refreshes or reports. You can create a more structured process to develop, test, and release content by having discrete environments for each of these stages. This helps you to improve productivity.
Test and production workspaces
Private workspace with Git integration When delivering business-critical content, each developer can also use their own, private workspace for development. In this scenario, a private workspace allows content creators to test content in the Fabric portal, or use features like scheduled refresh without risking disruption to others in the development team. Content creators can also develop content in the Fabric portal here, such as dataflows. Private workspaces can be a good choice when you are managing content changes by using Git integration together with Azure DevOps.
Alerts: You should set up alerts for when others add, remove, or modify critical files. Scope: Clearly define the scope of the remote storage location. Ideally, the scope of the remote storage location is identical to the scope of the downstream workspaces and apps that you use to deliver content to consumers. Access: You should set up access to the remote storage location by using a similar permissions model as you have set up for your deployment pipeline permissions and workspace roles. Content creators need access to the remote storage location. Documentation: Add text files to the remote storage location to describe the remote storage location and its purpose, ownership, access, and defined processes.
Fabric Git integration has some limitations with the supported items and scenarios. Ensure that you first validate whether Fabric Git integration best suits your specific scenario, or whether you should take a different approach to implement source control.
Use branches Content creators achieve collaboration by using a branching strategy. A branching strategy allows individual content creators to work in isolation in their local repository. When ready, they combine their changes as a single solution in the remote repository. Content creators should scope their work to branches by linking them to work items for specific developments, improvements, or bug fixes. Each content creator creates their own branch of the remote repository for their scope of work. Work done on their local solution is committed and pushed to a version of the branch in the remote repository with a descriptive commit message. A commit message describes the changes made in that commit.
·learn.microsoft.com·
Power BI implementation planning: Develop content and manage changes - Power BI
Power BI implementation planning: Plan and design content - Power BI
Power BI implementation planning: Plan and design content - Power BI
This article helps you to plan and design content as part of managing the content lifecycle.
You typically start the content lifecycle by performing BI solution planning. You gather requirements to understand and define the problem that your solution should address, and arrive at a solution design. During this planning and design stage, you make key decisions to prepare for the later stages.
Which item types do you expect to create, and how many of each? For instance, will you create data items like dataflows or semantic models, reporting items like reports or dashboards, or a combination of both? How is the content delivered to content consumers? For instance, will consumers use data items to build their own content, will they only view centralized reports, or a combination of both? How complex is the content? For instance, is it a small prototype, or a large semantic model that encompasses multiple business processes? Do you expect the scale, scope, and complexity of the content to grow over time? For instance, will the content encompass other regions or business areas in the future? How long do you expect the business to need this content? For instance, will this content support a key initiative of the business that has a finite timeline?
·learn.microsoft.com·
Power BI implementation planning: Plan and design content - Power BI
Being a PM at Microsoft: Influencing without authority
Being a PM at Microsoft: Influencing without authority
Influencing without authority is a fundamental PM skill and activity. What are the key factors and behaviors that will help you more consistently enlist the help of others to achieve your common go…
·ssbipolar.com·
Being a PM at Microsoft: Influencing without authority
Data Culture: Becoming a data fencing master
Data Culture: Becoming a data fencing master
We’re back with another data culture post and video with swords, and this time we’re bringing out the big blade. This time we’re bringing out the montante. In the 1500s and 1600s …
·ssbipolar.com·
Data Culture: Becoming a data fencing master
Data Culture: Self-service BI as a two-edged sword
Data Culture: Self-service BI as a two-edged sword
There’s a new data culture video! After I finished my 2020 video and blog series on building a data culture, I figured I would revisit this topic at some point. I didn’t expect it to ta…
·ssbipolar.com·
Data Culture: Self-service BI as a two-edged sword
Power BI implementation planning: BI tactical planning - Power BI
Power BI implementation planning: BI tactical planning - Power BI
This article helps you to identify your business intelligence objectives and form actionable plans to achieve incremental progress toward your strategic BI goals.
When you identify objectives, also consider how you can objectively evaluate and measure their impact. It's critical that you accurately describe the (potential) return on investment (ROI) for BI initiatives in order to attain sufficient executive support and resources. You can assess this impact together with your measures of success for your BI strategy.
First, identify your adoption objectives. These objectives can address many areas, but typically describe the actions you'll take to improve overall organizational adoption and data culture.
Define organizational readiness As described in the previous sections, the objectives you identify must be achievable. You should assess your organizational readiness to evaluate how prepared the organization is to achieve the objectives you've identified. Assess organizational readiness by considering the factors described in the following sections.
Here are some examples of obstacles. System migrations and other ongoing technical initiatives Business processes and planning, like fiscal year budgets Business mergers and restructuring Availability of stakeholders Availability of resources, including the available time of central team members Skills of central team members and business users Communication and change management activities to adequately inform and prepare business users about
Assess the necessary skills and knowledge
Improving the skills and competences of internal teams is particularly important when you migrate to Fabric or Power BI from other technologies. Don't rely exclusively on external consultants for these migrations. Ensure that internal team members have sufficient time and resources to upskill, so they'll work effectively with the new tools and processes.
Define and measure success
Step 3: Periodically revise the plan The business and technology context of your organization regularly changes. As such, you should periodically reevaluate and reassess your BI strategy and tactical planning. The goal is to keep them relevant and useful for your organization. In step 3 of tactical planning, you take practical steps to iteratively reevaluate and reassess planning. Prepare iterative planning and anticipate change To ensure BI and business strategic alignment, you should establish continuous improvement cycles. These cycles should be influenced by the success criteria (your KPIs or OKRs) and the feedback that you regularly collect to evaluate progress. We recommend that you conduct tactical planning at regular intervals with evaluation and assessment, as depicted in the following diagram
Schedule business alignment meetings:
Review feedback and requests: Feedback and requests from the user community is valuable input to reevaluate your BI strategy. Consider setting up a communication hub, possibly with channels like office hours, or feedback forms to collect feedback.
A BI strategy is a plan to implement, use, and manage data and analytics. You define your BI strategy by starting with BI strategic planning
To work toward your BI goals, the working team defines specific objectives by doing tactical planning
This process shifts the focus from strategic planning to tactical planning.
start, we recommend that you first address time-sensitive, quick-win, and high-impact objectives.
successful implementation of your BI strategy is more likely when you aim for an evolution instead of a revolution from your current state. Evolution implies that you strive for gradual change over time. Small but consistent, sustained progress is better than an abundance of change that risks disruption to ongoing activities.
curating this backlog for your implementation objectives, consider the following points. Justify the prioritization of the initiative or solution. Approximate the effort involved, if possible. Outline the anticipated scope.
·learn.microsoft.com·
Power BI implementation planning: BI tactical planning - Power BI
The Future of Business Intelligence Part 2: Dismantling the Supply Chain and Planting the Forest.
The Future of Business Intelligence Part 2: Dismantling the Supply Chain and Planting the Forest.
A new era of Business Intelligence requires new ways of thinking about and delivering insights. Gone is the just-in-time churn of endless dashboards! Read on to see what takes its place.
outgrows its roots simply falls over. Wave 3 of business intelligence is about a balanced approach to insight generation and distribution. It is not focused on needless growth and does not derive its value from the sheer amount of charts created, but rather its veracity and total value added.
Circulatory: If sap flows in only one direction the data tree dies. Wave 3 must support bi-directional interaction with decision makers and downstream systems to create feedback loops to drive growth and change. This must be built into the DNA of the tool.
So what the heck does this actually mean? The biggest set of changes I see coming for Wave 3 is the backswing of the ‘centralization - distribution’ technology pendulum into a place of balance, where the BI tool is a self-service insight generation platform that easily feeds into other important data processes, instead of being a black-box end point for the data supply chain.
To support this the platform must grow beyond just presenting dashboards. It needs to have an open, headless metrics store to feed AI/ML and apps
Data quality is going to matter even more than it does today, because of how compelling ChatGPT’s answers sound to humans. If your data sucks, it will very confidently give you sucky responses.
There is going to be a major ‘trough of disillusionment’ with this tech when it gets widely implemented in BI and 3% of its answers
A lot of firms may have very poor training data that results in very poor performance and a very bad initial impression.
Rooted: Just as a data tree grows best in great soil, Wave 3 requires an accurate foundation of clearly defined, valuable metrics that can feed any upstream process - whether that’s traditional BI, AI/ML or analytic/operational apps. These metrics are the foundation of balanced self-service.
·superdatablog.substack.com·
The Future of Business Intelligence Part 2: Dismantling the Supply Chain and Planting the Forest.
Power BI adoption roadmap conclusion - Power BI
Power BI adoption roadmap conclusion - Power BI
A conclusion and extra resources of the Power BI adoption roadmap series of articles.
Everything correlates together: As you progress through each of the steps listed above, it's important that everything's correlated from the high-level strategic organizational objectives, all the way down to more detailed action items. That way, you'll know that you're working on the right things.
e
·learn.microsoft.com·
Power BI adoption roadmap conclusion - Power BI
Lenskart transforms the way it eyes data using Power BI
Lenskart transforms the way it eyes data using Power BI
A direct-to-consumer omnichannel retailer, Lenskart, is one of the fastest-growing e-commerce-led eyewear retail chains in the world. It has over 1,100 stores in India and a growing presence in East Asia, Southeast Asia, the Middle East, and the US.Lenskart aims at giving a clearer vision to 1 billion people globally from children to adults. Its eyewear range offers a variety of lifestyle extensions and unique identities for athletes, working professionals, artists, support workers etc.
·customers.microsoft.com·
Lenskart transforms the way it eyes data using Power BI
Introduction to Data Clean Rooms
Introduction to Data Clean Rooms
Explore what data clean rooms are, why they're important, and how your organization can implement them in Snowflake - all in this blog!
·phdata.io·
Introduction to Data Clean Rooms
Reference Architecture for the “Landing Zone”, your indispensable foundation for scaling Power Platform — Andrew D Welch
Reference Architecture for the “Landing Zone”, your indispensable foundation for scaling Power Platform — Andrew D Welch
The Power Platform Landing Zone is the beginning of the path to overcoming these barriers. A foundation, if you will, the Landing Zone is the initial technical infrastructure plus governance of that infrastructure that allows an organization to begin “landing” workloads in Power Platform. With that
·andrewdwelch.com·
Reference Architecture for the “Landing Zone”, your indispensable foundation for scaling Power Platform — Andrew D Welch