Salesforce Reports and Dashboards - gettectonic.com
crm analytics

Build Better Tableau Dashboards

The effort made to build better Tableau dashboards pays tenfold in there readability and usability. “Dashboard design is not about making dashboards ‘pretty. It’s making them functional and helping the user to get the information they need as efficiently as possible.” ALEXANDER WALECZEK, ANALYTICS PRACTICE LEAD AND TABLEAU AMBASSADOR Effective communication with your audience involves considering their needs from start to finish. The key lies in posing the right questions. To convey information to your readers in an engaging manner, it is crucial to grasp fundamental aspects, such as: Possibly, when tailoring content for a time-pressed salesperson with only 15 seconds to spare for crucial performance indicators, it is imperative to present the most vital information in a glance. Additionally, ensuring that the dashboard is mobile-friendly and loads swiftly becomes essential. On the other hand, if your target audience consists of a team set to review quarterly dashboards over an extended period, offering more detailed views of the data might be advisable. Build Better Tableau Dashboards for Your Audience Take into account the expertise level of your audience. Gain a deeper understanding of their skill set by inquiring about their priorities and data consumption habits. This insight is crucial for determining the most effective way to present data, guiding key design decisions. For instance, a novice may require more action-oriented labels for filters or parameters compared to an advanced user. Here are four effective methods to assess the dashboard and data proficiency of your audience: Adjust Your Narrative Adjust your narrative accordingly. Tailoring your dashboards to suit the intended audience enhances their impact. Below are three visualizations depicting the distribution of tornadoes in the United States for the first nine months of the year. The distinction lies in the level of visual information employed to convey the narrative. There might e an extremely minimal presentation, progressing in complexity towards the right. None of these approaches is inherently superior to the others. The minimal visualization on the left might be ideal for audiences well-versed in the subject matter, appreciating simplicity and the elimination of redundancy. On the other hand, for newcomers or individuals viewing the visualization just once, the explicitness of the visualization on the right could be more effective. Determining what constitutes clutter versus essential information is where collaboration with colleagues becomes crucial. Crafting persuasive dashboards involves making a lasting impact on partnership. By closely collaborating with line-of-business stakeholders, you can secure the buy-in and engagement needed to tailor the dashboard to their specific requirements and expectations. This collaborative approach forms the essence of dashboard persuasion. A Work in Progress Demonstrate your process and embrace iterative refinement. Establishing a culture of analytics should be accompanied by a culture of supportive and frequent critique. Creating multiple versions of your work and actively seeking feedback throughout the process will contribute to a superior final product. Avoid isolation and stagnation; share your progress with others, use the feedback to refine your work, and repeat the process until you achieve a satisfactory result. Much like the formation of a diamond requiring extraordinary heat, pressure, and time, the outcome is worth the effort. Encouraging critiques is essential for cultivating a culture of constructive feedback. Trust among colleagues is important, arguably it enables mutual respect and trust in each other’s feedback. Developing a thick skin is also necessary, focusing on designing dashboards that cater to users and clients’ needs rather than personal preferences. Similar to writers who must “kill their darlings,” designers must prioritize the overall effectiveness of the dashboard, making honest assessments and adjustments when needed. “It also helps to have a public place—on a real or virtual wall—for sharing work. Making work public creates constant opportunities for feedback and improvements.” Tableau Like Related Posts Salesforce OEM AppExchange Expanding its reach beyond CRM, Salesforce.com has launched a new service called AppExchange OEM Edition, aimed at non-CRM service providers. Read more The Salesforce Story In Marc Benioff’s own words How did salesforce.com grow from a start up in a rented apartment into the world’s Read more Salesforce Jigsaw Salesforce.com, a prominent figure in cloud computing, has finalized a deal to acquire Jigsaw, a wiki-style business contact database, for Read more Health Cloud Brings Healthcare Transformation Following swiftly after last week’s successful launch of Financial Services Cloud, Salesforce has announced the second installment in its series Read more

Read More
Flexpricer and Optional Salesforce Line Items

Flexpricer and Optional Salesforce Line Items

