Live Webinar: The Power of Data Storytelling in Driving Business Decisions (September 10, 2024 at 9 AM CST)

Data doesn’t have to be overwhelming. Join our webinar to learn about Data Storytelling and turn complex information into actionable insights for faster decision-making.

Click below to check the schedule in your time zone and secure your spot. Can't make it? Register to get the recording instead.

Sponsored

🦋 Welcome to BIPro #74—Your Weekly Data Power-Up! 🚀

We’re switching our schedule to Tuesdays to keep you ahead of the curve right at the start of your week! Dive into the latest BI trends, cutting-edge strategies, and essential reads to supercharge your data game.

📖 Must-Reads This Week:

✦ Data Literacy with Python by Oswald Campesato

✦ Data Analysis for Business Decisions: A Laboratory Manual by Andres Fortino

✦ Generative AI with Amazon Bedrock by Shikhar Kwatra & Bunny Kaushik

✦ Database Design and Modeling with PostgreSQL and MySQL by Alkin Tezuysal & Mr. Ibrar Ahmed

✦ Unleashing the Power of Data with Trusted AI by Wendy Turner-Williams

📊Trends Shaping Data Insights:

✦ API for GraphQL in Microsoft Fabric

✦ Containers for Seamless SQL Server Deployment

✦ NumPy in Linear Algebra Applications

✦ Next-Gen Digital Analytics with Snowplow and Snowflake

✦ New Storage Integration in Snowflake Connector

🔄 Real-World Transformations:

✦ Enhanced AI/BI Dashboards with Databricks

✦ The Future of Data Lakehouses in Analytics & ML

✦ Forecasting Service Utilization with Tabnet & Optuna

✦ Designing Real-Time Streaming Platforms with Azure

✦ Real-Time Financial Data Feeds with Amazon MSK & Flink

⚡ Quick Wins for Instant Impact:

✦ Let Tableau Write Your SQL

✦ The Power of Predictive Analytics & BI

✦ AtScale’s New Natural Language Query Capabilities

✦ AI Chat Exploration in Domo with Amazon Bedrock

✦ Customer Management Insights with PwC’s Engine on AWS

🎤 Expert Voices:

✦ Scaling Numerical Data: A Visual Guide by Samy Baladram

✦ Implementing Graph RAG with Knowledge Graphs by Steve Hedden

✦ 5 Pillars for a Hyper-Optimized AI Workflow by Gilad Rubin

✦ Azure Managed Instance for SQL Server Backup & Restore

Let’s level up your BI game this week!

Calling All Data & BI Enthusiasts!

Do you dream of sharing your insights and building your reputation in the Data & BI community? Contribute to our new column in the Packt BIPro newsletter! Share your experiences, discuss new BI tools, or ask questions. Gain recognition among 37,000 BI professionals. Reply with your Google Docs article or use our weekly feedback form. Enjoy a free PDF of "Interactive Data Visualization with Python - Second Edition" for participating. Click reply or share your content today!

Cheers,

Merlyn Shelley

Editor-in-Chief, Packt

Sign Up|Advertise|Archives

We’re thrilled to bring you this week’s must-have new releases, straight from the experts to your bookshelf! Whether you're eager to enhance your skills or explore new horizons, now is the perfect moment to add these invaluable resources to your collection.

For a limited time,enjoy 30% off all eBooks at Packtpub.com. These books are thoughtfully crafted by industry insiders with hands-on experience, offering unique insights you won’t find anywhere else.

Don’t let these Packt-exclusive deals slip away—seize the opportunity to learn from the best at an unbeatable price!

Data Literacy with Python: A Comprehensive Guide to Understanding and Analyzing Data with Python

By Mercury Learning and Information, Oswald Campesato

Unlock the world of data with this engaging new book designed to make learning data analysis, statistics, and visualization easier than ever. Here’s what you’ll discover:

➤ Clear, step-by-step explanations for key concepts

➤ Practical, hands-on Python examples to bring data to life

➤ Easy-to-follow progression from data basics to advanced model training

➤ Powerful tools like Matplotlib and Seaborn for stunning visualizations

➤ Real-world datasets and code to practice along the way

This book is your guide to making sense of data, from cleaning and analyzing to visualizing and making data-driven decisions—all with Python! Get the eBook for $34.98 (originally $49.99) —master data analysis today!

Data Analysis for Business Decisions: A Laboratory Manual

By Mercury Learning and Information, Andres Fortino

Step into the world of business analytics with this hands-on guide, designed to boost your statistical skills using Excel. Here's what you'll learn:

