Informatyka
Excel Web App - Opracowanie grupowa w chmurze
Piotr Dynia
Przesyłanie raportu w załączniku wiadomości e-mail to przeżytek. Dzięki możliwością pracy w chmurze SkyDrive, efekty swoich analiz można udostępniać innym użytkownikom i współdzielić z nimi pracę, nawet jeżeli nie mają dostępu do pakietu MS Office. Publikacja zawiera szczegółowe wskazówki ekspertów dotyczące pracy grupowej z wykorzystaniem technologii chmury (cloud computing). Doradzamy, w jaki sposób usprawnić pracę grupową nad projektami i zadaniami bez ponoszenia dodatkowych kosztów.
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!
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.
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.
Marco Russo, Chris Webb, Alberto Ferrari, Marco...
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.
Soheil Bakhshi, Christian Wade
This book is a comprehensive guide to understanding the ins and outs of data modeling and how to create full-fledged data models using Power BI confidently.In this new, fully updated edition, you'll learn how to connect data from multiple sources, understand data, define and manage relationships between data, and shape data models to gain deep and detailed insights about your organization. As you advance through the chapters, the book will demonstrate how to prepare efficient data models in the Power Query Editor and use simpler DAX code with new data modeling features. You'll explore how to use the various data modeling and navigation techniques and perform custom calculations using the modeling features with the help of real-world examples. Finally, you'll learn how to use some new and advanced modeling features to enhance your data models to carry out a wide variety of complex tasks. Additionally, you'll learn valuable best practices and explore common data modeling complications and the solutions to supercharge the process of creating a data model in Power BI and build better-performing data models.By the end of this Power BI book, you'll have gained the skills you need to structure data coming from multiple sources in different ways to create optimized data models that support high-performing reports and data analytics.
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.
Dirk Merkel
Even if you find writing PHP code easy, writing code that is efficient and easy to maintain and reuse is not so straightforward. Self-taught PHP developers and programmers transitioning from other languages often lack the knowledge to work with PHP on an enterprise level. They need to take their PHP development skills to that level by learning the skills and tools necessary to write maintainable and efficient code.This book will enable you to take your PHP development skills to an enterprise level by teaching you the skills and tools necessary to write maintainable and efficient code. You will learn how to perform activities such as unit testing, enforcing coding standards, automating deployment, and interactive debugging using tools created for PHP developers – all the information in one place. Your code will be more maintainable, efficient, and self-documented.From the design phase to actually deploying the application, you will learn concepts and apply them using the best-of-breed tools available in PHP.Experienced developers looking for expertise in PHP development will learn how to follow best practices within the world of PHP. The book contains many well-documented code samples and recipes that can be used as a starting point for producing quality code.Specifically, you will learn to design an application with UML, code it in Eclipse with PDT, document it with phpDocumentor, debug it interactively with Xdebug, test it by writing PHPUnit tests, manage source code in Subversion, speed up development and increase stability by using Zend Framework, pull everything together using continuous integration, and deploy the application automatically with Phing – all in one book. The author's experience in PHP development enables him to share insights on using enterprise tools, in a clear and friendly way.
Kevin Wilson
This course takes you on a journey through the intricate world of computer hardware, beginning with a solid foundation in the fundamentals of computing. Starting with an overview of computers and microcomputers, you’ll explore the core components that make up these machines, including embedded systems, software, and peripherals. Each chapter is designed to build your understanding of how these elements work together to create the technology we rely on daily.As you progress, the course delves into more complex topics like computer networks, the Internet, and cloud computing. You’ll gain insights into how hardware interacts with software and the critical role of security in maintaining the integrity of systems. Additionally, the course covers binary numbers, Boolean logic, and other essential concepts that underpin modern computing, offering a comprehensive understanding of both theoretical and practical aspects.By the end of this course, you’ll have a thorough knowledge of not just the hardware components but also the data processes like encryption, compression, and storage that ensure efficient and secure computing. Whether you're a beginner or someone with some background in technology, this course provides the knowledge and skills necessary to navigate and understand the complex world of computer hardware.
Bryan Lyon, Matt Tora
Applying Deepfakes will allow you to tackle a wide range of scenarios creatively.Learning from experienced authors will help you to intuitively understand what is going on inside the model. You’ll learn what deepfakes are and what makes them different from other machine learning techniques, and understand the entire process from beginning to end, from finding faces to preparing them, training the model, and performing the final swap.We’ll discuss various uses for face replacement before we begin building our own pipeline. Spending some extra time thinking about how you collect your input data can make a huge difference to the quality of the final video. We look at the importance of this data and guide you with simple concepts to understand what your data needs to really be successful.No discussion of deepfakes can avoid discussing the controversial, unethical uses for which the technology initially became known. We’ll go over some potential issues, and talk about the value that deepfakes can bring to a variety of educational and artistic use cases, from video game avatars to filmmaking.By the end of the book, you’ll understand what deepfakes are, how they work at a fundamental level, and how to apply those techniques to your own needs.
Exploring Experience Design. Fusing business, tech, and design to shape customer engagement
Ezra Schwartz
We live in an experience economy in which interaction with products is valued more than owning them. Products are expected to engage and delight in order to form the emotional bonds that forge long-term customer loyalty:Products need to anticipate our needs and perform tasks for us: refrigerators order food, homes monitor energy, and cars drive autonomously; they track our vitals, sleep, location, finances, interactions, and content use; recognize our biometric signatures, chat with us, understand and motivate us. Beautiful and easy to use, products have to be fully customizable to match our personal preferences.Accomplishing these feats is easier said than done, but a solution has emerged in the form of Experience design (XD), the unifying approach to fusing business, technology and design around a user-centered philosophy.This book explores key dimensions of XD: Close collaboration among interdisciplinary teams, rapid iteration and ongoing user validation. We cover the processes, methodologies, tools, techniques and best-practices practitioners use throughout the entire product development life-cycle, as ideas are transformed to into positive experiences which lead to perpetual customer engagement and brand loyalty.
David Ringstrom
David Ringstrom coined the phrase “Either you work Excel, or it works you!” after observing how many users carry out tasks inefficiently.In this book, you’ll learn how to get more done with less effort. This book will enable you to create resilient spreadsheets that are easy for others to use as well, while incorporating spreadsheet disaster preparedness techniques. The time-saving techniques covered in the book include creating custom shortcuts and icons to streamline repetitive tasks, as well as automating them with features such as Tables and Custom Views. You’ll see how Conditional Formatting enables you to apply colors, Cell icons, and other formatting on-demand as your data changes. You’ll be empowered to protect the integrity of spreadsheets and increase usability by implementing internal controls, and understand how to solve problems with What-If Analysis features. In addition, you’ll master new features and functions such as XLOOKUP, Dynamic Array functions, LET and LAMBDA, and Power Query, while learning how to leverage shortcuts and nuances in Excel.By the end of this book, you’ll have a broader awareness of how to avoid pitfalls in Excel. You’ll be empowered to work more effectively in Excel, having gained a deeper understanding of the frustrating oddities that can arise daily in Excel.
Hage Yaaapa
Express is a minimal and flexible node.js web application framework, providing a robust set of features for building single and multi-page, and hybrid web applications. It provides a thin layer of features fundamental to any web application, without obscuring features that developers know and love in node.js.Express Web Application Development is a comprehensive guide for those looking to learn how to use the Express web framework for web application development.Starting with the initial setup of the Express web framework, Express Web Application Development helps you to understand the fundamentals of the framework. By the end of Express Web Application Development, you will have acquired enough knowledge and skills to create production-ready Express apps. All of this is made possible by the incremental introduction of more advanced topics, starting from the very essentials.On the way to mastering Express for application development, we teach you the more advanced topics such as routes, views, middleware, forms, sessions, cookies and various other aspects of configuring an Express application. Jade; the recommended HTML template engine, and Stylus; the CSS pre-processor for Express, are covered in detail.Last, but definitely not least, Express Web Application Development also covers practices and setups that are required to make Express apps production-ready.