If sales users are wasting time with the standard product selector while adding line items on Quotes and Opportunities in Salesforce, but treating them as optional, use Flexpricer’s Optional Line Items interface instead. Flexpricer and Optional Salesforce Line Items let users designate any line item for an opportunity or quote as optional. Flexpricer Benefits Flexpricer and Optional Salesforce Line Items What are Optional Line Items and Why are They Useful? In Sales Cloud, adding products to a Quote or Opportunity using the basic interface can be time-consuming and limited. Sales Cloud doesn’t offer functionality to easily mark products as additional or alternate. Flexpricer enhances Sales Cloud with Optional Line Items for Opportunities and Quotes. Sales Users can: Create Accurate Quotes in Salesforce Without specialized tools, creating quotes with optional line items is challenging and prone to pricing errors. Flexpricer’s Optional Line Items provides: Optional Line Items as Alternates Using the standard product selector in Sales Cloud, users struggle with adding line items for products that can be swapped out with others. With Flexpricer, selecting line items as alternates for upsell or replacements is easy: Standard Sales Cloud Objects Flexpricer uses standard Sales Cloud objects. Your Optional Line Items aren’t locked in custom objects requiring additional licenses. Optional Line Items are commonly used by companies to present alternate or additional line items on Quotes in Salesforce without contributing to the total amount. Like Related Posts Salesforce OEM AppExchange Expanding its reach beyond CRM, Salesforce.com has launched a new service called AppExchange OEM Edition, aimed at non-CRM service providers. Read more The Salesforce Story In Marc Benioff’s own words How did salesforce.com grow from a start up in a rented apartment into the world’s Read more Salesforce Jigsaw Salesforce.com, a prominent figure in cloud computing, has finalized a deal to acquire Jigsaw, a wiki-style business contact database, for Read more Health Cloud Brings Healthcare Transformation Following swiftly after last week’s successful launch of Financial Services Cloud, Salesforce has announced the second installment in its series Read more

Read More
Salesforce Success Story

Case Study: Higher Education Software Provider-Higher Education Intelligence-Salesforce Sales/Service/Experience Clouds

Salesforce in a Higher Education Intelligence Solutions Company Leveraging Salesforce to Support Acquisition and High Organic Growth Industry: Educational Technology Sales Cloud Service Cloud Experience Cloud salesforce higher ed software provider A Higher Education Software Provider, formed via multiple acquisitions, services more than 1,700 higher education institutions with educational solutions for assessment and accreditation planning, learning outcome, ePortfolios, faculty activity reporting, course evaluation and institutional surveys, and curriculum and catalog management.  Salesforce higher ed software provider. Salesforce Higher Ed Software Provider PROBLEM SOLUTION RESULT Like Related Posts Health Cloud Brings Healthcare Transformation Following swiftly after last week’s successful launch of Financial Services Cloud, Salesforce has announced the second installment in its series Read more 50 Advantages of Salesforce Sales Cloud According to the Salesforce 2017 State of Service report, 85% of executives with service oversight identify customer service as a Read more CRM Cloud Salesforce What is a CRM Cloud Salesforce? Salesforce Service Cloud is a customer relationship management (CRM) platform for Salesforce clients to Read more Salesforce Government Cloud: Ensuring Compliance and Security Salesforce Government Cloud public sector solutions offer dedicated instances known as Government Cloud Plus and Government Cloud Plus – Defense. Read more

Read More
better data better forecast

Joined Report in Salesforce

What is a joined report in Salesforce? A joined report in Salesforce consists of up to five report blocks , which you add to the report to create multiple views of your data. For each block, you can add regular and summary fields, create standard and cross-block custom summary formulas, apply filters, and sort columns.  A joined report can contain data from multiple standard or custom report types. What is the drawback of joined reports in Salesforce? Salesforce Joined report limitations A joined report in Salesforce is a report that allows you to show data that shares a relationship with one or more objects. Joined reports are often used when objects are not in parent-child relationships, such as Accounts and Opportunities. Advantages of Using Joined Reports What report types can be converted into joined reports? Like Related Posts Salesforce OEM AppExchange Expanding its reach beyond CRM, Salesforce.com has launched a new service called AppExchange OEM Edition, aimed at non-CRM service providers. Read more The Salesforce Story In Marc Benioff’s own words How did salesforce.com grow from a start up in a rented apartment into the world’s Read more Salesforce Jigsaw Salesforce.com, a prominent figure in cloud computing, has finalized a deal to acquire Jigsaw, a wiki-style business contact database, for Read more Health Cloud Brings Healthcare Transformation Following swiftly after last week’s successful launch of Financial Services Cloud, Salesforce has announced the second installment in its series Read more

Read More
public sector and tribal governent

What is BI in Salesforce?

