Explore the aspects of financial modeling with the help of clear and easy-to-follow instructions and a variety of Excel features, functions, and productivity tips Key Features A non data professionals guide to exploring Excel's financial functions and pivot tables Learn to prepare various models for income and cash flow statements, and balance sheets Learn to perform valuations and identify growth drivers with real-world case studies Book DescriptionFinancial modeling is a core skill required by anyone who wants to build a career in finance. Hands-On Financial Modeling with Microsoft Excel 2019 examines various definitions and relates them to the key features of financial modeling with the help of Excel. This book will help you understand financial modeling concepts using Excel, and provides you with an overview of the steps you should follow to build an integrated financial model. You will explore the design principles, functions, and techniques of building models in a practical manner. Starting with the key concepts of Excel, such as formulas and functions, you will learn about referencing frameworks and other advanced components of Excel for building financial models. Later chapters will help you understand your financial projects, build assumptions, and analyze historical data to develop data-driven models and functional growth drivers. The book takes an intuitive approach to model testing, along with best practices and practical use cases. By the end of this book, you will have examined the data from various use cases, and you will have the skills you need to build financial models to extract the information required to make informed business decisions. What you will learn Identify the growth drivers derived from processing historical data in Excel Use discounted cash flow (DCF) for efficient investment analysis Build a financial model by projecting balance sheets, profit, and loss Apply a Monte Carlo simulation to derive key assumptions for your financial model Prepare detailed asset and debt schedule models in Excel Discover the latest and advanced features of Excel 2019 Calculate profitability ratios using various profit parameters Who this book is forThis book is for data professionals, analysts, traders, business owners, and students, who want to implement and develop a high in-demand skill of financial modeling in their finance, analysis, trading, and valuation work. This book will also help individuals that have and don't have any experience in data and stats, to get started with building financial models. The book assumes working knowledge with Excel.

Solve business challenges with Microsoft Power BI's advanced visualization and data analysis techniques Key Features Create effective storytelling reports by implementing simple-to-intermediate Power BI features Develop powerful analytical models to extract key insights for changing business needs Build, publish, and share impressive dashboards for your organization Book DescriptionTo succeed in today's transforming business world, organizations need business intelligence capabilities to make smarter decisions faster than ever before. This Power BI book is an entry-level guide that will get you up and running with data modeling, visualization, and analytical techniques from scratch. You'll find this book handy if you want to get well-versed with the extensive Power BI ecosystem. You'll start by covering the basics of business intelligence and installing Power BI. You'll then learn the wide range of Power BI features to unlock business insights. As you progress, the book will take you through how to use Power Query to ingest, cleanse, and shape your data, and use Power BI DAX to create simple to complex calculations. You'll also be able to add a variety of interactive visualizations to your reports to bring your data to life. Finally, you'll gain hands-on experience in creating visually stunning reports that speak to business decision makers, and see how you can securely share these reports and collaborate with others. By the end of this book, you'll be ready to create simple, yet effective, BI reports and dashboards using the latest features of Power BI. What you will learn Explore the different features of Power BI to create interactive dashboards Use the Query Editor to import and transform data Perform simple and complex DAX calculations to enhance analysis Discover business insights and tell a story with your data using Power BI Explore data and learn to manage datasets, dataflows, and data gateways Use workspaces to collaborate with others and publish your reports Who this book is forIf you're an IT manager, data analyst, or BI user new to using Power BI for solving business intelligence problems, this book is for you. You'll also find this book useful if you want to migrate from other BI tools to create powerful and interactive dashboards. No experience of working with Power BI is expected.

A comprehensive guide filled with best practices and tailor-made examples - a must-read for all Lightning Platform architects! Key Features Use the Lightning Platform to build integrated, scalable, and robust apps focused on enterprise-level customer demands Use the Lightning Component framework to deliver modern and responsive user experiences targeting multiple devices through Lightning Experience and Salesforce Mobile Extend your application with access to external services and AI Book DescriptionSalesforce Lightning provides a secure and scalable platform to build, deploy, customize, and upgrade applications. This book will take you through the architecture of building an application on the Lightning platform to help you understand its features and best practices, and ensure that your app keeps up with your customers' increasing needs as well as the innovations on the platform. This book guides you in working with the popular aPaaS offering from Salesforce, the Lightning Platform. You'll see how to build and ship enterprise-grade apps that not only leverage the platform's many productivity features, but also prepare your app to harness its extensibility and customization capabilities. You'll even get to grips with advanced application architectural design patterns such as Separation of Concerns, Unit Testing and Dependency Integration. You will learn to use Apex and JavaScript with Lightning Web Components, Platform Events, among others, with the help of a sample app illustrating patterns that will ensure your own applications endure and evolve with the platform. Finally, you will become familiar with using Salesforce DX to develop, publish, and monitor a sample app and experience standard application life cycle processes along with tools such as Jenkins to implement CI/CD. By the end of this book, you will have learned how to develop effective business apps and be ready to explore innovative ways to meet customer demands. What you will learn Create and deploy AppExchange packages and manage upgrades Understand Enterprise Application Architecture patterns Customize mobile and desktop user experience with Lightning Web Components Manage large data volumes with asynchronous processing and big data strategies Implement Source Control and Continuous Integration Add AI to your application with Einstein Use Lightning External Services to integrate external code and data with your Lightning Application Who this book is forThis book is for Lightning platform developers who want to discover the true potential of the platform to develop complex scalable applications for use in enterprise businesses.

