Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletter Hub
Free Learning
Arrow right icon
timer SALE ENDS IN
0 Days
:
00 Hours
:
00 Minutes
:
00 Seconds
Salesforce Reporting and Dashboards
Salesforce Reporting and Dashboards

Salesforce Reporting and Dashboards: Master the art of building successful reports and dashboards with this comprehensive guide

eBook
€28.99 €32.99
Paperback
€41.99
Subscription
Free Trial
Renews at $19.99p/m

What do you get with Print?

Product feature icon Instant access to your digital copy whilst your Print order is Shipped
Product feature icon Paperback book shipped to your preferred address
Product feature icon Redeem a companion digital copy on all Print orders
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR
Modal Close icon
Payment Processing...
tick Completed

Shipping Address

Billing Address

Shipping Methods
Table of content icon View table of contents Preview book icon Preview Book

Salesforce Reporting and Dashboards

Chapter 2. Managing Data in Salesforce.com

Data management plays an important role in implementing and maintaining a successful adoption of Salesforce.com in an organization. Using Salesforce reporting and dashboards, you can easily analyze the data stored in most objects. Therefore, bad data will produce a bad result, and the report generated will not be of any use. For this reason, it is very important for you to keep your data clean, complete, and reliable.

In this chapter we will be covering data management in Salesforce, starting with a brief introduction to data backup in Salesforce, how to back up, and why backup is needed. Then we will continue with Sandbox, the types of Sandboxes, and Sandbox refreshing.

Data import is another interesting topic in Salesforce. It shows how we can bring external data into Salesforce regularly or on demand. We will end this chapter with data visibility and accessibility in Salesforce.

Throughout this chapter, we will provide notes and tips...

Back up your data

In general, data backup is an activity of copying data and files from a source to media or devices. When you perform data backup properly, you should be able to restore data from the backup media in the event of data loss, such as device failure. Another purpose of data backup is to recover data from an earlier time because of invalid, deleted data or for audit purposes.

Data loss may cause critical issues and even financial losses for the company. Corporates should have their data backup and restoration planned as per their business needs, and should store the backup in a safe place.

Back up Salesforce data

How about a backup of Salesforce data? Are you able to back it up? Yes, you can back up Salesforce data. Although Salesforce is a cloud application, it does not mean you cannot back up your data and the configuration (metadata) in your local computer or server.

What is the need to back up our Salesforce data? Salesforce handles backup activity and disaster recovery, and...

Playing with Sandbox

A Sandbox in Salesforce is a snapshot of your production environment on the date you create or refresh it. A Sandbox instance is created in a separate environment for a variety of purposes such as development, testing, and training, without affecting the data and configurations in your Salesforce production instance.

Some people may consider Sandbox as a backup of production data and configuration at a point of time, but this is wrong because you usually will use Sandbox for other purposes such as coding, testing, quality assurance, and staging. Sandboxes should not be considered as data backups for the following reasons:

  • Full Sandbox refresh is limited to once every 29 days.
  • The full Sandbox is only included in the Unlimited and Performance editions. For all others, it has to be purchased as an add-on to your subscription.

The Sandbox should be nearly identical to your production data and configuration. You need to refresh the Sandbox to apply the latest production configuration...

Importing data to Salesforce

The ability to import data to Salesforce is important and it may be required quite often, depending on your business. We can split the data import process into manual and automatic. There are a few options to import data into Salesforce. Let's start with the most basic option.

Data Import Wizard

Data Import Wizard is an out-of-the-box tool provided by Salesforce to import accounts/contacts, leads, solutions, and custom objects data to Salesforce. This tool can process up to 50,000 records at a time. If you have a larger volume of data, you can split it into many files, or you can use other tools, which we will be discussing after this topic.

Before launching the wizard, you will need to prepare your data and save it in CSV (comma-separated values) file format. To use this tool, navigate to Setup | Data Management | Data Import Wizard:

  1. Choose data to import and select the object with any of these actions:
    • Add new records
    • Update existing records
    • Add new and update...

Configure data visibility and accessibility

Salesforce comes with complete functionalities for administrators to configure data secured as per your organization's needs. The way Salesforce works is by setting the object level with less access to all users. If the data needs to be accessible by groups of users, the administrator can configure rules to auto-share it. The other way round is not possible—you cannot give more access to everyone and then create rules to block the access.

There are two fundamental settings that determine user ability to access a record:

  • The Organization-Wide Defaults (OWD) sharing setting
  • User permission

The Organization-Wide Defaults (OWD) sharing setting is a fundamental setting for each object in Salesforce that is used to determine object visibility and accessibility. There are a few standard accessibilities that can be configured for each object, although some objects may have special settings. But in general, the default access option is available...

