Bazy danych
Marco Bonzanini
Your social media is filled with a wealth of hidden data – unlock it with the power of Python. Transform your understanding of your clients and customers when you use Python to solve the problems of understanding consumer behavior and turning raw data into actionable customer insights.This book will help you acquire and analyze data from leading social media sites. It will show you how to employ scientific Python tools to mine popular social websites such as Facebook, Twitter, Quora, and more. Explore the Python libraries used for social media mining, and get the tips, tricks, and insider insight you need to make the most of them. Discover how to develop data mining tools that use a social media API, and how to create your own data analysis projects using Python for clear insight from your social data.
Guang Hui Du, Gordon Du
SAP Business One is an integrated Enterprise Resource Planning (ERP) software which offers an ideal solution for growing small to midsized businesses. For such companies, retrieving the most relevant information from their business data can be key to standing out from the competition. SAP Business One is a rapidly growing software package and this book is timely in giving those businesses an advantage in the area of Business Intelligence. Having SQL query skills in- house is the most important and cost-effective move you can make in this growing field.This practical guide will provide you with the skills to gain more specific business information from SAP Business One by using SQL queries. It will provide you with solutions for solving complicated report related problems, covering basic tools like the Query Generator and Query Wizard. More advanced content like using queries with Crystal Reports will also be delved into.SQL query is one of the advanced tools available in SAP Business One which is easily learned and quickly utilized. By referring back to and applying the many examples in this book, you will be able to create and run correct, and therefore effective, SQL queries to help your business.The book begins by teaching a clear definition of the SQL query, and covers the data dictionary and table links. Coverage will then jump to a higher level of complex SQL queries, discussing features like FMS. Along the way more advanced SQL Query topics will be covered, such as extending the scope of basic SQL queries for more complicated cases. You will ultimately gain in depth query knowledge to bring more Business Intelligence into SAP Business One.
Milo?° Radivojevifá, Dejan Sarka, William Durkin, Christian...
Microsoft SQL Server 2017 uses the power of R and Python for machine learning and containerization-based deployment on Windows and Linux. By learning how to use the features of SQL Server 2017 effectively, you can build scalable apps and easily perform data integration and transformation. You’ll start by brushing up on the features of SQL Server 2017. This Learning Path will then demonstrate how you can use Query Store, columnstore indexes, and In-Memory OLTP in your apps. You'll also learn to integrate Python code in SQL Server and graph database implementations for development and testing. Next, you'll get up to speed with designing and building SQL Server Integration Services (SSIS) data warehouse packages using SQL server data tools. Toward the concluding chapters, you’ll discover how to develop SSIS packages designed to maintain a data warehouse using the data flow and other control flow tasks.By the end of this Learning Path, you'll be equipped with the skills you need to design efficient, high-performance database applications with confidence.This Learning Path includes content from the following Packt books: SQL Server 2017 Developer's Guide by Miloš Radivojevi?, Dejan Sarka, et. al SQL Server 2017 Integration Services Cookbook by Christian Cote, Dejan Sarka, et. al
Marleen Meier, Christina Stathopoulos, David Sigerson
This edition of the bestselling Tableau guide will teach you how to leverage Tableau's newest features and offerings in various paradigms of the BI domain. Updated with fresh topics, including the newest features in Tableau Server, Prep, and Desktop, as well as up-to-date examples, this book will take you from mastering essential Tableau concepts to advance functionalities. A chapter on data governance has also been added.Throughout this book, you'll learn how to use Tableau Hyper files and Prep Builder to easily perform data preparation and handling, as well as complex joins, spatial joins, unions, and data blending tasks using practical examples. You'll also get to grips with executing data densification and explore other expert-level examples to help you with calculations, mapping, and visual design using Tableau extensions.Later chapters will teach you all about improving dashboard performance, connecting to Tableau Server, and understanding data visualization with examples. Finally, you'll cover advanced use cases, such as self-service analysis, time series analysis, geo-spatial analysis, and how to connect Tableau to Python and R to implement programming functionalities within Tableau.By the end of this book, you'll have mastered Tableau 2023 and be able to tackle common and advanced challenges in the BI domain.
Mastering Tableau. Smart Business Intelligence techniques to get maximum insights from your data
Jen Stirrup, David Baldwin
Tableau has emerged as one of the most popular Business Intelligence solutions in recent times, thanks to its powerful and interactive data visualization capabilities. This book will empower you to become a master in Tableau by exploiting the many new features introduced in Tableau 10.0.You will embark on this exciting journey by getting to know the valuable methods of utilizing advanced calculations to solve complex problems. These techniques include creative use of different types of calculations such as row-level, aggregate-level, and more. You will discover how almost any data visualization challenge can be met in Tableau by getting a proper understanding of the tool’s inner workings and creatively exploring possibilities. You’ll be armed with an arsenal of advanced chart types and techniques to enable you to efficiently and engagingly present information to a variety of audiences through the use of clear, efficient, and engaging dashboards. Explanations and examples of efficient and inefficient visualization techniques, well-designed and poorly designed dashboards, and compromise options when Tableau consumers will not embrace data visualization will build on your understanding of Tableau and how to use it efficiently.By the end of the book, you will be equipped with all the information you need to create effective dashboards and data visualization solutions using Tableau.
Hotek Mike
Podwójny zestaw szkoleniowy (Dla czytelników eBook'a obraz dysku CD towarzyszącego książce jest dostępny na stronie wydawcy - dokładny link podano we wstępie eBook'a). Książka pozwala zdobyć umiejętności przydane w pracy i wymagane na egzaminie MCTS 70-432. Stosując własne tempo można przerobić kolejne lekcje, wyczerpujące każdy temat egzaminu. Wzięte z życia scenariusze przykładowe i zadania pomagają utrwalić zdobytą wiedzę i zastosować ją w praktyce. Ten oficjalny podręcznik firmy Microsoft został zaprojektowany z myślą o maksymalnym wykorzystaniu czasu nauki. Zwiększ swoje szanse na egzaminie ucząc się, jak: * konfigurować bazy danych, tworzyć kopie zapasowe i je przywracać, * tworzyć partycjonowane tabele, indeksy i widoki indeksowane, * konfigurować usługi i komponenty zarządzania środowiskiem, * ochronić się przed nieupoważnionym dostępem na każdym poziomie infrastruktury zabezpieczeń, * projektować i wdrażać rozwiązania wysokiej dostępności, * zarządzać zadaniami, alertami i operatorami SQL Server Agent, * identyfikować problemy związane z usługami, wielodostępem i realizacją zadań.
Tomislav Piasevoli, Sherry Li
If you're often faced with MDX challenges, this is a book for you. It will teach you how to solve various real-world businessrequirements using MDX queries and calculations. Examples in the book introduce an idea or a problem and then guide you throughthe process of implementing the solution in a step-by-step manner, inform you about the best practices and offer a deep knowledge in terms of how the solution works. Recipes are organized by chapters, each covering a single topic. They start slowly and logically progress to more advanced techniques. In case of complexity, things are broken down. Instead of one, there are series of recipes built one on top of another. This way you are able to see intermediate results and debug potential errors faster. Finally, the cookbook format is here to help you quickly identify the topic of interest and in it a wide range of practical solutions, that is – MDX recipes for your success.
Microsoft Access 2010 PL. Praktyczne podejście
Curtis D. Frye
Poznaj proste i skuteczne metody pracy w programie Access 2010! Jak szybko stworzyć użyteczną bazę danych? Jak zapisywać w bazach grafikę i różnego rodzaju dokumenty? Jak tworzyć poprawne i atrakcyjne wizualnie raporty? Najnowsza wersja programu Microsoft Access umożliwia budowanie i przetwarzanie baz danych bez potrzeby znajomości języka SQL czy też skomplikowanych środowisk serwerowych. Nowego Accessa można wykorzystywać zarówno w przypadku prostych projektów, takich jak baza adresowa, jak i bardziej złożonych, na przykład z zewnętrznym źródłem danych. Ponadto program w wielu wypadkach umożliwia uzyskanie tego samego efektu różnymi metodami. Każdy użytkownik może więc znaleźć najlepsze dla siebie sposoby. W tym podręczniku znajdziesz nie tylko proste i skuteczne metody pracy z Accessem, ale także mnóstwo inspiracji do samodzielnego eksplorowania programu. Książka "Microsoft Access 2010 PL. Praktyczne podejście", Microsoft Access 2010 Plain & Simple" zawiera przejrzysty i klarowny opis wszystkich niezbędnych procedur i narzędzi programu, ilustrowany zrzutami ekranowymi. Korzystając z tego podręcznika, nauczysz się używać formularzy Accessa do sprawnego zbierania informacji, a także projektować i budować bazy danych oraz wymieniać dane pomiędzy nimi i programami zewnętrznymi. Dowiesz się, jak stosować grafikę i inne elementy, aby tworzyć wyszukane barwne raporty. Poznasz również inne zaawansowane zagadnienia, takie jak administrowanie bazą w sposób umożliwiający oddzielanie danych dostępnych dla każdego użytkownika od danych poufnych. Narzędzia programu Access 2010 Tworzenie bazy danych Praca z polami i tabelami Formularze i kwerendy Tworzenie raportów Formatowanie elementów wykresu Interakcje z innymi programami Administrowanie bazą danych Personalizacja programu i konfigurowanie interfejsu Dynamiczna prezentacja danych i kwerend Najprostszy barwny przewodnik po świecie Accessa do stosowania na bieżąco!