Leverage the power of Tableau 2019.1's new features to create impactful data visualization Key Features Get up and running with the newly released features of Tableau 2019.1 Create enterprise-grade dashboard and reports to communicate your insights effectively Begin your Tableau journey by understanding its core functionalities Book DescriptionTableau is one of the leading data visualization tools and is regularly updated with new functionalities and features. The latest release, Tableau 2019.1, promises new and advanced features related to visual analytics, reporting, dashboarding, and a host of other data visualization aspects. Getting Started with Tableau 2019.1 will get you up to speed with these additional functionalities. The book starts by highlighting the new functionalities of Tableau 2019.1, providing concrete examples of how to use them. However, if you're new to Tableau, don't worry - you'll be guided through the major aspects of Tableau with relevant examples. You'll learn how to connect to data, build a data source, visualize your data, build a dashboard, and even share data online. In the concluding chapters, you'll delve into advanced techniques such as creating a cross-database join and data blending. By the end of this book, you will be able to use Tableau effectively to create quick, cost-effective, and business-efficient Business Intelligence (BI) solutions. What you will learn Discover new functionalities such as 'Ask Data', the new way to interact with your data using natural language Connect tables and make transformations such as pivoting the field and splitting columns Build an efficient data source for analysis Design insightful data visualization using different mark types and properties Develop powerful dashboards and stories Share your work and interact with Tableau Server Use Tableau to explore your data and find new insights Explore Tableau's advanced features and gear up for upcoming challenges Who this book is forExisting Tableau users and BI professionals who want to get up to speed with what's new in Tableau 2019 will find this beginner-level book to be a very useful resource. Some experience of Tableau is assumed, however, the book also features introductory concepts, which even beginners can take advantage of.

Take your SAP ABAP skills to the next level by mastering ABAP programming techniques with the help of real-world examples Key Features Become adept at building interfaces and explore ABAP tools and techniques Discover the modern functionalities available in the latest version of ABAP Learn the process of creating stunning HTML5 applications using SAPUI5 Book DescriptionAdvanced Business Application Programming (ABAP) is an established and complex programming language in the IT industry. This book is designed to help you use the latest ABAP techniques and apply legacy constructions using practical examples. You'll start with a quick refresher on language and database concepts, followed by agile techniques for adding custom code to a modern ABAP system. After this, you will get up to speed with the complete ABAP toolset for importing data to and from different environments. Next, you'll learn how to print forms and work with the different ABAP tools for Extensible Markup Language (XML) manipulation. While covering further chapters, you'll gain insights into building stunning UI5 interfaces, in addition to learning how to develop simple apps using the Business Object Processing Framework (BOPF). You will also pick up the technique of handling exceptions and performing testing in ABAP. In the concluding chapters, you can look forward to grasping various techniques for optimizing the performance of programs using a variety of performance analysis tools. By the end of this book, you will have the expertise you need to confidently build maintainable programs in Systems, Applications, and Products (SAP). What you will learn Create stable and error-free ABAP programs Leverage new ABAP concepts including object-oriented programming(OOP) and Model-View-Controller (MVC) Learn to add custom code to your existing SAP program Speed up your ABAP programs by spotting bottlenecks Understand techniques such as performance tuning and optimization Develop modern and beautiful user interfaces (UIs) in an ABAP environment Build multiple classes with any nesting level Who this book is forThis book is for developers who want to learn and use ABAP skills to become an industry expert. Familiarity with object-oriented programming concepts is expected.