➤ Practical case studies for real-world applications

➤ How to clean, shape, and analyze data in Excel

➤ Use Excel's Analysis ToolPak for powerful statistical insights

➤ Master regression, forecasting, and A/B testing for better business decisions

This book takes you from basics to advanced techniques, helping you make data-driven decisions with ease! Get the eBook now for $34.98 (originally $49.99) and boost your analytics skills!

Generative AI with Amazon Bedrock: Build, scale, and secure generative AI applications using Amazon Bedrock

By Shikhar Kwatra, Bunny Kaushik

Discover the power of generative AI with this hands-on guide to Amazon Bedrock. Designed for practical application, you'll learn how to tackle real-world business challenges. Key highlights include:

➤ Expert foundations of Amazon Bedrock from AWS specialists

➤ Techniques for building and scaling AI applications

➤ Advanced tips for prompt engineering and secure frameworks

➤ Real-world cases, from text generation to virtual assistants

➤ Best practices for security, monitoring, and ethical AI

Master AI and drive innovation with confidence! Get the eBook now for just $24.99 (originally $35.99) and start mastering AI with Amazon Bedrock today!

Database Design and Modeling with PostgreSQL and MySQL: Build efficient and scalable databases for modern applications using open source databases

By Alkin Tezuysal, Mr. Ibrar Ahmed

Dive into the world of database design and modeling with this practical guide to PostgreSQL and MySQL. Whether you're a beginner or looking to enhance your skills, here's what you'll learn:

➤ Master database design, from fundamentals to advanced concepts

➤ Hands-on exercises for real-world application

➤ Seamless integration with web apps and emerging database trends

➤ Tips on optimizing, scaling, and managing databases effectively

Get ready to build modern, scalable databases with confidence! Get the eBook now for just $21.99 (originally $31.99) and start mastering PostgreSQL and MySQL database design today!

Unleashing the Power of Data with Trusted AI: A guide for board members and executives

By Wendy Turner-Williams

Feeling overwhelmed by AI and data integration? This book, by a top digital transformation expert, simplifies it all.

What you’ll gain:

➤ Quick Decisions: Get actionable insights for faster, accurate choices.

➤ AI Integration: Easily incorporate AI into your workflows.

➤ Real-World Success: Learn from giants like Starbucks and Netflix.

Why this book stands out:

➤ Ethics and Compliance: Navigate AI’s ethical and regulatory challenges.

➤ Boost Data Skills: Improve data quality and literacy.

➤ Effective Strategies: Develop AI strategies that work.

➤ Real-World Examples: See AI’s impact across industries.

➤ Smarter Decisions: Use AI-driven insights for better decision-making.

🚀 Boost Your AI Skills! Grab your eBook, "Unleashing the Power of Data with Trusted AI", for just $79.99. Get insights and success stories to transform your AI strategies. Buy now!

➽ API for GraphQL in Microsoft Fabric: The blog explains how to share data from a Fabric warehouse using a GraphQL API. It details the benefits of GraphQL over REST APIs, including precise data extraction and efficient querying, and provides a guide to setting up the GraphQL API in Microsoft Fabric.

➽ Using Containers to Avoid Installing SQL Server: This article details how to quickly set up SQL Server using Docker containers instead of a traditional installation. It covers installing Docker Desktop, configuring data directories, creating a `docker-compose` file, and testing the setup.

➽ NumPy for Linear Algebra Applications: This article explores NumPy's capabilities for linear algebra, covering functions for matrix operations, such as multiplication, inversion, and decomposition. It provides practical examples for each function, showcasing their use in solving equations and data analysis.

➽ Unlocking The Next-Gen Digital Analytics Solution, Powered by Snowplow and Snowflake on AWS: This post introduces the Next-Gen Digital Analytics solution on AWS, integrating Snowplow and Snowflake to enhance customer data analysis. It improves data quality, governance, and real-time insights, supporting AI adoption for better user engagement and business outcomes.

➽ Announcing New Storage Integration Support in Snowflake Connector for Fabric Data Factory: Fabric Data Factory now supports Snowflake storage integration, enhancing data pipeline security by enabling secure connections with external storage providers. This feature simplifies data management, improves security, and offers fine-grained control over data flows.

➽ Next-Level Interactivity in AI/BI Dashboards withDatabricks: Databricks AI/BI Dashboards, unveiled at the Data and AI Summit, now feature enhanced interactivity with cross-filtering, static widget parameters, and improved performance. These updates enable dynamic data exploration, secure access, and faster analytics with minimal manual configuration.