Summary

This chapter is primarily intended for Salesforce system administrators, but it is also good for business users to understand more of data management in Salesforce. In this chapter, we started with discussing data backup in Salesforce.com, how to back up, the tools available, and why we need to back up.

We continued to discuss the Salesforce Sandbox environment, type of Sandbox, and usage of each type of Sandbox. Next, you learned how to import data to Salesforce with the help of multiple tools.

At the end of the chapter, we highlighted items that determined user accessibility to a record, from record owner to manual and apex sharing.

The next chapter will be more interesting, as we will start building our very own Salesforce report.

Left arrow icon Right arrow icon

Description

This book is intended for all Salesforce users—administrators, managers, business analysts, or report writers who are new to creating reports or dashboards within Salesforce. Basic knowledge of the Salesforce platform is required.

Who is this book for?

This book is intended for all Salesforce users administrators, managers, business analysts, or report writers who are new to creating reports or dashboards within Salesforce. Basic knowledge of the Salesforce platform is required.

What you will learn

  • Understand and create multiple types of reports and dashboards from scratch
  • Assign permissions related to reports and dashboards
  • Get to grips with the Salesforce data architecture and its relation to reports
  • Get to know what a report folder is and how to use it
  • Understand and create custom report types from scratch
  • Use various components related to basic and advanced report configuration
  • Discover best practices to build and share reports and dashboards
  • Interface your dashboard to your mobile device app on the go
Estimated delivery fee Deliver to Germany

Premium delivery 7 - 10 business days

€17.95
(Includes tracking information)

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Mar 26, 2015
Length: 306 pages
Edition : 1st
Language : English
ISBN-13 : 9781784394677
Vendor :
Salesforce
Category :
Concepts :
Tools :

What do you get with Print?

Product feature icon Instant access to your digital copy whilst your Print order is Shipped
Product feature icon Paperback book shipped to your preferred address
Product feature icon Redeem a companion digital copy on all Print orders
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR
Modal Close icon
Payment Processing...
tick Completed

Shipping Address

Billing Address

Shipping Methods
Estimated delivery fee Deliver to Germany

Premium delivery 7 - 10 business days

€17.95
(Includes tracking information)

Product Details

Publication date : Mar 26, 2015
Length: 306 pages
Edition : 1st
Language : English
ISBN-13 : 9781784394677
Vendor :
Salesforce
Category :
Concepts :
Tools :

Packt Subscriptions

See our plans and pricing
Modal Close icon
$19.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
$199.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts
$279.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total 129.97
Salesforce CRM : The Definitive Admin Handbook - Third Edition
€45.99
Salesforce Reporting and Dashboards
€41.99
Salesforce.com customization handbook
€41.99
Total 129.97 Stars icon

Table of Contents

10 Chapters
1. Introducing Salesforce.com Chevron down icon Chevron up icon
2. Managing Data in Salesforce.com Chevron down icon Chevron up icon
3. Creating Your First Report Chevron down icon Chevron up icon
4. Working with Reports Chevron down icon Chevron up icon
5. Learning Advanced Report Configuration Chevron down icon Chevron up icon
6. Creating Your First Dashboard Chevron down icon Chevron up icon
7. Learning Advanced Dashboard Configuration Chevron down icon Chevron up icon
8. Accessing Historical Data Chevron down icon Chevron up icon
9. Dashboards and Reports in Salesforce1 Chevron down icon Chevron up icon
Index Chevron down icon Chevron up icon

Customer reviews

Top Reviews
Rating distribution
Full star icon Full star icon Full star icon Full star icon Half star icon 4.1
(9 Ratings)
5 star 33.3%
4 star 44.4%
3 star 22.2%
2 star 0%
1 star 0%
Filter icon Filter
Top Reviews

Filter reviews by




