Microsoft Power BI
Advanced analytics in power BI with R and Python: Ingesting, transforming, visualizing by
Data analytics expert and author Ryan Wade shows you how to use R and Python to perform tasks that are extremely hard to do, if not impossible, using native Power BI tools without Power BI Premium capacity.
ISBN: 9781484258293Publication Date: 2020
Data analysis with Microsoft Power BI by
Written by an expert in the field, the book teaches you how to build accurate data models and design, create, and manage visually-rich and robust data analyses and dashboards. The book includes details on R, Python, and Microsoft's proprietary analytics language DAX.
ISBN: 9781260458626Publication Date: 2020
Expert data modeling with Power BI: Get the best out of Power BI by building optimized data models for reporting and business needs by
This book will be your guide to understanding the ins and outs of data modeling and how to create data models using Power BI confidently. You'll learn how to connect data from multiple sources, understand data, define and manage relationships between data, and shape data models.
ISBN: 9781800203174Publication Date: 2021
Learning Microsoft Power BI by
This streamlined intro to Power BI covers all the foundational aspects and features you need to go from "zero to hero" with data and visualizations. You'll learn how to: Import, manipulate, visualize, and investigate data in Power BI Approach solutions for both self-service and enterprise BI Use Power BI in your organization's business intelligence strategy Produce effective reports and dashboards Create environments for sharing reports and managing data access with your team Determine the right solution for using Power BI offerings based on size, security, and computational needs
ISBN: 9781098112837Publication Date: 2022
Microsoft Power BI Cookbook by
Build effective analytical data models, reports, and dashboards using the advanced features of Power BI. Purchase of the print or Kindle book includes a free eBook in the PDF format. Key Features Update your knowledge with new recipes for query optimization, aggregation tables, Power BI API, and paginated reports Work with recipes across diverse Power BI platforms including the Power BI Service and Mobile Applications Implement custom solutions with M and DAX languages through actionable guidance and proven development techniques Book Description The complete everyday reference guide to Power BI, written by an internationally recognized Power BI expert duo, is back with a new and updated edition. Packed with revised practical recipes, Microsoft Power BI Cookbook, Second Edition, helps you navigate Power BI tools and advanced features. It also demonstrates the use of end-to-end solutions that integrate those features to get the most out of Power BI. With the help of the recipes in this book, you'll gain advanced design and development insight, practical tips, and guidance on enhancing existing Power BI projects. The updated recipes will equip you with everything you need to know to implement evergreen frameworks that will stay relevant as Power BI updates. You'll familiarize yourself with Power BI development tools and services by going deep into the data connectivity, transformation, modeling, visualization, and analytical capabilities of Power BI. By the end of this book, you'll make the most of Power BI's functional programming languages of DAX and M and deliver powerful solutions to common business intelligence challenges. What you will learn Cleanse, stage, and integrate your data sources with Power Query (M) Remove data complexities and provide users with intuitive, self-service BI capabilities Build business logic and analysis into your solutions via the DAX programming language and dashboard-ready calculations Implement aggregation tables to accelerate query performance over large data sources Create and integrate paginated reports Understand the differences and implications of DirectQuery, live connections, Import, and Composite model datasets Integrate other Microsoft data tools into your Power BI solution Who this book is for If you're a BI professional who wants to up their knowledge of Power BI and offer more value to their organization, then this book is for you. Those looking for quick solutions to common Power BI problems will also find this book an extremely useful resource. Please be aware that this is not a beginner's guide; you'll need a solid understanding of Power BI and experience working with datasets before you dive in.
ISBN: 9781801813044Publication Date: 2021-09-30
Microsoft Power BI Quick Start Guide by
Bring your data to life with this accessible yet fast-paced introduction to MS Power BI, now in color Purchase of the print or Kindle book includes a free eBook in PDF format Key Features: Learn faster with practical examples of the latest features of Power BI, including navigator buttons, column-level security, visualizing goals, and moreMigrate your existing Excel and data analysis skills to Power BIBuild accurate analytical models, reports, and dashboards, now in color Book Description: Updated with the latest features and improvements in Power BI, this fast-paced yet comprehensive guide will help you master the core concepts of data visualization quickly. You'll learn how to install Power BI, design effective data models, and build basic dashboards and visualizations to help you make better business decisions. This new edition will also help you bridge the gap between MS Excel and Power BI. Throughout this book, you'll learn how to obtain data from a variety of sources and clean it using the Power Query Editor. You'll also start designing data models to navigate and explore relationships within your data and building DAX formulas to make data easier to work with. Visualizing data is a key element of this book, so there's an emphasis on helping you get to grips with data visualization styles and enhanced digital storytelling. As you progress, you'll start building your own dataflows, gain an understanding of the Common Data Model, and automate dataflow refreshes to eradicate data cleaning inefficiency. You'll learn how to administer your organization's Power BI environment so that deployment can be made seamless, data refreshes can run properly, and security can be fully implemented. By the end of this Power BI book, you'll know how to get the most out of Power BI for better business intelligence. What You Will Learn: Connect to data sources using import and DirectQuery optionsUse Power Query Editor for data transformation and data cleansing processes, and write M and R scripts and dataflows to do the same in the cloudDesign effective reports with built-in and custom visuals to optimize user experienceImplement row-level and column-level security in your dashboardsAdminister a Power BI cloud tenant for your organizationUse built-in artificial intelligence capabilities to enhance Power BI data transformation techniquesDeploy your Power BI Desktop files into Power BI Report Server Who this book is for: This book is for aspiring business intelligence and data professionals with a basic understanding of BI concepts, who want to learn Power BI quickly. Complete beginners with no BI background can also get plenty of useful information from this book.
ISBN: 9781804613498Publication Date: 2022-11-25
Self-service AI with Power BI Desktop: Machine learning insights for business by
This book explains how you can enrich the data you have loaded into Power BI Desktop by accessing a suite of Artificial Intelligence (AI) features.
ISBN: 9781484262313Publication Date: 2020
- Power BI data visualization with purpose: Communicating through color, shape, and layout by This video provides you with practices and guidance toward communicating the right message to your audience without clutter and distraction.Publication Date: 2019
- Power BI visuals that impact and persuade by This video explains how to create Power BI visuals that provide a good user experience. The video begins by explaining how the common mindset around data visualization is often wrong, and then it suggests a better approach.Publication Date: 2019
Microsoft Power BI Data Analyst Certification companion: Preparation for exam PL-300 by
The book follows the zSkills Measuredy outline provided by Microsoft to help focus your study. Each topic area from the outline corresponds to an area covered by the exam, and the book helps you build a good base of knowledge in each area. Each topic is presented with a blend of practical explanations, theory, and best practices.
ISBN: 9781484290132Publication Date: 2023- Microsoft Power BI Data Analyst Certification Guide by
From getting started with Power BI to connecting to data sources, including files, databases, cloud services, and SaaS providers, to using Power BI's built-in tools to build data models and produce visualizations, this book will walk you through everything from setup to preparing for the certification exam.
ISBN: 9781803241326Publication Date: 2022
Tableau
Learning Tableau 2022: Create effective data visualizations, build interactive visual analytics, and transform your organization by
Now in color, this edition of Learning Tableau will empower you to bring data to life and make better business decisions Purchase of the print or Kindle book includes a free eBook in PDF format. Key Features: Learn the basics of data analysis, from snappy visualizations to comprehensive dashboardsGain meaningful insights with geospatial analysis, scripting extensions, and other advanced methodsExplore the latest Tableau 2022 features, including Einstein Discovery and Explain Data Book Description: Learning Tableau 2022 helps you get started with Tableau and data visualization, but it does more than just cover the basic principles. It helps you understand how to analyze and communicate data visually, and articulate data stories using advanced features. This new edition is updated with Tableau's latest features, such as dashboard extensions, Explain Data, and integration with CRM Analytics (Einstein Analytics), which will help you harness the full potential of artificial intelligence (AI) and predictive modeling in Tableau. After an exploration of the core principles, this book will teach you how to use table and level of detail calculations to extend and alter default visualizations, build interactive dashboards, and master the art of telling stories with data. You'll learn about visual statistical analytics and create different types of static and animated visualizations and dashboards for rich user experiences. We then move on to interlinking different data sources with Tableau's Data Model capabilities, along with maps and geospatial visualization. You will further use Tableau Prep Builder's ability to efficiently clean and structure data. By the end of this book, you will be proficient in implementing the powerful features of Tableau 2022 to improve the business intelligence insights you can extract from your data. What You Will Learn: Develop stunning visualizations to explain complex data with clarityBuild interactive dashboards to drive actionable user insightsExplore Data Model capabilities and interlink data from various sourcesCreate and use calculations to solve problems and enrich your analyticsEnable smart decision-making with data clustering, distribution, and forecastingExtend Tableau's native functionality with extensions, scripts, and AI through CRM Analytics (formerly Einstein Analytics)Leverage Tableau Prep Builder's amazing capabilities for data cleaning and structuringShare your data stories to build a culture of trust and action Who this book is for: This Tableau book is for aspiring BI developers and data analysts, data scientists, researchers, and anyone else who wants to gain a deeper understanding of data through Tableau. This book starts from the ground up, so you won't need any prior experience with Tableau before you dive in, but a full Tableau license (or 14-day demo license) is essential to be able to make use of all the exercises.
ISBN: 9781801072328Publication Date: 2022-08-26
Tableau for business users: Learn to automate and simplify dashboards for better decision making by
Author Shankar Arul starts by teaching you the fundamentals of data analytics before moving on to the core concepts of Tableau. You will learn how to create calculated fields, and about the currently available calculation functionalities in Tableau, including Basic Expressions, Level of Detail (LOD) Expressions, and Table Calculations. As the book progresses, you'll be walked through comparisons and trend calculations using tables. A concluding chapter on dashboarding will show you how to build actionable dashboards to communicate analysis and visualizations.
ISBN: 9781484277867Publication Date: 2021
Tableau Desktop Pocket Reference by
In a crowded field of data visualization and analytics tools, Tableau Desktop has emerged as the clear leader. This is partly due to its ease of use, but once you dive into Tableau's extensive feature set, you'll understand just how powerful and flexible this software can be for your business or organization. With this handy pocket reference, author Ryan Sleeper (Innovative Tableau) shows you how to translate the vast amounts of data into useful information. Tableau has done an amazing job of making valuable insights accessible to analysts and executives who would otherwise need to rely on IT. This book quickly guides you through Tableau Desktop's learning curve. You'll learn: How to shape data for use with Tableau Desktop How to create the most effective chart types Core concepts including discrete versus continuous Must-know technical features including filters, parameters, and sets Key syntax for creating the most useful analyses How to bring it all together with dashboards And more!
ISBN: 9781492093480Publication Date: 2021-08-03
The Tableau Workshop by
Learn how to bring your data to life with this hands-on guide to visual analytics with Tableau Key Features Master the fundamentals of Tableau Desktop and Tableau Prep Learn how to explore, analyze, and present data to provide business insights Build your experience and confidence with hands-on exercises and activities Book Description Learning Tableau has never been easier, thanks to this practical introduction to storytelling with data. The Tableau Workshop breaks down the analytical process into five steps: data preparation, data exploration, data analysis, interactivity, and distribution of dashboards. Each stage is addressed with a clear walkthrough of the key tools and techniques you'll need, as well as engaging real-world examples, meaningful data, and practical exercises to give you valuable hands-on experience. As you work through the book, you'll learn Tableau step by step, studying how to clean, shape, and combine data, as well as how to choose the most suitable charts for any given scenario. You'll load data from various sources and formats, perform data engineering to create new data that delivers deeper insights, and create interactive dashboards that engage end-users. All concepts are introduced with clear, simple explanations and demonstrated through realistic example scenarios. You'll simulate real-world data science projects with use cases such as traffic violations, urban populations, coffee store sales, and air travel delays. By the end of this Tableau book, you'll have the skills and knowledge to confidently present analytical results and make data-driven decisions. What you will learn Become an effective user of Tableau Prep and Tableau Desktop Load, combine, and process data for analysis and visualization Understand different types of charts and when to use them Perform calculations to engineer new data and unlock hidden insights Add interactivity to your visualizations to make them more engaging Create holistic dashboards that are detailed and user-friendly Who this book is for This book is for anyone who wants to get started on visual analytics with Tableau. If you're new to Tableau, this Workshop will get you up and running. If you already have some experience in Tableau, this book will help fill in any gaps, consolidate your understanding, and give you extra practice of key tools.
ISBN: 9781800207653Publication Date: 2022-04-28
Visual Analytics with Tableau by
A four-color journey through a complete Tableau visualization Tableau is a popular data visualization tool that's easy for individual desktop use as well as enterprise. Used by financial analysts, marketers, statisticians, business and sales leadership, and many other job roles to present data visually for easy understanding, it's no surprise that Tableau is an essential tool in our data-driven economy. Visual Analytics with Tableau is a complete journey in Tableau visualization for a non-technical business user. You can start from zero, connect your first data, and get right into creating and publishing awesome visualizations and insightful dashboards. * Learn the different types of charts you can create * Use aggregation, calculated fields, and parameters * Create insightful maps * Share interactive dashboards Geared toward beginners looking to get their feet wet with Tableau, this book makes it easy and approachable to get started right away.
ISBN: 9781119560203Publication Date: 2019-05-07- Visual data storytelling with Tableau by
Coverage includes:
The visual data storytelling paradigm: moving beyond static charts to powerful visualizations that combine narrative with interactive graphics
How to think like a data scientist, a storyteller, and a designer -- all in the same project
Data storytelling case studies: the good, the bad, and the ugly
Shaping data stories: blending data science, genre, and visual design
Seven best practices for visual data storytelling -- and common pitfalls to avoid
Tricks and hacks you can use with any toolset, not just Tableau
ISBN: 9780134712963Publication Date: 2018
- An introduction to data storytelling with Tableau by Angela Baltes, PhD, Senior Research Analyst, American Public Education, Inc., discusses data storytelling, including the key points for data storytelling and shares an example of data visualization using Tableau.ISBN: 9781529602067Publication Date: 2022
- Data Visualization Using Tableau by This course explains right from the scratch, starting from downloading and installing your own copy of Tableau Desktop to developing, formatting and publishing your dashboard to Tableau Public.Publication Date: 2021
- Learn Tableau by working on exciting dashboards by The course starts with the basics of Tableau and its installation. You will learn about donut charts, KPI cards, placeholders, waterfall charts, lollipop charts, dual axis charts, dynamic arrows, separate legend formatting, how to use custom shapes, visualization in a tooltip, quick table calculations, level of detail expressions, formatting, dashboard actions, how to use dashboard objects effectively, and more. You will have a hands-on approach to creating four different dashboards and views such as the sales analysis dashboard, Netflix analysis dashboard, and investment portfolio dashboard.ISBN: 9781837633814Publication Date: 2023
- Tableau Desktop - A Step-by-Step Guide for Beginners by This video course will teach you how to create effective data visualizations using Tableau with the help of interesting activities. The course begins with an introduction to Tableau, showing you how to connect to a data source in Tableau. You'll then gain a solid understanding of data visualization, before going on to develop a bar chart and a pie chart, create a text table and explore map visualization in Tableau. The course will also help you to find a suitable method for using filters in a Tableau worksheet.ISBN: 9781800563247Publication Date: 2020
Tableau Desktop Certified Associate exam guide by
What you will learn
Apply Tableau best practices to analyze and visualize data
Use Tableau to visualize geographic data using vector maps
Create charts to gain productive insights into data and make quality-driven decisions
Implement advanced analytics techniques to identify and forecast key values
Prepare customized table calculations to compute specific values
Answer questions based on the Tableau Desktop Certified Associate exam with the help of mock tests
ISBN: 9781838986643Publication Date: 2019- Learn Tableau and Ace the Tableau Desktop Certified Associate Exam by Learn Tableau and crack the Tableau Desktop Certified Associate Exam with detailed video tutorials, exam notes PDF, tips and tricks, and a full practice test along with solutions.ISBN: 9781801813235Publication Date: 2021
- Learn Tableau and Ace the Tableau Desktop Specialist Exam by We'll start by familiarizing ourselves with the software and understanding the basic concepts of Tableau. We then move on to exploring and analyzing data. We'll look at the various charts that can be used to present several types of data and we can use Tableau easily to create such visualizations. We'll learn how to effectively present these visualizations using dashboards and stories. Finally, we will go over some exam tricks and tips that will help us prepare for the Tableau Specialist exam.ISBN: 9781801076364Publication Date: 2021
Python
Basic Python for data management, finance, and marketing by
This book is a practical guide to help you get started with Python from ground zero and to the point where you can use coding for everyday tasks. Python, the most in-demand skill by employers, can be learned in a matter of months and a working knowledge will help you to advance your career. This book will teach you to crunch numbers, analyze big-data, and switch from spreadsheets to a faster and more efficient programming language. You'll benefit from the numerous real-life examples designed to meet current world challenges and from step-by-step guidance to become a confident Python user.
ISBN: 9781484271896Publication Date: 2021
Data Visualization with Python and JavaScript by
How do you turn raw, unprocessed, or malformed data into dynamic, interactive web visualizations? In this practical book, author Kyran Dale shows data scientists and analysts--as well as Python and JavaScript developers--how to create the ideal toolchain for the job. By providing engaging examples and stressing hard-earned best practices, this guide teaches you how to leverage the power of best-of-breed Python and JavaScript libraries. Python provides accessible, powerful, and mature libraries for scraping, cleaning, and processing data. And while JavaScript is the best language when it comes to programming web visualizations, its data processing abilities can't compare with Python's. Together, these two languages are a perfect complement for creating a modern web-visualization toolchain. This book gets you started. You'll learn how to: Obtain data you need programmatically, using scraping tools or web APIs: Requests, Scrapy, Beautiful Soup Clean and process data using Python's heavyweight data processing libraries within the NumPy ecosystem: Jupyter notebooks with pandas+Matplotlib+Seaborn Deliver the data to a browser with static files or by using Flask, the lightweight Python server, and a RESTful API Pick up enough web development skills (HTML, CSS, JS) to get your visualized data on the web Use the data you've mined and refined to create web charts and visualizations with Plotly, D3, Leaflet, and other libraries
ISBN: 9781098111878Publication Date: 2023-01-17
Practical Python data visualization: A fast track approach to learning data visualization with Python by
Quickly start programming with Python 3 for data visualization with this step-by-step, detailed guide. This book's programming-friendly approach using libraries such as leather, NumPy, Matplotlib, and Pandas will serve as a template for business and scientific visualizations.
ISBN: 9781484264553Publication Date: 2021
- Data analytics using Python visualizations This course takes a holistic approach to teach visualization techniques. We will be taking real-life business scenarios and raw data to go through detailed Exploratory Data Analysis (EDA) techniques to prepare the raw data to suit the appropriate visualization needs. You will learn about data analytics and exploratory data analysis techniques using multiple different data structures with NumPy and Pandas libraries. You will also learn various chart/graph types, customization/configuration, and vectorization techniques.ISBN: 9781804614839Publication Date: 2022
- Data Understanding and Data Visualization with Python by Learn data manipulation and visualization from scratch Master various Python libraries such as NumPy, Pandas, Matplotlib, and so on Create interactive, insightful visualizationsISBN: 9781801078795Publication Date: 2021
- Fundamentals of statistics and visualization in Python by In this course, we explore several core statistical concepts to utilize data; construct confidence intervals in Python and assess the results; discover correlations; and update your beliefs using Bayesian Inference.Publication Date: 2020
- Import data and analyze with Python Python programming language allows sophisticated data analysis and visualization. This tutorial is a basic step-by-step introduction on how to import a text file (CSV), perform simple data analysis, export the results as a text file, and generate a trend.Publication Date: 2021