Salesforce BI helps to create fast, digestible reports to help you make informed decisions at the right time. Salesforce Einstein is a leading business intelligence software solution that will help streamline your operations. Read on in this insight to learn how Salesforce BI capabilities including Tableau rank in the Gartner Magic Quadrant. Make the right decision every time using analytics that go beyond business intelligence software. See why Gartner named Salesforce (Tableau) a Leader in the Gartner® Magic Quadrant™ for Analytics and Business Intelligence Platforms for the 11th consecutive year. Data and analytics leaders must use analytics and BI platforms to support the needs of IT, analysts, consumers and data scientists. While integration with cloud ecosystems and business applications is a key selection requirement, buyers also need platforms to support openness and interoperability. Analytics and business intelligence (ABI) platforms enable less technical users, including business people, to model, analyze, explore, share and manage data, and collaborate and share findings, enabled by IT and augmented by artificial intelligence (AI). For several years, the Magic Quadrant for Analytic and Business Intelligence Platforms has emphasized visual self-service for end users augmented by AI to deliver automated insights. While this remains a significant use case, the ABI platform market will increasingly need to focus on the needs of the analytic content consumer and business decision makers. To achieve this, automated insights must be relevant in context of a user’s goals, actions and workflow. Many platforms are adding capabilities for users to easily compose low-code or no-code automation workflows and applications. This blend of capabilities is helping to expand the vision for analytics beyond simply delivering datasets and presenting dashboards. Today’s ABI platforms can deliver enriched contextualized insights, refocus attention on decision-making processes and ultimately take actions that will deliver business value. In addition to the increasing consumer design focus trend, we see other key market trends, including the need for improved governance of analytic content creation and dissemination, and the demand for a headless, open architecture. For example, a headless ABI platform would decouple the metrics store from the front-end presentation layer, enabling more interoperability with competitive products. ABI platform functionality includes the following 12 critical capabilities, which have been updated to reflect areas of market change, differentiation and customer demand: Gartner added three new critical capabilities as part of our metrics store evaluation criteria this year:  ABI platforms have always been about measurement. For decades, the slicing and dicing of measures by their dimensional attributes was synonymous with the act of performing business intelligence. However, over the last decade, the focus on metrics and measurement was overshadowed by data visualization. As data visualization became the most conspicuous capability, some business executives began to conflate ABI platforms with data visualization — as if ABI platforms are glorified chart wizards. This misconception minimizes much of the work performed and the business value delivered by ABI platforms. Establishing metrics stores as a critical capability to execute makes it clear that defining and communicating performance measures throughout an organization is one of the key purposes of an ABI platform. Analytics collaboration is a combination of many features (such as Slack/Teams integration, action frameworks) that collectively improve an organization’s ability to make decisions with consensus. Data science integration reflects the increasing likelihood that a business analyst may want to use data science to test certain hypotheses, and that data scientists will need to leverage features such as data prep and data visualization. In addition, Gartner is changing “catalogs” to “analytic catalogs” to emphasize a set of requirements that are not being met by ABI platform vendors today. Most large enterprises have thousands of reports built across multiple ABI platforms, but consumers in these organizations have no easy way to access these reports. The name change to analytic catalogs reflects the need for ABI platform vendors to deliver analytic content with the consumer in mind. Three critical capabilities were removed from our evaluation criteria: security, natural language generation (NLG; rolled into data storytelling) and cloud analytics (which will no longer be considered a platform capability, but instead a go-to-market strategy covered in the Magic Quadrant). And one of the security sub-criteria, about the granularity of authorization (e.g., row-based security) has been moved to the enterprise reporting capability. Salesforce (Tableau) Tableau, a Salesforce company, is a Leader in this Magic Quadrant. Its products are mainly focused on visual-based exploration that enables business users to access, prepare, analyze and present findings in their data. CRM Analytics, formerly Tableau CRM, provides augmented analytics capabilities for analysts and citizen data scientists. Tableau has global operations and serves clients of all sizes. In 2022, Tableau reinforced its augmented consumer vision to provide contextualized insights with deeper integration with Salesforce Data Cloud. IT also improved decision intelligence by bringing domain-aware insights into action with Revenue Intelligence and other Salesforce-native apps. The extensible design and x-platform integrations (Salesforce Flow, MuleSoft, UiPath and Looker) further enable composable analytics to bring insights into workflow with agility. Strengths Cautions Like Related Posts Salesforce OEM AppExchange Expanding its reach beyond CRM, Salesforce.com has launched a new service called AppExchange OEM Edition, aimed at non-CRM service providers. Read more The Salesforce Story In Marc Benioff’s own words How did salesforce.com grow from a start up in a rented apartment into the world’s Read more Salesforce Jigsaw Salesforce.com, a prominent figure in cloud computing, has finalized a deal to acquire Jigsaw, a wiki-style business contact database, for Read more Health Cloud Brings Healthcare Transformation Following swiftly after last week’s successful launch of Financial Services Cloud, Salesforce has announced the second installment in its series Read more