Amanda Peralta Apr 28, 2018
Full star icon Full star icon Full star icon Full star icon Full star icon 5
From beginners to advanced Salesforce users, this book is totally worth every penny! I am a super user and I purchased this book to help build bashboards and reports for our global sales team. I’ve found solutions to many of our reporting issues with this book! The only suggestion I have is there needs to be more formulas that can be customized to org needs. Other than that, I’d recommend this to any sales ops person using Salesforce as their CRM!
Amazon Verified review Amazon
adnan baloch May 30, 2015
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Anyone interested in creating reports and dashboards on the business platform of the CRM leader Salesforce will find this book invaluable. Readers begin their journey into the world of Salesforce with an introduction to the basic concepts of this popular SaaS platform. The two relationship models for defining the relationship between standard and custom objects are discussed using a practical approach with Schema Builder. Salesforce provides a data export functionality so the business organization can backup its data at regular intervals. Data import is a necessary feature that is available in the Salesforce cloud platform. The book also discusses the various types of Sandbox environments made available by Salesforce for experimenting without posing any threat to critical business data. The book shows how easy it is to create your own report from the available report types. Readers will appreciate the section about creating custom report types in the Report Builder. Sharing reports with managers and business executives is a pretty common activity in business organizations. The author lays out the steps required to export reports in popular formats like CSV and Excel. Practical examples are used to delineate report filters like filter logic and cross filter. Getting the list of dormant customers, for example, becomes easy with the cross filter. Readers are introduced to the concept of bucket fields that make it possible to create categories in a report based on specified criteria without having to make any changes in the account object. Dashboards are a convenient way to display multiple reports together in a visually aesthetic manner. Readers are guided through creating a dashboard from scratch as well as connecting the dashboard to Chatter for collaboration with other users. A chapter on advanced dashboard configuration takes readers through the steps necessary to implement dashboard filters, enabling them to display different combinations of data based on the selected filter which can number upto a maximum of three. Dashboards are always created based on the data visibility of a particular user. In cases where more flexibility is required, dynamic dashboards come into the picture. The book dedicates a whole chapter to detailing the historical trending and snapshot reporting features of Salesforce that enable managers to see how the data changes over time. The book ends with a brief chapter on the Salesforce1 mobile app that brings the excellent reporting capabilities of the Salesforce platform to any Android or iOS mobile device with internet access.
Amazon Verified review Amazon
R. Stowe May 02, 2017
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Excellent reference guide.
Amazon Verified review Amazon
John S. Kret Apr 21, 2017
Full star icon Full star icon Full star icon Full star icon Empty star icon 4
Wish my employer would give us more access so i could utilize this book.
Amazon Verified review Amazon
Nitin Wader May 06, 2015
Full star icon Full star icon Full star icon Full star icon Empty star icon 4
This book helps to understand intrinsic parts of reports and dashboard on Salesforce platform. I liked the way various report types explained in step by step manner. Advanced reporting , Reporting snapshot part is explained in very lucid manner.Author has also touched on historical data related part which is very important from SFDC admin related activities.Hands on provided at the end of each chapter are very useful. I strongly recommend this book who deals with SFDC reports & dashboards on daily basis.Grab your copy quickly !!!
Amazon Verified review Amazon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

What is the digital copy I get with my Print order? Chevron down icon Chevron up icon

When you buy any Print edition of our Books, you can redeem (for free) the eBook edition of the Print Book you’ve purchased. This gives you instant access to your book when you make an order via PDF, EPUB or our online Reader experience.

What is the delivery time and cost of print book? Chevron down icon Chevron up icon

Shipping Details

USA:

'

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

Economy: Can deliver to P. O. Boxes and private residences.
Trackable service with delivery to addresses in Australia only.
Delivery time ranges from 7-9 business days for VIC and 8-10 business days for Interstate metro
Delivery time is up to 15 business days for remote areas of WA, NT & QLD.

Premium: Delivery to addresses in Australia only
Trackable delivery to most P. O. Boxes and private residences in Australia within 4-5 days based on the distance to a destination following dispatch.

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Disclaimer:
All orders received before 5 PM U.K time would start printing from the next business day. So the estimated delivery times start from the next day as well. Orders received after 5 PM U.K time (in our internal systems) on a business day or anytime on the weekend will begin printing the second to next business day. For example, an order placed at 11 AM today will begin printing tomorrow, whereas an order placed at 9 PM tonight will begin printing the day after tomorrow.


Unfortunately, due to several restrictions, we are unable to ship to the following countries:

  1. Afghanistan
  2. American Samoa
  3. Belarus
  4. Brunei Darussalam
  5. Central African Republic
  6. The Democratic Republic of Congo
  7. Eritrea
  8. Guinea-bissau
  9. Iran
  10. Lebanon
  11. Libiya Arab Jamahriya
  12. Somalia
  13. Sudan
  14. Russian Federation
  15. Syrian Arab Republic
  16. Ukraine
  17. Venezuela
What is custom duty/charge? Chevron down icon Chevron up icon

Customs duty are charges levied on goods when they cross international borders. It is a tax that is imposed on imported goods. These duties are charged by special authorities and bodies created by local governments and are meant to protect local industries, economies, and businesses.

Do I have to pay customs charges for the print book order? Chevron down icon Chevron up icon

The orders shipped to the countries that are listed under EU27 will not bear custom charges. They are paid by Packt as part of the order.

List of EU27 countries: www.gov.uk/eu-eea:

A custom duty or localized taxes may be applicable on the shipment and would be charged by the recipient country outside of the EU27 which should be paid by the customer and these duties are not included in the shipping charges been charged on the order.