➽ Data Lakehouses: Shaping The Future Of Analytics And Machine Learning. The article highlights the data lakehouse architecture as a transformative approach in analytics and machine learning. Combining features of data lakes and warehouses, it offers scalable, cost-effective data management and advanced analytics capabilities, while addressing challenges of both systems.

➽ Real world Use Cases: Forecasting Service Utilization Using Tabnet and Optuna ~by Hampus Gustavsson. The article explains using TabNet and Optuna for forecasting service utilization. It covers practical implementation of TabNet for predictive modeling, with Optuna optimizing hyperparameters. The focus is on real-world application and enhancing forecasting accuracy through these tools.

➽ How to Design a Real-Time Streaming Platform with Azure? This blog explores designing a real-time data streaming platform using Microsoft Azure tools. It details how to utilize Azure Event Hub for data ingestion and Azure Stream Analytics for processing, aimed at creating a near real-time financial data pipeline and visualizations.

➽ Publish and enrich real-time financial data feeds using Amazon MSK and Amazon Managed Service for Apache Flink: This article describes setting up a real-time financial data feed on AWS using Amazon MSK and Apache Flink. It explains how to enrich stock quotes with additional indicators, and deliver the data to customers via secure, low-latency streaming.

➽ Let Tableau Write Your SQL for You: This blog discusses the benefits of using Tableau’s dynamic SQL and relationships instead of custom SQL and joins. It highlights how relationships simplify data modeling by avoiding data explosion and improving performance, making dashboards more efficient and responsive.

➽ Predictive Analytics and Business Intelligence: A Powerful Duo! This article explores the synergy between predictive analytics and business intelligence (BI). It emphasizes how BI provides historical insights while predictive analytics forecasts future trends, and how combining these tools can enhance forecasting, customer insights, operations, and risk management.

➽ AtScale Launches New Natural Language Query Capabilities with Semantic Layer Integration: AtScale is introducing a private preview of its Natural Language Query (NQL) feature, allowing users to access data insights by asking questions in plain English. This advancement, combining Generative AI with AtScale’s Semantic Layer, simplifies data queries and improves decision-making accuracy.

➽ Exploring data using AI chat at Domo with Amazon Bedrock: Domo is enhancing data insights with generative AI via its Domo.AI platform, powered by Amazon Bedrock. This allows users to query data using natural language, simplifying data analysis and visualization, and improving accessibility while addressing challenges like data quality and integration.

➽ Data-Driven Customer Management Across Data Silos, Powered by PwC’s Customer Insights Engine on AWS: PwC Australia's Customer Insights Engine (CIE) on AWS provides a unified 360-degree view of customers by aggregating data from multiple sources. It uses machine learning and pre-built analytics to deliver personalized insights and enhance customer experiences efficiently.

➽ Scaling Numerical Data, Explained: A Visual Guide with Code Examples for Beginners ~ by Samy Baladram: This article explains data scaling in machine learning, comparing it to making large numbers more manageable for models. It covers various scaling techniques like normalization and Box-Cox transformation, demonstrating their impact on creating balanced, effective machine learning models.

➽ How to Implement Graph RAG Using Knowledge Graphs and Vector Databases ~ by Steve Hedden: This article explores integrating knowledge graphs (KGs) with large language models (LLMs) using Retrieval-Augmented Generation (RAG). It highlights various methods like vector-based retrieval, prompt-to-query, and hybrid approaches, emphasizing how combining these techniques improves data retrieval and enhances LLM responses.

➽ 5 Pillars for a Hyper-Optimized AI Workflow ~ by Gilad Rubin: This article explores the author's journey to find an elegant approach for structuring and developing AI & ML projects. It introduces five key pillars for creating a hyper-optimized AI workflow, focusing on metrics optimization, interactive development, production readiness, and modular code.

➽ Azure Managed Instance Download and Restore SQL Server Backup: This article explains how Azure SQL Managed Instance (MI) supports both automated and manual backups. While Azure MI provides automatic backups, it also allows manual backups to Azure Blob Storage. It outlines the process for setting up these manual backups.

Stay tuned for more—until next time!

Copyright (C) 2024 Packt Publishing. All rights reserved.

Our mailing address is:
Packt Publishing Grosvenor House 11 St Paul's Square Birmingham, West Midlands B3 1RB United Kingdom

Want to change how you receive these emails?
You canupdate your preferencesorunsubscribe