Informatyka
Excel. Wykresy, analiza danych, tabele przestawne. Niebieski podręcznik
Paul McFedries
Zaawansowana wiedza w zasięgu ręki! Excel to narzędzie należące do pakietu MS Office, charakteryzujące się nieskończoną cierpliwością w wykonywaniu najbardziej mozolnych i skomplikowanych obliczeń. Rozwijany od wielu lat, zdobył ogromną popularność i obecnie jest najbardziej znanym arkuszem kalkulacyjnym. Jego potencjał doceniają inżynierowie, księgowi, analitycy i studenci. Program znajduje zastosowanie wszędzie tam, gdzie są przechowywane i poddawane analizie ogromne zbiory danych. Świetnie sprawdza się też w roli kontrolera budżetu domowego. Chcesz poznać inne sposoby jego wykorzystania? Pomysłowość użytkowników nie zna granic! Ta książka pozwoli Ci dogłębnie poznać najbardziej zaawansowane funkcje Excela. Tworzenie skomplikowanych wykresów i tabel przestawnych już nigdy nie będzie dla Ciebie problemem. Dowiesz się z niej, jak tworzyć formuły na potrzeby analizy danych oraz jak ominąć typowe trudności. Nauczysz się też analizować dane finansowe oraz statystyczne. Po zdobyciu tych umiejętności przejdziesz do zagadnień związanych z filtrowaniem danych oraz ich sortowaniem. Na sam koniec zapoznasz się z różnymi technikami analizy, poznasz narzędzie Solver oraz dodatek Analysis ToolPak. Zobaczysz także, jak zaimportować dane z innych źródeł lub skorzystać z kwerend bazodanowych. Książka ta jest doskonałym źródłem wiedzy dla wszystkich użytkowników Excela, którzy chcą wykorzystać w pełni jego możliwości. W książce znajdziesz ponad 150 technik analizy danych w Excelu. Oto wybrane z tych metod: Tworzenie formuł tablicowych Wykrywanie błędów w formułach Określanie lokalizacji wartości Obliczanie amortyzacji metodą liniową Tworzenie rozkładu częstości dla grup wartości Przekształcanie zakresów na tabele Analizowanie wartości komórek Wykreślanie linii trendu logarytmicznego Przeprowadzanie analizy regresji Tworzenie tabel przestawnych i wykresów Najlepsze techniki analizy danych podane na tacy!
Jason Brown
Ransomware, phishing, and data breaches are major concerns affecting all organizations as a new cyber threat seems to emerge every day, making it paramount to protect the security of your organization and be prepared for potential cyberattacks. This book will ensure that you can build a reliable cybersecurity framework to keep your organization safe from cyberattacks.This Executive’s Cybersecurity Program Handbook explains the importance of executive buy-in, mission, and vision statement of the main pillars of security program (governance, defence, people and innovation). You’ll explore the different types of cybersecurity frameworks, how they differ from one another, and how to pick the right framework to minimize cyber risk. As you advance, you’ll perform an assessment against the NIST Cybersecurity Framework, which will help you evaluate threats to your organization by identifying both internal and external vulnerabilities. Toward the end, you’ll learn the importance of standard cybersecurity policies, along with concepts of governance, risk, and compliance, and become well-equipped to build an effective incident response team.By the end of this book, you’ll have gained a thorough understanding of how to build your security program from scratch as well as the importance of implementing administrative and technical security controls.
Expert Android Programming. Master skills to build enterprise grade Android applications
Prajyot Mainkar
Android O brings a number of important changes for the users as well as the developers. If you want to create smart android applications which are fast, lightweight and also highly efficient then this is the book that will solve all your problems. You will create a complex enterprise grade app in this book. You will get a quick refresher of the latest android SDK and how to configure your development environment. Then you will move onto creating app layouts, component and module building, creating smart and efficient UIs. The most important part of a modern day app is how real time they are. With this book, you will create a smooth back-end for your app, ensure dynamic and real time communication between different app layers. As we move on, you will learn to leverage the different Android APIs and create an efficient SQLite data layer for your apps. You will implement effective testing techniques to make your app reliable and robust and finally you will learn to deploy it efficiently. The multiple stages of android development will also be simplified by giving you an industry standard set of best practices.
Expert Angular. Build deep understanding of Angular to set you apart from the developer crowd
Sridhar Rao Chivukula
Got some experience of Angular under your belt? Want to learn everything about using advanced features for developing websites? This book is everything you need for the deep understanding of Angular that will set you apart from the developer crowd.Angular has introduced a new way to build applications. Creating complex and rich web applications, with a lighter resource footprint, has never been easier or faster. Angular is now at release 4, with significant changes through previous versions. This book has been written and tested for Angular release 4.Angular is a mature technology, and you'll likely have applications built with earlier versions. This book starts by showing you best practices and approaches to migrating your existing Angular applications so that you can be immediately up-to-date. You will take an in-depth look at components and see how to control the user journey in your applications by implementing routing and navigation. You will learn how to work with asynchronous programming by using Observables.To easily build applications that look great, you will learn all about template syntax and how to beautify applications with Material Design. Mastering forms and data binding will further speed up your application development time. Learning about managing services and animations will help you to progressively enhance your applications. Next you’ll use native directives to integrate Bootstrap with Angular. You will see the best ways to test your application with the leading options such as Jasmine and Protractor. At the end of the book, you’ll learn how to apply design patterns in Angular, and see the benefits they will bring to your development.
Atul Mistry
Expert AWS Development begins with theinstallation of the AWS SDK and you will goon to get hands-on experience of creatingan application using the AWS ManagementConsole and the AWS Command LineInterface (CLI). Then, you will integrateapplications with AWS services such asDynamoDB, Amazon Kinesis, AWS Lambda,Amazon SQS, and Amazon SWF.Following this, you will get well versed withCI/CD workflow and work with four majorphases in the release process – Source,Build, Test, and Production. Then, you willlearn to apply AWS Developer tools to yourContinuous Integration (CI) and ContinuousDeployment (CD) workflow. Later, youwill learn about user authentication usingAmazon Cognito, and also how you canevaluate the best architecture as per yourinfrastructure costs. You will learn aboutAmazon EC2 service and will deploy anapp using it. You will also deploy a practicalreal-world example of a CI/CD applicationwith the Serverless Application Framework,which is known as AWS Lambda.Finally, you will learn how to build, develop,and deploy the Application using AWSDeveloper tools such as AWS CodeCommit,AWS CodeBuild, AWS CodeDeploy, andAWS CodePipeline, as per your projectrequirements.
Chris Webb, Alberto Ferrari, Marco Russo
Microsoft's SQL Server Analysis Services 2008 is an OLAP server that allows users to analyze business data quickly and easily. However, designing cubes in Analysis Services can be a complex task: it's all too easy to make mistakes early on in development that lead to serious problems when the cube is in production. Learning the best practices for cube design before you start your project will help you avoid these problems and ensure that your project is a success.This book offers practical advice on how to go about designing and building fast, scalable, and maintainable cubes that will meet your users' requirements and help make your Business Intelligence project a success.This book gives readers insight into the best practices for designing and building Microsoft Analysis Services 2008 cubes. It also provides details about server architecture, performance tuning, security, and administration of an Analysis Services solution.In this book, you will learn how to design and implement Analysis Services cubes. Starting from designing a data mart for Analysis Services, through the creation of dimensions and measure groups, to putting the cube into production, we'll explore the whole of the development lifecycle.This book is an invaluable guide for anyone who is planning to use Microsoft Analysis Services 2008 in a Business Intelligence project.
Expert Delphi. Robust and fast cross-platform application development
Paweł Głowacki
Delphi is the most powerful Object Pascal IDE and component library for cross-platform native app development. It enables building natively compiled, blazingly fast apps for all major platforms including Android, iOS, Windows, Mac, and Linux.If you want to build server-side applications, create web services, and have clear GUIs for your project, then this book is for you. The book begins with a basic primer on Delphi helping you get accustomed to the IDE and the Object Pascal language and will then quickly move on to advanced-level concepts. Through this book, we’ll help you understand the architecture of applications and will teach you the important concepts of the FireMonkey library, show you how to build server-side services, and enable you to interact with the Internet of Things. Towards the end, you will learn to integrate your app with various web services and deploy them. By the end of the book, you will be able to build powerful, cross-platform, native apps for iOS and Android with a single code base.
Expert Delphi. Robust and fast cross-platform application development - Second Edition
Marco Cantu, Paweł Głowacki, Stephen Ball
Master Delphi, the most powerful Object Pascal IDE and versatile component library for cross-platform native app development, by harnessing its capabilities for building natively compiled, blazingly fast apps for all major platforms, including Android, iOS, Windows, Mac, and Linux.Expert Delphi begins with a quick overview of Delphi, helping you get acquainted with the IDE and the Object Pascal language. The book then quickly progresses to more advanced concepts, followed by the architecture of applications and the FireMonkey library, guiding you through building server-side services, parallel programming, and database access. Toward the end, you’ll learn how to integrate your app with various web services and deploy them effectively.By the end of this book, you’ll be adept at building powerful, cross-platform, native apps for iOS, Android, Windows, and macOS—all from a single code base.