How do I know my custom duty charges? Chevron down icon Chevron up icon

The amount of duty payable varies greatly depending on the imported goods, the country of origin and several other factors like the total invoice amount or dimensions like weight, and other such criteria applicable in your country.

For example:

  • If you live in Mexico, and the declared value of your ordered items is over $ 50, for you to receive a package, you will have to pay additional import tax of 19% which will be $ 9.50 to the courier service.
  • Whereas if you live in Turkey, and the declared value of your ordered items is over € 22, for you to receive a package, you will have to pay additional import tax of 18% which will be € 3.96 to the courier service.
How can I cancel my order? Chevron down icon Chevron up icon

Cancellation Policy for Published Printed Books:

You can cancel any order within 1 hour of placing the order. Simply contact customercare@packt.com with your order details or payment transaction id. If your order has already started the shipment process, we will do our best to stop it. However, if it is already on the way to you then when you receive it, you can contact us at customercare@packt.com using the returns and refund process.

Please understand that Packt Publishing cannot provide refunds or cancel any order except for the cases described in our Return Policy (i.e. Packt Publishing agrees to replace your printed book because it arrives damaged or material defect in book), Packt Publishing will not accept returns.

What is your returns and refunds policy? Chevron down icon Chevron up icon

Return Policy:

We want you to be happy with your purchase from Packtpub.com. We will not hassle you with returning print books to us. If the print book you receive from us is incorrect, damaged, doesn't work or is unacceptably late, please contact Customer Relations Team on customercare@packt.com with the order number and issue details as explained below:

  1. If you ordered (eBook, Video or Print Book) incorrectly or accidentally, please contact Customer Relations Team on customercare@packt.com within one hour of placing the order and we will replace/refund you the item cost.
  2. Sadly, if your eBook or Video file is faulty or a fault occurs during the eBook or Video being made available to you, i.e. during download then you should contact Customer Relations Team within 14 days of purchase on customercare@packt.com who will be able to resolve this issue for you.
  3. You will have a choice of replacement or refund of the problem items.(damaged, defective or incorrect)
  4. Once Customer Care Team confirms that you will be refunded, you should receive the refund within 10 to 12 working days.
  5. If you are only requesting a refund of one book from a multiple order, then we will refund you the appropriate single item.
  6. Where the items were shipped under a free shipping offer, there will be no shipping costs to refund.

On the off chance your printed book arrives damaged, with book material defect, contact our Customer Relation Team on customercare@packt.com within 14 days of receipt of the book with appropriate evidence of damage and we will work with you to secure a replacement copy, if necessary. Please note that each printed book you order from us is individually made by Packt's professional book-printing partner which is on a print-on-demand basis.

What tax is charged? Chevron down icon Chevron up icon

Currently, no tax is charged on the purchase of any print book (subject to change based on the laws and regulations). A localized VAT fee is charged only to our European and UK customers on eBooks, Video and subscriptions that they buy. GST is charged to Indian customers for eBooks and video purchases.

What payment methods can I use? Chevron down icon Chevron up icon

You can pay with the following card types:

  1. Visa Debit
  2. Visa Credit
  3. MasterCard
  4. PayPal
What is the delivery time and cost of print books? Chevron down icon Chevron up icon

Shipping Details

USA:

'

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

Economy: Can deliver to P. O. Boxes and private residences.
Trackable service with delivery to addresses in Australia only.
Delivery time ranges from 7-9 business days for VIC and 8-10 business days for Interstate metro
Delivery time is up to 15 business days for remote areas of WA, NT & QLD.

Premium: Delivery to addresses in Australia only
Trackable delivery to most P. O. Boxes and private residences in Australia within 4-5 days based on the distance to a destination following dispatch.

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Disclaimer:
All orders received before 5 PM U.K time would start printing from the next business day. So the estimated delivery times start from the next day as well. Orders received after 5 PM U.K time (in our internal systems) on a business day or anytime on the weekend will begin printing the second to next business day. For example, an order placed at 11 AM today will begin printing tomorrow, whereas an order placed at 9 PM tonight will begin printing the day after tomorrow.


Unfortunately, due to several restrictions, we are unable to ship to the following countries:

  1. Afghanistan
  2. American Samoa
  3. Belarus
  4. Brunei Darussalam
  5. Central African Republic
  6. The Democratic Republic of Congo
  7. Eritrea
  8. Guinea-bissau
  9. Iran
  10. Lebanon
  11. Libiya Arab Jamahriya
  12. Somalia
  13. Sudan
  14. Russian Federation
  15. Syrian Arab Republic
  16. Ukraine
  17. Venezuela