Read More
Salesforce

What is Advanced Reporting in Salesforce?

Cross Filters, Summary Formulas, and More: Advanced Reporting in Salesforce Salesforce comes with report types out-of-the-box for all standard objects and standard object relationships eg. “Contacts & Accounts” or “Opportunities with Products”. You can view a list of report types when creating a new report. For the custom objects we build, Salesforce also creates report types automatically. Salesforce Reporting is one of the most powerful features, used to give users many different views into their data, and for Admins to demonstrate the value Salesforce has upon the organization’s productivity. Building reports in the Lightning Report Builder, a drag and drop interface, is extremely effective – as a Salesforce Admin, you should have a solid idea of all the options available to you when reporting requirements come up. What are advanced reporting features in Salesforce? These are the tricks Salesforce power-users should know to ultimately create the reports users need – even with challenging data models – in the most efficient and scalable way (with minimal additional configuration). Let’s have a look at some of the more advanced reporting options that Salesforce offers. 1. Custom Report Types Salesforce provides out-of-the-box report types for standard objects and their relationships. When creating a new report, you can choose from a list of available report types. For custom objects, Salesforce automatically generates report types. These report types establish a “with” or “and” relationship based on whether the two objects have a Lookup or Master-detail relationship. Custom Report Types become essential when you need to report on: To create a custom report type: Bonus: You can now automatically add fields to Custom Report Types without manually adding them to each report type. 2. Cross Filters (Exception Reports) When filtering reports, Cross Filters help identify records with or without related records, creating exception reports. They are added like regular filters, using the format: “Show me — [primary object] — with/without — [related object].” Example: “Show me — Contacts — without — Campaign History.” Enhance Cross Filters with additional sub-filters to narrow down related records further. For instance, “Show me — Contacts — without — Activities — with status: ‘open’” will generate a report of contacts with no open activities. Salesforce Admins can master Cross Filters to avoid unnecessary creation of custom report types or rollup fields. 3. Summary Formulas Summary Formulas handle complex calculations at all summary levels, acting like fields once created. In Salesforce Lightning, they are referred to as Summary Formula Columns. To use them: Summary Formulas offer powerful capabilities for in-depth calculations. 4. Row-level Formulas Row-Level Formulas, distinct from Summary Formulas, are applied to single records and displayed on the row itself. An example is checking if two fields on the same record have the same value. 5. Reporting Snapshots Reporting Snapshots capture a snapshot of Salesforce records, freezing data for future reference. Commonly used for tracking Opportunity Pipeline Change over time. 6. Historical Trend Reporting Historical Trend Reporting glances back at historical field values on a specific date. Limited to certain objects and fields, it provides a targeted view of historical data changes. 7. Field-to-field Filters These filters allow the comparison of values in different fields on a Salesforce report, refining report filter criteria. 8. Stacked Summaries Stacked Summaries summarize extensive data for quick review and comparison, activated when adding fields to both rows and columns. 9. Joined Reports Joined Reports combine two reports with different report types into a single view, offering a holistic data view. 10. Report URL Hack Report URL Hacking is a technique to set filter values via URL parameters, supported in Lightning Experience. It allows dynamic filtering without the need for multiple reports, enhancing user experience. This URL hacking can be used to launch specific reports with predefined filters, adding efficiency to report navigation. Like1 Related Posts Salesforce OEM AppExchange Expanding its reach beyond CRM, Salesforce.com has launched a new service called AppExchange OEM Edition, aimed at non-CRM service providers. Read more The Salesforce Story In Marc Benioff’s own words How did salesforce.com grow from a start up in a rented apartment into the world’s Read more Salesforce Jigsaw Salesforce.com, a prominent figure in cloud computing, has finalized a deal to acquire Jigsaw, a wiki-style business contact database, for Read more Health Cloud Brings Healthcare Transformation Following swiftly after last week’s successful launch of Financial Services Cloud, Salesforce has announced the second installment in its series Read more

Read More
gettectonic.com