Explore distributed ledger technology, decentralization, and smart contracts and develop real-time decentralized applications with Ethereum and Solidity Key Features Get to grips with the underlying technical principles and implementations of blockchain Build powerful applications using Ethereum to secure transactions and create smart contracts Gain advanced insights into cryptography and cryptocurrencies Book DescriptionBlockchain technology is a distributed ledger with applications in industries such as finance, government, and media. This Learning Path is your guide to building blockchain networks using Ethereum, JavaScript, and Solidity. You will get started by understanding the technical foundations of blockchain technology, including distributed systems, cryptography and how this digital ledger keeps data secure. Further into the chapters, you'll gain insights into developing applications using Ethereum and Hyperledger. As you build on your knowledge of Ether security, mining , smart contracts, and Solidity, you'll learn how to create robust and secure applications that run exactly as programmed without being affected by fraud, censorship, or third-party interference. Toward the concluding chapters, you'll explore how blockchain solutions can be implemented in applications such as IoT apps, in addition to its use in currencies. The Learning Path will also highlight how you can increase blockchain scalability and even discusses the future scope of this fascinating and powerful technology. By the end of this Learning Path, you'll be equipped with the skills you need to tackle pain points encountered in the blockchain life cycle and confidently design and deploy decentralized applications. This Learning Path includes content from the following Packt products: Mastering Blockchain - Second Edition by Imran Bashir Building Blockchain Projects by Narayan Prusty What you will learn Understand why decentralized applications are important Discover the mechanisms behind bitcoin and alternative cryptocurrencies Master how cryptography is used to secure data with the help of examples Maintain, monitor, and manage your blockchain solutions Create Ethereum wallets Explore research topics and the future scope of blockchain technology Who this book is forThis Learning Path is designed for blockchain developers who want to build decentralized applications and smart contracts from scratch using Hyperledger. Basic familiarity with any programming language will be useful to get started with this Learning Path.

This CRM masterclass gives you a proven approach to modern customer relationship management Key Features Proven techniques to architect CRM systems that perform well, that are built on time and on budget, and that deliver value for many years Combines technical knowledge and business experience to provide a powerful guide to CRM implementation Covers modern CRM opportunities and challenges including machine learning, cloud hosting, and GDPR compliance Book DescriptionCRM systems have delivered huge value to organizations. This book shares proven and cutting-edge techniques to increase the power of CRM even further. In The Art of CRM, Max Fatouretchi shares his decades of experience building successful CRM systems that make a real difference to business performance. Through clear processes, actionable advice, and informative case studies, The Art of CRM teaches you to design successful CRM systems for your clients. Fatouretchi, founder of Academy4CRM institute, draws on his experience over 20 years and 200 CRM implementations worldwide. Bringing CRM bang up to date, The Art of CRM shows how to add AI and machine learning, ensure compliance with GDPR, and choose between on-premise, cloud, and hybrid hosting solutions. If you're looking for an expert guide to real-world CRM implementations, this book is for you. What you will learn Deliver CRM systems that are on time, on budget, and bring lasting value to organizations Build CRM that excels at operations, analytics, and collaboration Gather requirements effectively: identify key pain points, objectives, and functional requirements Develop customer insight through 360-degree client view and client profiling Turn customer requirements into a CRM design spec Architect your CRM platform Bring machine learning and artificial intelligence into your CRM system Ensure compliance with GDPR and other critical regulations Choose between on-premise, cloud, and hybrid hosting solutions Who this book is forCRM practitioners who want to update their work with new, proven techniques and approaches

Build and deploy scalable applications on the Salesforce Lightning Platform using the latest features of Spring '19 Key Features An end-to end-guide with practice tests to help you achieve the Salesforce Platform Developer certification Design data models, user interfaces, and business logic for your custom applications Understand the complete development life cycle from designing to testing Book DescriptionSalesforce Lightning Platform, used to build enterprise apps, is being increasingly adopted by admins, business analysts, consultants, architects, and especially developers. With this Salesforce certification, you'll be able to enhance your development skills and become a valuable member of your organization. This certification guide is designed to be completely aligned with the official exam study guide for the latest Salesforce Certified Platform Developer I release and includes updates from Spring '19. Starting with Salesforce fundamentals and performing data modeling and management, you'll progress to automating logic and processes and working on user interfaces with Salesforce components. Finally, you'll learn how to work with testing frameworks, perform debugging, and deploy metadata, and get to grips with useful tips and tricks. Each chapter concludes with sample questions that are commonly found in the exam, and the book wraps up with mock tests to help you prepare for the DEV501 certification exam. By the end of the book, you'll be ready to take the exam and earn your Salesforce Certified Platform Developer I certification. What you will learn Solve sample questions and mock tests and work with exam patterns Gain an understanding of declarative Salesforce tools such as Process Builder, flows, and many more Code in Salesforce using the Developer Console and IDEs Grasp the basics of object-oriented programming Write Apex classes, Visualforce pages, and Apex test classes with easy-to-follow steps Explore the different deployment tools that you can use to push metadata to different environments Build custom declarative apps and programs on Force.com platforms Who this book is forThe Salesforce Platform Developer I Certification Guide is for you if you want to learn how to develop and deploy business logic and user interfaces using the capabilities of the Lightning Platform. No prior knowledge of Apex programming is required.